   `capacity` int(11) DEFAULT NULL,
   `status` varchar(150) DEFAULT NULL,
   `logo_url` varchar(150) DEFAULT NULL,
-  `organizerID` double DEFAULT NULL,
-  `categoryID` double DEFAULT NULL,
-  `subCategoryID` double DEFAULT NULL,
+  `organizerID` int(10) unsigned DEFAULT NULL,
+  `categoryID` int(10) unsigned DEFAULT NULL,
+  `subCategoryID` int(10) unsigned DEFAULT NULL,
   `address_1` varchar(150) DEFAULT NULL,
   `address_2` varchar(150) DEFAULT NULL,
   `city` varchar(150) DEFAULT NULL,

/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `userpreference` (
  `uId` int(11) NOT NULL,
  `subCategoryId` double NOT NULL,
  `CategoryId` double 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` bigint(20) unsigned NOT NULL,
  `name` varchar(150) DEFAULT NULL,
  `url` varchar(150) DEFAULT NULL,
  `description` text,
