-- MySQL dump 10.10
--
-- Host: lib-511.library.nd.edu    Database: mylibrary
-- ------------------------------------------------------
-- Server version	5.0.18-max

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `components4interfaces`
--

DROP TABLE IF EXISTS `components4interfaces`;
CREATE TABLE `components4interfaces` (
  `interface_component_id` int(10) NOT NULL default '0',
  `interface_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`interface_component_id`,`interface_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `components4interfaces`
--

LOCK TABLES `components4interfaces` WRITE;
/*!40000 ALTER TABLE `components4interfaces` DISABLE KEYS */;
/*!40000 ALTER TABLE `components4interfaces` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `facets`
--

DROP TABLE IF EXISTS `facets`;
CREATE TABLE `facets` (
  `facet_id` int(10) NOT NULL default '0',
  `facet_name` varchar(255) NOT NULL default '',
  `facet_note` text,
  PRIMARY KEY  (`facet_id`),
  UNIQUE KEY `facet_name` (`facet_name`),
  KEY `facet_name_2` (`facet_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `facets`
--

LOCK TABLES `facets` WRITE;
/*!40000 ALTER TABLE `facets` DISABLE KEYS */;
INSERT INTO `facets` VALUES (2,'Formats','The physical manifestation of information'),(3,'People','Human beings both real and fictional'),(4,'Places','Geographic areas; physical locations'),(5,'Research Tools','Traditional information finding tools'),(6,'Subjects','Aboutness');
/*!40000 ALTER TABLE `facets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `help_simple`
--

DROP TABLE IF EXISTS `help_simple`;
CREATE TABLE `help_simple` (
  `help_id` int(10) NOT NULL default '0',
  `help_title` varchar(255) default NULL,
  `help_text` text,
  PRIMARY KEY  (`help_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `help_simple`
--

LOCK TABLES `help_simple` WRITE;
/*!40000 ALTER TABLE `help_simple` DISABLE KEYS */;
/*!40000 ALTER TABLE `help_simple` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `interface`
--

DROP TABLE IF EXISTS `interface`;
CREATE TABLE `interface` (
  `interface_id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `html` text NOT NULL,
  `options` text,
  PRIMARY KEY  (`interface_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `interface`
--

LOCK TABLES `interface` WRITE;
/*!40000 ALTER TABLE `interface` DISABLE KEYS */;
/*!40000 ALTER TABLE `interface` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `interface_component`
--

DROP TABLE IF EXISTS `interface_component`;
CREATE TABLE `interface_component` (
  `interface_component_id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `html` text NOT NULL,
  `options` text,
  PRIMARY KEY  (`interface_component_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `interface_component`
--

LOCK TABLES `interface_component` WRITE;
/*!40000 ALTER TABLE `interface_component` DISABLE KEYS */;
/*!40000 ALTER TABLE `interface_component` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `librarians`
--

DROP TABLE IF EXISTS `librarians`;
CREATE TABLE `librarians` (
  `librarian_id` int(10) NOT NULL default '0',
  `name` varchar(255) default NULL,
  `telephone` varchar(255) NOT NULL default '',
  `email` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  PRIMARY KEY  (`librarian_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `librarians`
--

LOCK TABLES `librarians` WRITE;
/*!40000 ALTER TABLE `librarians` DISABLE KEYS */;
/*!40000 ALTER TABLE `librarians` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
  `message_id` int(10) NOT NULL default '0',
  `message_date` date NOT NULL default '0000-00-00',
  `message` text NOT NULL,
  `message_global` int(1) NOT NULL default '2',
  PRIMARY KEY  (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `messages`
--

LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `new_item_profiles`
--

DROP TABLE IF EXISTS `new_item_profiles`;
CREATE TABLE `new_item_profiles` (
  `profile_id` int(10) NOT NULL default '0',
  `profile` text NOT NULL,
  `patron_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`profile_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `new_item_profiles`
--

LOCK TABLES `new_item_profiles` WRITE;
/*!40000 ALTER TABLE `new_item_profiles` DISABLE KEYS */;
/*!40000 ALTER TABLE `new_item_profiles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `patron_resource`
--

DROP TABLE IF EXISTS `patron_resource`;
CREATE TABLE `patron_resource` (
  `resource_id` int(10) NOT NULL default '0',
  `patron_id` int(10) NOT NULL default '0',
  `usage_count` int(10) NOT NULL default '0',
  `patron_owned` int(1) NOT NULL default '0',
  PRIMARY KEY  (`resource_id`,`patron_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `patron_resource`
--

LOCK TABLES `patron_resource` WRITE;
/*!40000 ALTER TABLE `patron_resource` DISABLE KEYS */;
/*!40000 ALTER TABLE `patron_resource` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `patron_term`
--

DROP TABLE IF EXISTS `patron_term`;
CREATE TABLE `patron_term` (
  `patron_id` int(10) NOT NULL default '0',
  `term_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`patron_id`,`term_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `patron_term`
--

LOCK TABLES `patron_term` WRITE;
/*!40000 ALTER TABLE `patron_term` DISABLE KEYS */;
/*!40000 ALTER TABLE `patron_term` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `patrons`
--

DROP TABLE IF EXISTS `patrons`;
CREATE TABLE `patrons` (
  `patron_id` int(10) NOT NULL default '0',
  `patron_firstname` varchar(255) default NULL,
  `patron_surname` varchar(255) default NULL,
  `patron_image` varchar(255) default NULL,
  `patron_url` varchar(255) default NULL,
  `patron_username` varchar(255) default NULL,
  `patron_organization` varchar(255) default NULL,
  `patron_address_1` varchar(255) default NULL,
  `patron_address_2` varchar(255) default NULL,
  `patron_address_3` varchar(255) default NULL,
  `patron_address_4` varchar(255) default NULL,
  `patron_address_5` varchar(255) default NULL,
  `patron_can_contact` int(1) default NULL,
  `patron_password` varchar(255) default NULL,
  `patron_total_visits` int(10) default NULL,
  `patron_last_visit` date default NULL,
  `patron_remember_me` int(1) default NULL,
  `patron_email` varchar(255) default NULL,
  `patron_stylesheet_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`patron_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `patrons`
--

LOCK TABLES `patrons` WRITE;
/*!40000 ALTER TABLE `patrons` DISABLE KEYS */;
/*!40000 ALTER TABLE `patrons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `patrons_resources`
--

DROP TABLE IF EXISTS `patrons_resources`;
CREATE TABLE `patrons_resources` (
  `resource_id` int(10) NOT NULL default '0',
  `patron_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`resource_id`,`patron_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `patrons_resources`
--

LOCK TABLES `patrons_resources` WRITE;
/*!40000 ALTER TABLE `patrons_resources` DISABLE KEYS */;
/*!40000 ALTER TABLE `patrons_resources` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `personallinks`
--

DROP TABLE IF EXISTS `personallinks`;
CREATE TABLE `personallinks` (
  `link_id` int(10) NOT NULL default '0',
  `patron_id` int(10) default NULL,
  `link_name` varchar(255) default NULL,
  `link_url` varchar(255) default NULL,
  PRIMARY KEY  (`link_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `personallinks`
--

LOCK TABLES `personallinks` WRITE;
/*!40000 ALTER TABLE `personallinks` DISABLE KEYS */;
/*!40000 ALTER TABLE `personallinks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `preferences`
--

DROP TABLE IF EXISTS `preferences`;
CREATE TABLE `preferences` (
  `PREFERNECE_ID` int(10) NOT NULL default '0',
  `SHOW_QUICK_SEARCHES` int(1) NOT NULL default '0',
  `MESSSAGE_FROM_LIBRARIAN` varchar(255) NOT NULL default '',
  `YOUR_LIBRARIANS` varchar(255) NOT NULL default '',
  `CURRENT_AWARENESS` varchar(255) NOT NULL default '',
  `PERSONAL_LINKS` varchar(255) NOT NULL default '',
  `FOOTER` text NOT NULL,
  `header` text NOT NULL,
  `SHOW_LIBREF` int(1) NOT NULL default '0',
  `GENERIC_BLURB` text NOT NULL,
  `SHOW_CAM` int(1) NOT NULL default '0',
  `MARION` varchar(255) NOT NULL default '',
  `DISCLAIMER` text NOT NULL,
  `FROM_ADDRESS` varchar(255) NOT NULL default '',
  `EXPIRES` varchar(255) NOT NULL default '',
  `PAGE_TITLE` varchar(255) NOT NULL default '',
  `SAVE_STATISTICS` int(1) NOT NULL default '0',
  `MANAGE_DISCIPLINE` int(1) NOT NULL default '0',
  `STATIC_PAGES_SHOW` int(1) NOT NULL default '0',
  `LIBRARIAN_BLURB` text NOT NULL,
  `MANAGER_BLURB` text NOT NULL,
  `facet_id` int(10) NOT NULL default '0',
  `TEMPLATE_ID` int(10) NOT NULL default '0',
  `TEMPLATE_FREE_ID` int(10) NOT NULL default '0',
  `stylesheet_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`PREFERNECE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `preferences`
--

LOCK TABLES `preferences` WRITE;
/*!40000 ALTER TABLE `preferences` DISABLE KEYS */;
/*!40000 ALTER TABLE `preferences` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `resource_location`
--

DROP TABLE IF EXISTS `resource_location`;
CREATE TABLE `resource_location` (
  `resource_location_id` int(10) NOT NULL default '0',
  `resource_location` text NOT NULL,
  `resource_location_note` varchar(255) default NULL,
  `resource_location_type` int(10) NOT NULL default '0',
  `resource_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`resource_location_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_location`
--

LOCK TABLES `resource_location` WRITE;
/*!40000 ALTER TABLE `resource_location` DISABLE KEYS */;
INSERT INTO `resource_location` VALUES (45,'http://www.humanities.ualberta.ca/agora/',NULL,43,44),(47,'http://agricola.nal.usda.gov/',NULL,43,46),(49,'http://infomotions.com/alex/',NULL,43,48),(51,'http://amazon.com/',NULL,43,50),(53,'http://www.swgc.mun.ca/animus/',NULL,43,52),(55,'http://www.bartleby.com/65/ba/BaconF-phl.html',NULL,43,54),(57,'http://www.iep.utm.edu/b/bacon.htm',NULL,43,56),(59,'http://catalogue.bl.uk/',NULL,43,58),(61,'http://www.bartleby.com/cambridge/',NULL,43,60),(63,'http://www.umich.edu/~risotto/',NULL,43,62),(65,'http://www.chicagotribune.com/',NULL,43,64),(67,'http://clcwebjournal.lib.purdue.edu/',NULL,43,66),(69,'http://www.cliffsnotes.com/',NULL,43,68),(71,'http://www.bartleby.com/65/',NULL,43,70),(73,'http://www.aber.ac.uk/~drawww/journal/',NULL,43,72),(75,'http://cookinglight.com/',NULL,43,74),(77,'http://www.ditext.com/runes/',NULL,43,76),(79,'http://dictionary.com/',NULL,43,78),(81,'http://www.doaj.org/',NULL,43,80),(83,'http://purl.org/emls',NULL,43,82),(85,'http://www.poemuseum.org/',NULL,43,84),(87,'http://www.eapoe.org/',NULL,43,86),(89,'http://docsouth.unc.edu/poe/bio.html',NULL,43,88),(91,'http://www.luminarium.org/sevenlit/',NULL,43,90),(93,'http://www.epicurious.com/',NULL,43,92),(95,'http://webdoc.sub.gwdg.de/edoc/ia/eese/eese.html',NULL,43,94),(97,'http://www.eric.ed.gov/',NULL,43,96),(99,'http://www.humboldt.edu/~essays/',NULL,43,98),(101,'http://www.units.it/~etica/',NULL,43,100),(103,'http://expedia.com/',NULL,43,102),(105,'http://www.cas.ucf.edu/philosophy/fpr/',NULL,43,104),(107,'http://plato.stanford.edu/entries/francis-bacon/',NULL,43,106),(109,'http://en.wikipedia.org/wiki/Francis_Bacon',NULL,43,108),(111,'http://en.wikipedia.org/wiki/Frankenstein%27s_monster',NULL,43,110),(113,'http://www.nlm.nih.gov/hmd/frankenstein/frankhome.html',NULL,43,112),(115,'http://google.com/',NULL,43,114),(117,'http://images.google.com/',NULL,43,116),(119,'http://maps.google.com/',NULL,43,118),(121,'http://news.google.com/',NULL,43,120),(123,'http://scholar.google.com/',NULL,43,122),(125,'http://users.bathspa.ac.uk/greenwood/',NULL,43,124),(127,'http://hollisweb.harvard.edu/',NULL,43,126),(129,'http://en.wikipedia.org/wiki/Herman_Melville',NULL,43,128),(131,'http://infomotions.com/gallery/',NULL,43,130),(133,'http://www.inspire.net/',NULL,43,132),(135,'http://www.iep.utm.edu/',NULL,43,134),(137,'http://www.jetpress.org/',NULL,43,136),(139,'http://www.psljournal.com/',NULL,43,138),(141,'http://catalog.loc.gov/',NULL,43,140),(143,'http://www.latimes.com/',NULL,43,142),(145,'http://www.bartleby.com/65/ma/Machiave.html',NULL,43,144),(147,'http://www.ph.ucla.edu/epi/snow/1859map/',NULL,43,146),(149,'http://mapquest.com/',NULL,43,148),(151,'http://people.brandeis.edu/~teuber/shelleybio.html',NULL,43,150),(153,'http://en.wikipedia.org/wiki/Mary_Shelley',NULL,43,152),(155,'http://melvyl.cdlib.org/',NULL,43,154),(157,'http://www.m-w.com/',NULL,43,156),(159,'http://www.ul.ie/~philos/',NULL,43,158),(161,'http://digital.library.upenn.edu/books/',NULL,43,160),(163,'http://www.oclc.org/worldcat/open/tryit/',NULL,43,162),(165,'http://www.csustan.edu/english/reuben/pal/chap3/melville.html',NULL,43,164),(167,'http://www.philosophersimprint.org/',NULL,43,166),(169,'http://www.philosophypages.com/dy/',NULL,43,168),(171,'http://www.picsearch.com/',NULL,43,170),(173,'http://newark.rutgers.edu/~ehrlich/poesites.html',NULL,43,172),(175,'http://www.gutenberg.org/',NULL,43,174),(177,'http://muse.jhu.edu/',NULL,43,176),(179,'http://www.pubmedcentral.nih.gov/',NULL,43,178),(181,'http://www.randmcnally.com/',NULL,43,180),(183,'http://www.victorianlondon.org/map1895/frontpage0.htm',NULL,43,182),(185,'http://www.bartleby.com/62/',NULL,43,184),(187,'http://www.ron.umontreal.ca/',NULL,43,186),(189,'http://www.sirbacon.org/biblio.html',NULL,43,188),(191,'http://www.sherlockian.net/',NULL,43,190),(193,'http://www.sherlockian.net/acd/',NULL,43,192),(195,'http://www.southbendtribune.com/',NULL,43,194),(197,'http://sjcpl.lib.in.us/',NULL,43,196),(199,'http://plato.stanford.edu/',NULL,43,198),(201,'http://www.switchboard.com/',NULL,43,200),(203,'http://www.library.nd.edu/',NULL,43,202),(205,'http://weather.com/',NULL,43,204),(207,'http://www.wikipedia.org/',NULL,43,206),(209,'http://yahoo.com/',NULL,43,208);
/*!40000 ALTER TABLE `resource_location` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `resource_location_type`
--

DROP TABLE IF EXISTS `resource_location_type`;
CREATE TABLE `resource_location_type` (
  `type_id` int(10) NOT NULL default '0',
  `type_name` varchar(255) NOT NULL default '',
  `type_description` text,
  PRIMARY KEY  (`type_id`),
  UNIQUE KEY `type_name` (`type_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resource_location_type`
--

LOCK TABLES `resource_location_type` WRITE;
/*!40000 ALTER TABLE `resource_location_type` DISABLE KEYS */;
INSERT INTO `resource_location_type` VALUES (43,'URL','Pointers to things on the Internet, usually websites');
/*!40000 ALTER TABLE `resource_location_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `resources`
--

DROP TABLE IF EXISTS `resources`;
CREATE TABLE `resources` (
  `resource_id` int(10) NOT NULL default '0',
  `resource_name` varchar(255) NOT NULL default '',
  `resource_note` text,
  `resource_fkey` varchar(255) default '',
  `resource_date` date default '0000-00-00',
  `resource_lcd` int(1) default '0',
  `qsearch_prefix` varchar(255) default '',
  `qsearch_suffix` varchar(255) default '',
  `resource_proxied` int(1) NOT NULL default '0',
  `resource_creator` varchar(255) default NULL,
  `resource_publisher` varchar(255) default NULL,
  `resource_contributor` varchar(255) default NULL,
  `resource_coverage` varchar(255) default NULL,
  `resource_rights` varchar(255) default NULL,
  `resource_language` varchar(255) default NULL,
  `resource_source` varchar(255) default NULL,
  `resource_relation` varchar(255) default NULL,
  `resource_access_note` varchar(255) default NULL,
  `resource_coverage_info` varchar(255) default NULL,
  `resource_full_text` int(1) NOT NULL default '0',
  `resource_reference_linking` int(1) NOT NULL default '0',
  `resource_format` varchar(255) default NULL,
  `resource_type` varchar(255) default NULL,
  `resource_subject` varchar(255) default NULL,
  `resource_create_date` date default NULL,
  PRIMARY KEY  (`resource_id`),
  KEY `resource_name` (`resource_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resources`
--

LOCK TABLES `resources` WRITE;
/*!40000 ALTER TABLE `resources` DISABLE KEYS */;
INSERT INTO `resources` VALUES (44,'Agora (Edmonton)','\"...a public forum of debate and dialogue that addresses issues of critical scholarship regarding the literary arts, the public sphere, the nature of communication, and the humanities, as they relate to the academic and general community.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(46,'AGRICOLA','\"AGRICOLA (AGRICultural OnLine Access) is a bibliographic database of citations to the agricultural literature created by the National Agricultural Library (NAL) and its cooperators.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(48,'Alex Catalogue of Electronic Texts','A collection of about 600 texts from American and English literature as well as Western philosophy\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(50,'Amazon.com','Buy lot\'s o\' stuff, but books is one of their strengths\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(52,'Animus: a philosophical journal for our time','\"...aims at an understanding of the works of Western civilization and contemporary views of these works. It seeks to promote a standpoint which is critical of dogmatic positions both within contemporary views and within the Western tradition itself.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(54,'Bacon, Francis, English philosopher','An entry from the Columbia Encyclopedia\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(56,'Biography of Francis Bacon','An entry from the Internet Encyclopedia of Philosophy\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(58,'British Library Integrated Catalogue','\"...list[s] over twelve million items in the British Library\'s outstanding collections.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(60,'Cambridge History of English and American Literature','\"...contains over 303 chapters and 11,000 pages, with essay topics ranging from poetry, fiction, drama and essays to history, theology and political writing.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(62,'Charles Booth\'s 1889 Descriptive Map of London Poverty','An interactive map of London illustrating where the hightest concentration of poverty existed in 1889\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(64,'Chicago Tribune','The daily news paper of Chicago, IL\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(66,'CLCWeb: Comparative Literature and Culture','\"...publishes scholarship in the widest definition of comparative literature and culture in combining comparative literature with cultural studies as \'comparative cultural studies.\'\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(68,'Cliffs Notes','Summaries and guides to \"great\" literature\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(70,'Columbia Encyclopedia','\"Containing nearly 51,000 entries (marshalling six and one-half million words on a vast range of topics), and with more than 80,000 hypertext cross-references, the current Sixth Edition is among the most complete and up-to-date encyclopedias ever produced.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(72,'Consciousness, Literature and the Arts','\"...provides a forum for new work relating the arts and literature to the exploration of consciousness currently flourishing in many disciplines such as philosophy, cognitive science, psychology, neuroscience, computer science, and physics.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(74,'Cooking Light','Another one of Mary\'s favorites\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(76,'Dictionary of Philosophy','\"to provide teachers, students and laymen interested in philosophy with clear, concise, and correct definitions and descriptions of the philosophical terms, throughout the range of philosophic thought.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(78,'Dictionary.com','A free dictionary\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(80,'Directory of Open Access Journals','\"...covers free, full text, quality controlled scientific and scholarly journals. We aim to cover all subjects and languages.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(82,'Early Modern Literary Studies: a journal of sixteenth- and seventeenth-century English literature','\"...examine[s] English literature, literary culture, and language during the sixteenth and seventeenth centuries\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(84,'Edgar Alan Poe Museum','\"...boasts the world\'s finest collection of Edgar Allan Poe\'s manuscripts, letters, first editions, memorabilia and personal belongings. The Poe Museum provides a retreat into early nineteenth century Richmond where Poe lived and worked. The museum features the life and career of Edgar Allan Poe by documenting his accomplishments with pictures, relics, and verse, and focusing on his many years in Richmond.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(86,'Edgar Allan Poe Society of Baltimore','Contains a nice set of local links regarding Poe.\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(88,'Edgar Allan Poe, 1809-1849','A short biography from the Encyclopedia of Southern Culture\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(90,'English Literature: Early 17th Centry (1603-1660)','\"...a starting point for students and enthusiasts of English Literature.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(92,'Epicurious','Mary\'s favorite cooking site\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(94,'Erfurt Electronic Studies in English','\"EESE is a refereed journal archived by the Niedersachsische Staats- und Universitatsbibliothek Gottingen.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(96,'ERIC','The ERIC Clearinghouse provides information on becoming a teacher, alternative routes to certification, and teacher education programs.\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(98,'Essays in Philosophy','\"...exists to publish philosophical papers of quality, papers which the editors believe will make a contribution to the literature on a certain topic. The Journal holds to no specific school of thought, mode of philosophizing, or style of writing. Each issue of the Journal will be devoted to a specific topic.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(100,'Etica e Politica/Ethics and Politics','ISSN 1825-5167',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(102,'Expedia','Make airline, hotel, and rental car reservations\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(104,'Florida Philosophical Review','The Journal of the Florida Philosophical Association is a publication of the University of Central Florida Department of Philosophy\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(106,'Francis Bacon','An entry from the Stanford Encyclopedia of Philosophy\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(108,'Francis Bacon','An entry from the Wikipedia\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(110,'Frankenstein\'s monster','An outline of what Frankenstein\'s monster is/was from Wikipedia\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(112,'Frankenstein: Penetrating the secrets of nature','An interesting set of photographs and links as a part of a history of medicine exhibit.\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(114,'Google','An index to the Internet\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(116,'Google Images','An index to pictures from the Internet\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(118,'Google Maps','An interactive map-making site enhanced with satelite imagery\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(120,'Google News','An aggrigation of news stories from news sites across the Internet\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(122,'Google Scholar','An index to scholarly literture on the Internet\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(124,'Greenwood\'s Map of London, 1827','\"Greenwood\'s map is scaled at eight inches to the mile, covers London and surroundings and stretches out to Earls Court in the West, to the River Lea and Greenwich in the East, Highgate to the North and to the South, Camberwell\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(126,'Harvard University library catalog','\"...a database containing over 9 million records for more than 14 million books, journals, manuscripts, government documents, maps, microforms, music scores, sound recordings, visual materials, and data files.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(128,'Herman Melville from Wikipedia','An encylopedic essay describing Herman Melville\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(130,'Infomotions Image Gallery','A collection of travel photographs',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(132,'INSPIRE','A large collection licensed biblographic datdabases touted as a \"digital library of Indiana\". Registration is free to Indiana residents and login is required.\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(134,'Internet Encyclopedia of Philosophy','\"...founded in 1995 for the purpose of providing detailed, scholarly information on key topics and philosophers in all areas of philosophy.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(136,'Journal of Evolution and Technology','A peer-reviewed electronic journal published by the Institute for Ethics and Emerging Technologies',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(138,'Journal of Philosophy, Science and Law','\"...edicated to examining issues in the intersection of applied philosophy, science, and the law.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(140,'Library of Congress catalog','The lists of items owned by the Library of Congress\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(142,'Los Angeles Times','The daily newspaper of Los Angeles, CA\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(144,'Machiavelli, Niccoli','An entry from the Columbia Encyclopedia\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(146,'Map of John Snow\'s London in 1859','\"A historical map with sites of Victorian London during the time of Dr. John Snow (1813-58), the prominent epidemiologist and anesthesilogist.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(148,'MapQuest','Provides maps of most United States towns as well as driving directions\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(150,'Mary Shelley Biography','A short biography and bibliography regarding  Mr. Shelley\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(152,'Mary Shelley from Wikipedia','An outline of who Ms. Shelley was and what she wrote\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(154,'Melvyl, the University of California library catalog','\"The Melvyl catalog contains records for materials (books, journals, movies, maps, music scores and recordings, computer files, dissertations, government documents, etc.) held by the libraries of the ten UC campuses, [plus others]... The database contains over 25,000,000 records...\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(156,'Merriam-Webster Online','a more than decent dictionary and thesarus\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(158,'Minerva: an Internet Journal of Philosophy','\"...published annually and is available on an open-access basis on the Internet. The journal publishes articles relating to philosophy construed in a broad but scholarly sense, without preference for any particular school or intellectual tradition.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(160,'Online Books Page','\"...a website that facilitates access to books that are freely readable over the Internet.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(162,'Open WorldCat','An index to collections of the majority of libraries across the world\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(164,'PAL: Herman Melville','A biography and bibliography of Herman Melville\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(166,'Philosophers\' Imprint','\"...refereed series of original papers in philosophy,... it is not restricted to any particular field or school of philosophy.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(168,'Philosophical Dictionary','\"This is a concise guide to technical terms and personal names often encountered in the study of philosophy.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(170,'Picsearch','\"... provides an image search engine for individual users.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(172,'Poe Webliography: Edgar Allan Poe on the Internet','\"A critical guide to electronic resources for Poe research on the World Wide Web and CD-ROM, including electronic texts, HTML-encoded texts, hypertexts, secondary works, commentaries, and indexes.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(174,'Project Gutenberg','The grand daddy of electronic text collections\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(176,'Project MUSE','\"...a unique collaboration between libraries and publishers providing 100% full-text, affordable and user-friendly online access to over 300 high quality humanities, arts, and social sciences journals from 60 scholarly publishers,\" but the articles are only available to subscribing libraries.\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(178,'PubMed','PubMed Central (PMC) is the U.S. National Institutes of Health (NIH) free digital archive of biomedical and life sciences journal literature.\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(180,'Rand McNally','Maps of all kinds\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(182,'Reynolds\' Map of London','An interactive map of London from 1895\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(184,'Roget\'s II: The New Thesaurus','\"Containing 35,000 synonyms in an easy-to-use format, this thesaurus features succinct word definitions and an innovative hyperlinked category index by the Editors of the American Heritage Dictionary.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(186,'Romanticism On the Net','\"...devoted to British Romantic studies.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(188,'Select Bibliography of the Works of Francis Bacon','\"...a select bibliography of the works of Francis Bacon, followed by two bibliographies of works about him regarding the authorship and other topics.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(190,'Sherlockian.Net','\"Everything the Web offers about Sherlock Holmes...\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(192,'Sherlockian.Net: Arthur Conan Doyle','A brief biography of Sir Arthur Conan Doyle\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(194,'South Bend Tribune','The daily newspaper of South Bend, IN\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(196,'St. Joseph County Public Library','The public library of the South Bend area\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(198,'Stanford†Encyclopedia of Philosophy','\"...designed from its inception (September 1995) as a dynamic reference work ... each entry is maintained and kept up to date by an expert or group of experts ... updates are refereed by the members of a distinguished Editorial Board before they are made public.\"\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(200,'Switchboard.com','Find names, addresses, and telephone numbers of people and businesses\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(202,'University Libraries of Notre Dame','The library of the University of Notre Dame\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(204,'Weather.com','The Weather Channel gone online\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(206,'Wikipedia','An encyclopedia update by the Internet community\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL),(208,'Yahoo','A collection of services -- most notably an index to Internet resources\r\n',NULL,NULL,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `resources` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reviews`
--

DROP TABLE IF EXISTS `reviews`;
CREATE TABLE `reviews` (
  `review_id` int(10) NOT NULL default '0',
  `review` text NOT NULL,
  `reviewer_name` varchar(255) NOT NULL default '',
  `reviewer_email` varchar(255) NOT NULL default '',
  `review_date` date NOT NULL default '0000-00-00',
  `review_rating` varchar(255) NOT NULL default '',
  `term_id` int(10) NOT NULL default '0',
  `resource_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`review_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reviews`
--

LOCK TABLES `reviews` WRITE;
/*!40000 ALTER TABLE `reviews` DISABLE KEYS */;
/*!40000 ALTER TABLE `reviews` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sequence`
--

DROP TABLE IF EXISTS `sequence`;
CREATE TABLE `sequence` (
  `id` int(10) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sequence`
--

LOCK TABLES `sequence` WRITE;
/*!40000 ALTER TABLE `sequence` DISABLE KEYS */;
INSERT INTO `sequence` VALUES (297);
/*!40000 ALTER TABLE `sequence` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `id` varchar(32) NOT NULL default '',
  `a_session` text NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sessions`
--

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `statistics`
--

DROP TABLE IF EXISTS `statistics`;
CREATE TABLE `statistics` (
  `statistic_id` int(10) NOT NULL default '0',
  `resource_id` int(10) NOT NULL default '0',
  `statistic_date` date NOT NULL default '0000-00-00',
  `statistic_query` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`statistic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `statistics`
--

LOCK TABLES `statistics` WRITE;
/*!40000 ALTER TABLE `statistics` DISABLE KEYS */;
/*!40000 ALTER TABLE `statistics` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stylesheets`
--

DROP TABLE IF EXISTS `stylesheets`;
CREATE TABLE `stylesheets` (
  `stylesheet_id` int(10) NOT NULL default '0',
  `stylesheet_name` varchar(255) NOT NULL default '',
  `stylesheet_description` text NOT NULL,
  `stylesheet` text NOT NULL,
  PRIMARY KEY  (`stylesheet_id`),
  UNIQUE KEY `stylesheet_name` (`stylesheet_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stylesheets`
--

LOCK TABLES `stylesheets` WRITE;
/*!40000 ALTER TABLE `stylesheets` DISABLE KEYS */;
/*!40000 ALTER TABLE `stylesheets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `suggestedResources`
--

DROP TABLE IF EXISTS `suggestedResources`;
CREATE TABLE `suggestedResources` (
  `term_id` int(10) NOT NULL default '0',
  `resource_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`resource_id`,`term_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `suggestedResources`
--

LOCK TABLES `suggestedResources` WRITE;
/*!40000 ALTER TABLE `suggestedResources` DISABLE KEYS */;
/*!40000 ALTER TABLE `suggestedResources` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `terms`
--

DROP TABLE IF EXISTS `terms`;
CREATE TABLE `terms` (
  `term_id` int(10) NOT NULL default '0',
  `term_name` varchar(255) NOT NULL default '',
  `term_note` text,
  `facet_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`term_id`),
  UNIQUE KEY `term_name` (`term_name`),
  KEY `facet_id` (`facet_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `terms`
--

LOCK TABLES `terms` WRITE;
/*!40000 ALTER TABLE `terms` DISABLE KEYS */;
INSERT INTO `terms` VALUES (7,'Books','Traditionally codexes,but can now-a-days mean electronic books of all kinds',2),(8,'Images','Pictures',2),(9,'Journals','Like magazines, contain articles but usually of a scholarly nature',2),(10,'Maps','Pictures of geographic locations',2),(11,'Newspapers','News stories distributed on a more or less daily basis',2),(12,'Bacon Francis (1561-1626)','An author of philosophy',3),(13,'Doyle Arthur Conan (1859-1930)','The author of many short stories, most notably surrounding Sherlock Holmes',3),(14,'Frankenstein','\"a modern Prometheus\"',3),(15,'Holmes, Sherlock','The main character of many Sir Arthur Conan Doyle stories',3),(16,'Machiavelli, Niccolo (1469-1527)','A political commentator',3),(17,'Melville, Herman (1819-1891)','The author of Moby Dick',3),(18,'Poe, Edgar Allan (1809-1849)','The author of many short stories',3),(19,'Shelley, Mary Wollstonecraft (1797-1851)','The author of Frankenstein',3),(20,'London','The capital of England',4),(21,'Bibliographies','Lists of citations',5),(22,'Biographies','Narratives about people',5),(23,'Catalogs','Usually lists of items own by a specific institutions, usually library \"catalogs\"',5),(24,'Dictionaries','Useful for determining the definitions of words',5),(25,'Directories','Names, addresses, and telephone numbers',5),(26,'Encyclopedias','Short introductions to specific topics',5),(27,'Exhibits','Usually things done by libraries, archives, and museums displaying works  or themes of items from their collections',5),(28,'Indexes, bibliographic','Lists of pointers to magazine and journal articles',5),(29,'Indexes, Internet','Lists -- pointers -- to information resources found on the Web. Usually websites.',5),(30,'Libraries','Places where information needs are met',5),(31,'Museums','An \"archive\" open to the public',5),(32,'News','Current events',5),(33,'Thesauri','Usually used to discover words with similar meanings',5),(34,'Cooking','The process of preparing food',6),(35,'Education','The process of teaching people how to learn',6),(37,'Languages and Literatures','Reading and writing',6),(38,'Languages and Literatures -- English, 17th century','Reading and writing between 1600-1699',6),(39,'Health Sciences','A life science dealing with the healing of people',6),(40,'Philosophy and Religion','Thinking and thinquing',6),(41,'Travel','Going places',6),(42,'Weather','What is it doing outside?',6);
/*!40000 ALTER TABLE `terms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `terms_librarians`
--

DROP TABLE IF EXISTS `terms_librarians`;
CREATE TABLE `terms_librarians` (
  `term_id` int(10) NOT NULL default '0',
  `librarian_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`term_id`,`librarian_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `terms_librarians`
--

LOCK TABLES `terms_librarians` WRITE;
/*!40000 ALTER TABLE `terms_librarians` DISABLE KEYS */;
/*!40000 ALTER TABLE `terms_librarians` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `terms_messages`
--

DROP TABLE IF EXISTS `terms_messages`;
CREATE TABLE `terms_messages` (
  `message_id` int(10) NOT NULL default '0',
  `term_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`message_id`,`term_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `terms_messages`
--

LOCK TABLES `terms_messages` WRITE;
/*!40000 ALTER TABLE `terms_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `terms_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `terms_resources`
--

DROP TABLE IF EXISTS `terms_resources`;
CREATE TABLE `terms_resources` (
  `resource_id` int(10) NOT NULL default '0',
  `term_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`resource_id`,`term_id`),
  KEY `term_id` (`term_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `terms_resources`
--

LOCK TABLES `terms_resources` WRITE;
/*!40000 ALTER TABLE `terms_resources` DISABLE KEYS */;
INSERT INTO `terms_resources` VALUES (44,9),(44,37),(46,28),(48,7),(48,37),(48,40),(50,7),(52,9),(52,40),(54,12),(54,22),(56,12),(56,22),(58,7),(58,23),(60,26),(60,37),(62,10),(62,20),(64,11),(66,9),(66,37),(68,37),(70,26),(70,37),(72,9),(72,37),(74,9),(74,34),(76,24),(76,40),(78,24),(80,9),(80,25),(82,9),(82,38),(84,18),(84,31),(86,18),(86,29),(88,18),(88,22),(90,21),(90,38),(92,34),(94,9),(94,37),(96,28),(96,35),(98,21),(98,40),(100,9),(100,40),(102,41),(104,9),(104,40),(106,12),(106,21),(106,22),(108,12),(108,21),(108,22),(110,14),(112,8),(112,14),(112,27),(112,39),(114,29),(116,8),(116,29),(118,10),(118,29),(120,29),(120,32),(122,28),(124,10),(124,20),(126,23),(128,17),(128,21),(128,22),(130,8),(132,28),(134,26),(134,40),(136,9),(136,40),(138,9),(138,40),(140,23),(142,11),(144,16),(144,21),(144,22),(146,10),(146,20),(148,10),(150,19),(150,22),(152,19),(152,21),(152,22),(154,23),(156,24),(156,33),(158,9),(158,40),(160,7),(160,23),(162,23),(164,17),(164,21),(164,22),(166,21),(166,40),(168,24),(168,40),(170,8),(170,29),(172,18),(172,21),(174,7),(174,23),(176,28),(178,28),(178,39),(180,10),(182,10),(182,20),(184,33),(186,21),(186,37),(188,12),(188,21),(190,15),(192,13),(192,22),(194,11),(196,30),(198,26),(198,40),(200,25),(202,30),(204,42),(206,26),(208,29);
/*!40000 ALTER TABLE `terms_resources` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2007-06-29 13:31:02
