--- fenglin/TODO/sql/db_stru.sql	2025/03/03 06:43:40	1.4
+++ 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,
@@ -479,14 +460,6 @@ CREATE TABLE `user_regverify` (
   `set_dt` datetime DEFAULT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
-CREATE TABLE `user_relation` (
-  `RID` mediumint NOT NULL,
-  `pUID` mediumint NOT NULL DEFAULT '0',
-  `cUID` mediumint NOT NULL DEFAULT '0',
-  `enable` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `last_exp` mediumint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
 CREATE TABLE `user_score` (
   `UID` mediumint NOT NULL DEFAULT '0',
   `score` mediumint NOT NULL DEFAULT '0',
@@ -526,32 +499,6 @@ CREATE TABLE `visit_log` (
   `ip` varchar(20) DEFAULT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
-CREATE TABLE `vote_answer` (
-  `AID` smallint NOT NULL,
-  `VID` smallint NOT NULL DEFAULT '0',
-  `answer` varchar(100) DEFAULT NULL,
-  `count` smallint NOT NULL DEFAULT '0'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `vote_config` (
-  `VID` smallint NOT NULL,
-  `title` varchar(20) DEFAULT NULL,
-  `question` varchar(100) DEFAULT NULL,
-  `begin_dt` datetime DEFAULT NULL,
-  `end_dt` datetime DEFAULT NULL,
-  `enable` tinyint UNSIGNED NOT NULL DEFAULT '1'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `vote_log` (
-  `ID` mediumint NOT NULL,
-  `UID` mediumint NOT NULL DEFAULT '0',
-  `VID` smallint NOT NULL DEFAULT '0',
-  `AID` smallint NOT NULL DEFAULT '0',
-  `vote_dt` datetime DEFAULT NULL,
-  `vote_ip` varchar(20) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-
 ALTER TABLE `admin_config`
   ADD PRIMARY KEY (`AID`),
   ADD KEY `UID` (`UID`);
@@ -601,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`);
@@ -742,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`),
@@ -768,11 +706,6 @@ ALTER TABLE `user_regverify`
   ADD PRIMARY KEY (`UID`),
   ADD UNIQUE KEY `verify_code` (`verify_code`);
 
-ALTER TABLE `user_relation`
-  ADD PRIMARY KEY (`RID`),
-  ADD UNIQUE KEY `cUID` (`cUID`),
-  ADD KEY `pUID` (`pUID`);
-
 ALTER TABLE `user_score`
   ADD PRIMARY KEY (`UID`),
   ADD KEY `score` (`score`);
@@ -798,22 +731,6 @@ ALTER TABLE `view_article_log`
 ALTER TABLE `visit_log`
   ADD PRIMARY KEY (`VID`);
 
-ALTER TABLE `vote_answer`
-  ADD PRIMARY KEY (`AID`),
-  ADD KEY `VID` (`VID`);
-
-ALTER TABLE `vote_config`
-  ADD PRIMARY KEY (`VID`),
-  ADD KEY `begin_dt` (`begin_dt`),
-  ADD KEY `end_dt` (`end_dt`);
-
-ALTER TABLE `vote_log`
-  ADD PRIMARY KEY (`ID`),
-  ADD KEY `UID` (`UID`),
-  ADD KEY `VID` (`VID`),
-  ADD KEY `AID` (`AID`);
-
-
 ALTER TABLE `admin_config`
   MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
 
@@ -838,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;
 
@@ -922,15 +836,9 @@ 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;
 
-ALTER TABLE `user_relation`
-  MODIFY `RID` mediumint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `user_score_log`
   MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
 
@@ -942,12 +850,3 @@ ALTER TABLE `user_trust_log`
 
 ALTER TABLE `visit_log`
   MODIFY `VID` int NOT NULL AUTO_INCREMENT;
-
-ALTER TABLE `vote_answer`
-  MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
-
-ALTER TABLE `vote_config`
-  MODIFY `VID` smallint NOT NULL AUTO_INCREMENT;
-
-ALTER TABLE `vote_log`
-  MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
