@@ -11,7 +11,7 @@ CREATE TABLE `system_menu` (
11
11
` Class` VARCHAR (100 ) CHARACTER SET utf8 DEFAULT NULL COMMENT ' 样式' ,
12
12
PRIMARY KEY (` Tid` ),
13
13
KEY ` idx_DataChange_LastTime` (` DataChangeLastTime` )
14
- ) ENGINE= INNODB AUTO_INCREMENT= 17 DEFAULT CHARSET= utf8 COMMENT= ' 系统菜单表'
14
+ ) ENGINE= INNODB AUTO_INCREMENT= 17 DEFAULT CHARSET= utf8 COMMENT= ' 系统菜单表' ;
15
15
16
16
17
17
CREATE TABLE `system_page_action ` (
@@ -22,7 +22,7 @@ CREATE TABLE `system_page_action` (
22
22
` ActionName` VARCHAR (255 ) DEFAULT NULL COMMENT ' ActionName' ,
23
23
` ControlName` VARCHAR (255 ) DEFAULT NULL COMMENT ' ControlName' ,
24
24
PRIMARY KEY (` Tid` )
25
- ) ENGINE= INNODB DEFAULT CHARSET= utf8 COMMENT= ' 菜单按钮'
25
+ ) ENGINE= INNODB DEFAULT CHARSET= utf8 COMMENT= ' 菜单按钮' ;
26
26
27
27
28
28
@@ -39,7 +39,7 @@ CREATE TABLE `system_role` (
39
39
PRIMARY KEY (` Tid` ),
40
40
UNIQUE KEY ` idx_RoleName` (` RoleName` ),
41
41
KEY ` idx_DataChange_LastTime` (` DataChangeLastTime` )
42
- ) ENGINE= INNODB AUTO_INCREMENT= 7 DEFAULT CHARSET= utf8 COMMENT= ' 角色表'
42
+ ) ENGINE= INNODB AUTO_INCREMENT= 7 DEFAULT CHARSET= utf8 COMMENT= ' 角色表' ;
43
43
44
44
45
45
@@ -62,7 +62,7 @@ CREATE TABLE `system_users` (
62
62
UNIQUE KEY ` idx_Eid` (` Eid` ),
63
63
KEY ` idx_roleTid` (` RoleTid` ),
64
64
KEY ` idx_DataChange_LastTime` (` DataChangeLastTime` )
65
- ) ENGINE= INNODB DEFAULT CHARSET= utf8 COMMENT= ' 后台系统用户表'
65
+ ) ENGINE= INNODB DEFAULT CHARSET= utf8 COMMENT= ' 后台系统用户表' ;
66
66
67
67
68
68
@@ -72,22 +72,22 @@ insert into `system_menu` (`Tid`,`DataChangeLastTime`, `IsActive`, `ParentTid`,
72
72
73
73
insert into ` system_menu` (` DataChangeLastTime` , ` IsActive` , ` ParentTid` , ` Name` , ` Ico` , ` Url` , ` OrderRule` , ` Level` , ` Class` )
74
74
values
75
- (now(),' 1' ,' 1' ,' 菜单管理' ,NULL ,' ~/Home/MenuList' ,' 1' ,' 2' ,NULL );
75
+ (now(),' 1' ,' 1' ,' 菜单管理' ,NULL ,' ~/Admin/ Home/MenuList' ,' 1' ,' 2' ,NULL );
76
76
77
77
insert into ` system_menu` (` DataChangeLastTime` , ` IsActive` , ` ParentTid` , ` Name` , ` Ico` , ` Url` , ` OrderRule` , ` Level` , ` Class` )
78
- values (now(),' 1' ,' 1' ,' 权限配置' ,NULL ,' ~/Role/RoleAction' ,' 2' ,' 2' ,NULL );
78
+ values (now(),' 1' ,' 1' ,' 权限配置' ,NULL ,' ~/Admin/ Role/RoleAction' ,' 2' ,' 2' ,NULL );
79
79
80
80
insert into ` system_menu` (` DataChangeLastTime` , ` IsActive` , ` ParentTid` , ` Name` , ` Ico` , ` Url` , ` OrderRule` , ` Level` , ` Class` )
81
- values (now(),' 1' ,' 1' ,' 角色管理' ,NULL ,' ~/Role/RoleList' ,' 3' ,' 2' ,NULL );
81
+ values (now(),' 1' ,' 1' ,' 角色管理' ,NULL ,' ~/Admin/ Role/RoleList' ,' 3' ,' 2' ,NULL );
82
82
83
83
insert into ` system_menu` (` DataChangeLastTime` , ` IsActive` , ` ParentTid` , ` Name` , ` Ico` , ` Url` , ` OrderRule` , ` Level` , ` Class` )
84
- values (now(),' 1' ,' 1' ,' 系统用户' ,NULL ,' ~/Account/UserList' ,' 4' ,' 2' ,NULL );
84
+ values (now(),' 1' ,' 1' ,' 系统用户' ,NULL ,' ~/Admin/ Account/UserList' ,' 4' ,' 2' ,NULL );
85
85
86
86
insert into ` system_menu` (` DataChangeLastTime` , ` IsActive` , ` ParentTid` , ` Name` , ` Ico` , ` Url` , ` OrderRule` , ` Level` , ` Class` )
87
- values (now(),' 1' ,' 1' ,' 代码生成' ,NULL ,' ~/Common/CodeGen' ,' 5' ,' 2' ,NULL );
87
+ values (now(),' 1' ,' 1' ,' 代码生成' ,NULL ,' ~/Admin/ Common/CodeGen' ,' 5' ,' 2' ,NULL );
88
88
89
89
INSERT INTO ` system_users`
90
90
(` DataChangeLastTime` , ` IsActive` , ` Eid` , ` UserName` , ` Pwd` , ` Phone` , ` LoginIp` , ` MenuRights` , ` RoleTid` , ` LastLoginTime` , ` UserAgent` , ` CreateRoleName` , ` CreateUser` )
91
- VALUES (NOW(),' 1' ,' zdyu' ,' admin' ,' e10adc3949ba59abbe56e057f20f883e' ,' 13000000000' ,' 114.80.11.236' ,NULL ,' 0' ,' 2019-05-15 12:22:52' ,' Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36 ' ,NULL ,' ' );
91
+ VALUES (NOW(),' 1' ,' zdyu' ,' admin' ,' e10adc3949ba59abbe56e057f20f883e' ,' 13000000000' ,' 114.80.11.236' ,NULL ,' 0' ,' 2019-05-15 12:22:52' ,' Mozilla/5.0' ,NULL ,' ' );
92
92
93
93
0 commit comments