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

CREATE TABLE IF NOT EXISTS `PROMOCODES` (
  
`ID` int(11) NOT NULL AUTO_INCREMENT,
`BALLS` int(11) DEFAULT NULL,
`MONEY` double(10,2) DEFAULT '0.00',
`RATING` double(10,2) DEFAULT '0.00',
`COUNT` int(11) DEFAULT NULL,
`CODE` varchar(30) DEFAULT NULL,
`ACT` int(11) DEFAULT '1',
`TIME` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


CREATE TABLE IF NOT EXISTS `PROMOCODES_USER` (
  
`ID` int(11) NOT NULL AUTO_INCREMENT,
`USER_ID` int(11) DEFAULT NULL,
`BALLS` int(11) DEFAULT NULL,
`MONEY` double(10,2) DEFAULT '0.00',
`RATING` double(10,2) DEFAULT '0.00',
`CODE` varchar(30) DEFAULT NULL,
`TIME` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;