ALTER TABLE `xxb_entry` ADD `status` ENUM('online','offline') NOT NULL DEFAULT 'online' AFTER `category`; ALTER TABLE `xxb_entry` ADD `version` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `buildin`; ALTER TABLE `xxb_entry` ADD `platform` VARCHAR(255) NOT NULL DEFAULT 'ranzhi' AFTER `version`; ALTER TABLE `xxb_entry` ADD `package` INT(11) NOT NULL DEFAULT '0' AFTER `platform`; CREATE TABLE `xxb_sso` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `sid` char(32) NOT NULL, `entry` mediumint(8) unsigned NOT NULL, `token` char(32) NOT NULL, `time` datetime NOT NULL, PRIMARY KEY (`id`), KEY `sid` (`sid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;