 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2015-11-22 11:55:39
+-- Dump completed on 2015-11-22 15:49:57


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
