 USE `wham`;
 -- MySQL dump 10.13  Distrib 5.6.13, for Win32 (x86)
 --
--- Host: 127.0.0.1    Database: wham_db
+-- Host: 127.0.0.1    Database: wham
 -- ------------------------------------------------------
 -- Server version	5.6.15
 


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


/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `userpreference` (
  `uId` int(11) NOT NULL,
  `subCategoryId` int(11) unsigned NOT NULL,
  `CategoryId` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`uId`,`subCategoryId`),
  KEY `userId_idx` (`uId`),
  CONSTRAINT `userPref` FOREIGN KEY (`uId`) REFERENCES `user` (`uId`) ON DELETE CASCADE ON UPDATE CASCADE
