Bravo List - View Single Post

costy22it · #2 15th July 2012, 16:01

Some SQL needed

Code:

CREATE TABLE `invite_codes` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `sender` int(10) unsigned NOT NULL default '0',
  `receiver` varchar(32) NOT NULL default '0',
  `code` varchar(32) NOT NULL default '',
  `invite_added` int(10) NOT NULL,
  `status` enum('Pending','Confirmed') NOT NULL default 'Pending',
  PRIMARY KEY  (`id`),
  KEY `sender` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

Alter table users with this sql

Code:

 `invitedate` int(11) NOT NULL default '0',
  `invitees` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',
  `invite_on` enum('yes','no') character set utf8 collate utf8_bin NOT NULL default 'yes',