SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; CREATE TABLE IF NOT EXISTS `xredirect_attributes` ( `source_id` int(11) NOT NULL, `target_id` int(11) NOT NULL default '0', `attrib` varchar(50) NOT NULL, `value` varchar(100) NOT NULL, PRIMARY KEY (`source_id`,`target_id`,`attrib`), KEY `idx_source_id` (`source_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='xREDIRECT server attributes'; CREATE TABLE IF NOT EXISTS `xredirect_servers` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) default NULL, `address` varchar(100) default NULL, `localaddress` varchar(100) default NULL, `port` int(11) default NULL, `password` varchar(15) default NULL, `publicpassword` int(11) default NULL, `cmdbackup` int(11) default NULL, `noauto` int(11) default NULL, `nomanual` int(11) default NULL, `nodisplay` int(11) default NULL, `adminslots` int(11) default NULL, `category` varchar(100) default NULL, `private` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT='xREDIRECT server list'; CREATE TABLE IF NOT EXISTS `xredirect_statistics` ( `id` int(11) NOT NULL auto_increment, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `user_name` varchar(32) default NULL, `user_ip` varchar(15) default NULL, `user_authid` varchar(34) default NULL, `action` varchar(30) default NULL, `server_id` int(11) default NULL, `target_server_id` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT='xREDIRECT redirection statistics';