...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
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; |
...