--- fenglin/TODO/sql/db_stru.sql 2025/03/08 03:30:08 1.6 +++ fenglin/TODO/sql/db_stru.sql 2025/03/08 03:32:32 1.7 @@ -392,16 +392,6 @@ CREATE TABLE `user_online` ( `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; - CREATE TABLE `user_pubinfo` ( `UID` mediumint NOT NULL DEFAULT '0', `nickname` varchar(20) DEFAULT NULL, @@ -696,12 +686,6 @@ ALTER TABLE `user_online` 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`); - ALTER TABLE `user_pubinfo` ADD PRIMARY KEY (`UID`), ADD UNIQUE KEY `nickname` (`nickname`), @@ -852,9 +836,6 @@ ALTER TABLE `user_nickname` 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;