...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
CREATE TABLE gobblin_job_owners ( 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; CREATE TABLE gobblin_sync_systems ( name varchar(255) NOT NULL, db_type varchar(255) NOT NULL, users varchar(255) NOT NULL, on_hold tinyint(1) NOT NULL DEFAULT '0', deprecated tinyint(1) NOT NULL DEFAULT '0', config text, created_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (name) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; CREATE TABLE gobblin_jobs ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, description varchar(255) DEFAULT NULL, schedule varchar(64) DEFAULT NULL, is_disabled tinyint(1) DEFAULT '0', priority smallint DEFAULT NULL100, configs text, owner_email varchar(255) NOT NULL, source_system varchar(255) NOT DEFAULT NULL, source#source_systemdataset varchar(255) DEFAULT NULL, target#target_systemdataset varchar(255) DEFAULTDEFAULT NULL, target_system varchar(255) NOT NULL, created_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (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 gobblin_sync_systems_maintenance ( id int(11) NOT NULL AUTO_INCREMENT, sync_system_name varchar(255) NOT NULL, type varchar(255) NOT NULL, start_time datetime NOT NULL, end_time datetime NOT NULL, PRIMARY KEY (id), FOREIGN KEY (sync_system_name) REFERENCES gobblin_sync_systems (name) ) ENGINE = InnoDB DEFAULT CHARSET = utf8; |
- Create New job example
...