1 |
------------------------------------------------------------------ |
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 |
campus_id INT4 references campus(campus_id) on delete cascade on update cascade, |
89 |
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 |
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 |
page_title varchar(255) DEFAULT NULL, |
209 |
pagetitle_style INT2 references style(style_id) on delete cascade on update cascade, |
210 |
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 |
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 |
course_num varchar(50) DEFAULT NULL, |
251 |
course_section varchar(10) DEFAULT NULL, |
252 |
course_concat varchar(255) DEFAULT NULL, |
253 |
term_id INT4 references term(term_id) on delete cascade on update cascade, |
254 |
course_year varchar(4) DEFAULT NULL, |
255 |
campus_id INT4 references campus(campus_id) on delete cascade on update cascade, |
256 |
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 |
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 |
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 |
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 |
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 |
sublocation_id INT4 references location(location_id) on delete cascade on update cascade, |
521 |
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 `masterinfotype` |
581 |
-- |
582 |
|
583 |
|
584 |
|
585 |
-- |
586 |
-- Sequences for table MASTERINFOTYPE |
587 |
-- |
588 |
|
589 |
CREATE SEQUENCE masterinfotype_masterinfotyp; |
590 |
|
591 |
CREATE TABLE masterinfotype ( |
592 |
masterinfotype_id INT4 DEFAULT nextval('masterinfotype_masterinfotyp'), |
593 |
masterinfotype varchar(75) NOT NULL DEFAULT '', |
594 |
PRIMARY KEY (masterinfotype_id) |
595 |
|
596 |
); |
597 |
|
598 |
-- |
599 |
-- Dumping data for table `masterinfotype` |
600 |
-- |
601 |
|
602 |
INSERT INTO masterinfotype VALUES (1,'(N/A)'); |
603 |
INSERT INTO masterinfotype VALUES (2,'General Reference Sources'); |
604 |
INSERT INTO masterinfotype VALUES (3,'Abstracts and Indexes'); |
605 |
INSERT INTO masterinfotype VALUES (4,'Catalogs and Bibliographies'); |
606 |
INSERT INTO masterinfotype VALUES (5,'Primary Source Materials'); |
607 |
INSERT INTO masterinfotype VALUES (6,'Periodical and Newspaper subscriptions'); |
608 |
INSERT INTO masterinfotype VALUES (7,'Statistics and Data'); |
609 |
INSERT INTO masterinfotype VALUES (8,'Images Collections'); |
610 |
INSERT INTO masterinfotype VALUES (9,'Societies, Agencies, and Organizations'); |
611 |
INSERT INTO masterinfotype VALUES (10,'Style Manuals and Writing Guides'); |
612 |
INSERT INTO masterinfotype VALUES (11,'Internet Resources'); |
613 |
INSERT INTO masterinfotype VALUES (12,'University of Minnesota'); |
614 |
INSERT INTO masterinfotype VALUES (13,'WWW Resources'); |
615 |
|
616 |
-- |
617 |
-- Table structure for table `infotype` |
618 |
-- |
619 |
|
620 |
|
621 |
|
622 |
-- |
623 |
-- Sequences for table INFOTYPE |
624 |
-- |
625 |
|
626 |
CREATE SEQUENCE infotype_infotype_id_seq; |
627 |
|
628 |
CREATE TABLE infotype ( |
629 |
infotype_id INT4 DEFAULT nextval('infotype_infotype_id_seq'), |
630 |
masterinfotype_id INT4 references masterinfotype(masterinfotype_id) on delete cascade on update cascade, |
631 |
mastersubject_id INT4 references mastersubject(mastersubject_id) on delete cascade on update cascade, |
632 |
infotype varchar(75) NOT NULL DEFAULT '', |
633 |
PRIMARY KEY (infotype_id) |
634 |
|
635 |
); |
636 |
|
637 |
-- |
638 |
-- Dumping data for table `infotype` |
639 |
-- |
640 |
|
641 |
INSERT INTO infotype VALUES (1,1,1,'(N/A)'); |
642 |
INSERT INTO infotype VALUES (2,2,2,'Almanacs'); |
643 |
INSERT INTO infotype VALUES (3,2,2,'Encyclopedias'); |
644 |
INSERT INTO infotype VALUES (4,2,2,'Field Guides'); |
645 |
INSERT INTO infotype VALUES (5,2,2,'Dictionaries'); |
646 |
INSERT INTO infotype VALUES (6,2,2,'Handbooks and Manuals'); |
647 |
INSERT INTO infotype VALUES (7,2,2,'Biographical Sources'); |
648 |
INSERT INTO infotype VALUES (8,2,2,'Directories'); |
649 |
INSERT INTO infotype VALUES (9,2,2,'Glossaries'); |
650 |
INSERT INTO infotype VALUES (10,2,2,'Reports'); |
651 |
INSERT INTO infotype VALUES (11,2,2,'Public Opinion Resources'); |
652 |
INSERT INTO infotype VALUES (12,2,2,'Yearbooks'); |
653 |
INSERT INTO infotype VALUES (13,2,2,'Speeches'); |
654 |
INSERT INTO infotype VALUES (14,2,4,'Atlases & Maps'); |
655 |
INSERT INTO infotype VALUES (15,2,2,'Chronologies'); |
656 |
INSERT INTO infotype VALUES (16,2,2,'Forms, Tests, Inventories'); |
657 |
INSERT INTO infotype VALUES (17,2,2,'General Reference Works'); |
658 |
INSERT INTO infotype VALUES (18,3,2,'Academic or Scholarly Articles Subject Indexes'); |
659 |
INSERT INTO infotype VALUES (19,3,2,'General Indexes to Magazine, Journal & Newspaper Articles'); |
660 |
INSERT INTO infotype VALUES (20,3,2,'Catalogs & Indexes to Government Publications'); |
661 |
INSERT INTO infotype VALUES (21,3,2,'Indexes, Other'); |
662 |
INSERT INTO infotype VALUES (22,4,2,'Bibliographies'); |
663 |
INSERT INTO infotype VALUES (23,4,2,'National Bibliographies'); |
664 |
INSERT INTO infotype VALUES (24,4,2,'Catalogs'); |
665 |
INSERT INTO infotype VALUES (25,5,2,'Reports'); |
666 |
INSERT INTO infotype VALUES (26,5,2,'Diaries'); |
667 |
INSERT INTO infotype VALUES (27,5,2,'Correspondence'); |
668 |
INSERT INTO infotype VALUES (28,5,2,'Speeches'); |
669 |
INSERT INTO infotype VALUES (29,6,2,'News Sources'); |
670 |
INSERT INTO infotype VALUES (30,6,2,'Journal Titles'); |
671 |
INSERT INTO infotype VALUES (31,6,2,'Magazine Titles'); |
672 |
INSERT INTO infotype VALUES (32,7,2,'Data Resources'); |
673 |
INSERT INTO infotype VALUES (33,7,2,'Statistical Guides'); |
674 |
INSERT INTO infotype VALUES (34,7,2,'Statistical Resources'); |
675 |
INSERT INTO infotype VALUES (35,8,2,'Atlases and Maps'); |
676 |
INSERT INTO infotype VALUES (37,9,2,'Trade & Professional Associations'); |
677 |
INSERT INTO infotype VALUES (38,10,2,'Guides to Working with Government Publications'); |
678 |
INSERT INTO infotype VALUES (39,10,2,'Research Guides'); |
679 |
INSERT INTO infotype VALUES (40,11,2,'Gateways & Megasites'); |
680 |
INSERT INTO infotype VALUES (41,11,2,'Search Engines'); |
681 |
INSERT INTO infotype VALUES (42,12,2,'Related U of M Web Sites'); |
682 |
INSERT INTO infotype VALUES (43,2,5,'Security Analysts\' Reports'); |
683 |
INSERT INTO infotype VALUES (44,2,5,'Doing Business in Another Country'); |
684 |
INSERT INTO infotype VALUES (45,2,5,'Financial Ratios'); |
685 |
INSERT INTO infotype VALUES (46,2,5,'Industry Profiles'); |
686 |
INSERT INTO infotype VALUES (47,2,5,'Market Research Surveys'); |
687 |
INSERT INTO infotype VALUES (48,2,5,'Tax Reporters'); |
688 |
INSERT INTO infotype VALUES (49,2,5,'Financial Reports'); |
689 |
INSERT INTO infotype VALUES (50,2,5,'Accounting Standards'); |
690 |
INSERT INTO infotype VALUES (51,2,5,'Nonprofit Finance'); |
691 |
INSERT INTO infotype VALUES (52,2,5,'Nonprofit Management'); |
692 |
INSERT INTO infotype VALUES (53,2,5,'Nonprofit Marketing'); |
693 |
INSERT INTO infotype VALUES (54,2,5,'Leadership History'); |
694 |
INSERT INTO infotype VALUES (55,2,5,'Leadership Landscapes, strategies and structures'); |
695 |
INSERT INTO infotype VALUES (56,2,5,'Books by and about Leaders'); |
696 |
INSERT INTO infotype VALUES (57,2,6,'Spectra'); |
697 |
INSERT INTO infotype VALUES (58,2,6,'Spectra, Atomic'); |
698 |
INSERT INTO infotype VALUES (59,2,6,'Spectra, General'); |
699 |
INSERT INTO infotype VALUES (60,2,6,'Spectra, Infrared'); |
700 |
INSERT INTO infotype VALUES (61,2,6,'Spectra, Mass'); |
701 |
INSERT INTO infotype VALUES (62,2,6,'Spectra, Nuclear Magnetic Resonance'); |
702 |
INSERT INTO infotype VALUES (63,2,6,'Spectra, Raman'); |
703 |
INSERT INTO infotype VALUES (64,2,6,'Spectra, Ultraviolet & Visible'); |
704 |
INSERT INTO infotype VALUES (65,2,6,'Chemical Compounds'); |
705 |
INSERT INTO infotype VALUES (66,2,6,'Data Compilations/Algorithms'); |
706 |
INSERT INTO infotype VALUES (67,2,6,'Organic Reactions'); |
707 |
INSERT INTO infotype VALUES (68,2,6,'Organic Synthesis'); |
708 |
INSERT INTO infotype VALUES (69,2,6,'Physical Property Data'); |
709 |
INSERT INTO infotype VALUES (70,2,8,'Federal Law - Administrative Law'); |
710 |
INSERT INTO infotype VALUES (71,2,8,'Minnesota Law - Constitution, Statutes and Codes'); |
711 |
INSERT INTO infotype VALUES (72,2,8,'Courts'); |
712 |
INSERT INTO infotype VALUES (73,2,8,'Attorneys and Law Firms'); |
713 |
INSERT INTO infotype VALUES (74,2,8,'Minnesota Law - Administrative Law'); |
714 |
INSERT INTO infotype VALUES (75,2,8,'Minnesota Law - Case Law'); |
715 |
INSERT INTO infotype VALUES (76,2,8,'Law Schools'); |
716 |
INSERT INTO infotype VALUES (77,2,8,'Federal Law - Case Law - U.S. Supreme Court'); |
717 |
INSERT INTO infotype VALUES (78,2,8,'Federal Law - Case Law - U.S. Court of Appeals'); |
718 |
INSERT INTO infotype VALUES (79,2,8,'Federal Law - Case Law - U.S. District Courts'); |
719 |
INSERT INTO infotype VALUES (80,2,8,'Laws and Legislation'); |
720 |
INSERT INTO infotype VALUES (81,2,8,'Official Journal of Legislative Activity'); |
721 |
INSERT INTO infotype VALUES (82,2,8,'Unofficial Journal of Legislative Activity'); |
722 |
INSERT INTO infotype VALUES (83,2,8,'Legislative Debates'); |
723 |
INSERT INTO infotype VALUES (84,2,8,'Federal Law - Constitution, Statutes and Codes'); |
724 |
INSERT INTO infotype VALUES (85,2,2,'Country Studies'); |
725 |
INSERT INTO infotype VALUES (130,11,2,'Electronic Texts'); |
726 |
INSERT INTO infotype VALUES (87,11,2,'Official Agency and Organization Web Sites'); |
727 |
INSERT INTO infotype VALUES (88,11,2,'Internet Directory'); |
728 |
INSERT INTO infotype VALUES (105,1,6,'Astronomical Objects'); |
729 |
INSERT INTO infotype VALUES (124,10,2,'Writing Guides'); |
730 |
INSERT INTO infotype VALUES (125,2,6,'Safety Information'); |
731 |
INSERT INTO infotype VALUES (126,6,2,'Electronic Journal Collections'); |
732 |
INSERT INTO infotype VALUES (127,8,2,'Image Resources'); |
733 |
INSERT INTO infotype VALUES (128,2,2,'Conferences and Proceedings'); |
734 |
INSERT INTO infotype VALUES (129,10,2,'Style Manuals'); |
735 |
INSERT INTO infotype VALUES (131,2,2,'Standards'); |
736 |
INSERT INTO infotype VALUES (132,2,6,'Analytical Techniques'); |
737 |
INSERT INTO infotype VALUES (133,2,6,'Chemical Prices'); |
738 |
INSERT INTO infotype VALUES (134,2,2,'Treatises'); |
739 |
INSERT INTO infotype VALUES (135,2,2,'Rankings'); |
740 |
INSERT INTO infotype VALUES (136,2,2,'Technical Reports'); |
741 |
INSERT INTO infotype VALUES (137,5,2,'Historical Documents'); |
742 |
INSERT INTO infotype VALUES (138,13,2,'Web Sites'); |
743 |
INSERT INTO infotype VALUES (139,5,2,'Government Documents'); |
744 |
INSERT INTO infotype VALUES (140,5,2,'Archival Materials'); |
745 |
INSERT INTO infotype VALUES (143,2,2,'Dissertations and Theses'); |
746 |
INSERT INTO infotype VALUES (142,2,2,'Guides'); |
747 |
INSERT INTO infotype VALUES (147,13,2,'Library Web Sites'); |
748 |
INSERT INTO infotype VALUES (148,13,2,'Campus web site'); |
749 |
INSERT INTO infotype VALUES (149,6,2,'Electronic Journal Titles'); |
750 |
|
751 |
-- |
752 |
-- Table structure for table `resource` |
753 |
-- |
754 |
|
755 |
|
756 |
|
757 |
-- |
758 |
-- Sequences for table RESOURCE |
759 |
-- |
760 |
|
761 |
CREATE SEQUENCE resource_resource_id_seq; |
762 |
|
763 |
CREATE TABLE resource ( |
764 |
resource_id INT4 DEFAULT nextval('resource_resource_id_seq'), |
765 |
date_created TIMESTAMP DEFAULT NULL, |
766 |
date_modified TIMESTAMP DEFAULT NULL, |
767 |
account_created varchar(20) DEFAULT NULL, |
768 |
account_modified varchar(20) DEFAULT NULL, |
769 |
title varchar(255) DEFAULT NULL, |
770 |
other_title text, |
771 |
author varchar(125) DEFAULT NULL, |
772 |
publisher varchar(255) DEFAULT NULL, |
773 |
pub_date varchar(255) DEFAULT NULL, |
774 |
edition varchar(25) DEFAULT NULL, |
775 |
cat_num varchar(50) DEFAULT NULL, |
776 |
call_no text, |
777 |
coverage_detail varchar(255) DEFAULT NULL, |
778 |
sources_indexed varchar(100) DEFAULT NULL, |
779 |
url text, |
780 |
visited varchar(25) DEFAULT NULL, |
781 |
annotation text, |
782 |
location_id INT4 references location(location_id) on delete cascade on update cascade, |
783 |
infotype_id INT4 references infotype(infotype_id) on delete cascade on update cascade, |
784 |
vendor_id INT4 DEFAULT NULL, -- XXX unused |
785 |
PRIMARY KEY (resource_id) |
786 |
|
787 |
); |
788 |
|
789 |
-- |
790 |
-- Dumping data for table `resource` |
791 |
-- |
792 |
|
793 |
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); |
794 |
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); |
795 |
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); |
796 |
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); |
797 |
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); |
798 |
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); |
799 |
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); |
800 |
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); |
801 |
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); |
802 |
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); |
803 |
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); |
804 |
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); |
805 |
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); |
806 |
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); |
807 |
|
808 |
-- |
809 |
-- Table structure for table `element` |
810 |
-- |
811 |
|
812 |
|
813 |
|
814 |
-- |
815 |
-- Sequences for table ELEMENT |
816 |
-- |
817 |
|
818 |
CREATE SEQUENCE element_element_id_seq; |
819 |
|
820 |
CREATE TABLE element ( |
821 |
element_id INT4 DEFAULT nextval('element_element_id_seq'), |
822 |
page_id INT4 references page(page_id) on delete cascade on update cascade, |
823 |
parent_id INT4, --- XXX references element(element_id) on delete cascade on update cascade, |
824 |
resource_id INT4 references resource(resource_id) on delete cascade on update cascade, |
825 |
location_id INT4 references location(location_id) on delete cascade on update cascade, |
826 |
service_id INT4 references service(service_id) on delete cascade on update cascade, |
827 |
staff_id INT4 references staff(staff_id) on delete cascade on update cascade, |
828 |
subject_id INT4 references subject(subject_id) on delete cascade on update cascade, |
829 |
label varchar(200) DEFAULT NULL, |
830 |
label_url varchar(200) DEFAULT NULL, |
831 |
element_descr text, |
832 |
element_size INT2 DEFAULT NULL, |
833 |
element_order INT2 DEFAULT NULL, |
834 |
indent_level INT2 DEFAULT NULL, |
835 |
PRIMARY KEY (element_id) |
836 |
|
837 |
); |
838 |
|
839 |
-- |
840 |
-- Dumping data for table `element` |
841 |
-- |
842 |
|
843 |
INSERT INTO element VALUES (21,4,15,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,9,1); |
844 |
INSERT INTO element VALUES (22,4,15,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,10,1); |
845 |
INSERT INTO element VALUES (20,4,15,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7,1); |
846 |
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); |
847 |
INSERT INTO element VALUES (23,4,15,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,11,1); |
848 |
INSERT INTO element VALUES (25,4,15,11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,12,1); |
849 |
INSERT INTO element VALUES (28,15,0,NULL,NULL,NULL,NULL,NULL,'Library Resources','','',1,8,0); |
850 |
INSERT INTO element VALUES (29,15,28,NULL,58,NULL,NULL,NULL,NULL,NULL,'\r\n',NULL,9,1); |
851 |
INSERT INTO element VALUES (30,15,28,NULL,55,NULL,NULL,NULL,NULL,NULL,NULL,5,10,1); |
852 |
INSERT INTO element VALUES (31,15,0,NULL,NULL,NULL,NULL,NULL,'Astrobiology','','',1,1,0); |
853 |
INSERT INTO element VALUES (32,15,31,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,1); |
854 |
INSERT INTO element VALUES (33,15,31,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,1); |
855 |
INSERT INTO element VALUES (34,15,31,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,1); |
856 |
INSERT INTO element VALUES (35,15,31,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,1); |
857 |
INSERT INTO element VALUES (36,15,31,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,1); |
858 |
INSERT INTO element VALUES (37,15,31,11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,1); |
859 |
INSERT INTO element VALUES (49,4,0,2,NULL,NULL,NULL,NULL,'','','',0,5,0); |
860 |
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); |
861 |
INSERT INTO element VALUES (51,4,20,NULL,NULL,NULL,NULL,NULL,'to je tekst','http://bla..','neki tekst',NULL,8,2); |
862 |
INSERT INTO element VALUES (52,4,0,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4,0); |
863 |
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); |
864 |
INSERT INTO element VALUES (54,4,0,16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0); |
865 |
INSERT INTO element VALUES (55,4,0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0); |
866 |
INSERT INTO element VALUES (56,4,0,NULL,NULL,NULL,NULL,6,NULL,NULL,NULL,0,1,0); |
867 |
INSERT INTO element VALUES (58,18,57,13,NULL,NULL,NULL,NULL,'','','',NULL,10,1); |
868 |
INSERT INTO element VALUES (59,18,57,14,NULL,NULL,NULL,NULL,'','','',NULL,12,1); |
869 |
INSERT INTO element VALUES (60,18,57,4,NULL,NULL,NULL,NULL,'','','',NULL,13,1); |
870 |
INSERT INTO element VALUES (61,18,57,3,NULL,NULL,NULL,NULL,'','','',NULL,14,1); |
871 |
INSERT INTO element VALUES (62,18,57,11,NULL,NULL,NULL,NULL,'','','',NULL,15,1); |
872 |
INSERT INTO element VALUES (63,18,0,2,NULL,NULL,NULL,NULL,'','','',NULL,8,0); |
873 |
INSERT INTO element VALUES (64,18,58,NULL,NULL,NULL,NULL,NULL,'to je tekst','http://bla..','neki tekst',NULL,11,2); |
874 |
INSERT INTO element VALUES (65,18,0,20,NULL,NULL,NULL,NULL,'','','',NULL,7,0); |
875 |
INSERT INTO element VALUES (66,18,0,16,NULL,NULL,NULL,NULL,'','','',NULL,5,0); |
876 |
INSERT INTO element VALUES (67,18,0,1,NULL,NULL,NULL,NULL,'','','',NULL,6,0); |
877 |
INSERT INTO element VALUES (68,18,0,NULL,NULL,NULL,NULL,6,'','','',NULL,4,0); |
878 |
INSERT INTO element VALUES (70,18,0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0); |
879 |
INSERT INTO element VALUES (71,18,0,19,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,0); |
880 |
INSERT INTO element VALUES (72,18,0,18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,0); |
881 |
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); |
882 |
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); |
883 |
|
884 |
-- |
885 |
-- Table structure for table `feature` |
886 |
-- |
887 |
|
888 |
|
889 |
|
890 |
-- |
891 |
-- Sequences for table FEATURE |
892 |
-- |
893 |
|
894 |
CREATE SEQUENCE feature_feature_id_seq; |
895 |
|
896 |
CREATE TABLE feature ( |
897 |
feature_id INT4 DEFAULT nextval('feature_feature_id_seq'), |
898 |
feature varchar(50) DEFAULT NULL, |
899 |
image_path varchar(100) DEFAULT NULL, |
900 |
image_alt varchar(100) DEFAULT NULL, |
901 |
PRIMARY KEY (feature_id) |
902 |
|
903 |
); |
904 |
|
905 |
-- |
906 |
-- Dumping data for table `feature` |
907 |
-- |
908 |
|
909 |
INSERT INTO feature VALUES (1,'(N/A)',NULL,NULL); |
910 |
INSERT INTO feature VALUES (2,'CD-ROM','images/cd.gif','On CD-ROM Format'); |
911 |
INSERT INTO feature VALUES (3,'Full Text','images/fulltext.gif','Available in Full Text'); |
912 |
INSERT INTO feature VALUES (5,'Restricted','images/lock.gif','Authentication Required'); |
913 |
|
914 |
-- |
915 |
-- Table structure for table `libunit` |
916 |
-- |
917 |
|
918 |
|
919 |
|
920 |
-- |
921 |
-- Sequences for table LIBUNIT |
922 |
-- |
923 |
|
924 |
CREATE SEQUENCE libunit_libunit_id_seq; |
925 |
|
926 |
CREATE TABLE libunit ( |
927 |
libunit_id INT4 DEFAULT nextval('libunit_libunit_id_seq'), |
928 |
libunit varchar(100) DEFAULT NULL, |
929 |
libunit_abbrev varchar(25) DEFAULT NULL, |
930 |
head_staff_id INT4 references staff(staff_id) on delete cascade on update cascade, |
931 |
PRIMARY KEY (libunit_id) |
932 |
|
933 |
); |
934 |
|
935 |
-- |
936 |
-- Dumping data for table `libunit` |
937 |
-- |
938 |
|
939 |
INSERT INTO libunit VALUES (1,'(N/A)','(N/A)',NULL); |
940 |
|
941 |
-- |
942 |
-- Table structure for table `libunit_staff` |
943 |
-- |
944 |
|
945 |
CREATE TABLE libunit_staff ( |
946 |
libunit_id INT4 references libunit(libunit_id) on delete cascade on update cascade, |
947 |
staff_id INT4 references staff(staff_id) on delete cascade on update cascade, |
948 |
PRIMARY KEY (libunit_id,staff_id) |
949 |
|
950 |
); |
951 |
|
952 |
-- |
953 |
-- Dumping data for table `libunit_staff` |
954 |
-- |
955 |
|
956 |
-- |
957 |
-- Table structure for table `page_staff` |
958 |
-- |
959 |
|
960 |
CREATE TABLE page_staff ( |
961 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
highlighted char(1) DEFAULT NULL, |
1097 |
description text, |
1098 |
masterinfotype_id INT4 references masterinfotype(masterinfotype_id) on delete cascade on update cascade |
1099 |
); |
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 |
location_id INT4 references location(location_id) on delete cascade on update cascade, |
1126 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
subject_id INT4 references subject(subject_id) on delete cascade on update cascade, |
1210 |
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 |
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 |
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 |
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 |
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; |