inncomm/.data/inncomm.sql.prazno

\connect - dpavlin
CREATE SEQUENCE "osobe_id_seq" start 10 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
SELECT nextval ('osobe_id_seq');
CREATE SEQUENCE "poruke_id_seq" start 25 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',
        "last_login" timestamp);
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';
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	dpavlin	1.1	\connect - dpavlin
2	dpavlin	1.3	CREATE SEQUENCE "osobe_id_seq" start 10 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
3	dpavlin	1.2	SELECT nextval ('osobe_id_seq');
4	dpavlin	1.3	CREATE SEQUENCE "poruke_id_seq" start 25 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
5	dpavlin	1.2	SELECT nextval ('poruke_id_seq');
6	dpavlin	1.1	CREATE SEQUENCE "attach_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
7			CREATE TABLE "osobe" (
8	dpavlin	1.2	"id" int4 DEFAULT nextval ( 'osobe_id_seq' ) NOT NULL,
9	dpavlin	1.1	"login" character varying(30),
10			"full_name" character varying(100),
11			"email" character varying(100),
12			"passwd" character varying(10),
13	dpavlin	1.2	"upisan" timestamp DEFAULT now ( ),
14			"analitical" bool DEFAULT 'f',
15	dpavlin	1.3	"solution" bool DEFAULT 'f',
16			"last_login" timestamp);
17	dpavlin	1.1	CREATE TABLE "poruke" (
18	dpavlin	1.2	"id" int4 DEFAULT nextval ( 'poruke_id_seq' ) NOT NULL,
19	dpavlin	1.1	"thread_id" int4,
20			"reply_id" int4,
21			"osoba_id" int4 NOT NULL,
22	dpavlin	1.2	"datum" timestamp DEFAULT now ( ),
23	dpavlin	1.1	"level" int4 DEFAULT 1,
24			"sadrzaj" text,
25			"pos" character varying(200) DEFAULT 'a',
26	dpavlin	1.2	"analitical" bool DEFAULT 'f',
27			"solution" bool DEFAULT 'f');
28	dpavlin	1.1	CREATE TABLE "attach" (
29	dpavlin	1.2	"id" int4 DEFAULT nextval ( 'attach_id_seq' ) NOT NULL,
30	dpavlin	1.1	"poruka_id" int4 NOT NULL,
31	dpavlin	1.2	"data" text);
32	dpavlin	1.1	CREATE TABLE "topics" (
33			"id" int4,
34			"title" character varying(100),
35	dpavlin	1.2	"datum" timestamp DEFAULT now ( ));
36	dpavlin	1.1	CREATE FUNCTION "plpgsql_call_handler" ( ) RETURNS opaque AS '/usr/lib/pgsql/plpgsql.so' LANGUAGE 'C';
37			CREATE PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
38			CREATE UNIQUE INDEX "osobe_id_key" on "osobe" using btree ( "id" "int4_ops" );
39			CREATE UNIQUE INDEX "poruke_id_key" on "poruke" using btree ( "id" "int4_ops" );
40			CREATE UNIQUE INDEX "attach_id_key" on "attach" using btree ( "id" "int4_ops" );