-- MySQL dump 10.10
--
-- Host: localhost    Database: clue
-- ------------------------------------------------------
-- Server version	5.0.24a-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 `didit`
--

DROP TABLE IF EXISTS `didit`;
CREATE TABLE `didit` (
  `pid` int(11) NOT NULL default '0',
  `rid` int(11) NOT NULL default '0',
  `wid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pid`,`rid`,`wid`),
  KEY `rid` (`rid`),
  KEY `wid` (`wid`),
  CONSTRAINT `didit_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `people` (`pid`),
  CONSTRAINT `didit_ibfk_2` FOREIGN KEY (`rid`) REFERENCES `rooms` (`rid`),
  CONSTRAINT `didit_ibfk_3` FOREIGN KEY (`wid`) REFERENCES `weapons` (`wid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `didit`
--


/*!40000 ALTER TABLE `didit` DISABLE KEYS */;
LOCK TABLES `didit` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `didit` ENABLE KEYS */;

--
-- Table structure for table `hastouched`
--

DROP TABLE IF EXISTS `hastouched`;
CREATE TABLE `hastouched` (
  `pid` int(11) NOT NULL default '0',
  `wid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pid`,`wid`),
  KEY `wid` (`wid`),
  CONSTRAINT `hastouched_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `people` (`pid`),
  CONSTRAINT `hastouched_ibfk_2` FOREIGN KEY (`wid`) REFERENCES `weapons` (`wid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hastouched`
--


/*!40000 ALTER TABLE `hastouched` DISABLE KEYS */;
LOCK TABLES `hastouched` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `hastouched` ENABLE KEYS */;

--
-- Table structure for table `knows`
--

DROP TABLE IF EXISTS `knows`;
CREATE TABLE `knows` (
  `person_1` int(11) NOT NULL default '0',
  `person_2` int(11) NOT NULL default '0',
  `duration` int(11) default NULL,
  PRIMARY KEY  (`person_1`,`person_2`),
  KEY `person_2` (`person_2`),
  CONSTRAINT `knows_ibfk_1` FOREIGN KEY (`person_1`) REFERENCES `people` (`pid`),
  CONSTRAINT `knows_ibfk_2` FOREIGN KEY (`person_2`) REFERENCES `people` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `knows`
--


/*!40000 ALTER TABLE `knows` DISABLE KEYS */;
LOCK TABLES `knows` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `knows` ENABLE KEYS */;

--
-- Table structure for table `people`
--

DROP TABLE IF EXISTS `people`;
CREATE TABLE `people` (
  `pid` int(11) NOT NULL default '0',
  `name` char(20) default NULL,
  `gender` char(1) default NULL,
  `shoe_size` int(11) default NULL,
  `height` int(11) default NULL,
  PRIMARY KEY  (`pid`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `people`
--


/*!40000 ALTER TABLE `people` DISABLE KEYS */;
LOCK TABLES `people` WRITE;
INSERT INTO `people` VALUES (1,'Mr. Boddy','M',9,65),(2,'Miss Scarlet','F',8,67),(3,'Professor Plum','M',11,72),(4,'Colonel Mustard','M',13,75),(5,'Mr. Green','M',8,69),(6,'Mrs. White','F',10,72),(7,'Mrs. Peacock','F',5,60);
UNLOCK TABLES;
/*!40000 ALTER TABLE `people` ENABLE KEYS */;

--
-- Table structure for table `rooms`
--

DROP TABLE IF EXISTS `rooms`;
CREATE TABLE `rooms` (
  `rid` int(11) NOT NULL default '0',
  `rname` char(15) default NULL,
  `floor` char(15) default NULL,
  `has_windows` tinyint(1) default NULL,
  PRIMARY KEY  (`rid`),
  UNIQUE KEY `rname` (`rname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rooms`
--


/*!40000 ALTER TABLE `rooms` DISABLE KEYS */;
LOCK TABLES `rooms` WRITE;
INSERT INTO `rooms` VALUES (1,'Lounge','blue carpet',1),(2,'Dining Room','hardwood',1),(3,'Study','hardwood',0),(4,'Ballroom','hardwood',0),(5,'Conservatory','red carpet',1),(6,'Kitchen','tile',1),(7,'Billiard Room','green carpet',0),(8,'Library','brown carpet',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `rooms` ENABLE KEYS */;

--
-- Table structure for table `wasin`
--

DROP TABLE IF EXISTS `wasin`;
CREATE TABLE `wasin` (
  `pid` int(11) NOT NULL default '0',
  `rid` int(11) NOT NULL default '0',
  `time` char(15) NOT NULL default '',
  PRIMARY KEY  (`pid`,`rid`,`time`),
  KEY `rid` (`rid`),
  CONSTRAINT `wasin_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `people` (`pid`),
  CONSTRAINT `wasin_ibfk_2` FOREIGN KEY (`rid`) REFERENCES `rooms` (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wasin`
--


/*!40000 ALTER TABLE `wasin` DISABLE KEYS */;
LOCK TABLES `wasin` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `wasin` ENABLE KEYS */;

--
-- Table structure for table `weapons`
--

DROP TABLE IF EXISTS `weapons`;
CREATE TABLE `weapons` (
  `wid` int(11) NOT NULL default '0',
  `wname` char(15) default NULL,
  `weight` char(15) default NULL,
  `shape` char(20) default NULL,
  `diameter` double default NULL,
  PRIMARY KEY  (`wid`),
  UNIQUE KEY `wname` (`wname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `weapons`
--


/*!40000 ALTER TABLE `weapons` DISABLE KEYS */;
LOCK TABLES `weapons` WRITE;
INSERT INTO `weapons` VALUES (1,'Rope','light','cylinder',1),(2,'Lead Pipe','heavy','cylinder',1),(3,'Knife','light','edge',0.5),(4,'Wrench','heavy','misc',3),(5,'Candlestick','heavy','cylinder',1),(6,'Revolver','heavy','misc',0.75);
UNLOCK TABLES;
/*!40000 ALTER TABLE `weapons` ENABLE KEYS */;
/*!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 */;