CREATE TABLE ' qrtz_job_details ' (' job_name ' varchar) NOT NULL, ' job_group ' varchar ($) NOT null, ' DESCRIPTION ' varchar (+) DEFAULT null, ' job_class_name ' varchar (+) NOT null, ' is_durable ' varchar (1) is not NULL, ' is_volatile ' varchar (1) Not NULL, ' is_stateful ' varchar (1) is not NULL, ' requests_recovery ' varchar (1) is not NULL, ' Job_data ' BLOB, PRIMARY KEY (' Job_ NAME ', ' Job_group ')) engine=innodb DEFAULT charset=utf8; create TABLE ' qrtz_job_listeners ' (' job_name ' varchar ( ) not NULL, ' job_group ' varchar ($) NOT null, ' job_listener ' varchar ($) Not null,primary KEY (' job_name ', ' Job_group ' , ' Job_listener '), key ' job_name ' (' job_name ', ' Job_group '), CONSTRAINT ' Qrtz_job_listeners_ibfk_1 ' FOREIGN KEY (' Job_ NAME ', ' job_group ') REFERENCES ' qrtz_job_details ' (' job_name ', ' Job_group ')) Engine=innodb DEFAULT charset=utf8 CREATE TABLE ' qrtz_locks ' (' lock_name ' varchar (+) not null,primary KEY (' Lock_name ')) Engine=innodb DEFAULT Charset=utf8 create TABLE ' Qrtz_paused_trigger_grps ' (' TRIGGER_group ' varchar ($) Not NULL, PRIMARY KEY (' Trigger_group ')) engine=innodb DEFAULT charset=utf8 create TABLE ' qrtz_ Scheduler_state ' (' instance_name ' varchar) NOT NULL, ' Last_checkin_time ' bigint (all) not null, ' Checkin_interval ' BigInt () Not null,primary KEY (' instance_name ') Engine=innodb DEFAULT charset=utf8 create TABLE ' qrtz_triggers ' (' trigger_name ' varchar () not NULL, ' trigger_group ' varchar ($) NOT null, ' job_name ' varchar ($) NOT NULL, ' Job_group ' varchar ' is not NULL, ' is_volatile ' varchar (1) is not NULL, ' DESCRIPTION ' varchar (+) DEFAULT NULL, ' Next_fire_time ' bigint (+) default NULL, ' Prev_fire_time ' bigint (all) default NULL, ' priority ' int (one-by-one) default null, ' Trigger_state ' varchar (+) NOT null, ' trigger_type ' varchar (8) is not NULL, ' Start_time ' bigint (all) not null, ' End_time ' bigint (All) DEFAULT NU LL, ' calendar_name ' varchar ($) default null, ' Misfire_instr ' smallint (2) default null, ' Job_data ' blob,primary KEY (' Trigger_name ', ' Trigger_group '), KEY ' job_name ' (' job_name ', ' JOb_group '), CONSTRAINT ' Qrtz_triggers_ibfk_1 ' FOREIGN KEY (' job_name ', ' job_group ') REFERENCES ' qrtz_job_details ' (' JOB _name ', ' Job_group ')) engine=innodb DEFAULT charset=utf8 create TABLE ' qrtz_trigger_listeners ' (' trigger_name ' varchar (+) NOT null, ' trigger_group ' varchar ($) NOT null, ' trigger_listener ' varchar ($) Not null,primary KEY (' Trigger_name ', ' trigger_group ', ' Trigger_listener '), KEY ' trigger_name ' (' trigger_name ', ' Trigger_group '), CONSTRAINT ' Qrtz_trigger_listeners_ibfk_1 ' FOREIGN KEY (' trigger_name ', ' trigger_group ') REFERENCES ' qrtz_triggers ' (' Trigger_ NAME ', ' Trigger_group ')) engine=innodb DEFAULT charset=utf8 create TABLE ' qrtz_simple_triggers ' (' trigger_name ' varchar (+) is not null, ' trigger_group ' varchar ($) NOT null, ' Repeat_count ' bigint (7) is not NULL, ' Repeat_interval ' bigint ( Not NULL, ' times_triggered ' bigint (Ten) Not null,primary key (' trigger_name ', ' trigger_group '), key ' trigger_name ' (' Trigger_name ', ' Trigger_group '), CONSTRAINT ' Qrtz_simple_triggers_ibfk_1 ' FOREIGN KEY (' trigger_name ', ' trigger_group ') REFERENCES ' qrtz_triggers ' (' trigger_name ', ' Trigger_group ')) engine= InnoDB DEFAULT charset=utf8 create TABLE ' qrtz_blob_triggers ' (' trigger_name ' varchar () not NULL, ' Trigger_ GROUP ' varchar ' is not NULL, ' Blob_data ' blob,primary key (' trigger_name ', ' trigger_group '), key ' trigger_name ' (' Trigger_name ', ' Trigger_group '), CONSTRAINT ' Qrtz_blob_triggers_ibfk_1 ' FOREIGN KEY (' trigger_name ', ' Trigger_group ') REFERENCES ' qrtz_triggers ' (' trigger_name ', ' Trigger_group ')) engine=innodb DEFAULT charset=utf8 create TABLE ' Qrtz_calendars ' (' calendar_name ' varchar () not NULL, ' CALENDAR ' blob not NULL, PRIMARY KEY (' Calendar_name ')) engine=in Nodb DEFAULT charset=utf8create TABLE ' qrtz_cron_triggers ' (' trigger_name ' varchar () not NULL, ' Trigger_group ' varchar (+) NOT null, ' cron_expression ' varchar (+) NOT null, ' time_zone_id ' varchar ' DEFAULT null,primary KEY (' Trigger_name ', ' Trigger_group '), KEY ' trigger_name ' (' trigger_name ', ' TriggeR_group '), CONSTRAINT ' Qrtz_cron_triggers_ibfk_1 ' FOREIGN KEY (' trigger_name ', ' trigger_group ') REFERENCES ' qrtz_ TRIGGERS ' (' trigger_name ', ' Trigger_group ')) engine=innodb DEFAULT charset=utf8 create TABLE ' qrtz_fired_ TRIGGERS ' (' entry_id ' varchar) not NULL, ' trigger_name ' varchar ($) NOT null, ' trigger_group ' varchar ($) NOT NULL, ' Is_volatile ' varchar (1) NOT NULL, ' instance_name ' varchar ($) NOT null, ' Fired_time ' bigint (all) not NULL, ' priority ' int ( One) not NULL, ' state ' varchar (+) NOT null, ' job_name ' varchar ($) default null, ' Job_group ' varchar ($) default NULL, ' Is_ STATEFUL ' varchar (1) default null, ' requests_recovery ' varchar (1) default NULL, PRIMARY KEY (' entry_id ')) Engine=innodb DE FAULT Charset=utf8 insert into qrtz_locks values (' calendar_access ') INSERT into qrtz_locks values (' job_access ') I Nsert into qrtz_locks values (' misfire_access ') insert into qrtz_locks values (' state_access ') insert into Qrtz_locks VA Lues (' trigger_access ') |