1 |
dpavlin |
1.1 |
\connect - dpavlin |
2 |
|
|
CREATE SEQUENCE "osobe_id_seq" start 3 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
3 |
|
|
SELECT nextval ('"osobe_id_seq"'); |
4 |
|
|
CREATE SEQUENCE "poruke_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
5 |
|
|
CREATE SEQUENCE "attach_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; |
6 |
|
|
CREATE TABLE "osobe" ( |
7 |
|
|
"id" int4 DEFAULT nextval('osobe_id_seq'::text) NOT NULL, |
8 |
|
|
"login" character varying(30), |
9 |
|
|
"full_name" character varying(100), |
10 |
|
|
"email" character varying(100), |
11 |
|
|
"passwd" character varying(10), |
12 |
|
|
"upisan" timestamp DEFAULT now(), |
13 |
|
|
"disc_perm" bool DEFAULT 'f', |
14 |
|
|
"conc_perm" bool DEFAULT 'f' |
15 |
|
|
); |
16 |
|
|
CREATE TABLE "poruke" ( |
17 |
|
|
"id" int4 DEFAULT nextval('poruke_id_seq'::text) NOT NULL, |
18 |
|
|
"thread_id" int4, |
19 |
|
|
"reply_id" int4, |
20 |
|
|
"osoba_id" int4 NOT NULL, |
21 |
|
|
"datum" timestamp DEFAULT now(), |
22 |
|
|
"level" int4 DEFAULT 1, |
23 |
|
|
"sadrzaj" text, |
24 |
|
|
"pos" character varying(200) DEFAULT 'a', |
25 |
|
|
"discussion" bool DEFAULT 'f', |
26 |
|
|
"conclusion" bool DEFAULT 'f' |
27 |
|
|
); |
28 |
|
|
CREATE TABLE "attach" ( |
29 |
|
|
"id" int4 DEFAULT nextval('attach_id_seq'::text) NOT NULL, |
30 |
|
|
"poruka_id" int4 NOT NULL, |
31 |
|
|
"data" text |
32 |
|
|
); |
33 |
|
|
CREATE TABLE "topics" ( |
34 |
|
|
"id" int4, |
35 |
|
|
"title" character varying(100), |
36 |
|
|
"datum" timestamp DEFAULT now() |
37 |
|
|
); |
38 |
|
|
CREATE FUNCTION "plpgsql_call_handler" ( ) RETURNS opaque AS '/usr/lib/pgsql/plpgsql.so' LANGUAGE 'C'; |
39 |
|
|
CREATE PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL'; |
40 |
|
|
COPY "osobe" FROM stdin; |
41 |
|
|
1 dpavlin Dobrica Pavlinu¹iæ dpavlin@pliva.hr dream 2000-11-25 19:06:04+01 t f |
42 |
|
|
2 sasa Sa¹a Raiæ araic@pliva.hr raic 2000-11-25 19:06:49+01 t f |
43 |
|
|
3 zcovic ®eljko Èoviæ zeljko.covic@pliva.hr covic 2000-11-25 19:07:34+01 t t |
44 |
|
|
\. |
45 |
|
|
COPY "poruke" FROM stdin; |
46 |
|
|
\. |
47 |
|
|
COPY "attach" FROM stdin; |
48 |
|
|
\. |
49 |
|
|
COPY "topics" FROM stdin; |
50 |
|
|
\. |
51 |
|
|
CREATE UNIQUE INDEX "osobe_id_key" on "osobe" using btree ( "id" "int4_ops" ); |
52 |
|
|
CREATE UNIQUE INDEX "poruke_id_key" on "poruke" using btree ( "id" "int4_ops" ); |
53 |
|
|
CREATE UNIQUE INDEX "attach_id_key" on "attach" using btree ( "id" "int4_ops" ); |