www/wiki/maintenance/postgres/archives/patch-content_models-table.sql


1
2
3
4
5
6
7

CREATE SEQUENCE content_models_model_id_seq;
CREATE TABLE content_models (
  model_id    SMALLINT  NOT NULL PRIMARY KEY DEFAULT nextval('content_models_model_id_seq'),
  model_name  TEXT      NOT NULL
);

CREATE UNIQUE INDEX model_name ON content_models (model_name);