trunk/pg/libdata.pgsql

------------------------------------------------------------------
-- My2Pg 1.28 translated dump
--
------------------------------------------------------------------

BEGIN;


--
-- Sequences for table ACCESS
--

CREATE SEQUENCE access_access_id_seq;

-- MySQL dump 9.10
--
-- Host: localhost    Database: libdata
-- ------------------------------------------------------
-- Server version       4.0.18-log

--
-- Table structure for table `access`
--

CREATE TABLE access (
  access_id INT4 DEFAULT nextval('access_access_id_seq'),
  access_level INT4 DEFAULT NULL,
  access varchar(25) DEFAULT NULL,
  PRIMARY KEY (access_id)

);

--
-- Dumping data for table `access`
--

INSERT INTO access VALUES (1,0,'Denied');
INSERT INTO access VALUES (2,10,'Guest');
INSERT INTO access VALUES (3,20,'Author');
INSERT INTO access VALUES (4,100,'Manager');
INSERT INTO access VALUES (5,1000,'DBA');

--
-- Table structure for table `campus`
--


--
-- Sequences for table CAMPUS
--

CREATE SEQUENCE campus_campus_id_seq;

CREATE TABLE campus (
  campus_id INT4 DEFAULT nextval('campus_campus_id_seq'),
  campus varchar(50) DEFAULT NULL,
  institution varchar(10) DEFAULT NULL,
  PRIMARY KEY (campus_id)

);

--
-- Dumping data for table `campus`
--

INSERT INTO campus VALUES (1,'(N/A)','(N/A)');

--
-- Table structure for table `coursesub`
--


--
-- Sequences for table COURSESUB
--

CREATE SEQUENCE coursesub_coursesub_id_seq;

CREATE TABLE coursesub (
  coursesub_id INT4 DEFAULT nextval('coursesub_coursesub_id_seq'),
  coursesub varchar(15) DEFAULT NULL,
  coursesub_descr varchar(100) DEFAULT NULL,
  cip_code varchar(50) DEFAULT NULL,
  campus_id INT4 references campus(campus_id) on delete cascade on update cascade,
  PRIMARY KEY (coursesub_id)

);

--
-- Dumping data for table `coursesub`
--

INSERT INTO coursesub VALUES (1,'(N/A)','(N/A)',NULL,NULL);
INSERT INTO coursesub VALUES (554,'ASTRO','Astronomy','',1);
INSERT INTO coursesub VALUES (553,'ANTH','Anthropology','',1);
INSERT INTO coursesub VALUES (555,'PSIHO','Uvod u psihologiju','',1);

--
-- Table structure for table `term`
--


--
-- Sequences for table TERM
--

CREATE SEQUENCE term_term_id_seq;

CREATE TABLE term (
  term_id INT4 DEFAULT nextval('term_term_id_seq'),
  term varchar(150) DEFAULT NULL,
  PRIMARY KEY (term_id)

);

--
-- Dumping data for table `term`
--

INSERT INTO term VALUES (1,'(N/A)');
INSERT INTO term VALUES (2,'Fall Semester');
INSERT INTO term VALUES (3,'Spring Semester');
INSERT INTO term VALUES (4,'Summer Term');

--
-- Table structure for table `style`
--


--
-- Sequences for table STYLE
--

CREATE SEQUENCE style_style_id_seq;

CREATE TABLE style (
  style_id INT4 DEFAULT nextval('style_style_id_seq'),
  style_title varchar(100) DEFAULT NULL,
  header_file varchar(255) DEFAULT NULL,
  footer_file varchar(255) DEFAULT NULL,
  css_file varchar(255) DEFAULT NULL,
  PRIMARY KEY (style_id)

);

--
-- Dumping data for table `style`
--

INSERT INTO style VALUES (1,'(N/A)',NULL,NULL,NULL);
INSERT INTO style VALUES (2,'LibData Standard','header.phtml','footer.phtml','libdata.css');
INSERT INTO style VALUES (10,'LibData Inverse Demo','styles/libinverse/header.phtml','styles/libinverse/footer.phtml','styles/libinverse/libdata.css');

--
-- Table structure for table `pagetype`
--


--
-- Sequences for table PAGETYPE
--

CREATE SEQUENCE pagetype_pagetype_id_seq;

CREATE TABLE pagetype (
  pagetype_id INT4 DEFAULT nextval('pagetype_pagetype_id_seq'),
  pagetype varchar(50) DEFAULT NULL,
  PRIMARY KEY (pagetype_id)

);

--
-- Dumping data for table `pagetype`
--

INSERT INTO pagetype VALUES (1,'(N/A)');
INSERT INTO pagetype VALUES (2,'Free Form');
INSERT INTO pagetype VALUES (3,'CourseLib');

--
-- Table structure for table `page`
--


--
-- Sequences for table PAGE
--

CREATE SEQUENCE page_page_id_seq;

CREATE TABLE page (
  page_id INT4 DEFAULT nextval('page_page_id_seq'),
  date_created TIMESTAMP DEFAULT NULL,
  date_modified TIMESTAMP DEFAULT NULL,
  account_created varchar(20) DEFAULT NULL,
  account_modified varchar(20) DEFAULT NULL,
  staff_coordinator INT4 DEFAULT NULL,
  style_id INT4 references style(style_id) on delete cascade on update cascade,
  pagetype_id INT4 references pagetype(pagetype_id) on delete cascade on update cascade,
  page_title varchar(255) DEFAULT NULL,
  pagetitle_style INT2 references style(style_id) on delete cascade on update cascade,
  published char(1) DEFAULT NULL,
  display_urls char(1) DEFAULT NULL,
  display_toc char(1) DEFAULT NULL,
  wrap_toc char(1) DEFAULT NULL,
  display_up char(1) DEFAULT NULL,
  up_text varchar(50) DEFAULT NULL,
  pageheader text,
  pageHTML text,
  page_debug char(1) DEFAULT NULL,
  PRIMARY KEY (page_id)

);

--
-- Dumping data for table `page`
--

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);
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);
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);
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);
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&#269;itih podru&#269;ja bibliotekarstva.',NULL,NULL);


--
-- Table structure for table `course`
--


--
-- Sequences for table COURSE
--

