--- fenglin/TODO/sql/db_stru.sql	2025/04/09 09:58:54	1.12
+++ fenglin/TODO/sql/db_stru.sql	2025/04/11 04:25:34	1.15
@@ -152,17 +152,6 @@ CREATE TABLE `section_class` (
   `sort_order` smallint NOT NULL DEFAULT '10'
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
-CREATE TABLE `section_class_master` (
-  `MID` smallint NOT NULL,
-  `CID` smallint NOT NULL DEFAULT '0',
-  `UID` mediumint NOT NULL DEFAULT '0',
-  `begin_dt` datetime DEFAULT NULL,
-  `end_dt` datetime DEFAULT NULL,
-  `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
-  `memo` text,
-  `major` tinyint UNSIGNED NOT NULL DEFAULT '0'
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
 CREATE TABLE `section_config` (
   `SID` smallint NOT NULL,
   `sname` varchar(20) DEFAULT NULL,
@@ -201,13 +190,6 @@ CREATE TABLE `section_master` (
   `memo` text
 ) 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=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
 CREATE TABLE `send_pass_log` (
   `ID` mediumint NOT NULL,
   `UID` mediumint NOT NULL DEFAULT '0',
@@ -317,7 +299,6 @@ CREATE TABLE `user_pubinfo` (
   `sign_1` mediumtext,
   `sign_2` mediumtext,
   `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=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
@@ -331,13 +312,6 @@ CREATE TABLE `user_reginfo` (
   `memo` mediumtext
 ) 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=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',
@@ -441,11 +415,6 @@ ALTER TABLE `section_class`
   ADD PRIMARY KEY (`CID`),
   ADD KEY `sort_order` (`sort_order`);
 
-ALTER TABLE `section_class_master`
-  ADD PRIMARY KEY (`MID`),
-  ADD KEY `UID` (`UID`),
-  ADD KEY `CID` (`CID`);
-
 ALTER TABLE `section_config`
   ADD PRIMARY KEY (`SID`),
   ADD KEY `CID` (`CID`),
@@ -463,10 +432,6 @@ ALTER TABLE `section_master`
   ADD KEY `SID` (`SID`),
   ADD KEY `UID` (`UID`);
 
-ALTER TABLE `section_user_priv`
-  ADD PRIMARY KEY (`SID`,`UID`),
-  ADD KEY `UID` (`UID`);
-
 ALTER TABLE `send_pass_log`
   ADD PRIMARY KEY (`ID`),
   ADD KEY `UID` (`UID`);
@@ -531,10 +496,6 @@ ALTER TABLE `user_pubinfo`
 ALTER TABLE `user_reginfo`
   ADD PRIMARY KEY (`UID`);
 
-ALTER TABLE `user_regverify`
-  ADD PRIMARY KEY (`UID`),
-  ADD UNIQUE KEY `verify_code` (`verify_code`);
-
 ALTER TABLE `user_score`
   ADD PRIMARY KEY (`UID`),
   ADD KEY `score` (`score`);
@@ -590,9 +551,6 @@ ALTER TABLE `journal_index`
 ALTER TABLE `section_class`
   MODIFY `CID` smallint NOT NULL AUTO_INCREMENT;
 
-ALTER TABLE `section_class_master`
-  MODIFY `MID` smallint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `section_config`
   MODIFY `SID` smallint NOT NULL AUTO_INCREMENT;
 
