akEL4ZDd

1ALTER TABLE `players` ADD COLUMN `num` VARCHAR(10) NOT NULL DEFAULT '0';
2ALTER TABLE `players` ADD COLUMN `contact` TEXT NULL DEFAULT NULL;
3ALTER TABLE `players` ADD COLUMN `sms` INT(10) NOT NULL DEFAULT '0';
4ALTER TABLE `players` ADD COLUMN `appel` INT(10) NOT NULL DEFAULT '0';
5CREATE TABLE IF NOT EXISTS `cellphone` (
6`pid` varchar(64) NOT NULL, 
7`name` varchar(32) NOT NULL, 
8`messages` text NOT NULL, 
9`insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`pid`) 
10) 
11ENGINE=InnoDB DEFAULT CHARSET=utf8;