CREATE SEQUENCE course_course_id_seq;

CREATE TABLE course (
  course_id INT4 DEFAULT nextval('course_course_id_seq'),
  page_id INT4 references page(page_id) on delete cascade on update cascade,
  coursesub_id INT4 references coursesub(coursesub_id) on delete cascade on update cascade,
  course_num varchar(50) DEFAULT NULL,
  course_section varchar(10) DEFAULT NULL,
  course_concat varchar(255) DEFAULT NULL,
  term_id INT4 references term(term_id) on delete cascade on update cascade,
  course_year varchar(4) DEFAULT NULL,
  campus_id INT4 references campus(campus_id) on delete cascade on update cascade,
  courseheader varchar(255) DEFAULT NULL,
  introheader1 text,
  intromessage1 text,
  introheader2 text,
  intromessage2 text,
  PRIMARY KEY (course_id)

);

--
-- Dumping data for table `course`
--

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);

--
-- Table structure for table `stafftitle`
--


--
-- Sequences for table STAFFTITLE
--

CREATE SEQUENCE stafftitle_stafftitle_id_seq;

CREATE TABLE stafftitle (
  stafftitle_id INT4 DEFAULT nextval('stafftitle_stafftitle_id_seq'),
  stafftitle varchar(50) DEFAULT NULL,
  PRIMARY KEY (stafftitle_id)

);

--
-- Dumping data for table `stafftitle`
--

INSERT INTO stafftitle VALUES (1,'(N/A)');
INSERT INTO stafftitle VALUES (2,'Web Applications Developer');
INSERT INTO stafftitle VALUES (3,'Info Tech Prof');
INSERT INTO stafftitle VALUES (4,'Librarian');
INSERT INTO stafftitle VALUES (5,'Faculty');
INSERT INTO stafftitle VALUES (6,'Professor');
INSERT INTO stafftitle VALUES (7,'Assistant Professor');
INSERT INTO stafftitle VALUES (8,'Associate Professor');
INSERT INTO stafftitle VALUES (16,'Instructor');
INSERT INTO stafftitle VALUES (17,'TA');

--
-- Table structure for table `staff`
--


--
-- Sequences for table STAFF
--

CREATE SEQUENCE staff_staff_id_seq;

CREATE TABLE staff (
  staff_id INT4 DEFAULT nextval('staff_staff_id_seq'),
  staff_account varchar(20) DEFAULT NULL,
  staff_email varchar(50) DEFAULT NULL,
  password varchar(32) DEFAULT NULL,
  last_name varchar(75) DEFAULT NULL,
  first_name varchar(75) DEFAULT NULL,
  last_login TIMESTAMP DEFAULT NULL,
  last_ip varchar(15) DEFAULT NULL,
  date_created TIMESTAMP DEFAULT NULL,
  date_modified TIMESTAMP DEFAULT NULL,
  access_id INT4 references access(access_id) on delete cascade on update cascade,
  stafftitle_id INT4 references stafftitle(stafftitle_id) on delete cascade on update cascade,
  PRIMARY KEY (staff_id)

);

--
-- Dumping data for table `staff`
--

INSERT INTO staff VALUES (1,'(N/A)','(N/A)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL);
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);
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);
INSERT INTO staff VALUES (4,'dpavlin','dpavlin@mjesec.ffzg.hr','0778c26e0ed1e1ad','Pavlinui&#263;','Dobrica',NULL,NULL,NULL,NULL,5,2);

--
-- Table structure for table `faculty`
--


--
-- Sequences for table FACULTY
--

CREATE SEQUENCE faculty_faculty_id_seq;

CREATE TABLE faculty (
  faculty_id INT4 DEFAULT nextval('faculty_faculty_id_seq'),
  faculty_lastname varchar(75) DEFAULT NULL,
  faculty_firstname varchar(75) DEFAULT NULL,
  faculty_email varchar(50) DEFAULT NULL,
  faculty_account varchar(20) DEFAULT NULL,
  PRIMARY KEY (faculty_id)

);

--
-- Dumping data for table `faculty`
--

INSERT INTO faculty VALUES (1,NULL,NULL,NULL,'(N/A)');
INSERT INTO faculty VALUES (123,'Smith','Joe','joe001@yourlibrary.edu','joe001');


--
-- Table structure for table `course_personnel`
--


--
-- Sequences for table COURSE_PERSONNEL
--

CREATE SEQUENCE course_personnel_personnel_i;

CREATE TABLE course_personnel (
  personnel_id INT4 DEFAULT nextval('course_personnel_personnel_i'),
  course_id INT4 references course(course_id) on delete cascade on update cascade,
  stafftitle_id INT4 references stafftitle(stafftitle_id) on delete cascade on update cascade,
  staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
  faculty_id INT4 references faculty(faculty_id) on delete cascade on update cascade,
  pers_email varchar(40) DEFAULT NULL,
  pers_account varchar(20) DEFAULT NULL,
  pers_lastname varchar(50) DEFAULT NULL,
  pers_firstname varchar(20) DEFAULT NULL,
  PRIMARY KEY (personnel_id)

);

--
-- Dumping data for table `course_personnel`
--

