diff options
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`), |