DROP TABLE IF EXISTS `invites`;
CREATE TABLE `invites` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `inviter` int(10) unsigned NOT NULL default '0',
  `invitee` varchar(80) NOT NULL default '',
  `hash` varchar(32) NOT NULL default '',
  `time_invited` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `inviter` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;


ALTER TABLE `users`
ADD `invites` int(10) NOT NULL default '0',
ADD `invited_by` int(10) NOT NULL default '0',
ADD `invitedate` datetime NOT NULL default '0000-00-00 00:00:00';