INSERT INTO course_personnel VALUES (4,8,7,2,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `service`
--


--
-- Sequences for table SERVICE
--

CREATE SEQUENCE service_service_id_seq;

CREATE TABLE service (
  service_id INT4 DEFAULT nextval('service_service_id_seq'),
  service varchar(100) DEFAULT NULL,
  serviceURL varchar(150) DEFAULT NULL,
  serviceDescr text,
  address1 varchar(50) DEFAULT NULL,
  address2 varchar(50) DEFAULT NULL,
  address3 varchar(50) DEFAULT NULL,
  address4 varchar(50) DEFAULT NULL,
  telephone varchar(20) DEFAULT NULL,
  fax varchar(20) DEFAULT NULL,
  email varchar(40) DEFAULT NULL,
  nonaff char(1) DEFAULT NULL,
  PRIMARY KEY (service_id)

);

--
-- Dumping data for table `service`
--

INSERT INTO service VALUES (1,'(N/A)','','','','','','','','','','0');

--
-- Table structure for table `servicetype`
--


--
-- Sequences for table SERVICETYPE
--

CREATE SEQUENCE servicetype_servicetype_id_s;

CREATE TABLE servicetype (
  servicetype_id INT4 DEFAULT nextval('servicetype_servicetype_id_s'),
  servicetype varchar(75) DEFAULT NULL,
  PRIMARY KEY (servicetype_id)

);

--
-- Dumping data for table `servicetype`
--


--
-- Table structure for table `location`
--


--
-- Sequences for table LOCATION
--

CREATE SEQUENCE location_location_id_seq;

CREATE TABLE location (
  location_id INT4 DEFAULT nextval('location_location_id_seq'),
  location varchar(255) DEFAULT NULL,
  location_descr text,
  campus varchar(255) DEFAULT NULL,
  address1 varchar(255) DEFAULT NULL,
  address2 varchar(255) DEFAULT NULL,
  address3 varchar(255) DEFAULT NULL,
  address4 varchar(255) DEFAULT NULL,
  telephone varchar(100) DEFAULT NULL,
  mainURL varchar(255) DEFAULT NULL,
  referenceURL varchar(255) DEFAULT NULL,
  mapURL varchar(255) DEFAULT NULL,
  hoursURL varchar(255) DEFAULT NULL,
  PRIMARY KEY (location_id)

);

--
-- Dumping data for table `location`
--

INSERT INTO location VALUES (1,'(N/A)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO location VALUES (55,'Virtual Web Library','Resources here are all freely available on the internet.','','','','','','','','','','');
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','','','');

INSERT INTO servicetype VALUES (1,'(N/A)');

--
-- Table structure for table `subject`
--


--
-- Sequences for table SUBJECT
--

CREATE SEQUENCE subject_subject_id_seq;

CREATE TABLE subject (
  subject_id INT4 DEFAULT nextval('subject_subject_id_seq'),
  subject varchar(75) NOT NULL DEFAULT '',
  subject_descr text,
  sublocation_id INT4 references location(location_id) on delete cascade on update cascade,
  rqs_date_created TIMESTAMP DEFAULT NULL,
  rqs_date_modified TIMESTAMP DEFAULT NULL,
  rqs_account_created varchar(20) DEFAULT NULL,
  rqs_account_modified varchar(20) DEFAULT NULL,
  rqs_published char(1) DEFAULT NULL,
  PRIMARY KEY (subject_id)

);

--
-- Dumping data for table `subject`
--

INSERT INTO subject VALUES (1,'(N/A)',NULL,NULL,'2003-08-27 10:07:20','2003-08-27 10:07:50','staff','staff','1');
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');
INSERT INTO subject VALUES (3,'xxx3','',1,'2004-02-17 00:24:53','2004-03-03 20:54:57','admin','admin','1');
INSERT INTO subject VALUES (4,'xxx4','',1,'2004-02-17 00:24:53','2004-03-03 20:54:57','admin','admin','1');
INSERT INTO subject VALUES (5,'xxx5','',1,'2004-02-17 00:24:53','2004-03-03 20:54:57','admin','admin','1');
INSERT INTO subject VALUES (6,'Psihologija','',1,'2004-02-17 00:24:53','2004-03-03 20:54:57','admin','admin','1');
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');
INSERT INTO subject VALUES (8,'xxx8','',1,'2004-02-17 00:24:53','2004-03-03 20:54:57','admin','admin','1');

--
-- Table structure for table `mastersubject`
--


--
-- Sequences for table MASTERSUBJECT
--

CREATE SEQUENCE mastersubject_mastersubject_;

CREATE TABLE mastersubject (
  mastersubject_id INT4 DEFAULT nextval('mastersubject_mastersubject_'),
  mastersubject varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (mastersubject_id)

);

--
-- Dumping data for table `mastersubject`
--

INSERT INTO mastersubject VALUES (1,'(N/A)');
INSERT INTO mastersubject VALUES (2,'(All)');
INSERT INTO mastersubject VALUES (3,'Agriculture, Biology, Ecology');
INSERT INTO mastersubject VALUES (4,'Humanistika');
INSERT INTO mastersubject VALUES (5,'Business and Economics');
INSERT INTO mastersubject VALUES (6,'Prirodoslovlje');
INSERT INTO mastersubject VALUES (7,'Health and Medicine');
INSERT INTO mastersubject VALUES (8,'Law');
INSERT INTO mastersubject VALUES (9,'Dru¹tvene znanosti');
INSERT INTO mastersubject VALUES (10,'General');
INSERT INTO mastersubject VALUES (11,'Biomedicina');
INSERT INTO mastersubject VALUES (12,'Tehnika');

--
-- Table structure for table `infotype`
--


--
-- Sequences for table INFOTYPE
--

CREATE SEQUENCE infotype_infotype_id_seq;

CREATE TABLE infotype (
  infotype_id INT4 DEFAULT nextval('infotype_infotype_id_seq'),
  masterinfotype_id INT4 references infotype(infotype_id) on delete cascade on update cascade,
  mastersubject_id INT4 references mastersubject(mastersubject_id) on delete cascade on update cascade,
  infotype varchar(75) NOT NULL DEFAULT '',
  PRIMARY KEY (infotype_id)

);

--
-- Dumping data for table `infotype`
--

INSERT INTO infotype VALUES (1,1,1,'(N/A)');
INSERT INTO infotype VALUES (2,2,2,'Almanacs');
INSERT INTO infotype VALUES (3,2,2,'Encyclopedias');
INSERT INTO infotype VALUES (4,2,2,'Field Guides');
INSERT INTO infotype VALUES (5,2,2,'Dictionaries');
INSERT INTO infotype VALUES (6,2,2,'Handbooks and Manuals');
INSERT INTO infotype VALUES (7,2,2,'Biographical Sources');
INSERT INTO infotype VALUES (8,2,2,'Directories');
INSERT INTO infotype VALUES (9,2,2,'Glossaries');
INSERT INTO infotype VALUES (10,2,2,'Reports');
INSERT INTO infotype VALUES (11,2,2,'Public Opinion Resources');
INSERT INTO infotype VALUES (12,2,2,'Yearbooks');
INSERT INTO infotype VALUES (13,2,2,'Speeches');
INSERT INTO infotype VALUES (14,2,4,'Atlases & Maps');
INSERT INTO infotype VALUES (15,2,2,'Chronologies');
INSERT INTO infotype VALUES (16,2,2,'Forms, Tests, Inventories');
INSERT INTO infotype VALUES (17,2,2,'General Reference Works');
INSERT INTO infotype VALUES (18,3,2,'Academic or Scholarly Articles Subject Indexes');
INSERT INTO infotype VALUES (19,3,2,'General Indexes to Magazine, Journal & Newspaper Articles');
INSERT INTO infotype VALUES (20,3,2,'Catalogs & Indexes to Government Publications');
INSERT INTO infotype VALUES (21,3,2,'Indexes, Other');
INSERT INTO infotype VALUES (22,4,2,'Bibliographies');
INSERT INTO infotype VALUES (23,4,2,'National Bibliographies');
INSERT INTO infotype VALUES (24,4,2,'Catalogs');
INSERT INTO infotype VALUES (25,5,2,'Reports');
INSERT INTO infotype VALUES (26,5,2,'Diaries');
INSERT INTO infotype VALUES (27,5,2,'Correspondence');
INSERT INTO infotype VALUES (28,5,2,'Speeches');
INSERT INTO infotype VALUES (29,6,2,'News Sources');
INSERT INTO infotype VALUES (30,6,2,'Journal Titles');
INSERT INTO infotype VALUES (31,6,2,'Magazine Titles');
INSERT INTO infotype VALUES (32,7,2,'Data Resources');
INSERT INTO infotype VALUES (33,7,2,'Statistical Guides');
INSERT INTO infotype VALUES (34,7,2,'Statistical Resources');
INSERT INTO infotype VALUES (35,8,2,'Atlases and Maps');
INSERT INTO infotype VALUES (37,9,2,'Trade & Professional Associations');
INSERT INTO infotype VALUES (38,10,2,'Guides to Working with Government Publications');
INSERT INTO infotype VALUES (39,10,2,'Research Guides');
INSERT INTO infotype VALUES (40,11,2,'Gateways & Megasites');
INSERT INTO infotype VALUES (41,11,2,'Search Engines');
INSERT INTO infotype VALUES (42,12,2,'Related U of M Web Sites');
INSERT INTO infotype VALUES (43,2,5,'Security Analysts\' Reports');
INSERT INTO infotype VALUES (44,2,5,'Doing Business in Another Country');
INSERT INTO infotype VALUES (45,2,5,'Financial Ratios');
INSERT INTO infotype VALUES (46,2,5,'Industry Profiles');
INSERT INTO infotype VALUES (47,2,5,'Market Research Surveys');
INSERT INTO infotype VALUES (48,2,5,'Tax Reporters');
INSERT INTO infotype VALUES (49,2,5,'Financial Reports');
INSERT INTO infotype VALUES (50,2,5,'Accounting Standards');
INSERT INTO infotype VALUES (51,2,5,'Nonprofit Finance');
INSERT INTO infotype VALUES (52,2,5,'Nonprofit Management');
INSERT INTO infotype VALUES (53,2,5,'Nonprofit Marketing');
INSERT INTO infotype VALUES (54,2,5,'Leadership History');
INSERT INTO infotype VALUES (55,2,5,'Leadership Landscapes, strategies and structures');
INSERT INTO infotype VALUES (56,2,5,'Books by and about Leaders');
INSERT INTO infotype VALUES (57,2,6,'Spectra');
INSERT INTO infotype VALUES (58,2,6,'Spectra, Atomic');
INSERT INTO infotype VALUES (59,2,6,'Spectra, General');
INSERT INTO infotype VALUES (60,2,6,'Spectra, Infrared');
INSERT INTO infotype VALUES (61,2,6,'Spectra, Mass');
INSERT INTO infotype VALUES (62,2,6,'Spectra, Nuclear Magnetic Resonance');
INSERT INTO infotype VALUES (63,2,6,'Spectra, Raman');
INSERT INTO infotype VALUES (64,2,6,'Spectra, Ultraviolet & Visible');
INSERT INTO infotype VALUES (65,2,6,'Chemical Compounds');
INSERT INTO infotype VALUES (66,2,6,'Data Compilations/Algorithms');
INSERT INTO infotype VALUES (67,2,6,'Organic Reactions');
INSERT INTO infotype VALUES (68,2,6,'Organic Synthesis');
INSERT INTO infotype VALUES (69,2,6,'Physical Property Data');
INSERT INTO infotype VALUES (70,2,8,'Federal Law - Administrative Law');
INSERT INTO infotype VALUES (71,2,8,'Minnesota Law - Constitution, Statutes and Codes');
INSERT INTO infotype VALUES (72,2,8,'Courts');
INSERT INTO infotype VALUES (73,2,8,'Attorneys and Law Firms');
INSERT INTO infotype VALUES (74,2,8,'Minnesota Law - Administrative Law');
INSERT INTO infotype VALUES (75,2,8,'Minnesota Law - Case Law');
INSERT INTO infotype VALUES (76,2,8,'Law Schools');
INSERT INTO infotype VALUES (77,2,8,'Federal Law - Case Law - U.S. Supreme Court');
INSERT INTO infotype VALUES (78,2,8,'Federal Law - Case Law - U.S. Court of Appeals');
INSERT INTO infotype VALUES (79,2,8,'Federal Law - Case Law - U.S. District Courts');
INSERT INTO infotype VALUES (80,2,8,'Laws and Legislation');
INSERT INTO infotype VALUES (81,2,8,'Official Journal of Legislative Activity');
INSERT INTO infotype VALUES (82,2,8,'Unofficial Journal of Legislative Activity');
INSERT INTO infotype VALUES (83,2,8,'Legislative Debates');
INSERT INTO infotype VALUES (84,2,8,'Federal Law - Constitution, Statutes and Codes');
INSERT INTO infotype VALUES (85,2,2,'Country Studies');
INSERT INTO infotype VALUES (130,11,2,'Electronic Texts');
INSERT INTO infotype VALUES (87,11,2,'Official Agency and Organization Web Sites');
INSERT INTO infotype VALUES (88,11,2,'Internet Directory');
INSERT INTO infotype VALUES (105,1,6,'Astronomical Objects');
INSERT INTO infotype VALUES (124,10,2,'Writing Guides');
INSERT INTO infotype VALUES (125,2,6,'Safety Information');
INSERT INTO infotype VALUES (126,6,2,'Electronic Journal Collections');
INSERT INTO infotype VALUES (127,8,2,'Image Resources');
INSERT INTO infotype VALUES (128,2,2,'Conferences and Proceedings');
INSERT INTO infotype VALUES (129,10,2,'Style Manuals');
INSERT INTO infotype VALUES (131,2,2,'Standards');
INSERT INTO infotype VALUES (132,2,6,'Analytical Techniques');
INSERT INTO infotype VALUES (133,2,6,'Chemical Prices');
INSERT INTO infotype VALUES (134,2,2,'Treatises');
INSERT INTO infotype VALUES (135,2,2,'Rankings');
INSERT INTO infotype VALUES (136,2,2,'Technical Reports');
INSERT INTO infotype VALUES (137,5,2,'Historical Documents');
INSERT INTO infotype VALUES (138,13,2,'Web Sites');
INSERT INTO infotype VALUES (139,5,2,'Government Documents');
INSERT INTO infotype VALUES (140,5,2,'Archival Materials');
INSERT INTO infotype VALUES (143,2,2,'Dissertations and Theses');
INSERT INTO infotype VALUES (142,2,2,'Guides');
INSERT INTO infotype VALUES (147,13,2,'Library Web Sites');
INSERT INTO infotype VALUES (148,13,2,'Campus web site');
INSERT INTO infotype VALUES (149,6,2,'Electronic Journal Titles');

--
-- Table structure for table `resource`
--


--
-- Sequences for table RESOURCE
--

CREATE SEQUENCE resource_resource_id_seq;

CREATE TABLE resource (
  resource_id INT4 DEFAULT nextval('resource_resource_id_seq'),
  date_created TIMESTAMP DEFAULT NULL,
  date_modified TIMESTAMP DEFAULT NULL,
  account_created varchar(20) DEFAULT NULL,
  account_modified varchar(20) DEFAULT NULL,
  title varchar(255) DEFAULT NULL,
  other_title text,
  author varchar(125) DEFAULT NULL,
  publisher varchar(255) DEFAULT NULL,
  pub_date varchar(255) DEFAULT NULL,
  edition varchar(25) DEFAULT NULL,
  cat_num varchar(50) DEFAULT NULL,
  call_no text,
  coverage_detail varchar(255) DEFAULT NULL,
  sources_indexed varchar(100) DEFAULT NULL,
  url text,
  visited varchar(25) DEFAULT NULL,
  annotation text,
  location_id INT4 references location(location_id) on delete cascade on update cascade,
  infotype_id INT4 references infotype(infotype_id) on delete cascade on update cascade,
  vendor_id INT4 DEFAULT NULL,                                          -- XXX unused
  PRIMARY KEY (resource_id)

);

--
-- Dumping data for table `resource`
--

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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);

--
-- Table structure for table `element`
--


--
-- Sequences for table ELEMENT
--

CREATE SEQUENCE element_element_id_seq;

CREATE TABLE element (
  element_id INT4 DEFAULT nextval('element_element_id_seq'),
  page_id INT4 references page(page_id) on delete cascade on update cascade,
  parent_id INT4,                       --- XXX references element(element_id) on delete cascade on update cascade,
  resource_id INT4 references resource(resource_id) on delete cascade on update cascade,
  location_id INT4 references location(location_id) on delete cascade on update cascade,
  service_id INT4 references service(service_id) on delete cascade on update cascade,
  staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
  subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
  label varchar(200) DEFAULT NULL,
  label_url varchar(200) DEFAULT NULL,
  element_descr text,
  element_size INT2 DEFAULT NULL,
  element_order INT2 DEFAULT NULL,
  indent_level INT2 DEFAULT NULL,
  PRIMARY KEY (element_id)

);

--
-- Dumping data for table `element`
--

INSERT INTO element VALUES (21,4,15,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,9,1);
INSERT INTO element VALUES (22,4,15,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,10,1);
INSERT INTO element VALUES (20,4,15,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7,1);
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);
INSERT INTO element VALUES (23,4,15,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,11,1);
INSERT INTO element VALUES (25,4,15,11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,12,1);
INSERT INTO element VALUES (28,15,0,NULL,NULL,NULL,NULL,NULL,'Library Resources','','',1,8,0);
INSERT INTO element VALUES (29,15,28,NULL,58,NULL,NULL,NULL,NULL,NULL,'\r\n',NULL,9,1);
INSERT INTO element VALUES (30,15,28,NULL,55,NULL,NULL,NULL,NULL,NULL,NULL,5,10,1);
INSERT INTO element VALUES (31,15,0,NULL,NULL,NULL,NULL,NULL,'Astrobiology','','',1,1,0);
INSERT INTO element VALUES (32,15,31,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,1);
INSERT INTO element VALUES (33,15,31,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,1);
INSERT INTO element VALUES (34,15,31,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,1);
INSERT INTO element VALUES (35,15,31,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,1);
INSERT INTO element VALUES (36,15,31,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,1);
INSERT INTO element VALUES (37,15,31,11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7,1);
INSERT INTO element VALUES (49,4,0,2,NULL,NULL,NULL,NULL,'','','',0,5,0);
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);
INSERT INTO element VALUES (51,4,20,NULL,NULL,NULL,NULL,NULL,'to je tekst','http://bla..','neki tekst',NULL,8,2);
INSERT INTO element VALUES (52,4,0,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4,0);
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);
INSERT INTO element VALUES (54,4,0,16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0);
INSERT INTO element VALUES (55,4,0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0);
INSERT INTO element VALUES (56,4,0,NULL,NULL,NULL,NULL,6,NULL,NULL,NULL,0,1,0);
INSERT INTO element VALUES (58,18,57,13,NULL,NULL,NULL,NULL,'','','',NULL,10,1);
INSERT INTO element VALUES (59,18,57,14,NULL,NULL,NULL,NULL,'','','',NULL,12,1);
INSERT INTO element VALUES (60,18,57,4,NULL,NULL,NULL,NULL,'','','',NULL,13,1);
INSERT INTO element VALUES (61,18,57,3,NULL,NULL,NULL,NULL,'','','',NULL,14,1);
INSERT INTO element VALUES (62,18,57,11,NULL,NULL,NULL,NULL,'','','',NULL,15,1);
INSERT INTO element VALUES (63,18,0,2,NULL,NULL,NULL,NULL,'','','',NULL,8,0);
INSERT INTO element VALUES (64,18,58,NULL,NULL,NULL,NULL,NULL,'to je tekst','http://bla..','neki tekst',NULL,11,2);
INSERT INTO element VALUES (65,18,0,20,NULL,NULL,NULL,NULL,'','','',NULL,7,0);
INSERT INTO element VALUES (66,18,0,16,NULL,NULL,NULL,NULL,'','','',NULL,5,0);
INSERT INTO element VALUES (67,18,0,1,NULL,NULL,NULL,NULL,'','','',NULL,6,0);
INSERT INTO element VALUES (68,18,0,NULL,NULL,NULL,NULL,6,'','','',NULL,4,0);
INSERT INTO element VALUES (70,18,0,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0);
INSERT INTO element VALUES (71,18,0,19,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,0);
INSERT INTO element VALUES (72,18,0,18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,0);
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&#269;no knjini&#269;arima instaliran je probno na adresi http://libdata.knjiznice.ffzg.hr/',0,1,0);
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&#263;inom se radilo na organizaciji sadraja, jer &#263;e sam design biti povjeren dizajerima.',0,2,0);

