/[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

Contents of /.data/sql/plivasi.sql

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.1 - (show annotations)
Fri Jun 29 22:43:27 2001 UTC (22 years, 10 months ago) by dpavlin
Branch: MAIN 
perm, .data dir
1 --
2 -- Selected TOC Entries:
3 --
4 \connect - postgres
5 --
6 -- TOC Entry ID 8 (OID 18720)
7 --
8 -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres
9 --
10
11 CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';
12
13 --
14 -- TOC Entry ID 9 (OID 18721)
15 --
16 -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
17 --
18
19 CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
20
21 \connect - dpavlin
22 --
23 -- TOC Entry ID 2 (OID 776747)
24 --
25 -- Name: news_id_seq Type: SEQUENCE Owner: dpavlin
26 --
27
28 CREATE SEQUENCE "news_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
29
30 --
31 -- TOC Entry ID 4 (OID 776766)
32 --
33 -- Name: news Type: TABLE Owner: dpavlin
34 --
35
36 CREATE TABLE "news" (
37 "id" integer DEFAULT nextval('"news_id_seq"'::text) NOT NULL,
38 "title" text NOT NULL,
39 "town_date" text,
40 "body" text,
41 "more" text,
42 "pdf" text,
43 "date" date,
44 "type" character(3),
45 "pic" character varying(20),
46 "origpic" character varying(20),
47 "visible" boolean DEFAULT 't',
48 "priority" integer DEFAULT 0
49 );
50
51 --
52 -- TOC Entry ID 5 (OID 776805)
53 --
54 -- Name: menu Type: TABLE Owner: dpavlin
55 --
56
57 CREATE TABLE "menu" (
58 "section" text,
59 "level" integer DEFAULT 1,
60 "item" text,
61 "url" text,
62 "file" text,
63 "num" integer DEFAULT 0,
64 "visible" boolean DEFAULT 'f',
65 "w" integer,
66 "h" integer
67 );
68
69 --
70 -- Data for TOC Entry ID 10 (OID 776766)
71 --
72 -- Name: news Type: TABLE DATA Owner: dpavlin
73 --
74
75
76 COPY "news" FROM stdin;
77 4 Veliki karavan Zagreb, ni na nebu ni na zemlji... PLIVA Ljubljana kreæe na veliko i naporno putovanje prema Kini. Cilj - pronaæi i dovuæi što više svile.
78 \
79 <p>misc: Nasveti</p> 2001-06-28 mn_ \N t 0
80 3 Tarzan, kommt hier! Kuala Lumpur, 1938 Tarzan! Tarzan!
81 \
82 <p>misc: Smernice O-m</p> 2001-06-29 msx \N t 0
83 2 Vrag Vas odnio Vrag Vas odnio Heto radim tu nesto, nesto. Testiranje i tako to.
84 \
85 <p>evnt: Pliva.si dogotki</p> TestSI.htm 2001-06-29 ep_ \N t 0
86 5 Gotovo je Ljubljana, 25 Juni 2001. Gotovo je - nema više.
87 \
88 <p>news: Strokovne novice O-m</p> 2001-06-25 ndx \N t 0
89 1 Poèetak izrade pliva.si dinamièkog web-a 28.6.2001. join us and share the joy!
90 \
91 <p>news: Novice</p> PR_loan_extension-25_06_01a.pdf 2001-06-28 nn_ \N t 0
92 6 A-ha! Ljubljana, 29 Juni 2001. A-ha! koncert u Ljubljani. Za sve ljubitelje švedskih "slavuja".
93 \
94 <p>evnt: Dogotki O-m</p> Test-2.htm 2001-06-29 epx \N t 5
95 9 KusKus Ljubljana, 29 Juni 2001. misc: Medicus O-m Medikus01_2001.pdf 2001-06-29 mcx \N t 0
96 7 Bikerski koncert za zdravnike Kuala Lumpur, 1938 Wrooom!!!!
97 \
98 <p>misc: Kongresi O-m</p> Test-3slika.htm 2001-06-21 mkx snjesko.gif \N t 0
99 8 Pharma Info Zagreb, 20 June 2001. misc: Pharma info O-m 2001-06-20 mpx \N t 0
100 10 nesto drugo Ljubljana, 27 Juni 2001. misc: Medinfo O-m lazniMedInfo.pdf 2001-06-27 mix \N t 0
101 \.
102 --
103 -- Data for TOC Entry ID 11 (OID 776805)
104 --
105 -- Name: menu Type: TABLE DATA Owner: dpavlin
106 --
107
108
109 COPY "menu" FROM stdin;
110 sladkorna 1 Mali leksikon \N mali_leksikon.gif 200 t 125 13
111 o_nas 3 V svetu \N v_svetu.gif 45 t 125 13
112 o_nas 3 Sporoèila za javnost \N sporo_ila_za_javnost.gif 35 t 125 13
113 o_nas 3 Raziskovne in\\nrazvoj \N raziskovne_in_nrazvoj.gif 40 t 125 26
114 o_nas 1 Zaposleni o_nas.php?h=zaposleni zaposleni.gif 10 t 125 13
115 izdelki 1 Zdravila brez recepta \N zdravila_brez_recepta.gif 50 t 125 13
116 izdelki 1 Raskužila \N rasku_ila.gif 55 t 125 13
117 izdelki 1 Diagnostika \N diagnostika.gif 60 t 125 13
118 izdelki 1 Veterina \N veterina.gif 65 t 125 13
119 nasveti 1 Izobraževalni kotièek \N izobra_evalni_koti_ek.gif 70 t 125 13
120 nasveti 1 Mali leksikon \N mali_leksikon.gif 75 t 125 13
121 nasveti 1 Koristni nasveti \N koristni_nasveti.gif 80 t 125 13
122 za_zdravnike 1 Zdravilo \N zdravilo.gif 85 t 125 13
123 za_zdravnike 1 Zdravljenje XYZ \N zdravljenje_xyz.gif 110 t 125 13
124 sladkorna 2 Uèna Ura \N u_na_ura.gif 205 t 125 13
125 za_zdravnike 2 Publikacije \N publikacije.gif 90 t 125 13
126 o_nas 2 PLIVA http://www.pliva.hr/ pliva.gif 20 t 125 13
127 o_nas 3 Letno Poroèilo http://www.pliva.hr/results.php?type=a letno_poro_ilo.gif 25 t 125 13
128 o_nas 3 PLIVA Magazin \N pliva_magazin.gif 30 t 125 13
129 za_zdravnike 3 Medicus za_zdravnike.php?p=publikacije&type=mcx medicus.gif 100 t 125 13
130 za_zdravnike 3 Pharma Info za_zdravnike.php?p=publikacije&type=mpx pharma_info.gif 95 t 125 13
131 za_zdravnike 3 Medinfo za_zdravnike.php?p=publikacije&type=mix medinfo.gif 105 t 125 13
132 o_nas 1 Novosti novosti.php?m=o_nas&days=0 novosti.gif 15 t 125 13
133 \.
134 --
135 -- TOC Entry ID 6 (OID 776766)
136 --
137 -- Name: "news_id_key" Type: INDEX Owner: dpavlin
138 --
139
140 CREATE UNIQUE INDEX "news_id_key" on "news" using btree ( "id" "int4_ops" );
141
142 --
143 -- TOC Entry ID 7 (OID 776805)
144 --
145 -- Name: "menu_num" Type: INDEX Owner: dpavlin
146 --
147
148 CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" );
149
150 --
151 -- TOC Entry ID 3 (OID 776747)
152 --
153 -- Name: news_id_seq Type: SEQUENCE SET Owner:
154 --
155
156 SELECT setval ('"news_id_seq"', 10, 't');
157
  ViewVC Help
Powered by ViewVC 1.1.26