15 lines
696 B
SQL
15 lines
696 B
SQL
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;
|