adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V1810.1__AddModelAndModelRecipe.sql

   1 USE catalogdb;
   2
   3 create table if not exists model_recipe (
   4         `ID` INT(11) NOT NULL AUTO_INCREMENT,
   5         `MODEL_ID` INT(11),
   6         `ACTION` VARCHAR(40),
   7         `SCHEMA_VERSION` VARCHAR(40),
   8         `DESCRIPTION` VARCHAR(40),
   9         `ORCHESTRATION_URI` VARCHAR(20),
  10         `MODEL_PARAM_XSD` VARCHAR(20),
  11         `RECIPE_TIMEOUT` INT(11),
  12         `CREATION_TIMESTAMP` datetime not null default current_timestamp,
  13         PRIMARY KEY (`ID`),
  14         CONSTRAINT uk1_model_recipe UNIQUE (`MODEL_ID`, `ACTION`)
  15 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  16
  17 create table if not exists model (
  18         `ID` INT(11) NOT NULL AUTO_INCREMENT,
  19         `MODEL_CUSTOMIZATION_ID` VARCHAR(40),
  20         `MODEL_CUSTOMIZATION_NAME` VARCHAR(40),
  21         `MODEL_INVARIANT_ID` VARCHAR(40),
  22         `MODEL_NAME` VARCHAR(40),
  23         `MODEL_TYPE` VARCHAR(20),
  24         `MODEL_VERSION` VARCHAR(20),
  25         `MODEL_VERSION_ID` VARCHAR(40),
  26         `CREATION_TIMESTAMP` datetime not null default current_timestamp,
  27         `RECIPE` INT(11),
  28         PRIMARY KEY (`ID`),
  29         CONSTRAINT uk1_model UNIQUE (`MODEL_TYPE`, `MODEL_VERSION_ID`),
  30         FOREIGN KEY (`RECIPE`) REFERENCES `model_recipe` (`MODEL_ID`) ON DELETE CASCADE ON UPDATE CASCADE
  31 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;