inncomm/.data/inncomm.sql.prazno

\connect - dpavlin
CREATE SEQUENCE "osobe_id_seq" start 2 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('osobe_id_seq');
CREATE SEQUENCE "poruke_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('poruke_id_seq');
CREATE SEQUENCE "attach_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "osobe" (
        "id" int4 DEFAULT nextval ( 'osobe_id_seq' ) NOT NULL,
        "login" character varying(30),
        "full_name" character varying(100),
        "email" character varying(100),
        "passwd" character varying(10),
        "upisan" timestamp DEFAULT now ( ),
        "analitical" bool DEFAULT 'f',
        "solution" bool DEFAULT 'f');
CREATE TABLE "poruke" (
        "id" int4 DEFAULT nextval ( 'poruke_id_seq' ) NOT NULL,
        "thread_id" int4,
        "reply_id" int4,
        "osoba_id" int4 NOT NULL,
        "datum" timestamp DEFAULT now ( ),
        "level" int4 DEFAULT 1,
        "sadrzaj" text,
        "pos" character varying(200) DEFAULT 'a',
        "analitical" bool DEFAULT 'f',
        "solution" bool DEFAULT 'f');
CREATE TABLE "attach" (
        "id" int4 DEFAULT nextval ( 'attach_id_seq' ) NOT NULL,
        "poruka_id" int4 NOT NULL,
        "data" text);
CREATE TABLE "topics" (
        "id" int4,
        "title" character varying(100),
        "datum" timestamp DEFAULT now ( ));
CREATE FUNCTION "plpgsql_call_handler" ( ) RETURNS opaque AS '/usr/lib/pgsql/plpgsql.so' LANGUAGE 'C';
CREATE PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
COPY "osobe" FROM stdin;
1       dpavlin Dobrica Pavlinu¹iæ      dpavlin@pliva.hr        dream   2000-11-25 19:06:04+01  t       f
\.
CREATE UNIQUE INDEX "osobe_id_key" on "osobe" using btree ( "id" "int4_ops" );
CREATE UNIQUE INDEX "poruke_id_key" on "poruke" using btree ( "id" "int4_ops" );
CREATE UNIQUE INDEX "attach_id_key" on "attach" using btree ( "id" "int4_ops" );
1	\connect - dpavlin
2	CREATE SEQUENCE "osobe_id_seq" start 2 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	SELECT nextval ('poruke_id_seq');
6	CREATE SEQUENCE "attach_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
7	CREATE TABLE "osobe" (
8	"id" int4 DEFAULT nextval ( 'osobe_id_seq' ) NOT NULL,
9	"login" character varying(30),
10	"full_name" character varying(100),
11	"email" character varying(100),
12	"passwd" character varying(10),
13	"upisan" timestamp DEFAULT now ( ),
14	"analitical" bool DEFAULT 'f',
15	"solution" bool DEFAULT 'f');
16	CREATE TABLE "poruke" (
17	"id" int4 DEFAULT nextval ( 'poruke_id_seq' ) 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	"analitical" bool DEFAULT 'f',
26	"solution" bool DEFAULT 'f');
27	CREATE TABLE "attach" (
28	"id" int4 DEFAULT nextval ( 'attach_id_seq' ) NOT NULL,
29	"poruka_id" int4 NOT NULL,
30	"data" text);
31	CREATE TABLE "topics" (
32	"id" int4,
33	"title" character varying(100),
34	"datum" timestamp DEFAULT now ( ));
35	CREATE FUNCTION "plpgsql_call_handler" ( ) RETURNS opaque AS '/usr/lib/pgsql/plpgsql.so' LANGUAGE 'C';
36	CREATE PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
37	COPY "osobe" FROM stdin;
38	1 dpavlin Dobrica Pavlinu¹iæ dpavlin@pliva.hr dream 2000-11-25 19:06:04+01 t f
39	\.
40	CREATE UNIQUE INDEX "osobe_id_key" on "osobe" using btree ( "id" "int4_ops" );
41	CREATE UNIQUE INDEX "poruke_id_key" on "poruke" using btree ( "id" "int4_ops" );
42	CREATE UNIQUE INDEX "attach_id_key" on "attach" using btree ( "id" "int4_ops" );