| Index: trunk/extensions/CentralNotice/CentralNotice.pg.psql |
| — | — | @@ -0,0 +1,29 @@ |
| | 2 | +-- Postgres version of the SQL for the CentralNotice extension |
| | 3 | +-- To load, run: psql -U wikiuser -d wikidb -f CentralNotice.pg.sql |
| | 4 | +-- Replacing the user and database as needed |
| | 5 | + |
| | 6 | +BEGIN; |
| | 7 | +CREATE TABLE cn_notices ( |
| | 8 | + not_id SERIAL PRIMARY KEY, |
| | 9 | + not_name TEXT NOT NULL, |
| | 10 | + not_start TIMESTAMPTZ NOT NULL, |
| | 11 | + not_end TIMESTAMPTZ NOT NULL, |
| | 12 | + not_enabled SMALLINT NOT NULL DEFAULT 0, |
| | 13 | + not_preferred SMALLINT NOT NULL DEFAULT 0, |
| | 14 | + not_locked SMALLINT NOT NULL DEFAULT 0, |
| | 15 | + not_language TEXT NOT NULL, |
| | 16 | + not_project TEXT NOT NULL |
| | 17 | +); |
| | 18 | + |
| | 19 | +CREATE TABLE cn_assignments ( |
| | 20 | + asn_id SERIAL PRIMARY KEY, |
| | 21 | + not_id INTEGER NOT NULL, |
| | 22 | + tmp_id INTEGER NOT NULL, |
| | 23 | + tmp_weight INTEGER NOT NULL |
| | 24 | +); |
| | 25 | + |
| | 26 | +CREATE TABLE cn_templates ( |
| | 27 | + tmp_id SERIAL PRIMARY KEY, |
| | 28 | + tmp_name TEXT |
| | 29 | +); |
| | 30 | +COMMIT; |