FilesExpand file tree

 develop

/

init.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

23 lines (21 loc) · 759 Bytes

 develop

/

init.sql

Copy path

Top

File metadata and controls

• Code
• Blame

23 lines (21 loc) · 759 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

CREATE TABLE `g_authority` (

`id` int(11) NOT NULL,

`auth_id` int(11) DEFAULT NULL,

`auth_name` varchar(45) DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `IDX_AUTHORITY` (`auth_id`,`auth_name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `g_users` (

`id` int(11) NOT NULL COMMENT 'Id，自增主键',

`user_id` int(11) DEFAULT NULL COMMENT '用户id',

`user_name` varchar(45) DEFAULT NULL COMMENT '用户名称',

PRIMARY KEY (`id`),

KEY `IDX_USER_ID` (`user_id`,`user_name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `r_auth_user` (

`id` int(11) NOT NULL,

`user_id` int(11) DEFAULT NULL,

`auth_id` int(11) DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `IDX_USER_AUTH` (`user_id`,`auth_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;