• Home
• com.ecfront
• ezf-examples
• 3.2.0
• 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.

zf-examples.3.2.0.source-code.ez_ddl.sql Maven / Gradle / Ivy

CREATE TABLE IF NOT EXISTS ez_scheduler
(
    id INT NOT NULL AUTO_INCREMENT COMMENT '记录主键' ,
    name varchar(200) NOT NULL COMMENT '调度名称' ,
    cron varchar(20) NOT NULL COMMENT '调度周期' ,
    clazz varchar(200) NOT NULL COMMENT '回调执行的类' ,
    parameterstr TEXT NOT NULL COMMENT '任务参数' ,
    module varchar(200) NOT NULL COMMENT '使用的模块' ,
    enable BOOLEAN NOT NULL COMMENT '是否启用' ,
    create_user varchar(100) NOT NULL COMMENT '创建用户' ,
    create_org varchar(100) NOT NULL COMMENT '创建组织' ,
    create_time BIGINT NOT NULL COMMENT '创建时间(yyyyMMddHHmmssSSS)' ,
    update_user varchar(100) NOT NULL COMMENT '更新用户' ,
    update_org varchar(100) NOT NULL COMMENT '更新组织' ,
    update_time BIGINT NOT NULL COMMENT '更新时间(yyyyMMddHHmmssSSS)' ,
    PRIMARY KEY(id) ,
    INDEX idx_enable(enable) ,
    INDEX idx_module(module) ,
    INDEX idx_update_user(update_user) ,
    INDEX idx_update_org(update_org) ,
    INDEX idx_update_time(update_time)
)ENGINE=innodb DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS ez_scheduler_log
(
    id INT NOT NULL AUTO_INCREMENT COMMENT '记录主键' ,
    scheduler_name varchar(200) NOT NULL COMMENT '调度名称' ,
    start_time BIGINT NOT NULL COMMENT '开始时间(yyyyMMddHHmmssSSS)' ,
    end_time BIGINT NOT NULL COMMENT '结束时间(yyyyMMddHHmmssSSS)' ,
    success BOOLEAN NOT NULL COMMENT '是否成功' ,
    message varchar(500) NOT NULL COMMENT '描述' ,
    PRIMARY KEY(id)
)ENGINE=innodb DEFAULT CHARSET=utf8;