/[LeafOK_CVS]/fenglin/TODO/sql/sample_data.sql
ViewVC logotype

Annotation of /fenglin/TODO/sql/sample_data.sql

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.2 - (hide annotations)
Tue Jan 6 02:41:36 2026 UTC (2 months, 1 week ago) by sysadm
Branch: MAIN
CVS Tags: HEAD
Changes since 1.1: +1 -1 lines
Content type: application/sql 
Update
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 sysadm 1.2 (1, 'sysop', '', '55b8624bb2d098bf1c01a7ad884f0037244ac4bd08b447462cb8b00000e954ba', 1, 1, 1, 1, 1);
23 sysadm 1.1
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;
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1