WoW-Info — информационный World of Warcraft портал

CREATE TABLE ip (
             id_ip int(32) NOT NULL auto_increment,
             ip tinytext NOT NULL,
             putdate datetime NOT NULL default '0000-00-00 00:00:00',
             id_page int(10) NOT NULL default '0',
             browsers enum('none','msie','opera','netscape') NOT NULL default 'none',
             systems enum('none', 'windows', 'unix', 'macintosh', 'robot_yandex', 'robot_google', 'robot_rambler', 'robot_aport', 'robot_msnbot') NOT NULL default 'none',
             searches enum('none','yandex','google','rambler','aport','own_site','mail','msn') NOT NULL default 'none',
             PRIMARY KEY  (id_ip)
) TYPE=MyISAM;
CREATE TABLE links (
             id_links int(8) NOT NULL auto_increment,
             name text,
             comment text,
             PRIMARY KEY  (id_links)
) TYPE=MyISAM;
CREATE TABLE pages (
             id_page int(10) NOT NULL auto_increment,
             name text,
             id_site int(4) default NULL,
             PRIMARY KEY  (id_page)
) TYPE=MyISAM;
CREATE TABLE refferer (
             id_refferer int(16) NOT NULL auto_increment,
             name tinytext NOT NULL,
             putdate datetime NOT NULL default '0000-00-00 00:00:00',
             ip tinytext NOT NULL,
             id_page int(8) NOT NULL default '0',
             searches enum('none','yandex','google','rambler','aport','own_site','mail','msn') NOT NULL default 'none',
             PRIMARY KEY  (id_refferer),
             FULLTEXT KEY name (name)
) TYPE=MyISAM;
CREATE TABLE thits (
             hits int(11)
) TYPE=MyISAM;