--- fenglin/TODO/sql/db_stru.sql	2025/03/08 02:58:02	1.5
+++ fenglin/TODO/sql/db_stru.sql	2025/03/08 03:32:32	1.7
@@ -105,15 +105,6 @@ CREATE TABLE `bbs_msg` (
   `s_deleted` tinyint UNSIGNED NOT NULL DEFAULT '0'
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
-CREATE TABLE `bbs_prize` (
-  `PID` smallint NOT NULL,
-  `title` varchar(50) DEFAULT NULL,
-  `description` varchar(50) DEFAULT NULL,
-  `score` mediumint NOT NULL DEFAULT '0',
-  `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
-  `count_left` mediumint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
 CREATE TABLE `bbs_top_list` (
   `AID` int NOT NULL DEFAULT '0',
   `bbs_title` varchar(80) NOT NULL DEFAULT '',
@@ -401,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,
@@ -567,9 +548,6 @@ ALTER TABLE `bbs_msg`
   ADD KEY `fromUID` (`fromUID`),
   ADD KEY `toUID` (`toUID`);
 
-ALTER TABLE `bbs_prize`
-  ADD PRIMARY KEY (`PID`);
-
 ALTER TABLE `email`
   ADD PRIMARY KEY (`ID`),
   ADD KEY `complete` (`complete`);
@@ -708,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`),
@@ -783,9 +755,6 @@ ALTER TABLE `bbs_ex_dl`
 ALTER TABLE `bbs_msg`
   MODIFY `MID` int NOT NULL AUTO_INCREMENT;
 
-ALTER TABLE `bbs_prize`
-  MODIFY `PID` smallint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `email`
   MODIFY `ID` int NOT NULL AUTO_INCREMENT;
 
@@ -867,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;
 
