1 |
CREATE TABLE "news" ( |
2 |
"id" serial, |
3 |
"title" text NOT NULL, |
4 |
"town_date" text, |
5 |
"body" text, |
6 |
"more" text, |
7 |
"pdf" text, |
8 |
"date" date, |
9 |
"type" character(2), |
10 |
"pic" character varying(20), |
11 |
"origpic" character varying(20), |
12 |
"visible" boolean DEFAULT 't', |
13 |
"priority" integer DEFAULT 0 |
14 |
); |
15 |
|
16 |
CREATE TABLE "menu" ( |
17 |
"section" text, |
18 |
level int default 1, |
19 |
"item" text, |
20 |
"url" text, |
21 |
"file" text, |
22 |
"num" integer DEFAULT 0, |
23 |
"visible" boolean default false |
24 |
); |
25 |
|
26 |
CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" ); |
27 |
|