--- fenglin/TODO/sql/db_stru.sql	2025/04/11 04:25:34	1.15
+++ fenglin/TODO/sql/db_stru.sql	2025/04/19 06:55:53	1.17
@@ -52,7 +52,6 @@ CREATE TABLE `bbs` (
   `excerption` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `ontop` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `static` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `recommend` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `gen_ex` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `m_del` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `old_SID` smallint NOT NULL DEFAULT '0'
@@ -74,16 +73,6 @@ CREATE TABLE `bbs_content` (
   `content` longtext
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
-CREATE TABLE `bbs_ex_dl` (
-  `ID` mediumint NOT NULL,
-  `SID` smallint NOT NULL DEFAULT '0',
-  `url` varchar(255) DEFAULT NULL,
-  `dl_count` mediumint NOT NULL DEFAULT '0',
-  `dl_type` char(1) NOT NULL DEFAULT 'C',
-  `filename` varchar(50) DEFAULT NULL,
-  `enable` tinyint UNSIGNED NOT NULL DEFAULT '1'
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
 CREATE TABLE `bbs_msg` (
   `MID` int NOT NULL,
   `fromUID` mediumint NOT NULL DEFAULT '0',
@@ -131,19 +120,6 @@ CREATE TABLE `friend_list` (
   `fUID` mediumint NOT NULL DEFAULT '0'
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
-CREATE TABLE `journal_data` (
-  `ID` mediumint NOT NULL,
-  `JID` smallint NOT NULL DEFAULT '0',
-  `AID` mediumint NOT NULL DEFAULT '0',
-  `abstract` longtext NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
-CREATE TABLE `journal_index` (
-  `JID` smallint NOT NULL,
-  `dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  `enable` tinyint(1) NOT NULL DEFAULT '0'
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
 CREATE TABLE `section_class` (
   `CID` smallint NOT NULL,
   `cname` varchar(20) DEFAULT NULL,
@@ -375,11 +351,6 @@ ALTER TABLE `bbs_content`
   ADD PRIMARY KEY (`CID`),
   ADD KEY `AID` (`AID`);
 
-ALTER TABLE `bbs_ex_dl`
-  ADD PRIMARY KEY (`ID`),
-  ADD UNIQUE KEY `SID` (`SID`),
-  ADD KEY `dl_type` (`dl_type`);
-
 ALTER TABLE `bbs_msg`
   ADD PRIMARY KEY (`MID`),
   ADD KEY `fromUID` (`fromUID`),
@@ -403,14 +374,6 @@ ALTER TABLE `friend_list`
   ADD KEY `fUID` (`fUID`),
   ADD KEY `UID` (`UID`);
 
-ALTER TABLE `journal_data`
-  ADD PRIMARY KEY (`ID`),
-  ADD UNIQUE KEY `AID` (`AID`),
-  ADD KEY `JID` (`JID`);
-
-ALTER TABLE `journal_index`
-  ADD PRIMARY KEY (`JID`);
-
 ALTER TABLE `section_class`
   ADD PRIMARY KEY (`CID`),
   ADD KEY `sort_order` (`sort_order`);
@@ -527,9 +490,6 @@ ALTER TABLE `bbs_article_op`
 ALTER TABLE `bbs_content`
   MODIFY `CID` int NOT NULL AUTO_INCREMENT;
 
-ALTER TABLE `bbs_ex_dl`
-  MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `bbs_msg`
   MODIFY `MID` int NOT NULL AUTO_INCREMENT;
 
@@ -542,12 +502,6 @@ ALTER TABLE `ex_dir`
 ALTER TABLE `friend_list`
   MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
 
-ALTER TABLE `journal_data`
-  MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
-
-ALTER TABLE `journal_index`
-  MODIFY `JID` smallint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `section_class`
   MODIFY `CID` smallint NOT NULL AUTO_INCREMENT;