-----------------------------------------------------------------------------
-- TURBINE_SCHEDULED_JOB
-----------------------------------------------------------------------------
DROP TABLE TURBINE_SCHEDULED_JOB cascade constraints;

CREATE TABLE TURBINE_SCHEDULED_JOB
(
    JOB_ID INT NOT NULL,
    JOB_SECOND INT default -1 NOT NULL,
    JOB_MINUTE INT default -1 NOT NULL,
    JOB_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),
    JOB_PROPERTY LONG RAW
);

ALTER TABLE TURBINE_SCHEDULED_JOB
    ADD CONSTRAINT TURBINE_SCHEDULED_JOB_PK 
PRIMARY KEY (JOB_ID);


DROP SEQUENCE TURBINE_SCHEDULED_JOB_SEQ;

CREATE SEQUENCE TURBINE_SCHEDULED_JOB_SEQ 
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOMINVALUE
NOCYCLE
NOORDER
;