summaryrefslogtreecommitdiffstats
path: root/mso-catalog-db/src/test/resources/schema.sql
diff options
context:
space:
mode:
authorSteve Smokowski <ss835w@att.com>2019-04-11 11:47:16 +0000
committerGerrit Code Review <gerrit@onap.org>2019-04-11 11:47:16 +0000
commit2aa56678b48362d87ae1eadfb9ab20737f83c3c6 (patch)
tree4398efc234415ea597d57424c58c22742c384043 /mso-catalog-db/src/test/resources/schema.sql
parentfb4b7ea522f859eeb8813f30004dd7c1fb7b3409 (diff)
parent00915790df56dbde0232e2d8d53767d8f0e7d422 (diff)
Merge "Add SO Populate Activity BB Data in Catalog DB"
Diffstat (limited to 'mso-catalog-db/src/test/resources/schema.sql')
-rw-r--r--mso-catalog-db/src/test/resources/schema.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/mso-catalog-db/src/test/resources/schema.sql b/mso-catalog-db/src/test/resources/schema.sql
index 92979f4f32..5e43f8f3e2 100644
--- a/mso-catalog-db/src/test/resources/schema.sql
+++ b/mso-catalog-db/src/test/resources/schema.sql
@@ -1296,7 +1296,7 @@ ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
CREATE TABLE IF NOT EXISTS `activity_spec_categories` (
- `ID` INT(11) NOT NULL,
+ `ID` INT(11) NOT NULL AUTO_INCREMENT,
`NAME` VARCHAR(200) NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE INDEX `UK_activity_spec_categories` (`NAME` ASC))
@@ -1304,7 +1304,7 @@ ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
CREATE TABLE IF NOT EXISTS `activity_spec_to_activity_spec_categories` (
- `ID` INT(11) NOT NULL,
+ `ID` INT(11) NOT NULL AUTO_INCREMENT,
`ACTIVITY_SPEC_ID` INT(11) NOT NULL,
`ACTIVITY_SPEC_CATEGORIES_ID` INT(11) NOT NULL,
PRIMARY KEY (`ID`),
@@ -1346,7 +1346,7 @@ ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
CREATE TABLE IF NOT EXISTS `activity_spec_to_user_parameters` (
- `ID` INT(11) NOT NULL,
+ `ID` INT(11) NOT NULL AUTO_INCREMENT,
`ACTIVITY_SPEC_ID` INT(11) NOT NULL,
`USER_PARAMETERS_ID` INT(11) NOT NULL,
PRIMARY KEY (`ID`),