patch-page.sql 1.3 KB

12345678910111213141516171819202122232425
  1. CREATE SEQUENCE page_page_id_seq;
  2. CREATE TABLE page (
  3. page_id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('page_page_id_seq'),
  4. page_namespace SMALLINT NOT NULL,
  5. page_title TEXT NOT NULL,
  6. page_restrictions TEXT,
  7. page_counter BIGINT NOT NULL DEFAULT 0,
  8. page_is_redirect SMALLINT NOT NULL DEFAULT 0,
  9. page_is_new SMALLINT NOT NULL DEFAULT 0,
  10. page_random NUMERIC(15,14) NOT NULL DEFAULT RANDOM(),
  11. page_touched TIMESTAMPTZ,
  12. page_latest INTEGER NOT NULL,
  13. page_len INTEGER NOT NULL
  14. );
  15. CREATE UNIQUE INDEX page_unique_name ON page (page_namespace, page_title);
  16. CREATE INDEX page_main_title ON page (page_title) WHERE page_namespace = 0;
  17. CREATE INDEX page_talk_title ON page (page_title) WHERE page_namespace = 1;
  18. CREATE INDEX page_user_title ON page (page_title) WHERE page_namespace = 2;
  19. CREATE INDEX page_utalk_title ON page (page_title) WHERE page_namespace = 3;
  20. CREATE INDEX page_project_title ON page (page_title) WHERE page_namespace = 4;
  21. CREATE INDEX page_mediawiki_title ON page (page_title) WHERE page_namespace = 8;
  22. CREATE INDEX page_random_idx ON page (page_random);
  23. CREATE INDEX page_len_idx ON page (page_len);