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

Diff of /.data/inncomm.sql.prazno

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.2 by dpavlin, Thu Dec 21 15:09:03 2000 UTC revision 1.3 by dpavlin, Fri Jan 5 13:31:34 2001 UTC
# Line 1  Line 1 
1  \connect - dpavlin  \connect - dpavlin
2  CREATE SEQUENCE "osobe_id_seq" start 2 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;  CREATE SEQUENCE "osobe_id_seq" start 10 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
3  SELECT nextval ('osobe_id_seq');  SELECT nextval ('osobe_id_seq');
4  CREATE SEQUENCE "poruke_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;  CREATE SEQUENCE "poruke_id_seq" start 25 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
5  SELECT nextval ('poruke_id_seq');  SELECT nextval ('poruke_id_seq');
6  CREATE SEQUENCE "attach_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;  CREATE SEQUENCE "attach_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
7  CREATE TABLE "osobe" (  CREATE TABLE "osobe" (
# Line 12  CREATE TABLE "osobe" ( Line 12  CREATE TABLE "osobe" (
12          "passwd" character varying(10),          "passwd" character varying(10),
13          "upisan" timestamp DEFAULT now ( ),          "upisan" timestamp DEFAULT now ( ),
14          "analitical" bool DEFAULT 'f',          "analitical" bool DEFAULT 'f',
15          "solution" bool DEFAULT 'f');          "solution" bool DEFAULT 'f',
16            "last_login" timestamp);
17  CREATE TABLE "poruke" (  CREATE TABLE "poruke" (
18          "id" int4 DEFAULT nextval ( 'poruke_id_seq' ) NOT NULL,          "id" int4 DEFAULT nextval ( 'poruke_id_seq' ) NOT NULL,
19          "thread_id" int4,          "thread_id" int4,
# Line 34  CREATE TABLE "topics" ( Line 35  CREATE TABLE "topics" (
35          "datum" timestamp DEFAULT now ( ));          "datum" timestamp DEFAULT now ( ));
36  CREATE FUNCTION "plpgsql_call_handler" ( ) RETURNS opaque AS '/usr/lib/pgsql/plpgsql.so' LANGUAGE 'C';  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';  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  
 \.  
38  CREATE UNIQUE INDEX "osobe_id_key" on "osobe" using btree ( "id" "int4_ops" );  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" );  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" );  CREATE UNIQUE INDEX "attach_id_key" on "attach" using btree ( "id" "int4_ops" );
Legend:
Removed from v.1.2  
changed lines
  Added in v.1.3
  ViewVC Help
Powered by ViewVC 1.1.26