Commits

Anonymous committed 7068d55

QUARTZ-784 : times_triggered column too small for frequently repeating triggers that live for a long time (years).

git-svn-id: http://svn.opensymphony.com/svn/quartz/trunk@92769f7d36a-ea1c-0410-88ea-9fd03e4c9665

Comments (0)

Files changed (8)

docs/dbTables/tables_hsqldb.sql

 TRIGGER_GROUP VARCHAR(200) NOT NULL,
 REPEAT_COUNT NUMERIC(7) NOT NULL,
 REPEAT_INTERVAL NUMERIC(12) NOT NULL,
-TIMES_TRIGGERED NUMERIC(7) NOT NULL,
+TIMES_TRIGGERED NUMERIC(10) NOT NULL,
 PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
 FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
 REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)

docs/dbTables/tables_hsqldb_old.sql

 TRIGGER_GROUP LONGVARCHAR(80) NOT NULL,
 REPEAT_COUNT NUMERIC(7) NOT NULL,
 REPEAT_INTERVAL NUMERIC(12) NOT NULL,
-TIMES_TRIGGERED NUMERIC(7) NOT NULL,
+TIMES_TRIGGERED NUMERIC(10) NOT NULL,
 PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
 FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
 REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)

docs/dbTables/tables_informix.sql

 TRIGGER_GROUP varchar(80) NOT NULL,
 REPEAT_COUNT numeric(7) NOT NULL,
 REPEAT_INTERVAL numeric(12) NOT NULL,
-TIMES_TRIGGERED numeric(7) NOT NULL
+TIMES_TRIGGERED numeric(10) NOT NULL
 );
 
 

docs/dbTables/tables_mysql.sql

     TRIGGER_GROUP VARCHAR(200) NOT NULL,
     REPEAT_COUNT BIGINT(7) NOT NULL,
     REPEAT_INTERVAL BIGINT(12) NOT NULL,
-    TIMES_TRIGGERED BIGINT(7) NOT NULL,
+    TIMES_TRIGGERED BIGINT(10) NOT NULL,
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
     FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
         REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)

docs/dbTables/tables_mysql_innodb.sql

 TRIGGER_GROUP VARCHAR(200) NOT NULL,
 REPEAT_COUNT BIGINT(7) NOT NULL,
 REPEAT_INTERVAL BIGINT(12) NOT NULL,
-TIMES_TRIGGERED BIGINT(7) NOT NULL,
+TIMES_TRIGGERED BIGINT(10) NOT NULL,
 PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
 INDEX (TRIGGER_NAME, TRIGGER_GROUP),
 FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)

docs/dbTables/tables_oracle.sql

     TRIGGER_GROUP VARCHAR2(200) NOT NULL,
     REPEAT_COUNT NUMBER(7) NOT NULL,
     REPEAT_INTERVAL NUMBER(12) NOT NULL,
-    TIMES_TRIGGERED NUMBER(7) NOT NULL,
+    TIMES_TRIGGERED NUMBER(10) NOT NULL,
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
     FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
 	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)

docs/dbTables/tables_pointbase.sql

     TRIGGER_GROUP VARCHAR2(80) NOT NULL,
     REPEAT_COUNT NUMBER(7) NOT NULL,
     REPEAT_INTERVAL NUMBER(12) NOT NULL,
-    TIMES_TRIGGERED NUMBER(7) NOT NULL,
+    TIMES_TRIGGERED NUMBER(10) NOT NULL,
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
     FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) 
 	REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)

docs/dbTables/tables_sapdb.sql

     TRIGGER_GROUP VARCHAR(200) NOT NULL,
     REPEAT_COUNT FIXED(7) NOT NULL,
     REPEAT_INTERVAL FIXED(12) NOT NULL,
-    TIMES_TRIGGERED FIXED(7) NOT NULL,
+    TIMES_TRIGGERED FIXED(10) NOT NULL,
     PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
     FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
 );