summaryrefslogtreecommitdiffstats
path: root/mso-catalog-db/src/test/resources/schema.sql
diff options
context:
space:
mode:
authorBonkur, Venkat (vb8416) <vb8416@att.com>2019-04-10 21:10:01 -0400
committerBonkur, Venkat (vb8416) <vb8416@att.com>2019-04-10 23:05:52 -0400
commit00915790df56dbde0232e2d8d53767d8f0e7d422 (patch)
treee17de8c0ad25648e89251617fde781eead3660c4 /mso-catalog-db/src/test/resources/schema.sql
parentae01b62624eb897ee1d556110bf2dd189335abc0 (diff)
Add SO Populate Activity BB Data in Catalog DB
Added SO Populate Activity BB Data in Catalog DB. Populated more data for lookup tables. Created a alter script to make the id as auto increment. Issue-ID: SO-1724 Signed-off-by: Bonkur, Venkat (vb8416) <vb8416@att.com> Change-Id: I281a2a8abe4457fa76553615efccff628c3f6623
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`),