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

Annotation of /.data/sql/plivasi.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.3 - (hide annotations)
Tue Jul 3 12:41:05 2001 UTC (22 years, 10 months ago) by dpavlin
Branch: MAIN
Changes since 1.2: +100 -23 lines
multi-page support

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

  ViewVC Help
Powered by ViewVC 1.1.26