system_setup.sql

来自「Java的框架」· SQL 代码 · 共 71 行

USE PRRM;

INSERT INTO USER (USERNAME, VERSION, PASSWORD, FIRST_NAME, LAST_NAME, ADDRESS, CITY,
									PROVINCE, COUNTRY, POSTAL_CODE, EMAIL, PHONE_NUMBER, WEBSITE, 
									PASSWORD_HINT, ENABLED, EXPIRED, LOCKED, CREDENTIALS_EXPIRED) 
									VALUES 
									('admin', 1, 'd033e22ae348aeb5660fc2140aec35850c4da997', 'admin',
									'admin', 'Ang Mo Kio', 'Singapore', '', 'Singapore', '569061', 
									'[e-mail]', '', '','', '1', '0', '0', '0');

INSERT INTO ROLE (NAME, VERSION, DESCRIPTION) VALUES ('admin', 1, 'Default administrator')
;

INSERT INTO ROLE (NAME, VERSION, DESCRIPTION) VALUES ('member', 1, 'Default role for all user')
;

INSERT INTO USER_ROLE (USERNAME, ROLE_NAME) VALUES ('admin', 'admin')
;

INSERT INTO USER_ROLE (USERNAME, ROLE_NAME) VALUES ('admin', 'member')
;

## ----------------- ROLE REQUIRED BY ALERT

INSERT INTO ROLE (NAME, VERSION, DESCRIPTION) VALUES ('alertAdmin', 1, 'Alert admin role')
;

INSERT INTO USER_ROLE (USERNAME, ROLE_NAME) VALUES ('admin', 'alertAdmin')
;

INSERT INTO ROLE (NAME, VERSION, DESCRIPTION) VALUES ('alertSender', 1, 'Role that can create and send alert to others')
;

INSERT INTO USER_ROLE (USERNAME, ROLE_NAME) VALUES ('admin', 'alertSender')
;
	
## -----------------  ROLE REQUIRED BY REPORTING

INSERT INTO ROLE (NAME, VERSION, DESCRIPTION) VALUES ('reportAdmin', 1, 'Report admin role')
;

INSERT INTO USER_ROLE (USERNAME, ROLE_NAME) VALUES ('admin', 'reportAdmin')
;

## -----------------  ROLE REQUIRED BY SCHEDULING

INSERT INTO ROLE (NAME, VERSION, DESCRIPTION) VALUES ('schedulerAdmin', 1, 'Schedule admin role')
;


INSERT INTO USER_ROLE (USERNAME, ROLE_NAME) VALUES ('admin', 'schedulerAdmin')
;

## ------------------ ROLE REQUIRED BY ROAD DEFECT

INSERT INTO ROLE (NAME, VERSION, DESCRIPTION) VALUES ('roadDefectAdmin', 1, 'Administrator for manage Road Defect')
;

INSERT INTO ROLE (NAME, VERSION, DESCRIPTION) VALUES ('roadDefectCreator', 1, 'Creator role for Road Defect')
;



## -----------------  ROLE REQUIRED BY MAP

INSERT INTO ROLE (NAME, VERSION, DESCRIPTION) VALUES ('mapAdmin', 1, 'Map admin role')
;

INSERT INTO USER_ROLE (USERNAME, ROLE_NAME) VALUES ('admin', 'mapAdmin')
;