aboutsummaryrefslogtreecommitdiffstats
path: root/epsdk-app-onap/src/main/resources/vid-schema.sql
diff options
context:
space:
mode:
authorSonsino, Ofir (os0695) <os0695@intl.att.com>2018-09-05 18:26:30 +0300
committerSonsino, Ofir (os0695) <os0695@intl.att.com>2018-09-05 18:26:30 +0300
commit436646fcc88913246d75e03fe4be308545e0d13e (patch)
tree2a8dd74b8b18e14f6dc4aebcffac8961d954991c /epsdk-app-onap/src/main/resources/vid-schema.sql
parent7059a9c8aa100b51cab7698b09d80ec5acee584e (diff)
Fix features.properties
Change-Id: I18bc7ca0bbc270937884eb37d375678a0cd02252 Issue-ID: VID-305 Signed-off-by: Sonsino, Ofir (os0695) <os0695@intl.att.com>
Diffstat (limited to 'epsdk-app-onap/src/main/resources/vid-schema.sql')
-rwxr-xr-xepsdk-app-onap/src/main/resources/vid-schema.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/epsdk-app-onap/src/main/resources/vid-schema.sql b/epsdk-app-onap/src/main/resources/vid-schema.sql
index 02de875b8..3f15c88aa 100755
--- a/epsdk-app-onap/src/main/resources/vid-schema.sql
+++ b/epsdk-app-onap/src/main/resources/vid-schema.sql
@@ -1378,7 +1378,20 @@ CREATE TABLE IF NOT EXISTS `vid_category_parameter_option` (
CONSTRAINT `FK_OWNING_ENTITY_OPTIONS_TO_OE` FOREIGN KEY (`CATEGORY_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_category_parameter` (`CATEGORY_ID`)
) COLLATE='utf8_bin' ENGINE=InnoDB AUTO_INCREMENT=25;
+CREATE TABLE IF NOT EXISTS `vid_job` (
+ `JOB_ID` BINARY(16) NOT NULL PRIMARY KEY,
+ `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `JOB_STATUS` VARCHAR(50) NULL COLLATE 'utf8_bin',
+ `JOB_TYPE` VARCHAR(50) NULL COLLATE 'utf8_bin',
+ `JOB_DATA` MEDIUMTEXT NULL COLLATE 'utf8_bin',
+ `PARENT_JOB_ID` BINARY(16) NULL,
+ `TAKEN_BY` VARCHAR(100) NULL COLLATE 'utf8_bin',
+ CONSTRAINT `FK_OWNING_VID_JOB_PARENT` FOREIGN KEY (`PARENT_JOB_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_job` (`JOB_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+ALTER TABLE `vid_job`
+ ADD COLUMN if NOT EXISTS `TAKEN_BY` VARCHAR (100) COLLATE 'utf8_bin';
-- ----------------------------------------------------------------------------
-- View vid_openecomp_epsdk.v_url_access
-- ----------------------------------------------------------------------------