· 6 years ago · Jun 03, 2019, 12:30 PM
1• Step 8 : In your database, execute the following code :
2ALTER TABLE `players` ADD COLUMN `num` VARCHAR(10) NOT NULL DEFAULT '0';
3
4and execute :
5ALTER TABLE `players` ADD COLUMN `contact` TEXT NULL DEFAULT NULL;
6
7and after that execute :
8CREATE TABLE IF NOT EXISTS `cellphone` ( `pid` varchar(64) NOT NULL, `name` varchar(32) NOT NULL, `messages` text NOT NULL, `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;