-
Notifications
You must be signed in to change notification settings - Fork 0
/
dbmigration
48 lines (44 loc) · 1.28 KB
/
dbmigration
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
create table user_type (
UserTypeID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
Description varchar(100)
)
create table acl (
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
ApiName VARCHAR(200) NOT NULL,
userTypeID INT,
Active Boolean NOT NULL,
CONSTRAINT fk_category1 FOREIGN KEY (userTypeID)
REFERENCES user_type(userTypeID)
)
CREATE TABLE users (
UserId INT NOT NULL AUTO_INCREMENT,
Email VARCHAR(100) NOT NULL,
Password VARCHAR(100) NOT NULL,
UserTypeID INT,
CreateDate DATE NOT NULL,
UpdateDate DATE NOT NULL,
Active Boolean NOT NULL,
PRIMARY KEY (userId),
CONSTRAINT fk_category1 FOREIGN KEY (userTypeID)
REFERENCES user_type(userTypeID)
)
CREATE TABLE user_data (
Id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
FirstName VARCHAR(100) NOT NULL,
LastName VARCHAR(100) NOT NULL,
OrganizationName VARCHAR(100) NOT NULL,
UserId INT,
CreateDate DATE NOT NULL,
UpdateDate DATE NOT NULL,
Active Boolean NOT NULL,
CONSTRAINT fk_category2 FOREIGN KEY (userId)
REFERENCES users(userId)
)
CREATE TABLE token (
Id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
Token VARCHAR(500),
UserId INT,
CreateDate DATE NOT NULL,
CONSTRAINT fk_category3 FOREIGN KEY (userId)
REFERENCES users(userId)
)