
# --------------------------------------------------------

#
# Table structure for table `banners`
#

CREATE TABLE banners (
  number int(3) NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  image varchar(60) NOT NULL default '',
  description varchar(200) NOT NULL default '',
  PRIMARY KEY  (number)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `clickthroughs`
#

CREATE TABLE clickthroughs (
  refid varchar(20) default 'none',
  date date NOT NULL default '0000-00-00',
  time time NOT NULL default '00:00:00',
  browser varchar(200) default 'Could Not Find This Data',
  ipaddress varchar(50) default 'Could Not Find This Data',
  refferalurl varchar(200) default 'none detected (maybe a direct link)',
  buy varchar(10) default 'NO'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `sales`
#

CREATE TABLE sales (
  refid varchar(20) NOT NULL default '',
  date date NOT NULL default '0000-00-00',
  time time NOT NULL default '00:00:00',
  browser varchar(100) NOT NULL default '',
  ipaddress varchar(20) NOT NULL default '',
  payment varchar(10) NOT NULL default ''
) TYPE=MyISAM;

    
