Page History

CREATE TABLE `gobblingobblin_job_owners` owners
(
    name   `name`      varchar(255) NOT NULL DEFAULT '',
,
    email       `email` varchar(255) NOT NULL,
 DEFAULT '',
  team_name   `team_name` int(11)               DEFAULT NULL,
    team_email  `team_email` int(11)               DEFAULT NULL,
    org_name    `org_name` int(11)               DEFAULT NULL,
     `createdcreated_date`date timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP,
     `updatedupdated_date`date timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
     PRIMARY KEY (`email`email)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `gobblingobblin_sync_systems` systems
(
    `name`name         varchar(255) NOT NULL DEFAULT '',
    `db_type`db_type      varchar(255) NOT NULL DEFAULT '',
,
    users       `users` varchar(255) NOT NULL DEFAULT '',
    `on_hold`on_hold      tinyint(1)   NOT NULL DEFAULT '0',
    deprecated  `deprecated` tinyint(1)   NOT NULL DEFAULT '0',
    config  `config`     text,
    `createdcreated_date`date timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updatedupdated_date`date timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`name`name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `gobblingobblin_jobs` jobs
(
    id           `id` int(11)      NOT NULL AUTO_INCREMENT,
    name         `name` varchar(255) NOT NULL,
    `description`description   varchar(255)          DEFAULT NULL,
    schedule  `schedule`    varchar(64)           DEFAULT NULL,
    `isis_disabled`disabled   tinyint(1)            DEFAULT '0',
    priority `priority` smallint(6)     smallint              DEFAULT NULL,
    `configs`configs       text,
    `ownerowner_email`email   intvarchar(11)255)          DEFAULT NULL,
    `sourcesource_system`system varchar(11)255)           DEFAULT NULL,
    `targettarget_system`system varchar(11)255)           DEFAULT NULL,
    `createdcreated_date`date  timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updatedupdated_date`date  timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`name`name),
    FOREIGN KEY (owner_email) REFERENCES gobblin_job_owners (email),
    FOREIGN KEY (source_system) REFERENCES gobblin_sync_systems (name),
    FOREIGN KEY (target_system) REFERENCES gobblin_sync_systems (name),
    INDEX (name),
    INDEX (id)
) AUTO_INCREMENT = 1 ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `gobblingobblin_sync_systems_maintenance` maintenance
(
    id  `id`             int(11)      NOT NULL AUTO_INCREMENT,
    `syncsync_system_name`name varchar(255) NOT NULL DEFAULT '',
,
    type            `type` varchar(255) NOT NULL DEFAULT '',
    `start_time`start_time       datetime     NOT NULL,
    `end_time` datetimeend_time         datetime     NOT NULL,
    PRIMARY KEY (`id`id),
    FOREIGN KEY (sync_system_name) REFERENCES gobblin_sync_systems (name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;