-
Notifications
You must be signed in to change notification settings - Fork 0
/
sql-schema.sql
52 lines (52 loc) · 1.76 KB
/
sql-schema.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
--===============init users======================
CREATE TABLE `banksalerrest`.`users` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`login_name` VARCHAR(64),
`login_password` VARCHAR(64),
`real_name` VARCHAR(32),
`mobile` VARCHAR(16),
`department` INTEGER UNSIGNED,
`user_code` VARCHAR(8),
`is_active` INT(1) UNSIGNED,
PRIMARY KEY (`id`)
)
--==================================================
--================init auth_key=====================
CREATE TABLE `banksalerrest`.`auth_key` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INTEGER UNSIGNED,
`auth_key` VARCHAR(64),
PRIMARY KEY (`id`)
)
--==================================================
--================init role_permission==============
CREATE TABLE `banksalerrest`.`role_permission` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`role_id` INTEGER UNSIGNED,
`permission_id` INTEGER UNSIGNED,
PRIMARY KEY (`id`)
)
--==================================================
--================init permissions==================
CREATE TABLE `banksalerrest`.`permissions` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`permission_name` VARCHAR(64),
`code_name` VARCHAR(32),
PRIMARY KEY (`id`)
)
--==================================================
--================init opera========================
CREATE TABLE `banksalerrest`.`opera` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`opera_name` VARCHAR(64),
PRIMARY KEY (`id`)
)
--==================================================
--================init opera_permission=============
CREATE TABLE `banksalerrest`.`opera_permission` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`permission_id` INTEGER UNSIGNED,
`opera_id` INTEGER UNSIGNED,
PRIMARY KEY (`id`)
)
--==================================================