--
-- Table structure for table `feature`
--


--
-- Sequences for table FEATURE
--

CREATE SEQUENCE feature_feature_id_seq;

CREATE TABLE feature (
  feature_id INT4 DEFAULT nextval('feature_feature_id_seq'),
  feature varchar(50) DEFAULT NULL,
  image_path varchar(100) DEFAULT NULL,
  image_alt varchar(100) DEFAULT NULL,
  PRIMARY KEY (feature_id)

);

--
-- Dumping data for table `feature`
--

INSERT INTO feature VALUES (1,'(N/A)',NULL,NULL);
INSERT INTO feature VALUES (2,'CD-ROM','images/cd.gif','On CD-ROM Format');
INSERT INTO feature VALUES (3,'Full Text','images/fulltext.gif','Available in Full Text');
INSERT INTO feature VALUES (5,'Restricted','images/lock.gif','Authentication Required');

--
-- Table structure for table `libunit`
--


--
-- Sequences for table LIBUNIT
--

CREATE SEQUENCE libunit_libunit_id_seq;

CREATE TABLE libunit (
  libunit_id INT4 DEFAULT nextval('libunit_libunit_id_seq'),
  libunit varchar(100) DEFAULT NULL,
  libunit_abbrev varchar(25) DEFAULT NULL,
  head_staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
  PRIMARY KEY (libunit_id)

);

