maintenance/mssql/archives/patch-content_models.sql

   1
   2 --
   3 -- Normalization table for content model names
   4 --
   5 CREATE TABLE /*_*/content_models (
   6   model_id smallint NOT NULL CONSTRAINT PK_content_models PRIMARY KEY IDENTITY,
   7   model_name nvarchar(64) NOT NULL
   8 );
   9
  10 -- Index for looking of the internal ID of for a name
  11 CREATE UNIQUE INDEX /*i*/model_name ON /*_*/content_models (model_name);