/[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.5 by sysadm, Sat Mar 8 02:58:02 2025 UTC Revision 1.6 by sysadm, Sat Mar 8 03:30:08 2025 UTC
# Line 105  CREATE TABLE `bbs_msg` ( Line 105  CREATE TABLE `bbs_msg` (
105    `s_deleted` tinyint UNSIGNED NOT NULL DEFAULT '0'    `s_deleted` tinyint UNSIGNED NOT NULL DEFAULT '0'
106  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
107    
 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;  
   
108  CREATE TABLE `bbs_top_list` (  CREATE TABLE `bbs_top_list` (
109    `AID` int NOT NULL DEFAULT '0',    `AID` int NOT NULL DEFAULT '0',
110    `bbs_title` varchar(80) NOT NULL DEFAULT '',    `bbs_title` varchar(80) NOT NULL DEFAULT '',
# Line 567  ALTER TABLE `bbs_msg` Line 558  ALTER TABLE `bbs_msg`
558    ADD KEY `fromUID` (`fromUID`),    ADD KEY `fromUID` (`fromUID`),
559    ADD KEY `toUID` (`toUID`);    ADD KEY `toUID` (`toUID`);
560    
 ALTER TABLE `bbs_prize`  
   ADD PRIMARY KEY (`PID`);  
   
561  ALTER TABLE `email`  ALTER TABLE `email`
562    ADD PRIMARY KEY (`ID`),    ADD PRIMARY KEY (`ID`),
563    ADD KEY `complete` (`complete`);    ADD KEY `complete` (`complete`);
# Line 783  ALTER TABLE `bbs_ex_dl` Line 771  ALTER TABLE `bbs_ex_dl`
771  ALTER TABLE `bbs_msg`  ALTER TABLE `bbs_msg`
772    MODIFY `MID` int NOT NULL AUTO_INCREMENT;    MODIFY `MID` int NOT NULL AUTO_INCREMENT;
773    
 ALTER TABLE `bbs_prize`  
   MODIFY `PID` smallint NOT NULL AUTO_INCREMENT;  
   
774  ALTER TABLE `email`  ALTER TABLE `email`
775    MODIFY `ID` int NOT NULL AUTO_INCREMENT;    MODIFY `ID` int NOT NULL AUTO_INCREMENT;
776    

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