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;