CREATE TABLE `friendcodes` (
  `gid` int(4) NOT NULL,
  `username` varchar(50) collate latin1_general_ci NOT NULL,
  `ingamename` varchar(50) collate latin1_general_ci NOT NULL,
  `friendcode` varchar(16) collate latin1_general_ci NOT NULL,
  `personalnotes` varchar(350) collate latin1_general_ci NOT NULL,
  `hidden` varchar(1) collate latin1_general_ci NOT NULL
) 

CREATE TABLE `wifigames` (
  `id` int(3) NOT NULL auto_increment,
  `gamename` varchar(255) collate latin1_general_ci NOT NULL,
  `platform` varchar(4) collate latin1_general_ci NOT NULL,
  `boxart` varchar(400) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
)