...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
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; |
JOB MGMT. CRUD REST API
Create New job example
...