CREATE TABLE analyzer2_data (
  ip varchar(15) NOT NULL ,
  time int NOT NULL ,
  mods varchar(128)  NOT NULL,
  ref varchar(255) ,
  ua varchar(255) ,
  user varchar(128),
  analysis tinyint(1) NOT NULL default '0', 
  date int(8)  NOT NULL,
  jikan int(2) ,
  searchtext varchar(255),
  searcheng  varchar(128),
  host varchar(255) ,
  browser varchar(255) ,
  os varchar(255) ,
  crawl varchar(255) ,
  PRIMARY KEY  (ip,time,mods,date),
  KEY date (date),
  KEY ip (ip)
) TYPE=MyISAM;

CREATE TABLE analyzer2_noip (
  ip varchar(255) NOT NULL,
  PRIMARY KEY  (ip)
) TYPE=MyISAM;
INSERT INTO analyzer2_noip VALUES ('127.0.0.1');

