--- 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;
 
