+CREATE TABLE IF NOT EXISTS `vid_job` (\r
+ `JOB_ID` BINARY(16) NOT NULL PRIMARY KEY,\r
+ `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\r
+ `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\r
+ `JOB_STATUS` VARCHAR(50) NULL COLLATE 'utf8_bin',\r
+ `JOB_TYPE` VARCHAR(50) NULL COLLATE 'utf8_bin',\r
+ `JOB_DATA` MEDIUMTEXT NULL COLLATE 'utf8_bin',\r
+ `PARENT_JOB_ID` BINARY(16) NULL,\r
+ `TAKEN_BY` VARCHAR(100) NULL COLLATE 'utf8_bin',\r
+ CONSTRAINT `FK_OWNING_VID_JOB_PARENT` FOREIGN KEY (`PARENT_JOB_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_job` (`JOB_ID`)\r
+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;\r