reporting server: quartz sql scripts updated to correct version
authorAlex Kirhenshtein <alk@netxms.org>
Tue, 20 Sep 2016 10:33:42 +0000 (13:33 +0300)
committerAlex Kirhenshtein <alk@netxms.org>
Tue, 20 Sep 2016 10:33:42 +0000 (13:33 +0300)
src/java/nxreporting/sql/oracle/quartz.sql
src/java/nxreporting/sql/postgres/quartz.sql

index a80d4e5..0f23e5a 100644 (file)
@@ -143,6 +143,7 @@ CREATE TABLE qrtz_fired_triggers
     TRIGGER_GROUP VARCHAR2(200) NOT NULL,
     INSTANCE_NAME VARCHAR2(200) NOT NULL,
     FIRED_TIME NUMBER(13) NOT NULL,
+    SCHED_TIME NUMBER(13) NOT NULL,
     PRIORITY NUMBER(13) NOT NULL,
     STATE VARCHAR2(16) NOT NULL,
     JOB_NAME VARCHAR2(200) NULL,
index deb158a..512a9b1 100644 (file)
@@ -3,17 +3,17 @@
 -- In your Quartz properties file, you'll need to set 
 -- org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
 
-DROP TABLE IF EXISTS qrtz_fired_triggers;
-DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS;
-DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;
-DROP TABLE IF EXISTS QRTZ_LOCKS;
-DROP TABLE IF EXISTS qrtz_simple_triggers;
-DROP TABLE IF EXISTS qrtz_cron_triggers;
-DROP TABLE IF EXISTS qrtz_simprop_triggers;
-DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS;
-DROP TABLE IF EXISTS qrtz_triggers;
-DROP TABLE IF EXISTS qrtz_job_details;
-DROP TABLE IF EXISTS qrtz_calendars;
+drop table qrtz_fired_triggers;
+DROP TABLE QRTZ_PAUSED_TRIGGER_GRPS;
+DROP TABLE QRTZ_SCHEDULER_STATE;
+DROP TABLE QRTZ_LOCKS;
+drop table qrtz_simple_triggers;
+drop table qrtz_cron_triggers;
+drop table qrtz_simprop_triggers;
+DROP TABLE QRTZ_BLOB_TRIGGERS;
+drop table qrtz_triggers;
+drop table qrtz_job_details;
+drop table qrtz_calendars;
 
 CREATE TABLE qrtz_job_details
   (