matches and stages

-- ----------------------------
--  Table structure for `matches`
-- ----------------------------
DROP TABLE IF EXISTS `matches`;
CREATE TABLE `matches` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `match_name` varchar(200) NOT NULL,
  `match_type` varchar(200) NOT NULL,
  `clubID` varchar(200) NOT NULL,
  `deviceID` varchar(200) NOT NULL,
  `matchuuid` varchar(200) NOT NULL,
  `password` varchar(200) NOT NULL,
  `match_date` datetime NOT NULL,
  `match_creationdate` varchar(200) NOT NULL,
  `match_modifieddate` varchar(200) NOT NULL,
  `URLSegment` varchar(200) NOT NULL,
  `notes` text,
  `matchTitle` varchar(200) DEFAULT NULL,
  `contentAllResults` tinyint(1) NOT NULL,
  `match_usesdqpoints` tinyint(1) NOT NULL,
  `match_sdqpoints` decimal(17,2) NOT NULL,
  `match_owner` tinyint(1) DEFAULT NULL,
  `version` decimal(5,2) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `matches`
-- ----------------------------
BEGIN;
INSERT INTO `matches` VALUES ('1', '2012 Games', 'timeplus', 'devin', 'a8b21f32f28460cb1dc89d63c822903e9a0a6a20', 'E11A3C81-A2B8-48E2-BE1B-1FFB77CC5849', '', '2012-05-17 00:00:00', '2012-08-06 20:47:45.607', '2012-08-06 21:34:50.431', 'E11A3C81-A2B8-48E2-BE1B-1FFB77CC5849', 'Bar', 'foo', '1', '0', '999.00', '0', '1.00', '2012-08-08 23:21:36', '2012-08-08 23:27:18');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;


-- ----------------------------
--  Table structure for `stages`
-- ----------------------------
DROP TABLE IF EXISTS `stages`;
CREATE TABLE `stages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `stage_name` varchar(100) NOT NULL,
  `stage_number` int(11) NOT NULL,
  `stage_tppoints` int(11) NOT NULL,
  `stage_modifieddate` varchar(30) NOT NULL,
  `stage_uuid` varchar(200) NOT NULL,
  `stage_numtargets` int(11) NOT NULL,
  `match_id` int(10) unsigned NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `stages_match_id_index` (`match_id`),
  CONSTRAINT `stages_match_id_foreign` FOREIGN KEY (`match_id`) REFERENCES `matches` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `stages`
-- ----------------------------
BEGIN;
INSERT INTO `stages` VALUES ('1', 'Stage 1 - Fort', '1', '100', '2012-05-18 21:07:06.636', 'D127736E-26AC-43AF-B448-D30E5937B570', '24', '1', '2012-08-08 23:21:36', '2012-08-08 23:27:18'), ('2', 'Stage 2 - Junction', '2', '100', '2012-05-18 21:07:26.079', 'D5EF3B74-AAA2-4E31-B9BB-A5BB9EF58A3E', '24', '1', '2012-08-08 23:21:36', '2012-08-08 23:27:18'), ('3', 'Stage 3 - Saloon', '3', '100', '2012-05-18 21:07:53.512', 'C70AF795-FD7B-4910-9363-A9AF17260D2E', '24', '1', '2012-08-08 23:21:36', '2012-08-08 23:27:18'), ('4', 'Stage 4 - Office', '4', '100', '2012-05-18 21:08:21.220', '84A775F0-0C99-460B-8606-FF07EDAAD0C9', '24', '1', '2012-08-08 23:21:36', '2012-08-08 23:27:18'), ('5', 'Stage 5 -Shack', '5', '100', '2012-05-18 21:09:06.083', 'CCEE75C3-B502-4103-9C81-731CCE4D9644', '24', '1', '2012-08-08 23:21:37', '2012-08-08 23:27:19');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;