summaryrefslogtreecommitdiff
path: root/maintenance/postgres/archives/patch-category.sql
blob: 5e0d620f5c22592e259f489c14b7adc4e822f506 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

CREATE SEQUENCE category_id_seq;

CREATE TABLE category (
  cat_id       INTEGER  NOT NULL  PRIMARY KEY DEFAULT nextval('category_id_seq'),
  cat_title    TEXT     NOT NULL,
  cat_pages    INTEGER  NOT NULL  DEFAULT 0,
  cat_subcats  INTEGER  NOT NULL  DEFAULT 0,
  cat_files    INTEGER  NOT NULL  DEFAULT 0,
  cat_hidden   SMALLINT NOT NULL  DEFAULT 0
);

CREATE UNIQUE INDEX category_title ON category(cat_title);
CREATE INDEX category_pages ON category(cat_pages);