text: -- MySQL dump 10.11
  --
  -- Host: localhost    Database: leaderboard
  -- ------------------------------------------------------
  -- Server version	5.0.51a-24+lenny2
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `ADMIN`
  --
  
  DROP TABLE IF EXISTS `ADMIN`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `ADMIN` (
    `id` int(10) unsigned NOT NULL,
    `username` varchar(32) NOT NULL default 'default',
    `password` varchar(32) NOT NULL default 'default',
    `is_disabled` enum('default','no','yes') NOT NULL default 'no',
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`id`),
    KEY `username` (`username`),
    KEY `enabled_i` (`is_disabled`,`is_deleted`),
    CONSTRAINT `ADMIN_id_fkc` FOREIGN KEY (`id`) REFERENCES `PERSON` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `ADMIN`
  --
  
  LOCK TABLES `ADMIN` WRITE;
  /*!40000 ALTER TABLE `ADMIN` DISABLE KEYS */;
  INSERT INTO `ADMIN` VALUES (70,'josh','7e3f6c2585c061852d8f6ed6fd91ccb0','no','no'),(71,'jackforester','bf51d173c48cfca0774c22cc2911bede','no','no');
  /*!40000 ALTER TABLE `ADMIN` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `AUTHORITY`
  --
  
  DROP TABLE IF EXISTS `AUTHORITY`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `AUTHORITY` (
    `id` int(10) unsigned NOT NULL,
    `authority` enum('default','ROLE_COMPETITOR','ROLE_EVENTADMIN','ROLE_PROMOTER','ROLE_ROOT') NOT NULL default 'default',
    PRIMARY KEY  (`id`,`authority`),
    CONSTRAINT `AUTHORITY_id_fkc` FOREIGN KEY (`id`) REFERENCES `PERSON` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `AUTHORITY`
  --
  
  LOCK TABLES `AUTHORITY` WRITE;
  /*!40000 ALTER TABLE `AUTHORITY` DISABLE KEYS */;
  INSERT INTO `AUTHORITY` VALUES (70,'ROLE_EVENTADMIN'),(70,'ROLE_PROMOTER'),(70,'ROLE_ROOT'),(71,'ROLE_EVENTADMIN'),(71,'ROLE_PROMOTER'),(71,'ROLE_ROOT');
  /*!40000 ALTER TABLE `AUTHORITY` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `COMPARATOR`
  --
  
  DROP TABLE IF EXISTS `COMPARATOR`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `COMPARATOR` (
    `id` int(10) unsigned NOT NULL,
    `course_id` int(10) unsigned NOT NULL,
    `type` enum('default','missedcutoff','unofficial','incomplete','withdrawn','disqualified','didnotstart','mandatorycps','mandatorygroupcps','optionalcps','cpweight','lastvisitedcporder','lastvisitedcporderdeparture','lastvisitedcporderarrival','leastskippedmandatorycps','leastskippedmandatorygroupcps','leastskippedoptionalcps','leastskippedcpweight') NOT NULL default 'default',
    `tie_action` enum('default','continue','rankeven') default 'default',
    `c_order` smallint(2) unsigned NOT NULL default '0',
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`id`),
    KEY `COMPARATOR_course_id_fkc` (`course_id`),
    CONSTRAINT `COMPARATOR_course_id_fkc` FOREIGN KEY (`course_id`) REFERENCES `COURSE` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `COMPARATOR_id_fkc` FOREIGN KEY (`id`) REFERENCES `DATA_RESOURCE` (`id`) ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `COMPARATOR`
  --
  
  LOCK TABLES `COMPARATOR` WRITE;
  /*!40000 ALTER TABLE `COMPARATOR` DISABLE KEYS */;
  INSERT INTO `COMPARATOR` VALUES (163,96,'didnotstart','rankeven',1,'no'),(164,96,'disqualified','rankeven',2,'no'),(165,96,'optionalcps','continue',3,'no'),(171,96,'leastskippedoptionalcps','continue',4,'no'),(172,96,'lastvisitedcporderdeparture','continue',5,'no'),(173,96,'lastvisitedcporderarrival','rankeven',6,'no'),(182,175,'didnotstart','rankeven',1,'no'),(183,175,'disqualified','rankeven',2,'no'),(184,175,'withdrawn','continue',3,'no'),(185,175,'unofficial','continue',4,'no'),(186,175,'lastvisitedcporder','continue',5,'no'),(187,175,'lastvisitedcporderdeparture','continue',6,'no'),(188,175,'lastvisitedcporderarrival','rankeven',7,'no');
  /*!40000 ALTER TABLE `COMPARATOR` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `COMPETITOR`
  --
  
  DROP TABLE IF EXISTS `COMPETITOR`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `COMPETITOR` (
    `id` int(10) unsigned NOT NULL,
    `person_id` int(10) unsigned NOT NULL,
    `emergency_contact_first_name` varchar(32) default 'default',
    `emergency_contact_last_name` varchar(32) default 'default',
    `emergency_contact_relation` enum('default','spouse','sibling','parent','child','other') default 'default',
    `emergency_phone` varchar(24) default 'default',
    `shirt_size` enum('default','x-small','small','medium','large','x-large','xx-large','xxx-large') default 'default',
    `shoe_size` varchar(7) default 'default',
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`id`),
    KEY `enabled_i` (`is_deleted`),
    KEY `COMPETITOR_person_id_fkc` (`person_id`),
    CONSTRAINT `COMPETITOR_id_fkc` FOREIGN KEY (`id`) REFERENCES `DATA_RESOURCE` (`id`) ON UPDATE CASCADE,
    CONSTRAINT `COMPETITOR_person_id_fkc` FOREIGN KEY (`person_id`) REFERENCES `PERSON` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `COMPETITOR`
  --
  
  LOCK TABLES `COMPETITOR` WRITE;
  /*!40000 ALTER TABLE `COMPETITOR` DISABLE KEYS */;
  /*!40000 ALTER TABLE `COMPETITOR` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `COURSE`
  --
  
  DROP TABLE IF EXISTS `COURSE`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `COURSE` (
    `id` int(10) unsigned NOT NULL,
    `event_id` int(10) unsigned NOT NULL,
    `name` varchar(64) NOT NULL default 'default',
    `type` enum('default','rogaine','weightedrogaine','modifiedrogaine','pointtopoint','stage') NOT NULL default 'default',
    `length_hours` smallint(5) unsigned default '0',
    `length_miles` smallint(5) unsigned default '0',
    `description` text,
    `scribblelive_id` varchar(7) NOT NULL default 'default',
    `coveritlive_id` varchar(10) NOT NULL default 'default',
    `feedburner_all_id` varchar(64) NOT NULL default 'default',
    `feedburner_blogs_id` varchar(64) NOT NULL default 'default',
    `feedburner_photos_id` varchar(64) NOT NULL default 'default',
    `feedburner_videos_id` varchar(64) NOT NULL default 'default',
    `feedburner_audio_id` varchar(64) NOT NULL default 'default',
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`id`),
    KEY `event_id` (`event_id`,`name`),
    CONSTRAINT `COURSE_event_id_fkc` FOREIGN KEY (`event_id`) REFERENCES `EVENT` (`id`) ON UPDATE CASCADE,
    CONSTRAINT `COURSE_id_fkc` FOREIGN KEY (`id`) REFERENCES `DATA_RESOURCE` (`id`) ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `COURSE`
  --
  
  LOCK TABLES `COURSE` WRITE;
  /*!40000 ALTER TABLE `COURSE` DISABLE KEYS */;
  INSERT INTO `COURSE` VALUES (96,95,'Main Course','modifiedrogaine',0,0,'<div class=\"listhdr\">\r\n	Race Overview</div>\r\n<ul class=\"simple\">\r\n	<li>\r\n		The race is divided into three sections: Bike Section. consisting of points B1-B8, East Trek consisting of ET1-ET3 and West Trek consisting of WT1-WT6.</li>\r\n	<li>\r\n		The race starts and finishes at labeled S/F.</li>\r\n	<li>\r\n		<span style=\"font-weight: bold;\">Race cutoff is 12 hours 9:30pm.</span> Teams must be back at the start/finish by 9:30pm arriving after this time will result in DQ</li>\r\n	<li>\r\n		All maps are pre plotted and optional east trek UTM coordinates will be provided.</li>\r\n	<li>\r\n		After finishing the course either full or part you must either check out with the volunteer in S/F area or sign out on the provided spreadsheet.</li>\r\n	<li>\r\n		For sections WT and ET all racers must sign in/out with times and report number of checkpoints retrieved</li>\r\n</ul>\r\n<div class=\"listhdr\">\r\n	Section Order</div>\r\n<ul class=\"simple\">\r\n	<li>\r\n		Teams can complete all sections in any order. However, once a team starts a section, they need to .finish. that section . meaning to get as many points as they want within that section -- before moving on to the next section. Once a team finishes a section, they can.t go back later and punch points on a section they.ve finished. Teams can.t punch CPs from a section other than the one they are working on at that time.</li>\r\n</ul>\r\n<div class=\"listhdr\">\r\n	Control Point Order</div>\r\n<ul class=\"simple\">\r\n	<li>\r\n		Rogaine format so any order you choose in the designated section.</li>\r\n</ul>\r\n<div class=\"listhdr\">\r\n	Additional Details</div>\r\n<ul class=\"simple\">\r\n	<li>\r\n		Bikes are mandatory on the bike section and no bikes are allowed on the trek sections, All points are either on right off the trail/FS road or easily accessible from it. You may drop your bike at any place to retrieve a bike CP.</li>\r\n	<li>\r\n		Absolutely no bikes on or around the Appalachian or Benton MacKaye trails.</li>\r\n	<li>\r\n		If going for the optional east trek bikes must be dropped at B4, after dropping bikes you may then start the east trek after either checking in w/ the volunteer or signing in on the provided spreadsheet. Each team must also check out in the same manner stating the number of CP.s retrieved either to the volunteer or in the provided space on the spreadsheet.</li>\r\n	<li>\r\n		The west trek must be started and finished at the start/finish location for the race. You must check in/out with the volunteer and you must state the number of CP.s retrieved or if the volunteer is not on site the provided spreadsheet must be filled in by each team.</li>\r\n	<li>\r\n		There are no off-limits areas on the course, and the bike trails can be ridden in either direction. Be watchful for other riders as the trails are extremely popular, for good reason! Always yield to horse riders. Feel free to bushwhack or bike whack wherever you see fit with the exception of the AT and BMT where no bikes are allowed but bushwhacking is.</li>\r\n	<li>\r\n		Teams can use the Start/Finish location as a transition area which they can visit at any time during the race. That includes while in the middle of working on a race section.</li>\r\n	<li>\r\n		Use your trail map along with the topographic map to determine how to best get around.</li>\r\n	<li>\r\n		There&#39;s plenty of water out there. Be sure to treat it before drinking, but you.ll have plenty of opportunities to fill up your water bottles.</li>\r\n</ul>\r\n','10895','default','default','default','default','default','default','no'),(175,174,'Race Course','stage',24,110,'<p>\r\n	Course Description</p>\r\n','16066','default','AtomicAdventureRaceFeedMix','AtomicAdventureRaceBlog','AtomicAdventureRacePhotos','AtomicAdventureRaceVideos','AtomicAdventureRaceAudio','no');
  /*!40000 ALTER TABLE `COURSE` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `CP`
  --
  
  DROP TABLE IF EXISTS `CP`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `CP` (
    `id` int(10) unsigned NOT NULL,
    `course_id` int(10) unsigned NOT NULL,
    `cp_order` smallint(2) unsigned NOT NULL default '0',
    `name` varchar(32) NOT NULL default 'default',
    `ta_name` varchar(32) NOT NULL default 'default',
    `northernly` int(10) unsigned NOT NULL default '0',
    `easternly` int(10) unsigned NOT NULL default '0',
    `zone_number` int(10) unsigned NOT NULL default '0',
    `zone_char` enum('default','C','D','E','F','G','H','J','K','L','M','N','P','Q','S','T','U','V','W','X') default 'default',
    `hint` varchar(256) NOT NULL default 'default',
    `altitude` smallint(6) default '0',
    `cutoff` datetime NOT NULL default '1970-01-01 00:00:00',
    `is_mandatory` enum('default','no','yes') NOT NULL default 'default',
    `is_in_mandatory_group` enum('default','no','yes') NOT NULL default 'default',
    `mandatory_group_requirement` smallint(2) unsigned default '0',
    `mandatory_group_size` smallint(2) unsigned default '0',
    `weight` smallint(5) unsigned NOT NULL default '0',
    `from_discipline` enum('default','running','trekking','mountaineering','coasteering','biking','orienteering','paddling','swimming','ropes','riverboarding','inlineskating','scootering','specialchallenge') default 'default',
    `to_discipline` enum('default','running','trekking','mountaineering','coasteering','biking','orienteering','paddling','swimming','ropes','riverboarding','inlineskating','scootering','specialchallenge') default 'default',
    `heywhatsthat_id` varchar(8) default 'default',
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`id`),
    KEY `course_id` (`course_id`,`name`),
    CONSTRAINT `CP_course_id_fkc` FOREIGN KEY (`course_id`) REFERENCES `COURSE` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `CP_id_fkc` FOREIGN KEY (`id`) REFERENCES `DATA_RESOURCE` (`id`) ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `CP`
  --
  
  LOCK TABLES `CP` WRITE;
  /*!40000 ALTER TABLE `CP` DISABLE KEYS */;
  INSERT INTO `CP` VALUES (98,96,1,'S','',3836531,760107,16,'S','Race Start',0,'1970-01-01 00:00:00','no','no',0,0,0,'running','orienteering','default','no'),(99,96,2,'WT1','',3838406,758136,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'orienteering','orienteering','default','no'),(100,96,3,'WT2','',3838502,757516,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'orienteering','orienteering','default','no'),(101,96,4,'WT3','',3838786,756791,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'orienteering','orienteering','LALVOOG5','no'),(102,96,5,'WT4','',3836860,758369,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'orienteering','orienteering','default','no'),(103,96,6,'WT5','',3837851,758472,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'orienteering','orienteering','default','no'),(104,96,7,'WT6','',3837366,757567,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'orienteering','orienteering','default','no'),(105,96,8,'T1','West',3836531,760107,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'orienteering','biking','default','no'),(106,96,9,'B1','',3842679,761894,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'biking','biking','default','no'),(107,96,10,'B2','',3842425,764010,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'biking','biking','default','no'),(108,96,11,'B3','',3841584,765157,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'biking','biking','default','no'),(109,96,12,'B4','East',3838402,767158,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'biking','trekking','default','no'),(110,96,17,'B5','',3835163,764448,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'biking','biking','default','no'),(111,96,13,'ET1','',3839675,768211,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'trekking','trekking','default','no'),(112,96,14,'ET2','',3838848,769071,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'trekking','trekking','default','no'),(113,96,15,'ET3','',3837909,768686,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'trekking','trekking','default','no'),(114,96,16,'T2','East 2',3838402,767158,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'trekking','biking','default','no'),(115,96,18,'B6','',3833450,763865,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'biking','biking','default','no'),(116,96,19,'B7','',3834478,763955,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'biking','biking','default','no'),(117,96,20,'B8','',3834973,761532,16,'S','',0,'1970-01-01 00:00:00','no','no',0,0,0,'biking','biking','default','no'),(118,96,21,'F','',3836431,760107,16,'S','Race Finish',0,'1970-01-01 00:00:00','no','no',0,0,0,'biking','running','default','no'),(241,175,1,'S','',3827452,752298,16,'S','Start of Race',0,'1970-01-01 00:00:00','yes','no',0,0,1,'running','running','C0SSNAPF','no'),(242,175,2,'CP1','',3827910,752226,16,'S','Mt Laurel Loop Trail',0,'1970-01-01 00:00:00','no','no',0,0,1,'running','trekking','R72P5ECG','no'),(243,175,3,'CP2','TA',3828562,752809,16,'S','Top of Falls TA to pick up your bikes. Leave nothing at this TA.',0,'1970-01-01 00:00:00','yes','no',0,0,1,'trekking','biking','PJ8MVAEP','no'),(244,175,4,'CP3','',3831819,754333,16,'S','Frosty Mt Tower.',0,'1970-01-01 00:00:00','no','no',0,0,1,'biking','biking','KO0KO2CA','no'),(245,175,5,'CP4','',3833148,757105,16,'S','Bearden Falls',0,'1970-01-01 00:00:00','no','no',0,0,1,'biking','biking','JIP2UPFL','no'),(246,175,6,'CP5','',3828455,762543,16,'S','Nimblewill Church Manned CP.  This is also CP11.',0,'1970-01-01 00:00:00','yes','no',0,0,1,'biking','biking','NGLB535L','no'),(247,175,7,'CP6','',3829287,761915,16,'S','On 223F singletrack',0,'1970-01-01 00:00:00','no','no',0,0,1,'biking','biking','K4GJ48C7','no'),(248,175,8,'CP7','',3831731,761043,16,'S','On 223C near peak',0,'1970-01-01 00:00:00','no','no',0,0,1,'biking','biking','UGBTRDF2','no'),(249,175,9,'CP8','',3833506,760645,16,'S','Jones Creek Sliding Falls',0,'1970-01-01 00:00:00','no','no',0,0,1,'biking','biking','NLQ5RQC1','no'),(250,175,10,'CP9','',3831967,763403,16,'S','On 223E singletrack',0,'1970-01-01 00:00:00','no','no',0,0,1,'biking','biking','GAN4NJO9','no'),(251,175,11,'CP10','',3830421,763241,16,'S','Dam',0,'1970-01-01 00:00:00','no','no',0,0,1,'biking','biking','DG410KRF','no'),(252,175,12,'CP11','',3828455,762543,16,'S','Nimblewill Church Manned CP.  This is also CP5.',0,'1970-01-01 00:00:00','yes','no',0,0,1,'biking','biking','AIG9AHG3','no'),(256,175,13,'CP12','',3825299,767121,16,'S','Intersection of Larmon Forks Rd and CR 202 aka Sheep Wallow Rd.',0,'1970-01-01 00:00:00','no','no',0,0,1,'biking','biking','VVDTNOJ7','no'),(257,175,14,'CP13','TA',3823177,769875,16,'S','Canoe Put-In.  This must be approached from the south west on Hwy 9.',0,'2010-05-15 16:30:00','yes','no',0,0,1,'biking','paddling','R98JKSB5','no'),(258,175,15,'CP14','',3818602,772108,16,'S','Castleberry Rd Manned CP',0,'1970-01-01 00:00:00','no','no',0,0,1,'paddling','paddling','AU1D0SF3','no'),(259,175,16,'CP15','TA',3805581,765442,16,'S','Canoe Take-out.',0,'1970-01-01 00:00:00','yes','no',0,0,1,'paddling','running','G8OO1QVO','no'),(260,175,17,'CP16','TA',3804672,762869,16,'S','Dawson Forest Parking Lot, End of ROC Gear Stage.\r\n',0,'1970-01-01 00:00:00','yes','no',0,0,1,'running','trekking','APB5IANG','no'),(261,175,18,'S2','',3804672,762869,16,'S','Dawson Forest Parking/Start of Reality Bikes Stage 2. ',0,'1970-01-01 00:00:00','yes','no',0,0,1,'trekking','trekking','FMM9AIUL','no'),(262,175,19,'CP17','',3808899,758319,16,'S','Hidden Falls',0,'1970-01-01 00:00:00','no','no',0,0,1,'trekking','trekking','GDJOSA0Q','no'),(263,175,20,'CP18','',3812243,756112,16,'S','Tapped Spring of old homestead',0,'1970-01-01 00:00:00','no','no',0,0,1,'trekking','trekking','KB4UB0UU','no'),(264,175,21,'CP19','TA',3812993,756317,16,'S','Amicalola Creek Parking Lot TA.  ',0,'1970-01-01 00:00:00','yes','no',0,0,1,'trekking','biking','UK5E40DR','no'),(265,175,22,'CP20','',3815031,756434,16,'S','Steel Bridge',0,'1970-01-01 00:00:00','no','no',0,0,1,'biking','biking','DR3CB4SC','no'),(266,175,23,'CP21','TA',3825905,745624,16,'S','Road TA',0,'1970-01-01 00:00:00','yes','no',0,0,1,'biking','orienteering','SH67V154','no'),(267,175,24,'CP22','',3825905,745624,16,'S','Ropes',0,'1970-01-01 00:00:00','no','no',0,0,1,'ropes','ropes','IC67BD7C','no'),(268,175,25,'CP23','',3826871,746032,16,'S','Peak',0,'1970-01-01 00:00:00','no','no',0,0,1,'orienteering','orienteering','D34N5HNI','no'),(269,175,26,'CP24','',3826500,747728,16,'S','Stream Confluence',0,'1970-01-01 00:00:00','no','no',0,0,1,'orienteering','orienteering','KGSCK8TJ','no'),(270,175,27,'CP25','',3825645,746455,16,'S','Peak',0,'1970-01-01 00:00:00','no','no',0,0,1,'orienteering','orienteering','RJP07EPF','no'),(271,175,28,'CP26','',3826353,746443,16,'S','Reentrant',0,'1970-01-01 00:00:00','no','no',0,0,1,'orienteering','orienteering','UENDK1T3','no'),(272,175,29,'CP27','TA',3825905,745624,16,'S','FS Road TA.  This is also CP21.',0,'1970-01-01 00:00:00','yes','no',0,0,1,'orienteering','biking','LGSSCU06','no'),(273,175,30,'CP28','TA',3827452,752298,16,'S','Field',0,'1970-01-01 00:00:00','yes','no',0,0,1,'biking','running','A7RSM31I','no'),(274,175,31,'F','',3828562,752809,16,'S','Top of Falls.',0,'2010-05-16 14:00:00','yes','no',0,0,1,'running','running','AGQ5N3CO','no');
  /*!40000 ALTER TABLE `CP` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `CP_Visit_Rel`
  --
  
  DROP TABLE IF EXISTS `CP_Visit_Rel`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `CP_Visit_Rel` (
    `team_id` int(10) unsigned NOT NULL,
    `cp_id` int(10) unsigned NOT NULL,
    `division_place` smallint(5) unsigned NOT NULL default '0',
    `course_place` smallint(5) unsigned NOT NULL default '0',
    `last_modified` datetime NOT NULL default '1970-01-01 00:00:00',
    `arrival` datetime NOT NULL default '1970-01-01 00:00:00',
    `departure` datetime NOT NULL default '1970-01-01 00:00:00',
    `time_bonus_assessed` datetime NOT NULL default '1970-01-01 00:00:00',
    `time_penalty_assessed` datetime NOT NULL default '1970-01-01 00:00:00',
    `cp_bonus_assessed` tinyint(3) unsigned NOT NULL default '0',
    `cp_penalty_assessed` tinyint(3) unsigned NOT NULL default '0',
    `weight_bonus_assessed` smallint(5) unsigned NOT NULL default '0',
    `weight_penalty_assessed` smallint(5) unsigned NOT NULL default '0',
    `is_acquired` enum('default','no','yes') NOT NULL default 'no',
    `is_skipped` enum('default','no','yes') NOT NULL default 'no',
    `is_missed_cutoff` enum('default','no','yes') NOT NULL default 'no',
    `is_unofficial` enum('default','no','yes') NOT NULL default 'no',
    `is_incomplete` enum('default','no','yes') NOT NULL default 'no',
    `is_withdrawn` enum('default','no','yes') NOT NULL default 'no',
    `is_disqualified` enum('default','no','yes') NOT NULL default 'no',
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    `bonus_assessed_reason` varchar(256) NOT NULL default 'default',
    `penalty_assessed_reason` varchar(256) NOT NULL default 'default',
    PRIMARY KEY  (`team_id`,`cp_id`),
    KEY `CP_Visit_Rel_cp_id_fkc` (`cp_id`),
    CONSTRAINT `CP_Visit_Rel_cp_id_fkc` FOREIGN KEY (`cp_id`) REFERENCES `CP` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `CP_Visit_Rel_team_id_fkc` FOREIGN KEY (`team_id`) REFERENCES `TEAM` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `CP_Visit_Rel`
  --
  
  LOCK TABLES `CP_Visit_Rel` WRITE;
  /*!40000 ALTER TABLE `CP_Visit_Rel` DISABLE KEYS */;
  INSERT INTO `CP_Visit_Rel` VALUES (119,98,0,0,'2009-12-05 22:10:00','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(119,99,0,0,'2009-12-05 22:10:00','2009-12-05 16:17:00','2009-12-05 16:17:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(119,100,0,0,'2009-12-05 22:10:00','2009-12-05 16:17:00','2009-12-05 16:17:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(119,101,0,0,'2009-12-05 22:10:00','2009-12-05 16:17:00','2009-12-05 16:17:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(119,102,0,0,'2009-12-05 22:10:00','2009-12-05 16:17:00','2009-12-05 16:17:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(119,103,0,0,'2009-12-05 22:10:00','2009-12-05 16:17:00','2009-12-05 16:17:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(119,104,0,0,'2009-12-05 22:10:00','2009-12-05 16:17:00','2009-12-05 16:17:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(119,105,0,0,'2009-12-05 22:10:00','2009-12-05 16:17:00','2009-12-05 16:17:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(119,106,0,0,'2009-12-05 22:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(119,107,0,0,'2009-12-05 22:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(119,108,0,0,'2009-12-05 22:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(119,109,0,0,'2009-12-05 22:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(119,110,0,0,'2009-12-05 22:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(119,111,0,0,'2009-12-05 22:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(119,112,0,0,'2009-12-05 22:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(119,113,0,0,'2009-12-05 22:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(119,114,0,0,'2009-12-05 22:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(119,115,0,0,'2009-12-05 22:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(119,116,0,0,'2009-12-05 22:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(119,117,0,0,'2009-12-05 22:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(119,118,0,0,'2009-12-05 22:10:00','2009-12-05 16:17:00','2009-12-05 16:17:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,98,0,0,'2009-12-06 05:33:04','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,99,0,0,'2009-12-06 05:33:04','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,100,0,0,'2009-12-06 05:33:04','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,101,0,0,'2009-12-06 05:33:04','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,102,0,0,'2009-12-06 05:33:04','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,103,0,0,'2009-12-06 05:33:04','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,104,0,0,'2009-12-06 05:33:04','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,105,0,0,'2009-12-06 05:33:04','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,106,0,0,'2009-12-06 05:33:04','2009-12-05 16:10:00','2009-12-05 16:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,107,0,0,'2009-12-06 05:33:04','2009-12-05 16:10:00','2009-12-05 16:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,108,0,0,'2009-12-06 05:33:04','2009-12-05 16:10:00','2009-12-05 16:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,109,0,0,'2009-12-06 05:33:04','2009-12-05 16:10:00','2009-12-05 16:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,110,0,0,'2009-12-06 05:33:04','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(120,111,0,0,'2009-12-06 05:33:04','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(120,112,0,0,'2009-12-06 05:33:04','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(120,113,0,0,'2009-12-06 05:33:04','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(120,114,0,0,'2009-12-06 05:33:04','2009-12-05 16:10:00','2009-12-05 16:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(120,115,0,0,'2009-12-06 05:33:04','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(120,116,0,0,'2009-12-06 05:33:04','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(120,117,0,0,'2009-12-06 05:33:04','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(120,118,0,0,'2009-12-06 05:33:04','2009-12-05 18:10:00','2009-12-05 18:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,98,0,0,'2009-12-06 05:10:21','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,99,0,0,'2009-12-06 05:10:21','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,100,0,0,'2009-12-06 05:10:21','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,101,0,0,'2009-12-06 05:10:21','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,102,0,0,'2009-12-06 05:10:21','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,103,0,0,'2009-12-06 05:10:21','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,104,0,0,'2009-12-06 05:10:21','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,105,0,0,'2009-12-06 05:10:21','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,106,0,0,'2009-12-06 05:10:21','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(121,107,0,0,'2009-12-06 05:10:21','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(121,108,0,0,'2009-12-06 05:10:21','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(121,109,0,0,'2009-12-06 05:10:21','2009-12-05 17:30:00','2009-12-05 17:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,110,0,0,'2009-12-06 05:10:21','2009-12-05 17:30:00','2009-12-05 17:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,111,0,0,'2009-12-06 05:10:21','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(121,112,0,0,'2009-12-06 05:10:21','2009-12-05 19:12:00','2009-12-05 19:12:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,113,0,0,'2009-12-06 05:10:21','2009-12-05 19:12:00','2009-12-05 19:12:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,114,0,0,'2009-12-06 05:10:21','2009-12-05 19:12:00','2009-12-05 19:22:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,115,0,0,'2009-12-06 05:10:21','2009-12-05 17:30:00','2009-12-05 17:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,116,0,0,'2009-12-06 05:10:21','2009-12-05 17:30:00','2009-12-05 17:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,117,0,0,'2009-12-06 05:10:21','2009-12-05 17:30:00','2009-12-05 17:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(121,118,0,0,'2009-12-09 11:15:58','2009-12-05 20:55:00','2009-12-05 20:55:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(122,98,0,0,'2009-12-05 22:10:41','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(122,99,0,0,'2009-12-05 22:10:41','2009-12-05 15:35:00','2009-12-05 15:35:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(122,100,0,0,'2009-12-05 22:10:41','2009-12-05 15:35:00','2009-12-05 15:35:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(122,101,0,0,'2009-12-05 22:10:41','2009-12-05 15:35:00','2009-12-05 15:35:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(122,102,0,0,'2009-12-05 22:10:41','2009-12-05 15:35:00','2009-12-05 15:35:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(122,103,0,0,'2009-12-05 22:10:41','2009-12-05 15:35:00','2009-12-05 15:35:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(122,104,0,0,'2009-12-05 22:10:41','2009-12-05 15:35:00','2009-12-05 15:35:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(122,105,0,0,'2009-12-05 22:10:41','2009-12-05 15:35:00','2009-12-05 15:35:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(124,98,0,0,'2009-12-05 20:43:54','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(124,99,0,0,'2009-12-05 20:43:54','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(124,100,0,0,'2009-12-05 20:43:54','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(124,101,0,0,'2009-12-05 20:43:54','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(124,102,0,0,'2009-12-05 20:43:54','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(124,103,0,0,'2009-12-05 20:43:54','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(124,104,0,0,'2009-12-05 20:43:54','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(124,105,0,0,'2009-12-05 20:43:54','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(125,98,0,0,'2009-12-05 20:44:22','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(125,99,0,0,'2009-12-05 20:44:22','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(125,100,0,0,'2009-12-05 20:44:22','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(125,101,0,0,'2009-12-05 20:44:22','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(125,102,0,0,'2009-12-05 20:44:22','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(125,103,0,0,'2009-12-05 20:44:22','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(125,104,0,0,'2009-12-05 20:44:22','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(125,105,0,0,'2009-12-05 20:44:22','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(126,98,0,0,'2009-12-06 02:13:04','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(126,99,0,0,'2009-12-06 02:13:04','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(126,100,0,0,'2009-12-06 02:13:04','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(126,101,0,0,'2009-12-06 02:13:04','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(126,102,0,0,'2009-12-06 02:13:04','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(126,103,0,0,'2009-12-06 02:13:04','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(126,104,0,0,'2009-12-06 02:13:04','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(126,105,0,0,'2009-12-06 02:13:04','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(129,98,0,0,'2009-12-05 20:10:16','2009-12-05 09:30:00','2009-12-05 09:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(129,99,0,0,'2009-12-05 20:10:16','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(129,100,0,0,'2009-12-05 20:10:16','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(129,101,0,0,'2009-12-05 20:10:16','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(129,102,0,0,'2009-12-05 20:10:16','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(129,103,0,0,'2009-12-05 20:10:16','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(129,104,0,0,'2009-12-05 20:10:16','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(129,105,0,0,'2009-12-05 20:10:16','2009-12-05 14:05:00','2009-12-05 14:35:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,98,0,0,'2009-12-07 11:03:13','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,99,0,0,'2009-12-07 11:03:13','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(130,100,0,0,'2009-12-07 11:03:13','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(130,101,0,0,'2009-12-07 11:03:13','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(130,102,0,0,'2009-12-07 11:03:13','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(130,103,0,0,'2009-12-07 11:03:13','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(130,104,0,0,'2009-12-07 11:03:13','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(130,105,0,0,'2009-12-07 11:03:13','2009-12-05 18:28:00','2009-12-05 18:28:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,106,0,0,'2009-12-07 11:03:13','2009-12-05 14:30:00','2009-12-05 14:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,107,0,0,'2009-12-07 11:03:13','2009-12-05 14:30:00','2009-12-05 14:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,108,0,0,'2009-12-07 11:03:13','2009-12-05 14:30:00','2009-12-05 14:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,109,0,0,'2009-12-07 11:03:13','2009-12-05 12:35:00','2009-12-05 12:35:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,110,0,0,'2009-12-07 11:03:13','2009-12-05 14:30:00','2009-12-05 14:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,111,0,0,'2009-12-07 11:03:13','2009-12-05 14:30:00','2009-12-05 14:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,112,0,0,'2009-12-07 11:03:13','2009-12-05 14:30:00','2009-12-05 14:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,113,0,0,'2009-12-07 11:03:13','2009-12-05 14:30:00','2009-12-05 14:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,114,0,0,'2009-12-07 11:03:13','2009-12-05 14:30:00','2009-12-05 14:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,115,0,0,'2009-12-07 11:03:13','2009-12-05 14:30:00','2009-12-05 14:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,116,0,0,'2009-12-07 11:03:13','2009-12-05 14:30:00','2009-12-05 14:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,117,0,0,'2009-12-07 11:03:13','2009-12-05 14:30:00','2009-12-05 14:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(130,118,0,0,'2009-12-07 11:03:13','2009-12-05 16:25:00','2009-12-05 16:25:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(131,98,0,0,'2009-12-05 20:45:01','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(131,99,0,0,'2009-12-05 20:45:01','2009-12-05 15:10:00','2009-12-05 15:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(131,100,0,0,'2009-12-05 20:45:01','2009-12-05 15:10:00','2009-12-05 15:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(131,101,0,0,'2009-12-05 20:45:01','2009-12-05 15:10:00','2009-12-05 15:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(131,102,0,0,'2009-12-05 20:45:01','2009-12-05 15:10:00','2009-12-05 15:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(131,103,0,0,'2009-12-05 20:45:01','2009-12-05 15:10:00','2009-12-05 15:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(131,104,0,0,'2009-12-05 20:45:01','2009-12-05 15:10:00','2009-12-05 15:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(131,105,0,0,'2009-12-05 20:45:01','2009-12-05 15:10:00','2009-12-05 15:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(132,98,0,0,'2009-12-06 02:12:35','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(132,109,0,0,'2009-12-06 02:12:35','2009-12-05 12:00:00','2009-12-05 12:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(132,111,0,0,'2009-12-06 02:12:35','2009-12-05 14:25:00','2009-12-05 14:25:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(132,112,0,0,'2009-12-06 02:12:35','2009-12-05 14:25:00','2009-12-05 14:25:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(132,113,0,0,'2009-12-06 02:12:35','2009-12-05 14:25:00','2009-12-05 14:25:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(132,114,0,0,'2009-12-06 02:12:35','2009-12-05 14:25:00','2009-12-05 14:25:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(132,118,0,0,'2009-12-06 02:12:35','2009-12-05 19:15:00','2009-12-05 19:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',7,0,0,0,'no','no','no','no','no','no','no','no','Marked as 11 total CPs, so adding bonus here.','default'),(133,98,0,0,'2009-12-06 02:16:05','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(133,118,0,0,'2009-12-06 02:16:05','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(134,98,0,0,'2009-12-06 02:16:35','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(134,118,0,0,'2009-12-06 02:16:35','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(135,98,0,0,'2009-12-06 02:18:58','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(135,99,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,100,0,0,'2009-12-06 02:18:58','2009-12-05 14:51:00','2009-12-05 14:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(135,101,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,102,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,103,0,0,'2009-12-06 02:18:58','2009-12-05 14:51:00','2009-12-05 14:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(135,104,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,105,0,0,'2009-12-06 02:18:58','2009-12-05 14:51:00','2009-12-05 14:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(135,106,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,107,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,108,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,109,0,0,'2009-12-06 02:18:58','2009-12-05 17:10:00','2009-12-05 17:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(135,110,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,111,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,112,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,113,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,114,0,0,'2009-12-06 02:18:58','2009-12-05 17:10:00','2009-12-05 17:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(135,115,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,116,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,117,0,0,'2009-12-06 02:18:58','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(135,118,0,0,'2009-12-06 02:18:58','2009-12-05 18:47:00','2009-12-05 18:47:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(136,98,0,0,'2009-12-10 15:45:23','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(136,99,0,0,'2009-12-10 15:45:24','2009-12-05 14:42:00','2009-12-05 14:42:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(136,100,0,0,'2009-12-10 15:45:24','2009-12-05 14:42:00','2009-12-05 14:42:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(136,101,0,0,'2009-12-10 15:45:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(136,102,0,0,'2009-12-10 15:45:24','2009-12-05 14:42:00','2009-12-05 14:42:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(136,103,0,0,'2009-12-10 15:45:24','2009-12-05 14:42:00','2009-12-05 14:42:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(136,104,0,0,'2009-12-10 15:45:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(136,105,0,0,'2009-12-10 15:45:24','2009-12-05 14:42:00','2009-12-05 14:42:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(136,118,0,0,'2009-12-10 15:45:24','2009-12-05 14:42:00','2009-12-05 14:42:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(137,98,0,0,'2009-12-05 20:49:29','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(137,99,0,0,'2009-12-05 20:49:29','2009-12-05 14:52:00','2009-12-05 14:52:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(137,100,0,0,'2009-12-05 20:49:29','2009-12-05 14:52:00','2009-12-05 14:52:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(137,101,0,0,'2009-12-05 20:49:29','2009-12-05 14:52:00','2009-12-05 14:52:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(137,102,0,0,'2009-12-05 20:49:29','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,103,0,0,'2009-12-05 20:49:30','2009-12-05 14:52:00','2009-12-05 14:52:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(137,104,0,0,'2009-12-05 20:49:30','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,105,0,0,'2009-12-05 20:49:30','2009-12-05 14:52:00','2009-12-05 14:52:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(137,106,0,0,'2009-12-05 20:49:30','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,107,0,0,'2009-12-05 20:49:30','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,108,0,0,'2009-12-05 20:49:30','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,109,0,0,'2009-12-05 20:49:30','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,110,0,0,'2009-12-05 20:49:30','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,111,0,0,'2009-12-05 20:49:30','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,112,0,0,'2009-12-05 20:49:30','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,113,0,0,'2009-12-05 20:49:30','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,114,0,0,'2009-12-05 20:49:30','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,115,0,0,'2009-12-05 20:49:30','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,116,0,0,'2009-12-05 20:49:30','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,117,0,0,'2009-12-05 20:49:30','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(137,118,0,0,'2009-12-05 20:49:30','2009-12-05 14:52:00','2009-12-05 14:52:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(138,98,0,0,'2009-12-06 02:22:12','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(138,99,0,0,'2009-12-06 02:22:12','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(138,100,0,0,'2009-12-06 02:22:12','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(138,101,0,0,'2009-12-06 02:22:12','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(138,102,0,0,'2009-12-06 02:22:12','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(138,103,0,0,'2009-12-06 02:22:12','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(138,104,0,0,'2009-12-06 02:22:12','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(138,105,0,0,'2009-12-06 02:22:12','2009-12-05 14:10:00','2009-12-05 14:11:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(138,118,0,0,'2009-12-06 02:22:12','2009-12-05 18:10:00','2009-12-05 18:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',3,0,0,0,'no','no','no','no','no','no','no','no','Sheet says he got 9 total, so added 3 here.','default'),(139,98,0,0,'2009-12-06 05:06:07','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(139,99,0,0,'2009-12-06 05:06:07','2009-12-05 14:50:00','2009-12-05 14:50:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(139,100,0,0,'2009-12-06 05:06:07','2009-12-05 14:50:00','2009-12-05 14:50:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(139,101,0,0,'2009-12-06 05:06:07','2009-12-05 14:50:00','2009-12-05 14:50:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(139,102,0,0,'2009-12-06 05:06:07','2009-12-05 14:50:00','2009-12-05 14:50:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(139,103,0,0,'2009-12-06 05:06:07','2009-12-05 14:50:00','2009-12-05 14:50:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(139,104,0,0,'2009-12-06 05:06:07','2009-12-05 14:50:00','2009-12-05 14:50:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(139,105,0,0,'2009-12-06 05:06:07','2009-12-05 14:50:00','2009-12-05 14:50:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(139,106,0,0,'2009-12-06 05:06:07','2009-12-05 18:39:00','2009-12-05 18:39:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(139,107,0,0,'2009-12-06 05:06:07','2009-12-05 18:39:00','2009-12-05 18:39:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(139,108,0,0,'2009-12-06 05:06:07','2009-12-05 18:39:00','2009-12-05 18:39:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(139,109,0,0,'2009-12-06 05:06:07','2009-12-05 18:39:00','2009-12-05 18:39:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(139,110,0,0,'2009-12-06 05:06:07','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(139,111,0,0,'2009-12-06 05:06:07','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(139,112,0,0,'2009-12-06 05:06:07','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(139,113,0,0,'2009-12-06 05:06:07','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(139,114,0,0,'2009-12-06 05:06:07','2009-12-05 18:39:00','2009-12-05 18:39:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(139,115,0,0,'2009-12-06 05:06:07','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(139,116,0,0,'2009-12-06 05:06:07','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(139,117,0,0,'2009-12-06 05:06:07','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(139,118,0,0,'2009-12-06 05:06:07','2009-12-05 21:30:00','2009-12-05 21:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(144,98,0,0,'2009-12-06 02:23:11','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(144,99,0,0,'2009-12-06 02:23:11','2009-12-05 15:24:00','2009-12-05 15:24:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(144,100,0,0,'2009-12-06 02:23:11','2009-12-05 15:24:00','2009-12-05 15:24:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(144,101,0,0,'2009-12-06 02:23:11','2009-12-05 15:24:00','2009-12-05 15:24:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(144,102,0,0,'2009-12-06 02:23:11','2009-12-05 15:24:00','2009-12-05 15:24:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(144,103,0,0,'2009-12-06 02:23:11','2009-12-05 15:24:00','2009-12-05 15:24:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(144,104,0,0,'2009-12-06 02:23:11','2009-12-05 15:24:00','2009-12-05 15:24:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(144,105,0,0,'2009-12-06 02:23:11','2009-12-05 15:24:00','2009-12-05 15:24:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(144,106,0,0,'2009-12-06 02:23:11','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(144,107,0,0,'2009-12-06 02:23:11','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(144,108,0,0,'2009-12-06 02:23:11','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(144,109,0,0,'2009-12-06 02:23:11','2009-12-05 18:50:00','2009-12-05 18:50:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(144,110,0,0,'2009-12-06 02:23:11','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(144,111,0,0,'2009-12-06 02:23:11','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(144,112,0,0,'2009-12-06 02:23:11','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(144,113,0,0,'2009-12-06 02:23:11','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(144,114,0,0,'2009-12-06 02:23:11','2009-12-05 18:59:00','2009-12-05 18:59:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(144,115,0,0,'2009-12-06 02:23:11','2009-12-05 18:50:00','2009-12-05 18:50:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(144,116,0,0,'2009-12-06 02:23:11','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(144,117,0,0,'2009-12-06 02:23:11','2009-12-05 18:50:00','2009-12-05 18:50:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(144,118,0,0,'2009-12-06 02:23:11','2009-12-05 17:18:00','2009-12-05 17:18:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(145,98,0,0,'2009-12-05 22:11:30','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(145,99,0,0,'2009-12-05 22:11:30','2009-12-05 15:45:00','2009-12-05 15:45:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(145,100,0,0,'2009-12-05 22:11:30','2009-12-05 15:45:00','2009-12-05 15:45:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(145,101,0,0,'2009-12-05 22:11:30','2009-12-05 15:45:00','2009-12-05 15:45:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(145,102,0,0,'2009-12-05 22:11:31','2009-12-05 15:45:00','2009-12-05 15:45:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(145,103,0,0,'2009-12-05 22:11:31','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(145,104,0,0,'2009-12-05 22:11:31','2009-12-05 15:45:00','2009-12-05 15:45:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(145,105,0,0,'2009-12-05 22:11:31','2009-12-05 15:45:00','2009-12-05 15:45:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(146,98,0,0,'2009-12-05 18:00:56','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(147,98,0,0,'2009-12-06 02:27:28','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(147,105,0,0,'2009-12-06 02:27:28','2009-12-05 04:28:00','2009-12-05 04:28:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(148,98,0,0,'2009-12-05 20:55:36','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(148,99,0,0,'2009-12-05 20:55:36','2009-12-05 15:25:00','2009-12-05 15:25:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(148,100,0,0,'2009-12-05 20:55:36','2009-12-05 15:25:00','2009-12-05 15:25:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(148,101,0,0,'2009-12-05 20:55:36','2009-12-05 15:25:00','2009-12-05 15:25:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(148,102,0,0,'2009-12-05 20:55:36','2009-12-05 15:25:00','2009-12-05 15:25:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(148,103,0,0,'2009-12-05 20:55:36','2009-12-05 15:25:00','2009-12-05 15:25:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(148,104,0,0,'2009-12-05 20:55:36','2009-12-05 15:25:00','2009-12-05 15:25:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(148,105,0,0,'2009-12-05 20:55:36','2009-12-05 15:25:00','2009-12-05 15:25:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,98,0,0,'2009-12-07 11:03:31','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,99,0,0,'2009-12-07 11:03:31','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(149,100,0,0,'2009-12-07 11:03:31','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(149,101,0,0,'2009-12-07 11:03:31','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(149,102,0,0,'2009-12-07 11:03:31','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(149,103,0,0,'2009-12-07 11:03:31','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(149,104,0,0,'2009-12-07 11:03:31','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(149,105,0,0,'2009-12-07 11:03:31','2009-12-05 06:28:00','2009-12-05 06:28:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,106,0,0,'2009-12-07 11:03:31','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,107,0,0,'2009-12-07 11:03:31','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,108,0,0,'2009-12-07 11:03:31','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,109,0,0,'2009-12-07 11:03:31','2009-12-05 12:35:00','2009-12-05 12:35:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,110,0,0,'2009-12-07 11:03:31','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,111,0,0,'2009-12-07 11:03:31','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,112,0,0,'2009-12-07 11:03:31','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,113,0,0,'2009-12-07 11:03:31','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,114,0,0,'2009-12-07 11:03:31','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,115,0,0,'2009-12-07 11:03:31','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,116,0,0,'2009-12-07 11:03:31','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,117,0,0,'2009-12-07 11:03:31','2009-12-05 14:20:00','2009-12-05 14:20:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(149,118,0,0,'2009-12-07 11:03:31','2009-12-05 16:30:00','2009-12-05 16:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,98,0,0,'2009-12-08 14:51:54','2009-12-05 09:30:00','2009-12-05 09:48:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,99,0,0,'2009-12-08 14:51:54','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,100,0,0,'2009-12-08 14:51:54','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,101,0,0,'2009-12-08 14:51:54','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,102,0,0,'2009-12-08 14:51:54','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,103,0,0,'2009-12-08 14:51:54','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,104,0,0,'2009-12-08 14:51:54','2009-12-05 14:10:00','2009-12-05 14:10:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,105,0,0,'2009-12-08 14:51:54','2009-12-05 14:10:00','2009-12-05 14:11:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,106,0,0,'2009-12-08 14:51:54','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(150,107,0,0,'2009-12-08 14:51:54','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(150,108,0,0,'2009-12-08 14:51:54','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(150,109,0,0,'2009-12-08 14:51:54','2009-12-05 17:30:00','2009-12-05 17:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,110,0,0,'2009-12-08 14:51:54','2009-12-05 19:06:00','2009-12-05 19:06:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,111,0,0,'2009-12-08 14:51:54','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(150,112,0,0,'2009-12-08 14:51:54','2009-12-05 19:06:00','2009-12-05 19:06:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,113,0,0,'2009-12-08 14:51:54','2009-12-05 19:06:00','2009-12-05 19:06:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,114,0,0,'2009-12-08 14:51:54','2009-12-05 19:06:00','2009-12-05 19:06:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,115,0,0,'2009-12-08 14:51:54','2009-12-05 19:06:00','2009-12-05 19:06:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,116,0,0,'2009-12-08 14:51:54','2009-12-05 19:06:00','2009-12-05 19:06:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,117,0,0,'2009-12-08 14:51:54','2009-12-05 19:06:00','2009-12-05 19:06:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(150,118,0,0,'2009-12-08 14:51:54','2009-12-05 20:35:00','2009-12-05 20:35:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,98,0,0,'2009-12-06 01:58:01','2009-12-05 09:30:00','2009-12-05 09:44:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,99,0,0,'2009-12-06 01:58:01','2009-12-05 13:54:00','2009-12-05 13:54:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,100,0,0,'2009-12-06 01:58:01','2009-12-05 13:54:00','2009-12-05 13:54:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,101,0,0,'2009-12-06 01:58:01','2009-12-05 13:54:00','2009-12-05 13:54:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,102,0,0,'2009-12-06 01:58:01','2009-12-05 13:54:00','2009-12-05 13:54:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,103,0,0,'2009-12-06 01:58:01','2009-12-05 13:54:00','2009-12-05 13:54:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,104,0,0,'2009-12-06 01:58:01','2009-12-05 13:54:00','2009-12-05 13:54:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,105,0,0,'2009-12-06 01:58:01','2009-12-05 13:54:00','2009-12-05 13:58:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,106,0,0,'2009-12-06 01:58:01','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(151,107,0,0,'2009-12-06 01:58:01','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(151,108,0,0,'2009-12-06 01:58:01','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(151,109,0,0,'2009-12-06 01:58:01','2009-12-05 18:15:00','2009-12-05 18:35:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,110,0,0,'2009-12-06 01:58:01','2009-12-05 18:15:00','2009-12-05 18:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,111,0,0,'2009-12-06 01:58:01','2009-12-05 19:07:00','2009-12-05 19:07:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,112,0,0,'2009-12-06 01:58:01','2009-12-05 19:07:00','2009-12-05 19:07:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,113,0,0,'2009-12-06 01:58:01','2009-12-05 19:07:00','2009-12-05 19:07:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,114,0,0,'2009-12-06 01:58:01','2009-12-05 19:07:00','2009-12-05 19:07:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,115,0,0,'2009-12-06 01:58:01','2009-12-05 18:15:00','2009-12-05 18:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,116,0,0,'2009-12-06 01:58:01','2009-12-05 18:15:00','2009-12-05 18:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,117,0,0,'2009-12-06 01:58:01','2009-12-05 18:15:00','2009-12-05 18:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(151,118,0,0,'2009-12-06 01:58:01','2009-12-05 20:35:00','2009-12-05 20:35:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(152,98,0,0,'2009-12-06 02:29:34','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(152,105,0,0,'2009-12-06 02:29:34','2009-12-05 04:15:00','2009-12-05 04:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(152,118,0,0,'2009-12-06 02:29:34','2009-12-05 04:15:00','2009-12-05 04:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',3,0,0,0,'no','no','no','no','no','no','no','no','Got 3 CPs on WT.','default'),(153,98,0,0,'2009-12-05 18:00:56','2009-12-05 09:30:00','2009-12-05 09:50:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(154,98,0,0,'2009-12-06 02:32:40','2009-12-05 09:30:00','2009-12-05 09:50:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(154,105,0,0,'2009-12-06 02:32:40','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(154,118,0,0,'2009-12-06 02:32:40','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(155,98,0,0,'2009-12-05 20:17:23','2009-12-05 09:30:00','2009-12-05 09:50:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(155,99,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,100,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,101,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,102,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,103,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,104,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,105,0,0,'2009-12-05 20:17:24','2009-12-05 13:54:00','2009-12-05 13:54:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(155,106,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,107,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,108,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,109,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,110,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,111,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,112,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,113,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,114,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,115,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,116,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,117,0,0,'2009-12-05 20:17:24','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(155,118,0,0,'2009-12-05 20:17:24','2009-12-05 13:54:00','2009-12-05 13:54:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(156,98,0,0,'2009-12-06 05:15:46','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(156,99,0,0,'2009-12-06 05:15:46','2009-12-05 14:05:00','2009-12-05 14:05:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(156,100,0,0,'2009-12-06 05:15:46','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,101,0,0,'2009-12-06 05:15:46','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,102,0,0,'2009-12-06 05:15:46','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,103,0,0,'2009-12-06 05:15:46','2009-12-05 14:05:00','2009-12-05 14:05:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,104,0,0,'2009-12-06 05:15:46','2009-12-05 14:05:00','2009-12-05 14:05:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(156,105,0,0,'2009-12-06 05:15:46','2009-12-05 14:05:00','2009-12-05 14:09:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(156,106,0,0,'2009-12-06 05:15:46','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,107,0,0,'2009-12-06 05:15:47','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,108,0,0,'2009-12-06 05:15:47','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,109,0,0,'2009-12-06 05:15:47','2009-12-05 18:00:00','2009-12-05 18:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(156,110,0,0,'2009-12-06 05:15:47','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,111,0,0,'2009-12-06 05:15:47','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,112,0,0,'2009-12-06 05:15:47','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,113,0,0,'2009-12-06 05:15:47','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,114,0,0,'2009-12-06 05:15:47','2009-12-05 18:15:00','2009-12-05 18:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(156,115,0,0,'2009-12-06 05:15:47','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,116,0,0,'2009-12-06 05:15:47','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,117,0,0,'2009-12-06 05:15:47','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(156,118,0,0,'2009-12-06 05:15:47','2009-12-05 09:15:00','2009-12-05 09:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(158,98,0,0,'2009-12-06 02:01:28','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(158,99,0,0,'2009-12-06 02:01:28','2009-12-05 16:04:00','2009-12-05 16:04:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(158,100,0,0,'2009-12-06 02:01:28','2009-12-05 16:04:00','2009-12-05 16:04:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(158,101,0,0,'2009-12-06 02:01:28','2009-12-05 16:04:00','2009-12-05 16:04:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(158,102,0,0,'2009-12-06 02:01:28','2009-12-05 16:04:00','2009-12-05 16:04:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(158,103,0,0,'2009-12-06 02:01:28','2009-12-05 16:04:00','2009-12-05 16:04:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(158,104,0,0,'2009-12-06 02:01:28','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(158,105,0,0,'2009-12-06 02:01:28','2009-12-05 16:04:00','2009-12-05 16:04:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(158,106,0,0,'2009-12-06 02:01:28','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(158,107,0,0,'2009-12-06 02:01:28','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(158,108,0,0,'2009-12-06 02:01:28','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(158,109,0,0,'2009-12-06 02:01:28','2009-12-05 07:51:00','2009-12-05 07:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(158,110,0,0,'2009-12-06 02:01:28','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(158,111,0,0,'2009-12-06 02:01:28','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(158,112,0,0,'2009-12-06 02:01:28','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(158,113,0,0,'2009-12-06 02:01:28','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(158,114,0,0,'2009-12-06 02:01:28','2009-12-05 07:51:00','2009-12-05 07:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(158,115,0,0,'2009-12-06 02:01:28','2009-12-05 07:51:00','2009-12-05 07:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(158,116,0,0,'2009-12-06 02:01:28','2009-12-05 07:51:00','2009-12-05 07:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(158,117,0,0,'2009-12-06 02:01:28','2009-12-05 07:51:00','2009-12-05 07:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(158,118,0,0,'2009-12-06 02:01:28','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(159,98,0,0,'2009-12-05 22:49:03','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(159,109,0,0,'2009-12-05 22:49:03','2009-12-05 13:25:00','2009-12-05 13:25:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,98,0,0,'2009-12-06 05:09:47','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,99,0,0,'2009-12-06 05:09:47','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,100,0,0,'2009-12-06 05:09:47','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,101,0,0,'2009-12-06 05:09:47','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,102,0,0,'2009-12-06 05:09:47','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,103,0,0,'2009-12-06 05:09:47','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,104,0,0,'2009-12-06 05:09:47','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,105,0,0,'2009-12-06 05:09:47','2009-12-05 14:40:00','2009-12-05 14:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,106,0,0,'2009-12-06 05:09:47','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(160,107,0,0,'2009-12-06 05:09:47','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(160,108,0,0,'2009-12-06 05:09:47','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(160,109,0,0,'2009-12-06 05:09:47','2009-12-05 17:30:00','2009-12-05 17:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,110,0,0,'2009-12-06 05:09:47','2009-12-05 17:30:00','2009-12-05 17:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,111,0,0,'2009-12-06 05:09:47','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(160,112,0,0,'2009-12-06 05:09:47','2009-12-05 19:12:00','2009-12-05 19:12:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,113,0,0,'2009-12-06 05:09:47','2009-12-05 19:12:00','2009-12-05 19:12:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,114,0,0,'2009-12-06 05:09:47','2009-12-05 19:12:00','2009-12-05 19:22:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,115,0,0,'2009-12-06 05:09:47','2009-12-05 17:30:00','2009-12-05 17:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,116,0,0,'2009-12-06 05:09:47','2009-12-05 17:30:00','2009-12-05 17:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,117,0,0,'2009-12-06 05:09:47','2009-12-05 17:30:00','2009-12-05 17:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(160,118,0,0,'2009-12-09 11:16:18','2009-12-05 20:55:00','2009-12-05 20:55:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(161,98,0,0,'2009-12-05 22:38:29','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(161,99,0,0,'2009-12-05 22:38:29','2009-12-05 15:40:00','2009-12-05 15:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(161,100,0,0,'2009-12-05 22:38:29','2009-12-05 15:40:00','2009-12-05 15:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(161,101,0,0,'2009-12-05 22:38:29','2009-12-05 15:40:00','2009-12-05 15:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(161,102,0,0,'2009-12-05 22:38:29','2009-12-05 15:40:00','2009-12-05 15:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(161,103,0,0,'2009-12-05 22:38:29','2009-12-05 15:40:00','2009-12-05 15:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(161,104,0,0,'2009-12-05 22:38:29','2009-12-05 15:40:00','2009-12-05 15:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(161,105,0,0,'2009-12-05 22:38:29','2009-12-05 15:40:00','2009-12-05 15:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(161,106,0,0,'2009-12-05 22:38:29','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(161,107,0,0,'2009-12-05 22:38:29','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(161,108,0,0,'2009-12-05 22:38:29','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(161,109,0,0,'2009-12-05 22:38:29','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(161,110,0,0,'2009-12-05 22:38:29','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(161,111,0,0,'2009-12-05 22:38:29','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(161,112,0,0,'2009-12-05 22:38:29','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(161,113,0,0,'2009-12-05 22:38:29','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(161,114,0,0,'2009-12-05 22:38:29','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(161,115,0,0,'2009-12-05 22:38:29','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(161,116,0,0,'2009-12-05 22:38:29','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(161,117,0,0,'2009-12-05 22:38:29','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(161,118,0,0,'2009-12-05 22:38:29','2009-12-05 15:40:00','2009-12-05 15:40:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(168,98,0,0,'2009-12-06 02:09:50','2009-12-05 09:30:00','2009-12-05 09:51:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(168,99,0,0,'2009-12-06 02:09:50','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(168,100,0,0,'2009-12-06 02:09:50','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(168,101,0,0,'2009-12-06 02:09:50','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(168,102,0,0,'2009-12-06 02:09:50','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(168,103,0,0,'2009-12-06 02:09:50','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(168,104,0,0,'2009-12-06 02:09:50','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(168,118,0,0,'2009-12-06 02:09:50','2009-12-05 04:30:00','2009-12-05 04:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(170,98,0,0,'2009-12-05 22:32:56','2009-12-05 09:30:00','2009-12-05 10:05:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(170,99,0,0,'2009-12-05 22:32:56','2009-12-05 16:15:00','2009-12-05 16:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(170,100,0,0,'2009-12-05 22:32:56','2009-12-05 16:15:00','2009-12-05 16:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(170,101,0,0,'2009-12-05 22:32:56','2009-12-05 16:15:00','2009-12-05 16:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(170,102,0,0,'2009-12-05 22:32:56','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','yes','no','no','no','no','no','no','default','default'),(170,103,0,0,'2009-12-05 22:32:56','2009-12-05 16:15:00','2009-12-05 16:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(170,104,0,0,'2009-12-05 22:32:56','2009-12-05 16:15:00','2009-12-05 16:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default'),(170,105,0,0,'2009-12-05 22:32:56','2009-12-05 16:15:00','2009-12-05 16:15:00','1970-01-01 00:00:00','1970-01-01 00:00:00',0,0,0,0,'no','no','no','no','no','no','no','no','default','default');
  /*!40000 ALTER TABLE `CP_Visit_Rel` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `Competitor_Docs_Rel`
  --
  
  DROP TABLE IF EXISTS `Competitor_Docs_Rel`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `Competitor_Docs_Rel` (
    `competitor_id` int(10) unsigned NOT NULL,
    `event_id` int(10) unsigned NOT NULL,
    `usara` enum('default','no','yes') NOT NULL default 'no',
    `media_release` enum('default','no','yes') NOT NULL default 'no',
    `hold_harmless` enum('default','no','yes') NOT NULL default 'no',
    `doc01_name` varchar(64) NOT NULL default 'default',
    `doc01` enum('default','no','yes') NOT NULL default 'no',
    `doc02_name` varchar(64) NOT NULL default 'default',
    `doc02` enum('default','no','yes') NOT NULL default 'no',
    `doc03_name` varchar(64) NOT NULL default 'default',
    `doc03` enum('default','no','yes') NOT NULL default 'no',
    `doc04_name` varchar(64) NOT NULL default 'default',
    `doc04` enum('default','no','yes') NOT NULL default 'no',
    `doc05_name` varchar(64) NOT NULL default 'default',
    `doc05` enum('default','no','yes') NOT NULL default 'no',
    `doc06_name` varchar(64) NOT NULL default 'default',
    `doc06` enum('default','no','yes') NOT NULL default 'no',
    `doc07_name` varchar(64) NOT NULL default 'default',
    `doc07` enum('default','no','yes') NOT NULL default 'no',
    `doc08_name` varchar(64) NOT NULL default 'default',
    `doc08` enum('default','no','yes') NOT NULL default 'no',
    `doc09_name` varchar(64) NOT NULL default 'default',
    `doc09` enum('default','no','yes') NOT NULL default 'no',
    `doc10_name` varchar(64) NOT NULL default 'default',
    `doc10` enum('default','no','yes') NOT NULL default 'no',
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`competitor_id`,`event_id`),
    KEY `Competitor_Docs_Rel_event_id_fkc` (`event_id`),
    CONSTRAINT `Competitor_Docs_Rel_competitor_id_fkc` FOREIGN KEY (`competitor_id`) REFERENCES `COMPETITOR` (`id`) ON UPDATE CASCADE,
    CONSTRAINT `Competitor_Docs_Rel_event_id_fkc` FOREIGN KEY (`event_id`) REFERENCES `EVENT` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `Competitor_Docs_Rel`
  --
  
  LOCK TABLES `Competitor_Docs_Rel` WRITE;
  /*!40000 ALTER TABLE `Competitor_Docs_Rel` DISABLE KEYS */;
  /*!40000 ALTER TABLE `Competitor_Docs_Rel` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `DATA_RESOURCE`
  --
  
  DROP TABLE IF EXISTS `DATA_RESOURCE`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `DATA_RESOURCE` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `admin_id` int(10) unsigned default NULL,
    PRIMARY KEY  (`id`),
    KEY `DATA_RESOURCE_admin_id_fkc` (`admin_id`),
    CONSTRAINT `DATA_RESOURCE_admin_id_fkc` FOREIGN KEY (`admin_id`) REFERENCES `ADMIN` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
  ) ENGINE=InnoDB AUTO_INCREMENT=275 DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `DATA_RESOURCE`
  --
  
  LOCK TABLES `DATA_RESOURCE` WRITE;
  /*!40000 ALTER TABLE `DATA_RESOURCE` DISABLE KEYS */;
  INSERT INTO `DATA_RESOURCE` VALUES (57,70),(60,70),(70,70),(71,70),(95,70),(96,70),(97,70),(98,70),(99,70),(100,70),(101,70),(102,70),(103,70),(104,70),(105,70),(106,70),(107,70),(108,70),(109,70),(110,70),(111,70),(112,70),(113,70),(114,70),(115,70),(116,70),(117,70),(118,70),(119,70),(120,70),(121,70),(122,70),(123,70),(124,70),(125,70),(126,70),(127,70),(128,70),(129,70),(130,70),(131,70),(132,70),(133,70),(134,70),(135,70),(136,70),(137,70),(138,70),(139,70),(140,70),(141,70),(142,70),(143,70),(144,70),(145,70),(146,70),(147,70),(148,70),(149,70),(150,70),(151,70),(152,70),(153,70),(154,70),(155,70),(156,70),(157,70),(158,70),(159,70),(160,70),(161,70),(163,70),(164,70),(165,70),(168,70),(170,70),(171,70),(172,70),(173,70),(174,70),(175,70),(177,70),(179,70),(180,70),(181,70),(182,70),(183,70),(184,70),(185,70),(186,70),(187,70),(188,70),(189,70),(190,70),(191,70),(192,70),(193,70),(194,70),(195,70),(196,70),(197,70),(198,70),(199,70),(200,70),(201,70),(202,70),(203,70),(204,70),(205,70),(206,70),(207,70),(208,70),(209,70),(210,70),(211,70),(212,70),(213,70),(214,70),(215,70),(216,70),(217,70),(218,70),(219,70),(220,70),(221,70),(222,70),(223,70),(224,70),(225,70),(226,70),(227,70),(228,70),(229,70),(230,70),(231,70),(232,70),(233,70),(234,70),(235,70),(236,70),(237,70),(238,70),(239,70),(240,70),(241,70),(242,70),(243,70),(244,70),(245,70),(246,70),(247,70),(248,70),(249,70),(250,70),(251,70),(252,70),(256,70),(257,70),(258,70),(259,70),(260,70),(261,70),(262,70),(263,70),(264,70),(265,70),(266,70),(267,70),(268,70),(269,70),(270,70),(271,70),(272,70),(273,70),(274,70);
  /*!40000 ALTER TABLE `DATA_RESOURCE` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `DIVISION`
  --
  
  DROP TABLE IF EXISTS `DIVISION`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `DIVISION` (
    `id` int(10) unsigned NOT NULL,
    `event_id` int(10) unsigned NOT NULL,
    `name` varchar(64) NOT NULL default 'default',
    `member_count` tinyint(1) unsigned NOT NULL default '0',
    `consistency` enum('default','coed','open','male','female','masters','masterscoed','mastersopen','mastersmale','mastersfemale') NOT NULL default 'default',
    `is_elite` enum('default','no','yes') NOT NULL default 'no',
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`id`),
    KEY `event_id` (`event_id`,`name`),
    CONSTRAINT `DIVISION_event_id_fkc` FOREIGN KEY (`event_id`) REFERENCES `EVENT` (`id`) ON UPDATE CASCADE,
    CONSTRAINT `DIVISION_id_fkc` FOREIGN KEY (`id`) REFERENCES `DATA_RESOURCE` (`id`) ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `DIVISION`
  --
  
  LOCK TABLES `DIVISION` WRITE;
  /*!40000 ALTER TABLE `DIVISION` DISABLE KEYS */;
  INSERT INTO `DIVISION` VALUES (97,95,'All',4,'coed','yes','no'),(177,174,'3-Person Coed (Elite)',3,'coed','yes','no'),(179,174,'3-Person Open',3,'open','no','no'),(180,174,'2-Person Coed',2,'coed','no','no'),(181,174,'2-Person Open',2,'open','no','no');
  /*!40000 ALTER TABLE `DIVISION` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `EVENT`
  --
  
  DROP TABLE IF EXISTS `EVENT`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `EVENT` (
    `id` int(10) unsigned NOT NULL,
    `name` varchar(64) NOT NULL default 'default',
    `start_time` datetime NOT NULL default '1970-01-01 00:00:00',
    `end_time` datetime NOT NULL default '1970-01-01 00:00:00',
    `city` varchar(32) NOT NULL default 'default',
    `region` varchar(32) NOT NULL default 'default',
    `country` varchar(32) NOT NULL default 'default',
    `zip` mediumint(5) unsigned NOT NULL default '0',
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`id`),
    KEY `name` (`name`,`start_time`),
    CONSTRAINT `EVENT_id_fkc` FOREIGN KEY (`id`) REFERENCES `DATA_RESOURCE` (`id`) ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `EVENT`
  --
  
  LOCK TABLES `EVENT` WRITE;
  /*!40000 ALTER TABLE `EVENT` DISABLE KEYS */;
  INSERT INTO `EVENT` VALUES (95,'Bull Mountain Mock Race','2009-12-03 00:00:00','2009-12-03 00:00:00','Dawsonville, GA','GA','US',30354,'no'),(174,'Atomic Adventure Race','2010-05-15 00:00:00','2010-05-17 00:00:00','Dawsonville','GA','US',30354,'no');
  /*!40000 ALTER TABLE `EVENT` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `IDENTITY`
  --
  
  DROP TABLE IF EXISTS `IDENTITY`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `IDENTITY` (
    `id` int(10) unsigned NOT NULL,
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`id`),
    CONSTRAINT `IDENTITY_id_fkc` FOREIGN KEY (`id`) REFERENCES `DATA_RESOURCE` (`id`) ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `IDENTITY`
  --
  
  LOCK TABLES `IDENTITY` WRITE;
  /*!40000 ALTER TABLE `IDENTITY` DISABLE KEYS */;
  INSERT INTO `IDENTITY` VALUES (57,'no'),(60,'no');
  /*!40000 ALTER TABLE `IDENTITY` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `PERSON`
  --
  
  DROP TABLE IF EXISTS `PERSON`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `PERSON` (
    `id` int(10) unsigned NOT NULL,
    `identity_id` int(10) unsigned NOT NULL,
    `email` varchar(64) NOT NULL default 'default',
    `first_name` varchar(32) NOT NULL default 'default',
    `last_name` varchar(32) NOT NULL default 'default',
    `city` varchar(32) NOT NULL default 'default',
    `region` varchar(32) NOT NULL default 'default',
    `country` varchar(32) NOT NULL default 'default',
    `zip` mediumint(5) unsigned NOT NULL default '0',
    `gender` enum('default','male','female') default 'default',
    `birthday` datetime default '1970-01-01 00:00:00',
    `home_phone` varchar(24) default 'default',
    `cell_phone` varchar(24) default 'default',
    `work_phone` varchar(24) default 'default',
    `default_emergency_contact_first_name` varchar(32) default 'default',
    `default_emergency_contact_last_name` varchar(32) default 'default',
    `default_emergency_contact_relation` enum('default','spouse','sibling','parent','child','other') default 'default',
    `default_emergency_phone` varchar(24) default 'default',
    `default_shirt_size` enum('default','x-small','small','medium','large','x-large','xx-large','xxx-large') default 'default',
    `default_shoe_size` varchar(7) default 'default',
    `occupation` varchar(64) default 'default',
    `self_description` text,
    `hobbies_interests` text,
    `favorite_quote` text,
    `favorite_things` text,
    `website` text,
    `is_disabled` enum('default','no','yes') NOT NULL default 'no',
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`id`),
    KEY `email_i` (`email`),
    KEY `zip_i` (`zip`),
    KEY `enabled_i` (`is_disabled`,`is_deleted`),
    KEY `PERSON_identity_id_fkc` (`identity_id`),
    CONSTRAINT `PERSON_identity_id_fkc` FOREIGN KEY (`identity_id`) REFERENCES `IDENTITY` (`id`) ON UPDATE CASCADE,
    CONSTRAINT `PERSON_id_fkc` FOREIGN KEY (`id`) REFERENCES `DATA_RESOURCE` (`id`) ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `PERSON`
  --
  
  LOCK TABLES `PERSON` WRITE;
  /*!40000 ALTER TABLE `PERSON` DISABLE KEYS */;
  INSERT INTO `PERSON` VALUES (70,57,'josh@teamrocgear.com','Josh','Forester','Cumming','GA','US',30041,'male','1982-03-12 00:00:00','678-513-2279','770-403-7846','678-319-7041','Laraleigh','Forester','spouse','770-403-8166','medium','11M','default',NULL,NULL,NULL,NULL,'http://www.teamrocgear.com','no','no'),(71,60,'jack@4lph41337.com','Jack','Forester','Dawsonville','GA','US',30534,'male','1973-05-01 00:00:00','678-455-9048','678-234-8069','678-624-6010','','','spouse','','default','default','default',NULL,NULL,NULL,NULL,'','no','no');
  /*!40000 ALTER TABLE `PERSON` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `RANK`
  --
  
  DROP TABLE IF EXISTS `RANK`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `RANK` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `team_id` int(10) unsigned NOT NULL,
    `time` datetime NOT NULL default '1970-01-01 00:00:00',
    `division_place` smallint(5) unsigned NOT NULL default '0',
    `course_place` smallint(5) unsigned NOT NULL default '0',
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`id`),
    KEY `team_id` (`team_id`,`time`),
    CONSTRAINT `RANK_team_id_fkc` FOREIGN KEY (`team_id`) REFERENCES `TEAM` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `RANK`
  --
  
  LOCK TABLES `RANK` WRITE;
  /*!40000 ALTER TABLE `RANK` DISABLE KEYS */;
  /*!40000 ALTER TABLE `RANK` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `TEAM`
  --
  
  DROP TABLE IF EXISTS `TEAM`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `TEAM` (
    `id` int(10) unsigned NOT NULL,
    `name` varchar(64) NOT NULL default 'default',
    `course_id` int(10) unsigned NOT NULL,
    `division_id` int(10) unsigned NOT NULL,
    `number` smallint(5) unsigned NOT NULL default '0',
    `registration_time` datetime NOT NULL default '1970-01-01 00:00:00',
    `division_place` smallint(5) unsigned NOT NULL default '0',
    `course_place` smallint(5) unsigned NOT NULL default '0',
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`id`),
    KEY `TEAM_course_id_fkc` (`course_id`),
    KEY `TEAM_division_id_fkc` (`division_id`),
    CONSTRAINT `TEAM_course_id_fkc` FOREIGN KEY (`course_id`) REFERENCES `COURSE` (`id`) ON UPDATE CASCADE,
    CONSTRAINT `TEAM_division_id_fkc` FOREIGN KEY (`division_id`) REFERENCES `DIVISION` (`id`) ON UPDATE CASCADE,
    CONSTRAINT `TEAM_id_fkc` FOREIGN KEY (`id`) REFERENCES `DATA_RESOURCE` (`id`) ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `TEAM`
  --
  
  LOCK TABLES `TEAM` WRITE;
  /*!40000 ALTER TABLE `TEAM` DISABLE KEYS */;
  INSERT INTO `TEAM` VALUES (119,'John Franco Team',96,97,1,'1970-01-01 00:00:00',0,0,'no'),(120,'Bryan Goble Solo',96,97,2,'1970-01-01 00:00:00',0,0,'no'),(121,'Basic Inner Rash',96,97,3,'1970-01-01 00:00:00',0,0,'no'),(122,'Beth Fordyce Team 1',96,97,4,'1970-01-01 00:00:00',0,0,'no'),(123,'Beth Fordyce Team 2',96,97,5,'1970-01-01 00:00:00',0,0,'no'),(124,'Claire Pate Team 1',96,97,6,'1970-01-01 00:00:00',0,0,'no'),(125,'Claire Pate Team 2',96,97,7,'1970-01-01 00:00:00',0,0,'no'),(126,'Team GLR Exstaenergy',96,97,8,'1970-01-01 00:00:00',0,0,'no'),(127,'Zach Dopple Team',96,97,9,'1970-01-01 00:00:00',0,0,'no'),(128,'Tony Berwald Team',96,97,10,'1970-01-01 00:00:00',0,0,'no'),(129,'Justin Kennedy Team',96,97,11,'1970-01-01 00:00:00',0,0,'no'),(130,'John Dove Solo',96,97,12,'1970-01-01 00:00:00',0,0,'no'),(131,'Team Toccoa',96,97,13,'1970-01-01 00:00:00',0,0,'no'),(132,'Dave Muse Solo',96,97,14,'1970-01-01 00:00:00',0,0,'no'),(133,'Karen Foley Team 1',96,97,15,'1970-01-01 00:00:00',0,0,'no'),(134,'Karen Foley Team 2',96,97,16,'1970-01-01 00:00:00',0,0,'no'),(135,'No Man\'s Land',96,97,17,'1970-01-01 00:00:00',0,0,'no'),(136,'Jack Forester Team 1',96,97,18,'1970-01-01 00:00:00',0,0,'no'),(137,'Jack Forester Team 2',96,97,19,'1970-01-01 00:00:00',0,0,'no'),(138,'Charles Oswald Solo',96,97,20,'1970-01-01 00:00:00',0,0,'no'),(139,'Paradofobia',96,97,21,'1970-01-01 00:00:00',0,0,'no'),(140,'Brian Boughner Team',96,97,22,'1970-01-01 00:00:00',0,0,'no'),(141,'Robert Bower Team',96,97,23,'1970-01-01 00:00:00',0,0,'no'),(142,'Dwight Shuler Solo',96,97,24,'1970-01-01 00:00:00',0,0,'no'),(143,'Ken Milam Team',96,97,25,'1970-01-01 00:00:00',0,0,'no'),(144,'David Bennett Team',96,97,26,'1970-01-01 00:00:00',0,0,'no'),(145,'Mike O\'Grady Solo',96,97,27,'1970-01-01 00:00:00',0,0,'no'),(146,'Ken Townsend Team',96,97,28,'1970-01-01 00:00:00',0,0,'no'),(147,'Chris Wade Team',96,97,29,'1970-01-01 00:00:00',0,0,'no'),(148,'Michael Carroll Team',96,97,30,'1970-01-01 00:00:00',0,0,'no'),(149,'Jay Scott Solo',96,97,31,'1970-01-01 00:00:00',0,0,'no'),(150,'Dale Johnson Solo',96,97,32,'1970-01-01 00:00:00',0,0,'no'),(151,'Kent Townley Team',96,97,33,'1970-01-01 00:00:00',0,0,'no'),(152,'Mind Over Matter',96,97,34,'1970-01-01 00:00:00',0,0,'no'),(153,'Andy McCann Team',96,97,35,'1970-01-01 00:00:00',0,0,'no'),(154,'Laura Battista Team',96,97,36,'1970-01-01 00:00:00',0,0,'no'),(155,'Under Par',96,97,37,'1970-01-01 00:00:00',0,0,'no'),(156,'Deez Gunz',96,97,38,'1970-01-01 00:00:00',0,0,'no'),(157,'Clint Sanders Team',96,97,39,'1970-01-01 00:00:00',0,0,'no'),(158,'Tim Page Team',96,97,40,'1970-01-01 00:00:00',0,0,'no'),(159,'Team SF',96,97,41,'1970-01-01 00:00:00',0,0,'no'),(160,'Tina w/ Russ Marshall',96,97,42,'1970-01-01 00:00:00',0,0,'no'),(161,'Wren Chase Team',96,97,43,'1970-01-01 00:00:00',0,0,'no'),(168,'Kristen Thompson',96,97,44,'1970-01-01 00:00:00',0,0,'no'),(170,'Chris Dusack',96,97,45,'1970-01-01 00:00:00',0,0,'no'),(189,'2 Old Guys',175,181,1,'1970-01-01 00:00:00',0,0,'no'),(190,'Adventure Racing South A',175,180,2,'1970-01-01 00:00:00',0,0,'no'),(191,'Adventure Racing South B',175,181,3,'1970-01-01 00:00:00',0,0,'no'),(192,'Angelman Syndrome Awareness',175,179,4,'1970-01-01 00:00:00',0,0,'no'),(193,'Appalachian AR',175,177,5,'1970-01-01 00:00:00',0,0,'no'),(194,'Applied Vitals',175,181,6,'1970-01-01 00:00:00',0,0,'no'),(195,'AR Militia',175,179,7,'1970-01-01 00:00:00',0,0,'no'),(196,'Arms Raised in a V',175,179,8,'1970-01-01 00:00:00',0,0,'no'),(197,'ATP/CP0',175,177,9,'1970-01-01 00:00:00',0,0,'no'),(198,'Bikes Plus',175,179,10,'1970-01-01 00:00:00',0,0,'no'),(199,'Blinded by the Night',175,181,11,'1970-01-01 00:00:00',0,0,'no'),(200,'Blue Falcons',175,179,12,'1970-01-01 00:00:00',0,0,'no'),(201,'Bottoms Up',175,181,13,'1970-01-01 00:00:00',0,0,'no'),(202,'Checkpoint Zero',175,177,15,'1970-01-01 00:00:00',0,0,'no'),(203,'Crossfit Garage',175,177,16,'1970-01-01 00:00:00',0,0,'no'),(204,'Currahee',175,181,18,'1970-01-01 00:00:00',0,0,'no'),(205,'EntHost',175,179,19,'1970-01-01 00:00:00',0,0,'no'),(206,'Felix Navidad',175,177,20,'1970-01-01 00:00:00',0,0,'no'),(207,'Fire and EMS',175,181,21,'1970-01-01 00:00:00',0,0,'no'),(208,'Florida Xtreme 1',175,177,22,'1970-01-01 00:00:00',0,0,'no'),(209,'Florida Xtreme 2',175,181,23,'1970-01-01 00:00:00',0,0,'no'),(210,'GoBushwhack.com',175,177,24,'1970-01-01 00:00:00',0,0,'no'),(211,'God Hates A Coward',175,181,25,'1970-01-01 00:00:00',0,0,'no'),(212,'Green Paw Adventure Sports',175,177,26,'1970-01-01 00:00:00',0,0,'no'),(213,'ImONPoint.org-Odyssey Adventure Racing',175,177,27,'1970-01-01 00:00:00',0,0,'no'),(214,'Intel Outside',175,181,28,'1970-01-01 00:00:00',0,0,'no'),(215,'Kickapoo',175,177,29,'1970-01-01 00:00:00',0,0,'no'),(216,'Layer 3',175,177,30,'1970-01-01 00:00:00',0,0,'no'),(217,'M2',175,181,32,'1970-01-01 00:00:00',0,0,'no'),(218,'Mims the Word',175,177,33,'1970-01-01 00:00:00',0,0,'no'),(219,'Moving Strong',175,177,34,'1970-01-01 00:00:00',0,0,'no'),(220,'No Man\'s Land',175,181,36,'1970-01-01 00:00:00',0,0,'no'),(221,'Pangea Adventure Racing',175,177,37,'1970-01-01 00:00:00',0,0,'no'),(222,'Rogue',175,180,39,'1970-01-01 00:00:00',0,0,'no'),(223,'SCARredforlife',175,181,40,'1970-01-01 00:00:00',0,0,'no'),(224,'spiritualendurance',175,180,42,'1970-01-01 00:00:00',0,0,'no'),(225,'Sport Factory',175,177,43,'1970-01-01 00:00:00',0,0,'no'),(226,'Tabula Rasa',175,181,44,'1970-01-01 00:00:00',0,0,'no'),(227,'Team Flight',175,177,45,'1970-01-01 00:00:00',0,0,'no'),(228,'Team GLR',175,177,46,'1970-01-01 00:00:00',0,0,'no'),(229,'team jackass',175,177,47,'1970-01-01 00:00:00',0,0,'no'),(230,'Team Juggernaut',175,181,48,'1970-01-01 00:00:00',0,0,'no'),(231,'Team SSFD',175,179,50,'1970-01-01 00:00:00',0,0,'no'),(232,'The Arizona Brothers',175,181,52,'1970-01-01 00:00:00',0,0,'no'),(233,'The Nightman Cometh',175,179,53,'1970-01-01 00:00:00',0,0,'no'),(234,'This is Gonna Hurt',175,179,54,'1970-01-01 00:00:00',0,0,'no'),(235,'Toledo Bender',175,179,55,'1970-01-01 00:00:00',0,0,'no'),(236,'Trakkers',175,177,56,'1970-01-01 00:00:00',0,0,'no'),(237,'Tuttle Shuttle',175,179,57,'1970-01-01 00:00:00',0,0,'no'),(238,'Vignette',175,177,58,'1970-01-01 00:00:00',0,0,'no'),(239,'WEDALI',175,177,59,'1970-01-01 00:00:00',0,0,'no'),(240,'Zombies',175,181,60,'1970-01-01 00:00:00',0,0,'no');
  /*!40000 ALTER TABLE `TEAM` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `Team_Instance_Rel`
  --
  
  DROP TABLE IF EXISTS `Team_Instance_Rel`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `Team_Instance_Rel` (
    `team_id` int(10) unsigned NOT NULL,
    `competitor_id` int(10) unsigned NOT NULL,
    `is_captain` enum('default','no','yes') NOT NULL default 'no',
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`team_id`,`competitor_id`),
    KEY `Team_Instance_Rel_competitor_id_fkc` (`competitor_id`),
    CONSTRAINT `Team_Instance_Rel_competitor_id_fkc` FOREIGN KEY (`competitor_id`) REFERENCES `COMPETITOR` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `Team_Instance_Rel_team_id_fkc` FOREIGN KEY (`team_id`) REFERENCES `TEAM` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `Team_Instance_Rel`
  --
  
  LOCK TABLES `Team_Instance_Rel` WRITE;
  /*!40000 ALTER TABLE `Team_Instance_Rel` DISABLE KEYS */;
  /*!40000 ALTER TABLE `Team_Instance_Rel` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `UPD`
  --
  
  DROP TABLE IF EXISTS `UPD`;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  CREATE TABLE `UPD` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `team_id` int(10) unsigned NOT NULL,
    `time` datetime NOT NULL default '1970-01-01 00:00:00',
    `type` enum('default','CP Visit','Rank') NOT NULL default 'default',
    `message` text,
    `is_deleted` enum('default','no','yes') NOT NULL default 'no',
    PRIMARY KEY  (`id`),
    KEY `UPD_team_id_fkc` (`team_id`),
    CONSTRAINT `UPD_team_id_fkc` FOREIGN KEY (`team_id`) REFERENCES `TEAM` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Dumping data for table `UPD`
  --
  
  LOCK TABLES `UPD` WRITE;
  /*!40000 ALTER TABLE `UPD` DISABLE KEYS */;
  /*!40000 ALTER TABLE `UPD` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2010-05-14  6:22:14
  