diff options
| author |   Bonkur, Venkat (vb8416) <vb8416@att.com> | 2019-04-10 21:10:01 -0400 |
|---|---|---|
| committer | Bonkur, Venkat (vb8416) <vb8416@att.com> | 2019-04-10 23:05:52 -0400 |
| commit | 00915790df56dbde0232e2d8d53767d8f0e7d422 (patch) | |
| tree | e17de8c0ad25648e89251617fde781eead3660c4 /mso-catalog-db/src/test/resources/schema.sql | |
| parent | ae01b62624eb897ee1d556110bf2dd189335abc0 (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.sql | 6 |
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`), |