Page History

CREATE TABLE gobblin_job_owners
(
    id   name         varcharint(25511)      NOT NULL AUTO_INCREMENT,
    name  email        varchar(255) NOT NULL,
    team_namedescription    intvarchar(11255)               DEFAULT NULL,
    team_emailschedule   int(11)    varchar(64)           DEFAULT NULL,
    orgis_namedisabled     inttinyint(111)               DEFAULT NULL'0',
    priority created_date timestamp    NOTsmallint NULL DEFAULT CURRENT_TIMESTAMP,
    updated_date timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP100,
    PRIMARYconfigs KEY (email)
) ENGINE = InnoDB
  DEFAULTtext,
 CHARSET = utf8;

CREATE TABLE gobblin_sync_systems
(
    name     owner_email    varchar(255) NOT NULL,
    db_type      source_system varchar(255) NOT NULL,
    users        target_system varchar(255) NOT NULL,
    onjob_holdtemplate      tinyint(1)   NOT NULL DEFAULT '0',
    deprecated   tinyint(1)   NOT NULL DEFAULT '0',
    config       textVARCHAR(255) NULL,
    created_date  timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_date  timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (name),
    INDEX (name),
    INDEX (id)
) AUTO_INCREMENT = 1
  ENGINE = InnoDB
  DEFAULT CHARSET = utf8;


CREATE TABLE gobblin_job_jobsqueue
(
    queue_id            int(11)      varchar(255) NOT NULL AUTO_INCREMENT,
    job_name          varchar(255) NOT NULL,
    description   varchar(255)configs          DEFAULT NULLtext,
    status schedule      varchar(64255) NOT NULL,
    job_id     DEFAULT NULL  varchar(255),
    iscreated_disabled   tinyint(1)date timestamp           NOT NULL DEFAULT '0'CURRENT_TIMESTAMP,
    priorityupdated_date timestamp    NOT smallintNULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (queue_id)
) ENGINE = DEFAULT 100,InnoDB
  DEFAULT CHARSET configs       text,= utf8;


CREATE TABLE `gobblin_job_template`
(
    owner_email`name`   varchar(255) NOT NULL,
    source_system varchar(255) NOT NULL DEFAULT '',
    #source`source_datasetsystem` varchar(255)          DEFAULT NULL,
    #target`target_datasetsystem` varchar(255)          DEFAULT NULL,
    target_system varchar(255)`configs` text NOT NULL,
    created_datePRIMARY KEY timestamp(`name`)
) ENGINE = InnoDB
 NOT NULL DEFAULT CURRENT_TIMESTAMP,
CHARSET = utf8;

CREATE TABLE updated_date  timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,gobblin_job_owner
(
    PRIMARYname KEY (name),
#     FOREIGN KEY varchar(owner_email255) REFERENCES gobblin_job_owners (email)NOT NULL,
#    email FOREIGN KEY (source_system) REFERENCES gobblin_sync_systems (name),
#     FOREIGN KEY (target_systemvarchar(255) REFERENCES gobblin_sync_systems (name)NOT NULL,
    INDEX (name),
team_name    INDEX (id)
int(11) AUTO_INCREMENT = 1
  ENGINE = InnoDB
  DEFAULT CHARSET = utf8;


CREATE TABLE gobblin_sync_systems_maintenance
(
    id      DEFAULT NULL,
    team_email   int(11)          int(11)      NOTDEFAULT NULL AUTO_INCREMENT,
    syncorg_system_name varchar(255) NOT NULL,
  int(11)  type             varchar(255) NOTDEFAULT NULL,
    startcreated_timedate timestamp    NOT NULL datetime     NOT NULLDEFAULT CURRENT_TIMESTAMP,
    endupdated_time         datetime date timestamp    NOT NULL,
 DEFAULT CURRENT_TIMESTAMP ON PRIMARY KEY (id)UPDATE CURRENT_TIMESTAMP,
    FOREIGNPRIMARY KEY (sync_system_name) REFERENCES gobblin_sync_systems (name)email)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8;