`id` int(11) NOT NULL AUTO_INCREMENT, `name` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `system` enum('PS1','PS2','XBOX','XBOX360','N64','Wii') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `UPC-A` varchar(20) NOT NULL, `price_level` enum('used_price','complete_price','new_price') NOT NULL, `own` bit(1) NOT NULL DEFAULT b'1', `item-count` tinyint(4) NOT NULL DEFAULT '1', `imguri` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `reprint` bit(1) NOT NULL DEFAULT b'0', `notes` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `paid-value` decimal(4,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`id`)