SQLite format 3@  ÈMM!È.S`ˆ:˚ˆ©|p
ô	©
n	V˝ä*∆_è≥?˙ñ)∂O¯e3Åindexidx_comment_user_idt_commentCREATE INDEX `idx_comment_user_id` ON `t_comment`(`user_id`)q;Åindexidx_comment_entity_typet_commentCREATE INDEX `idx_comment_entity_type` ON `t_comment`(`entity_type`)k7Å
indexidx_comment_entity_idt_commentCREATE INDEX `idx_comment_entity_id` ON `t_comment`(`entity_id`)b1Åindexidx_comment_statust_commentCREATE INDEX `idx_comment_status` ON `t_comment`(`status`)ÇBÑStablet_commentt_commentCREATE TABLE `t_comment` (`id` integer,`user_id` integer NOT NULL,`entity_type` text NOT NULL,`entity_id` integer NOT NULL,`content` text NOT NULL,`image_list` longtext,`content_type` varchar(32) NOT NULL,`quote_id` integer NOT NULL,`status` integer,`create_time` integer,PRIMARY KEY (`id`))r9'Åindexidx_article_tag_statust_article_tagCREATE INDEX `idx_article_tag_status` ON `t_article_tag`(`status`)f)'Å	indexidx_article_idt_article_tagCREATE INDEX `idx_article_id` ON `t_article_tag`(`article_id`)r9'Åindexidx_article_tag_tag_idt_article_tagCREATE INDEX `idx_article_tag_tag_id` ON `t_article_tag`(`tag_id`)ÅM''ÇYtablet_article_tagt_article_tagCREATE TABLE `t_article_tag` (`id` integer,`article_id` integer NOT NULL,`tag_id` integer NOT NULL,`status` integer NOT NULL,`create_time` integer,PRIMARY KEY (`id`))e3Åindexidx_article_user_idt_articleCREATE INDEX `idx_article_user_id` ON `t_article`(`user_id`)b1Åindexidx_article_statust_articleCREATE INDEX `idx_article_status` ON `t_article`(`status`)^)Åindexidx_view_countt_articleCREATE INDEX `idx_view_count` ON `t_article`(`view_count`)q;Åindexidx_article_create_timet_articleCREATE INDEX `idx_article_create_time` ON `t_article`(`create_time`)ÇV
Ñ{tablet_articlet_articleCREATE TABLE `t_article` (`id` integer,`user_id` integer,`title` text NOT NULL,`summary` text,`content` longtext NOT NULL,`content_type` varchar(32) NOT NULL,`status` int(11),`share` numeric NOT NULL,`source_url` text,`view_count` integer NOT NULL,`create_time` integer,`update_time` integer,PRIMARY KEY (`id`))Q)qindexidx_tag_statust_tag
CREATE INDEX `idx_tag_status` ON `t_tag`(`status`)ÅB
Çctablet_tagt_tagCREATE TABLE `t_tag` (`id` integer,`name` text NOT NULL UNIQUE,`description` text,`status` integer NOT NULL,`create_time` integer,`update_time` integer,PRIMARY KEY (`id`)))=indexsqlite_autoindex_t_tag_1t_tagq	9%Åindexidx_user_token_user_idt_user_token
CREATE INDEX `idx_user_token_user_id` ON `t_user_token`(`user_id`)n7%Å
indexidx_user_token_statust_user_token	CREATE INDEX `idx_user_token_status` ON `t_user_token`(`status`)Åq%%É%tablet_user_tokent_user_tokenCREATE TABLE `t_user_token` (`id` integer,`token` text NOT NULL UNIQUE,`user_id` integer NOT NULL,`expired_at` integer NOT NULL,`status` integer NOT NULL,`create_time` integer NOT NULL,PRIMARY KEY (`id`))7K%indexsqlite_autoindex_t_user_token_1t_user_tokenR)qindexidx_user_scoret_userCREATE INDEX `idx_user_score` ON `t_user`(`score`)U+uindexidx_user_statust_userCREATE INDEX `idx_user_status` ON `t_user`(`status`)ÑGàitablet_usert_userCREATE TABLE `t_user` (`id` integer,`username` text UNIQUE,`email` text UNIQUE,`email_verified` numeric NOT NULL DEFAULT false,`nickname` text,`avatar` text,`background_image` text,`password` text,`home_page` text,`description` text,`score` integer NOT NULL,`status` integer NOT NULL,`topic_count` integer NOT NULL,`comment_count` integer NOT NULL,`follow_count` integer NOT NULL,`fans_count` integer NOT NULL,`roles` text,`type` integer NOT NULL,`forbidden_end_time` integer NOT NULL DEFAULT 0,`create_time` integer,`update_time` integer,PRIMARY KEY (`id`))+?indexsqlite_autoindex_t_user_2t_user+?indexsqlite_autoindex_t_user_1t_use8
JJÅ3'#
Ågadmina@example.comfalsebbsgoÁ´ôÈïø$2a$10$ofA39bAFMpYpIX/Xiz7jtOMH9JnPvYfPRlzHXqAtLPFpbE/cLdjmSËΩªËΩªÂú∞ÊàëËµ∞‰∫ÜÔºåÊ≠£Â¶ÇÊàëËΩªËΩªÁöÑÊù•„ÄÇowner}ãŒê}ãŒê
˜˜	admin
ÔÔ'	a@example.com
¸¸	
¸¸	






















H
∂
â
\
±ΩÑ
°	‹	±	^é≤>˘ï(µNÖ£2HÜÉgá%tablet_topict_topic"CREATE TABLE `t_topic` (`id` integer,`type` integer NOT NULL,`node_id` integer NOT NULL,`user_id` integer NOT NULL,`title` text,`content` longtext,`image_list` longtext,`recommend` numeric NOT NULL,`recommend_time` integer NOT NULL,`view_count` integer NOT NULL,`comment_count` integer NOT NULL,`like_count` integer NOT NULL,`status` integer,`last_comment_time` integer,`last_comment_user_id` integer,`create_time` integer,`extra_data` text,PRIMARY KEY (`id`))o9!Åindexidx_favorite_entity_idt_favorite!CREATE INDEX `idx_favorite_entity_id` ON `t_favorite`(`entity_id`)i5!Å	indexidx_favorite_user_idt_favorite CREATE INDEX `idx_favorite_user_id` ON `t_favorite`(`user_id`)u=!Åindexidx_favorite_entity_typet_favoriteCREATE INDEX `idx_favorite_entity_type` ON `t_favorite`(`entity_type`)ÅF!!ÇWtablet_favoritet_favoriteCREATE TABLE `t_favorite` (`id` integer,`user_id` integer NOT NULL,`entity_type` text NOT NULL,`entity_id` integer NOT NULL,`create_time` integer,PRIMARY KEY (`id`))e3Åindexidx_comment_user_idt_commentCREATE INDEX `idx_comment_user_id` ON `t_comment`(`user_id`)q;Åindexidx_comment_entity_typet_commentCREATE INDEX `idx_comment_entity_type` ON `t_comment`(`entity_type`)k7Å
indexidx_comment_entity_idt_commentCREATE INDEX `idx_comment_entity_id` ON `t_comment`(`entity_id`)b1Åindexidx_comment_statust_commentCREATE INDEX `idx_comment_status` ON `t_comment`(`status`)ÇBÑStablet_commentt_commentCREATE TABLE `t_comment` (`id` integer,`user_id` integer NOT NULL,`entity_type` text NOT NULL,`entity_id` integer NOT NULL,`content` text NOT NULL,`image_list` longtext,`content_type` varchar(32) NOT NULL,`quote_id` integer NOT NULL,`status` integer,`create_time` integer,PRIMARY KEY (`id`))r9'Åindexidx_article_tag_statust_article_tagCREATE INDEX `idx_article_tag_status` ON `t_article_tag`(`status`)f)'Å	indexidx_article_idt_article_tagCREATE INDEX `idx_article_id` ON `t_article_tag`(`article_id`)r9'Åindexidx_article_tag_tag_idt_article_tagCREATE INDEX `idx_article_tag_tag_id` ON `t_article_tag`(`tag_id`)ÅM''ÇYtablet_article_tagt_article_tagCREATE TABLE `t_article_tag` (`id` integer,`article_id` integer NOT NULL,`tag_id` integer NOT NULL,`status` integer NOT NULL,`create_time` integer,PRIMARY KEY (`id`))Q)qindexidx_tag_statust_tag
CREATE INDEX `idx_tag_status` ON `t_tag`(`status`))=indexsqlite_autoindex_t_tag_1t_tagÅB
Çctablet_tagt_tagCREATE TABLE `t_tag` (`id` integer,`name` text NOT NULL UNIQUE,`description` text,`status` integer NOT NULL,`create_time` integer,`update_time` integer,PRIMARY KEY (`id`))q	9%Åindexidx_user_token_user_idt_user_token
CREATE INDEX `idx_user_token_user_id` ON `t_user_token`(`user_id`)n7%Å
indexidx_user_token_statust_user_token	CREATE INDEX `idx_user_token_status` ON `t_user_token`(`status`)7K%indexsqlite_autoindex_t_user_token_1t_user_tokenÅq%%É%tablet_user_tokent_user_tokenCREATE TABLE `t_user_token` (`id` integer,`token` text NOT NULL UNIQUE,`user_id` integer NOT NULL,`expired_at` integer NOT NULL,`status` integer NOT NULL,`create_time` integer NOT NULL,PRIMARY KEY (`id`))R)qindexidx_user_scoret_userCREATE INDEX `idx_user_score` ON `t_user`(`score`)U+uindexidx_user_statust_userCREATE INDEX `idx_user_status` ON `t_user`(`status`)+?indexsqlite_autoindex_t_user_2t_user+?indexsqlite_autoindex_t_user_1t_userÑGàitablet_usert_userCREATE TABLE `t_user` (`id` integer,`username` text UNIQUE,`email` text UNIQUE,`email_verified` numeric NOT NULL DEFAULT false,`nickname` text,`avatar` text,`background_image` text,`password` text,`home_page` text,`description` text,`score` integer NOT NULL,`status` integer NOT NULL,`topic_count` integer NOT NULL,`comment_count` integer NOT NULL,`follow_count` integer NOT NULL,`fans_count` integer NOT NULL,`roles` text,`type` integer NOT NULL,`forbidden_end_time` integer NOT NULL DEFAULT 0,`create_time` integer,`update_time` integer,PRIMARY KEY (`id`))

√ch≤`
ı
x	ü	f	
õ/Ω/cÊW1 ◊ûcçº
®	ˆ	∂g3ÅindeÇ85Ñ?tablet_projectt_project8CREATE TABLE `t_project` (`id` integer,`user_id` integer NOT NULL,`name` varchar(1024),`title` text,`logo` varchar(1024),`url` varchar(1024),`doc_url` varchar(1024),`download_url` varchar(1024),`content_type` varchar(32),`content` longtext,`create_time` integer,PRIMARY KEY (`id`))74K%indexsqlite_autoindex_t_sys_config_1t_sys_config7Åp3%%É#tablet_sys_configt_sys_config6CREATE TABLE `t_sys_config` (`id` integer,`key` text NOT NULL UNIQUE,`value` text,`name` text NOT NULL,`description` text,`create_time` integer NOT NULL,`update_time` integer NOT NULL,PRIMARY KEY (`id`))e23Åindexidx_message_user_idt_message5CREATE INDEX `idx_message_user_id` ON `t_message`(`user_id`)Ç#1Ñtablet_messaget_message4CREATE TABLE `t_message` (`id` integer,`from_id` integer NOT NULL,`user_id` integer NOT NULL,`title` text,`content` text NOT NULL,`quote_content` text,`type` integer NOT NULL,`extra_data` text,`status` integer NOT NULL,`create_time` integer,PRIMARY KEY (`id`))Å05#ÅMindexidx_user_like_uniquet_user_like3CREATE UNIQUE INDEX `idx_user_like_unique` ON `t_user_like`(`user_id`,`entity_type`,`entity_id`){/5#Å+indexidx_user_like_entityt_user_like2CREATE INDEX `idx_user_like_entity` ON `t_user_like`(`entity_type`,`entity_id`)ÅI.##ÇYtablet_user_liket_user_like1CREATE TABLE `t_user_like` (`id` integer,`user_id` integer NOT NULL,`entity_type` text NOT NULL,`entity_id` integer NOT NULL,`create_time` integer,PRIMARY KEY (`id`))Å-K#Å5indexidx_topic_tag_last_comment_timet_topic_tag0CREATE INDEX `idx_topic_tag_last_comment_time` ON `t_topic_tag`(`last_comment_time`)p,9#Åindexidx_topic_tag_topic_idt_topic_tag/CREATE INDEX `idx_topic_tag_topic_id` ON `t_topic_tag`(`topic_id`)j+5#Å	indexidx_topic_tag_tag_idt_topic_tag.CREATE INDEX `idx_topic_tag_tag_id` ON `t_topic_tag`(`tag_id`)j*5#Å	indexidx_topic_tag_statust_topic_tag-CREATE INDEX `idx_topic_tag_status` ON `t_topic_tag`(`status`)Ç)##ÉGtablet_topic_tagt_topic_tag,CREATE TABLE `t_topic_tag` (`id` integer,`topic_id` integer NOT NULL,`tag_id` integer NOT NULL,`status` integer NOT NULL,`last_comment_time` integer,`last_comment_user_id` integer,`create_time` integer,PRIMARY KEY (`id`))Z(#%{indexidx_sort_not_topic_node+CREATE INDEX `idx_sort_no` ON `t_topic_node`(`sort_no`)7'K%indexsqlite_autoindex_t_topic_node_1t_topic_node*ÅV&%%Çotablet_topic_nodet_topic_node)CREATE TABLE `t_topic_node` (`id` integer,`name` text UNIQUE,`description` text,`logo` text,`sort_no` integer,`status` integer NOT NULL,`create_time` integer,PRIMARY KEY (`id`)){%CÅ%indexidx_topic_last_comment_timet_topic(CREATE INDEX `idx_topic_last_comment_time` ON `t_topic`(`last_comment_time`)i$7Å
indexidx_topic_create_timet_topic'CREATE INDEX `idx_topic_create_time` ON `t_topic`(`create_time`)P##qindexidx_node_idt_topic&CREATE INDEX `idx_node_id` ON `t_topic`(`node_id`)\"/}indexidx_topic_user_idt_topic%CREATE INDEX `idx_topic_user_id` ON `t_topic`(`user_id`)V!'yindexidx_recommendt_topic$CREATE INDEX `idx_recommend` ON `t_topic`(`recommend`)Y -yindexidx_topic_statust_topic#CREATE INDEX `idx_topic_status` ON `t_topic`(`status`)Âá%tablet_topict_topic"CREATE TABLE `t_topic` (`id` integer,`type` integer NOT NULL,`node_id` integer NOT NULL,`user_id` integer NOT NULL,`title` text,`content` longtext,`image_list` longtext,`recommend` numeric NOT NULL,`Ç8++ÉYtablet_third_accountt_third_account<CREATE TABLE `t_third_account` (`id` integer,`user_id` integer,`avatar` text,`nickname` text,`third_type` text NOT NULL,`third_id` text NOT NULL,`extra_data` longtext,`create_time` integer,`update_time` integer,PRIMARY KEY (`id`))ÅN7Çwtablet_linkt_link;CREATE TABLE `t_link` (`id` integer,`url` text NOT NULL,`title` text NOT NULL,`summary` text,`logo` text,`status` integer NOT NULL,`create_time` integer NOT NULL,PRIMARY KEY (`id`))q6;Åindexidx_project_create_timet_project9CREATE INDEX `idx_project_create_time` ON `t_project`(`create_time`)























