 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `userpreference` (
   `uId` int(11) NOT NULL,
-  `subCategoryId` double NOT NULL,
-  `CategoryId` double DEFAULT 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

/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `event` (
  `eId` double NOT NULL,
  `name` varchar(150) DEFAULT NULL,
  `url` varchar(150) DEFAULT NULL,
  `description` text,


LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'contashish@yahoo.co.in','Ashish','Khanna','8572410644','16C Smith street',NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

