/[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.6 by sysadm, Sat Mar 8 03:30:08 2025 UTC Revision 1.7 by sysadm, Sat Mar 8 03:32:32 2025 UTC
# Line 392  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 696  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 852  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    

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