--
-- Dumping data for table `libunit`
--

INSERT INTO libunit VALUES (1,'(N/A)','(N/A)',NULL);

--
-- Table structure for table `libunit_staff`
--

CREATE TABLE libunit_staff (
  libunit_id INT4 references libunit(libunit_id) on delete cascade on update cascade,
  staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
  PRIMARY KEY (libunit_id,staff_id)

);

--
-- Dumping data for table `libunit_staff`
--

--
-- Table structure for table `masterinfotype`
--


--
-- Sequences for table MASTERINFOTYPE
--

CREATE SEQUENCE masterinfotype_masterinfotyp;

CREATE TABLE masterinfotype (
  masterinfotype_id INT4 DEFAULT nextval('masterinfotype_masterinfotyp'),
  masterinfotype varchar(75) NOT NULL DEFAULT '',
  PRIMARY KEY (masterinfotype_id)

);

--
-- Dumping data for table `masterinfotype`
--

INSERT INTO masterinfotype VALUES (1,'(N/A)');
INSERT INTO masterinfotype VALUES (2,'General Reference Sources');
INSERT INTO masterinfotype VALUES (3,'Abstracts and Indexes');
INSERT INTO masterinfotype VALUES (4,'Catalogs and Bibliographies');
INSERT INTO masterinfotype VALUES (5,'Primary Source Materials');
INSERT INTO masterinfotype VALUES (6,'Periodical and Newspaper subscriptions');
INSERT INTO masterinfotype VALUES (7,'Statistics and Data');
INSERT INTO masterinfotype VALUES (8,'Images Collections');
INSERT INTO masterinfotype VALUES (9,'Societies, Agencies, and Organizations');
INSERT INTO masterinfotype VALUES (10,'Style Manuals and Writing Guides');
INSERT INTO masterinfotype VALUES (11,'Internet Resources');
INSERT INTO masterinfotype VALUES (12,'University of Minnesota');
INSERT INTO masterinfotype VALUES (13,'WWW Resources');

