/[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.4 - (show annotations)
Mon Jul 9 08:49:46 2001 UTC (22 years, 10 months ago) by dpavlin
Branch: MAIN
Changes since 1.3: +29 -27 lines
multi-page changes

1 --
2 -- Selected TOC Entries:
3 --
4 \connect - postgres
5 --
6 -- TOC Entry ID 19 (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 20 (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 115229)
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 8 (OID 115248)
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 9 (OID 115287)
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 -- TOC Entry ID 10 (OID 115323)
71 --
72 -- Name: countries Type: TABLE Owner: dpavlin
73 --
74
75 CREATE TABLE "countries" (
76 "iso" character varying(2),
77 "name" text
78 );
79
80 --
81 -- TOC Entry ID 11 (OID 115349)
82 --
83 -- Name: emails Type: TABLE Owner: dpavlin
84 --
85
86 CREATE TABLE "emails" (
87 "referer" text,
88 "email" text
89 );
90
91 --
92 -- TOC Entry ID 4 (OID 115375)
93 --
94 -- Name: zaposleni_id_seq Type: SEQUENCE Owner: dpavlin
95 --
96
97 CREATE SEQUENCE "zaposleni_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
98
99 --
100 -- TOC Entry ID 12 (OID 115394)
101 --
102 -- Name: zaposleni Type: TABLE Owner: dpavlin
103 --
104
105 CREATE TABLE "zaposleni" (
106 "id" integer DEFAULT nextval('"zaposleni_id_seq"'::text) NOT NULL,
107 "titula" text,
108 "ime" text,
109 "note" text,
110 "tel" text,
111 "email" text,
112 "pozicija" character(1),
113 "visible" boolean,
114 CONSTRAINT "zaposleni_pozicija" CHECK ((((pozicija = 'l'::bpchar) OR (pozicija = 'c'::bpchar)) OR (pozicija = 'r'::bpchar)))
115 );
116
117 --
118 -- TOC Entry ID 6 (OID 115428)
119 --
120 -- Name: multi_id_seq Type: SEQUENCE Owner: dpavlin
121 --
122
123 CREATE SEQUENCE "multi_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
124
125 --
126 -- TOC Entry ID 13 (OID 115447)
127 --
128 -- Name: multi Type: TABLE Owner: dpavlin
129 --
130
131 CREATE TABLE "multi" (
132 "id" integer DEFAULT nextval('"multi_id_seq"'::text) NOT NULL,
133 "menu_num" integer NOT NULL,
134 "name" text,
135 "num" integer,
136 "html" text NOT NULL,
137 "visible" boolean DEFAULT 't',
138 "path" text,
139 "type" character varying(1)
140 );
141
142 --
143 -- Data for TOC Entry ID 21 (OID 115248)
144 --
145 -- Name: news Type: TABLE DATA Owner: dpavlin
146 --
147
148
149 COPY "news" FROM stdin;
150 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.
151 \
152 <p>misc: Nasveti</p> 2001-06-28 mn_ \N t 0
153 3 Tarzan, kommt hier! Kuala Lumpur, 1938 Tarzan! Tarzan!
154 \
155 <p>misc: Smernice O-m</p> 2001-06-29 msx \N t 0
156 2 Vrag Vas odnio Vrag Vas odnio Heto radim tu nesto, nesto. Testiranje i tako to.
157 \
158 <p>evnt: Pliva.si dogotki</p> TestSI.htm 2001-06-29 ep_ \N t 0
159 5 Gotovo je Ljubljana, 25 Juni 2001. Gotovo je - nema više.
160 \
161 <p>news: Strokovne novice O-m</p> 2001-06-25 ndx \N t 0
162 1 Poèetak izrade pliva.si dinamièkog web-a 28.6.2001. join us and share the joy!
163 \
164 <p>news: Novice</p> PR_loan_extension-25_06_01a.pdf 2001-06-28 nn_ \N t 0
165 6 A-ha! Ljubljana, 29 Juni 2001. A-ha! koncert u Ljubljani. Za sve ljubitelje švedskih "slavuja".
166 \
167 <p>evnt: Dogotki O-m</p> Test-2.htm 2001-06-29 epx \N t 5
168 9 KusKus Ljubljana, 29 Juni 2001. misc: Medicus O-m Medikus01_2001.pdf 2001-06-29 mcx \N t 0
169 7 Bikerski koncert za zdravnike Kuala Lumpur, 1938 Wrooom!!!!
170 \
171 <p>misc: Kongresi O-m</p> Test-3slika.htm 2001-06-21 mkx snjesko.gif \N t 0
172 8 Pharma Info Zagreb, 20 June 2001. misc: Pharma info O-m 2001-06-20 mpx \N t 0
173 10 nesto drugo Ljubljana, 27 Juni 2001. misc: Medinfo O-m lazniMedInfo.pdf 2001-06-27 mix \N t 0
174 \.
175 --
176 -- Data for TOC Entry ID 22 (OID 115287)
177 --
178 -- Name: menu Type: TABLE DATA Owner: dpavlin
179 --
180
181
182 COPY "menu" FROM stdin;
183 sladkorna 1 Mali leksikon \N mali_leksikon.gif 200 t 125 13
184 o_nas 3 V svetu \N v_svetu.gif 45 t 125 13
185 o_nas 3 Sporoèila za javnost \N sporo_ila_za_javnost.gif 35 t 125 13
186 o_nas 3 Raziskovne in\\nrazvoj \N raziskovne_in_nrazvoj.gif 40 t 125 26
187 o_nas 1 Zaposleni o_nas.php?h=zaposleni zaposleni.gif 10 t 125 13
188 izdelki 1 Zdravila brez recepta \N zdravila_brez_recepta.gif 50 t 125 13
189 izdelki 1 Raskužila \N rasku_ila.gif 55 t 125 13
190 izdelki 1 Diagnostika \N diagnostika.gif 60 t 125 13
191 izdelki 1 Veterina \N veterina.gif 65 t 125 13
192 nasveti 1 Izobraževalni kotièek \N izobra_evalni_koti_ek.gif 70 t 125 13
193 nasveti 1 Mali leksikon \N mali_leksikon.gif 75 t 125 13
194 nasveti 1 Koristni nasveti \N koristni_nasveti.gif 80 t 125 13
195 za_zdravnike 1 Zdravilo \N zdravilo.gif 85 t 125 13
196 za_zdravnike 1 Zdravljenje XYZ \N zdravljenje_xyz.gif 110 t 125 13
197 sladkorna 2 Uèna Ura \N u_na_ura.gif 205 t 125 13
198 za_zdravnike 2 Publikacije \N publikacije.gif 90 t 125 13
199 o_nas 2 PLIVA http://www.pliva.hr/ pliva.gif 20 t 125 13
200 o_nas 3 Letno Poroèilo http://www.pliva.hr/results.php?type=a letno_poro_ilo.gif 25 t 125 13
201 o_nas 3 PLIVA Magazin \N pliva_magazin.gif 30 t 125 13
202 za_zdravnike 3 Medicus za_zdravnike.php?p=publikacije&type=mcx medicus.gif 100 t 125 13
203 za_zdravnike 3 Pharma Info za_zdravnike.php?p=publikacije&type=mpx pharma_info.gif 95 t 125 13
204 za_zdravnike 3 Medinfo za_zdravnike.php?p=publikacije&type=mix medinfo.gif 105 t 125 13
205 o_nas 1 Novosti novosti.php?m=o_nas&days=0 novosti.gif 15 t 125 13
206 \.
207 --
208 -- Data for TOC Entry ID 23 (OID 115323)
209 --
210 -- Name: countries Type: TABLE DATA Owner: dpavlin
211 --
212
213
214 COPY "countries" FROM stdin;
215 AG Antigua
216 AR Argentina
217 AU Australia
218 AT Austria
219 BS Bahamas
220 BH Bahrain
221 BD Bangladesh
222 BB Barbados
223 BY Belarus
224 BE Belgium
225 BM Bermuda
226 BO Bolivia
227 BA Bosnia
228 BR Brazil
229 IO Britain (UK)
230 BG Bulgaria
231 CA Canada
232 KY Cayman Islands
233 CL Chile
234 CN China
235 CO Colombia
236 HR Croatia
237 CU Cuba
238 CY Cyprus
239 CZ Czech Republic
240 DK Denmark
241 DO Dominican Republic
242 EC Ecuador
243 EG Egypt
244 SV El Salvador
245 EE Estonia
246 FI Finland
247 FR France
248 DE Germany
249 GI Gibraltar
250 GR Greece
251 GD Grenada
252 GY Guyana
253 HT Haiti
254 HN Honduras
255 HK Hong Kong
256 HU Hungary
257 IN India
258 ID Indonesia
259 IR Iran
260 IQ Iraq
261 IE Ireland
262 IL Israel
263 IT Italy
264 JM Jamaica
265 JP Japan
266 JO Jordan
267 KZ Kazakhstan
268 KE Kenya
269 KP Korea (South)
270 KW Kuwait
271 KG Kyrgyzstan
272 LV Latvia
273 LB Lebanon
274 LY Libya
275 LT Lithuania
276 MK Macedonia
277 MW Malawi
278 MY Malaysia
279 MT Malta
280 MX Mexico
281 MZ Mozambique
282 NL Netherlands
283 AN Netherlands Antilles
284 NZ New Zealand
285 NI Nicaragua
286 NG Nigeria
287 NO Norway
288 OM Oman
289 PK Pakistan
290 PA Panama
291 PY Paraguay
292 PE Peru
293 PH Philippines
294 PL Poland
295 PT Portugal
296 QA Qatar
297 RO Romania
298 RU Russian Federation
299 SA Saudi Arabia
300 SG Singapore
301 SK Slovak Republic
302 SI Slovenia
303 ZA South Africa
304 ES Spain
305 SD Sudan
306 SE Sweden
307 CH Switzerland
308 XX Switzerland (Basel)
309 SY Syria
310 TW Taiwan
311 TH Thailand
312 TT Trinidad and Tobago
313 TR Turkey
314 UA Ukraine
315 AE United Arab Emirates
316 US United States
317 UY Uruguay
318 VE Venezuela
319 VN Viet Nam
320 YE Yemen
321 YU Yugoslavia
322 ZM Zambia
323 ZW Zimbabwe
324 ZZ Other
325 \.
326 --
327 -- Data for TOC Entry ID 24 (OID 115349)
328 --
329 -- Name: emails Type: TABLE DATA Owner: dpavlin
330 --
331
332
333 COPY "emails" FROM stdin;
334 o_nas pliva-si-info@pliva.si
335 \.
336 --
337 -- Data for TOC Entry ID 25 (OID 115394)
338 --
339 -- Name: zaposleni Type: TABLE DATA Owner: dpavlin
340 --
341
342
343 COPY "zaposleni" FROM stdin;
344 8 \N PLIVA Ljubljana d.o.o registrirano podjetje od 1.8. 1992 \N \N r t
345 9 Direktor mag. Ljiljana Zagorec, dipl. oec. \N 01 436 95 53 Fax: 01 436 86 36 ljiljana.zagorec@pliva.si c t
346 11 Finance Milan Vujinoviè, dipl. oec. \N 01 436 95 76 milan.vujinovic@pliva.si r t
347 12 Vi¹ja medicinska svetovalka Barbara Marolt ®u¾ek, dr. med. \N 01 436 86 18 barbara.marolt@pliva.si l t
348 10 Vodja marketinga in prodaje farmacevtike Ur¹ka Oblak, mag. farm. \N 01 436 86 18 urska.oblak@pliva.si l t
349 1 \N Predstavni¹tvo PLIVE d.d. v Ljubljani registrirano od 1.5. 2000. \N \N l t
350 13 Vodja registracijskega in medicinskega oddelka Nata¹a Androèec-Robiè, mag. farm. \N 01 436 86 18 natasa.androcec@pliva.si r t
351 14 Poslovna korespondentka Tanja Slobodnjak \N 01 436 86 18 tanja.slobodnjak@pliva.si l t
352 15 Medicinska svetovalka Radmila Luèiè, dr. med. \N 01 436 86 18 radmila.lucic@pliva.si r t
353 16 Strokovna sodelavka za registracije Manca ©ef-Kri¾aniè, mag. farm. \N 01 436 86 18 manca.sef-krizanic@pliva.si l t
354 17 Proizvodi za za¹èito rastlin Darinka Bauman, dipl. ing. agrn \N \N darinka.bauman@pliva.si r t
355 18 Psihofarmaki Irena Mastnak, mag. farm. \N 01 436 86 18 irena.mastnak@pliva.si l t
356 20 Intim plus, dezinficijensi in diagnostika Andreja Kav¹ek, dipl. biol. \N 01 436 86 18 andreja.kavsek@pliva.si l t
357 21 Zdravila, ki so na voljo brez recepta Tatjana Hribar, dipl. ing. ¾ivil. teh. \N 01 436 92 22 tatjana.hribar@pliva.si l t
358 22 Podroèje antibiotikov Zdenka Ferenèak, dipl. univ. biol. \N 01 436 86 18 zdenka.ferencak@pliva.si l t
359 23 Zdravila za uporabo v kardiologiji Erika Ko¹ir, mag. farm. \N 01 436 86 18 erika.kosir@pliva.si l t
360 24 Vi¹ja strokovna sodelavka Danica Berce, mag. farm. \N 01 436 86 18 danica.berce@pliva.si l t
361 25 Vi¹ja strokovna sodelavka Majda Marc, mag. farm. \N 01 436 86 18 majda.marc@pliva.si l t
362 19 Zdravila za zdravljenje diabetesa Rosana Potokar, mag. farm. \N 01 436 86 18 rosana.potokar@pliva.si l t
363 26 Poslovni sekretar Jelka Primo¾iè \N 01 436 95 69 jelka.primozic@pliva.si l t
364 27 Strokovna sodelavka Kristina Pahljina, dipl. ing. bioteh. \N 01 436 86 18 kristina.pahljina@pliva.si l t
365 28 Strokovna sodelavka Maja Kovaèiè, uni. dipl. mikrobiolog \N 01 436 86 18 maja.kovacic@pliva.si l t
366 29 Strokovna sodelavka Brigita Tepu¹, dipl. ing. \N 01 436 86 18 brigita.tepus@pliva.si l t
367 30 Strokovna sodelavka Andreja Podlogar, mag. farm. \N 01 436 86 18 andreja.podlogar@pliva.si l t
368 31 Strokovni sodelavec Robert Pevec, mag. farm. \N 01 436 86 13 robert.pevec@pliva.si l t
369 32 Veterinarski izdelki Darja Bri¹nik, dr. vet. med. \N 01 436 92 22 darja.brisnik@pliva.si l t
370 33 \N Sandra Giovani, dr. vet. med. \N 01 436 92 22 sandra.giovani@pliva.si l t
371 34 Splo¹ne informacije \N \N \N info@pliva.si l t
372 \.
373 --
374 -- Data for TOC Entry ID 26 (OID 115447)
375 --
376 -- Name: multi Type: TABLE DATA Owner: dpavlin
377 --
378
379
380 COPY "multi" FROM stdin;
381 7 40 bla2 \N Profile-antiinfectives2.htm t \N h
382 1 40 proba multi stranice \N Profile-antiinfectives1.htm t /data/corp_html/html/RnD-Main.htm u
383 \.
384 --
385 -- TOC Entry ID 14 (OID 115248)
386 --
387 -- Name: "news_id_key" Type: INDEX Owner: dpavlin
388 --
389
390 CREATE UNIQUE INDEX "news_id_key" on "news" using btree ( "id" "int4_ops" );
391
392 --
393 -- TOC Entry ID 15 (OID 115287)
394 --
395 -- Name: "menu_num" Type: INDEX Owner: dpavlin
396 --
397
398 CREATE UNIQUE INDEX "menu_num" on "menu" using btree ( "num" "int4_ops" );
399
400 --
401 -- TOC Entry ID 16 (OID 115323)
402 --
403 -- Name: "ind_countries_iso" Type: INDEX Owner: dpavlin
404 --
405
406 CREATE UNIQUE INDEX "ind_countries_iso" on "countries" using btree ( "iso" "varchar_ops" );
407
408 --
409 -- TOC Entry ID 17 (OID 115394)
410 --
411 -- Name: "zaposleni_id_key" Type: INDEX Owner: dpavlin
412 --
413
414 CREATE UNIQUE INDEX "zaposleni_id_key" on "zaposleni" using btree ( "id" "int4_ops" );
415
416 --
417 -- TOC Entry ID 18 (OID 115447)
418 --
419 -- Name: "multi_id_key" Type: INDEX Owner: dpavlin
420 --
421
422 CREATE UNIQUE INDEX "multi_id_key" on "multi" using btree ( "id" "int4_ops" );
423
424 --
425 -- TOC Entry ID 3 (OID 115229)
426 --
427 -- Name: news_id_seq Type: SEQUENCE SET Owner:
428 --
429
430 SELECT setval ('"news_id_seq"', 10, 't');
431
432 --
433 -- TOC Entry ID 5 (OID 115375)
434 --
435 -- Name: zaposleni_id_seq Type: SEQUENCE SET Owner:
436 --
437
438 SELECT setval ('"zaposleni_id_seq"', 34, 't');
439
440 --
441 -- TOC Entry ID 7 (OID 115428)
442 --
443 -- Name: multi_id_seq Type: SEQUENCE SET Owner:
444 --
445
446 SELECT setval ('"multi_id_seq"', 8, 't');
447

  ViewVC Help
Powered by ViewVC 1.1.26