CREATE TABLE `user_master` ( `msisdn` bigint(20) NOT NULL, `cat0` tinyint(1) DEFAULT '0', `cat1` tinyint(1) DEFAULT '0', `cat2` tinyint(1) DEFAULT '0', `cat3` tinyint(1) DEFAULT '0', `cat4` tinyint(1) DEFAULT '0', `cat5` tinyint(1) DEFAULT '0', `cat6` tinyint(1) DEFAULT '0', `cat7` tinyint(1) DEFAULT '0', `vip` tinyint(1) DEFAULT '0', `SAcode` bigint(10) NOT NULL DEFAULT '0', `phone_type` bigint(10) NOT NULL DEFAULT '0', PRIMARY KEY (`msisdn`), KEY `num` (`msisdn`) )