1 |
dpavlin |
34 |
------------------------------------------------------------------ |
2 |
|
|
-- My2Pg 1.28 translated dump |
3 |
|
|
-- |
4 |
|
|
------------------------------------------------------------------ |
5 |
|
|
|
6 |
|
|
BEGIN; |
7 |
|
|
|
8 |
|
|
|
9 |
|
|
|
10 |
|
|
|
11 |
|
|
-- |
12 |
|
|
-- Sequences for table ACCESS |
13 |
|
|
-- |
14 |
|
|
|
15 |
|
|
CREATE SEQUENCE access_access_id_seq; |
16 |
|
|
|
17 |
|
|
-- MySQL dump 9.10 |
18 |
|
|
-- |
19 |
|
|
-- Host: localhost Database: libdata |
20 |
|
|
-- ------------------------------------------------------ |
21 |
|
|
-- Server version 4.0.18-log |
22 |
|
|
|
23 |
|
|
-- |
24 |
|
|
-- Table structure for table `access` |
25 |
|
|
-- |
26 |
|
|
|
27 |
|
|
CREATE TABLE access ( |
28 |
|
|
access_id INT4 DEFAULT nextval('access_access_id_seq'), |
29 |
|
|
access_level INT4 DEFAULT NULL, |
30 |
|
|
access varchar(25) DEFAULT NULL, |
31 |
|
|
PRIMARY KEY (access_id) |
32 |
|
|
|
33 |
|
|
); |
34 |
|
|
|
35 |
|
|
-- |
36 |
|
|
-- Dumping data for table `access` |
37 |
|
|
-- |
38 |
|
|
|
39 |
|
|
INSERT INTO access VALUES (1,0,'Denied'); |
40 |
|
|
INSERT INTO access VALUES (2,10,'Guest'); |
41 |
|
|
INSERT INTO access VALUES (3,20,'Author'); |
42 |
|
|
INSERT INTO access VALUES (4,100,'Manager'); |
43 |
|
|
INSERT INTO access VALUES (5,1000,'DBA'); |
44 |
|
|
|
45 |
|
|
-- |
46 |
|
|
-- Table structure for table `campus` |
47 |
|
|
-- |
48 |
|
|
|
49 |
|
|
|
50 |
|
|
|
51 |
|
|
-- |
52 |
|
|
-- Sequences for table CAMPUS |
53 |
|
|
-- |
54 |
|
|
|
55 |
|
|
CREATE SEQUENCE campus_campus_id_seq; |
56 |
|
|
|
57 |
|
|
CREATE TABLE campus ( |
58 |
|
|
campus_id INT4 DEFAULT nextval('campus_campus_id_seq'), |
59 |
|
|
campus varchar(50) DEFAULT NULL, |
60 |
|
|
institution varchar(10) DEFAULT NULL, |
61 |
|
|
PRIMARY KEY (campus_id) |
62 |
|
|
|
63 |
|
|
); |
64 |
|
|
|
65 |
|
|
-- |
66 |
|
|
-- Dumping data for table `campus` |
67 |
|
|
-- |
68 |
|
|
|
69 |
|
|
INSERT INTO campus VALUES (1,'(N/A)','(N/A)'); |
70 |
|
|
|
71 |
|
|
-- |
72 |
|
|
-- Table structure for table `coursesub` |
73 |
|
|
-- |
74 |
|
|
|
75 |
|
|
|
76 |
|
|
|
77 |
|
|
-- |
78 |
|
|
-- Sequences for table COURSESUB |
79 |
|
|
-- |
80 |
|
|
|
81 |
|
|
CREATE SEQUENCE coursesub_coursesub_id_seq; |
82 |
|
|
|
83 |
|
|
CREATE TABLE coursesub ( |
84 |
|
|
coursesub_id INT4 DEFAULT nextval('coursesub_coursesub_id_seq'), |
85 |
|
|
coursesub varchar(15) DEFAULT NULL, |
86 |
|
|
coursesub_descr varchar(100) DEFAULT NULL, |
87 |
|
|
cip_code varchar(50) DEFAULT NULL, |
88 |
dpavlin |
43 |
campus_id INT4 references campus(campus_id) on delete cascade on update cascade, |
89 |
dpavlin |
34 |
PRIMARY KEY (coursesub_id) |
90 |
|
|
|
91 |
|
|
); |
92 |
|
|
|
93 |
|
|
-- |
94 |
|
|
-- Dumping data for table `coursesub` |
95 |
|
|
-- |
96 |
|
|
|
97 |
|
|
INSERT INTO coursesub VALUES (1,'(N/A)','(N/A)',NULL,NULL); |
98 |
|
|
INSERT INTO coursesub VALUES (554,'ASTRO','Astronomy','',1); |
99 |
|
|
INSERT INTO coursesub VALUES (553,'ANTH','Anthropology','',1); |
100 |
|
|
INSERT INTO coursesub VALUES (555,'PSIHO','Uvod u psihologiju','',1); |
101 |
|
|
|
102 |
|
|
-- |
103 |
|
|
-- Table structure for table `term` |
104 |
|
|
-- |
105 |
|
|
|
106 |
|
|
|
107 |
|
|
|
108 |
|
|
-- |
109 |
|
|
-- Sequences for table TERM |
110 |
|
|
-- |
111 |
|
|
|
112 |
|
|
CREATE SEQUENCE term_term_id_seq; |
113 |
|
|
|
114 |
|
|
CREATE TABLE term ( |
115 |
|
|
term_id INT4 DEFAULT nextval('term_term_id_seq'), |
116 |
|
|
term varchar(150) DEFAULT NULL, |
117 |
|
|
PRIMARY KEY (term_id) |
118 |
|
|
|
119 |
|
|
); |
120 |
|
|
|
121 |
|
|
-- |
122 |
|
|
-- Dumping data for table `term` |
123 |
|
|
-- |
124 |
|
|
|
125 |
|
|
INSERT INTO term VALUES (1,'(N/A)'); |
126 |
|
|
INSERT INTO term VALUES (2,'Fall Semester'); |
127 |
|
|
INSERT INTO term VALUES (3,'Spring Semester'); |
128 |
|
|
INSERT INTO term VALUES (4,'Summer Term'); |
129 |
|
|
|
130 |
|
|
-- |
131 |
|
|
-- Table structure for table `style` |
132 |
|
|
-- |
133 |
|
|
|
134 |
|
|
|
135 |
|
|
|
136 |
|
|
-- |
137 |
|
|
-- Sequences for table STYLE |
138 |
|
|
-- |
139 |
|
|
|
140 |
|
|
CREATE SEQUENCE style_style_id_seq; |
141 |
|
|
|
142 |
|
|
CREATE TABLE style ( |
143 |
|
|
style_id INT4 DEFAULT nextval('style_style_id_seq'), |
144 |
|
|
style_title varchar(100) DEFAULT NULL, |
145 |
|
|
header_file varchar(255) DEFAULT NULL, |
146 |
|
|
footer_file varchar(255) DEFAULT NULL, |
147 |
|
|
css_file varchar(255) DEFAULT NULL, |
148 |
|
|
PRIMARY KEY (style_id) |
149 |
|
|
|
150 |
|
|
); |
151 |
|
|
|
152 |
|
|
-- |
153 |
|
|
-- Dumping data for table `style` |
154 |
|
|
-- |
155 |
|
|
|
156 |
|
|
INSERT INTO style VALUES (1,'(N/A)',NULL,NULL,NULL); |
157 |
|
|
INSERT INTO style VALUES (2,'LibData Standard','header.phtml','footer.phtml','libdata.css'); |
158 |
|
|
INSERT INTO style VALUES (10,'LibData Inverse Demo','styles/libinverse/header.phtml','styles/libinverse/footer.phtml','styles/libinverse/libdata.css'); |
159 |
|
|
|
160 |
|
|
-- |
161 |
|
|
-- Table structure for table `pagetype` |
162 |
|
|
-- |
163 |
|
|
|
164 |
|
|
|
165 |
|
|
|
166 |
|
|
-- |
167 |
|
|
-- Sequences for table PAGETYPE |
168 |
|
|
-- |
169 |
|
|
|
170 |
|
|
CREATE SEQUENCE pagetype_pagetype_id_seq; |
171 |
|
|
|
172 |
|
|
CREATE TABLE pagetype ( |
173 |
|
|
pagetype_id INT4 DEFAULT nextval('pagetype_pagetype_id_seq'), |
174 |
|
|
pagetype varchar(50) DEFAULT NULL, |
175 |
|
|
PRIMARY KEY (pagetype_id) |
176 |
|
|
|
177 |
|
|
); |
178 |
|
|
|
179 |
|
|
-- |
180 |
|
|
-- Dumping data for table `pagetype` |
181 |
|
|
-- |
182 |
|
|
|
183 |
|
|
INSERT INTO pagetype VALUES (1,'(N/A)'); |
184 |
|
|
INSERT INTO pagetype VALUES (2,'Free Form'); |
185 |
|
|
INSERT INTO pagetype VALUES (3,'CourseLib'); |
186 |
|
|
|
187 |
|
|
-- |
188 |
|
|
-- Table structure for table `page` |
189 |
|
|
-- |
190 |
|
|
|
191 |
|
|
|
192 |
|
|
|
193 |
|
|
-- |
194 |
|
|
-- Sequences for table PAGE |
195 |
|
|
-- |
196 |
|
|
|
197 |
|
|
CREATE SEQUENCE page_page_id_seq; |
198 |
|
|
|
199 |
|
|
CREATE TABLE page ( |
200 |
|
|
page_id INT4 DEFAULT nextval('page_page_id_seq'), |
201 |
|
|
date_created TIMESTAMP DEFAULT NULL, |
202 |
|
|
date_modified TIMESTAMP DEFAULT NULL, |
203 |
|
|
account_created varchar(20) DEFAULT NULL, |
204 |
|
|
account_modified varchar(20) DEFAULT NULL, |
205 |
|
|
staff_coordinator INT4 DEFAULT NULL, |
206 |
dpavlin |
43 |
style_id INT4 references style(style_id) on delete cascade on update cascade, |
207 |
|
|
pagetype_id INT4 references pagetype(pagetype_id) on delete cascade on update cascade, |
208 |
dpavlin |
34 |
page_title varchar(255) DEFAULT NULL, |
209 |
dpavlin |
43 |
pagetitle_style INT2 references style(style_id) on delete cascade on update cascade, |
210 |
dpavlin |
34 |
published char(1) DEFAULT NULL, |
211 |
|
|
display_urls char(1) DEFAULT NULL, |
212 |
|
|
display_toc char(1) DEFAULT NULL, |
213 |
|
|
wrap_toc char(1) DEFAULT NULL, |
214 |
|
|
display_up char(1) DEFAULT NULL, |
215 |
|
|
up_text varchar(50) DEFAULT NULL, |
216 |
|
|
pageheader text, |
217 |
|
|
pageHTML text, |
218 |
|
|
page_debug char(1) DEFAULT NULL, |
219 |
|
|
PRIMARY KEY (page_id) |
220 |
|
|
|
221 |
|
|
); |
222 |
|
|
|
223 |
|
|
-- |
224 |
|
|
-- Dumping data for table `page` |
225 |
|
|
-- |
226 |
|
|
|
227 |
|
|
INSERT INTO page VALUES (4,'2003-09-24 09:29:36','2004-03-04 00:52:57','admin','admin',2,2,2,'Further SETI Resources',NULL,'1',NULL,'0',NULL,'1','[Return to Top]','header',NULL,NULL); |
228 |
|
|
INSERT INTO page VALUES (15,'2003-10-06 10:01:31','2004-02-17 00:14:32','admin','admin',2,2,3,'Advanced Topics in Astronomy',NULL,'1','0','1','0','1','[Return to Top]',NULL,NULL,NULL); |
229 |
|
|
INSERT INTO page VALUES (17,'2004-03-03 20:57:24','2004-03-03 21:02:04','admin','admin',2,2,2,'Knji¾nica psihologije',1,'1','0','0','1','1','[Return to Top]','',NULL,NULL); |
230 |
|
|
INSERT INTO page VALUES (18,'2004-03-04 00:52:57','2004-03-04 00:57:05','admin','admin',2,2,2,'Copy of: Further SETI Resources',NULL,NULL,NULL,'0',NULL,'0','[Return to Top]',NULL,NULL,NULL); |
231 |
|
|
INSERT INTO page VALUES (19,'2004-03-04 13:37:08','2004-03-04 13:52:12','admin','admin',3,1,2,'Vijesti',null,'1','0','1','0','0','[Return to Top]','Ova stranica sadri popis zanimljivih vijeti iz različitih područja bibliotekarstva.',NULL,NULL); |
232 |
|
|
|
233 |
|
|
|
234 |
|
|
-- |
235 |
|
|
-- Table structure for table `course` |
236 |
|
|
-- |
237 |
|
|
|
238 |
|
|
|
239 |
|
|
|
240 |
|
|
-- |
241 |
|
|
-- Sequences for table COURSE |
242 |
|
|
-- |
243 |
|
|
|
244 |
|
|
CREATE SEQUENCE course_course_id_seq; |
245 |
|
|
|
246 |
|
|
CREATE TABLE course ( |
247 |
|
|
course_id INT4 DEFAULT nextval('course_course_id_seq'), |
248 |
dpavlin |
43 |
page_id INT4 references page(page_id) on delete cascade on update cascade, |
249 |
|
|
coursesub_id INT4 references coursesub(coursesub_id) on delete cascade on update cascade, |
250 |
dpavlin |
34 |
course_num varchar(50) DEFAULT NULL, |
251 |
|
|
course_section varchar(10) DEFAULT NULL, |
252 |
|
|
course_concat varchar(255) DEFAULT NULL, |
253 |
dpavlin |
43 |
term_id INT4 references term(term_id) on delete cascade on update cascade, |
254 |
dpavlin |
34 |
course_year varchar(4) DEFAULT NULL, |
255 |
dpavlin |
43 |
campus_id INT4 references campus(campus_id) on delete cascade on update cascade, |
256 |
dpavlin |
34 |
courseheader varchar(255) DEFAULT NULL, |
257 |
|
|
introheader1 text, |
258 |
|
|
intromessage1 text, |
259 |
|
|
introheader2 text, |
260 |
|
|
intromessage2 text, |
261 |
|
|
PRIMARY KEY (course_id) |
262 |
|
|
|
263 |
|
|
); |
264 |
|
|
|
265 |
|
|
-- |
266 |
|
|
-- Dumping data for table `course` |
267 |
|
|
-- |
268 |
|
|
|
269 |
|
|
INSERT INTO course VALUES (8,15,554,'909','1','ASTRO 909: Advanced Topics in Astronomy',2,'2003',NULL,'Information Resources for:','Course Description','This course serves as a cross-displinary introduction to xenobiology.',NULL,NULL); |
270 |
|
|
|
271 |
|
|
-- |
272 |
|
|
-- Table structure for table `stafftitle` |
273 |
|
|
-- |
274 |
|
|
|
275 |
|
|
|
276 |
|
|
|
277 |
|
|
-- |
278 |
|
|
-- Sequences for table STAFFTITLE |
279 |
|
|
-- |
280 |
|
|
|
281 |
|
|
CREATE SEQUENCE stafftitle_stafftitle_id_seq; |
282 |
|
|
|
283 |
|
|
CREATE TABLE stafftitle ( |
284 |
|
|
stafftitle_id INT4 DEFAULT nextval('stafftitle_stafftitle_id_seq'), |
285 |
|
|
stafftitle varchar(50) DEFAULT NULL, |
286 |
|
|
PRIMARY KEY (stafftitle_id) |
287 |
|
|
|
288 |
|
|
); |
289 |
|
|
|
290 |
|
|
-- |
291 |
|
|
-- Dumping data for table `stafftitle` |
292 |
|
|
-- |
293 |
|
|
|
294 |
|
|
INSERT INTO stafftitle VALUES (1,'(N/A)'); |
295 |
|
|
INSERT INTO stafftitle VALUES (2,'Web Applications Developer'); |
296 |
|
|
INSERT INTO stafftitle VALUES (3,'Info Tech Prof'); |
297 |
|
|
INSERT INTO stafftitle VALUES (4,'Librarian'); |
298 |
|
|
INSERT INTO stafftitle VALUES (5,'Faculty'); |
299 |
|
|
INSERT INTO stafftitle VALUES (6,'Professor'); |
300 |
|
|
INSERT INTO stafftitle VALUES (7,'Assistant Professor'); |
301 |
|
|
INSERT INTO stafftitle VALUES (8,'Associate Professor'); |
302 |
|
|
INSERT INTO stafftitle VALUES (16,'Instructor'); |
303 |
|
|
INSERT INTO stafftitle VALUES (17,'TA'); |
304 |
|
|
|
305 |
|
|
-- |
306 |
|
|
-- Table structure for table `staff` |
307 |
|
|
-- |
308 |
|
|
|
309 |
|
|
|
310 |
|
|
|
311 |
|
|
-- |
312 |
|
|
-- Sequences for table STAFF |
313 |
|
|
-- |
314 |
|
|
|
315 |
|
|
CREATE SEQUENCE staff_staff_id_seq; |
316 |
|
|
|
317 |
|
|
CREATE TABLE staff ( |
318 |
|
|
staff_id INT4 DEFAULT nextval('staff_staff_id_seq'), |
319 |
|
|
staff_account varchar(20) DEFAULT NULL, |
320 |
|
|
staff_email varchar(50) DEFAULT NULL, |
321 |
|
|
password varchar(32) DEFAULT NULL, |
322 |
|
|
last_name varchar(75) DEFAULT NULL, |
323 |
|
|
first_name varchar(75) DEFAULT NULL, |
324 |
|
|
last_login TIMESTAMP DEFAULT NULL, |
325 |
|
|
last_ip varchar(15) DEFAULT NULL, |
326 |
|
|
date_created TIMESTAMP DEFAULT NULL, |
327 |
|
|
date_modified TIMESTAMP DEFAULT NULL, |
328 |
dpavlin |
43 |
access_id INT4 references access(access_id) on delete cascade on update cascade, |
329 |
|
|
stafftitle_id INT4 references stafftitle(stafftitle_id) on delete cascade on update cascade, |
330 |
dpavlin |
34 |
PRIMARY KEY (staff_id) |
331 |
|
|
|
332 |
|
|
); |
333 |
|
|
|
334 |
|
|
-- |
335 |
|
|
-- Dumping data for table `staff` |
336 |
|
|
-- |
337 |
|
|
|
338 |
|
|
INSERT INTO staff VALUES (1,'(N/A)','(N/A)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL); |
339 |
|
|
INSERT INTO staff VALUES (2,'admin','admin@yourlibrary.edu','5f3a215f2c55a516','Administrator','System','2004-03-04 13:31:03','193.198.214.118',NULL,NULL,5,3); |
340 |
|
|
INSERT INTO staff VALUES (3,'mglavica','mglavica@ffzg.hr','2b8a357b7963a990','Glavica','Marijana','2004-03-04 13:54:17','193.198.214.118',NULL,NULL,4,5); |
341 |
|
|
INSERT INTO staff VALUES (4,'dpavlin','dpavlin@mjesec.ffzg.hr','0778c26e0ed1e1ad','Pavlinuić','Dobrica',NULL,NULL,NULL,NULL,5,2); |
342 |
|
|
|
343 |
|
|
-- |
344 |
|
|
-- Table structure for table `faculty` |
345 |
|
|
-- |
346 |
|
|
|
347 |
|
|
|
348 |
|
|
|
349 |
|
|
-- |
350 |
|
|
-- Sequences for table FACULTY |
351 |
|
|
-- |
352 |
|
|
|
353 |
|
|
CREATE SEQUENCE faculty_faculty_id_seq; |
354 |
|
|
|
355 |
|
|
CREATE TABLE faculty ( |
356 |
|
|
faculty_id INT4 DEFAULT nextval('faculty_faculty_id_seq'), |
357 |
|
|
faculty_lastname varchar(75) DEFAULT NULL, |
358 |
|
|
faculty_firstname varchar(75) DEFAULT NULL, |
359 |
|
|
faculty_email varchar(50) DEFAULT NULL, |
360 |
|
|
faculty_account varchar(20) DEFAULT NULL, |
361 |
|
|
PRIMARY KEY (faculty_id) |
362 |
|
|
|
363 |
|
|
); |
364 |
|
|
|
365 |
|
|
-- |
366 |
|
|
-- Dumping data for table `faculty` |
367 |
|
|
-- |
368 |
|
|
|
369 |
|
|
INSERT INTO faculty VALUES (1,NULL,NULL,NULL,'(N/A)'); |
370 |
|
|
INSERT INTO faculty VALUES (123,'Smith','Joe','joe001@yourlibrary.edu','joe001'); |
371 |
|
|
|
372 |
|
|
|
373 |
|
|
-- |
374 |
|
|
-- Table structure for table `course_personnel` |
375 |
|
|
-- |
376 |
|
|
|
377 |
|
|
|
378 |
|
|
|
379 |
|
|
-- |
380 |
|
|
-- Sequences for table COURSE_PERSONNEL |
381 |
|
|
-- |
382 |
|
|
|
383 |
|
|
CREATE SEQUENCE course_personnel_personnel_i; |
384 |
|
|
|
385 |
|
|
CREATE TABLE course_personnel ( |
386 |
|
|
personnel_id INT4 DEFAULT nextval('course_personnel_personnel_i'), |
387 |
dpavlin |
43 |
course_id INT4 references course(course_id) on delete cascade on update cascade, |
388 |
|
|
stafftitle_id INT4 references stafftitle(stafftitle_id) on delete cascade on update cascade, |
389 |
|
|
staff_id INT4 references staff(staff_id) on delete cascade on update cascade, |
390 |
|
|
faculty_id INT4 references faculty(faculty_id) on delete cascade on update cascade, |
391 |
dpavlin |
34 |
pers_email varchar(40) DEFAULT NULL, |
392 |
|
|
pers_account varchar(20) DEFAULT NULL, |
393 |
|
|
pers_lastname varchar(50) DEFAULT NULL, |
394 |
|
|
pers_firstname varchar(20) DEFAULT NULL, |
395 |
|
|
PRIMARY KEY (personnel_id) |
396 |
|
|
|
397 |
|
|
); |
398 |
|
|
|
399 |
|
|
-- |
400 |
|
|
-- Dumping data for table `course_personnel` |
401 |
|
|
-- |
402 |
|
|
|
403 |
|
|
INSERT INTO course_personnel VALUES (4,8,7,2,NULL,NULL,NULL,NULL,NULL); |
404 |
|
|
|
405 |
|
|
-- |
406 |
|
|
-- Table structure for table `service` |
407 |
|
|
-- |
408 |
|
|
|
409 |
|
|
|
410 |
|
|
|
411 |
|
|
-- |
412 |
|
|
-- Sequences for table SERVICE |
413 |
|
|
-- |
414 |
|
|
|
415 |
|
|
CREATE SEQUENCE service_service_id_seq; |
416 |
|
|
|
417 |
|
|
CREATE TABLE service ( |
418 |
|
|
service_id INT4 DEFAULT nextval('service_service_id_seq'), |
419 |
|
|
service varchar(100) DEFAULT NULL, |
420 |
|
|
serviceURL varchar(150) DEFAULT NULL, |
421 |
|
|
serviceDescr text, |
422 |
|
|
address1 varchar(50) DEFAULT NULL, |
423 |
|
|
address2 varchar(50) DEFAULT NULL, |
424 |
|
|
address3 varchar(50) DEFAULT NULL, |
425 |
|
|
address4 varchar(50) DEFAULT NULL, |
426 |
|
|
telephone varchar(20) DEFAULT NULL, |
427 |
|
|
fax varchar(20) DEFAULT NULL, |
428 |
|
|
email varchar(40) DEFAULT NULL, |
429 |
|
|
nonaff char(1) DEFAULT NULL, |
430 |
|
|
PRIMARY KEY (service_id) |
431 |
|
|
|
432 |
|
|
); |
433 |
|
|
|
434 |
|
|
-- |
435 |
|
|
-- Dumping data for table `service` |
436 |
|
|
-- |
437 |
|
|
|
438 |
|
|
INSERT INTO service VALUES (1,'(N/A)','','','','','','','','','','0'); |
439 |
|
|
|
440 |
|
|
-- |
441 |
|
|
-- Table structure for table `servicetype` |
442 |
|
|
-- |
443 |
|
|
|
444 |
|
|
|
445 |
|
|
|
446 |
|
|
-- |
447 |
|
|
-- Sequences for table SERVICETYPE |
448 |
|
|
-- |
449 |
|
|
|
450 |
|
|
CREATE SEQUENCE servicetype_servicetype_id_s; |
451 |
|
|
|
452 |
|
|
CREATE TABLE servicetype ( |
453 |
|
|
servicetype_id INT4 DEFAULT nextval('servicetype_servicetype_id_s'), |
454 |
|
|
servicetype varchar(75) DEFAULT NULL, |
455 |
|
|
PRIMARY KEY (servicetype_id) |
456 |
|
|
|
457 |
|
|
); |
458 |
|
|
|
459 |
|
|
-- |
460 |
|
|
-- Dumping data for table `servicetype` |
461 |
|
|
-- |
462 |
|
|
|
463 |
|
|
|
464 |
|
|
-- |
465 |
|
|
-- Table structure for table `location` |
466 |
|
|
-- |
467 |
|
|
|
468 |
|
|
|
469 |
|
|
|
470 |
|
|
-- |
471 |
|
|
-- Sequences for table LOCATION |
472 |
|
|
-- |
473 |
|
|
|
474 |
|
|
CREATE SEQUENCE location_location_id_seq; |
475 |
|
|
|
476 |
|
|
CREATE TABLE location ( |
477 |
|
|
location_id INT4 DEFAULT nextval('location_location_id_seq'), |
478 |
|
|
location varchar(255) DEFAULT NULL, |
479 |
|
|
location_descr text, |
480 |
|
|
campus varchar(255) DEFAULT NULL, |
481 |
|
|
address1 varchar(255) DEFAULT NULL, |
482 |
|
|
address2 varchar(255) DEFAULT NULL, |
483 |
|
|
address3 varchar(255) DEFAULT NULL, |
484 |
|
|
address4 varchar(255) DEFAULT NULL, |
485 |
|
|
telephone varchar(100) DEFAULT NULL, |
486 |
|
|
mainURL varchar(255) DEFAULT NULL, |
487 |
|
|
referenceURL varchar(255) DEFAULT NULL, |
488 |
|
|
mapURL varchar(255) DEFAULT NULL, |
489 |
|
|
hoursURL varchar(255) DEFAULT NULL, |
490 |
|
|
PRIMARY KEY (location_id) |
491 |
|
|
|
492 |
|
|
); |
493 |
|
|
|
494 |
|
|
-- |
495 |
|
|
-- Dumping data for table `location` |
496 |
|
|
-- |
497 |
|
|
|
498 |
|
|
INSERT INTO location VALUES (1,'(N/A)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); |
499 |
|
|
INSERT INTO location VALUES (55,'Virtual Web Library','Resources here are all freely available on the internet.','','','','','','','','','',''); |
500 |
|
|
INSERT INTO location VALUES (58,'Smith Library','State of the art facility with over 120 million print volumes, climate controlled with super computers for public use.','','','','','','','http://www.google.com','','',''); |
501 |
|
|
|
502 |
|
|
INSERT INTO servicetype VALUES (1,'(N/A)'); |
503 |
|
|
|
504 |
|
|
-- |
505 |
|
|
-- Table structure for table `subject` |
506 |
|
|
-- |
507 |
|
|
|
508 |
|
|
|
509 |
|
|
|
510 |
|
|
-- |
511 |
|
|
-- Sequences for table SUBJECT |
512 |
|
|
-- |
513 |
|
|
|
514 |
|
|
CREATE SEQUENCE subject_subject_id_seq; |
515 |
|
|
|
516 |
|
|
CREATE TABLE subject ( |
517 |
|
|
subject_id INT4 DEFAULT nextval('subject_subject_id_seq'), |
518 |
|
|
subject varchar(75) NOT NULL DEFAULT '', |
519 |
|
|
subject_descr text, |
520 |
dpavlin |
43 |
sublocation_id INT4 references location(location_id) on delete cascade on update cascade, |
521 |
dpavlin |
34 |
rqs_date_created TIMESTAMP DEFAULT NULL, |
522 |
|
|
rqs_date_modified TIMESTAMP DEFAULT NULL, |
523 |
|
|
rqs_account_created varchar(20) DEFAULT NULL, |
524 |
|
|
rqs_account_modified varchar(20) DEFAULT NULL, |
525 |
|
|
rqs_published char(1) DEFAULT NULL, |
526 |
|
|
PRIMARY KEY (subject_id) |
527 |
|
|
|
528 |
|
|
); |
529 |
|
|
|
530 |
|
|
-- |
531 |
|
|
-- Dumping data for table `subject` |
532 |
|
|
-- |
533 |
|
|
|
534 |
|
|
INSERT INTO subject VALUES (1,'(N/A)',NULL,NULL,'2003-08-27 10:07:20','2003-08-27 10:07:50','staff','staff','1'); |
535 |
|
|
INSERT INTO subject VALUES (2,'Astrobiology','Encompasses the search for extraterrestrial intelligence (commonly abbreviated as SETI), as well as an interdisciplinary mix of both astronomy and biology.',58,'2003-09-16 16:02:50','2004-03-02 16:09:02','admin','admin','1'); |
536 |
|
|
INSERT INTO subject VALUES (3,'xxx3','',1,'2004-02-17 00:24:53','2004-03-03 20:54:57','admin','admin','1'); |
537 |
|
|
INSERT INTO subject VALUES (4,'xxx4','',1,'2004-02-17 00:24:53','2004-03-03 20:54:57','admin','admin','1'); |
538 |
|
|
INSERT INTO subject VALUES (5,'xxx5','',1,'2004-02-17 00:24:53','2004-03-03 20:54:57','admin','admin','1'); |
539 |
|
|
INSERT INTO subject VALUES (6,'Psihologija','',1,'2004-02-17 00:24:53','2004-03-03 20:54:57','admin','admin','1'); |
540 |
|
|
INSERT INTO subject VALUES (7,'Tehnika','Informacijski izvori za podruèje tehnike',1,'2004-03-02 15:54:37','2004-03-02 16:15:49','admin','admin','1'); |
541 |
|
|
INSERT INTO subject VALUES (8,'xxx8','',1,'2004-02-17 00:24:53','2004-03-03 20:54:57','admin','admin','1'); |
542 |
|
|
|
543 |
|
|
-- |
544 |
|
|
-- Table structure for table `mastersubject` |
545 |
|
|
-- |
546 |
|
|
|
547 |
|
|
|
548 |
|
|
|
549 |
|
|
-- |
550 |
|
|
-- Sequences for table MASTERSUBJECT |
551 |
|
|
-- |
552 |
|
|
|
553 |
|
|
CREATE SEQUENCE mastersubject_mastersubject_; |
554 |
|
|
|
555 |
|
|
CREATE TABLE mastersubject ( |
556 |
|
|
mastersubject_id INT4 DEFAULT nextval('mastersubject_mastersubject_'), |
557 |
|
|
mastersubject varchar(50) NOT NULL DEFAULT '', |
558 |
|
|
PRIMARY KEY (mastersubject_id) |
559 |
|
|
|
560 |
|
|
); |
561 |
|
|
|
562 |
|
|
-- |
563 |
|
|
-- Dumping data for table `mastersubject` |
564 |
|
|
-- |
565 |
|
|
|
566 |
|
|
INSERT INTO mastersubject VALUES (1,'(N/A)'); |
567 |
|
|
INSERT INTO mastersubject VALUES (2,'(All)'); |
568 |
|
|
INSERT INTO mastersubject VALUES (3,'Agriculture, Biology, Ecology'); |
569 |
|
|
INSERT INTO mastersubject VALUES (4,'Humanistika'); |
570 |
|
|
INSERT INTO mastersubject VALUES (5,'Business and Economics'); |
571 |
|
|
INSERT INTO mastersubject VALUES (6,'Prirodoslovlje'); |
572 |
|
|
INSERT INTO mastersubject VALUES (7,'Health and Medicine'); |
573 |
|
|
INSERT INTO mastersubject VALUES (8,'Law'); |
574 |
|
|
INSERT INTO mastersubject VALUES (9,'Dru¹tvene znanosti'); |
575 |
|
|
INSERT INTO mastersubject VALUES (10,'General'); |
576 |
|
|
INSERT INTO mastersubject VALUES (11,'Biomedicina'); |
577 |
|
|
INSERT INTO mastersubject VALUES (12,'Tehnika'); |
578 |
|
|
|
579 |
|
|
-- |
580 |
|
|
-- Table structure for table `infotype` |
581 |
|
|
-- |
582 |
|
|
|
583 |
|
|
|
584 |
|
|
|
585 |
|
|
-- |
586 |
|
|
-- Sequences for table INFOTYPE |
587 |
|
|
-- |
588 |
|
|
|
589 |
|
|
CREATE SEQUENCE infotype_infotype_id_seq; |
590 |
|
|
|
591 |
|
|
CREATE TABLE infotype ( |
592 |
|
|
infotype_id INT4 DEFAULT nextval('infotype_infotype_id_seq'), |
593 |
dpavlin |
43 |
masterinfotype_id INT4 references infotype(infotype_id) on delete cascade on update cascade, |
594 |
|
|
mastersubject_id INT4 references mastersubject(mastersubject_id) on delete cascade on update cascade, |
595 |
dpavlin |
34 |
infotype varchar(75) NOT NULL DEFAULT '', |
596 |
|
|
PRIMARY KEY (infotype_id) |
597 |
|
|
|
598 |
|
|
); |
599 |
|
|
|
600 |
|
|
-- |
601 |
|
|
-- Dumping data for table `infotype` |
602 |
|
|
-- |
603 |
|
|
|
604 |
|
|
INSERT INTO infotype VALUES (1,1,1,'(N/A)'); |
605 |
|
|
INSERT INTO infotype VALUES (2,2,2,'Almanacs'); |
606 |
|
|
INSERT INTO infotype VALUES (3,2,2,'Encyclopedias'); |
607 |
|
|
INSERT INTO infotype VALUES (4,2,2,'Field Guides'); |
608 |
|
|
INSERT INTO infotype VALUES (5,2,2,'Dictionaries'); |
609 |
|
|
INSERT INTO infotype VALUES (6,2,2,'Handbooks and Manuals'); |
610 |
|
|
INSERT INTO infotype VALUES (7,2,2,'Biographical Sources'); |
611 |
|
|
INSERT INTO infotype VALUES (8,2,2,'Directories'); |
612 |
|
|
INSERT INTO infotype VALUES (9,2,2,'Glossaries'); |
613 |
|
|
INSERT INTO infotype VALUES (10,2,2,'Reports'); |
614 |
|
|
INSERT INTO infotype VALUES (11,2,2,'Public Opinion Resources'); |
615 |
|
|
INSERT INTO infotype VALUES (12,2,2,'Yearbooks'); |
616 |
|
|
INSERT INTO infotype VALUES (13,2,2,'Speeches'); |
617 |
|
|
INSERT INTO infotype VALUES (14,2,4,'Atlases & Maps'); |
618 |
|
|
INSERT INTO infotype VALUES (15,2,2,'Chronologies'); |
619 |
|
|
INSERT INTO infotype VALUES (16,2,2,'Forms, Tests, Inventories'); |
620 |
|
|
INSERT INTO infotype VALUES (17,2,2,'General Reference Works'); |
621 |
|
|
INSERT INTO infotype VALUES (18,3,2,'Academic or Scholarly Articles Subject Indexes'); |
622 |
|
|
INSERT INTO infotype VALUES (19,3,2,'General Indexes to Magazine, Journal & Newspaper Articles'); |
623 |
|
|
INSERT INTO infotype VALUES (20,3,2,'Catalogs & Indexes to Government Publications'); |
624 |
|
|
INSERT INTO infotype VALUES (21,3,2,'Indexes, Other'); |
625 |
|
|
INSERT INTO infotype VALUES (22,4,2,'Bibliographies'); |
626 |
|
|
INSERT INTO infotype VALUES (23,4,2,'National Bibliographies'); |
627 |
|
|
INSERT INTO infotype VALUES (24,4,2,'Catalogs'); |
628 |
|
|
INSERT INTO infotype VALUES (25,5,2,'Reports'); |
629 |
|
|
INSERT INTO infotype VALUES (26,5,2,'Diaries'); |
630 |
|
|
INSERT INTO infotype VALUES (27,5,2,'Correspondence'); |
631 |
|
|
INSERT INTO infotype VALUES (28,5,2,'Speeches'); |
632 |
|
|
INSERT INTO infotype VALUES (29,6,2,'News Sources'); |
633 |
|
|
INSERT INTO infotype VALUES (30,6,2,'Journal Titles'); |
634 |
|
|
INSERT INTO infotype VALUES (31,6,2,'Magazine Titles'); |
635 |
|
|
INSERT INTO infotype VALUES (32,7,2,'Data Resources'); |
636 |
|
|
INSERT INTO infotype VALUES (33,7,2,'Statistical Guides'); |
637 |
|
|
INSERT INTO infotype VALUES (34,7,2,'Statistical Resources'); |
638 |
|
|
INSERT INTO infotype VALUES (35,8,2,'Atlases and Maps'); |
639 |
|
|
INSERT INTO infotype VALUES (37,9,2,'Trade & Professional Associations'); |
640 |
|
|
INSERT INTO infotype VALUES (38,10,2,'Guides to Working with Government Publications'); |
641 |
|
|
INSERT INTO infotype VALUES (39,10,2,'Research Guides'); |
642 |
|
|
INSERT INTO infotype VALUES (40,11,2,'Gateways & Megasites'); |
643 |
|
|
INSERT INTO infotype VALUES (41,11,2,'Search Engines'); |
644 |
|
|
INSERT INTO infotype VALUES (42,12,2,'Related U of M Web Sites'); |
645 |
|
|
INSERT INTO infotype VALUES (43,2,5,'Security Analysts\' Reports'); |
646 |
|
|
INSERT INTO infotype VALUES (44,2,5,'Doing Business in Another Country'); |
647 |
|
|
INSERT INTO infotype VALUES (45,2,5,'Financial Ratios'); |
648 |
|
|
INSERT INTO infotype VALUES (46,2,5,'Industry Profiles'); |
649 |
|
|
INSERT INTO infotype VALUES (47,2,5,'Market Research Surveys'); |
650 |
|
|
INSERT INTO infotype VALUES (48,2,5,'Tax Reporters'); |
651 |
|
|
INSERT INTO infotype VALUES (49,2,5,'Financial Reports'); |
652 |
|
|
INSERT INTO infotype VALUES (50,2,5,'Accounting Standards'); |
653 |
|
|
INSERT INTO infotype VALUES (51,2,5,'Nonprofit Finance'); |
654 |
|
|
INSERT INTO infotype VALUES (52,2,5,'Nonprofit Management'); |
655 |
|
|
INSERT INTO infotype VALUES (53,2,5,'Nonprofit Marketing'); |
656 |
|
|
INSERT INTO infotype VALUES (54,2,5,'Leadership History'); |
657 |
|
|
INSERT INTO infotype VALUES (55,2,5,'Leadership Landscapes, strategies and structures'); |
658 |
|
|
INSERT INTO infotype VALUES (56,2,5,'Books by and about Leaders'); |
659 |
|
|
INSERT INTO infotype VALUES (57,2,6,'Spectra'); |
660 |
|
|
INSERT INTO infotype VALUES (58,2,6,'Spectra, Atomic'); |
661 |
|
|
INSERT INTO infotype VALUES (59,2,6,'Spectra, General'); |
662 |
|
|
INSERT INTO infotype VALUES (60,2,6,'Spectra, Infrared'); |
663 |
|
|
INSERT INTO infotype VALUES (61,2,6,'Spectra, Mass'); |
664 |
|
|
INSERT INTO infotype VALUES (62,2,6,'Spectra, Nuclear Magnetic Resonance'); |
665 |
|
|
INSERT INTO infotype VALUES (63,2,6,'Spectra, Raman'); |
666 |
|
|
INSERT INTO infotype VALUES (64,2,6,'Spectra, Ultraviolet & Visible'); |
667 |
|
|
INSERT INTO infotype VALUES (65,2,6,'Chemical Compounds'); |
668 |
|
|
INSERT INTO infotype VALUES (66,2,6,'Data Compilations/Algorithms'); |
669 |
|
|
INSERT INTO infotype VALUES (67,2,6,'Organic Reactions'); |
670 |
|
|
INSERT INTO infotype VALUES (68,2,6,'Organic Synthesis'); |
671 |
|
|
INSERT INTO infotype VALUES (69,2,6,'Physical Property Data'); |
672 |
|
|
INSERT INTO infotype VALUES (70,2,8,'Federal Law - Administrative Law'); |
673 |
|
|
INSERT INTO infotype VALUES (71,2,8,'Minnesota Law - Constitution, Statutes and Codes'); |
674 |
|
|
INSERT INTO infotype VALUES (72,2,8,'Courts'); |
675 |
|
|
INSERT INTO infotype VALUES (73,2,8,'Attorneys and Law Firms'); |
676 |
|
|
INSERT INTO infotype VALUES (74,2,8,'Minnesota Law - Administrative Law'); |
677 |
|
|
INSERT INTO infotype VALUES (75,2,8,'Minnesota Law - Case Law'); |
678 |
|
|
INSERT INTO infotype VALUES (76,2,8,'Law Schools'); |
679 |
|
|
INSERT INTO infotype VALUES (77,2,8,'Federal Law - Case Law - U.S. Supreme Court'); |
680 |
|
|
INSERT INTO infotype VALUES (78,2,8,'Federal Law - Case Law - U.S. Court of Appeals'); |
681 |
|
|
INSERT INTO infotype VALUES (79,2,8,'Federal Law - Case Law - U.S. District Courts'); |
682 |
|
|
INSERT INTO infotype VALUES (80,2,8,'Laws and Legislation'); |
683 |
|
|
INSERT INTO infotype VALUES (81,2,8,'Official Journal of Legislative Activity'); |
684 |
|
|
INSERT INTO infotype VALUES (82,2,8,'Unofficial Journal of Legislative Activity'); |
685 |
|
|
INSERT INTO infotype VALUES (83,2,8,'Legislative Debates'); |
686 |
|
|
INSERT INTO infotype VALUES (84,2,8,'Federal Law - Constitution, Statutes and Codes'); |
687 |
|
|
INSERT INTO infotype VALUES (85,2,2,'Country Studies'); |
688 |
|
|
INSERT INTO infotype VALUES (130,11,2,'Electronic Texts'); |
689 |
|
|
INSERT INTO infotype VALUES (87,11,2,'Official Agency and Organization Web Sites'); |
690 |
|
|
INSERT INTO infotype VALUES (88,11,2,'Internet Directory'); |
691 |
|
|
INSERT INTO infotype VALUES (105,1,6,'Astronomical Objects'); |
692 |
|
|
INSERT INTO infotype VALUES (124,10,2,'Writing Guides'); |
693 |
|
|
INSERT INTO infotype VALUES (125,2,6,'Safety Information'); |
694 |
|
|
INSERT INTO infotype VALUES (126,6,2,'Electronic Journal Collections'); |
695 |
|
|
INSERT INTO infotype VALUES (127,8,2,'Image Resources'); |
696 |
|
|
INSERT INTO infotype VALUES (128,2,2,'Conferences and Proceedings'); |
697 |
|
|
INSERT INTO infotype VALUES (129,10,2,'Style Manuals'); |
698 |
|
|
INSERT INTO infotype VALUES (131,2,2,'Standards'); |
699 |
|
|
INSERT INTO infotype VALUES (132,2,6,'Analytical Techniques'); |
700 |
|
|
INSERT INTO infotype VALUES (133,2,6,'Chemical Prices'); |
701 |
|
|
INSERT INTO infotype VALUES (134,2,2,'Treatises'); |
702 |
|
|
INSERT INTO infotype VALUES (135,2,2,'Rankings'); |
703 |
|
|
INSERT INTO infotype VALUES (136,2,2,'Technical Reports'); |
704 |
|
|
INSERT INTO infotype VALUES (137,5,2,'Historical Documents'); |
705 |
|
|
INSERT INTO infotype VALUES (138,13,2,'Web Sites'); |
706 |
|
|
INSERT INTO infotype VALUES (139,5,2,'Government Documents'); |
707 |
|
|
INSERT INTO infotype VALUES (140,5,2,'Archival Materials'); |
708 |
|
|
INSERT INTO infotype VALUES (143,2,2,'Dissertations and Theses'); |
709 |
|
|
INSERT INTO infotype VALUES (142,2,2,'Guides'); |
710 |
|
|
INSERT INTO infotype VALUES (147,13,2,'Library Web Sites'); |
711 |
|
|
INSERT INTO infotype VALUES (148,13,2,'Campus web site'); |
712 |
|
|
INSERT INTO infotype VALUES (149,6,2,'Electronic Journal Titles'); |
713 |
|
|
|
714 |
|
|
-- |
715 |
|
|
-- Table structure for table `resource` |
716 |
|
|
-- |
717 |
|
|
|
718 |
|
|
|
719 |
|
|
|
720 |
|
|
-- |
721 |
|
|
-- Sequences for table RESOURCE |
722 |
|
|
-- |
723 |
|
|
|
724 |
|
|
CREATE SEQUENCE resource_resource_id_seq; |
725 |
|
|
|
726 |
|
|
CREATE TABLE resource ( |
727 |
|
|
resource_id INT4 DEFAULT nextval('resource_resource_id_seq'), |
728 |
|
|
date_created TIMESTAMP DEFAULT NULL, |
729 |
|
|
date_modified TIMESTAMP DEFAULT NULL, |
730 |
|
|
account_created varchar(20) DEFAULT NULL, |
731 |
|
|
account_modified varchar(20) DEFAULT NULL, |
732 |
|
|
title varchar(255) DEFAULT NULL, |
733 |
|
|
other_title text, |
734 |
|
|
author varchar(125) DEFAULT NULL, |
735 |
|
|
publisher varchar(255) DEFAULT NULL, |
736 |
|
|
pub_date varchar(255) DEFAULT NULL, |
737 |
|
|
edition varchar(25) DEFAULT NULL, |
738 |
|
|
cat_num varchar(50) DEFAULT NULL, |
739 |
|
|
call_no text, |
740 |
|
|
coverage_detail varchar(255) DEFAULT NULL, |
741 |
|
|
sources_indexed varchar(100) DEFAULT NULL, |
742 |
|
|
url text, |
743 |
|
|
visited varchar(25) DEFAULT NULL, |
744 |
|
|
annotation text, |
745 |
dpavlin |
43 |
location_id INT4 references location(location_id) on delete cascade on update cascade, |
746 |
|
|
infotype_id INT4 references infotype(infotype_id) on delete cascade on update cascade, |
747 |
dpavlin |
34 |
vendor_id INT4 DEFAULT NULL, -- XXX unused |
748 |
|
|
PRIMARY KEY (resource_id) |
749 |
|
|
|
750 |
|
|
); |
751 |
|
|
|
752 |
|
|
-- |
753 |
|
|
-- Dumping data for table `resource` |
754 |
|
|
-- |
755 |
|
|
|
756 |
|
|
INSERT INTO resource VALUES (1,'2003-09-16 15:54:54','2004-03-02 16:15:20','admin','admin','Google','','','','','','','','','','http://www.google.com/',NULL,'Pretraivaè weba',NULL,41,0); |
757 |
|
|
INSERT INTO resource VALUES (2,'2003-09-16 16:10:13','2003-09-16 16:10:13','admin',NULL,'SETI@Home','','','','','','','','','','http://setiathome.berkeley.edu/',NULL,'SETI@home is a scientific experiment that uses Internet-connected computers in the Search for Extraterrestrial Intelligence (SETI). You can participate by running a free program that downloads and analyzes radio telescope data.',NULL,138,NULL); |
758 |
|
|
INSERT INTO resource VALUES (3,'2003-09-16 16:13:11','2003-09-24 09:35:24','admin','jtest','SETI Institute','','','','','','','','','','http://www.seti-inst.edu/',NULL,'The mission of the SETI Institute is to explore, understand and explain the origin, nature and prevalence of life in the universe.',NULL,87,0); |
759 |
|
|
INSERT INTO resource VALUES (4,'2003-09-17 09:35:43','2003-09-17 09:35:43','admin',NULL,'Harvard\'s SETI Project','','','','','','','','','','http://seti.harvard.edu/seti/',NULL,'Project home page for Harvard\'s SETI programs.',NULL,138,NULL); |
760 |
|
|
INSERT INTO resource VALUES (11,'2003-10-01 09:35:17','2003-10-01 09:35:17','admin',NULL,'Sky & Telescope\'s SETI Page','','','','','','','','','','http://skyandtelescope.com/resources/SETI/',NULL,'Sky & Telescope magazine\'s collection of resources on SETI.',NULL,138,NULL); |
761 |
|
|
INSERT INTO resource VALUES (12,'2003-10-01 09:45:28','2003-10-01 11:54:27','admin','admin','The SETI League','','','','','','','','','','http://seti1.setileague.org/index.html',NULL,'Non-profit organization, primarily of amateur radio astronomers interested in coordinating a private effort (Project Argus) of small radio telescopes in a SETI search.',NULL,24,0); |
762 |
|
|
INSERT INTO resource VALUES (13,'2003-10-01 09:53:27','2003-10-06 14:48:18','admin','admin','Arecibo Observatory','','','','','','','','','','http://www.naic.edu/',NULL,'The radiotelescope based in Puerto Rico responsible for the feed to SETI@Home.',NULL,87,0); |
763 |
|
|
INSERT INTO resource VALUES (14,'2003-10-01 09:58:52','2004-01-27 14:35:52','admin','admin','Astrobiology Web','','','','','','','','','','http://www.astrobiology.com/',NULL,'General gateway site to many resources and articles on astrobiology.',NULL,40,0); |
764 |
|
|
INSERT INTO resource VALUES (15,'2004-02-16 15:10:51','2004-02-16 15:10:51','admin',NULL,'E-LIS','E-Prints in Library and Information Science','','','','','','','','','http://eprints.rclis.org/',NULL,'',NULL,130,NULL); |
765 |
|
|
INSERT INTO resource VALUES (16,'2004-02-17 00:41:39','2004-02-27 21:32:33','admin','admin','Classics in the History of psychology','','','','','','','','','','http://psychclassics.yorku.ca/',NULL,'zbirka klasiènih tekstova iz psihologije',NULL,130,0); |
766 |
|
|
INSERT INTO resource VALUES (17,'2004-03-02 15:37:04','2004-03-02 15:37:15','admin','admin','Katalog knjinica FF-a','','','FF','2001','','','','','','http://knjiznice.ffzg.hr/webpac/',NULL,'Skupni katalog knjinica FF-a',NULL,24,0); |
767 |
|
|
INSERT INTO resource VALUES (18,'2004-03-02 15:53:32','2004-03-02 15:53:57','admin','admin','Skupni katalog knjinica tehnike','','','','','','','','','','http://mjesec.ffzg.hr/webpac-tehnika/',NULL,'',NULL,24,0); |
768 |
|
|
INSERT INTO resource VALUES (19,'2004-03-02 16:00:19','2004-03-02 16:01:46','admin','admin','Kluwer èasopisi','','','Kluwer','','','','','','','http://gateway.ovid.com/autologin.html',NULL,'',NULL,126,0); |
769 |
|
|
INSERT INTO resource VALUES (20,'2004-03-03 20:53:58','2004-03-03 20:54:41','admin','admin','Centar za online baze podataka','','','','','','','','','','http://nippur.irb.hr/ovid/',NULL,'Centar za online baze podataka je projekt Ministarstva znanosti i tehnologije RH kojim ono osigurava mre¾ni pristup komercijalnim bazama podataka za èlanove znanstvene i istra¾ivaèke zajednice RH.',NULL,18,0); |
770 |
|
|
|
771 |
|
|
-- |
772 |
|
|
-- Table structure for table `element` |
773 |
|
|
-- |
774 |
|
|
|
775 |
|
|
|
776 |
|
|
|
777 |
|
|
-- |
778 |
|
|
-- Sequences for table ELEMENT |
779 |
|
|
-- |
780 |
|
|
|
781 |
|
|
CREATE SEQUENCE element_element_id_seq; |
782 |
|
|
|
783 |
|
|
CREATE TABLE element ( |
784 |
|
|
element_id INT4 DEFAULT nextval('element_element_id_seq'), |
785 |
dpavlin |
43 |
page_id INT4 references page(page_id) on delete cascade on update cascade, |
786 |
|
|
parent_id INT4, --- XXX references element(element_id) on delete cascade on update cascade, |
787 |
|
|
resource_id INT4 references resource(resource_id) on delete cascade on update cascade, |
788 |
|
|
location_id INT4 references location(location_id) on delete cascade on update cascade, |
789 |
|
|
service_id INT4 references service(service_id) on delete cascade on update cascade, |
790 |
|
|
staff_id INT4 references staff(staff_id) on delete cascade on update cascade, |
791 |
|
|
subject_id INT4 references subject(subject_id) on delete cascade on update cascade, |
792 |
dpavlin |
34 |
label varchar(200) DEFAULT NULL, |
793 |
|
|
label_url varchar(200) DEFAULT NULL, |
794 |
|
|
element_descr text, |
795 |
|
|
element_size INT2 DEFAULT NULL, |
796 |
|
|
element_order INT2 DEFAULT NULL, |
797 |
|
|
indent_level INT2 DEFAULT NULL, |
798 |
|
|
PRIMARY KEY (element_id) |
799 |
|
|
|
800 |
|
|
); |
801 |
|
|
|
802 |
|
|
-- |
803 |
|
|
-- Dumping data for table `element` |
804 |
|
|
-- |
805 |
|
|
|
806 |
|
|
INSERT INTO element VALUES (21,4,15,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,9,1); |
807 |
|
|
INSERT INTO element VALUES (22,4,15,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,10,1); |
808 |
|
|
INSERT INTO element VALUES (20,4,15,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7,1); |
809 |
|
|
INSERT INTO element VALUES (15,4,0,NULL,NULL,NULL,NULL,NULL,'Harested Links from the Astrobiology RQS Page','','<i>Note</i> -- these aren\'t actually additional resources. They are duplicated here to demonstrate PageScribe.',3,6,0); |
810 |
|
|
INSERT INTO element VALUES (23,4,15,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,11,1); |
811 |
|
|
INSERT INTO element VALUES (25,4,15,11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,12,1); |
812 |
|
|
INSERT INTO element VALUES (28,15,0,NULL,NULL,NULL,NULL,NULL,'Library Resources','','',1,8,0); |
813 |
|
|
INSERT INTO element VALUES (29,15,28,NULL,58,NULL,NULL,NULL,NULL,NULL,'\r\n',NULL,9,1); |
814 |
|
|
INSERT INTO element VALUES (30,15,28,NULL,55,NULL,NULL,NULL,NULL,NULL,NULL,5,10,1); |
815 |
|
|
INSERT INTO element VALUES (31,15,0,NULL,NULL,NULL,NULL,NULL,'Astrobiology','','',1,1,0); |
816 |
|
|
INSERT INTO element VALUES (32,15,31,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,1); |
817 |
|
|
INSERT INTO element VALUES (33,15,31,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,1); |
818 |
|
|
INSERT INTO element VALUES (34,15,31,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,1); |
819 |
|
|
INSERT INTO element VALUES (35,15,31,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,1); |
820 |
|
|
INSERT INTO element VALUES (36,15,31,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,1); |
821 |
|
|
INSERT INTO element VALUES (37,15,31,11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,1); |
822 |
|
|
INSERT INTO element VALUES (49,4,0,2,NULL,NULL,NULL,NULL,'','','',0,5,0); |
823 |
|
|
INSERT INTO element VALUES (50,17,0,NULL,NULL,NULL,NULL,NULL,'radno vrijeme','http://www.ffzg.hr/psiho/knjiznica/','pon, uto 12 do 19',0,1,0); |
824 |
|
|
INSERT INTO element VALUES (51,4,20,NULL,NULL,NULL,NULL,NULL,'to je tekst','http://bla..','neki tekst',NULL,8,2); |
825 |
|
|
INSERT INTO element VALUES (52,4,0,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4,0); |
826 |
|
|
INSERT INTO element VALUES (57,18,0,NULL,NULL,NULL,NULL,NULL,'Harested Links from the Astrobiology RQS Page','','<i>Note</i> -- these aren\'t actually additional resources. They are duplicated here to demonstrate PageScribe.',3,9,0); |
827 |
|
|
INSERT INTO element VALUES (54,4,0,16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0); |
828 |
|
|
INSERT INTO element VALUES (55,4,0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0); |
829 |
|
|
INSERT INTO element VALUES (56,4,0,NULL,NULL,NULL,NULL,6,NULL,NULL,NULL,0,1,0); |
830 |
|
|
INSERT INTO element VALUES (58,18,57,13,NULL,NULL,NULL,NULL,'','','',NULL,10,1); |
831 |
|
|
INSERT INTO element VALUES (59,18,57,14,NULL,NULL,NULL,NULL,'','','',NULL,12,1); |
832 |
|
|
INSERT INTO element VALUES (60,18,57,4,NULL,NULL,NULL,NULL,'','','',NULL,13,1); |
833 |
|
|
INSERT INTO element VALUES (61,18,57,3,NULL,NULL,NULL,NULL,'','','',NULL,14,1); |
834 |
|
|
INSERT INTO element VALUES (62,18,57,11,NULL,NULL,NULL,NULL,'','','',NULL,15,1); |
835 |
|
|
INSERT INTO element VALUES (63,18,0,2,NULL,NULL,NULL,NULL,'','','',NULL,8,0); |
836 |
|
|
INSERT INTO element VALUES (64,18,58,NULL,NULL,NULL,NULL,NULL,'to je tekst','http://bla..','neki tekst',NULL,11,2); |
837 |
|
|
INSERT INTO element VALUES (65,18,0,20,NULL,NULL,NULL,NULL,'','','',NULL,7,0); |
838 |
|
|
INSERT INTO element VALUES (66,18,0,16,NULL,NULL,NULL,NULL,'','','',NULL,5,0); |
839 |
|
|
INSERT INTO element VALUES (67,18,0,1,NULL,NULL,NULL,NULL,'','','',NULL,6,0); |
840 |
|
|
INSERT INTO element VALUES (68,18,0,NULL,NULL,NULL,NULL,6,'','','',NULL,4,0); |
841 |
|
|
INSERT INTO element VALUES (70,18,0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0); |
842 |
|
|
INSERT INTO element VALUES (71,18,0,19,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,0); |
843 |
|
|
INSERT INTO element VALUES (72,18,0,18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,0); |
844 |
|
|
INSERT INTO element VALUES (73,19,0,NULL,NULL,NULL,NULL,NULL,'Postavljena demo verzija LibData rjeenja','http://libdata.sf.net/','LibData,portal namjenjen specifično knjiničarima instaliran je probno na adresi http://libdata.knjiznice.ffzg.hr/',0,1,0); |
845 |
|
|
INSERT INTO element VALUES (74,19,0,NULL,NULL,NULL,NULL,NULL,'Sustav znanstevnih informacija, prijedlog za web site','http://mjesec.ffzg.hr/~mglavica/szi-web2/','SZI humanistika je dobio prijedlog protopipa za novi web. Većinom se radilo na organizaciji sadraja, jer će sam design biti povjeren dizajerima.',0,2,0); |
846 |
|
|
|
847 |
|
|
-- |
848 |
|
|
-- Table structure for table `feature` |
849 |
|
|
-- |
850 |
|
|
|
851 |
|
|
|
852 |
|
|
|
853 |
|
|
-- |
854 |
|
|
-- Sequences for table FEATURE |
855 |
|
|
-- |
856 |
|
|
|
857 |
|
|
CREATE SEQUENCE feature_feature_id_seq; |
858 |
|
|
|
859 |
|
|
CREATE TABLE feature ( |
860 |
|
|
feature_id INT4 DEFAULT nextval('feature_feature_id_seq'), |
861 |
|
|
feature varchar(50) DEFAULT NULL, |
862 |
|
|
image_path varchar(100) DEFAULT NULL, |
863 |
|
|
image_alt varchar(100) DEFAULT NULL, |
864 |
|
|
PRIMARY KEY (feature_id) |
865 |
|
|
|
866 |
|
|
); |
867 |
|
|
|
868 |
|
|
-- |
869 |
|
|
-- Dumping data for table `feature` |
870 |
|
|
-- |
871 |
|
|
|
872 |
|
|
INSERT INTO feature VALUES (1,'(N/A)',NULL,NULL); |
873 |
|
|
INSERT INTO feature VALUES (2,'CD-ROM','images/cd.gif','On CD-ROM Format'); |
874 |
|
|
INSERT INTO feature VALUES (3,'Full Text','images/fulltext.gif','Available in Full Text'); |
875 |
|
|
INSERT INTO feature VALUES (5,'Restricted','images/lock.gif','Authentication Required'); |
876 |
|
|
|
877 |
|
|
-- |
878 |
|
|
-- Table structure for table `libunit` |
879 |
|
|
-- |
880 |
|
|
|
881 |
|
|
|
882 |
|
|
|
883 |
|
|
-- |
884 |
|
|
-- Sequences for table LIBUNIT |
885 |
|
|
-- |
886 |
|
|
|
887 |
|
|
CREATE SEQUENCE libunit_libunit_id_seq; |
888 |
|
|
|
889 |
|
|
CREATE TABLE libunit ( |
890 |
|
|
libunit_id INT4 DEFAULT nextval('libunit_libunit_id_seq'), |
891 |
|
|
libunit varchar(100) DEFAULT NULL, |
892 |
|
|
libunit_abbrev varchar(25) DEFAULT NULL, |
893 |
dpavlin |
43 |
head_staff_id INT4 references staff(staff_id) on delete cascade on update cascade, |
894 |
dpavlin |
34 |
PRIMARY KEY (libunit_id) |
895 |
|
|
|
896 |
|
|
); |
897 |
|
|
|
898 |
|
|
-- |
899 |
|
|
-- Dumping data for table `libunit` |
900 |
|
|
-- |
901 |
|
|
|
902 |
|
|
INSERT INTO libunit VALUES (1,'(N/A)','(N/A)',NULL); |
903 |
|
|
|
904 |
|
|
-- |
905 |
|
|
-- Table structure for table `libunit_staff` |
906 |
|
|
-- |
907 |
|
|
|
908 |
|
|
CREATE TABLE libunit_staff ( |
909 |
dpavlin |
43 |
libunit_id INT4 references libunit(libunit_id) on delete cascade on update cascade, |
910 |
|
|
staff_id INT4 references staff(staff_id) on delete cascade on update cascade, |
911 |
dpavlin |
34 |
PRIMARY KEY (libunit_id,staff_id) |
912 |
|
|
|
913 |
|
|
); |
914 |
|
|
|
915 |
|
|
-- |
916 |
|
|
-- Dumping data for table `libunit_staff` |
917 |
|
|
-- |
918 |
|
|
|
919 |
|
|
-- |
920 |
|
|
-- Table structure for table `masterinfotype` |
921 |
|
|
-- |
922 |
|
|
|
923 |
|
|
|
924 |
|
|
|
925 |
|
|
-- |
926 |
|
|
-- Sequences for table MASTERINFOTYPE |
927 |
|
|
-- |
928 |
|
|
|
929 |
|
|
CREATE SEQUENCE masterinfotype_masterinfotyp; |
930 |
|
|
|
931 |
|
|
CREATE TABLE masterinfotype ( |
932 |
|
|
masterinfotype_id INT4 DEFAULT nextval('masterinfotype_masterinfotyp'), |
933 |
|
|
masterinfotype varchar(75) NOT NULL DEFAULT '', |
934 |
|
|
PRIMARY KEY (masterinfotype_id) |
935 |
|
|
|
936 |
|
|
); |
937 |
|
|
|
938 |
|
|
-- |
939 |
|
|
-- Dumping data for table `masterinfotype` |
940 |
|
|
-- |
941 |
|
|
|
942 |
|
|
INSERT INTO masterinfotype VALUES (1,'(N/A)'); |
943 |
|
|
INSERT INTO masterinfotype VALUES (2,'General Reference Sources'); |
944 |
|
|
INSERT INTO masterinfotype VALUES (3,'Abstracts and Indexes'); |
945 |
|
|
INSERT INTO masterinfotype VALUES (4,'Catalogs and Bibliographies'); |
946 |
|
|
INSERT INTO masterinfotype VALUES (5,'Primary Source Materials'); |
947 |
|
|
INSERT INTO masterinfotype VALUES (6,'Periodical and Newspaper subscriptions'); |
948 |
|
|
INSERT INTO masterinfotype VALUES (7,'Statistics and Data'); |
949 |
|
|
INSERT INTO masterinfotype VALUES (8,'Images Collections'); |
950 |
|
|
INSERT INTO masterinfotype VALUES (9,'Societies, Agencies, and Organizations'); |
951 |
|
|
INSERT INTO masterinfotype VALUES (10,'Style Manuals and Writing Guides'); |
952 |
|
|
INSERT INTO masterinfotype VALUES (11,'Internet Resources'); |
953 |
|
|
INSERT INTO masterinfotype VALUES (12,'University of Minnesota'); |
954 |
|
|
INSERT INTO masterinfotype VALUES (13,'WWW Resources'); |
955 |
|
|
|
956 |
|
|
-- |
957 |
|
|
-- Table structure for table `page_staff` |
958 |
|
|
-- |
959 |
|
|
|
960 |
|
|
CREATE TABLE page_staff ( |
961 |
dpavlin |
43 |
page_id INT4 references page(page_id) on delete cascade on update cascade, |
962 |
|
|
staff_id INT4 references staff(staff_id) on delete cascade on update cascade, |
963 |
dpavlin |
34 |
PRIMARY KEY (page_id,staff_id) |
964 |
|
|
|
965 |
|
|
); |
966 |
|
|
|
967 |
|
|
-- |
968 |
|
|
-- Dumping data for table `page_staff` |
969 |
|
|
-- |
970 |
|
|
|
971 |
|
|
INSERT INTO page_staff VALUES (19,4); |
972 |
|
|
|
973 |
|
|
-- |
974 |
|
|
-- Table structure for table `pastebuffer` |
975 |
|
|
-- |
976 |
|
|
|
977 |
|
|
|
978 |
|
|
|
979 |
|
|
-- |
980 |
|
|
-- Sequences for table PASTEBUFFER |
981 |
|
|
-- |
982 |
|
|
|
983 |
|
|
CREATE SEQUENCE pastebuffer_pastebuffer_id_s; |
984 |
|
|
|
985 |
|
|
CREATE TABLE pastebuffer ( |
986 |
|
|
pastebuffer_id INT4 DEFAULT nextval('pastebuffer_pastebuffer_id_s'), |
987 |
dpavlin |
43 |
paste_staff_id INT4 references staff(staff_id) on delete cascade on update cascade, |
988 |
|
|
parent_id INT4 DEFAULT NULL, -- XXX references what? on delete cascade on update cascade |
989 |
|
|
resource_id INT4 references resource(resource_id) on delete cascade on update cascade, |
990 |
|
|
location_id INT4 references location(location_id) on delete cascade on update cascade, |
991 |
|
|
service_id INT4 references service(service_id) on delete cascade on update cascade, |
992 |
|
|
staff_id INT4 references staff(staff_id) on delete cascade on update cascade, |
993 |
|
|
subject_id INT4 references subject(subject_id) on delete cascade on update cascade, |
994 |
dpavlin |
34 |
label varchar(200) DEFAULT NULL, |
995 |
|
|
label_url varchar(200) DEFAULT NULL, |
996 |
|
|
element_descr text, |
997 |
|
|
element_size INT2 DEFAULT NULL, |
998 |
|
|
element_order INT2 DEFAULT NULL, |
999 |
|
|
indent_level INT2 DEFAULT NULL, |
1000 |
|
|
PRIMARY KEY (pastebuffer_id) |
1001 |
|
|
|
1002 |
|
|
); |
1003 |
|
|
|
1004 |
|
|
-- |
1005 |
|
|
-- Dumping data for table `pastebuffer` |
1006 |
|
|
-- |
1007 |
|
|
|
1008 |
|
|
|
1009 |
|
|
-- |
1010 |
|
|
-- Table structure for table `res_feature` |
1011 |
|
|
-- |
1012 |
|
|
|
1013 |
|
|
CREATE TABLE res_feature ( |
1014 |
dpavlin |
43 |
resource_id INT4 references resource(resource_id) on delete cascade on update cascade, |
1015 |
|
|
feature_id INT4 references feature(feature_id) on delete cascade on update cascade, |
1016 |
dpavlin |
34 |
PRIMARY KEY (resource_id,feature_id) |
1017 |
|
|
|
1018 |
|
|
); |
1019 |
|
|
|
1020 |
|
|
-- |
1021 |
|
|
-- Dumping data for table `res_feature` |
1022 |
|
|
-- |
1023 |
|
|
|
1024 |
|
|
INSERT INTO res_feature VALUES (11,3); |
1025 |
|
|
INSERT INTO res_feature VALUES (14,2); |
1026 |
|
|
INSERT INTO res_feature VALUES (14,5); |
1027 |
|
|
INSERT INTO res_feature VALUES (15,3); |
1028 |
|
|
INSERT INTO res_feature VALUES (16,3); |
1029 |
|
|
INSERT INTO res_feature VALUES (19,3); |
1030 |
|
|
INSERT INTO res_feature VALUES (19,5); |
1031 |
|
|
INSERT INTO res_feature VALUES (20,5); |
1032 |
|
|
|
1033 |
|
|
-- |
1034 |
|
|
-- Table structure for table `res_loc` |
1035 |
|
|
-- |
1036 |
|
|
|
1037 |
|
|
CREATE TABLE res_loc ( |
1038 |
dpavlin |
43 |
resource_id INT4 references resource(resource_id) on delete cascade on update cascade, |
1039 |
|
|
location_id INT4 references location(location_id) on delete cascade on update cascade, |
1040 |
dpavlin |
34 |
PRIMARY KEY (resource_id,location_id) |
1041 |
|
|
|
1042 |
|
|
); |
1043 |
|
|
|
1044 |
|
|
-- |
1045 |
|
|
-- Dumping data for table `res_loc` |
1046 |
|
|
-- |
1047 |
|
|
|
1048 |
|
|
INSERT INTO res_loc VALUES (2,55); |
1049 |
|
|
INSERT INTO res_loc VALUES (3,55); |
1050 |
|
|
INSERT INTO res_loc VALUES (11,55); |
1051 |
|
|
INSERT INTO res_loc VALUES (12,55); |
1052 |
|
|
INSERT INTO res_loc VALUES (13,55); |
1053 |
|
|
INSERT INTO res_loc VALUES (15,55); |
1054 |
|
|
INSERT INTO res_loc VALUES (16,55); |
1055 |
|
|
INSERT INTO res_loc VALUES (18,55); |
1056 |
|
|
INSERT INTO res_loc VALUES (19,55); |
1057 |
|
|
|
1058 |
|
|
-- |
1059 |
|
|
-- Table structure for table `res_mastersubject` |
1060 |
|
|
-- |
1061 |
|
|
|
1062 |
|
|
CREATE TABLE res_mastersubject ( |
1063 |
dpavlin |
43 |
resource_id INT4 references resource(resource_id) on delete cascade on update cascade, |
1064 |
|
|
mastersubject_id INT4 references mastersubject(mastersubject_id) on delete cascade on update cascade, |
1065 |
dpavlin |
34 |
PRIMARY KEY (resource_id,mastersubject_id) |
1066 |
|
|
|
1067 |
|
|
); |
1068 |
|
|
|
1069 |
|
|
-- |
1070 |
|
|
-- Dumping data for table `res_mastersubject` |
1071 |
|
|
-- |
1072 |
|
|
|
1073 |
|
|
INSERT INTO res_mastersubject VALUES (1,10); |
1074 |
|
|
INSERT INTO res_mastersubject VALUES (2,6); |
1075 |
|
|
INSERT INTO res_mastersubject VALUES (3,6); |
1076 |
|
|
INSERT INTO res_mastersubject VALUES (4,6); |
1077 |
|
|
INSERT INTO res_mastersubject VALUES (11,6); |
1078 |
|
|
INSERT INTO res_mastersubject VALUES (12,6); |
1079 |
|
|
INSERT INTO res_mastersubject VALUES (13,6); |
1080 |
|
|
INSERT INTO res_mastersubject VALUES (14,6); |
1081 |
|
|
INSERT INTO res_mastersubject VALUES (15,9); |
1082 |
|
|
INSERT INTO res_mastersubject VALUES (16,9); |
1083 |
|
|
INSERT INTO res_mastersubject VALUES (17,4); |
1084 |
|
|
INSERT INTO res_mastersubject VALUES (18,12); |
1085 |
|
|
INSERT INTO res_mastersubject VALUES (19,10); |
1086 |
|
|
INSERT INTO res_mastersubject VALUES (20,10); |
1087 |
|
|
|
1088 |
|
|
-- |
1089 |
|
|
-- Table structure for table `res_sub_infotype` |
1090 |
|
|
-- |
1091 |
|
|
|
1092 |
|
|
CREATE TABLE res_sub_infotype ( |
1093 |
dpavlin |
43 |
resource_id INT4 references resource(resource_id) on delete cascade on update cascade, |
1094 |
|
|
subject_id INT4 references subject(subject_id) on delete cascade on update cascade, |
1095 |
|
|
infotype_id INT4 references infotype(infotype_id) on delete cascade on update cascade, |
1096 |
dpavlin |
34 |
highlighted char(1) DEFAULT NULL, |
1097 |
|
|
description text, |
1098 |
dpavlin |
43 |
masterinfotype_id INT4 references masterinfotype(masterinfotype_id) on delete cascade on update cascade |
1099 |
dpavlin |
34 |
); |
1100 |
|
|
|
1101 |
|
|
-- |
1102 |
|
|
-- Dumping data for table `res_sub_infotype` |
1103 |
|
|
-- |
1104 |
|
|
|
1105 |
|
|
INSERT INTO res_sub_infotype VALUES (2,2,138,'1','',13); |
1106 |
|
|
INSERT INTO res_sub_infotype VALUES (4,2,138,'0',NULL,13); |
1107 |
|
|
INSERT INTO res_sub_infotype VALUES (3,2,87,'0','',11); |
1108 |
|
|
INSERT INTO res_sub_infotype VALUES (11,2,138,'0',NULL,13); |
1109 |
|
|
INSERT INTO res_sub_infotype VALUES (13,2,87,'0',NULL,11); |
1110 |
|
|
INSERT INTO res_sub_infotype VALUES (14,2,40,'0','',11); |
1111 |
|
|
INSERT INTO res_sub_infotype VALUES (16,6,130,'1','klasici u psihologiji',11); |
1112 |
|
|
INSERT INTO res_sub_infotype VALUES (1,6,41,'0',NULL,11); |
1113 |
|
|
INSERT INTO res_sub_infotype VALUES (18,7,24,'0',NULL,4); |
1114 |
|
|
INSERT INTO res_sub_infotype VALUES (1,7,41,'0',NULL,11); |
1115 |
|
|
INSERT INTO res_sub_infotype VALUES (19,7,126,'0',NULL,6); |
1116 |
|
|
INSERT INTO res_sub_infotype VALUES (1,2,18,'0',NULL,3); |
1117 |
|
|
INSERT INTO res_sub_infotype VALUES (20,6,18,'0',NULL,3); |
1118 |
|
|
|
1119 |
|
|
-- |
1120 |
|
|
-- Table structure for table `serv_loc` |
1121 |
|
|
-- |
1122 |
|
|
|
1123 |
|
|
CREATE TABLE serv_loc ( |
1124 |
|
|
service_id INT4 NOT NULL DEFAULT '0', |
1125 |
dpavlin |
43 |
location_id INT4 references location(location_id) on delete cascade on update cascade, |
1126 |
dpavlin |
34 |
allloc char(1) DEFAULT NULL, |
1127 |
|
|
PRIMARY KEY (service_id,location_id) |
1128 |
|
|
|
1129 |
|
|
); |
1130 |
|
|
|
1131 |
|
|
-- |
1132 |
|
|
-- Dumping data for table `serv_loc` |
1133 |
|
|
-- |
1134 |
|
|
|
1135 |
|
|
|
1136 |
|
|
-- |
1137 |
|
|
-- Table structure for table `serv_servtype` |
1138 |
|
|
-- |
1139 |
|
|
|
1140 |
|
|
CREATE TABLE serv_servtype ( |
1141 |
dpavlin |
43 |
service_id INT4 references service(service_id) on delete cascade on update cascade, |
1142 |
|
|
servicetype_id INT4 references servicetype(servicetype_id) on delete cascade on update cascade, |
1143 |
dpavlin |
34 |
PRIMARY KEY (service_id,servicetype_id) |
1144 |
|
|
|
1145 |
|
|
); |
1146 |
|
|
|
1147 |
|
|
-- |
1148 |
|
|
-- Dumping data for table `serv_servtype` |
1149 |
|
|
-- |
1150 |
|
|
|
1151 |
|
|
|
1152 |
|
|
-- |
1153 |
|
|
-- Table structure for table `sub_coursesub` |
1154 |
|
|
-- |
1155 |
|
|
|
1156 |
|
|
CREATE TABLE sub_coursesub ( |
1157 |
dpavlin |
43 |
subject_id INT4 references subject(subject_id) on delete cascade on update cascade, |
1158 |
|
|
coursesub_id INT4 references coursesub(coursesub_id) on delete cascade on update cascade, |
1159 |
dpavlin |
34 |
PRIMARY KEY (subject_id,coursesub_id) |
1160 |
|
|
|
1161 |
|
|
); |
1162 |
|
|
|
1163 |
|
|
-- |
1164 |
|
|
-- Dumping data for table `sub_coursesub` |
1165 |
|
|
-- |
1166 |
|
|
|
1167 |
|
|
INSERT INTO sub_coursesub VALUES (6,555); |
1168 |
|
|
|
1169 |
|
|
-- |
1170 |
|
|
-- Table structure for table `sub_loc` |
1171 |
|
|
-- |
1172 |
|
|
|
1173 |
|
|
CREATE TABLE sub_loc ( |
1174 |
dpavlin |
43 |
subject_id INT4 references subject(subject_id) on delete cascade on update cascade, |
1175 |
|
|
location_id INT4 references location(location_id) on delete cascade on update cascade, |
1176 |
dpavlin |
34 |
PRIMARY KEY (subject_id,location_id) |
1177 |
|
|
|
1178 |
|
|
); |
1179 |
|
|
|
1180 |
|
|
-- |
1181 |
|
|
-- Dumping data for table `sub_loc` |
1182 |
|
|
-- |
1183 |
|
|
|
1184 |
|
|
INSERT INTO sub_loc VALUES (2,55); |
1185 |
|
|
|
1186 |
|
|
-- |
1187 |
|
|
-- Table structure for table `sub_mastersubject` |
1188 |
|
|
-- |
1189 |
|
|
|
1190 |
|
|
CREATE TABLE sub_mastersubject ( |
1191 |
dpavlin |
43 |
subject_id INT4 references subject(subject_id) on delete cascade on update cascade, |
1192 |
|
|
mastersubject_id INT4 references mastersubject(mastersubject_id) on delete cascade on update cascade, |
1193 |
dpavlin |
34 |
PRIMARY KEY (subject_id,mastersubject_id) |
1194 |
|
|
|
1195 |
|
|
); |
1196 |
|
|
|
1197 |
|
|
-- |
1198 |
|
|
-- Dumping data for table `sub_mastersubject` |
1199 |
|
|
-- |
1200 |
|
|
|
1201 |
|
|
INSERT INTO sub_mastersubject VALUES (2,6); |
1202 |
|
|
INSERT INTO sub_mastersubject VALUES (6,9); |
1203 |
|
|
|
1204 |
|
|
-- |
1205 |
|
|
-- Table structure for table `sub_othersub` |
1206 |
|
|
-- |
1207 |
|
|
|
1208 |
|
|
CREATE TABLE sub_othersub ( |
1209 |
dpavlin |
43 |
subject_id INT4 references subject(subject_id) on delete cascade on update cascade, |
1210 |
dpavlin |
34 |
othersub_id INT4 NOT NULL DEFAULT '0', -- XXX subject or mastersubject? |
1211 |
|
|
PRIMARY KEY (subject_id,othersub_id) |
1212 |
|
|
|
1213 |
|
|
); |
1214 |
|
|
|
1215 |
|
|
-- |
1216 |
|
|
-- Dumping data for table `sub_othersub` |
1217 |
|
|
-- |
1218 |
|
|
|
1219 |
|
|
|
1220 |
|
|
-- |
1221 |
|
|
-- Table structure for table `sub_page` |
1222 |
|
|
-- |
1223 |
|
|
|
1224 |
|
|
CREATE TABLE sub_page ( |
1225 |
dpavlin |
43 |
subject_id INT4 references subject(subject_id) on delete cascade on update cascade, |
1226 |
|
|
page_id INT4 references page(page_id) on delete cascade on update cascade, |
1227 |
dpavlin |
34 |
PRIMARY KEY (subject_id,page_id) |
1228 |
|
|
|
1229 |
|
|
); |
1230 |
|
|
|
1231 |
|
|
-- |
1232 |
|
|
-- Dumping data for table `sub_page` |
1233 |
|
|
-- |
1234 |
|
|
|
1235 |
|
|
|
1236 |
|
|
-- |
1237 |
|
|
-- Table structure for table `sub_staff` |
1238 |
|
|
-- |
1239 |
|
|
|
1240 |
|
|
CREATE TABLE sub_staff ( |
1241 |
dpavlin |
43 |
subject_id INT4 references subject(subject_id) on delete cascade on update cascade, |
1242 |
|
|
staff_id INT4 references staff(staff_id) on delete cascade on update cascade, |
1243 |
dpavlin |
34 |
PRIMARY KEY (subject_id,staff_id) |
1244 |
|
|
|
1245 |
|
|
); |
1246 |
|
|
|
1247 |
|
|
-- |
1248 |
|
|
-- Dumping data for table `sub_staff` |
1249 |
|
|
-- |
1250 |
|
|
|
1251 |
|
|
INSERT INTO sub_staff VALUES (2,2); |
1252 |
|
|
INSERT INTO sub_staff VALUES (6,2); |
1253 |
|
|
INSERT INTO sub_staff VALUES (6,3); |
1254 |
|
|
INSERT INTO sub_staff VALUES (7,2); |
1255 |
|
|
|
1256 |
|
|
|
1257 |
|
|
-- |
1258 |
|
|
-- Sequences for table PAGE |
1259 |
|
|
-- |
1260 |
|
|
|
1261 |
|
|
SELECT SETVAL('page_page_id_seq',(select case when max(page_id)>0 then max(page_id)+1 else 1 end from page)); |
1262 |
|
|
|
1263 |
|
|
-- |
1264 |
|
|
-- Sequences for table INFOTYPE |
1265 |
|
|
-- |
1266 |
|
|
|
1267 |
|
|
SELECT SETVAL('infotype_infotype_id_seq',(select case when max(infotype_id)>0 then max(infotype_id)+1 else 1 end from infotype)); |
1268 |
|
|
|
1269 |
|
|
-- |
1270 |
|
|
-- Sequences for table TERM |
1271 |
|
|
-- |
1272 |
|
|
|
1273 |
|
|
SELECT SETVAL('term_term_id_seq',(select case when max(term_id)>0 then max(term_id)+1 else 1 end from term)); |
1274 |
|
|
|
1275 |
|
|
-- |
1276 |
|
|
-- Sequences for table FEATURE |
1277 |
|
|
-- |
1278 |
|
|
|
1279 |
|
|
SELECT SETVAL('feature_feature_id_seq',(select case when max(feature_id)>0 then max(feature_id)+1 else 1 end from feature)); |
1280 |
|
|
|
1281 |
|
|
-- |
1282 |
|
|
-- Sequences for table STAFFTITLE |
1283 |
|
|
-- |
1284 |
|
|
|
1285 |
|
|
SELECT SETVAL('stafftitle_stafftitle_id_seq',(select case when max(stafftitle_id)>0 then max(stafftitle_id)+1 else 1 end from stafftitle)); |
1286 |
|
|
|
1287 |
|
|
-- |
1288 |
|
|
-- Sequences for table LIBUNIT |
1289 |
|
|
-- |
1290 |
|
|
|
1291 |
|
|
SELECT SETVAL('libunit_libunit_id_seq',(select case when max(libunit_id)>0 then max(libunit_id)+1 else 1 end from libunit)); |
1292 |
|
|
|
1293 |
|
|
-- |
1294 |
|
|
-- Sequences for table MASTERINFOTYPE |
1295 |
|
|
-- |
1296 |
|
|
|
1297 |
|
|
SELECT SETVAL('masterinfotype_masterinfotyp',(select case when max(masterinfotype_id)>0 then max(masterinfotype_id)+1 else 1 end from masterinfotype)); |
1298 |
|
|
|
1299 |
|
|
-- |
1300 |
|
|
-- Sequences for table SERVICETYPE |
1301 |
|
|
-- |
1302 |
|
|
|
1303 |
|
|
SELECT SETVAL('servicetype_servicetype_id_s',(select case when max(servicetype_id)>0 then max(servicetype_id)+1 else 1 end from servicetype)); |
1304 |
|
|
|
1305 |
|
|
-- |
1306 |
|
|
-- Sequences for table MASTERSUBJECT |
1307 |
|
|
-- |
1308 |
|
|
|
1309 |
|
|
SELECT SETVAL('mastersubject_mastersubject_',(select case when max(mastersubject_id)>0 then max(mastersubject_id)+1 else 1 end from mastersubject)); |
1310 |
|
|
|
1311 |
|
|
-- |
1312 |
|
|
-- Sequences for table COURSE |
1313 |
|
|
-- |
1314 |
|
|
|
1315 |
|
|
SELECT SETVAL('course_course_id_seq',(select case when max(course_id)>0 then max(course_id)+1 else 1 end from course)); |
1316 |
|
|
|
1317 |
|
|
-- |
1318 |
|
|
-- Sequences for table COURSESUB |
1319 |
|
|
-- |
1320 |
|
|
|
1321 |
|
|
SELECT SETVAL('coursesub_coursesub_id_seq',(select case when max(coursesub_id)>0 then max(coursesub_id)+1 else 1 end from coursesub)); |
1322 |
|
|
|
1323 |
|
|
-- |
1324 |
|
|
-- Sequences for table LOCATION |
1325 |
|
|
-- |
1326 |
|
|
|
1327 |
|
|
SELECT SETVAL('location_location_id_seq',(select case when max(location_id)>0 then max(location_id)+1 else 1 end from location)); |
1328 |
|
|
|
1329 |
|
|
-- |
1330 |
|
|
-- Sequences for table SUBJECT |
1331 |
|
|
-- |
1332 |
|
|
|
1333 |
|
|
SELECT SETVAL('subject_subject_id_seq',(select case when max(subject_id)>0 then max(subject_id)+1 else 1 end from subject)); |
1334 |
|
|
|
1335 |
|
|
-- |
1336 |
|
|
-- Sequences for table ACCESS |
1337 |
|
|
-- |
1338 |
|
|
|
1339 |
|
|
SELECT SETVAL('access_access_id_seq',(select case when max(access_id)>0 then max(access_id)+1 else 1 end from access)); |
1340 |
|
|
|
1341 |
|
|
-- |
1342 |
|
|
-- Sequences for table STYLE |
1343 |
|
|
-- |
1344 |
|
|
|
1345 |
|
|
SELECT SETVAL('style_style_id_seq',(select case when max(style_id)>0 then max(style_id)+1 else 1 end from style)); |
1346 |
|
|
|
1347 |
|
|
-- |
1348 |
|
|
-- Sequences for table STAFF |
1349 |
|
|
-- |
1350 |
|
|
|
1351 |
|
|
SELECT SETVAL('staff_staff_id_seq',(select case when max(staff_id)>0 then max(staff_id)+1 else 1 end from staff)); |
1352 |
|
|
|
1353 |
|
|
-- |
1354 |
|
|
-- Sequences for table COURSE_PERSONNEL |
1355 |
|
|
-- |
1356 |
|
|
|
1357 |
|
|
SELECT SETVAL('course_personnel_personnel_i',(select case when max(personnel_id)>0 then max(personnel_id)+1 else 1 end from course_personnel)); |
1358 |
|
|
|
1359 |
|
|
-- |
1360 |
|
|
-- Sequences for table FACULTY |
1361 |
|
|
-- |
1362 |
|
|
|
1363 |
|
|
SELECT SETVAL('faculty_faculty_id_seq',(select case when max(faculty_id)>0 then max(faculty_id)+1 else 1 end from faculty)); |
1364 |
|
|
|
1365 |
|
|
-- |
1366 |
|
|
-- Sequences for table SERVICE |
1367 |
|
|
-- |
1368 |
|
|
|
1369 |
|
|
SELECT SETVAL('service_service_id_seq',(select case when max(service_id)>0 then max(service_id)+1 else 1 end from service)); |
1370 |
|
|
|
1371 |
|
|
-- |
1372 |
|
|
-- Sequences for table ELEMENT |
1373 |
|
|
-- |
1374 |
|
|
|
1375 |
|
|
SELECT SETVAL('element_element_id_seq',(select case when max(element_id)>0 then max(element_id)+1 else 1 end from element)); |
1376 |
|
|
|
1377 |
|
|
-- |
1378 |
|
|
-- Sequences for table RESOURCE |
1379 |
|
|
-- |
1380 |
|
|
|
1381 |
|
|
SELECT SETVAL('resource_resource_id_seq',(select case when max(resource_id)>0 then max(resource_id)+1 else 1 end from resource)); |
1382 |
|
|
|
1383 |
|
|
-- |
1384 |
|
|
-- Sequences for table PASTEBUFFER |
1385 |
|
|
-- |
1386 |
|
|
|
1387 |
|
|
SELECT SETVAL('pastebuffer_pastebuffer_id_s',(select case when max(pastebuffer_id)>0 then max(pastebuffer_id)+1 else 1 end from pastebuffer)); |
1388 |
|
|
|
1389 |
|
|
-- |
1390 |
|
|
-- Sequences for table CAMPUS |
1391 |
|
|
-- |
1392 |
|
|
|
1393 |
|
|
SELECT SETVAL('campus_campus_id_seq',(select case when max(campus_id)>0 then max(campus_id)+1 else 1 end from campus)); |
1394 |
|
|
|
1395 |
|
|
-- |
1396 |
|
|
-- Sequences for table PAGETYPE |
1397 |
|
|
-- |
1398 |
|
|
|
1399 |
|
|
SELECT SETVAL('pagetype_pagetype_id_seq',(select case when max(pagetype_id)>0 then max(pagetype_id)+1 else 1 end from pagetype)); |
1400 |
|
|
|
1401 |
|
|
COMMIT; |