--
-- Table structure for table `page_staff`
--

CREATE TABLE page_staff (
  page_id INT4 references page(page_id) on delete cascade on update cascade,
  staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
  PRIMARY KEY (page_id,staff_id)

);

--
-- Dumping data for table `page_staff`
--

INSERT INTO page_staff VALUES (19,4);

--
-- Table structure for table `pastebuffer`
--


--
-- Sequences for table PASTEBUFFER
--

CREATE SEQUENCE pastebuffer_pastebuffer_id_s;

CREATE TABLE pastebuffer (
  pastebuffer_id INT4 DEFAULT nextval('pastebuffer_pastebuffer_id_s'),
  paste_staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
  parent_id INT4 DEFAULT NULL,                                          -- XXX references what? on delete cascade on update cascade
  resource_id INT4 references resource(resource_id) on delete cascade on update cascade,
  location_id INT4 references location(location_id) on delete cascade on update cascade,
  service_id INT4 references service(service_id) on delete cascade on update cascade,
  staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
  subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
  label varchar(200) DEFAULT NULL,
  label_url varchar(200) DEFAULT NULL,
  element_descr text,
  element_size INT2 DEFAULT NULL,
  element_order INT2 DEFAULT NULL,
  indent_level INT2 DEFAULT NULL,
  PRIMARY KEY (pastebuffer_id)

);

