| |
| |
| |
| ----------------------------------------------------------------------------- |
| -- TURBINE_PERMISSION |
| ----------------------------------------------------------------------------- |
| drop table TURBINE_PERMISSION cascade constraints; |
| |
| CREATE TABLE TURBINE_PERMISSION |
| ( |
| PERMISSION_ID INT NOT NULL, |
| PERMISSION_NAME VARCHAR2 (99) NOT NULL, |
| OBJECTDATA LONG RAW, |
| UNIQUE (PERMISSION_NAME) |
| ); |
| |
| ALTER TABLE TURBINE_PERMISSION |
| ADD CONSTRAINT TURBINE_PERMISSION_PK |
| PRIMARY KEY (PERMISSION_ID); |
| |
| |
| |
| |
| |
| ----------------------------------------------------------------------------- |
| -- TURBINE_ROLE |
| ----------------------------------------------------------------------------- |
| drop table TURBINE_ROLE cascade constraints; |
| |
| CREATE TABLE TURBINE_ROLE |
| ( |
| ROLE_ID INT NOT NULL, |
| ROLE_NAME VARCHAR2 (99) NOT NULL, |
| OBJECTDATA LONG RAW, |
| UNIQUE (ROLE_NAME) |
| ); |
| |
| ALTER TABLE TURBINE_ROLE |
| ADD CONSTRAINT TURBINE_ROLE_PK |
| PRIMARY KEY (ROLE_ID); |
| |
| |
| |
| |
| |
| ----------------------------------------------------------------------------- |
| -- TURBINE_GROUP |
| ----------------------------------------------------------------------------- |
| drop table TURBINE_GROUP cascade constraints; |
| |
| CREATE TABLE TURBINE_GROUP |
| ( |
| GROUP_ID INT NOT NULL, |
| GROUP_NAME VARCHAR2 (99) NOT NULL, |
| OBJECTDATA LONG RAW, |
| UNIQUE (GROUP_NAME) |
| ); |
| |
| ALTER TABLE TURBINE_GROUP |
| ADD CONSTRAINT TURBINE_GROUP_PK |
| PRIMARY KEY (GROUP_ID); |
| |
| |
| |
| |
| |
| ----------------------------------------------------------------------------- |
| -- TURBINE_ROLE_PERMISSION |
| ----------------------------------------------------------------------------- |
| drop table TURBINE_ROLE_PERMISSION cascade constraints; |
| |
| CREATE TABLE TURBINE_ROLE_PERMISSION |
| ( |
| ROLE_ID INT NOT NULL, |
| PERMISSION_ID INT NOT NULL |
| ); |
| |
| ALTER TABLE TURBINE_ROLE_PERMISSION |
| ADD CONSTRAINT TURBINE_ROLE_PERMISSION_PK |
| PRIMARY KEY (ROLE_ID,PERMISSION_ID); |
| |
| ALTER TABLE TURBINE_ROLE_PERMISSION |
| ADD CONSTRAINT TURBINE_ROLE_PERMISSION_FK_1 FOREIGN KEY (ROLE_ID) |
| REFERENCES TURBINE_ROLE (ROLE_ID) |
| ; |
| |
| ALTER TABLE TURBINE_ROLE_PERMISSION |
| ADD CONSTRAINT TURBINE_ROLE_PERMISSION_FK_2 FOREIGN KEY (PERMISSION_ID) |
| REFERENCES TURBINE_PERMISSION (PERMISSION_ID) |
| ; |
| |
| |
| |
| |
| |
| ----------------------------------------------------------------------------- |
| -- TURBINE_USER |
| ----------------------------------------------------------------------------- |
| drop table TURBINE_USER cascade constraints; |
| |
| CREATE TABLE TURBINE_USER |
| ( |
| USER_ID INT NOT NULL, |
| LOGIN_NAME VARCHAR2 (32) NOT NULL, |
| PASSWORD_VALUE VARCHAR2 (32) NOT NULL, |
| FIRST_NAME VARCHAR2 (99) NOT NULL, |
| LAST_NAME VARCHAR2 (99) NOT NULL, |
| EMAIL VARCHAR2 (99), |
| CONFIRM_VALUE VARCHAR2 (99), |
| MODIFIED DATE, |
| CREATED DATE, |
| LAST_LOGIN DATE, |
| OBJECTDATA LONG RAW, |
| UNIQUE (LOGIN_NAME) |
| ); |
| |
| ALTER TABLE TURBINE_USER |
| ADD CONSTRAINT TURBINE_USER_PK |
| PRIMARY KEY (USER_ID); |
| |
| |
| |
| |
| |
| ----------------------------------------------------------------------------- |
| -- TURBINE_USER_GROUP_ROLE |
| ----------------------------------------------------------------------------- |
| drop table TURBINE_USER_GROUP_ROLE cascade constraints; |
| |
| CREATE TABLE TURBINE_USER_GROUP_ROLE |
| ( |
| USER_ID INT NOT NULL, |
| GROUP_ID INT NOT NULL, |
| ROLE_ID INT NOT NULL |
| ); |
| |
| ALTER TABLE TURBINE_USER_GROUP_ROLE |
| ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_PK |
| PRIMARY KEY (USER_ID,GROUP_ID,ROLE_ID); |
| |
| ALTER TABLE TURBINE_USER_GROUP_ROLE |
| ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_1 FOREIGN KEY (USER_ID) |
| REFERENCES TURBINE_USER (USER_ID) |
| ; |
| |
| ALTER TABLE TURBINE_USER_GROUP_ROLE |
| ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_2 FOREIGN KEY (GROUP_ID) |
| REFERENCES TURBINE_GROUP (GROUP_ID) |
| ; |
| |
| ALTER TABLE TURBINE_USER_GROUP_ROLE |
| ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_3 FOREIGN KEY (ROLE_ID) |
| REFERENCES TURBINE_ROLE (ROLE_ID) |
| ; |
| |
| |
| |
| |
| |
| ----------------------------------------------------------------------------- |
| -- TURBINE_SCHEDULED_JOB |
| ----------------------------------------------------------------------------- |
| drop table TURBINE_SCHEDULED_JOB cascade constraints; |
| |
| CREATE TABLE TURBINE_SCHEDULED_JOB |
| ( |
| JOB_ID INT NOT NULL, |
| SECOND INT default -1 NOT NULL, |
| MINUTE INT default -1 NOT NULL, |
| HOUR INT default -1 NOT NULL, |
| WEEK_DAY INT default -1 NOT NULL, |
| DAY_OF_MONTH INT default -1 NOT NULL, |
| TASK VARCHAR2 (99) NOT NULL, |
| EMAIL VARCHAR2 (99), |
| PROPERTY LONG RAW |
| ); |
| |
| ALTER TABLE TURBINE_SCHEDULED_JOB |
| ADD CONSTRAINT TURBINE_SCHEDULED_JOB_PK |
| PRIMARY KEY (JOB_ID); |
| |
| |
| |
| |
| |