1 |
dpavlin |
1.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 |
|
|
|