All Downloads are FREE. Search and download functionalities are using the official Maven repository.

t.piezo-worker_2.11.1.12.source-code.alter_tables_mysql.sql Maven / Gradle / Ivy

There is a newer version: 2.3.0
Show newest version
START TRANSACTION;

ALTER TABLE QRTZ_JOB_DETAILS
  MODIFY COLUMN `JOB_NAME` VARCHAR(190) NOT NULL,
  MODIFY COLUMN `JOB_GROUP` VARCHAR(190) NOT NULL;

ALTER TABLE QRTZ_TRIGGERS
  MODIFY COLUMN `TRIGGER_NAME` VARCHAR(190) NOT NULL,
  MODIFY COLUMN `TRIGGER_GROUP` VARCHAR(190) NOT NULL,
  MODIFY COLUMN `JOB_NAME` VARCHAR(190) NOT NULL,
  MODIFY COLUMN `JOB_GROUP` VARCHAR(190) NOT NULL;

ALTER TABLE QRTZ_SIMPLE_TRIGGERS
  MODIFY COLUMN `TRIGGER_NAME` VARCHAR(190) NOT NULL,
  MODIFY COLUMN `TRIGGER_GROUP` VARCHAR(190) NOT NULL;

ALTER TABLE QRTZ_CRON_TRIGGERS
  MODIFY COLUMN `TRIGGER_NAME` VARCHAR(190) NOT NULL,
  MODIFY COLUMN `TRIGGER_GROUP` VARCHAR(190) NOT NULL;

ALTER TABLE QRTZ_SIMPROP_TRIGGERS
  MODIFY COLUMN `TRIGGER_GROUP` VARCHAR(190) NOT NULL,
  MODIFY COLUMN `TRIGGER_NAME` VARCHAR(190) NOT NULL;

ALTER TABLE QRTZ_BLOB_TRIGGERS
  MODIFY COLUMN `TRIGGER_NAME` VARCHAR(190) NOT NULL,
  MODIFY COLUMN `TRIGGER_GROUP` VARCHAR(190) NOT NULL;

ALTER TABLE QRTZ_CALENDARS
  MODIFY COLUMN `CALENDAR_NAME`  VARCHAR(190) NOT NULL;

ALTER TABLE QRTZ_PAUSED_TRIGGER_GRPS
  MODIFY COLUMN `TRIGGER_GROUP`  VARCHAR(190) NOT NULL;

ALTER TABLE QRTZ_FIRED_TRIGGERS
  MODIFY COLUMN `TRIGGER_NAME` VARCHAR(190) NOT NULL,
  MODIFY COLUMN `TRIGGER_GROUP` VARCHAR(190) NOT NULL,
  MODIFY COLUMN `JOB_NAME` VARCHAR(190) NULL,
  MODIFY COLUMN `JOB_GROUP` VARCHAR(190) NULL;

ALTER TABLE QRTZ_SCHEDULER_STATE
  MODIFY COLUMN `INSTANCE_NAME` VARCHAR(190) NOT NULL;

COMMIT;




© 2015 - 2025 Weber Informatics LLC | Privacy Policy