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

ALTER TABLE `USERS` ADD `MONEY_SURF` double(10,2) DEFAULT '0.00';

CREATE TABLE IF NOT EXISTS `SURFING` (  
`ID` int(11) NOT NULL AUTO_INCREMENT,
`ACT` int(11) DEFAULT '0',
`USER_ID` int(11) DEFAULT NULL,
`MESSAGE` varchar(500) DEFAULT NULL,
`LINK` varchar(250) DEFAULT NULL,
`EYE` int(11) DEFAULT '0',
`BUDGET` double(10,2) DEFAULT '0.00',
`BUDGET_EXPENSE` double(10,2) DEFAULT '0.00',
`BUDGET_REMAINS` double(10,2) DEFAULT '0.00',
`TIME` int(11) DEFAULT '0',
`REPLAY` int(11) DEFAULT '0',
`TIME2` int(11) DEFAULT '0',
`JTIME` int(11) DEFAULT '0',
PRIMARY KEY (`ID`))
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


CREATE TABLE IF NOT EXISTS `SURFING_EYE` (  
`ID` int(11) NOT NULL AUTO_INCREMENT,
`USER_ID` int(11) DEFAULT '0',
`SURF_ID` int(11) DEFAULT '0',
`TIME` int(11) DEFAULT '0',
PRIMARY KEY (`ID`))
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


CREATE TABLE IF NOT EXISTS `SURFING_EYE_US` ( 
`USER_ID` int(11) DEFAULT '0',
`SURF_ID` int(11) DEFAULT '0',
`JTIME` int(11) DEFAULT '0'
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8;