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

File size: 800B
CREATE TABLE IF NOT EXISTS `LUCK_USER_VISIT` (

`ID` int(11) NOT NULL AUTO_INCREMENT,

`USER_ID` int(11) NOT NULL,

`TIME` int(11) NOT NULL
,

PRIMARY KEY (`ID`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;



CREATE TABLE `LUCK` (
  
`USER_ID` int(11) DEFAULT '0',
  
`TIME` int(11) NOT NULL,
  
`NUM` int(11) DEFAULT '1'
,
`OK` int(11) DEFAULT '0'
,
`LAST` int(11) DEFAULT '0'

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE `LUCK_TOP` (


`ID` int(11) NOT NULL AUTO_INCREMENT,  

`USER_ID` int(11) DEFAULT '0',
  

`TIME` int(11) NOT NULL,
  

`NUM` int(11) DEFAULT '0',

PRIMARY KEY (`ID`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;


CREATE TABLE `LUCK_TIME` (
`TIME` int(11) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;