Add SO Populate Activity BB Data in Catalog DB

[so.git] / mso-catalog-db / src / test / resources / schema.sql

diff --git a/mso-catalog-db/src/test/resources/schema.sql b/mso-catalog-db/src/test/resources/schema.sql
index 92979f4..5e43f8f 100644 (file)
--- 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`),