summaryrefslogtreecommitdiff
path: root/www/wiki/maintenance/mssql/archives/patch-content_models.sql
blob: b94de0b39a5922d50819cc02c95bbf4427fc847a (plain)
1
2
3
4
5
6
7
8
9
10
11

--
-- Normalization table for content model names
--
CREATE TABLE /*_*/content_models (
  model_id smallint NOT NULL CONSTRAINT PK_content_models PRIMARY KEY IDENTITY,
  model_name nvarchar(64) NOT NULL
);

-- Index for looking of the internal ID of for a name
CREATE UNIQUE INDEX /*i*/model_name ON /*_*/content_models (model_name);