SQLite format 3 @ t8 À t8 .Y ñ Pûöñ" P éÐßlÿOáÍæBÑc ïa r1!indexGI_PARENT_ID_INDEXGROUP_ITEMCREATE INDEX GI_PARENT_ID_INDEX ON GROUP_ITEM (PARENT_ID)l-!indexGI_USER_ID_INDEXGROUP_ITEMCREATE INDEX GI_USER_ID_INDEX ON GROUP_ITEM (USER_ID)o/!indexGI_GROUP_ID_INDEXGROUP_ITEMCREATE INDEX GI_GROUP_ID_INDEX ON GROUP_ITEM (GROUP_ID)!! [tableGROUP_ITEMGROUP_ITEMCREATE TABLE GROUP_ITEM (ID INTEGER PRIMARY KEY AUTOINCREMENT, PARENT_ID INTEGER, GROUP_ID INTEGER, USER_ID INTEGER, TITLE VARCHAR(512), DESCRIPTION VARCHAR(8192), PUBDATE NUMERIC(11), EDIT_DATE NUMERIC(11), UPS INTEGER DEFAULT 0, DOWNS INTEGER DEFAULT 0, TYPE INTEGER DEFAULT 0){tableFEED_ITEMFEED_ITEMCREATE TABLE FEED_ITEM (GUID CHAR(11) PRIMARY KEY, TITLE VARCHAR(512), LINK VARCHAR(512), IMAGE_LINK VARCHAR(512), DESCRIPTION VARCHAR(8192), PUBDATE INTEGER, SOURCE_NAME VARCHAR(64))1E indexsqlite_autoindex_FEED_ITEM_1FEED_ITEM//3tableCURRENT_WEB_INDEXCURRENT_WEB_INDEXCREATE TABLE CURRENT_WEB_INDEX (CRAWL_TIME NUMERIC(11) PRIMARY KEY)AU/ indexsqlite_autoindex_CURRENT_WEB_INDEX_1CURRENT_WEB_INDEXl''indexCL_USER_INDEXCREDIT_LEDGERCREATE INDEX CL_USER_INDEX ON CREDIT_LEDGER (USER_ID)-''tableCREDIT_LEDGERCREDIT_LEDGERCREATE TABLE CREDIT_LEDGER (USER_ID INTEGER, AMOUNT INTEGER, TYPE VARCHAR(32), BALANCE INTEGER, TIMESTAMP NUMERIC(11))k+#indexCM_PARENT_INDEXCRAWL_MIXESCREATE INDEX CM_PARENT_INDEX ON CRAWL_MIXES (PARENT)q/#indexCM_OWNER_ID_INDEXCRAWL_MIXESCREATE INDEX CM_OWNER_ID_INDEX ON CRAWL_MIXES (OWNER_ID)7 ##5tableCRAWL_MIXESCRAWL_MIXES CREATE TABLE CRAWL_MIXES (TIMESTAMP NUMERIC(11) PRIMARY KEY, NAME VARCHAR(32), OWNER_ID INTEGER, PARENT NUMERIC(11))5I# indexsqlite_autoindex_CRAWL_MIXES_1CRAWL_MIXES}-- -tableCHAT_BOT_PATTERNCHAT_BOT_PATTERNCREATE TABLE CHAT_BOT_PATTERN( PATTERN_ID INTEGER PRIMARY KEY AUTOINCREMENT, USER_ID INTEGER, REQUEST VARCHAR(2000), TRIGGER_STATE VARCHAR(32), REMOTE_MESSAGE VARCHAR(2000), RESULT_STATE VARCHAR(32), RESPONSE VARCHAR(2000)) tableCHAT_BOTCHAT_BOT CREATE TABLE CHAT_BOT( USER_ID INTEGER PRIMARY KEY, BOT_TOKEN CHAR(11) UNIQUE, CALLBACK_URL VARCHAR(512))/C indexsqlite_autoindex_CHAT_BOT_1CHAT_BOT y GindexACTIVITY_TRANSLATION_ID_INDEXACTIVITY CREATE INDEX ACTIVITY_TRANSLATION_ID_INDEX ON ACTIVITY (TRANSLATION_ID)39tableACTIVITYACTIVITYCREATE TABLE ACTIVITY (ACTIVITY_ID INTEGER PRIMARY KEY AUTOINCREMENT, TRANSLATION_ID INTEGER, METHOD_NAME VARCHAR(64))}9-!indexAAD_KEYWORD_DATE_INDEXACCEPTED_AD_BIDSCREATE INDEX AAD_KEYWORD_DATE_INDEX ON ACCEPTED_AD_BIDS(KEYWORD, BID_DATE))--tableACCEPTED_AD_BIDSACCEPTED_AD_BIDSCREATE TABLE ACCEPTED_AD_BIDS (AD_ID INTEGER, KEYWORD VARCHAR(60), BID_AMOUNT INTEGER, BID_DATE VARCHAR(20))6''+tableADVERTISEMENTADVERTISEMENTCREATE TABLE ADVERTISEMENT (ID INTEGER PRIMARY KEY AUTOINCREMENT, USER_ID INTEGER, NAME VARCHAR(25), DESCRIPTION VARCHAR(35), DESTINATION VARCHAR(60), KEYWORDS VARCHAR(60), STATUS INTEGER, BUDGET INTEGER, CLICKS INTEGER, IMPRESSIONS INTEGER, START_DATE VARCHAR(20), END_DATE VARCHAR(20))u))%tableACTIVE_PROCESSACTIVE_PROCESSCREATE TABLE ACTIVE_PROCESS (NAME VARCHAR(32), ID INTEGER, TYPE VARCHAR(32))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_seq 4? * © ³ ² ¾ À p « ¼ r ~ ½ ° ± o w v u © z t m ¯ } º ¡ n y m · ´ ª ¬ s k j µ | l x f e d c { q g h { ¿ ¸ ¶ ® ¹ » q ® ¯ p o j · £ ¤ ¥ ¦ § ¨ © i z } t º ¡ m n y ´ ¬ ª | s l j l x · · j l x j · 9 9 8 P 6 5 3 2 3 2 6 5 9 8 7 ; : = <