tbrTaGjz

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