btn-mdw-ace-server-local/mwapp/init/000.MWAPP.sql

DROP SCHEMA MWAPP RESTRICT~
CREATE SCHEMA MWAPP~

DROP TABLE IF EXISTS MWAPP.ATTRIBUTE~
CREATE TABLE MWAPP.ATTRIBUTE (
	ID BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9223372036854775807 NO CYCLE CACHE 20),
	TYPE VARCHAR(50) NOT NULL,
	NAME VARCHAR(50) NOT NULL,
	DESCRIPTION VARCHAR(256),
	MODIFIED_BY VARCHAR(64) NOT NULL,
	TIMESTAMP TIMESTAMP NOT NULL,
	PRIMARY KEY (ID)
)~

DROP TABLE IF EXISTS MWAPP.EOD_CONFIG~
CREATE TABLE MWAPP.EOD_CONFIG (
	CODE VARCHAR(10) NOT NULL,
	EOD_STATUS INTEGER NOT NULL,
	MODIFIED_BY VARCHAR(50) NOT NULL,
	MODIFIED_DATE TIMESTAMP NOT NULL,
	PRIMARY KEY (CODE)
)~

DROP TABLE IF EXISTS MWAPP.PRIVILEGE~
CREATE TABLE MWAPP.PRIVILEGE (
	ID VARCHAR(256) NOT NULL,
	NAME VARCHAR(256) NOT NULL,
	TYPE VARCHAR(100) NOT NULL,
	PATH VARCHAR(256) NOT NULL,
	PARENT VARCHAR(256),
	PRIORITY INTEGER,
	STATUS VARCHAR(50) NOT NULL,
	MODIFIED_BY VARCHAR(64) NOT NULL,
	TIMESTAMP TIMESTAMP NOT NULL,
	PRIMARY KEY (ID),
	FOREIGN KEY (PARENT) REFERENCES MWAPP.PRIVILEGE (ID)
)~

DROP TABLE IF EXISTS MWAPP.ROLE~
CREATE TABLE MWAPP.ROLE (
	ID VARCHAR(50) NOT NULL,
	TYPE VARCHAR(50) NOT NULL,
	NAME VARCHAR(50) NOT NULL,
	STATUS VARCHAR(50) NOT NULL,
	MODIFIED_BY VARCHAR(64) NOT NULL,
	TIMESTAMP TIMESTAMP NOT NULL,
	PRIMARY KEY (ID)
)~

DROP TABLE IF EXISTS MWAPP.ROLE_PRIVILEGE~
CREATE TABLE MWAPP.ROLE_PRIVILEGE (
	ROLE VARCHAR(50) NOT NULL,
	PRIVILEGE VARCHAR(256) NOT NULL,
	PRIMARY KEY (ROLE,PRIVILEGE),
	FOREIGN KEY (ROLE) REFERENCES MWAPP.ROLE (ID),
	FOREIGN KEY (PRIVILEGE) REFERENCES MWAPP.PRIVILEGE (ID)
)~

DROP TABLE IF EXISTS MWAPP.SYS_PARAM~
CREATE TABLE MWAPP.SYS_PARAM (
	CODE VARCHAR(50) NOT NULL,
	NAME VARCHAR(50) NOT NULL,
	PARAM_VALUE VARCHAR(256) NOT NULL,
	DESCRIPTION VARCHAR(256),
	MODIFIED_BY VARCHAR(64) NOT NULL,
	TIMESTAMP TIMESTAMP NOT NULL,
	PRIMARY KEY (CODE)
)~

DROP TABLE IF EXISTS MWAPP.QRTZ_CALENDARS~
CREATE TABLE MWAPP.QRTZ_CALENDARS (
	SCHED_NAME VARCHAR(120) NOT NULL,
	CALENDAR_NAME VARCHAR(80) NOT NULL,
	CALENDAR BLOB(2000) NOT NULL,
	PRIMARY KEY (CALENDAR_NAME)
)~

DROP TABLE IF EXISTS MWAPP.QRTZ_FIRED_TRIGGERS~
CREATE TABLE MWAPP.QRTZ_FIRED_TRIGGERS (
	SCHED_NAME VARCHAR(120) NOT NULL,
	ENTRY_ID VARCHAR(95) NOT NULL,
	TRIGGER_NAME VARCHAR(80) NOT NULL,
	TRIGGER_GROUP VARCHAR(80) NOT NULL,
	INSTANCE_NAME VARCHAR(80) NOT NULL,
	FIRED_TIME BIGINT NOT NULL,
	PRIORITY INTEGER NOT NULL,
	STATE VARCHAR(16) NOT NULL,
	JOB_NAME VARCHAR(80),
	JOB_GROUP VARCHAR(80),
	IS_NONCONCURRENT INTEGER,
	REQUESTS_RECOVERY INTEGER,
	PRIMARY KEY (SCHED_NAME, ENTRY_ID)
)~

DROP TABLE IF EXISTS MWAPP.QRTZ_JOB_DETAILS~
CREATE TABLE MWAPP.QRTZ_JOB_DETAILS (
	SCHED_NAME VARCHAR(120) NOT NULL,
	JOB_NAME VARCHAR(80) NOT NULL,
	JOB_GROUP VARCHAR(80) NOT NULL,
	DESCRIPTION VARCHAR(120),
	JOB_CLASS_NAME VARCHAR(128) NOT NULL,
	IS_DURABLE INTEGER NOT NULL,
	IS_NONCONCURRENT INTEGER NOT NULL,
	IS_UPDATE_DATA INTEGER NOT NULL,
	REQUESTS_RECOVERY INTEGER NOT NULL,
	JOB_DATA BLOB(2000),
	PRIMARY KEY (SCHED_NAME, JOB_NAME, JOB_GROUP)
)~

