| blob | cceef89897eef48ba90a3f913f4b8cad10085054 |
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);