-- MySQL dump 10.11 -- -- Host: localhost Database: lbc_test -- ------------------------------------------------------ -- Server version 5.0.77-log /*!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 `Keyword` -- DROP TABLE IF EXISTS `Keyword`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `Keyword` ( `id` int(10) unsigned NOT NULL default '0', `title` varchar(100) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `title` (`title`), FULLTEXT KEY `title_2` (`title`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `Keyword` -- LOCK TABLES `Keyword` WRITE; /*!40000 ALTER TABLE `Keyword` DISABLE KEYS */; INSERT INTO `Keyword` VALUES (541,'Arthur Scargill'); /*!40000 ALTER TABLE `Keyword` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `LbcTitle` -- DROP TABLE IF EXISTS `LbcTitle`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `LbcTitle` ( `id` int(10) unsigned NOT NULL default '0', `title` text NOT NULL, `notes` text, `date` varchar(10) default NULL, PRIMARY KEY (`id`), FULLTEXT KEY `title` (`title`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `LbcTitle` -- LOCK TABLES `LbcTitle` WRITE; /*!40000 ALTER TABLE `LbcTitle` DISABLE KEYS */; INSERT INTO `LbcTitle` VALUES (26416,'Miners strike - Film censored','','1984'),(26432,'Miners strike - Len Murray on picket line violence','','1984'),(26656,'Miners strike - Policing of Nottinghamshire mines','','1984'),(26672,'Miners strike - Pickets getting more violent','','1984'),(26704,'Miners strike - Tony Benn on media coverage','','1984'),(26720,'Miners strike - Roy Hattersley view','','1984'),(26736,'Miners strike - Scargill claims power stations will run out of coal','','1984'),(26800,'Miners strike - Leaked letters on government\'s involvement','','1984'),(26864,'Miners strike - Pickets at Orgreave steel plant','','1984'),(26896,'Miners strike - Ambulance crews don riot gear on picket lines','','1984'),(26912,'Miners strike - Peter Wright on violence','','1984'),(26944,'Miners strike - Ian MacGregor and Arthur Scargill on Channel 4 News','','1984'),(26960,'Miners strike - Rally at Saltley','','1984'),(27072,'Miners strike -Scargill-MacGregor TV debate','ITN Channel 4 news programme excerpt.','1984'),(27136,'Miners strike - NUM fined for contempt of court','','1984'),(27152,'Miners strike - Dover dockers support','','1984'),(27248,'Miners strike - Thatcher shows support for Ian MacGregor','','1984'),(27312,'Miners strike - Scargill on talks','','1984'),(27392,'Miners strike - Latest developments','','1984'),(27408,'Miners strike - NUM meets with Libyans','','1984'),(27488,'Robert Runcie on social change and violence in miners strike','','1984'),(27504,'Miners strike - Peter Walker view','','1984'),(27568,'Miners strike - Return to work offer','','1984'),(27664,'Miners strike - Michael Eaton gives back to work figures','','1984'),(27712,'Miners strike - Returning miners speak out','','1984'),(27728,'Miners strike - NUM funds with sequestrators','','1984'),(27792,'Miners strike - David Wilkie death','','1984'),(27888,'Miners strike - Arthur Scargill on Christmas Day picketing','','1984'); /*!40000 ALTER TABLE `LbcTitle` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `TitleKeyword` -- DROP TABLE IF EXISTS `TitleKeyword`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `TitleKeyword` ( `title_id` int(10) unsigned NOT NULL default '0', `keyword_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`title_id`,`keyword_id`), KEY `keyword_id` (`keyword_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `TitleKeyword` -- LOCK TABLES `TitleKeyword` WRITE; /*!40000 ALTER TABLE `TitleKeyword` DISABLE KEYS */; INSERT INTO `TitleKeyword` VALUES (26416,541),(26720,541),(26944,541),(26960,541),(27392,541),(27408,541),(27504,541),(27728,541),(27888,541); /*!40000 ALTER TABLE `TitleKeyword` 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 2009-10-08 17:39:00