I∫QU
Ω
Ir	#Å%%scoreConfig{"postTopicScore":1,"postCommentScore":1,"checkInScore":1}ÁßØÂàÜÈÖçÁΩÆÁßØÂàÜÈÖçÁΩÆ}ãŒê}ãŒêZ+AAtokenExpireDays365Áî®Êà∑ÁôªÂΩïÊúâÊïàÊúü(Â§©)Áî®Êà∑ÁôªÂΩïÊúâÊïàÊúü(Â§©)}ãŒê}ãŒê:'%%defaultNodeId1ÈªòËÆ§ËäÇÁÇπÈªòËÆ§ËäÇÁÇπ}ãŒê}ãŒêÅ3	Ç	%%siteNavs[{\"title\":\"È¶ñÈ°µ\",\"url\":\"/\"},{\"title\":\"ËØùÈ¢ò\",\"url\":\"/topics\"},{\"title\":\"ÊñáÁ´†\",\"url\":\"/articles\"}]Á´ôÁÇπÂØºËà™Á´ôÁÇπÂØºËà™}ãŒê}ãŒêD%++siteKeywordsbbs-goÁ´ôÁÇπÂÖ≥ÈîÆÂ≠óÁ´ôÁÇπÂÖ≥ÈîÆÂ≠ó}ãŒê}ãŒêg+e%%siteDescriptionbbs-goÔºåÂü∫‰∫éGoËØ≠Ë®ÄÁöÑÂºÄÊ∫êÁ§æÂå∫Á≥ªÁªüÁ´ôÁÇπÊèèËø∞Á´ôÁÇπÊèèËø∞}ãŒê}ãŒêD+%%siteTitlebbs-goÊºîÁ§∫Á´ôÁ´ôÁÇπÊ†áÈ¢òÁ´ôÁÇπÊ†áÈ¢ò}ãŒê}ãŒê
ãØãﬂŒ¡Ûõ#scoreConfig+tokenExpireDays'defaultNodeIdsiteNavs%siteKeywords+siteDescription	siteTitle


