/[LeafOK_CVS]/fenglin/TODO/sql/db_stru.sql
ViewVC logotype

Diff of /fenglin/TODO/sql/db_stru.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

Revision 1.16 by sysadm, Sun Apr 13 05:09:37 2025 UTC Revision 1.17 by sysadm, Sat Apr 19 06:55:53 2025 UTC
# Line 73  CREATE TABLE `bbs_content` ( Line 73  CREATE TABLE `bbs_content` (
73    `content` longtext    `content` longtext
74  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
75    
 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;  
   
76  CREATE TABLE `bbs_msg` (  CREATE TABLE `bbs_msg` (
77    `MID` int NOT NULL,    `MID` int NOT NULL,
78    `fromUID` mediumint NOT NULL DEFAULT '0',    `fromUID` mediumint NOT NULL DEFAULT '0',
# Line 361  ALTER TABLE `bbs_content` Line 351  ALTER TABLE `bbs_content`
351    ADD PRIMARY KEY (`CID`),    ADD PRIMARY KEY (`CID`),
352    ADD KEY `AID` (`AID`);    ADD KEY `AID` (`AID`);
353    
 ALTER TABLE `bbs_ex_dl`  
   ADD PRIMARY KEY (`ID`),  
   ADD UNIQUE KEY `SID` (`SID`),  
   ADD KEY `dl_type` (`dl_type`);  
   
354  ALTER TABLE `bbs_msg`  ALTER TABLE `bbs_msg`
355    ADD PRIMARY KEY (`MID`),    ADD PRIMARY KEY (`MID`),
356    ADD KEY `fromUID` (`fromUID`),    ADD KEY `fromUID` (`fromUID`),
# Line 505  ALTER TABLE `bbs_article_op` Line 490  ALTER TABLE `bbs_article_op`
490  ALTER TABLE `bbs_content`  ALTER TABLE `bbs_content`
491    MODIFY `CID` int NOT NULL AUTO_INCREMENT;    MODIFY `CID` int NOT NULL AUTO_INCREMENT;
492    
 ALTER TABLE `bbs_ex_dl`  
   MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;  
   
493  ALTER TABLE `bbs_msg`  ALTER TABLE `bbs_msg`
494    MODIFY `MID` int NOT NULL AUTO_INCREMENT;    MODIFY `MID` int NOT NULL AUTO_INCREMENT;
495    

Legend:
Removed lines/characters  
Changed lines/characters
  Added lines/characters
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1