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