CREATE TABLE gobblin_job_queue
`gobblin_job` (
`id` queue_id int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` job_name varchar(255) DEFAULT NULL,
`schedule` varchar(25564) NOTDEFAULT NULL,
`is_disabled` tinyint(1) configsDEFAULT '0',
`priority` smallint(6) DEFAULT textNULL,
`configs` text,
status `owner_email` varchar(255) DEFAULT NULL,
`source_system` varchar(255) NOTDEFAULT NULL,
job`target_idsystem` varchar(255) DEFAULT NULL,
`job_template` varchar(255) DEFAULT NULL,
created`created_datedate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated`updated_datedate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`name`),
KEY `name` (`name`),
KEY `id` (`id`),
KEY `gobblin_job_template_fk` (`job_template`),
KEY `source_system` (`source_system`),
KEY `target_system` (`target_system`),
CONSTRAINT `gobblin_job_ibfk_1` FOREIGN KEY (`source_system`) REFERENCES `gobblin_sync_system` (`id`),
CONSTRAINT `gobblin_job_ibfk_2` FOREIGN KEY (`target_system`) PRIMARYREFERENCES `gobblin_sync_system` (`id`),
CONSTRAINT `gobblin_job_template_fk` FOREIGN KEY (queue_id`job_template`) REFERENCES `gobblin_job_template` (`name`)
) ENGINE = InnoDB
AUTO_INCREMENT=25 DEFAULT CHARSET = utf8;
CREATE TABLE `gobblin_job_template` (
`name` varchar(255) NOT NULL DEFAULT '',
`configs` text NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `gobblin_sync_system` (
`id` varchar(255) NOT NULL,
`name` varchar(25564) NOT NULL,
`type` varchar(64) NOT NULL DEFAULT '',
`datacenter` varchar(64) DEFAULT NULL,
`source_system``region` varchar(25564) DEFAULT NULL,
`zone` varchar(64) DEFAULT NULL,
`users` varchar(1024) DEFAULT NULL,
`on_hold` tinyint(1) NOT NULL DEFAULT '0',
`target_system``deprecated` varchartinyint(2551) NOT NULL DEFAULT '0',
`source_support` tinyint(1) NOT NULL DEFAULT NULL'0',
`target_support` tinyint(1) NOT NULL DEFAULT '0',
`configs` text,
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`name``id`)
) 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;
|