· 7 years ago · Sep 25, 2018, 06:46 PM
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,
10PRIMARY KEY (`pid`)
11)
12ENGINE=InnoDB DEFAULT CHARSET=utf8;