ﬁ•	{qÈe8ª]ÊÓ•s
Ü
π‚
à
 	ª	ZÊzﬁ7CK%indexsqlite_autoindex_t_email_code_1t_email_codeGpuA;'Åindexidx_operate_log_user_idt_operate_logECREATE INDEX `idx_operate_log_user_id` ON `t_operate_log`(`user_id`)\@#'}indexidx_op_typet_operate_logDCREATE INDEX `idx_op_type` ON `t_operate_log`(`op_type`){?5'Å'indexidx_operate_log_datat_operate_logCCREATE INDEX `idx_operate_log_data` ON `t_operate_log`(`data_type`,`data_id`)Ç*>''Ñtablet_operate_logt_operate_logBCREATE TABLE `t_operate_log` (`id` integer,`user_id` integer NOT NULL,`op_type` text NOT NULL,`data_type` text NOT NULL,`data_id` integer NOT NULL,`description` text NOT NULL,`ip` text,`user_agent` text,`referer` text,`create_time` integer,PRIMARY KEY (`id`))Å=A-Å!indexidx_user_score_log_user_idt_user_score_logACREATE INDEX `idx_user_score_log_user_id` ON `t_user_score_log`(`user_id`)Å<5-Å5indexidx_user_score_scoret_user_score_log@CREATE INDEX `idx_user_score_score` ON `t_user_score_log`(`source_type`,`source_id`)Ç;--ÉAtablet_user_score_logt_user_score_log?CREATE TABLE `t_user_score_log` (`id` integer,`user_id` integer NOT NULL,`source_type` text NOT NULL,`source_id` text NOT NULL,`description` text,`type` integer,`score` integer,`create_time` integer,PRIMARY KEY (`id`))Å:9+Å?indexidx_user_id_third_typet_third_account>CREATE UNIQUE INDEX `idx_user_id_third_type` ON `t_third_account`(`user_id`,`third_type`)e9+Å
indexidx_thirdt_third_account=CREATE UNIQUE INDEX `idx_third` ON `t_third_account`(`third_id`)v++ÉYtablet_third_accountt_third_account<CREATE TABLE `t_third_account` (`id` integer,`user_id` integer,`avatar` text,`nickname` text,`third_type` text NOT NULL,`third_id` text NOT NULL,`extra_data` longtext,`create_time` integer,`update_time` integer,PRIMARY KÇhÅd++Ötablet_article__tempt_article__tempCREATE TABLE `t_article__temp` (`id` integer,`user_id` integer,`title` text NOT NULL,`summary` text,`content` longtext NOT NULL,`content_type` varchar(32) NOT NULL,`status` int(11),`share` numeric NOT NULL,`source_url` text,`view_count` integer NOT NULL,`create_time` integer,`update_time` integer,PRIMARY KEY (`id`))qÅh;Åindexidx_article_create_timet_articleCREATE INDEX `idx_article_create_time` ON `t_article`(`create_time`)^Åg)Åindexidx_view_countt_articleCREATE INDEX `idx_view_count` ON `t_article`(`view_count`)bÅf1Åindexidx_article_statust_articleCREATE INDEX `idx_article_status` ON `t_article`(`status`)eÅe3Åindexidx_article_user_idt_articleCREATE INDEX `idx_article_user_id` ON `t_article`(`user_id`)ÇVÅdÑ{tablet_articlet_articleCREATE TABLE "t_article" (`id` integer,`user_id` integer,`title` text NOT NULL,`summary` text,`content` longtext NOT NULL,`content_type` varchar(32) NOT NULL,`status` int(11),`share` numeric NOT NULL,`source_url` text,`view_count` integer NOT NULL,`create_time` integer,`update_time` integer,PRIMARY KEY (`id`))ÅTH''Çgtablet_user_followt_user_followLCREATE TABLE `t_user_follow` (`id` integer,`user_id` integer NOT NULL,`other_id` integer NOT NULL,`status` integer NOT NULL,`create_time` bigint NOT NULL,PRIMARY KEY (`id`))^G#!Åindexidx_user_idt_check_inKCREATE UNIQUE INDEX `idx_user_id` ON `t_check_in`(`user_id`)kF!!Å!indexidx_latestt_check_inJCREATE INDEX `idx_latest` ON `t_check_in`(`latest_day_name`,`update_time`)ÅjE!!Établet_check_int_check_inICREATE TABLE `t_check_in` (`id` integer,`user_id` integer NOT NULL,`latest_day_name` integer NOT NULL,`consecutive_days` integer NOT NULL,`create_time` integer,`update_time` integer,PRIMARY KEY (`id`))yDA%Åindexidx_user_email_log_user_idt_email_codeHCREATE INDEX `idx_user_email_log_user_id` ON `t_email_code`(`user_id`)ÇB%%Éatablet_email_codet_email_codeFCREATE TABLE `t_email_code` (`id` integer,`user_id` integer NOT NULL,`email` text NOT NULL,`code` text NOT NULL,`token` text NOT NULL UNIQUE,`title` text,`content` text,`used` numeric NOT NULL,`create_time` integer,PRIMARY KEY (`id`))

















