summaryrefslogtreecommitdiff
path: root/www/wiki/maintenance/archives/patch-content_models.sql
blob: 12c4c5bbf0a7b8ce8deeb11b71f73f0eecdc93a2 (plain)
1
2
3
4
5
6
7
8
9
10
--
-- Normalization table for content model names
--
CREATE TABLE /*_*/content_models (
  model_id smallint PRIMARY KEY AUTO_INCREMENT,
  model_name varbinary(64) NOT NULL
) /*$wgDBTableOptions*/;

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