/[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.4 by sysadm, Mon Mar 3 06:43:40 2025 UTC Revision 1.7 by sysadm, Sat Mar 8 03:32:32 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 401  CREATE TABLE `user_online` ( Line 392  CREATE TABLE `user_online` (
392    `last_tm` datetime DEFAULT NULL    `last_tm` datetime DEFAULT NULL
393  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
394    
 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;  
   
395  CREATE TABLE `user_pubinfo` (  CREATE TABLE `user_pubinfo` (
396    `UID` mediumint NOT NULL DEFAULT '0',    `UID` mediumint NOT NULL DEFAULT '0',
397    `nickname` varchar(20) DEFAULT NULL,    `nickname` varchar(20) DEFAULT NULL,
# Line 479  CREATE TABLE `user_regverify` ( Line 460  CREATE TABLE `user_regverify` (
460    `set_dt` datetime DEFAULT NULL    `set_dt` datetime DEFAULT NULL
461  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
462    
 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;  
   
463  CREATE TABLE `user_score` (  CREATE TABLE `user_score` (
464    `UID` mediumint NOT NULL DEFAULT '0',    `UID` mediumint NOT NULL DEFAULT '0',
465    `score` mediumint NOT NULL DEFAULT '0',    `score` mediumint NOT NULL DEFAULT '0',
# Line 526  CREATE TABLE `visit_log` ( Line 499  CREATE TABLE `visit_log` (
499    `ip` varchar(20) DEFAULT NULL    `ip` varchar(20) DEFAULT NULL
500  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
501    
 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;  
   
   
502  ALTER TABLE `admin_config`  ALTER TABLE `admin_config`
503    ADD PRIMARY KEY (`AID`),    ADD PRIMARY KEY (`AID`),
504    ADD KEY `UID` (`UID`);    ADD KEY `UID` (`UID`);
# Line 601  ALTER TABLE `bbs_msg` Line 548  ALTER TABLE `bbs_msg`
548    ADD KEY `fromUID` (`fromUID`),    ADD KEY `fromUID` (`fromUID`),
549    ADD KEY `toUID` (`toUID`);    ADD KEY `toUID` (`toUID`);
550    
 ALTER TABLE `bbs_prize`  
   ADD PRIMARY KEY (`PID`);  
   
551  ALTER TABLE `email`  ALTER TABLE `email`
552    ADD PRIMARY KEY (`ID`),    ADD PRIMARY KEY (`ID`),
553    ADD KEY `complete` (`complete`);    ADD KEY `complete` (`complete`);
# Line 742  ALTER TABLE `user_online` Line 686  ALTER TABLE `user_online`
686    ADD KEY `last_tm` (`last_tm`),    ADD KEY `last_tm` (`last_tm`),
687    ADD KEY `SID` (`SID`);    ADD KEY `SID` (`SID`);
688    
 ALTER TABLE `user_prize`  
   ADD PRIMARY KEY (`ID`),  
   ADD KEY `UID` (`UID`),  
   ADD KEY `PID` (`PID`),  
   ADD KEY `process` (`process`);  
   
689  ALTER TABLE `user_pubinfo`  ALTER TABLE `user_pubinfo`
690    ADD PRIMARY KEY (`UID`),    ADD PRIMARY KEY (`UID`),
691    ADD UNIQUE KEY `nickname` (`nickname`),    ADD UNIQUE KEY `nickname` (`nickname`),
# Line 768  ALTER TABLE `user_regverify` Line 706  ALTER TABLE `user_regverify`
706    ADD PRIMARY KEY (`UID`),    ADD PRIMARY KEY (`UID`),
707    ADD UNIQUE KEY `verify_code` (`verify_code`);    ADD UNIQUE KEY `verify_code` (`verify_code`);
708    
 ALTER TABLE `user_relation`  
   ADD PRIMARY KEY (`RID`),  
   ADD UNIQUE KEY `cUID` (`cUID`),  
   ADD KEY `pUID` (`pUID`);  
   
709  ALTER TABLE `user_score`  ALTER TABLE `user_score`
710    ADD PRIMARY KEY (`UID`),    ADD PRIMARY KEY (`UID`),
711    ADD KEY `score` (`score`);    ADD KEY `score` (`score`);
# Line 798  ALTER TABLE `view_article_log` Line 731  ALTER TABLE `view_article_log`
731  ALTER TABLE `visit_log`  ALTER TABLE `visit_log`
732    ADD PRIMARY KEY (`VID`);    ADD PRIMARY KEY (`VID`);
733    
 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`);  
   
   
734  ALTER TABLE `admin_config`  ALTER TABLE `admin_config`
735    MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;    MODIFY `AID` smallint NOT NULL AUTO_INCREMENT;
736    
# Line 838  ALTER TABLE `bbs_ex_dl` Line 755  ALTER TABLE `bbs_ex_dl`
755  ALTER TABLE `bbs_msg`  ALTER TABLE `bbs_msg`
756    MODIFY `MID` int NOT NULL AUTO_INCREMENT;    MODIFY `MID` int NOT NULL AUTO_INCREMENT;
757    
 ALTER TABLE `bbs_prize`  
   MODIFY `PID` smallint NOT NULL AUTO_INCREMENT;  
   
758  ALTER TABLE `email`  ALTER TABLE `email`
759    MODIFY `ID` int NOT NULL AUTO_INCREMENT;    MODIFY `ID` int NOT NULL AUTO_INCREMENT;
760    
# Line 922  ALTER TABLE `user_nickname` Line 836  ALTER TABLE `user_nickname`
836  ALTER TABLE `user_online`  ALTER TABLE `user_online`
837    MODIFY `ID` int NOT NULL AUTO_INCREMENT;    MODIFY `ID` int NOT NULL AUTO_INCREMENT;
838    
 ALTER TABLE `user_prize`  
   MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;  
   
839  ALTER TABLE `user_reginfo_log`  ALTER TABLE `user_reginfo_log`
840    MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;    MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
841    
 ALTER TABLE `user_relation`  
   MODIFY `RID` mediumint NOT NULL AUTO_INCREMENT;  
   
842  ALTER TABLE `user_score_log`  ALTER TABLE `user_score_log`
843    MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;    MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
844    
# Line 942  ALTER TABLE `user_trust_log` Line 850  ALTER TABLE `user_trust_log`
850    
851  ALTER TABLE `visit_log`  ALTER TABLE `visit_log`
852    MODIFY `VID` int NOT NULL AUTO_INCREMENT;    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;  

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