1 files changed, 11 insertions, 0 deletions
diff --git a/www/wiki/maintenance/mssql/archives/patch-content_models.sql b/www/wiki/maintenance/mssql/archives/patch-content_models.sql
new file mode 100644
index 00000000..b94de0b3
--- /dev/null
+++ b/www/wiki/maintenance/mssql/archives/patch-content_models.sql
@@ -0,0 +1,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);
+\ No newline at end of file