--- fenglin/TODO/sql/db_stru.sql	2025/03/28 12:04:46	1.8
+++ fenglin/TODO/sql/db_stru.sql	2025/03/31 14:18:20	1.9
@@ -219,7 +219,6 @@ CREATE TABLE `section_config` (
   `comment` varchar(255) DEFAULT NULL,
   `topic_retention` smallint NOT NULL DEFAULT '0',
   `announcement` longtext,
-  `bgsound` smallint NOT NULL DEFAULT '0',
   `enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
   `exp_get` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `recommend` tinyint UNSIGNED NOT NULL DEFAULT '0',
@@ -289,20 +288,6 @@ CREATE TABLE `upload_file` (
   `deleted` tinyint UNSIGNED NOT NULL DEFAULT '0'
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
-CREATE TABLE `user_auth` (
-  `AUID` mediumint NOT NULL,
-  `UID` mediumint NOT NULL DEFAULT '0',
-  `pid` varchar(18) DEFAULT NULL,
-  `name` varchar(10) DEFAULT NULL,
-  `email` varchar(30) DEFAULT NULL,
-  `expire_dt` datetime DEFAULT NULL,
-  `photo_enable` tinyint UNSIGNED NOT NULL DEFAULT '1',
-  `photo_ext` varchar(5) NOT NULL DEFAULT '',
-  `enable` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `process` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `auth_type` enum('PID','EMAIL','TRUST','SCORE') NOT NULL DEFAULT 'TRUST'
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
 CREATE TABLE `user_err_login_log` (
   `ID` int NOT NULL,
   `username` varchar(14) DEFAULT NULL,
@@ -381,8 +366,6 @@ CREATE TABLE `user_pubinfo` (
   `email` varchar(30) DEFAULT NULL,
   `gender` char(1) NOT NULL DEFAULT 'M',
   `qq` varchar(10) DEFAULT NULL,
-  `msn` varchar(30) DEFAULT NULL,
-  `homepage` varchar(80) DEFAULT NULL,
   `introduction` mediumtext,
   `photo` smallint DEFAULT '0',
   `photo_enable` tinyint(1) NOT NULL DEFAULT '0',
@@ -390,10 +373,6 @@ CREATE TABLE `user_pubinfo` (
   `life` smallint NOT NULL DEFAULT '15',
   `exp` mediumint DEFAULT '0',
   `visit_count` mediumint NOT NULL DEFAULT '0',
-  `email_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `qq_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `msn_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
-  `homepage_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `gender_pub` tinyint UNSIGNED NOT NULL DEFAULT '0',
   `last_login_dt` datetime DEFAULT NULL,
   `sign_1` mediumtext,
@@ -402,40 +381,17 @@ CREATE TABLE `user_pubinfo` (
   `sub_permission` tinyint UNSIGNED NOT NULL DEFAULT '1',
   `upload_limit` int NOT NULL DEFAULT '1048576',
   `login_notify_dt` datetime DEFAULT NULL,
-  `subscribe_jid` smallint NOT NULL DEFAULT '-1',
-  `bgsound` tinyint(1) NOT NULL DEFAULT '1'
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
 CREATE TABLE `user_reginfo` (
   `UID` mediumint NOT NULL DEFAULT '0',
   `name` varchar(10) DEFAULT NULL,
   `birthday` datetime DEFAULT NULL,
-  `address` varchar(80) DEFAULT NULL,
-  `tel` varchar(20) DEFAULT NULL,
-  `postcode` varchar(6) DEFAULT NULL,
-  `pid` varchar(18) DEFAULT NULL,
-  `country` varchar(10) DEFAULT NULL,
-  `province` varchar(10) DEFAULT NULL,
-  `city` varchar(10) DEFAULT NULL,
   `signup_dt` datetime DEFAULT NULL,
   `signup_ip` varchar(20) DEFAULT NULL,
   `memo` mediumtext
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 
-CREATE TABLE `user_reginfo_log` (
-  `ID` mediumint NOT NULL,
-  `UID` mediumint NOT NULL DEFAULT '0',
-  `name` varchar(10) DEFAULT NULL,
-  `birthday` date DEFAULT NULL,
-  `address` varchar(80) DEFAULT NULL,
-  `tel` varchar(20) DEFAULT NULL,
-  `postcode` varchar(6) DEFAULT NULL,
-  `pid` varchar(18) DEFAULT NULL,
-  `country` varchar(10) DEFAULT NULL,
-  `province` varchar(10) DEFAULT NULL,
-  `city` varchar(10) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-
 CREATE TABLE `user_regverify` (
   `UID` mediumint NOT NULL DEFAULT '0',
   `verify_code` varchar(10) NOT NULL DEFAULT '',
@@ -604,12 +560,6 @@ ALTER TABLE `upload_file`
   ADD KEY `UID` (`UID`),
   ADD KEY `ref_AID` (`ref_AID`);
 
-ALTER TABLE `user_auth`
-  ADD PRIMARY KEY (`AUID`),
-  ADD KEY `UID` (`UID`),
-  ADD KEY `expire_dt` (`expire_dt`),
-  ADD KEY `auth_type` (`auth_type`);
-
 ALTER TABLE `user_err_login_log`
   ADD PRIMARY KEY (`ID`),
   ADD KEY `login_dt` (`login_dt`,`login_ip`);
@@ -660,15 +610,10 @@ ALTER TABLE `user_pubinfo`
   ADD KEY `login_notify_dt` (`login_notify_dt`),
   ADD KEY `exp` (`exp`),
   ADD KEY `last_login_dt` (`last_login_dt`),
-  ADD KEY `subscribe_jid` (`subscribe_jid`);
 
 ALTER TABLE `user_reginfo`
   ADD PRIMARY KEY (`UID`);
 
-ALTER TABLE `user_reginfo_log`
-  ADD PRIMARY KEY (`ID`),
-  ADD KEY `UID` (`UID`);
-
 ALTER TABLE `user_regverify`
   ADD PRIMARY KEY (`UID`),
   ADD UNIQUE KEY `verify_code` (`verify_code`);
@@ -764,9 +709,6 @@ ALTER TABLE `send_pass_log`
 ALTER TABLE `upload_file`
   MODIFY `AID` mediumint NOT NULL AUTO_INCREMENT;
 
-ALTER TABLE `user_auth`
-  MODIFY `AUID` mediumint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `user_err_login_log`
   MODIFY `ID` int NOT NULL AUTO_INCREMENT;
 
@@ -788,9 +730,6 @@ ALTER TABLE `user_modify_log`
 ALTER TABLE `user_nickname`
   MODIFY `NID` mediumint NOT NULL AUTO_INCREMENT;
 
-ALTER TABLE `user_reginfo_log`
-  MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
-
 ALTER TABLE `user_score_log`
   MODIFY `ID` mediumint NOT NULL AUTO_INCREMENT;
 
