--- fenglin/TODO/sql/db_stru.sql	2025/03/03 06:43:40	1.4
+++ fenglin/TODO/sql/db_stru.sql	2025/03/08 02:58:02	1.5
@@ -479,14 +479,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 +518,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`);
@@ -768,11 +734,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 +759,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;
 
@@ -928,9 +873,6 @@ ALTER TABLE `user_prize`
 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 +884,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;
