SQLite format 3@ +J Ä:ûâìçÝØÎöñÓÉÄ9<86++43&#  0- ïtestG‘»M ó test ãtest1G‘»L ððadminsite [[^‡U‚ƒctablestarstarCREATE TABLE star ( user_id INT(11) NOT NULL DEFAULT '0', object_type VARCHAR(12) NOT NULL DEFAULT '', object_id INT(11) NOT NULL DEFAULT '0', time INT(10) NOT NULL DEFAULT '0', PRIMARY KEY (user_id, object_id, object_type) )';indexsqlite_autoindex_star_1starƒK†}tablehithitCREATE TABLE hit ( hit_id INTEGER PRIMARY KEY NOT NULL, object_type VARCHAR(12) NOT NULL, object_id INT(11) NOT NULL DEFAULT '0', hit_new INT(11) NOT NULL DEFAULT '0', hit_today INT(11) NOT NULL DEFAULT '0', hit_yesterday INT(11) NOT NULL DEFAULT '0', hit_weekly INT(11) NOT NULL DEFAULT '0', hit_monthly INT(11) NOT NULL DEFAULT '0', hit_all INT(11) NOT NULL DEFAULT '0', last_update_time INT(11) NOT NULL DEFAULT '0' )(‚tableuser_roleuser_roleCREATE TABLE user_role ( user_id INT(11) NOT NULL DEFAULT '0', role ENUM(9) DEFAULT 'user', field VARCHAR(32) NOT NULL DEFAULT '' )  «^^Myy¶ƒl‡7tableforumforumCREATE TABLE forum ( forum_id INTEGER PRIMARY KEY NOT NULL, forum_code VARCHAR(25) NOT NULL, name VARCHAR(100) NOT NULL, description VARCHAR(255) NOT NULL, forum_type VARCHAR(16) NOT NULL, policy ENUM(9) NOT NULL DEFAULT 'public', total_members INT(8) NOT NULL DEFAULT '0', total_topics INT(11) NOT NULL DEFAULT '0', total_replies INT(11) NOT NULL DEFAULT '0', status ENUM(7) NOT NULL DEFAULT 'healthy', last_post_id INT(11) NOT NULL DEFAULT '0' )\-indexforum_code_forumforum CREATE UNIQUE INDEX forum_code_forum on forum (forum_code)U¶=J    ÁcÁI!C)3testuser|J? 7ba?? =?d?Test User2NAfayland.dreamhost@gmail.comGdòÀ222.137.49.2372008-01-05 13:52:03127.0.0.1 verified encnI#/)3+fayland!K??yD?1?aé½™Fayland LamMfayland@gmail.comGWà[222.137.49.2052008-01-12 09:21:20169.254.110.185verified encn ttö¿úÍÍS‚ …atablepollpollCREATE TABLE poll ( poll_id INTEGER PRIMARY KEY NOT NULL, forum_id INT(11) NOT NULL DEFAULT '0', author_id INT(11) NOT NULL DEFAULT '0', multi ENUM(1) NOT NULL DEFAULT '0', anonymous ENUM(1) NOT NULL DEFAULT '0', time INT(10), duration INT(10), vote_no MEDIUMINT(8) NOT NULL DEFAULT '0', title VARCHAR(128), hit INT(11) NOT NULL DEFAULT '0' )F ''‚Ktableuser_settingsuser_settingsCREATE TABLE user_settings ( user_id INT(11) NOT NULL DEFAULT '0', type VARCHAR(48) NOT NULL, value VARCHAR(48) NOT NULL, PRIMARY KEY (user_id, type) )9M'indexsqlite_autoindex_user_settings_1user_settingsP‚otablevariablesvariablesCREATE TABLE variables ( type ENUM(6) NOT NULL DEFAULT 'global', name VARCHAR(32) NOT NULL DEFAULT '', value VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (type, name) )1Eindexsqlite_autoindex_variables_1variables    ÁÁù„5,ˆAtablecommentcomment*CREATE TABLE comment ( comment_id INTEGER PRIMARY KEY NOT NULL, reply_to INT(11) NOT NULL DEFAULT '0', text TEXT NOT NULL, post_on INT(11) NOT NULL DEFAULT '0', update_on INT(11) DEFAULT '0', post_ip VARCHAR(32) NOT NULL DEFAULT '', formatter VARCHAR(16) NOT NULL DEFAULT 'ubb', object_type VARCHAR(30) NOT NULL, object_id INT(11) NOT NULL DEFAULT '0', author_id INT(11) NOT NULL DEFAULT '0', title VARCHAR(255) NOT NULL DEFAULT '', forum_id INT(11) NOT NULL DEFAULT '0', upload_id INT(11) NOT NULL DEFAULT '0' )‚-!!ƒStablelog_actionlog_action2CREATE TABLE log_action ( user_id INT(11) NOT NULL DEFAULT '0', action VARCHAR(24), object_type VARCHAR(12), object_id INT(11), time INT(11) NOT NULL DEFAULT '0', text TEXT, forum_id INT(11) NOT NULL DEFAULT '0' ) çç/show_email_publicN èè/show_email_public    ÅÅÏÕ‚V11„Wtableuser_profile_photouser_profile_photoCREATE TABLE user_profile_photo ( user_id INTEGER PRIMARY KEY NOT NULL DEFAULT '0', type ENUM(6) NOT NULL DEFAULT 'upload', value VARCHAR(255) NOT NULL DEFAULT '0', width SMALLINT(6) NOT NULL DEFAULT '0', height SMALLINT(6) NOT NULL DEFAULT '0', time INT(11) NOT NULL DEFAULT '0' ).‚+tablebanned_ipbanned_ipCREATE TABLE banned_ip ( ip_id INTEGER PRIMARY KEY NOT NULL, cidr_ip VARCHAR(20) NOT NULL DEFAULT '', time INT(11) NOT NULL DEFAULT '0' )‚ƒetableshareshareCREATE TABLE share ( user_id INT(11) NOT NULL DEFAULT '0', object_type VARCHAR(12) NOT NULL DEFAULT '', object_id INT(11) NOT NULL DEFAULT '0', time INT(10) NOT NULL DEFAULT '0', PRIMARY KEY (user_id, object_id, object_type) ))=indexsqlite_autoindex_share_1share ÐР `)192.168.1.0/24G‘—öH)192.168.1.0/24G‘—ã0)192.168.1.0/24H7í.)192.168.0.0/24H7í.    ggq3p*‚%%ƒQtableuser_detailsuser_detailsCREATE TABLE user_details ( user_id INTEGER PRIMARY KEY NOT NULL DEFAULT '0', qq VARCHAR(14), msn VARCHAR(64), yahoo VARCHAR(64), skype VARCHAR(64), gtalk VARCHAR(64), homepage VARCHAR(255), birthday DATE(10) )?))‚9tablemessage_unreadmessage_unread CREATE TABLE message_unread ( message_id INT(11) NOT NULL DEFAULT '0', user_id INT(11) NOT NULL DEFAULT '0', PRIMARY KEY (message_id, user_id) );O)indexsqlite_autoindex_message_unread_1message_unread!7++‚%tableuser_activationuser_activation"CREATE TABLE user_activation ( user_id INTEGER PRIMARY KEY NOT NULL DEFAULT '0', activation_code VARCHAR(12), new_email VARCHAR(255) )S##‚mtablepoll_resultpoll_result#CREATE TABLE poll_result ( option_id INT(11) NOT NULL DEFAULT '0', poll_id INT(11) NOT NULL DEFAULT '0', poster_id INT(11) NOT NULL DEFAULT '0', poster_ip VARCHAR(32) ) 11nnã‚:/„Gtablelog_pathlog_path,CREATE TABLE log_path ( path_id INTEGER PRIMARY KEY NOT NULL, session_id VARCHAR(72), user_id INT(11) NOT NULL DEFAULT '0', path VARCHAR(255) NOT NULL DEFAULT '', get VARCHAR(255), post TEXT, time INT(11) NOT NULL DEFAULT '0', loadtime DOUBLE(64) NOT NULL DEFAULT '0' )ƒ0…utablemessagemessageCREATE TABLE message ( message_id INTEGER PRIMARY KEY NOT NULL, from_id INT(11) NOT NULL DEFAULT '0', to_id INT(11) NOT NULL DEFAULT '0', title VARCHAR(255) NOT NULL, text TEXT NOT NULL, post_on INT(11) NOT NULL DEFAULT '0', post_ip VARCHAR(32) NOT NULL DEFAULT '', from_status ENUM(7) NOT NULL DEFAULT 'open', to_status ENUM(7) NOT NULL DEFAULT 'open' )         UU[†6m+‚ƒetablevisitvisit$CREATE TABLE visit ( user_id INT(11) NOT NULL DEFAULT '0', object_type VARCHAR(12) NOT NULL DEFAULT '', object_id INT(11) NOT NULL DEFAULT '0', time INT(10) NOT NULL DEFAULT '0', PRIMARY KEY (user_id, object_type, object_id) ))=indexsqlite_autoindex_visit_1visit%-##‚!tablefilter_wordfilter_word'CREATE TABLE filter_word ( word VARCHAR(64) NOT NULL, type ENUM(19) NOT NULL DEFAULT 'username_reserved', PRIMARY KEY (word, type) )5I#indexsqlite_autoindex_filter_word_1filter_word(; ‚Ytablestatstat)CREATE TABLE stat ( stat_id INTEGER PRIMARY KEY NOT NULL, stat_key VARCHAR(255) NOT NULL, stat_value BIGINT(21) NOT NULL DEFAULT '0', date DATE(10) NOT NULL )R###‚ktablepoll_optionpoll_option-CREATE TABLE poll_option ( option_id INTEGER PRIMARY KEY NOT NULL, poll_id INT(11) NOT NULL DEFAULT '0', text VARCHAR(255), vote_no MEDIUMINT(8) NOT NULL DEFAULT '0' ) ¹¹¹G)assholeoffensive_word-fuckbad_word/systemusername_reserved ¶ÑãJassholeoffensive_word/fuckbad_wordsystemusername_reserved   ÅŸËË?p)ƒ;tableuploadupload5CREATE TABLE upload ( upload_id INTEGER PRIMARY KEY NOT NULL, user_id INT(11) NOT NULL DEFAULT '0', forum_id INT(11) NOT NULL DEFAULT '0', filename VARCHAR(36), filesize DOUBLE(64), filetype VARCHAR(4) )‚*!!ƒktableuser_forumuser_forum6CREATE TABLE `user_forum` ( `user_id` int(11) NOT NULL DEFAULT '0', `forum_id` int(11) NOT NULL DEFAULT '0', `status` ENUM( 9 ) NOT NULL DEFAULT 'user', `time` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`user_id`,`forum_id`) )3+G!indexsqlite_autoindex_user_forum_1user_forum7         íí†3Œtableuseruser CREATE TABLE user ( user_id INTEGER PRIMARY KEY NOT NULL, username VARCHAR(32) NOT NULL, password VARCHAR(32) NOT NULL DEFAULT '000000', nickname VARCHAR(100) NOT NULL, gender ENUM(2) NOT NULL DEFAULT 'NA', email VARCHAR(255) NOT NULL, register_time INT(11) NOT NULL DEFAULT '0', register_ip VARCHAR(32) NOT NULL, last_login_on INT(11) NOT NULL DEFAULT '0', last_login_ip VARCHAR(32), login_times MEDIUMINT(8) NOT NULL DEFAULT '1', status ENUM(10) NOT NULL DEFAULT 'unverified', threads INT(11) NOT NULL DEFAULT '0', replies INT(11) NOT NULL DEFAULT '0', lang CHAR(2) DEFAULT 'cn', country CHAR(2) DEFAULT 'cn', state_id INT(11) NOT NULL DEFAULT '0', city_id INT(11) NOT NULL DEFAULT '0' , "point" INT(8) NOT NULL DEFAULT '0')    FF„G4ˆmtabletopictopicCREATE TABLE topic ( topic_id INTEGER PRIMARY KEY NOT NULL, forum_id int(11) NOT NULL DEFAULT '0', title varchar(255) DEFAULT NULL, post_on int(11) NOT NULL DEFAULT '0', closed enum(1) NOT NULL DEFAULT '0', sticky enum(1) NOT NULL DEFAULT '0', elite enum(1) NOT NULL DEFAULT '0', hit int(11) NOT NULL DEFAULT '0', last_updator_id int(11) NOT NULL DEFAULT '0', author_id int(11) NOT NULL DEFAULT '0', total_replies int(11) NOT NULL DEFAULT '0', status enum(7) NOT NULL DEFAULT 'healthy', last_update_date int(11) NOT NULL DEFAULT '0' )‚m6++…tablescheduled_emailscheduled_email3CREATE TABLE `scheduled_email` (`email_id` INTEGER PRIMARY KEY NOT NULL ,`email_type` varchar(24) DEFAULT NULL ,`processed` enum(1) NOT NULL DEFAULT 'N' ,`from_email` varchar(128) DEFAULT NULL ,`to_email` varchar(128) DEFAULT NULL ,`subject` text,`plain_body` text,`html_body` text,`time` int(11) NOT NULL DEFAULT '0' ) óó¼:‚tablesessionsession0CREATE TABLE `session` (`id` CHAR(72) PRIMARY KEY NOT NULL DEFAULT '' ,`session_data` TEXT,`expires` INT(11) DEFAULT '0' )-;Aindexsqlite_autoindex_session_1session.‚A<##„Itableuser_onlineuser_onlineCREATE TABLE user_online ( sessionid varchar(72) NOT NULL DEFAULT '0', user_id int(11) NOT NULL DEFAULT '0', path varchar(255) NOT NULL, title varchar(255) NOT NULL, start_time int(11) NOT NULL DEFAULT '0', last_time int(11) NOT NULL DEFAULT '0', PRIMARY KEY (sessionid) ) ^3R!R3‚A''ƒwtablesecurity_codesecurity_code1CREATE TABLE security_code ( security_code_id INTEGER PRIMARY KEY NOT NULL, user_id int(11) NOT NULL DEFAULT '0', type tinyint(1) NOT NULL DEFAULT '0', code varchar(12) NOT NULL, time int(11) NOT NULL DEFAULT '0' , "note" varchar(255))F@‚[tablelog_errorlog_errorCREATE TABLE "log_error" ("error_id" INTEGER PRIMARY KEY NOT NULL ,"text" TEXT NOT NULL ,"time" INT(11) NOT NULL DEFAULT '0' , "level" INTEGER NOT NULL DEFAULT '1')5=I#indexsqlite_autoindex_user_online_1user_online/L>))‚Stableforum_settingsforum_settings CREATE TABLE forum_settings ( forum_id INT(11) NOT NULL DEFAULT '0', type VARCHAR(48) NOT NULL, value VARCHAR(255) NOT NULL, PRIMARY KEY (forum_id, type) );?O)indexsqlite_autoindex_forum_settings_1forum_settings ¢