-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-11
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 01, 2010 at 02:07 PM
-- Server version: 5.0.32
-- PHP Version: 5.2.0-8+etch16
-- 
-- Database: `ben_default`
-- 

-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_Partners`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `tbl_ddlb_ContributorRoles`
-- 

INSERT INTO `tbl_ddlb_ContributorRoles` (`ID`, `Name`, `Value`, `OrderID`, `Comments`) VALUES 
(1, 'Author', 'Author', 10, ''),
(2, 'Publisher', 'Publisher', 20, ''),
(3, 'Editor', 'Editor', 30, ''),
(4, 'Contact', 'Contact', 40, ''),
(5, 'Contributor', 'Contributor', 50, '');

-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=77 ;

-- 
-- Dumping data for table `tbl_ddlb_Disciplines`
-- 

INSERT INTO `tbl_ddlb_Disciplines` (`ID`, `Name`, `Value`, `Comments`) 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);

-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `tbl_ddlb_IntendedEndUserRoles`
-- 

INSERT INTO `tbl_ddlb_IntendedEndUserRoles` (`ID`, `Name`, `Value`, `Comments`) VALUES 
(1, 'Teacher', 'Teacher', ''),
(2, 'Author', 'Author', ''),
(3, 'Learner', 'Learner', ''),
(4, 'Manager', 'Manager', '');

-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

-- 
-- Dumping data for table `tbl_ddlb_Languages`
-- 

INSERT INTO `tbl_ddlb_Languages` (`ID`, `Name`, `Value`, `ISOCode`, `Comments`) 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);

-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

-- 
-- Dumping data for table `tbl_ddlb_LearningResourceContexts`
-- 

INSERT INTO `tbl_ddlb_LearningResourceContexts` (`ID`, `Name`, `Value`, `Comments`) 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', '');

-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ;

-- 
-- Dumping data for table `tbl_ddlb_LearningResourceTypes`
-- 

INSERT INTO `tbl_ddlb_LearningResourceTypes` (`ID`, `Name`, `Value`, `Comments`) 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', ''),
(54, 'Biography', 'Biography', '');

-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `tbl_ddlb_PedagogicalUses`
-- 

INSERT INTO `tbl_ddlb_PedagogicalUses` (`ID`, `Name`, `Value`, `Comments`) VALUES 
(1, 'Assess', 'Assess', ''),
(2, 'Learn', 'Learn', ''),
(3, 'Research', 'Research', ''),
(4, 'Plan', 'Plan', ''),
(5, 'Teach', 'Teach', '');

-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `tbl_ddlb_PrincipalUsers`
-- 

INSERT INTO `tbl_ddlb_PrincipalUsers` (`ID`, `Name`, `Value`, `Comments`) VALUES 
(1, 'Teacher', 'Teacher', ''),
(2, 'Author', 'Author', ''),
(3, 'Learner', 'Learner', ''),
(4, 'Manager', 'Manager', '');

-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `tbl_ddlb_YesNo`
-- 

INSERT INTO `tbl_ddlb_YesNo` (`ID`, `Name`, `Value`, `Comments`) VALUES 
(1, 'Yes', 'Yes', NULL),
(2, 'No', 'No', NULL);

-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `tbl_ddlb_usersListSortCriteria`
-- 

INSERT INTO `tbl_ddlb_usersListSortCriteria` (`ID`, `Value`, `Name`, `OrderID`, `Comment`) VALUES 
(1, 'organization', 'Organization', 10, ''),
(2, 'firstName', 'First Name', 20, ''),
(3, 'lastName', 'Last Name', 30, ''),
(4, 'country', 'Country', 40, ''),
(5, 'stateProvince', 'State/Province', 50, '');

-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_annotation`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_classification`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_classification_keywords`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_classification_taxonPath`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_classification_taxonPath_taxon`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_educational`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_educational_context`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_educational_intendedEndUserRole`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_educational_language`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_educational_learningResourceType`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_educational_typicalAgeRange`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_general`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_general_catalogEntry`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_general_coverage`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_general_description`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_general_keywords`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_general_language`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_lifeCycle`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_lifeCycle_contribute`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_lifeCycle_contribute_entity`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_metaMetadata`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_metaMetadata_catalogEntry`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_metaMetadata_contribute`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_metaMetadata_contribute_entity`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_metaMetadata_language`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_metaMetadata_metadataScheme`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_records`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_relation`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_relation_resource`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_relation_resource_catalogyEntry`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_rights`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_technical`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_technical_format`
-- 


-- --------------------------------------------------------

-- 
-- 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))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_technical_location`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_meta_technical_requirements`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

-- 
-- Dumping data for table `tbl_useractions`
-- 

INSERT INTO `tbl_useractions` (`actionID`, `permissionLevel`, `actionName`) 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');

-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `tbl_userclasses`
-- 

INSERT INTO `tbl_userclasses` (`classID`, `permissionLevel`, `className`) VALUES 
(1, 3, 'administrator'),
(2, 6, 'validator'),
(3, 9, 'beta'),
(4, 9, 'contributor'),
(5, 12, 'searcher'),
(6, 15, 'guest');

-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_usergroupclasses`
-- 


-- --------------------------------------------------------

-- 
-- 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `tbl_users`
--