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

CREATE TABLE IF NOT EXISTS `TRS_DATA` (  
`ID` int(11) NOT NULL AUTO_INCREMENT,
`SITE_ID` int(11) DEFAULT '0',
`DATE` varchar(200) DEFAULT NULL,
`HOST` int(11) DEFAULT '0',
`HIT` int(11) DEFAULT '0',
PRIMARY KEY (`ID`))
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `TRS_VISIT` (  
`ID` int(11) NOT NULL AUTO_INCREMENT,
`IP` varchar(100) DEFAULT NULL,
`SITE_ID` int(11) DEFAULT '0',
`DATE` varchar(200) DEFAULT NULL,
PRIMARY KEY (`ID`))
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `TRS_SITES` (  
`ID` int(11) NOT NULL AUTO_INCREMENT,
`NAME` varchar(300) DEFAULT NULL,
`MESSAGE` varchar(300) DEFAULT NULL,
`DOMAIN` varchar(200) DEFAULT NULL,
`TOKEN` varchar(300) DEFAULT NULL,
`FAVICON` varchar(300) DEFAULT NULL,
`USER_ID` int(11) DEFAULT '0',
`ID_CATEGORY` int(11) DEFAULT '0',
`ACT` int(11) DEFAULT '0',
`TIME` int(11) DEFAULT '0',
`BANNER` int(11) DEFAULT '1',
`VIP` int(11) DEFAULT '0',
PRIMARY KEY (`ID`))
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

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