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

CREATE TABLE IF NOT EXISTS `LOTTERY_USER` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `USER_ID` int(11) NOT NULL,
  `ID_BILET` int(11) NOT NULL,
  `SUM` int(11) NOT NULL,
  `LOTTERY_ID` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE `LOTTERY` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `USER_ID` int(11) NOT NULL,
  `NAME` varchar(500) NOT NULL,
  `TIME` int(11) NOT NULL,
  `MESSAGE` varchar(2000) NOT NULL,
  `TYPE` varchar(100) NOT NULL,
  `ACT` int(11) DEFAULT '0',
  `1M` int(11) DEFAULT '0',
  `2M` int(11) DEFAULT '0',
  `3M` int(11) DEFAULT '0',
  `1R` int(11) DEFAULT '0',
  `2R` int(11) DEFAULT '0',
  `3R` int(11) DEFAULT '0',
  `STIME` int(11) DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


CREATE TABLE IF NOT EXISTS `LOTTERY_COMMENTS` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`USER_ID` int(11) DEFAULT NULL,
`LOTTERY_ID` int(11) DEFAULT NULL,
`SECTION_ID` int(11) DEFAULT NULL,
`TIME` int(11) DEFAULT NULL,
`MESSAGE` varchar(5000) DEFAULT NULL,
`REPLY` int(11) DEFAULT '0',
`REPLY_USER_ID` int(11) DEFAULT '0',
`EDIT_TIME` int(11) DEFAULT NULL,
`EDIT_USER_ID` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


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