View file files/upload/alpha_installer/sql/db.sql

File size: 581B
ALTER TABLE `USERS` ADD `WBP` int(11) DEFAULT '1';

CREATE TABLE IF NOT EXISTS `WEB_PUSH_LIST` ( 
`ID` int(11) NOT NULL AUTO_INCREMENT,
`USER_ID` int(11) DEFAULT NULL,
`MY_ID` int(11) DEFAULT NULL,
`OBJECT_ID` int(11) DEFAULT NULL,
`TYPE` varchar(30) DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `WEB_PUSH_TOKEN` ( 
`ID` int(11) NOT NULL AUTO_INCREMENT,
`USER_ID` int(11) DEFAULT NULL,
`TOKEN` varchar(300) DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;