CREATE DATABASE `referrers` /*!40100 DEFAULT CHARACTER SET latin1 */;

DROP TABLE IF EXISTS `referrers`.`domain`;
CREATE TABLE `domain` (
  `Domain_ID` int(10) unsigned NOT NULL auto_increment,
  `Domain_Name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Domain_ID`),
  KEY `domain_index_2` (`Domain_Name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `referrers`.`referrer`;
CREATE TABLE `referrer` (
  `Referrer_ID` int(10) unsigned NOT NULL auto_increment,
  `Referrer_Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `Referrer_URL` varchar(255) NOT NULL default '',
  `Referrer_Title` varchar(255) default NULL,
  PRIMARY KEY  (`Referrer_ID`),
  KEY `referrer_index_2` (`Referrer_URL`),
  KEY `referrer_index_3` (`Referrer_Title`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `referrers`.`referrer_count`;
CREATE TABLE `referrer_count` (
  `Domain_ID` int(10) unsigned NOT NULL default '0',
  `Referrer_ID` int(10) unsigned NOT NULL default '0',
  `Referrer_Count` int(10) unsigned NOT NULL default '0',
  `Referrer_Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`Domain_ID`,`Referrer_ID`),
  KEY `FK_referrer_count_2` (`Referrer_ID`),
  CONSTRAINT `FK_referrer_count_1` FOREIGN KEY (`Domain_ID`) REFERENCES `domain` (`Domain_ID`),
  CONSTRAINT `FK_referrer_count_2` FOREIGN KEY (`Referrer_ID`) REFERENCES `referrer` (`Referrer_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;