--
-- Dumping data for table `pastebuffer`
--


--
-- Table structure for table `res_feature`
--

CREATE TABLE res_feature (
  resource_id INT4 references resource(resource_id) on delete cascade on update cascade,
  feature_id INT4 references feature(feature_id) on delete cascade on update cascade,
  PRIMARY KEY (resource_id,feature_id)

);

--
-- Dumping data for table `res_feature`
--

INSERT INTO res_feature VALUES (11,3);
INSERT INTO res_feature VALUES (14,2);
INSERT INTO res_feature VALUES (14,5);
INSERT INTO res_feature VALUES (15,3);
INSERT INTO res_feature VALUES (16,3);
INSERT INTO res_feature VALUES (19,3);
INSERT INTO res_feature VALUES (19,5);
INSERT INTO res_feature VALUES (20,5);

--
-- Table structure for table `res_loc`
--

CREATE TABLE res_loc (
  resource_id INT4 references resource(resource_id) on delete cascade on update cascade,
  location_id INT4 references location(location_id) on delete cascade on update cascade,
  PRIMARY KEY (resource_id,location_id)

);

--
-- Dumping data for table `res_loc`
--

INSERT INTO res_loc VALUES (2,55);
INSERT INTO res_loc VALUES (3,55);
INSERT INTO res_loc VALUES (11,55);
INSERT INTO res_loc VALUES (12,55);
INSERT INTO res_loc VALUES (13,55);
INSERT INTO res_loc VALUES (15,55);
INSERT INTO res_loc VALUES (16,55);
INSERT INTO res_loc VALUES (18,55);
INSERT INTO res_loc VALUES (19,55);

--
-- Table structure for table `res_mastersubject`
--

CREATE TABLE res_mastersubject (
  resource_id INT4 references resource(resource_id) on delete cascade on update cascade,
  mastersubject_id INT4 references mastersubject(mastersubject_id) on delete cascade on update cascade,
  PRIMARY KEY (resource_id,mastersubject_id)

);

--
-- Dumping data for table `res_mastersubject`
--

INSERT INTO res_mastersubject VALUES (1,10);
INSERT INTO res_mastersubject VALUES (2,6);
INSERT INTO res_mastersubject VALUES (3,6);
INSERT INTO res_mastersubject VALUES (4,6);
INSERT INTO res_mastersubject VALUES (11,6);
INSERT INTO res_mastersubject VALUES (12,6);
INSERT INTO res_mastersubject VALUES (13,6);
INSERT INTO res_mastersubject VALUES (14,6);
INSERT INTO res_mastersubject VALUES (15,9);
INSERT INTO res_mastersubject VALUES (16,9);
INSERT INTO res_mastersubject VALUES (17,4);
INSERT INTO res_mastersubject VALUES (18,12);
INSERT INTO res_mastersubject VALUES (19,10);
INSERT INTO res_mastersubject VALUES (20,10);

--
-- Table structure for table `res_sub_infotype`
--

CREATE TABLE res_sub_infotype (
  resource_id INT4 references resource(resource_id) on delete cascade on update cascade,
  subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
  infotype_id INT4 references infotype(infotype_id) on delete cascade on update cascade,
  highlighted char(1) DEFAULT NULL,
  description text,
  masterinfotype_id INT4 references masterinfotype(masterinfotype_id) on delete cascade on update cascade
);

--
-- Dumping data for table `res_sub_infotype`
--

INSERT INTO res_sub_infotype VALUES (2,2,138,'1','',13);
INSERT INTO res_sub_infotype VALUES (4,2,138,'0',NULL,13);
INSERT INTO res_sub_infotype VALUES (3,2,87,'0','',11);
INSERT INTO res_sub_infotype VALUES (11,2,138,'0',NULL,13);
INSERT INTO res_sub_infotype VALUES (13,2,87,'0',NULL,11);
INSERT INTO res_sub_infotype VALUES (14,2,40,'0','',11);
INSERT INTO res_sub_infotype VALUES (16,6,130,'1','klasici u psihologiji',11);
INSERT INTO res_sub_infotype VALUES (1,6,41,'0',NULL,11);
INSERT INTO res_sub_infotype VALUES (18,7,24,'0',NULL,4);
INSERT INTO res_sub_infotype VALUES (1,7,41,'0',NULL,11);
INSERT INTO res_sub_infotype VALUES (19,7,126,'0',NULL,6);
INSERT INTO res_sub_infotype VALUES (1,2,18,'0',NULL,3);
INSERT INTO res_sub_infotype VALUES (20,6,18,'0',NULL,3);

--
-- Table structure for table `serv_loc`
--

CREATE TABLE serv_loc (
  service_id INT4 NOT NULL DEFAULT '0',
  location_id INT4 references location(location_id) on delete cascade on update cascade,
  allloc char(1) DEFAULT NULL,
  PRIMARY KEY (service_id,location_id)

);

--
-- Dumping data for table `serv_loc`
--


--
-- Table structure for table `serv_servtype`
--

CREATE TABLE serv_servtype (
  service_id INT4 references service(service_id) on delete cascade on update cascade,
  servicetype_id INT4 references servicetype(servicetype_id) on delete cascade on update cascade,
  PRIMARY KEY (service_id,servicetype_id)

);

--
-- Dumping data for table `serv_servtype`
--


--
-- Table structure for table `sub_coursesub`
--

CREATE TABLE sub_coursesub (
  subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
  coursesub_id INT4 references coursesub(coursesub_id) on delete cascade on update cascade,
  PRIMARY KEY (subject_id,coursesub_id)

);

--
-- Dumping data for table `sub_coursesub`
--

INSERT INTO sub_coursesub VALUES (6,555);

--
-- Table structure for table `sub_loc`
--

CREATE TABLE sub_loc (
  subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
  location_id INT4 references location(location_id) on delete cascade on update cascade,
  PRIMARY KEY (subject_id,location_id)

);

--
-- Dumping data for table `sub_loc`
--

INSERT INTO sub_loc VALUES (2,55);

--
-- Table structure for table `sub_mastersubject`
--

