160405. Quartz Persistence Required table structure

Delete from Qrtz_fired_triggers;  delete from Qrtz_simple_triggers;  delete from Qrtz_simprop_triggers;  delete from Qrtz_cron_triggers;  delete from Qrtz_blob_triggers;  delete from Qrtz_triggers;  delete from Qrtz_job_details;  delete from Qrtz_calendars;  delete from Qrtz_paused_trigger_grps;  delete from Qrtz_locks;  delete from Qrtz_scheduler_state;    drop table Qrtz_calendars;  drop table qrtz_fired_triggers;  drop table qrtz_blob_triggers;  drop table qrtz_cron_triggers;  drop table qrtz_simple_triggers;  drop table qrtz_simprop_triggers;  drop table qrtz_triggers;  drop table qrtz_job_details;  drop table Qrtz_paused_trigger_grps;  drop table qrtz_locks;  drop table qrtz_scheduler_state;    --store details for each configured Job  create TABLE qrtz_job_details    (     Sched_nam E VARCHAR2 (+) not NULL,      job_name &NBSp VARCHAR2 (+) NOT NULL,      Job_group VARCHAR2 ($) NOT NULL,      DESCRIPTION VARCHAR2 (250 ) NULL,      job_class_name   VARCHAR2 (+) not NULL,       is_durable VARCHAR2 (1) Not NULL,      is_nonconcurrent VARCHAR2 (1) isn't NULL,      is_update_data VARCHAR2 (1) Not N ULL,      requests_recovery VARCHAR2 (1) Not NULL,      job_data BLOB null,    &nbs P CONSTRAINT qrtz_job_details_pk PRIMARY KEY (sched_name,job_name,job_group)  );  --  Store configured Trigger information  create TABLE qrtz_triggers    (     Sched_name VARCHAR2 ( ) not NULL,      trigger_name VARCHAR2 ($) NOT NULL,      Trigger_group VARCHAR2 (NO) T null,      job_name  varchar2 ($) Not NULL,       job_group VARCHAR2 (+) not N ULL,      DESCRIPTION VARCHAR2 (+) NULL,      Next_fire_time number (+) NULL,      prev_fire_time number (+) NULL,    &nbs P Priority number (+) NULL,      trigger_state VARCHAR2 (+) not NULL,      Trigger_type varcha R2 (8) NOT NULL,      start_time number (+) not NULL,      end_time number (all) NULL, &NBSP;&N Bsp   Calendar_name VARCHAR2 ($) NULL,      MISFIRE_INSTR number (2) NULL,      Job_data BL OB NULL,      CONSTRAINT qrtz_triggers_pk PRIMARY KEY (sched_name,trigger_name,trigger_group),  & nbsp   CONSTRAINT QRTZ_TRIGGER_TO_JOBS_FK FOREIGN KEY (sched_name,job_name,job_group)         REFERENCES qrtz_job_details (Sched_name,job_name,job_group)   );  --stores simple Trigger, including number of repetitions, intervals, and number of touches  create TABLE qrtz_simple_triggers    (     Sched_name VARCHAR2 (+) not NULL,      trigger_name VarcHAR2 ($) NOT NULL,      Trigger_group VARCHAR2 ($) NOT NULL,      Repeat_count number (7) N OT null,      repeat_interval number (a) not NULL,      times_triggered number (TEN) is not NULL,      CONSTRAINT qrtz_simple_trig_pk PRIMARY KEY (sched_name,trigger_name,trigger_group),    & nbsp CONSTRAINT qrtz_simple_trig_to_trig_fk FOREIGN KEY (sched_name,trigger_name,trigger_group)       REFERENCES qrtz_triggers (Sched_name,trigger_name,trigger_group)  );  --storage cron Trigger, including cron expressions and time zone information  create TABLE qrtz_cron_triggers    (     Sched_n AME VARCHAR2 (+) NOT NULL,      trigger_name VARCHAR2 ($) NOT NULL,      Trigger_group VAR CHAR2 (+) NOT NULL,      cron_expression VARCHAR2 (+) NOT NULL,      time_zone_id VARCHAR2      CONSTRAINT qrtz_cron_trig_pk PRIMARY KEY (sched_nAme,trigger_name,trigger_group),      CONSTRAINT qrtz_cron_trig_to_trig_fk FOREIGN KEY (Sched_name, Trigger_name,trigger_group)         REFERENCES qrtz_triggers (Sched_name,trigger_name, Trigger_group)  );  create TABLE qrtz_simprop_triggers    (               Sched_name VARCHAR2 (+) NOT NULL,      trigger_name VARCHAR2 ($) NOT NULL,      Trigger_group VARCHAR 2 ($) Not NULL,      str_prop_1 VARCHAR2 (+) NULL,      str_prop_2 VARCHAR2 (+) NULL, &NB sp;    Str_prop_3 VARCHAR2 (+) NULL,      int_prop_1 number (ten) null,      INT_PR Op_2 number (Ten) null,      long_prop_1 number (+) NULL,      long_prop_2 number (all) NULL, &N bsp;    dec_prop_1 NUMERIC (13,4) null,      dec_prop_2 NUMERIC (13,4) null,      BO Ol_prop_1 VARCHAR2 (1) NULL,      bool_prop_2 VARCHAR2 (1) NULL,      CONSTRAINT qrtz_simprop_trig_pk PRIMARY KEY (Sched_name,trigger_name,trigger_group),      CONSTRAINT qrtz_simprop_trig_to_trig_fk FOREIGN KEY ( Sched_name,trigger_name,trigger_group)         REFERENCES qrtz_triggers (Sched_name,trigger _name,trigger_group)  );  --Trigger is stored as Blob type (for Quartz users to create their own custom Trigger type, <span style= "Color:rgb (128, 0, 128);" >JobStore</span> do not know how to store instances when)  create TABLE qrtz_blob_triggers    (     SCHED _name VARCHAR2 (+) NOT NULL,      trigger_name VARCHAR2 (+) NOT NULL,      Trigger_group V ARCHAR2 ($) NOT NULL,      blob_data BLOB NULL,      CONSTRAINT qrtz_blob_trig_pk PRIMARY K EY (Sched_name,trigger_name,trigger_group),      CONSTRAINT qrtz_blob_trig_to_trig_fk FOREIGN KEY ( Sched_name,trigger_name,trigger_group)           REFERENCES qrtz_triggers (Sched_name,trigger_name,trigger_group)  );  --Store Quartz Calendar information in Blob type  create TABLE qrtz_calendars    (     Sched_name VARCHAR2 (+) NOT NULL,      calendar_name  varchar2 ($) NOT NULL,       Calenda R BLOB not NULL,      CONSTRAINT qrtz_calendars_pk PRIMARY KEY (sched_name,calendar_name)  );  --storing information for paused Trigger groups   create TABLE Qrtz_paused_trigger_grps    (     Sched_n AME VARCHAR2 (+) NOT NULL,      Trigger_group  varchar2 ($) NOT NULL,       CONS Traint qrtz_paused_trig_grps_pk PRIMARY KEY (sched_name,trigger_group)  );  --stores state information related to the triggered Trigger, and execution information for the associated Job  create TABLE qrtz_fired_triggers     (   & nbsp Sched_name VARCHAR2 (+) not NULL,      entry_id VARCHAR2 (trigger_name) not NULL,      VARCHAR2 ($) NOT NULL,      Trigger_group VARCHAR2 (N) OT null,      instance_name VARCHAR2 ($) NOT NULL,      fired_time number (in) NOT NULL, &NB sp;    Priority number (+) not NULL,      State VARCHAR2 (+) NOT NULL,      Job_na ME VARCHAR2 ($) NULL,      Job_group VARCHAR2 ($) NULL,      is_nonconcurrent VARCHAR2 (1) NULL,      requests_recovery VARCHAR2 (1) NULL,      CONSTRAINT qrtz_fired_trigger_pk PRIMA RY KEY (sched_name,entry_id)  );  --stores a small amount of state information about Scheduler, and other Scheduler instances (if used in a cluster)  create TABLE qrtz_scheduler_state      (     sched_name VARCHAR2 (+) NOT NULL,      instance_name VARCHAR2 (+) NOT NULL,      Last_checkin_time Number (+) not NULL,      checkin_interval number (a) is not NULL,      CONSTRAINT qrtz_scheduler_state_pk PRIMARY KEY (sched_name,instance_name)  );  --information about the pessimistic lock of the stored program (if pessimistic lock is used)  create TABLE qrtz_locks    (     sched_name VARCHAR2 (120) Not NULL,      lock_name  varchar2 (+) NOT NULL,       CONSTRAINT qrtz_locks_pk PR Imary KEY (sched_name,lock_name)  );    create index idx_qrtz_j_req_recovery on qrtz_job_details (sched_name,requests_recovery);  create index idx_qrtz_j_grp on qrtz_job_details (Sched_name,job_group);    create index Idx_qrtz_t_j on qrtz_triggers (Sched_name,job_name,job_group);  create index IDX_QRTZ_T_JG on qrtz_triggers (Sched_name,job_group);  create index Idx_qrtz_t_c on qrtz_triggers (sched_name,calendar_name);  create index Idx_qrtz_t_g on qrtz_triggers (Sched_name,trigger_group);  create index idx_qrtz_t_state on qrtz_triggers (sched_name,trigger_state);  create Index Idx_qrtz_t_n_State on Qrtz_triggers (sched_name,trigger_name,trigger_group,trigger_state);  create index idx_qrtz_t_n_g_state on qrtz_triggers (sched_name,trigger_group,trigger_state);  create index idx_qrtz_t_next_fire_time on qrtz_triggers (sched_name,next_fire_time);  create index Idx_qrtz_t_nft_st on qrtz_triggers (sched_name,trigger_state,next_fire_time);  create index Idx_qrtz_t_nft_misfire on qrtz_triggers (sched_name,misfire_instr,next_fire_time);  create index Idx_qrtz_t_nft_st_misfire on qrtz_triggers (sched_name,misfire_instr,next_fire_time,trigger_ State);  create index idx_qrtz_t_nft_st_misfire_grp on qrtz_triggers (sched_name,misfire_instr,next_fire_time,trigger_ Group,trigger_state);    create index idx_qrtz_ft_trig_inst_name on qrtz_fired_triggers (sched_name,instance_name);  create index Idx_qrtz_ft_inst_job_req_rcvry on qrtz_fired_triggers (sched_name,instance_name,requests_ RECOVERY);  create index idx_qrtz_ft_j_g on Qrtz_fired_triggers (Sched_name,job_name,job_group);  create index IDX_QRTZ_FT_JG on qrtz_fired_triggers (Sched_name,job_group);  create index Idx_qrtz_ft_t_g on qrtz_fired_triggers (Sched_name,trigger_name,trigger_group);  create index IDX_QRTZ_FT_TG on qrtz_fired_triggers (Sched_name,trigger_group);  

160405. Quartz Persistence Required table structure