| Index: trunk/extensions/Oversight/hidden.pg.sql |
| — | — | @@ -0,0 +1,29 @@ |
| | 2 | +-- Postgres schema for the Oversight extension |
| | 3 | +-- See the 'hidden.sql' file for explanations of the columns |
| | 4 | + |
| | 5 | +BEGIN; |
| | 6 | + |
| | 7 | +CREATE TABLE hidden ( |
| | 8 | + hidden_page INTEGER NOT NULL DEFAULT 0, |
| | 9 | + hidden_namespace INTEGER NOT NULL DEFAULT 0, |
| | 10 | + hidden_title TEXT NOT NULL DEFAULT '', |
| | 11 | + hidden_comment TEXT NOT NULL, |
| | 12 | + hidden_user INTEGER NOT NULL DEFAULT 0, |
| | 13 | + hidden_user_text TEXT NOT NULL, |
| | 14 | + hidden_timestamp TEXT NOT NULL DEFAULT '', |
| | 15 | + hidden_minor_edit SMALLINT NOT NULL DEFAULT 0, |
| | 16 | + hidden_deleted SMALLINT NOT NULL DEFAULT 0, |
| | 17 | + hidden_rev_id INTEGER, |
| | 18 | + hidden_text_id INTEGER, |
| | 19 | + hidden_by_user INTEGER, |
| | 20 | + hidden_on_timestamp TEXT, |
| | 21 | + hidden_reason TEXT |
| | 22 | +); |
| | 23 | + |
| | 24 | +CREATE INDEX hidden_timestamp ON hidden(hidden_timestamp); |
| | 25 | +CREATE INDEX hidden_on_timestamp ON hidden(hidden_on_timestamp); |
| | 26 | +CREATE INDEX hidden_user ON hidden(hidden_by_user); |
| | 27 | +CREATE INDEX hidden_page ON hidden(hidden_page); |
| | 28 | +CREATE INDEX hidden_title ON hidden(hidden_title); |
| | 29 | + |
| | 30 | +COMMIT; |
| Property changes on: trunk/extensions/Oversight/hidden.pg.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 31 | + native |