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	\connect - dpavlin
2	CREATE SEQUENCE "osobe_id_seq" start 10 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
3	SELECT nextval ('osobe_id_seq');
4	CREATE SEQUENCE "poruke_id_seq" start 25 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	"last_login" timestamp);
17	CREATE TABLE "poruke" (
18	"id" int4 DEFAULT nextval ( 'poruke_id_seq' ) NOT NULL,
19	"thread_id" int4,
20	"reply_id" int4,
21	"osoba_id" int4 NOT NULL,
22	"datum" timestamp DEFAULT now ( ),
23	"level" int4 DEFAULT 1,
24	"sadrzaj" text,
25	"pos" character varying(200) DEFAULT 'a',
26	"analitical" bool DEFAULT 'f',
27	"solution" bool DEFAULT 'f');
28	CREATE TABLE "attach" (
29	"id" int4 DEFAULT nextval ( 'attach_id_seq' ) NOT NULL,
30	"poruka_id" int4 NOT NULL,
31	"data" text);
32	CREATE TABLE "topics" (
33	"id" int4,
34	"title" character varying(100),
35	"datum" timestamp DEFAULT now ( ));
36	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" );