--- fenglin/TODO/sql/db_stru.sql	2025/03/31 14:18:20	1.9
+++ fenglin/TODO/sql/db_stru.sql	2025/04/01 10:46:40	1.10
@@ -1,5 +1,4 @@
 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
-START TRANSACTION;
 SET time_zone = "+00:00";
 
 CREATE TABLE `admin_config` (
@@ -9,7 +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;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `ban_user_list` (
   `BID` smallint NOT NULL,
@@ -24,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,
@@ -57,7 +56,7 @@ CREATE TABLE `bbs` (
   `gen_ex` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `m_del` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `old_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 `bbs_article_op` (
   `MID` int NOT NULL,
@@ -67,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,
@@ -83,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,
@@ -95,7 +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;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `email` (
   `ID` int NOT NULL,
@@ -110,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,
@@ -119,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,
@@ -151,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,
@@ -175,14 +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;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `section_apply_log` (
   `AID` smallint NOT NULL,
@@ -190,7 +189,7 @@ CREATE TABLE `section_apply_log` (
   `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,
@@ -198,7 +197,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,
@@ -209,7 +208,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,
@@ -231,13 +230,13 @@ CREATE TABLE `section_config` (
   `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,
@@ -249,7 +248,7 @@ CREATE TABLE `section_master` (
   `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;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `section_master_apply` (
   `AID` smallint NOT NULL,
@@ -261,21 +260,21 @@ CREATE TABLE `section_master_apply` (
   `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,
@@ -286,7 +285,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;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_err_login_log` (
   `ID` int NOT NULL,
@@ -294,7 +293,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,
@@ -303,25 +302,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,
@@ -331,7 +331,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,
@@ -339,7 +339,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,
@@ -349,7 +349,7 @@ 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` (
   `SID` varchar(32) NOT NULL DEFAULT '',
@@ -358,7 +358,7 @@ CREATE TABLE `user_online` (
   `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;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_pubinfo` (
   `UID` mediumint NOT NULL DEFAULT '0',
@@ -380,8 +380,8 @@ 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,
-) 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',
@@ -390,21 +390,21 @@ CREATE TABLE `user_reginfo` (
   `signup_dt` datetime DEFAULT NULL,
   `signup_ip` varchar(20) DEFAULT NULL,
   `memo` mediumtext
-) 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;
+) 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,
@@ -412,19 +412,19 @@ 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;
+) 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;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 
 ALTER TABLE `admin_config`
@@ -609,7 +609,7 @@ 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 `last_login_dt` (`last_login_dt`);
 
 ALTER TABLE `user_reginfo`
   ADD PRIMARY KEY (`UID`);
@@ -735,4 +735,3 @@ ALTER TABLE `user_score_log`
 
 ALTER TABLE `visit_log`
   MODIFY `VID` int NOT NULL AUTO_INCREMENT;
-COMMIT;