Page History

CREATE TABLE gobblin`gobblin_job
job` (
    id            `id` int(11)      NOT NULL AUTO_INCREMENT,
    name          `name` varchar(255) NOT NULL,
    description   varchar(255)          DEFAULT NULL,
    schedule      varchar(64)           DEFAULT NULL,
    is_disabled   tinyint(1)            DEFAULT '0',
    priority      smallint              DEFAULT 100,
    configs       `configs` text,
    owner_email   varchar(255) NOT NULL,
    source_system varchar(255) NOT NULL`version` int(11),
    target_system varchar(255) NOT NULL,
    job_template  VARCHAR(255) NULL,
    created_date  timestamp   `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_date `updated_date` timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (name`name`),
  KEY  INDEX`name` (name`name`),
  KEY `id` INDEX (id`id`)
) ENGINE=InnoDB AUTO_INCREMENT = 1
  ENGINE = InnoDB
  DEFAULT CHARSET = utf8;


CREATE TABLE gobblin_job_queue
(
    queue_id     varchar(255) NOT NULL,
    job_name     varchar(255) NOT NULL,
    configs      text,
    status       varchar(255) NOT NULL,
    job_id       varchar(255),
    created_date timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_date timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (queue_id)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8;


CREATE TABLE `gobblin_job_template`
(
    `name`          varchar(255) NOT NULL DEFAULT '',
    `source_system` varchar(255)          DEFAULT NULL,
    `target_system` varchar(255)          DEFAULT NULL,
    `configs` text NOT NULL,
    PRIMARY KEY (`name`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8;

CREATE TABLE gobblin_job_owner
(
    name         varchar(255) NOT NULL,
    email        varchar(255) NOT NULL,
    team_name    int(11)               DEFAULT NULL,
    team_email   int(11)               DEFAULT NULL,
    org_name     int(11)               DEFAULT NULL,
    created_date timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_date timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (email)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8;