rendered paste body
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`)
)