create.schedules.sql

CREATE TABLE schedules (
    schedule_id INT NOT NULL AUTO_INCREMENT,
    project_id INT NOT NULL,
    project_name VARCHAR(128) NOT NULL,
    flow_name VARCHAR(128) NOT NULL,
    status VARCHAR(16),
    first_sched_time BIGINT,
    timezone VARCHAR(64),
    period VARCHAR(16),
    last_modify_time BIGINT,
    next_exec_time BIGINT,
    submit_time BIGINT,
    submit_user VARCHAR(128),
    enc_type TINYINT,
    schedule_options LONGBLOB,
    PRIMARY KEY (schedule_id)
);

CREATE INDEX sched_project_id ON schedules(project_id, flow_name);