CREATE TABLE IF NOT EXISTS `codes` (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `code` CHAR(8) NOT NULL,
  `user_id` INT(4) UNSIGNED NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `magnum_codes`
--

INSERT INTO `codes` (`id`, `code`, `user_id`, `created_at`) VALUES
(1, 'ABCD1234', 0, '0000-00-00 00:00:00'),
(2, 'ABCD1235', 0, '0000-00-00 00:00:00');