--- fenglin/TODO/sql/db_stru.sql	2025/03/03 06:43:40	1.4
+++ fenglin/TODO/sql/db_stru.sql	2025/04/09 06:15:33	1.11
@@ -8,14 +8,7 @@ CREATE TABLE `admin_config` (
   `end_dt` datetime DEFAULT NULL,
   `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
   `major` tinyint UNSIGNED NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `ban_ip_list` (
-  `BID` smallint NOT NULL,
-  `begin_ip` varchar(20) DEFAULT NULL,
-  `end_ip` varchar(20) DEFAULT NULL,
-  `enable` tinyint UNSIGNED NOT NULL DEFAULT '1'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `ban_user_list` (
   `BID` smallint NOT NULL,
@@ -30,7 +23,7 @@ CREATE TABLE `ban_user_list` (
   `unban_ip` varchar(20) DEFAULT NULL,
   `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
   `reason` mediumtext
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `bbs` (
   `AID` int NOT NULL,
@@ -59,13 +52,11 @@ CREATE TABLE `bbs` (
   `excerption` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `ontop` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `static` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `cached` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `recommend` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `gen_ex` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `m_del` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `old_SID` smallint NOT NULL DEFAULT '0',
-  `old_TID` mediumint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+  `old_SID` smallint NOT NULL DEFAULT '0'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `bbs_article_op` (
   `MID` int NOT NULL,
@@ -75,13 +66,13 @@ CREATE TABLE `bbs_article_op` (
   `op_dt` datetime DEFAULT NULL,
   `op_ip` varchar(20) DEFAULT NULL,
   `complete` tinyint UNSIGNED NOT NULL DEFAULT '1'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `bbs_content` (
   `CID` int NOT NULL,
   `AID` int NOT NULL DEFAULT '0',
   `content` longtext
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `bbs_ex_dl` (
   `ID` mediumint NOT NULL,
@@ -91,7 +82,7 @@ CREATE TABLE `bbs_ex_dl` (
   `dl_type` char(1) NOT NULL DEFAULT 'C',
   `filename` varchar(50) DEFAULT NULL,
   `enable` tinyint UNSIGNED NOT NULL DEFAULT '1'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `bbs_msg` (
   `MID` int NOT NULL,
@@ -103,22 +94,7 @@ CREATE TABLE `bbs_msg` (
   `new` tinyint UNSIGNED NOT NULL DEFAULT '1',
   `deleted` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `s_deleted` tinyint UNSIGNED NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `bbs_prize` (
-  `PID` smallint NOT NULL,
-  `title` varchar(50) DEFAULT NULL,
-  `description` varchar(50) DEFAULT NULL,
-  `score` mediumint NOT NULL DEFAULT '0',
-  `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
-  `count_left` mediumint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `bbs_top_list` (
-  `AID` int NOT NULL DEFAULT '0',
-  `bbs_title` varchar(80) NOT NULL DEFAULT '',
-  `section_title` varchar(20) NOT NULL DEFAULT ''
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `email` (
   `ID` int NOT NULL,
@@ -133,7 +109,7 @@ CREATE TABLE `email` (
   `complete` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `error` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `error_msg` varchar(255) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `ex_dir` (
   `FID` mediumint NOT NULL,
@@ -142,31 +118,31 @@ CREATE TABLE `ex_dir` (
   `SID` smallint NOT NULL DEFAULT '0',
   `enable` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `dt` datetime DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `ex_file` (
   `AID` int NOT NULL DEFAULT '0',
   `FID` smallint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `friend_list` (
   `ID` mediumint NOT NULL,
   `UID` mediumint NOT NULL DEFAULT '0',
   `fUID` mediumint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `journal_data` (
   `ID` mediumint NOT NULL,
   `JID` smallint NOT NULL DEFAULT '0',
   `AID` mediumint NOT NULL DEFAULT '0',
   `abstract` longtext NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `journal_index` (
   `JID` smallint NOT NULL,
   `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `enable` tinyint(1) NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `mng_err_login_log` (
   `ID` int NOT NULL,
@@ -174,14 +150,14 @@ CREATE TABLE `mng_err_login_log` (
   `password` varchar(12) DEFAULT NULL,
   `login_dt` datetime DEFAULT NULL,
   `login_ip` varchar(20) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `mng_login_log` (
   `ID` int NOT NULL,
   `UID` mediumint NOT NULL DEFAULT '0',
   `login_dt` datetime DEFAULT NULL,
   `login_ip` varchar(20) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `mng_priv_list` (
   `PID` mediumint NOT NULL,
@@ -198,22 +174,14 @@ CREATE TABLE `mng_priv_list` (
   `gen_ex` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `upload_check` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `article_recommend` tinyint UNSIGNED NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `mng_user_list` (
   `UID` mediumint NOT NULL,
   `username` varchar(14) NOT NULL DEFAULT '',
   `password` varchar(64) NOT NULL DEFAULT '',
   `enable` tinyint UNSIGNED NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `section_apply_log` (
-  `AID` smallint NOT NULL,
-  `SID` smallint NOT NULL DEFAULT '0',
-  `UID` mediumint NOT NULL DEFAULT '0',
-  `process_dt` datetime DEFAULT NULL,
-  `memo` text
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `section_class` (
   `CID` smallint NOT NULL,
@@ -221,7 +189,7 @@ CREATE TABLE `section_class` (
   `title` varchar(20) DEFAULT NULL,
   `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
   `sort_order` smallint NOT NULL DEFAULT '10'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `section_class_master` (
   `MID` smallint NOT NULL,
@@ -232,7 +200,7 @@ CREATE TABLE `section_class_master` (
   `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
   `memo` text,
   `major` tinyint UNSIGNED NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `section_config` (
   `SID` smallint NOT NULL,
@@ -240,29 +208,26 @@ CREATE TABLE `section_config` (
   `CID` smallint NOT NULL DEFAULT '0',
   `title` varchar(20) DEFAULT NULL,
   `comment` varchar(255) DEFAULT NULL,
-  `topic_max_count` smallint NOT NULL DEFAULT '0',
+  `topic_retention` smallint NOT NULL DEFAULT '0',
   `announcement` longtext,
-  `bgsound` smallint NOT NULL DEFAULT '0',
   `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
   `exp_get` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `recommend` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `transship_ratio` float NOT NULL DEFAULT '0.5',
   `set_UID` mediumint DEFAULT '0',
   `set_dt` datetime DEFAULT NULL,
   `set_ip` varchar(20) DEFAULT NULL,
   `sort_order` smallint NOT NULL DEFAULT '10',
   `ex_gen_tm` datetime DEFAULT NULL,
-  `ex_pack_tm` datetime DEFAULT NULL,
   `ex_update` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `read_user_level` smallint NOT NULL DEFAULT '0',
   `write_user_level` smallint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `section_favorite` (
   `ID` int NOT NULL,
   `UID` mediumint NOT NULL DEFAULT '0',
   `SID` smallint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `section_master` (
   `MID` smallint NOT NULL,
@@ -272,35 +237,22 @@ CREATE TABLE `section_master` (
   `end_dt` datetime DEFAULT NULL,
   `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
   `major` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `formal` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `memo` text
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `section_master_apply` (
-  `AID` smallint NOT NULL,
-  `SID` smallint NOT NULL DEFAULT '0',
-  `UID` mediumint NOT NULL DEFAULT '0',
-  `apply_dt` datetime DEFAULT NULL,
-  `process` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `process_dt` datetime DEFAULT NULL,
-  `permit` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `major` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `memo` text
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `section_user_priv` (
   `SID` smallint NOT NULL DEFAULT '0',
   `UID` mediumint NOT NULL DEFAULT '0',
   `read` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `write` tinyint UNSIGNED NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `send_pass_log` (
   `ID` mediumint NOT NULL,
   `UID` mediumint NOT NULL DEFAULT '0',
   `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `ip` varchar(20) NOT NULL DEFAULT ''
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `upload_file` (
   `AID` mediumint NOT NULL,
@@ -311,21 +263,7 @@ CREATE TABLE `upload_file` (
   `check` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `deny` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `deleted` tinyint UNSIGNED NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `user_auth` (
-  `AUID` mediumint NOT NULL,
-  `UID` mediumint NOT NULL DEFAULT '0',
-  `pid` varchar(18) DEFAULT NULL,
-  `name` varchar(10) DEFAULT NULL,
-  `email` varchar(30) DEFAULT NULL,
-  `expire_dt` datetime DEFAULT NULL,
-  `photo_enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
-  `photo_ext` varchar(5) NOT NULL DEFAULT '',
-  `enable` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `process` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `auth_type` enum('PID','EMAIL','TRUST','SCORE') NOT NULL DEFAULT 'TRUST'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_err_login_log` (
   `ID` int NOT NULL,
@@ -333,7 +271,7 @@ CREATE TABLE `user_err_login_log` (
   `password` varchar(12) DEFAULT NULL,
   `login_dt` datetime DEFAULT NULL,
   `login_ip` varchar(20) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_life_log` (
   `ID` mediumint NOT NULL,
@@ -342,25 +280,26 @@ CREATE TABLE `user_life_log` (
   `life` smallint NOT NULL DEFAULT '0',
   `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `ip` varchar(20) NOT NULL DEFAULT ''
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_list` (
   `UID` mediumint NOT NULL,
   `username` varchar(20) NOT NULL DEFAULT '',
   `password` varchar(64) NOT NULL DEFAULT '',
+  `temp_password` varchar(20) NOT NULL DEFAULT '',
   `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
   `verified` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `p_login` tinyint UNSIGNED NOT NULL DEFAULT '1',
   `p_post` tinyint UNSIGNED NOT NULL DEFAULT '1',
   `p_msg` tinyint UNSIGNED NOT NULL DEFAULT '1'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_login_log` (
   `ID` int NOT NULL,
   `UID` mediumint NOT NULL DEFAULT '0',
   `login_dt` datetime DEFAULT NULL,
   `login_ip` varchar(20) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_modify_email_verify` (
   `MID` mediumint NOT NULL,
@@ -370,7 +309,7 @@ CREATE TABLE `user_modify_email_verify`
   `complete` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `dt` datetime DEFAULT NULL,
   `ip` varchar(20) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_modify_log` (
   `MID` mediumint NOT NULL,
@@ -378,7 +317,7 @@ CREATE TABLE `user_modify_log` (
   `modify_dt` datetime DEFAULT NULL,
   `modify_ip` varchar(20) DEFAULT NULL,
   `complete` tinyint UNSIGNED NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_nickname` (
   `NID` mediumint NOT NULL,
@@ -388,28 +327,16 @@ CREATE TABLE `user_nickname` (
   `begin_reason` char(1) DEFAULT NULL,
   `end_dt` datetime DEFAULT NULL,
   `end_reason` char(1) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_online` (
-  `ID` int NOT NULL,
   `SID` varchar(32) NOT NULL DEFAULT '',
   `UID` mediumint NOT NULL DEFAULT '0',
   `ip` varchar(20) NOT NULL DEFAULT '',
-  `current_SID` smallint NOT NULL DEFAULT '0',
   `current_action` varchar(20) NOT NULL DEFAULT '',
   `login_tm` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `last_tm` datetime DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `user_prize` (
-  `ID` mediumint NOT NULL,
-  `UID` mediumint NOT NULL DEFAULT '0',
-  `PID` smallint NOT NULL DEFAULT '0',
-  `dt` datetime DEFAULT NULL,
-  `ip` varchar(20) DEFAULT NULL,
-  `process` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `complete` tinyint UNSIGNED NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_pubinfo` (
   `UID` mediumint NOT NULL DEFAULT '0',
@@ -417,8 +344,6 @@ CREATE TABLE `user_pubinfo` (
   `email` varchar(30) DEFAULT NULL,
   `gender` char(1) NOT NULL DEFAULT 'M',
   `qq` varchar(10) DEFAULT NULL,
-  `msn` varchar(30) DEFAULT NULL,
-  `homepage` varchar(80) DEFAULT NULL,
   `introduction` mediumtext,
   `photo` smallint DEFAULT '0',
   `photo_enable` tinyint(1) NOT NULL DEFAULT '0',
@@ -426,10 +351,6 @@ CREATE TABLE `user_pubinfo` (
   `life` smallint NOT NULL DEFAULT '15',
   `exp` mediumint DEFAULT '0',
   `visit_count` mediumint NOT NULL DEFAULT '0',
-  `email_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `qq_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `msn_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `homepage_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `gender_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `last_login_dt` datetime DEFAULT NULL,
   `sign_1` mediumtext,
@@ -437,62 +358,31 @@ CREATE TABLE `user_pubinfo` (
   `sign_3` mediumtext,
   `sub_permission` tinyint UNSIGNED NOT NULL DEFAULT '1',
   `upload_limit` int NOT NULL DEFAULT '1048576',
-  `login_notify_dt` datetime DEFAULT NULL,
-  `subscribe_jid` smallint NOT NULL DEFAULT '-1',
-  `bgsound` tinyint(1) NOT NULL DEFAULT '1'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+  `login_notify_dt` datetime DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_reginfo` (
   `UID` mediumint NOT NULL DEFAULT '0',
   `name` varchar(10) DEFAULT NULL,
   `birthday` datetime DEFAULT NULL,
-  `address` varchar(80) DEFAULT NULL,
-  `tel` varchar(20) DEFAULT NULL,
-  `postcode` varchar(6) DEFAULT NULL,
-  `pid` varchar(18) DEFAULT NULL,
-  `country` varchar(10) DEFAULT NULL,
-  `province` varchar(10) DEFAULT NULL,
-  `city` varchar(10) DEFAULT NULL,
   `signup_dt` datetime DEFAULT NULL,
   `signup_ip` varchar(20) DEFAULT NULL,
   `memo` mediumtext
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `user_reginfo_log` (
-  `ID` mediumint NOT NULL,
-  `UID` mediumint NOT NULL DEFAULT '0',
-  `name` varchar(10) DEFAULT NULL,
-  `birthday` date DEFAULT NULL,
-  `address` varchar(80) DEFAULT NULL,
-  `tel` varchar(20) DEFAULT NULL,
-  `postcode` varchar(6) DEFAULT NULL,
-  `pid` varchar(18) DEFAULT NULL,
-  `country` varchar(10) DEFAULT NULL,
-  `province` varchar(10) DEFAULT NULL,
-  `city` varchar(10) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_regverify` (
   `UID` mediumint NOT NULL DEFAULT '0',
   `verify_code` varchar(10) NOT NULL DEFAULT '',
   `complete` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `set_dt` datetime DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `user_relation` (
-  `RID` mediumint NOT NULL,
-  `pUID` mediumint NOT NULL DEFAULT '0',
-  `cUID` mediumint NOT NULL DEFAULT '0',
-  `enable` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `last_exp` mediumint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_score` (
   `UID` mediumint NOT NULL DEFAULT '0',
   `score` mediumint NOT NULL DEFAULT '0',
   `last_exp` mediumint NOT NULL DEFAULT '0',
   `exp_left` mediumint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_score_log` (
   `ID` mediumint NOT NULL,
@@ -500,65 +390,25 @@ CREATE TABLE `user_score_log` (
   `score_change` mediumint NOT NULL DEFAULT '0',
   `reason` varchar(50) DEFAULT NULL,
   `dt` datetime DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `user_switch_list` (
-  `ID` mediumint NOT NULL,
-  `UID` mediumint NOT NULL DEFAULT '0',
-  `tUID` mediumint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `user_trust_log` (
-  `ID` mediumint NOT NULL,
-  `UID` mediumint NOT NULL DEFAULT '0',
-  `tUID` mediumint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `view_article_log` (
   `AID` int NOT NULL DEFAULT '0',
   `UID` mediumint NOT NULL DEFAULT '0',
   `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `visit_log` (
   `VID` int NOT NULL,
   `dt` datetime DEFAULT NULL,
   `ip` varchar(20) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `vote_answer` (
-  `AID` smallint NOT NULL,
-  `VID` smallint NOT NULL DEFAULT '0',
-  `answer` varchar(100) DEFAULT NULL,
-  `count` smallint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `vote_config` (
-  `VID` smallint NOT NULL,
-  `title` varchar(20) DEFAULT NULL,
-  `question` varchar(100) DEFAULT NULL,
-  `begin_dt` datetime DEFAULT NULL,
-  `end_dt` datetime DEFAULT NULL,
-  `enable` tinyint UNSIGNED NOT NULL DEFAULT '1'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `vote_log` (
-  `ID` mediumint NOT NULL,
-  `UID` mediumint NOT NULL DEFAULT '0',
-  `VID` smallint NOT NULL DEFAULT '0',
-  `AID` smallint NOT NULL DEFAULT '0',
-  `vote_dt` datetime DEFAULT NULL,
-  `vote_ip` varchar(20) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 
 ALTER TABLE `admin_config`
   ADD PRIMARY KEY (`AID`),
   ADD KEY `UID` (`UID`);
 
-ALTER TABLE `ban_ip_list`
-  ADD PRIMARY KEY (`BID`);
-
 ALTER TABLE `ban_user_list`
   ADD PRIMARY KEY (`BID`),
   ADD KEY `ban_UID` (`ban_UID`),
@@ -577,7 +427,6 @@ ALTER TABLE `bbs`
   ADD KEY `title` (`title`(10)),
   ADD KEY `old_SID` (`old_SID`),
   ADD KEY `SID` (`SID`),
-  ADD KEY `old_TID` (`old_TID`),
   ADD KEY `TID` (`TID`),
   ADD KEY `last_reply_UID` (`last_reply_UID`);
 
@@ -601,9 +450,6 @@ ALTER TABLE `bbs_msg`
   ADD KEY `fromUID` (`fromUID`),
   ADD KEY `toUID` (`toUID`);
 
-ALTER TABLE `bbs_prize`
-  ADD PRIMARY KEY (`PID`);
-
 ALTER TABLE `email`
   ADD PRIMARY KEY (`ID`),
   ADD KEY `complete` (`complete`);
@@ -646,9 +492,6 @@ ALTER TABLE `mng_user_list`
   ADD PRIMARY KEY (`UID`),
   ADD UNIQUE KEY `username` (`username`);
 
-ALTER TABLE `section_apply_log`
-  ADD PRIMARY KEY (`AID`);
-
 ALTER TABLE `section_class`
   ADD PRIMARY KEY (`CID`),
   ADD KEY `sort_order` (`sort_order`);
@@ -675,9 +518,6 @@ ALTER TABLE `section_master`
   ADD KEY `SID` (`SID`),
   ADD KEY `UID` (`UID`);
 
-ALTER TABLE `section_master_apply`
-  ADD PRIMARY KEY (`AID`);
-
 ALTER TABLE `section_user_priv`
   ADD PRIMARY KEY (`SID`,`UID`),
   ADD KEY `UID` (`UID`);
@@ -692,12 +532,6 @@ ALTER TABLE `upload_file`
   ADD KEY `UID` (`UID`),
   ADD KEY `ref_AID` (`ref_AID`);
 
-ALTER TABLE `user_auth`
-  ADD PRIMARY KEY (`AUID`),
-  ADD KEY `UID` (`UID`),
-  ADD KEY `expire_dt` (`expire_dt`),
-  ADD KEY `auth_type` (`auth_type`);
-
 ALTER TABLE `user_err_login_log`
   ADD PRIMARY KEY (`ID`),
   ADD KEY `login_dt` (`login_dt`,`login_ip`);
@@ -736,17 +570,10 @@ ALTER TABLE `user_nickname`
   ADD KEY `end_dt` (`end_dt`);
 
 ALTER TABLE `user_online`
-  ADD PRIMARY KEY (`ID`),
+  ADD PRIMARY KEY (`SID`) USING BTREE,
   ADD KEY `login_tm` (`login_tm`),
   ADD KEY `UID` (`UID`),
-  ADD KEY `last_tm` (`last_tm`),
-  ADD KEY `SID` (`SID`);
-
-ALTER TABLE `user_prize`
-  ADD PRIMARY KEY (`ID`),
-  ADD KEY `UID` (`UID`),
-  ADD KEY `PID` (`PID`),
-  ADD KEY `process` (`process`);
+  ADD KEY `last_tm` (`last_tm`);
 
 ALTER TABLE `user_pubinfo`
   ADD PRIMARY KEY (`UID`),
@@ -754,25 +581,15 @@ ALTER TABLE `user_pubinfo`
   ADD KEY `life` (`life`),
   ADD KEY `login_notify_dt` (`login_notify_dt`),
   ADD KEY `exp` (`exp`),
-  ADD KEY `last_login_dt` (`last_login_dt`),
-  ADD KEY `subscribe_jid` (`subscribe_jid`);
+  ADD KEY `last_login_dt` (`last_login_dt`);
 
 ALTER TABLE `user_reginfo`
   ADD PRIMARY KEY (`UID`);
 
-ALTER TABLE `user_reginfo_log`
-  ADD PRIMARY KEY (`ID`),
-  ADD KEY `UID` (`UID`);
-
 ALTER TABLE `user_regverify`
   ADD PRIMARY KEY (`UID`),
   ADD UNIQUE KEY `verify_code` (`verify_code`);
 
-ALTER TABLE `user_relation`
-  ADD PRIMARY KEY (`RID`),
-  ADD UNIQUE KEY `cUID` (`cUID`),
-  ADD KEY `pUID` (`pUID`);
-
 ALTER TABLE `user_score`
   ADD PRIMARY KEY (`UID`),
   ADD KEY `score` (`score`);
@@ -781,16 +598,6 @@ ALTER TABLE `user_score_log`
   ADD PRIMARY KEY (`ID`),
   ADD KEY `UID` (`UID`);
 
-ALTER TABLE `user_switch_list`
-  ADD PRIMARY KEY (`ID`),
-  ADD KEY `tUID` (`tUID`),
-  ADD KEY `UID` (`UID`);
-
-ALTER TABLE `user_trust_log`
-  ADD PRIMARY KEY (`ID`),
-  ADD KEY `tUID` (`tUID`),
-  ADD KEY `UID` (`UID`);
-
 ALTER TABLE `view_article_log`
   ADD PRIMARY KEY (`AID`,`UID`),
   ADD KEY `dt` (`dt`);
@@ -798,28 +605,10 @@ ALTER TABLE `view_article_log`
 ALTER TABLE `visit_log`
   ADD PRIMARY KEY (`VID`);
 
-ALTER TABLE `vote_answer`
-  ADD PRIMARY KEY (`AID`),
-  ADD KEY `VID` (`VID`);
-
-ALTER TABLE `vote_config`
-  ADD PRIMARY KEY (`VID`),
-  ADD KEY `begin_dt` (`begin_dt`),
-  ADD KEY `end_dt` (`end_dt`);
-
-ALTER TABLE `vote_log`
-  ADD PRIMARY KEY (`ID`),
-  ADD KEY `UID` (`UID`),
-  ADD KEY `VID` (`VID`),
-  ADD KEY `AID` (`AID`);
-
 
 ALTER TABLE `admin_config`
   MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
 
-ALTER TABLE `ban_ip_list`
-  MODIFY `BID` smallint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `ban_user_list`
   MODIFY `BID` smallint NOT NULL AUTO_INCREMENT;
 
@@ -838,9 +627,6 @@ ALTER TABLE `bbs_ex_dl`
 ALTER TABLE `bbs_msg`
   MODIFY `MID` int NOT NULL AUTO_INCREMENT;
 
-ALTER TABLE `bbs_prize`
-  MODIFY `PID` smallint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `email`
   MODIFY `ID` int NOT NULL AUTO_INCREMENT;
 
@@ -868,9 +654,6 @@ ALTER TABLE `mng_priv_list`
 ALTER TABLE `mng_user_list`
   MODIFY `UID` mediumint NOT NULL AUTO_INCREMENT;
 
-ALTER TABLE `section_apply_log`
-  MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `section_class`
   MODIFY `CID` smallint NOT NULL AUTO_INCREMENT;
 
@@ -886,18 +669,12 @@ ALTER TABLE `section_favorite`
 ALTER TABLE `section_master`
   MODIFY `MID` smallint NOT NULL AUTO_INCREMENT;
 
-ALTER TABLE `section_master_apply`
-  MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `send_pass_log`
   MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
 
 ALTER TABLE `upload_file`
   MODIFY `AID` mediumint NOT NULL AUTO_INCREMENT;
 
-ALTER TABLE `user_auth`
-  MODIFY `AUID` mediumint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `user_err_login_log`
   MODIFY `ID` int NOT NULL AUTO_INCREMENT;
 
@@ -919,35 +696,8 @@ ALTER TABLE `user_modify_log`
 ALTER TABLE `user_nickname`
   MODIFY `NID` mediumint NOT NULL AUTO_INCREMENT;
 
-ALTER TABLE `user_online`
-  MODIFY `ID` int NOT NULL AUTO_INCREMENT;
-
-ALTER TABLE `user_prize`
-  MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
-
-ALTER TABLE `user_reginfo_log`
-  MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
-
-ALTER TABLE `user_relation`
-  MODIFY `RID` mediumint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `user_score_log`
   MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
 
-ALTER TABLE `user_switch_list`
-  MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
-
-ALTER TABLE `user_trust_log`
-  MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `visit_log`
   MODIFY `VID` int NOT NULL AUTO_INCREMENT;
-
-ALTER TABLE `vote_answer`
-  MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
-
-ALTER TABLE `vote_config`
-  MODIFY `VID` smallint NOT NULL AUTO_INCREMENT;
-
-ALTER TABLE `vote_log`
-  MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;