# MySQL dump 8.13
#
# Host: localhost    Database: BEN
#--------------------------------------------------------
# Server version	3.23.37
#
# Updated 2003-09-23

#
# Table structure for table 'tbl_Partners'
#

DROP TABLE IF EXISTS tbl_Partners;
CREATE TABLE tbl_Partners (
  ID int(11) NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  ShortName varchar(255) NOT NULL default '',
  ResourceSubmissionURL text NOT NULL,
  Email varchar(255) NOT NULL default '',
  ContactFirstName varchar(255) default NULL,
  ContactLastName varchar(255) default NULL,
  Address varchar(255) default NULL,
  City varchar(255) default NULL,
  StateProvince varchar(255) default NULL,
  PostalCode varchar(255) default NULL,
  Country varchar(255) default NULL,
  PhoneNumber varchar(20) default NULL,
  FaxNumber varchar(20) default NULL,
  LastModified datetime default '0000-00-00 00:00:00',
  HarvesterURL text,
  HarvesterLastUpdated date default NULL,
  URL varchar(255) NOT NULL default '',
  EducationPageTitle varchar(255) NOT NULL default '',
  EducationPageURL varchar(255) NOT NULL default '',
  PRIMARY KEY  (ID),
  KEY Name (Name),
  KEY ShortName (ShortName)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_ddlb_ContributorRoles'
#

DROP TABLE IF EXISTS tbl_ddlb_ContributorRoles;
CREATE TABLE tbl_ddlb_ContributorRoles (
  ID int(11) NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  Value varchar(255) NOT NULL default '',
  OrderID int(11) NOT NULL default '0',
  Comments text NOT NULL,
  PRIMARY KEY  (ID),
  KEY Name (Name),
  KEY Value (Value),
  KEY OrderID (OrderID)
) TYPE=MyISAM;

#
# Dumping data for table 'tbl_ddlb_ContributorRoles'
#

LOCK TABLES tbl_ddlb_ContributorRoles WRITE;
INSERT INTO tbl_ddlb_ContributorRoles VALUES (1,'Author','Author',10,''),(2,'Publisher','Publisher',20,''),(3,'Editor','Editor',30,''),(4,'Contact','Contact',40,''),(5,'Contributor','Contributor',50,'');
UNLOCK TABLES;

#
# Table structure for table 'tbl_ddlb_Disciplines'
#

DROP TABLE IF EXISTS tbl_ddlb_Disciplines;
CREATE TABLE tbl_ddlb_Disciplines (
  ID int(11) NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  Value varchar(100) NOT NULL default '',
  Comments varchar(255) default NULL,
  PRIMARY KEY  (ID),
  KEY Name (Name),
  KEY Value (Value)
) TYPE=MyISAM;

#
# Dumping data for table 'tbl_ddlb_Disciplines'
#

LOCK TABLES tbl_ddlb_Disciplines WRITE;
INSERT INTO tbl_ddlb_Disciplines VALUES (1,'Agriculture & Aquaculture','Agriculture & Aquaculture',NULL),(2,'Anatomy','Anatomy',NULL),(3,'Anthropology & Archaeology','Anthropology & Archaeology',NULL),(4,'Behavioral Science','Behavioral Science',NULL),(5,'Biochemistry','Biochemistry',NULL),(6,'Bioethics','Bioethics',NULL),(7,'Bioinformatics Genomics & Proteomics','Bioinformatics Genomics & Proteomics',''),(8,'Biophysics','Biophysics',NULL),(9,'Biostatistics','Biostatistics',NULL),(10,'Biotechnology','Biotechnology',NULL),(11,'Botany & Plant Science','Botany & Plant Science',NULL),(12,'Cardiology','Cardiology',NULL),(13,'Cell biology','Cell biology',NULL),(14,'Conservation Biology','Conservation Biology',NULL),(15,'Cryobiology','Cryobiology',NULL),(16,'Developmental Biology','Developmental Biology',NULL),(17,'Ecology','Ecology',NULL),(18,'Education','Education',NULL),(19,'Endocrinology','Endocrinology',NULL),(20,'Entomology','Entomology',NULL),(21,'Environmental Sciences','Environmental Sciences',NULL),(22,'Epidemiology','Epidemiology',NULL),(23,'Evolutionary Biology','Evolutionary Biology',NULL),(24,'Exercise & Kinesiology','Exercise & Kinesiology',NULL),(25,'Exobiology','Exobiology',NULL),(26,'Forestry','Forestry',NULL),(27,'Gastroenterology','Gastroenterology',''),(28,'Genetics & Heredity','Genetics & Heredity',NULL),(29,'Geography','Geography',NULL),(30,'Histology','Histology',NULL),(31,'Human Biology','Human Biology',NULL),(32,'Hydrology & Water Resources','Hydrology & Water Resources',NULL),(33,'Immunology','Immunology',NULL),(34,'Invertebrate Biology','Invertebrate Biology',NULL),(35,'Marine Biology','Marine Biology',NULL),(36,'Microbiology','Microbiology',NULL),(37,'Molecular Biology','Molecular Biology',NULL),(38,'Mycology','Mycology',NULL),(39,'Natural History','Natural History',NULL),(40,'Nephrology','Nephrology',''),(41,'Neurobiology','Neurobiology',NULL),(42,'Nutrition & Food Sciences','Nutrition & Food Sciences',NULL),(43,'Paleontology','Paleontology',NULL),(44,'Parasitology','Parasitology',NULL),(45,'Pathology','Pathology',NULL),(46,'Pharmacology','Pharmacology',NULL),(47,'Phylogeny','Phylogeny',NULL),(48,'Physiology','Physiology',NULL),(49,'Population Biology','Population Biology',NULL),(50,'Psychology','Psychology',NULL),(51,'Reproductive Biology','Reproductive Biology',NULL),(52,'Respiratory Biology','Respiratory Biology',NULL),(53,'Sociobiology','Sociobiology',NULL),(54,'Soil Biology','Soil Biology',NULL),(55,'Systematics','Systematics',NULL),(56,'Taxonomy & Classification','Taxonomy & Classification',NULL),(57,'Theoretical Biology','Theoretical Biology',NULL),(58,'Toxicology','Toxicology',NULL),(59,'Vertebrate Biology','Vertebrate Biology',NULL),(60,'Virology','Virology',NULL),(61,'Zoology','Zoology',NULL),(62,'Genomics','Genomics',NULL),(63,'Proteomics','Proteomics',NULL),(64,'Bacteriology','Bacteriology',NULL),(65,'Public health','Public health',NULL),(66,'Biocomplexity','Biocomplexity',NULL),(67,'Biodiversity','Biodiversity',NULL),(68,'Structural biology','Structural biology',NULL),(69,'Oceanography','Oceanography',NULL),(70,'Hematology','Hematology',NULL),(71,'Bioengineering','Bioengineering',NULL),(72,'Enzymology','Enzymology',NULL),(73,'Glycobiology','Glycobiology',NULL),(74,'Metabolism','Metabolism',NULL),(75,'Wildlife science','Wildlife science',NULL),(76,'Range Science','Range Science',NULL);
UNLOCK TABLES;

#
# Table structure for table 'tbl_ddlb_IntendedEndUserRoles'
#

DROP TABLE IF EXISTS tbl_ddlb_IntendedEndUserRoles;
CREATE TABLE tbl_ddlb_IntendedEndUserRoles (
  ID int(11) NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  Value varchar(255) NOT NULL default '',
  Comments varchar(255) NOT NULL default '',
  PRIMARY KEY  (ID),
  KEY Name (Name),
  KEY Value (Value)
) TYPE=MyISAM;

#
# Dumping data for table 'tbl_ddlb_IntendedEndUserRoles'
#

LOCK TABLES tbl_ddlb_IntendedEndUserRoles WRITE;
INSERT INTO tbl_ddlb_IntendedEndUserRoles VALUES (1,'Teacher','Teacher',''),(2,'Author','Author',''),(3,'Learner','Learner',''),(4,'Manager','Manager','');
UNLOCK TABLES;

#
# Table structure for table 'tbl_ddlb_Languages'
#

DROP TABLE IF EXISTS tbl_ddlb_Languages;
CREATE TABLE tbl_ddlb_Languages (
  ID int(11) NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  Value varchar(50) NOT NULL default '',
  ISOCode varchar(20) NOT NULL default '',
  Comments varchar(255) default NULL,
  PRIMARY KEY  (ID),
  KEY Name (Name),
  KEY Value (Value),
  KEY ISOCode (ISOCode)
) TYPE=MyISAM;

#
# Dumping data for table 'tbl_ddlb_Languages'
#

LOCK TABLES tbl_ddlb_Languages WRITE;
INSERT INTO tbl_ddlb_Languages VALUES (1,'Arabic','ara','ara',''),(2,'Chinese','chi,zho','chi,zho',''),(3,'Czech','cze,ces','cze,ces',''),(4,'Danish','dan','dan',''),(5,'Dutch','dut,nld','dut,nld',''),(6,'English','eng','eng',''),(7,'French','fre,fra','fre,fra',''),(8,'German','ger,deu','ger,deu',''),(9,'Greek','gre,ell','gre,ell',''),(10,'Hebrew','heb','heb',''),(11,'Italian','ita','ita',''),(12,'Japanese','jpn','jpn',''),(13,'Korean','kor','kor',''),(14,'Latin','lat','lat',''),(15,'Multiple languages','mul','mul',''),(16,'Polish','pol','pol',''),(17,'Portuguese','por','por',''),(18,'Russian','rus','rus',''),(19,'Spanish','spa','spa',''),(20,'Swedish','swe','swe',''),(21,'Turkish','tur','tur',''),(22,'Undetermined','und','und',''),(23,'Czech','cze,ces','cze,ces',NULL),(24,'Danish','dan','dan',NULL),(25,'Dutch','dut,nld','dut,nld',NULL),(26,'English','eng','eng',NULL),(27,'French','fre,fra','fre,fra',NULL),(28,'German','ger,deu','ger,deu',NULL),(29,'Greek','gre,ell','gre,ell',NULL),(30,'Hebrew','heb','heb',NULL),(31,'Italian','ita','ita',NULL),(32,'Japanese','jpn','jpn',NULL),(33,'Korean','kor','kor',NULL),(34,'Latin','lat','lat',NULL),(35,'Multiple languages','mul','mul',NULL),(36,'Polish','pol','pol',NULL),(37,'Portuguese','por','por',NULL),(38,'Russian','rus','rus',NULL),(39,'Spanish','spa','spa',NULL),(40,'Swedish','swe','swe',NULL),(41,'Turkish','tur','tur',NULL),(42,'Undetermined','und','und',NULL);
UNLOCK TABLES;

#
# Table structure for table 'tbl_ddlb_LearningResourceContexts'
#

DROP TABLE IF EXISTS tbl_ddlb_LearningResourceContexts;
CREATE TABLE tbl_ddlb_LearningResourceContexts (
  ID int(11) NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  Value varchar(255) NOT NULL default '',
  Comments varchar(255) NOT NULL default '',
  PRIMARY KEY  (ID),
  KEY Name (Name),
  KEY Value (Value)
) TYPE=MyISAM;

#
# Dumping data for table 'tbl_ddlb_LearningResourceContexts'
#

LOCK TABLES tbl_ddlb_LearningResourceContexts WRITE;
INSERT INTO tbl_ddlb_LearningResourceContexts VALUES (1,'Preschool','Preschool',''),(2,'Primary elementary K-2','Primary elementary K-2',''),(3,'Intermediate elementary 3-5','Intermediate elementary 3-5',''),(4,'Middle school 6-8','Middle school 6-8',''),(5,'High school lower division 9-10','High school lower division 9-10',''),(6,'High school upper division 11-12','High school upper division 11-12',''),(7,'Undergraduate lower division 13-14','Undergraduate lower division 13-14',''),(8,'Undergraduate upper division 15-16','Undergraduate upper division 15-16',''),(9,'Graduate','Graduate',''),(10,'Profession (degree program)','Profession (degree program)',''),(11,'General public & informal education','General public & informal education',''),(12,'Continuing education','Continuing education','');
UNLOCK TABLES;

#
# Table structure for table 'tbl_ddlb_LearningResourceTypes'
#

DROP TABLE IF EXISTS tbl_ddlb_LearningResourceTypes;
CREATE TABLE tbl_ddlb_LearningResourceTypes (
  ID int(11) NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  Value varchar(255) NOT NULL default '',
  Comments varchar(255) NOT NULL default '',
  PRIMARY KEY  (ID),
  KEY Name (Name),
  KEY Value (Value)
) TYPE=MyISAM;

#
# Dumping data for table 'tbl_ddlb_LearningResourceTypes'
#

LOCK TABLES tbl_ddlb_LearningResourceTypes WRITE;
INSERT INTO tbl_ddlb_LearningResourceTypes VALUES (1,'<<<< Auditorium - Multimedia >>>>','Invalid1',''),(2,'Animation','Animation',''),(3,'Audio','Audio',''),(4,'Video','Video',''),(5,'Diagram','Diagram',''),(6,'Table','Table',''),(7,'35mm slide','35mm slide',''),(8,'Digital presentation (powerpoint)','Digital presentation (powerpoint)',''),(9,'Illustration','Illustration',''),(10,'Map','Map',''),(11,'Photograph','Photograph',''),(12,'Image','Image',''),(13,'Simulation','Simulation',''),(14,'Application','Application',''),(15,'Discussion group/Listserv','Discussion group/Listserv',''),(16,'Webcast','Webcast',''),(17,'<<<<  Reading Room >>>>','Invalid2',''),(18,'Meeting presentation','Meeting presentation',''),(19,'Proceedings','Proceedings',''),(20,'Book','Book',''),(21,'Book chapter','Book chapter',''),(22,'Journal','Journal',''),(23,'Journal article/Issue','Journal article/Issue',''),(24,'Thesis/Dissertation','Thesis/Dissertation',''),(25,'Report','Report',''),(26,'Memo','Memo',''),(27,'Newsletter','Newsletter',''),(28,'Non-journal article','Non-journal article',''),(29,'Pamphlet/Brochure','Pamphlet/Brochure',''),(30,'<<<<  Reference Room >>>>','Invalid3',''),(31,'Bibliography','Bibliography',''),(32,'Index','Index',''),(33,'Dataset','Dataset',''),(34,'Dictionary/Glossary','Dictionary/Glossary',''),(35,'Thesaurus','Thesaurus',''),(36,'Discussion group/Listserv archive','Discussion group/Listserv archive',''),(37,'Manual','Manual',''),(38,'Scientific standards and guidelines','Scientific standards and guidelines',''),(39,'Review','Review',''),(40,'<<<< Classroom >>>>','Invalid4',''),(41,'Educational standards','Educational standards',''),(42,'Teaching strategies & guidelines','Teaching strategies & guidelines',''),(43,'Course syllabus','Course syllabus',''),(44,'Lesson plan','Lesson plan',''),(45,'Lecture/Lecture outline','Lecture/Lecture outline',''),(46,'Laboratory exercise','Laboratory exercise',''),(47,'Laboratory manual','Laboratory manual',''),(48,'Assignment/Activity (non-laboratory)','Assignment/Activity (non-laboratory)',''),(49,'Assessment- tool','Assessment- tool',''),(50,'Assessment- exam with answer key','Assessment- exam with answer key',''),(51,'Assessment- exam without answer key','Assessment- exam without answer key',''),(52,'Assessment- other','Assessment- other',''),(53,'Fieldtrip guide','Fieldtrip guide','');
UNLOCK TABLES;

#
# Table structure for table 'tbl_ddlb_PedagogicalUses'
#

DROP TABLE IF EXISTS tbl_ddlb_PedagogicalUses;
CREATE TABLE tbl_ddlb_PedagogicalUses (
  ID int(11) NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  Value varchar(255) NOT NULL default '',
  Comments varchar(255) NOT NULL default '',
  PRIMARY KEY  (ID),
  KEY Name (Name),
  KEY Value (Value)
) TYPE=MyISAM;

#
# Dumping data for table 'tbl_ddlb_PedagogicalUses'
#

LOCK TABLES tbl_ddlb_PedagogicalUses WRITE;
INSERT INTO tbl_ddlb_PedagogicalUses VALUES (1,'Assess','Assess',''),(2,'Learn','Learn',''),(3,'Research','Research',''),(4,'Plan','Plan',''),(5,'Teach','Teach','');
UNLOCK TABLES;

#
# Table structure for table 'tbl_ddlb_PrincipalUsers'
#

DROP TABLE IF EXISTS tbl_ddlb_PrincipalUsers;
CREATE TABLE tbl_ddlb_PrincipalUsers (
  ID int(11) NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  Value varchar(255) NOT NULL default '',
  Comments varchar(255) NOT NULL default '',
  PRIMARY KEY  (ID),
  KEY Name (Name),
  KEY Value (Value)
) TYPE=MyISAM;

#
# Dumping data for table 'tbl_ddlb_PrincipalUsers'
#

LOCK TABLES tbl_ddlb_PrincipalUsers WRITE;
INSERT INTO tbl_ddlb_PrincipalUsers VALUES (1,'Teacher','Teacher',''),(2,'Author','Author',''),(3,'Learner','Learner',''),(4,'Manager','Manager','');
UNLOCK TABLES;

#
# Table structure for table 'tbl_ddlb_YesNo'
#

DROP TABLE IF EXISTS tbl_ddlb_YesNo;
CREATE TABLE tbl_ddlb_YesNo (
  ID int(11) NOT NULL auto_increment,
  Name varchar(255) NOT NULL default '',
  Value varchar(255) NOT NULL default '',
  Comments varchar(255) default NULL,
  PRIMARY KEY  (ID),
  KEY Name (Name),
  KEY Value (Value)
) TYPE=MyISAM;

#
# Dumping data for table 'tbl_ddlb_YesNo'
#

LOCK TABLES tbl_ddlb_YesNo WRITE;
INSERT INTO tbl_ddlb_YesNo VALUES (1,'Yes','Yes',NULL),(2,'No','No',NULL);
UNLOCK TABLES;

#
# Table structure for table 'tbl_ddlb_usersListSortCriteria'
#

DROP TABLE IF EXISTS tbl_ddlb_usersListSortCriteria;
CREATE TABLE tbl_ddlb_usersListSortCriteria (
  ID int(11) NOT NULL auto_increment,
  Value varchar(100) NOT NULL default '',
  Name varchar(100) NOT NULL default '',
  OrderID int(11) NOT NULL default '0',
  Comment text NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

#
# Dumping data for table 'tbl_ddlb_usersListSortCriteria'
#

LOCK TABLES tbl_ddlb_usersListSortCriteria WRITE;
INSERT INTO tbl_ddlb_usersListSortCriteria VALUES (1,'organization','Organization',10,''),(2,'firstName','First Name',20,''),(3,'lastName','Last Name',30,''),(4,'country','Country',40,''),(5,'stateProvince','State/Province',50,'');
UNLOCK TABLES;

#
# Table structure for table 'tbl_meta_annotation'
#

DROP TABLE IF EXISTS tbl_meta_annotation;
CREATE TABLE tbl_meta_annotation (
  id int(10) unsigned NOT NULL auto_increment,
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  person text,
  date datetime default NULL,
  description text,
  PRIMARY KEY  (id),
  KEY recordID (recordID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_classification'
#

DROP TABLE IF EXISTS tbl_meta_classification;
CREATE TABLE tbl_meta_classification (
  id int(10) unsigned NOT NULL auto_increment,
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  purpose varchar(255) default NULL,
  description text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY purpose (purpose)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_classification_keywords'
#

DROP TABLE IF EXISTS tbl_meta_classification_keywords;
CREATE TABLE tbl_meta_classification_keywords (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  value char(255) default NULL,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY value (value)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_classification_taxonPath'
#

DROP TABLE IF EXISTS tbl_meta_classification_taxonPath;
CREATE TABLE tbl_meta_classification_taxonPath (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  source char(255) default NULL,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY source (source)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_classification_taxonPath_taxon'
#

DROP TABLE IF EXISTS tbl_meta_classification_taxonPath_taxon;
CREATE TABLE tbl_meta_classification_taxonPath_taxon (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  identifier varchar(64) default NULL,
  entry varchar(255) default NULL,
  datetime datetime default NULL,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY identifier (identifier),
  KEY entry (entry)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_educational'
#

DROP TABLE IF EXISTS tbl_meta_educational;
CREATE TABLE tbl_meta_educational (
  id int(10) unsigned NOT NULL auto_increment,
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  interactivityType text,
  interactivityLevel text,
  semanticDensity text,
  difficulty text,
  typicalLearningTime text,
  description text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY description (description(250))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_educational_context'
#

DROP TABLE IF EXISTS tbl_meta_educational_context;
CREATE TABLE tbl_meta_educational_context (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  value text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY value (value(64))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_educational_intendedEndUserRole'
#

DROP TABLE IF EXISTS tbl_meta_educational_intendedEndUserRole;
CREATE TABLE tbl_meta_educational_intendedEndUserRole (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  value text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY value (value(32))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_educational_language'
#

DROP TABLE IF EXISTS tbl_meta_educational_language;
CREATE TABLE tbl_meta_educational_language (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  value text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_educational_learningResourceType'
#

DROP TABLE IF EXISTS tbl_meta_educational_learningResourceType;
CREATE TABLE tbl_meta_educational_learningResourceType (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  value text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY value (value(32))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_educational_typicalAgeRange'
#

DROP TABLE IF EXISTS tbl_meta_educational_typicalAgeRange;
CREATE TABLE tbl_meta_educational_typicalAgeRange (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  value text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY value (value(32))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_general'
#

DROP TABLE IF EXISTS tbl_meta_general;
CREATE TABLE tbl_meta_general (
  id int(10) unsigned NOT NULL auto_increment,
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  identifier text,
  title text NOT NULL,
  description text,
  structure text,
  aggregationLevel text,
  userID int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY title (title(250)),
  KEY description (description(250))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_general_catalogEntry'
#

DROP TABLE IF EXISTS tbl_meta_general_catalogEntry;
CREATE TABLE tbl_meta_general_catalogEntry (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  catalog text,
  entry text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_general_coverage'
#

DROP TABLE IF EXISTS tbl_meta_general_coverage;
CREATE TABLE tbl_meta_general_coverage (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  value text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_general_description'
#

DROP TABLE IF EXISTS tbl_meta_general_description;
CREATE TABLE tbl_meta_general_description (
   id int(10) unsigned NOT NULL auto_increment,
   parentID int(10) unsigned NOT NULL default '0',
   recordID int(10) unsigned NOT NULL default '0',
   datetime datetime default NULL,
   value text,
   PRIMARY KEY  (id),
   KEY recordID (recordID),
   KEY parentID (parentID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_general_keywords'
#

DROP TABLE IF EXISTS tbl_meta_general_keywords;
CREATE TABLE tbl_meta_general_keywords (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  value text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY value (value(250))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_general_language'
#

DROP TABLE IF EXISTS tbl_meta_general_language;
CREATE TABLE tbl_meta_general_language (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  value text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY value (value(10))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_lifeCycle'
#

DROP TABLE IF EXISTS tbl_meta_lifeCycle;
CREATE TABLE tbl_meta_lifeCycle (
  id int(10) unsigned NOT NULL auto_increment,
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  version text,
  status text,
  PRIMARY KEY  (id),
  KEY recordID (recordID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_lifeCycle_contribute'
#

DROP TABLE IF EXISTS tbl_meta_lifeCycle_contribute;
CREATE TABLE tbl_meta_lifeCycle_contribute (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  role text,
  date date default NULL,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY role (role(32))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_lifeCycle_contribute_entity'
#

DROP TABLE IF EXISTS tbl_meta_lifeCycle_contribute_entity;
CREATE TABLE tbl_meta_lifeCycle_contribute_entity (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  name text,
  institution text,
  department text,
  stateProvince text,
  vCard text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY name (name(64)),
  KEY institution (institution(64)),
  KEY department (department(32)),
  KEY stateProvince (stateProvince(32)),
  KEY vCard (vCard(64))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_metaMetadata'
#

DROP TABLE IF EXISTS tbl_meta_metaMetadata;
CREATE TABLE tbl_meta_metaMetadata (
  id int(10) unsigned NOT NULL auto_increment,
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  identifier text,
  PRIMARY KEY  (id),
  KEY recordID (recordID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_metaMetadata_catalogEntry'
#

DROP TABLE IF EXISTS tbl_meta_metaMetadata_catalogEntry;
CREATE TABLE tbl_meta_metaMetadata_catalogEntry (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  catalog text,
  entry text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_metaMetadata_contribute'
#

DROP TABLE IF EXISTS tbl_meta_metaMetadata_contribute;
CREATE TABLE tbl_meta_metaMetadata_contribute (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  role text,
  date date default NULL,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY role (role(32))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_metaMetadata_contribute_entity'
#

DROP TABLE IF EXISTS tbl_meta_metaMetadata_contribute_entity;
CREATE TABLE tbl_meta_metaMetadata_contribute_entity (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  name text,
  institution text,
  department text,
  stateProvince text,
  vCard text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY name (name(64)),
  KEY institution (institution(64)),
  KEY department (department(32)),
  KEY stateProvince (stateProvince(32)),
  KEY vCard (vCard(64))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_metaMetadata_language'
#

DROP TABLE IF EXISTS tbl_meta_metaMetadata_language;
CREATE TABLE tbl_meta_metaMetadata_language (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  value text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_metaMetadata_metadataScheme'
#

DROP TABLE IF EXISTS tbl_meta_metaMetadata_metadataScheme;
CREATE TABLE tbl_meta_metaMetadata_metadataScheme (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  value text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_records'
#

DROP TABLE IF EXISTS tbl_meta_records;
CREATE TABLE tbl_meta_records (
  recordID int(10) unsigned NOT NULL auto_increment,
  dateCreated date NOT NULL default '0000-00-00',
  timeCreated time default NULL,
  dateModified date NOT NULL default '0000-00-00',
  timeModified time default NULL,
  PRIMARY KEY  (recordID),
  KEY dateCreated (dateCreated,dateModified),
  KEY dateCreated_2 (dateCreated),
  KEY dateModified (dateModified)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_relation'
#

DROP TABLE IF EXISTS tbl_meta_relation;
CREATE TABLE tbl_meta_relation (
  id int(10) unsigned NOT NULL auto_increment,
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  kind text,
  PRIMARY KEY  (id),
  KEY recordID (recordID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_relation_resource'
#

DROP TABLE IF EXISTS tbl_meta_relation_resource;
CREATE TABLE tbl_meta_relation_resource (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  identifier text,
  description text,
  PRIMARY KEY (id),
  KEY recordID (recordID),
  KEY parentID (parentID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_relation_resource_catalogyEntry'
#

DROP TABLE IF EXISTS tbl_meta_relation_resource_catalogyEntry;
CREATE TABLE tbl_meta_relation_resource_catalogyEntry (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  catalog text,
  entry text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_rights'
#

DROP TABLE IF EXISTS tbl_meta_rights;
CREATE TABLE tbl_meta_rights (
  id int(10) unsigned NOT NULL auto_increment,
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  cost text,
  copyrightAndOtherRestrictions text,
  description text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY cost (cost(32)),
  KEY copyrightAndOtherRestrictions (copyrightAndOtherRestrictions(32)),
  KEY description (description(32))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_technical'
#

DROP TABLE IF EXISTS tbl_meta_technical;
CREATE TABLE tbl_meta_technical (
  id int(10) unsigned NOT NULL auto_increment,
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  size bigint(20) default NULL,
  installationRemarks text,
  otherPlatformRequirements text,
  duration text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY size (size)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_technical_format'
#

DROP TABLE IF EXISTS tbl_meta_technical_format;
CREATE TABLE tbl_meta_technical_format (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  value text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY value (value(32))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_technical_location'
#

DROP TABLE IF EXISTS tbl_meta_technical_location;
CREATE TABLE tbl_meta_technical_location (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  value text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID),
  KEY value (value(32))
) TYPE=MyISAM;

#
# Table structure for table 'tbl_meta_technical_requirements'
#

DROP TABLE IF EXISTS tbl_meta_technical_requirements;
CREATE TABLE tbl_meta_technical_requirements (
  id int(10) unsigned NOT NULL auto_increment,
  parentID int(10) unsigned NOT NULL default '0',
  recordID int(10) unsigned NOT NULL default '0',
  datetime datetime default NULL,
  type text,
  name text,
  minimumVersion text,
  maximumVersion text,
  PRIMARY KEY  (id),
  KEY recordID (recordID),
  KEY parentID (parentID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_useractions'
#

DROP TABLE IF EXISTS tbl_useractions;
CREATE TABLE tbl_useractions (
  actionID int(11) NOT NULL auto_increment,
  permissionLevel tinyint(4) NOT NULL default '4',
  actionName varchar(255) NOT NULL default '',
  PRIMARY KEY  (actionID),
  UNIQUE KEY actionName (actionName),
  KEY permissionLevel (permissionLevel),
  KEY actionName_2 (actionName)
) TYPE=MyISAM;

#
# Dumping data for table 'tbl_useractions'
#

LOCK TABLES tbl_useractions WRITE;
INSERT INTO tbl_useractions VALUES (1,15,'search'),(2,15,'register'),(3,12,'viewRecords'),(4,12,'viewResources'),(5,9,'suggestResource'),(6,6,'viewNewResources'),(7,6,'reviewNewResources'),(8,6,'approveNewResources'),(9,6,'editOwnResources'),(10,6,'disapproveOwnResources'),(11,3,'disapproveAllResources'),(12,3,'editAllResources'),(13,3,'deleteResource'),(14,3,'addUser'),(15,3,'editUser'),(16,3,'deleteUser'),(17,3,'administer'),(18,3,'administerHarvester'),(19,6,'editLimitedResources');
UNLOCK TABLES;

#
# Table structure for table 'tbl_userclasses'
#

DROP TABLE IF EXISTS tbl_userclasses;
CREATE TABLE tbl_userclasses (
  classID tinyint(4) NOT NULL auto_increment,
  permissionLevel tinyint(4) NOT NULL default '0',
  className varchar(128) NOT NULL default '',
  PRIMARY KEY  (classID),
  UNIQUE KEY className (className),
  KEY permissionLevel (permissionLevel)
) TYPE=MyISAM;

#
# Dumping data for table 'tbl_userclasses'
#

LOCK TABLES tbl_userclasses WRITE;
INSERT INTO tbl_userclasses VALUES (1,3,'administrator'),(2,6,'validator'),(3,9,'beta'),(4,9,'contributor'),(5,12,'searcher'),(6,15,'guest');
UNLOCK TABLES;

#
# Table structure for table 'tbl_usergroupclasses'
#

DROP TABLE IF EXISTS tbl_usergroupclasses;
CREATE TABLE tbl_usergroupclasses (
  groupID int(11) NOT NULL auto_increment,
  groupName varchar(255) NOT NULL default '',
  PRIMARY KEY  (groupID)
) TYPE=MyISAM;

#
# Table structure for table 'tbl_users'
#

DROP TABLE IF EXISTS tbl_users;
CREATE TABLE tbl_users (
  userID int(11) NOT NULL auto_increment,
  email varchar(255) NOT NULL default '',
  password varchar(128) default NULL,
  lastName text,
  firstName text,
  middleName text,
  namePrefix text,
  title text,
  organization text,
  department text,
  phoneNumber text,
  mailAddress text,
  stateProvince text,
  country text,
  vCard text,
  userClass tinyint(4) NOT NULL default '6',
  city text,
  postalCode varchar(32) default NULL,
  faxNumber text,
  teachingAudience text,
  vCardVersion varchar(12) NOT NULL default '2.1',
  lastModified datetime NOT NULL default '0000-00-00 00:00:00',
  groupID int(11) NOT NULL default '1',
  registerDate date NOT NULL default '0000-00-00',
  discoverBEN text,
  PRIMARY KEY  (userID),
  UNIQUE KEY email (email),
  KEY lastName (lastName(32)),
  KEY firstName (firstName(32)),
  KEY namePrefix (namePrefix(32)),
  KEY title (title(32)),
  KEY organization (organization(32)),
  KEY department (department(32)),
  KEY stateProvince (stateProvince(32)),
  KEY country (country(32)),
  KEY city (city(32)),
  KEY teachingAudience (teachingAudience(32)),
  KEY discoverBEN (discoverBEN(32)),
  KEY userClass (userClass),
  KEY postalCode (postalCode),
  KEY lastModified (lastModified),
  KEY groupID (groupID),
  KEY registerDate (registerDate)
) TYPE=MyISAM;