/[pliva-si]/.data/sql/plivasi.sql
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/sql/plivasi.sql

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

revision 1.3 by dpavlin, Tue Jul 3 12:41:05 2001 UTC revision 1.4 by dpavlin, Mon Jul 9 08:49:46 2001 UTC
# Line 20  CREATE TRUSTED PROCEDURAL LANGUAGE 'plpg Line 20  CREATE TRUSTED PROCEDURAL LANGUAGE 'plpg
20    
21  \connect - dpavlin  \connect - dpavlin
22  --  --
23  -- TOC Entry ID 2 (OID 784158)  -- TOC Entry ID 2 (OID 115229)
24  --  --
25  -- Name: news_id_seq Type: SEQUENCE Owner: dpavlin  -- Name: news_id_seq Type: SEQUENCE Owner: dpavlin
26  --  --
# Line 28  CREATE TRUSTED PROCEDURAL LANGUAGE 'plpg Line 28  CREATE TRUSTED PROCEDURAL LANGUAGE 'plpg
28  CREATE SEQUENCE "news_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;  CREATE SEQUENCE "news_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
29    
30  --  --
31  -- TOC Entry ID 8 (OID 784177)  -- TOC Entry ID 8 (OID 115248)
32  --  --
33  -- Name: news Type: TABLE Owner: dpavlin  -- Name: news Type: TABLE Owner: dpavlin
34  --  --
# Line 49  CREATE TABLE "news" ( Line 49  CREATE TABLE "news" (
49  );  );
50    
51  --  --
52  -- TOC Entry ID 9 (OID 784216)  -- TOC Entry ID 9 (OID 115287)
53  --  --
54  -- Name: menu Type: TABLE Owner: dpavlin  -- Name: menu Type: TABLE Owner: dpavlin
55  --  --
# Line 67  CREATE TABLE "menu" ( Line 67  CREATE TABLE "menu" (
67  );  );
68    
69  --  --
70  -- TOC Entry ID 10 (OID 784252)  -- TOC Entry ID 10 (OID 115323)
71  --  --
72  -- Name: countries Type: TABLE Owner: dpavlin  -- Name: countries Type: TABLE Owner: dpavlin
73  --  --
# Line 78  CREATE TABLE "countries" ( Line 78  CREATE TABLE "countries" (
78  );  );
79    
80  --  --
81  -- TOC Entry ID 11 (OID 784278)  -- TOC Entry ID 11 (OID 115349)
82  --  --
83  -- Name: emails Type: TABLE Owner: dpavlin  -- Name: emails Type: TABLE Owner: dpavlin
84  --  --
# Line 89  CREATE TABLE "emails" ( Line 89  CREATE TABLE "emails" (
89  );  );
90    
91  --  --
92  -- TOC Entry ID 4 (OID 784304)  -- TOC Entry ID 4 (OID 115375)
93  --  --
94  -- Name: zaposleni_id_seq Type: SEQUENCE Owner: dpavlin  -- Name: zaposleni_id_seq Type: SEQUENCE Owner: dpavlin
95  --  --
# Line 97  CREATE TABLE "emails" ( Line 97  CREATE TABLE "emails" (
97  CREATE SEQUENCE "zaposleni_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;  CREATE SEQUENCE "zaposleni_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
98    
99  --  --
100  -- TOC Entry ID 12 (OID 784323)  -- TOC Entry ID 12 (OID 115394)
101  --  --
102  -- Name: zaposleni Type: TABLE Owner: dpavlin  -- Name: zaposleni Type: TABLE Owner: dpavlin
103  --  --
# Line 115  CREATE TABLE "zaposleni" ( Line 115  CREATE TABLE "zaposleni" (
115  );  );
116    
117  --  --
118  -- TOC Entry ID 6 (OID 786793)  -- TOC Entry ID 6 (OID 115428)
119  --  --
120  -- Name: multi_id_seq Type: SEQUENCE Owner: dpavlin  -- Name: multi_id_seq Type: SEQUENCE Owner: dpavlin
121  --  --
# Line 123  CREATE TABLE "zaposleni" ( Line 123  CREATE TABLE "zaposleni" (
123  CREATE SEQUENCE "multi_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;  CREATE SEQUENCE "multi_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
124    
125  --  --
126  -- TOC Entry ID 13 (OID 786812)  -- TOC Entry ID 13 (OID 115447)
127  --  --
128  -- Name: multi Type: TABLE Owner: dpavlin  -- Name: multi Type: TABLE Owner: dpavlin
129  --  --
130    
131  CREATE TABLE "multi" (  CREATE TABLE "multi" (
132          "id" integer DEFAULT nextval('"multi_id_seq"'::text) NOT NULL,          "id" integer DEFAULT nextval('"multi_id_seq"'::text) NOT NULL,
133          "menu_num" int4 NOT NULL,          "menu_num" integer NOT NULL,
134          "name" text,          "name" text,
135          "num" integer,          "num" integer,
136          "html" text NOT NULL,          "html" text NOT NULL,
137          "visible" boolean DEFAULT 't'::bool          "visible" boolean DEFAULT 't',
138            "path" text,
139            "type" character varying(1)
140  );  );
141    
142  --  --
143  -- Data for TOC Entry ID 21 (OID 784177)  -- Data for TOC Entry ID 21 (OID 115248)
144  --  --
145  -- Name: news Type: TABLE DATA Owner: dpavlin  -- Name: news Type: TABLE DATA Owner: dpavlin
146  --  --
# Line 164  COPY "news"  FROM stdin; Line 166  COPY "news"  FROM stdin;
166  10      nesto drugo     Ljubljana, 27 Juni 2001.        misc: Medinfo O-m               lazniMedInfo.pdf        2001-06-27      mix             \N      t       0  10      nesto drugo     Ljubljana, 27 Juni 2001.        misc: Medinfo O-m               lazniMedInfo.pdf        2001-06-27      mix             \N      t       0
167  \.  \.
168  --  --
169  -- Data for TOC Entry ID 22 (OID 784216)  -- Data for TOC Entry ID 22 (OID 115287)
170  --  --
171  -- Name: menu Type: TABLE DATA Owner: dpavlin  -- Name: menu Type: TABLE DATA Owner: dpavlin
172  --  --
# Line 196  za_zdravnike   3       Medinfo za_zdravnike.php? Line 198  za_zdravnike   3       Medinfo za_zdravnike.php?
198  o_nas   1       Novosti novosti.php?m=o_nas&days=0      novosti.gif     15      t       125     13  o_nas   1       Novosti novosti.php?m=o_nas&days=0      novosti.gif     15      t       125     13
199  \.  \.
200  --  --
201  -- Data for TOC Entry ID 23 (OID 784252)  -- Data for TOC Entry ID 23 (OID 115323)
202  --  --
203  -- Name: countries Type: TABLE DATA Owner: dpavlin  -- Name: countries Type: TABLE DATA Owner: dpavlin
204  --  --
# Line 315  ZW     Zimbabwe Line 317  ZW     Zimbabwe
317  ZZ      Other  ZZ      Other
318  \.  \.
319  --  --
320  -- Data for TOC Entry ID 24 (OID 784278)  -- Data for TOC Entry ID 24 (OID 115349)
321  --  --
322  -- Name: emails Type: TABLE DATA Owner: dpavlin  -- Name: emails Type: TABLE DATA Owner: dpavlin
323  --  --
# Line 325  COPY "emails"  FROM stdin; Line 327  COPY "emails"  FROM stdin;
327  o_nas   pliva-si-info@pliva.si  o_nas   pliva-si-info@pliva.si
328  \.  \.
329  --  --
330  -- Data for TOC Entry ID 25 (OID 784323)  -- Data for TOC Entry ID 25 (OID 115394)
331  --  --
332  -- Name: zaposleni Type: TABLE DATA Owner: dpavlin  -- Name: zaposleni Type: TABLE DATA Owner: dpavlin
333  --  --
# Line 362  COPY "zaposleni"  FROM stdin; Line 364  COPY "zaposleni"  FROM stdin;
364  34      Splošne informacije     \N      \N      \N      info@pliva.si   l       t  34      Splošne informacije     \N      \N      \N      info@pliva.si   l       t
365  \.  \.
366  --  --
367  -- Data for TOC Entry ID 26 (OID 786812)  -- Data for TOC Entry ID 26 (OID 115447)
368  --  --
369  -- Name: multi Type: TABLE DATA Owner: dpavlin  -- Name: multi Type: TABLE DATA Owner: dpavlin
370  --  --
371    
372    
373  COPY "multi"  FROM stdin;  COPY "multi"  FROM stdin;
374  1       40      proba multi stranice    \N      Profile-antiinfectives1.htm     t  7       40      bla2    \N      Profile-antiinfectives2.htm     t       \N      h
375  7       40      bla2    \N      Profile-antiinfectives2.htm     t  1       40      proba multi stranice    \N      Profile-antiinfectives1.htm     t       /data/corp_html/html/RnD-Main.htm       u
376  \.  \.
377  --  --
378  -- TOC Entry ID 14 (OID 784177)  -- TOC Entry ID 14 (OID 115248)
379  --  --
380  -- Name: "news_id_key" Type: INDEX Owner: dpavlin  -- Name: "news_id_key" Type: INDEX Owner: dpavlin
381  --  --
# Line 381  COPY "multi"  FROM stdin; Line 383  COPY "multi"  FROM stdin;
383  CREATE UNIQUE INDEX "news_id_key" on "news" using btree ( "id" "int4_ops" );  CREATE UNIQUE INDEX "news_id_key" on "news" using btree ( "id" "int4_ops" );
384    
385  --  --
386  -- TOC Entry ID 15 (OID 784216)  -- TOC Entry ID 15 (OID 115287)
387  --  --
388  -- Name: "menu_num" Type: INDEX Owner: dpavlin  -- Name: "menu_num" Type: INDEX Owner: dpavlin
389  --  --
# Line 389  CREATE UNIQUE INDEX "news_id_key" on "ne Line 391  CREATE UNIQUE INDEX "news_id_key" on "ne
391  CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" );  CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" );
392    
393  --  --
394  -- TOC Entry ID 16 (OID 784252)  -- TOC Entry ID 16 (OID 115323)
395  --  --
396  -- Name: "ind_countries_iso" Type: INDEX Owner: dpavlin  -- Name: "ind_countries_iso" Type: INDEX Owner: dpavlin
397  --  --
# Line 397  CREATE UNIQUE INDEX "menu_num" on "menu" Line 399  CREATE UNIQUE INDEX "menu_num" on "menu"
399  CREATE UNIQUE INDEX "ind_countries_iso" on "countries" using btree ( "iso" "varchar_ops" );  CREATE UNIQUE INDEX "ind_countries_iso" on "countries" using btree ( "iso" "varchar_ops" );
400    
401  --  --
402  -- TOC Entry ID 17 (OID 784323)  -- TOC Entry ID 17 (OID 115394)
403  --  --
404  -- Name: "zaposleni_id_key" Type: INDEX Owner: dpavlin  -- Name: "zaposleni_id_key" Type: INDEX Owner: dpavlin
405  --  --
# Line 405  CREATE UNIQUE INDEX "ind_countries_iso" Line 407  CREATE UNIQUE INDEX "ind_countries_iso"
407  CREATE UNIQUE INDEX "zaposleni_id_key" on "zaposleni" using btree ( "id" "int4_ops" );  CREATE UNIQUE INDEX "zaposleni_id_key" on "zaposleni" using btree ( "id" "int4_ops" );
408    
409  --  --
410  -- TOC Entry ID 18 (OID 786812)  -- TOC Entry ID 18 (OID 115447)
411  --  --
412  -- Name: "multi_id_key" Type: INDEX Owner: dpavlin  -- Name: "multi_id_key" Type: INDEX Owner: dpavlin
413  --  --
# Line 413  CREATE UNIQUE INDEX "zaposleni_id_key" o Line 415  CREATE UNIQUE INDEX "zaposleni_id_key" o
415  CREATE UNIQUE INDEX "multi_id_key" on "multi" using btree ( "id" "int4_ops" );  CREATE UNIQUE INDEX "multi_id_key" on "multi" using btree ( "id" "int4_ops" );
416    
417  --  --
418  -- TOC Entry ID 3 (OID 784158)  -- TOC Entry ID 3 (OID 115229)
419  --  --
420  -- Name: news_id_seq Type: SEQUENCE SET Owner:  -- Name: news_id_seq Type: SEQUENCE SET Owner:
421  --  --
# Line 421  CREATE UNIQUE INDEX "multi_id_key" on "m Line 423  CREATE UNIQUE INDEX "multi_id_key" on "m
423  SELECT setval ('"news_id_seq"', 10, 't');  SELECT setval ('"news_id_seq"', 10, 't');
424    
425  --  --
426  -- TOC Entry ID 5 (OID 784304)  -- TOC Entry ID 5 (OID 115375)
427  --  --
428  -- Name: zaposleni_id_seq Type: SEQUENCE SET Owner:  -- Name: zaposleni_id_seq Type: SEQUENCE SET Owner:
429  --  --
# Line 429  SELECT setval ('"news_id_seq"', 10, 't') Line 431  SELECT setval ('"news_id_seq"', 10, 't')
431  SELECT setval ('"zaposleni_id_seq"', 34, 't');  SELECT setval ('"zaposleni_id_seq"', 34, 't');
432    
433  --  --
434  -- TOC Entry ID 7 (OID 786793)  -- TOC Entry ID 7 (OID 115428)
435  --  --
436  -- Name: multi_id_seq Type: SEQUENCE SET Owner:  -- Name: multi_id_seq Type: SEQUENCE SET Owner:
437  --  --
Legend:
Removed from v.1.3  
changed lines
  Added in v.1.4
  ViewVC Help
Powered by ViewVC 1.1.26