• Home
• com.lucidchart
• piezo-worker_2.11
• 1.12
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

CREATE TABLE job_history(
    fire_instance_id VARCHAR(120),
    job_name VARCHAR(190) NOT NULL,
    job_group VARCHAR(190) NOT NULL,
    trigger_name VARCHAR(190) NOT NULL,
    trigger_group VARCHAR(190) NOT NULL,
    success BOOLEAN NOT NULL,
    start DATETIME NOT NULL,
    finish DATETIME,
    PRIMARY KEY(fire_instance_id),
    KEY job_key(job_group, job_name),
    KEY start_key(start)
);

CREATE TABLE trigger_history(
    trigger_name VARCHAR(190) NOT NULL,
    trigger_group VARCHAR(190) NOT NULL,
    scheduled_start DATETIME NOT NULL,
    actual_start DATETIME,
    finish DATETIME NOT NULL,
    misfire BOOLEAN NOT NULL,
    fire_instance_id VARCHAR(120) NULL,
    PRIMARY KEY(trigger_group, trigger_name, scheduled_start, fire_instance_id),
    KEY sched_start_key(scheduled_start)
);