--- fenglin/TODO/sql/db_stru.sql 2025/04/11 04:06:44 1.14 +++ 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, @@ -426,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`), @@ -567,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;