| Index: trunk/extensions/CentralNotice/CentralNotice.pg.psql |
| — | — | @@ -1,29 +0,0 @@ |
| 2 | | - |
| 3 | | -BEGIN; |
| 4 | | -CREATE TABLE cn_notices ( |
| 5 | | - not_id SERIAL PRIMARY KEY, |
| 6 | | - not_name TEXT NOT NULL, |
| 7 | | - not_start TIMESTAMPTZ NOT NULL, |
| 8 | | - not_end TIMESTAMPTZ NOT NULL, |
| 9 | | - not_enabled SMALLINT NOT NULL DEFAULT 0, |
| 10 | | - not_preferred SMALLINT NOT NULL DEFAULT 0, |
| 11 | | - not_locked SMALLINT NOT NULL DEFAULT 0, |
| 12 | | - not_language TEXT NOT NULL, |
| 13 | | - not_project TEXT NOT NULL |
| 14 | | -); |
| 15 | | - |
| 16 | | -CREATE TABLE cn_assignments ( |
| 17 | | - asn_id SERIAL PRIMARY KEY, |
| 18 | | - not_id INTEGER NOT NULL, |
| 19 | | - tmp_id INTEGER NOT NULL, |
| 20 | | - tmp_weight INTEGER NOT NULL |
| 21 | | -); |
| 22 | | - |
| 23 | | -CREATE TABLE cn_templates ( |
| 24 | | - tmp_id SERIAL PRIMARY KEY, |
| 25 | | - tmp_name TEXT |
| 26 | | -); |
| 27 | | -COMMIT; |