| 1 |
sysadm |
1.1 |
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
| 2 |
|
|
START TRANSACTION;
|
| 3 |
|
|
SET time_zone = "+00:00";
|
| 4 |
|
|
|
| 5 |
|
|
INSERT INTO `admin_config` (`AID`, `UID`, `begin_dt`, `end_dt`, `enable`, `major`) VALUES
|
| 6 |
|
|
(1, 1, '2026-01-01 00:00:00', '2036-01-01 00:00:00', 1, 1);
|
| 7 |
|
|
|
| 8 |
|
|
INSERT INTO `section_class` (`CID`, `cname`, `title`, `enable`, `sort_order`) VALUES
|
| 9 |
|
|
(1, 'SYS', '系统管理', 1, 10);
|
| 10 |
|
|
|
| 11 |
|
|
INSERT INTO `section_config` (`SID`, `sname`, `CID`, `title`, `comment`, `topic_retention`, `announcement`, `enable`, `exp_get`, `recommend`, `set_UID`, `set_dt`, `set_ip`, `sort_order`, `ex_gen_tm`, `ex_update`, `ex_menu_tm`, `ex_menu_update`, `read_user_level`, `write_user_level`) VALUES
|
| 12 |
|
|
(1, 'SYSOP', 1, '论坛管理', '', 0, '', 1, 1, 1, 1, '2026-01-01 00:00:00', '127.0.0.1', 1, NULL, 1, NULL, 1, 0, 1),
|
| 13 |
|
|
(2, 'Test', 1, '测试区', '', 0, '', 1, 0, 0, 1, '2026-01-01 00:00:00', '127.0.0.1', 2, NULL, 1, NULL, 1, 1, 1);
|
| 14 |
|
|
|
| 15 |
|
|
INSERT INTO `section_favorite` (`ID`, `UID`, `SID`) VALUES
|
| 16 |
|
|
(3, 1, 1);
|
| 17 |
|
|
|
| 18 |
|
|
INSERT INTO `section_master` (`MID`, `SID`, `UID`, `begin_dt`, `end_dt`, `enable`, `major`, `memo`) VALUES
|
| 19 |
|
|
(1, 1, 1, '2026-01-01 00:00:00', '2036-01-01 00:00:00', 1, 1, NULL);
|
| 20 |
|
|
|
| 21 |
|
|
INSERT INTO `user_list` (`UID`, `username`, `password`, `temp_password`, `enable`, `verified`, `p_login`, `p_post`, `p_msg`) VALUES
|
| 22 |
|
|
(1, 'sysop', '55b8624bb2d098bf1c01a7ad884f0037244ac4bd08b447462cb8b00000e954ba', '', 1, 1, 1, 1, 1);
|
| 23 |
|
|
|
| 24 |
|
|
INSERT INTO `user_nickname` (`NID`, `UID`, `nickname`, `begin_dt`, `begin_reason`, `end_dt`, `end_reason`) VALUES
|
| 25 |
|
|
(1, 1, '懂王', '2026-01-01 00:00:00', 'R', NULL, NULL);
|
| 26 |
|
|
|
| 27 |
|
|
INSERT INTO `user_pubinfo` (`UID`, `nickname`, `email`, `gender`, `qq`, `introduction`, `photo`, `photo_enable`, `photo_ext`, `life`, `exp`, `visit_count`, `gender_pub`, `last_login_dt`, `last_logout_dt`, `sign_1`, `sign_2`, `sign_3`, `upload_limit`, `login_notify_dt`, `user_timezone`, `game_money`) VALUES
|
| 28 |
|
|
(1, '懂王', 'zhangsan@example.com', 'M', '', '', 0, 0, '', 150, 0, 4, 1, '2026-01-01 00:00:00', '2026-01-01 00:00:00', '', '', '', 1048576, NULL, 'Asia/Shanghai', 0);
|
| 29 |
|
|
|
| 30 |
|
|
INSERT INTO `user_reginfo` (`UID`, `name`, `birthday`, `signup_dt`, `signup_ip`, `memo`) VALUES
|
| 31 |
|
|
(1, '张三', '1995-09-01 00:00:00', '2026-01-01 00:00:00', '127.0.0.1', NULL);
|
| 32 |
|
|
COMMIT;
|
Parent Directory
| 
Revision Log