CREATE TABLE sub_mastersubject (
  subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
  mastersubject_id INT4 references mastersubject(mastersubject_id) on delete cascade on update cascade,
  PRIMARY KEY (subject_id,mastersubject_id)

);

--
-- Dumping data for table `sub_mastersubject`
--

INSERT INTO sub_mastersubject VALUES (2,6);
INSERT INTO sub_mastersubject VALUES (6,9);

--
-- Table structure for table `sub_othersub`
--

CREATE TABLE sub_othersub (
  subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
  othersub_id INT4 NOT NULL DEFAULT '0',                -- XXX subject or mastersubject?
  PRIMARY KEY (subject_id,othersub_id)

);

--
-- Dumping data for table `sub_othersub`
--


--
-- Table structure for table `sub_page`
--

CREATE TABLE sub_page (
  subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
  page_id INT4 references page(page_id) on delete cascade on update cascade,
  PRIMARY KEY (subject_id,page_id)

);

--
-- Dumping data for table `sub_page`
--


--
-- Table structure for table `sub_staff`
--

CREATE TABLE sub_staff (
  subject_id INT4 references subject(subject_id) on delete cascade on update cascade,
  staff_id INT4 references staff(staff_id) on delete cascade on update cascade,
  PRIMARY KEY (subject_id,staff_id)

);

--
-- Dumping data for table `sub_staff`
--

INSERT INTO sub_staff VALUES (2,2);
INSERT INTO sub_staff VALUES (6,2);
INSERT INTO sub_staff VALUES (6,3);
INSERT INTO sub_staff VALUES (7,2);


--
-- Sequences for table PAGE
--

SELECT SETVAL('page_page_id_seq',(select case when max(page_id)>0 then max(page_id)+1 else 1 end from page));

--
-- Sequences for table INFOTYPE
--

SELECT SETVAL('infotype_infotype_id_seq',(select case when max(infotype_id)>0 then max(infotype_id)+1 else 1 end from infotype));

--
-- Sequences for table TERM
--

SELECT SETVAL('term_term_id_seq',(select case when max(term_id)>0 then max(term_id)+1 else 1 end from term));

--
-- Sequences for table FEATURE
--

SELECT SETVAL('feature_feature_id_seq',(select case when max(feature_id)>0 then max(feature_id)+1 else 1 end from feature));

--
-- Sequences for table STAFFTITLE
--

SELECT SETVAL('stafftitle_stafftitle_id_seq',(select case when max(stafftitle_id)>0 then max(stafftitle_id)+1 else 1 end from stafftitle));

--
-- Sequences for table LIBUNIT
--

SELECT SETVAL('libunit_libunit_id_seq',(select case when max(libunit_id)>0 then max(libunit_id)+1 else 1 end from libunit));

--
-- Sequences for table MASTERINFOTYPE
--

SELECT SETVAL('masterinfotype_masterinfotyp',(select case when max(masterinfotype_id)>0 then max(masterinfotype_id)+1 else 1 end from masterinfotype));

--
-- Sequences for table SERVICETYPE
--

SELECT SETVAL('servicetype_servicetype_id_s',(select case when max(servicetype_id)>0 then max(servicetype_id)+1 else 1 end from servicetype));

--
-- Sequences for table MASTERSUBJECT
--

SELECT SETVAL('mastersubject_mastersubject_',(select case when max(mastersubject_id)>0 then max(mastersubject_id)+1 else 1 end from mastersubject));

--
-- Sequences for table COURSE
--

SELECT SETVAL('course_course_id_seq',(select case when max(course_id)>0 then max(course_id)+1 else 1 end from course));

--
-- Sequences for table COURSESUB
--

SELECT SETVAL('coursesub_coursesub_id_seq',(select case when max(coursesub_id)>0 then max(coursesub_id)+1 else 1 end from coursesub));

--
-- Sequences for table LOCATION
--

SELECT SETVAL('location_location_id_seq',(select case when max(location_id)>0 then max(location_id)+1 else 1 end from location));

--
-- Sequences for table SUBJECT
--

SELECT SETVAL('subject_subject_id_seq',(select case when max(subject_id)>0 then max(subject_id)+1 else 1 end from subject));

--
-- Sequences for table ACCESS
--

SELECT SETVAL('access_access_id_seq',(select case when max(access_id)>0 then max(access_id)+1 else 1 end from access));

--
-- Sequences for table STYLE
--

SELECT SETVAL('style_style_id_seq',(select case when max(style_id)>0 then max(style_id)+1 else 1 end from style));

--
-- Sequences for table STAFF
--

SELECT SETVAL('staff_staff_id_seq',(select case when max(staff_id)>0 then max(staff_id)+1 else 1 end from staff));

--
-- Sequences for table COURSE_PERSONNEL
--

SELECT SETVAL('course_personnel_personnel_i',(select case when max(personnel_id)>0 then max(personnel_id)+1 else 1 end from course_personnel));

--
-- Sequences for table FACULTY
--

SELECT SETVAL('faculty_faculty_id_seq',(select case when max(faculty_id)>0 then max(faculty_id)+1 else 1 end from faculty));

--
-- Sequences for table SERVICE
--

SELECT SETVAL('service_service_id_seq',(select case when max(service_id)>0 then max(service_id)+1 else 1 end from service));

--
-- Sequences for table ELEMENT
--

SELECT SETVAL('element_element_id_seq',(select case when max(element_id)>0 then max(element_id)+1 else 1 end from element));

--
-- Sequences for table RESOURCE
--

SELECT SETVAL('resource_resource_id_seq',(select case when max(resource_id)>0 then max(resource_id)+1 else 1 end from resource));

--
-- Sequences for table PASTEBUFFER
--

SELECT SETVAL('pastebuffer_pastebuffer_id_s',(select case when max(pastebuffer_id)>0 then max(pastebuffer_id)+1 else 1 end from pastebuffer));

--
-- Sequences for table CAMPUS
--

SELECT SETVAL('campus_campus_id_seq',(select case when max(campus_id)>0 then max(campus_id)+1 else 1 end from campus));

--
-- Sequences for table PAGETYPE
--

SELECT SETVAL('pagetype_pagetype_id_seq',(select case when max(pagetype_id)>0 then max(pagetype_id)+1 else 1 end from pagetype));

COMMIT;