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; |