admin/install/libdata.sql

-- MySQL dump 8.23
--
-- Host: localhost    Database: libdata
---------------------------------------------------------
-- Server version       3.23.56

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

CREATE TABLE access (
  access_id mediumint(9) NOT NULL auto_increment,
  access_level mediumint(9) default NULL,
  access varchar(25) default NULL,
  PRIMARY KEY  (access_id)
) TYPE=MyISAM;

--
-- 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`
--

CREATE TABLE campus (
  campus_id mediumint(9) NOT NULL auto_increment,
  campus varchar(50) default NULL,
  institution varchar(10) default NULL,
  PRIMARY KEY  (campus_id)
) TYPE=MyISAM;

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


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

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

CREATE TABLE course (
  course_id mediumint(9) NOT NULL auto_increment,
  page_id mediumint(9) default NULL,
  coursesub_id mediumint(9) default NULL,
  course_num varchar(50) default NULL,
  course_section varchar(10) default NULL,
  course_concat varchar(255) default NULL,
  term_id mediumint(9) default NULL,
  course_year varchar(4) default NULL,
  campus_id mediumint(9) default NULL,
  courseheader varchar(255) default NULL,
  introheader1 text,
  intromessage1 text,
  introheader2 text,
  intromessage2 text,
  PRIMARY KEY  (course_id)
) TYPE=MyISAM;

--
-- 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 `course_personnel`
--

CREATE TABLE course_personnel (
  personnel_id mediumint(9) NOT NULL auto_increment,
  course_id mediumint(9) NOT NULL default '0',
  stafftitle_id mediumint(9) default NULL,
  staff_id mediumint(9) default NULL,
  faculty_id mediumint(9) default NULL,
  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)
) TYPE=MyISAM;

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


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

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

CREATE TABLE coursesub (
  coursesub_id mediumint(9) NOT NULL auto_increment,
  coursesub varchar(15) default NULL,
  coursesub_descr varchar(100) default NULL,
  cip_code varchar(50) default NULL,
  campus_id mediumint(9) default NULL,
  PRIMARY KEY  (coursesub_id)
) TYPE=MyISAM;

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

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

CREATE TABLE element (
  element_id mediumint(9) NOT NULL auto_increment,
  page_id mediumint(9) default NULL,
  parent_id mediumint(9) default NULL,
  resource_id mediumint(9) default NULL,
  location_id mediumint(9) default NULL,
  service_id mediumint(9) default NULL,
  staff_id mediumint(9) default NULL,
  subject_id mediumint(9) default NULL,
  label varchar(200) default NULL,
  label_url varchar(200) default NULL,
  element_descr text,
  element_size smallint(6) default NULL,
  element_order smallint(6) default NULL,
  indent_level smallint(6) default NULL,
  PRIMARY KEY  (element_id)
) TYPE=MyISAM;

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


INSERT INTO element VALUES (21,4,15,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,1);
INSERT INTO element VALUES (22,4,15,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6,1);
INSERT INTO element VALUES (20,4,15,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,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.',2,3,0);
INSERT INTO element VALUES (23,4,15,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7,1);
INSERT INTO element VALUES (25,4,15,11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,8,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,10,1);
INSERT INTO element VALUES (30,15,28,NULL,55,NULL,NULL,NULL,NULL,NULL,NULL,NULL,9,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,48,2,NULL,NULL,NULL,NULL,'','','',NULL,2,1);
INSERT INTO element VALUES (48,4,0,NULL,NULL,NULL,NULL,NULL,'<IMG SRC=\"http://setiathome.berkeley.edu/images/header-sah.gif\">','','',NULL,1,0);

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

CREATE TABLE faculty (
  faculty_id mediumint(9) NOT NULL auto_increment,
  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)
) TYPE=MyISAM;

--
-- 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 `feature`
--

CREATE TABLE feature (
  feature_id mediumint(9) NOT NULL auto_increment,
  feature varchar(50) default NULL,
  image_path varchar(100) default NULL,
  image_alt varchar(100) default NULL,
  PRIMARY KEY  (feature_id)
) TYPE=MyISAM;

--
-- 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 `infotype`
--

CREATE TABLE infotype (
  infotype_id mediumint(9) NOT NULL auto_increment,
  masterinfotype_id mediumint(9) default NULL,
  mastersubject_id mediumint(9) default NULL,
  infotype varchar(75) NOT NULL default '',
  PRIMARY KEY  (infotype_id)
) TYPE=MyISAM;

--
-- 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,2,'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 `libunit`
--

CREATE TABLE libunit (
  libunit_id mediumint(9) NOT NULL auto_increment,
  libunit varchar(100) default NULL,
  libunit_abbrev varchar(25) default NULL,
  head_staff_id mediumint(9) default NULL,
  PRIMARY KEY  (libunit_id)
) TYPE=MyISAM;

--
-- 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 mediumint(9) NOT NULL default '0',
  staff_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (libunit_id,staff_id)
) TYPE=MyISAM;

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


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

CREATE TABLE location (
  location_id mediumint(9) NOT NULL auto_increment,
  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)
) TYPE=MyISAM;

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

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

CREATE TABLE masterinfotype (
  masterinfotype_id mediumint(9) NOT NULL auto_increment,
  masterinfotype varchar(75) NOT NULL default '',
  PRIMARY KEY  (masterinfotype_id)
) TYPE=MyISAM;

--
-- 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 `mastersubject`
--

CREATE TABLE mastersubject (
  mastersubject_id mediumint(9) NOT NULL auto_increment,
  mastersubject varchar(50) NOT NULL default '',
  PRIMARY KEY  (mastersubject_id)
) TYPE=MyISAM;

--
-- 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,'Arts & Humanities');
INSERT INTO mastersubject VALUES (5,'Business and Economics');
INSERT INTO mastersubject VALUES (6,'Engineering, Mathematics & Physical Sciences');
INSERT INTO mastersubject VALUES (7,'Health and Medicine');
INSERT INTO mastersubject VALUES (8,'Law');
INSERT INTO mastersubject VALUES (9,'Social Sciences');
INSERT INTO mastersubject VALUES (10,'General');

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

CREATE TABLE page (
  page_id mediumint(9) NOT NULL auto_increment,
  date_created datetime default NULL,
  date_modified datetime default NULL,
  account_created varchar(20) default NULL,
  account_modified varchar(20) default NULL,
  staff_coordinator mediumint(9) default NULL,
  style_id mediumint(9) default NULL,
  pagetype_id mediumint(9) default NULL,
  page_title varchar(255) default NULL,
  pagetitle_style smallint(6) default NULL,
  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 mediumtext,
  pageHTML mediumtext,
  page_debug char(1) default NULL,
  PRIMARY KEY  (page_id)
) TYPE=MyISAM;

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


INSERT INTO page VALUES (4,'2003-09-24 09:29:36','2004-01-30 15:05:23','admin','admin',2,1,2,'Further SETI Resources',NULL,NULL,NULL,'0',NULL,'0','[Return to Top]','',NULL,NULL);
INSERT INTO page VALUES (15,'2003-10-06 10:01:31','2004-02-19 13:23:11','admin','admin',2,2,3,'Advanced Topics in Astronomy',NULL,'1','0','1','0','1','[Return to Top]',NULL,NULL,NULL);

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

CREATE TABLE page_staff (
  page_id mediumint(9) NOT NULL default '0',
  staff_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (page_id,staff_id)
) TYPE=MyISAM;

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


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

CREATE TABLE pagetype (
  pagetype_id mediumint(9) NOT NULL auto_increment,
  pagetype varchar(50) default NULL,
  PRIMARY KEY  (pagetype_id)
) TYPE=MyISAM;

--
-- 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 `pastebuffer`
--

CREATE TABLE pastebuffer (
  pastebuffer_id mediumint(9) NOT NULL auto_increment,
  paste_staff_id mediumint(9) NOT NULL default '0',
  parent_id mediumint(9) default NULL,
  resource_id mediumint(9) default NULL,
  location_id mediumint(9) default NULL,
  service_id mediumint(9) default NULL,
  staff_id mediumint(9) default NULL,
  subject_id mediumint(9) default NULL,
  label varchar(200) default NULL,
  label_url varchar(200) default NULL,
  element_descr text,
  element_size smallint(6) default NULL,
  element_order smallint(6) default NULL,
  indent_level smallint(6) default NULL,
  PRIMARY KEY  (pastebuffer_id)
) TYPE=MyISAM;

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


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

CREATE TABLE res_feature (
  resource_id mediumint(9) NOT NULL default '0',
  feature_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (resource_id,feature_id)
) TYPE=MyISAM;

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

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

CREATE TABLE res_loc (
  resource_id mediumint(9) NOT NULL default '0',
  location_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (resource_id,location_id)
) TYPE=MyISAM;

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

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

CREATE TABLE res_mastersubject (
  resource_id mediumint(9) NOT NULL default '0',
  mastersubject_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (resource_id,mastersubject_id)
) TYPE=MyISAM;

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

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

CREATE TABLE res_sub_infotype (
  resource_id mediumint(9) NOT NULL default '0',
  subject_id mediumint(9) NOT NULL default '0',
  infotype_id mediumint(9) NOT NULL default '0',
  highlighted char(1) default NULL,
  description text,
  masterinfotype_id mediumint(9) NOT NULL default '0'
) TYPE=MyISAM;

--
-- 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 (13,3,87,'0','',11);

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

CREATE TABLE resource (
  resource_id mediumint(9) NOT NULL auto_increment,
  date_created datetime default NULL,
  date_modified datetime 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,
  guide_url text,
  visited varchar(25) default NULL,
  annotation text,
  location_id mediumint(9) default NULL,
  infotype_id mediumint(9) default NULL,
  vendor_id mediumint(9) default NULL,
  resource_message text,
  resource_status char(1) default NULL,
  PRIMARY KEY  (resource_id)
) TYPE=MyISAM;

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


INSERT INTO resource VALUES (1,'2003-09-16 15:54:54','2003-09-30 10:51:10','admin','admin','Google','','','','','','','','','','http://www.google.com',NULL,NULL,'',NULL,18,0,NULL,NULL);
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,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,NULL,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,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,NULL,NULL);
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,NULL,'Project home page for Harvard\'s SETI programs.',NULL,138,NULL,NULL,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,NULL,'Sky & Telescope magazine\'s collection of resources on SETI.',NULL,138,NULL,NULL,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,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,NULL,NULL);
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,NULL,'The radiotelescope based in Puerto Rico responsible for the feed to SETI@Home.',NULL,87,0,NULL,NULL);
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,NULL,'General gateway site to many resources and articles on astrobiology.',NULL,40,0,NULL,NULL);

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

CREATE TABLE serv_loc (
  service_id mediumint(9) NOT NULL default '0',
  location_id mediumint(9) NOT NULL default '0',
  allloc char(1) default NULL,
  PRIMARY KEY  (service_id,location_id)
) TYPE=MyISAM;

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


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

CREATE TABLE serv_servtype (
  service_id mediumint(9) NOT NULL default '0',
  servicetype_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (service_id,servicetype_id)
) TYPE=MyISAM;

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


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

CREATE TABLE service (
  service_id mediumint(9) NOT NULL auto_increment,
  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)
) TYPE=MyISAM;

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


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

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

CREATE TABLE servicetype (
  servicetype_id mediumint(9) NOT NULL auto_increment,
  servicetype varchar(75) default NULL,
  PRIMARY KEY  (servicetype_id)
) TYPE=MyISAM;

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


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

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

CREATE TABLE staff (
  staff_id mediumint(9) NOT NULL auto_increment,
  staff_account varchar(20) default NULL,
  staff_email varchar(50) default NULL,
  password varchar(16) default NULL,
  last_name varchar(75) default NULL,
  first_name varchar(75) default NULL,
  last_login datetime default NULL,
  last_ip varchar(15) default NULL,
  date_created datetime default NULL,
  date_modified datetime default NULL,
  access_id mediumint(9) default NULL,
  stafftitle_id mediumint(9) default NULL,
  PRIMARY KEY  (staff_id)
) TYPE=MyISAM;

--
-- 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',password('libd4t4'),
'Administrator','System',NULL,NULL, NULL,NULL,5,3);

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

CREATE TABLE stafftitle (
  stafftitle_id mediumint(9) NOT NULL auto_increment,
  stafftitle varchar(50) default NULL,
  PRIMARY KEY  (stafftitle_id)
) TYPE=MyISAM;

--
-- 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 `style`
--

CREATE TABLE style (
  style_id mediumint(9) NOT NULL auto_increment,
  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)
) TYPE=MyISAM;

--
-- 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','/var/www/html/libdata_pos/styles/libinverse/header.phtml','/var/www/html/libdata_pos/styles/libinverse/footer.phtml','/var/www/html/libdata_pos/styles/libinverse/libdata.css');

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

CREATE TABLE sub_coursesub (
  subject_id mediumint(9) NOT NULL default '0',
  coursesub_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (subject_id,coursesub_id)
) TYPE=MyISAM;

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


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

CREATE TABLE sub_loc (
  subject_id mediumint(9) NOT NULL default '0',
  location_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (subject_id,location_id)
) TYPE=MyISAM;

--
-- 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 mediumint(9) NOT NULL default '0',
  mastersubject_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (subject_id,mastersubject_id)
) TYPE=MyISAM;

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


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

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

CREATE TABLE sub_othersub (
  subject_id mediumint(9) NOT NULL default '0',
  othersub_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (subject_id,othersub_id)
) TYPE=MyISAM;

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


INSERT INTO sub_othersub VALUES (2,3);

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

CREATE TABLE sub_page (
  subject_id mediumint(9) NOT NULL default '0',
  page_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (subject_id,page_id)
) TYPE=MyISAM;

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


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

CREATE TABLE sub_staff (
  subject_id mediumint(9) NOT NULL default '0',
  staff_id mediumint(9) NOT NULL default '0',
  PRIMARY KEY  (subject_id,staff_id)
) TYPE=MyISAM;

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


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

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

CREATE TABLE subject (
  subject_id mediumint(9) NOT NULL auto_increment,
  subject varchar(75) NOT NULL default '',
  subject_descr text,
  sublocation_id mediumint(9) default NULL,
  rqs_date_created datetime default NULL,
  rqs_date_modified datetime 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)
) TYPE=MyISAM;

--
-- 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-01-30 13:11:24','admin','admin','1');
INSERT INTO subject VALUES (3,'Astronomy','The study of planets, stars, galaxies, and other objects in space.',55,'2003-11-04 12:14:53','2004-01-30 13:10:59','admin','admin','1');

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

CREATE TABLE term (
  term_id mediumint(9) NOT NULL auto_increment,
  term varchar(150) default NULL,
  PRIMARY KEY  (term_id)
) TYPE=MyISAM;

--
-- 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 `vendor`
--

CREATE TABLE vendor (
  vendor_id mediumint(9) NOT NULL auto_increment,
  vendor varchar(255) default NULL,
  vendor_descr text,
  vendor_message text,
  vendor_status char(1) default NULL,
  PRIMARY KEY  (vendor_id)
) TYPE=MyISAM;

--
-- Dumping data for table `vendor`
--


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