/[pliva-si]/.data/sql/plivasi-shema.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /.data/sql/plivasi-shema.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (show annotations)
Fri Jun 29 22:47:39 2001 UTC (22 years, 9 months ago) by dpavlin
Branch: MAIN
CVS Tags: HEAD
fix

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

  ViewVC Help
Powered by ViewVC 1.1.26