patch-category.sql 478 B

12345678910111213141516
  1. CREATE SEQUENCE category_cat_id_seq;
  2. CREATE TABLE category (
  3. cat_id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('category_cat_id_seq'),
  4. cat_title TEXT NOT NULL,
  5. cat_pages INTEGER NOT NULL DEFAULT 0,
  6. cat_subcats INTEGER NOT NULL DEFAULT 0,
  7. cat_files INTEGER NOT NULL DEFAULT 0,
  8. cat_hidden SMALLINT NOT NULL DEFAULT 0
  9. );
  10. CREATE UNIQUE INDEX category_title ON category(cat_title);
  11. CREATE INDEX category_pages ON category(cat_pages);