forked from eamonmckelvey/goodlife
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSQL Dump.txt
27 lines (25 loc) · 1012 Bytes
/
SQL Dump.txt
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
DROP TABLE IF EXISTS auth_user_role;
DROP TABLE IF EXISTS auth_role;
DROP TABLE IF EXISTS auth_user;
CREATE TABLE auth_role (
auth_role_id int(11) NOT NULL AUTO_INCREMENT,
role_name varchar(255) DEFAULT NULL,
role_desc varchar(255) DEFAULT NULL,
PRIMARY KEY (auth_role_id)
);
INSERT INTO auth_role VALUES (1,'SUPER_USER','This user has ultimate rights for everything');
INSERT INTO auth_role VALUES (2,'ADMIN_USER','This user has admin rights for administrative work');
INSERT INTO auth_role VALUES (3,'SITE_USER','This user has access to site, after login - normal user');
CREATE TABLE auth_user (
auth_user_id int(11) NOT NULL AUTO_INCREMENT,
first_name varchar(255) NOT NULL,
last_name varchar(255) NOT NULL,
email varchar(255) NOT NULL,
password varchar(255) NOT NULL,
status varchar(255),
PRIMARY KEY (auth_user_id)
);
CREATE TABLE auth_user_role (
auth_user_id int(11) NOT NULL,
auth_role_id int(11) NOT NULL,
PRIMARY KEY (auth_user_id,auth_role_id),