DROP TABLE IF EXISTS MWAPP.QRTZ_TRIGGERS~
CREATE TABLE MWAPP.QRTZ_TRIGGERS (
	SCHED_NAME VARCHAR(120) NOT NULL,
	TRIGGER_NAME VARCHAR(80) NOT NULL,
	TRIGGER_GROUP VARCHAR(80) NOT NULL,
	JOB_NAME VARCHAR(80) NOT NULL,
	JOB_GROUP VARCHAR(80) NOT NULL,
	DESCRIPTION VARCHAR(120),
	NEXT_FIRE_TIME BIGINT,
	PREV_FIRE_TIME BIGINT,
	PRIORITY INTEGER,
	TRIGGER_STATE VARCHAR(16) NOT NULL,
	TRIGGER_TYPE VARCHAR(8) NOT NULL,
	START_TIME BIGINT NOT NULL,
	END_TIME BIGINT,
	CALENDAR_NAME VARCHAR(80),
	MISFIRE_INSTR SMALLINT,
	JOB_DATA BLOB(2000),
	PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP),
	FOREIGN KEY (SCHED_NAME, JOB_NAME, JOB_GROUP) REFERENCES MWAPP.QRTZ_JOB_DETAILS (SCHED_NAME, JOB_NAME, JOB_GROUP)
)~

DROP TABLE IF EXISTS MWAPP.QRTZ_SIMPLE_TRIGGERS~
CREATE TABLE MWAPP.QRTZ_SIMPLE_TRIGGERS (
	SCHED_NAME VARCHAR(120) NOT NULL,
	TRIGGER_NAME VARCHAR(80) NOT NULL,
	TRIGGER_GROUP VARCHAR(80) NOT NULL,
	REPEAT_COUNT BIGINT NOT NULL,
	REPEAT_INTERVAL BIGINT NOT NULL,
	TIMES_TRIGGERED BIGINT NOT NULL,
	PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
	FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES MWAPP.QRTZ_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
)~

DROP TABLE IF EXISTS MWAPP.QRTZ_CRON_TRIGGERS~
CREATE TABLE MWAPP.QRTZ_CRON_TRIGGERS (
	SCHED_NAME VARCHAR(120) NOT NULL,
	TRIGGER_NAME VARCHAR(80) NOT NULL,
	TRIGGER_GROUP VARCHAR(80) NOT NULL,
	CRON_EXPRESSION VARCHAR(120) NOT NULL,
	TIME_ZONE_ID VARCHAR(80),
	PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP),
	FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES MWAPP.QRTZ_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
)~

DROP TABLE IF EXISTS MWAPP.QRTZ_SIMPROP_TRIGGERS~
CREATE TABLE MWAPP.QRTZ_SIMPROP_TRIGGERS (
    SCHED_NAME VARCHAR(120) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    STR_PROP_1 VARCHAR(512),
    STR_PROP_2 VARCHAR(512),
    STR_PROP_3 VARCHAR(512),
    INT_PROP_1 INT,
    INT_PROP_2 INT,
    LONG_PROP_1 BIGINT,
    LONG_PROP_2 BIGINT,
    DEC_PROP_1 NUMERIC(13,4),
    DEC_PROP_2 NUMERIC(13,4),
    BOOL_PROP_1 VARCHAR(1),
    BOOL_PROP_2 VARCHAR(1),
    PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP),
    FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES MWAPP.QRTZ_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
)~

DROP TABLE IF EXISTS MWAPP.QRTZ_BLOB_TRIGGERS~
CREATE TABLE MWAPP.QRTZ_BLOB_TRIGGERS (
	SCHED_NAME VARCHAR(120) NOT NULL,
	TRIGGER_NAME VARCHAR(80) NOT NULL,
	TRIGGER_GROUP VARCHAR(80) NOT NULL,
	BLOB_DATA BLOB(2000),
	PRIMARY KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP),
	FOREIGN KEY (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP) REFERENCES MWAPP.QRTZ_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
)~

DROP TABLE IF EXISTS MWAPP.QRTZ_LOCKS~
CREATE TABLE MWAPP.QRTZ_LOCKS (
	SCHED_NAME VARCHAR(120) NOT NULL,
	LOCK_NAME VARCHAR(40) NOT NULL,
	PRIMARY KEY (SCHED_NAME, LOCK_NAME)
)~

DROP TABLE IF EXISTS MWAPP.QRTZ_PAUSED_TRIGGER_GRPS~
CREATE TABLE MWAPP.QRTZ_PAUSED_TRIGGER_GRPS (
	SCHED_NAME VARCHAR(120) NOT NULL,
	TRIGGER_GROUP VARCHAR(80) NOT NULL,
	PRIMARY KEY (SCHED_NAME, TRIGGER_GROUP)
)~

DROP TABLE IF EXISTS MWAPP.QRTZ_SCHEDULER_STATE~
CREATE TABLE MWAPP.QRTZ_SCHEDULER_STATE (
	SCHED_NAME VARCHAR(120) NOT NULL,
	INSTANCE_NAME VARCHAR(80) NOT NULL,
	LAST_CHECKIN_TIME BIGINT NOT NULL,
	CHECKIN_INTERVAL BIGINT NOT NULL,
	PRIMARY KEY (SCHED_NAME, INSTANCE_NAME)
)~