-- MySQL dump 10.11
--
-- Host: localhost Database: oaicatdemo
-- ------------------------------------------------------
-- Server version 5.0.51b-community-nt
/*!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 `about_list`
--
DROP TABLE IF EXISTS `about_list`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `about_list` (
`about_ID` int(11) NOT NULL auto_increment,
`about_value` varchar(50) default NULL,
PRIMARY KEY (`about_ID`),
KEY `about_ID` (`about_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `metadata_record`
--
DROP TABLE IF EXISTS `metadata_record`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `metadata_record` (
`local_identifier` varchar(50) NOT NULL,
`timestamp` datetime default NULL,
`xml` text,
PRIMARY KEY (`local_identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `metadata_record`
--
LOCK TABLES `metadata_record` WRITE;
/*!40000 ALTER TABLE `metadata_record` DISABLE KEYS */;
INSERT INTO `metadata_record` VALUES ('oai/1','2007-06-27 17:57:38','TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTexteText'),('oai/2','2007-06-27 17:57:38','TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTexteText'),('oai/3','2007-06-27 17:57:39','TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTexteText'),('oai/4','2007-06-27 17:57:39','TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTexteText'),('oai/5','2007-06-27 17:57:40','TextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTextTexteText');
/*!40000 ALTER TABLE `metadata_record` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `record_about_map`
--
DROP TABLE IF EXISTS `record_about_map`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `record_about_map` (
`local_identifier` varchar(50) NOT NULL,
`about_ID` int(11) NOT NULL default '0',
PRIMARY KEY (`local_identifier`,`about_ID`),
KEY `about_ID` (`about_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `record_set_map`
--
DROP TABLE IF EXISTS `record_set_map`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `record_set_map` (
`local_identifier` varchar(50) NOT NULL,
`set_spec` varchar(50) NOT NULL,
PRIMARY KEY (`local_identifier`,`set_spec`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `record_set_map`
--
LOCK TABLES `record_set_map` WRITE;
/*!40000 ALTER TABLE `record_set_map` DISABLE KEYS */;
INSERT INTO `record_set_map` VALUES ('oai/1','SET1'),('oai/2','SET2'),('oai/3','SET3'),('oai/4','SET4'),('oai/5','SET4');
/*!40000 ALTER TABLE `record_set_map` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `set_list`
--
DROP TABLE IF EXISTS `set_list`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `set_list` (
`set_spec` varchar(50) NOT NULL,
`set_name` varchar(50) default NULL,
`set_description` varchar(50) default NULL,
PRIMARY KEY (`set_spec`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `set_list`
--
LOCK TABLES `set_list` WRITE;
/*!40000 ALTER TABLE `set_list` DISABLE KEYS */;
INSERT INTO `set_list` VALUES ('SET1','First set','Demonstration set'),('SET2','Second set','Demonstration set'),('SET3','Third set','Demonstration set'),('SET4','Fourth set','Demonstration set');
/*!40000 ALTER TABLE `set_list` 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 2008-08-13 22:40:01