schema_v4.sql 7.18 KB
-- MySQL dump 10.13  Distrib 5.5.22, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: metarepository
-- ------------------------------------------------------
-- Server version	5.5.22-0ubuntu1

/*!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 `deleted_documents`
--

DROP TABLE IF EXISTS `deleted_documents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `deleted_documents` (
  `deleted_id` varchar(255) NOT NULL,
  `delition_date` datetime DEFAULT NULL,
  PRIMARY KEY (`deleted_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `document_set`
--

DROP TABLE IF EXISTS `document_set`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `document_set` (
  `document_id` varchar(255) DEFAULT NULL,
  `set_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `documents`
--

DROP TABLE IF EXISTS `documents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `documents` (
  `id` varchar(255) NOT NULL,
  `harvested_date` datetime DEFAULT NULL,
  `harvest_event` datetime DEFAULT NULL,
  `archive_id` varchar(255) NOT NULL,
  `titles` longtext,
  `creators` longtext,
  `subjects` longtext,
  `descriptions` longtext,
  `publishers` longtext,
  `contributors` longtext,
  `dates` longtext,
  `types` longtext,
  `formats` longtext,
  `identifiers` longtext,
  `sources` longtext,
  `languages` longtext,
  `relations` longtext,
  `coverages` longtext,
  `rights` longtext,
  `alltext` longtext,
  `parsed` tinyint(1) DEFAULT '0',
  `document_issue_date` varchar(255) DEFAULT NULL,
  `document_link` varchar(300) DEFAULT NULL,
  `document_type` varchar(255) DEFAULT NULL,
  `document_language` varchar(255) DEFAULT NULL,
  `document_views` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `archiveid` (`archive_id`),
  KEY `document_views_index` (`document_views`) USING BTREE,
  FULLTEXT KEY `creators` (`creators`),
  FULLTEXT KEY `titles` (`titles`),
  FULLTEXT KEY `descriptions` (`descriptions`),
  FULLTEXT KEY `subjects` (`subjects`),
  FULLTEXT KEY `dates` (`dates`),
  FULLTEXT KEY `types` (`types`),
  FULLTEXT KEY `document_issue_date` (`document_issue_date`),
  FULLTEXT KEY `alltext` (`alltext`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `historic`
--

DROP TABLE IF EXISTS `historic`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `historic` (
  `archive_id` varchar(255) DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  `month` int(11) DEFAULT NULL,
  `day` int(11) DEFAULT NULL,
  `documents` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `problems`
--

DROP TABLE IF EXISTS `problems`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `problems` (
  `document_id` varchar(255) DEFAULT NULL,
  `problem` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `repositories`
--

DROP TABLE IF EXISTS `repositories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `repositories` (
  `arcid` varchar(255) NOT NULL,
  `allsets` tinyint(1) DEFAULT '1',
  `harvesting` tinyint(1) DEFAULT '0',
  `oaiurl` varchar(255) DEFAULT NULL,
  `homepage` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description_en` varchar(1000) DEFAULT NULL,
  `description_pt` varchar(1000) DEFAULT NULL,
  `active` tinyint(1) DEFAULT '0',
  `version` varchar(20) DEFAULT '2.0',
  `adminemail` varchar(255) DEFAULT NULL,
  `harvest_method` varchar(50) NOT NULL,
  `last_harvest` datetime DEFAULT NULL,
  `metadata_format` varchar(50) DEFAULT 'oai_dc',
  `resumption_token` varchar(255) DEFAULT NULL,
  `harvested` tinyint(1) DEFAULT '0',
  `order` int(11) DEFAULT '0',
  `full_text` tinyint(1) DEFAULT '0',
  `country` varchar(50) DEFAULT 'portugal',
  `tags_pt` varchar(500) DEFAULT '',
  `tags_en` varchar(500) DEFAULT '',
  `directoryURL` varchar(100) DEFAULT '',
  `degois` tinyint(1) DEFAULT '0',
  `openAire` tinyint(1) DEFAULT '0',
  `driver` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`arcid`),
  KEY `country_index` (`country`),
  KEY `active_index` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sets`
--

DROP TABLE IF EXISTS `sets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `archive_id` varchar(255) DEFAULT NULL,
  `set_name` varchar(255) DEFAULT NULL,
  `set_spec` varchar(255) DEFAULT NULL,
  `active` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12777 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tagcloudsearch`
--

DROP TABLE IF EXISTS `tagcloudsearch`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tagcloudsearch` (
  `word` varchar(255) DEFAULT NULL,
  `count` int(11) DEFAULT '1',
  `hidden` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tagcloudsubject`
--

DROP TABLE IF EXISTS `tagcloudsubject`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tagcloudsubject` (
  `word` varchar(255) DEFAULT NULL,
  `count` int(11) DEFAULT '1',
  `hidden` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2012-05-07 14:49:57