databaseChangeLog: - changeSet: id: 1490078531546-1 author: Bert (generated) changes: - createTable: columns: - column: constraints: nullable: false name: SCHED_NAME type: VARCHAR(120) - column: constraints: nullable: false name: TRIGGER_NAME type: VARCHAR(200) - column: constraints: nullable: false name: TRIGGER_GROUP type: VARCHAR(200) - column: name: BLOB_DATA type: BLOB tableName: QRTZ_BLOB_TRIGGERS - changeSet: id: 1490078531546-2 author: Bert (generated) changes: - createTable: columns: - column: constraints: nullable: false name: SCHED_NAME type: VARCHAR(120) - column: constraints: nullable: false name: CALENDAR_NAME type: VARCHAR(200) - column: constraints: nullable: false name: CALENDAR type: BLOB tableName: QRTZ_CALENDARS - changeSet: id: 1490078531546-3 author: Bert (generated) changes: - createTable: columns: - column: constraints: nullable: false name: SCHED_NAME type: VARCHAR(120) - column: constraints: nullable: false name: TRIGGER_NAME type: VARCHAR(200) - column: constraints: nullable: false name: TRIGGER_GROUP type: VARCHAR(200) - column: constraints: nullable: false name: CRON_EXPRESSION type: VARCHAR(200) - column: name: TIME_ZONE_ID type: VARCHAR(80) tableName: QRTZ_CRON_TRIGGERS - changeSet: id: 1490078531546-4 author: Bert (generated) changes: - createTable: columns: - column: constraints: nullable: false name: SCHED_NAME type: VARCHAR(120) - column: constraints: nullable: false name: ENTRY_ID type: VARCHAR(95) - column: constraints: nullable: false name: TRIGGER_NAME type: VARCHAR(200) - column: constraints: nullable: false name: TRIGGER_GROUP type: VARCHAR(200) - column: constraints: nullable: false name: INSTANCE_NAME type: VARCHAR(200) - column: constraints: nullable: false name: FIRED_TIME type: BIGINT - column: constraints: nullable: false name: SCHED_TIME type: BIGINT - column: constraints: nullable: false name: PRIORITY type: INT - column: constraints: nullable: false name: STATE type: VARCHAR(16) - column: name: JOB_NAME type: VARCHAR(200) - column: name: JOB_GROUP type: VARCHAR(200) - column: name: IS_NONCONCURRENT type: VARCHAR(1) - column: name: REQUESTS_RECOVERY type: VARCHAR(1) tableName: QRTZ_FIRED_TRIGGERS - changeSet: id: 1490078531546-5 author: Bert (generated) changes: - createTable: columns: - column: constraints: nullable: false name: SCHED_NAME type: VARCHAR(120) - column: constraints: nullable: false name: JOB_NAME type: VARCHAR(200) - column: constraints: nullable: false name: JOB_GROUP type: VARCHAR(200) - column: name: DESCRIPTION type: VARCHAR(250) - column: constraints: nullable: false name: JOB_CLASS_NAME type: VARCHAR(250) - column: constraints: nullable: false name: IS_DURABLE type: VARCHAR(1) - column: constraints: nullable: false name: IS_NONCONCURRENT type: VARCHAR(1) - column: constraints: nullable: false name: IS_UPDATE_DATA type: VARCHAR(1) - column: constraints: nullable: false name: REQUESTS_RECOVERY type: VARCHAR(1) - column: name: JOB_DATA type: BLOB tableName: QRTZ_JOB_DETAILS - changeSet: id: 1490078531546-6 author: Bert (generated) changes: - createTable: columns: - column: constraints: nullable: false name: SCHED_NAME type: VARCHAR(120) - column: constraints: nullable: false name: LOCK_NAME type: VARCHAR(40) tableName: QRTZ_LOCKS - changeSet: id: 1490078531546-7 author: Bert (generated) changes: - createTable: columns: - column: constraints: nullable: false name: SCHED_NAME type: VARCHAR(120) - column: constraints: nullable: false name: TRIGGER_GROUP type: VARCHAR(200) tableName: QRTZ_PAUSED_TRIGGER_GRPS - changeSet: id: 1490078531546-8 author: Bert (generated) changes: - createTable: columns: - column: constraints: nullable: false name: SCHED_NAME type: VARCHAR(120) - column: constraints: nullable: false name: INSTANCE_NAME type: VARCHAR(200) - column: constraints: nullable: false name: LAST_CHECKIN_TIME type: BIGINT - column: constraints: nullable: false name: CHECKIN_INTERVAL type: BIGINT tableName: QRTZ_SCHEDULER_STATE - changeSet: id: 1490078531546-9 author: Bert (generated) changes: - createTable: columns: - column: constraints: nullable: false name: SCHED_NAME type: VARCHAR(120) - column: constraints: nullable: false name: TRIGGER_NAME type: VARCHAR(200) - column: constraints: nullable: false name: TRIGGER_GROUP type: VARCHAR(200) - column: constraints: nullable: false name: REPEAT_COUNT type: BIGINT - column: constraints: nullable: false name: REPEAT_INTERVAL type: BIGINT - column: constraints: nullable: false name: TIMES_TRIGGERED type: BIGINT tableName: QRTZ_SIMPLE_TRIGGERS - changeSet: id: 1490078531546-10 author: Bert (generated) changes: - createTable: columns: - column: constraints: nullable: false name: SCHED_NAME type: VARCHAR(120) - column: constraints: nullable: false name: TRIGGER_NAME type: VARCHAR(200) - column: constraints: nullable: false name: TRIGGER_GROUP type: VARCHAR(200) - column: name: STR_PROP_1 type: VARCHAR(512) - column: name: STR_PROP_2 type: VARCHAR(512) - column: name: STR_PROP_3 type: VARCHAR(512) - column: name: INT_PROP_1 type: INT - column: name: INT_PROP_2 type: INT - column: name: LONG_PROP_1 type: BIGINT - column: name: LONG_PROP_2 type: BIGINT - column: name: DEC_PROP_1 type: DECIMAL(13, 4) - column: name: DEC_PROP_2 type: DECIMAL(13, 4) - column: name: BOOL_PROP_1 type: VARCHAR(1) - column: name: BOOL_PROP_2 type: VARCHAR(1) tableName: QRTZ_SIMPROP_TRIGGERS - changeSet: id: 1490078531546-11 author: Bert (generated) changes: - createTable: columns: - column: constraints: nullable: false name: SCHED_NAME type: VARCHAR(120) - column: constraints: nullable: false name: TRIGGER_NAME type: VARCHAR(200) - column: constraints: nullable: false name: TRIGGER_GROUP type: VARCHAR(200) - column: constraints: nullable: false name: JOB_NAME type: VARCHAR(200) - column: constraints: nullable: false name: JOB_GROUP type: VARCHAR(200) - column: name: DESCRIPTION type: VARCHAR(250) - column: name: NEXT_FIRE_TIME type: BIGINT - column: name: PREV_FIRE_TIME type: BIGINT - column: name: PRIORITY type: INT - column: constraints: nullable: false name: TRIGGER_STATE type: VARCHAR(16) - column: constraints: nullable: false name: TRIGGER_TYPE type: VARCHAR(8) - column: constraints: nullable: false name: START_TIME type: BIGINT - column: name: END_TIME type: BIGINT - column: name: CALENDAR_NAME type: VARCHAR(200) - column: name: MISFIRE_INSTR type: SMALLINT - column: name: JOB_DATA type: BLOB tableName: QRTZ_TRIGGERS - changeSet: id: 1490078531546-12 author: Bert (generated) changes: - addPrimaryKey: columnNames: SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP tableName: QRTZ_BLOB_TRIGGERS - changeSet: id: 1490078531546-13 author: Bert (generated) changes: - addPrimaryKey: columnNames: SCHED_NAME, CALENDAR_NAME tableName: QRTZ_CALENDARS - changeSet: id: 1490078531546-14 author: Bert (generated) changes: - addPrimaryKey: columnNames: SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP tableName: QRTZ_CRON_TRIGGERS - changeSet: id: 1490078531546-15 author: Bert (generated) changes: - addPrimaryKey: columnNames: SCHED_NAME, ENTRY_ID tableName: QRTZ_FIRED_TRIGGERS - changeSet: id: 1490078531546-16 author: Bert (generated) changes: - addPrimaryKey: columnNames: SCHED_NAME, JOB_NAME, JOB_GROUP tableName: QRTZ_JOB_DETAILS - changeSet: id: 1490078531546-17 author: Bert (generated) changes: - addPrimaryKey: columnNames: SCHED_NAME, LOCK_NAME tableName: QRTZ_LOCKS - changeSet: id: 1490078531546-18 author: Bert (generated) changes: - addPrimaryKey: columnNames: SCHED_NAME, TRIGGER_GROUP tableName: QRTZ_PAUSED_TRIGGER_GRPS - changeSet: id: 1490078531546-19 author: Bert (generated) changes: - addPrimaryKey: columnNames: SCHED_NAME, INSTANCE_NAME tableName: QRTZ_SCHEDULER_STATE - changeSet: id: 1490078531546-20 author: Bert (generated) changes: - addPrimaryKey: columnNames: SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP tableName: QRTZ_SIMPLE_TRIGGERS - changeSet: id: 1490078531546-21 author: Bert (generated) changes: - addPrimaryKey: columnNames: SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP tableName: QRTZ_SIMPROP_TRIGGERS - changeSet: id: 1490078531546-22 author: Bert (generated) changes: - addPrimaryKey: columnNames: SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP tableName: QRTZ_TRIGGERS - changeSet: id: 1490078531546-23 author: Bert (generated) changes: - createIndex: columns: - column: name: SCHED_NAME - column: name: JOB_NAME - column: name: JOB_GROUP indexName: SCHED_NAME tableName: QRTZ_TRIGGERS - changeSet: id: 1490078531546-24 author: Bert (generated) changes: - addForeignKeyConstraint: baseColumnNames: SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP baseTableName: QRTZ_BLOB_TRIGGERS constraintName: qrtz_blob_triggers_ibfk_1 onDelete: RESTRICT onUpdate: RESTRICT referencedColumnNames: SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP referencedTableName: QRTZ_TRIGGERS - changeSet: id: 1490078531546-25 author: Bert (generated) changes: - addForeignKeyConstraint: baseColumnNames: SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP baseTableName: QRTZ_CRON_TRIGGERS constraintName: qrtz_cron_triggers_ibfk_1 onDelete: RESTRICT onUpdate: RESTRICT referencedColumnNames: SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP referencedTableName: QRTZ_TRIGGERS - changeSet: id: 1490078531546-26 author: Bert (generated) changes: - addForeignKeyConstraint: baseColumnNames: SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP baseTableName: QRTZ_SIMPLE_TRIGGERS constraintName: qrtz_simple_triggers_ibfk_1 onDelete: RESTRICT onUpdate: RESTRICT referencedColumnNames: SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP referencedTableName: QRTZ_TRIGGERS - changeSet: id: 1490078531546-27 author: Bert (generated) changes: - addForeignKeyConstraint: baseColumnNames: SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP baseTableName: QRTZ_SIMPROP_TRIGGERS constraintName: qrtz_simprop_triggers_ibfk_1 onDelete: RESTRICT onUpdate: RESTRICT referencedColumnNames: SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP referencedTableName: QRTZ_TRIGGERS - changeSet: id: 1490078531546-28 author: Bert (generated) changes: - addForeignKeyConstraint: baseColumnNames: SCHED_NAME,JOB_NAME,JOB_GROUP baseTableName: QRTZ_TRIGGERS constraintName: qrtz_triggers_ibfk_1 onDelete: RESTRICT onUpdate: RESTRICT referencedColumnNames: SCHED_NAME,JOB_NAME,JOB_GROUP referencedTableName: QRTZ_JOB_DETAILS