/[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.3 - (show annotations)
Tue Jul 3 12:41:05 2001 UTC (22 years, 9 months ago) by dpavlin
Branch: MAIN
Changes since 1.2: +100 -23 lines
multi-page support

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

  ViewVC Help
Powered by ViewVC 1.1.26