Yiyqm97j

1DROP TABLE IF EXISTS `mcb_user_payment_data`;
2CREATE TABLE IF NOT EXISTS `mcb_user_payment_data` (
3  `user_id` int(11) NOT NULL,
4  `payment_type` varchar(25) CHARACTER SET utf8 NOT NULL,
5  `cc_num` int(16) DEFAULT NULL,
6  `cc_type` varchar(25) CHARACTER SET utf8 DEFAULT NULL,
7  `cc_ex_month` int(2) DEFAULT NULL,
8  `cc_ex_year` int(4) DEFAULT NULL,
9  `cc_code` int(3) DEFAULT NULL,
10  `eft_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
11  `eft_route` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
12  `eft_num` varchar(255) CHARACTER SET utf8 DEFAULT NULL
13) ENGINE=MyISAM DEFAULT CHARSET=utf8;
14
15ALTER TABLE `mcb_users` ADD `phone_number2` VARCHAR( 25 ) NOT NULL AFTER `phone_number`;