.data/sql/plivasi-shema.sql

CREATE TABLE "news" (
        "id" serial,
        "title" text NOT NULL,
        "town_date" text,
        "body" text,
        "more" text,
        "pdf" text,
        "date" date,
        "type" character(2),
        "pic" character varying(20),
        "origpic" character varying(20),
        "visible" boolean DEFAULT 't',
        "priority" integer DEFAULT 0
);

CREATE TABLE "menu" (
        "section" text,
        level int default 1,
        "item" text,
        "url" text,
        "file" text,
        "num" integer DEFAULT 0,
        "visible" boolean default false
);

CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" );

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