Data format is : YYYY-MM-DD
Version format is : major.minor.patch
배포자원
Item | Version | File name |
Server | 1.3.5 | scheduler-server-1.3.5.zip |
Manager | 1.4.6 | glue-scheduler-manager-1.4.6.war ( M0SA010APP.ear ) |
API | 1.2.5 | glue-scheduler-job-1.2.5.jar |
DB script | - | db_script.zip |
Manager Properties | - | meta-manager.properties |
db_script.zip + quartz-2.2.2 - tables_mysql.sql - tables_oracle.sql - tables_postgres.sql + scheduler - tables_mysql.sql <-- 수정 - tables_oracle.sql <-- 수정 - tables_postgres.sql <-- 수정 + security - tables_mysql.sql - tables_oracle.sql - tables_postgres.sql
create table SCHEDULE_JOB_MANAGER ( MANAGER_NAME varchar(50) not null, SCHEDULER_NAME varchar(50) not null, DESCRIPTION varchar(250), STATUS char(1) not null, constraint JOB_MANAGER_PK primary key (MANAGER_NAME, SCHEDULER_NAME), constraint JOB_MANAGER_FK foreign key (SCHEDULER_NAME) references SCHEDULE_SERVER (SCHEDULER_NAME) ); create table SCHEDULE_MANAGER_JOBS ( MANAGER_NAME varchar(50) not null, JOB_NAME varchar(150) not null, JOB_GROUP varchar(150) not null, constraint MANAGER_JOBS_PK primary key (MANAGER_NAME, JOB_NAME, JOB_GROUP), constraint MANAGER_JOBS_FK foreign key (JOB_NAME, JOB_GROUP) references SCHEDULE_JOB_INFO (JOB_NAME, JOB_GROUP) );