-- Table visiteurip

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
CREATE TABLE IF NOT EXISTS `visiteurip` (
  `uid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date_heure` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(40) NOT NULL,
  `ipdecimal` bigint(20) NOT NULL,
  `host` varchar(60) NOT NULL,
  `filename` varchar(60) NOT NULL,
  `site` varchar(40) NOT NULL,
  `precedent` varchar(1000) NOT NULL,
  `user_agent` varchar(500) NOT NULL,
  `x_forward` varchar(100) NOT NULL,
  `bloque` char(1) NOT NULL,
  UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=787830 ;


-- Table bloqueip

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
CREATE TABLE IF NOT EXISTS `bloqueip` (
  `uid` bigint(20) NOT NULL AUTO_INCREMENT,
  `ip` varchar(40) NOT NULL,
  `ipdecimal` bigint(20) NOT NULL,
  `ipdecimal_min` bigint(10) NOT NULL,
  `ipdecimal_max` bigint(10) NOT NULL,
  `date_heure` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `serveur` char(1) NOT NULL,
  `remaruque` varchar(60) NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5325 ;



-- Table robotip

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
CREATE TABLE IF NOT EXISTS `robotip` (
  `uid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date-heure` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ip` varchar(40) NOT NULL,
  `ipdecimal` bigint(20) NOT NULL,
  `host` varchar(60) NOT NULL,
  `filename` varchar(60) NOT NULL,
  `site` varchar(40) NOT NULL,
  `precedent` varchar(1000) NOT NULL,
  `user_agent` varchar(500) NOT NULL,
  `x_forward` varchar(100) NOT NULL,
  UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=541422 ;