--
-- Host: localhost    Database: eforms
-- ------------------------------------------------------


--
-- Table structure for table `commcare_budgets`
--

CREATE TABLE `commcare_budgets` (
  `recc_id` int(11) NOT NULL,
  `year` smallint(6) DEFAULT NULL,
  `month` tinyint(4) DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  UNIQUE KEY `idx_budget_types` (`recc_id`,`year`,`month`),
  KEY `idx_when` (`year`,`month`),
  CONSTRAINT `commcare_budgets_ibfk_1` FOREIGN KEY (`recc_id`) REFERENCES `reccs` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commcare_budgets`
--

INSERT INTO `commcare_budgets` VALUES (1,2011,2,3900.00),(1,2011,3,3900.00),(1,2011,4,3900.00),(1,2011,5,3900.00),(1,2011,6,3900.00),(1,2011,7,3900.00),(1,2011,8,3900.00),(1,2011,9,3900.00),(1,2011,10,3900.00),(1,2011,11,3900.00),(2,2011,2,4200.00),(2,2011,3,4200.00),(2,2011,4,4200.00),(2,2011,5,4200.00),(2,2011,6,4200.00),(2,2011,7,4200.00),(2,2011,8,4200.00),(2,2011,9,4200.00),(2,2011,10,4200.00),(2,2011,11,4200.00),(3,2011,2,6000.00),(3,2011,3,6000.00),(3,2011,4,6000.00),(3,2011,5,6000.00),(3,2011,6,6000.00),(3,2011,7,6000.00),(3,2011,8,6000.00),(3,2011,9,6000.00),(3,2011,10,6000.00),(3,2011,11,6000.00),(4,2011,2,7200.00),(4,2011,3,7200.00),(4,2011,4,7200.00),(4,2011,5,7200.00),(4,2011,6,7200.00),(4,2011,7,7200.00),(4,2011,8,7200.00),(4,2011,9,7200.00),(4,2011,10,7200.00),(4,2011,11,7200.00),(5,2011,2,3300.00),(5,2011,3,3300.00),(5,2011,4,3300.00),(5,2011,5,3300.00),(5,2011,6,3300.00),(5,2011,7,3300.00),(5,2011,8,3300.00),(5,2011,9,3300.00),(5,2011,10,3300.00),(5,2011,11,3300.00),(6,2011,2,8900.00),(6,2011,3,8900.00),(6,2011,4,8900.00),(6,2011,5,8900.00),(6,2011,6,8900.00),(6,2011,7,8900.00),(6,2011,8,8900.00),(6,2011,9,8900.00),(6,2011,10,8900.00),(6,2011,11,8900.00),(7,2011,2,1500.00),(7,2011,3,1500.00),(7,2011,4,1500.00),(7,2011,5,1500.00),(7,2011,6,1500.00),(7,2011,7,1500.00),(7,2011,8,1500.00),(7,2011,9,1500.00),(7,2011,10,1500.00),(7,2011,11,1500.00);

--
-- Table structure for table `commcare_grant_uses`
--

CREATE TABLE `commcare_grant_uses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `grant_use` varchar(255) DEFAULT NULL,
  `ord` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ord` (`ord`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commcare_grant_uses`
--

INSERT INTO `commcare_grant_uses` VALUES (1,'Funding for awareness campaigns',1),(2,'Funding for charity events',2),(3,'Funding research',3),(4,'Purchasing general equipment',4),(5,'Purchasing safety equipment',5),(6,'Purchasing sporting equipment',6),(7,'Purchasing toys',7),(8,'Supported travel',8),(9,'Other',9);

--
-- Table structure for table `commcare_justifications`
--

CREATE TABLE `commcare_justifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `justification` varchar(512) NOT NULL,
  `ord` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ord` (`ord`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commcare_justifications`
--

INSERT INTO `commcare_justifications` VALUES (1,'Organisation operates outside of Australia',1),(2,'Individual',2),(3,'Church or religious group',3),(4,'Political party/association',4),(5,'Trade or business association',5),(6,'Social club',6),(7,'Discriminates race/religion/gender/etc',7),(8,'Sporting organisation',8),(9,'3rd application',9),(10,'4th application',10),(11,'Electrical job application approved',11),(12,'School (not Parents and Friends Group)',12),(13,'Does not satisfy any positive eligibility criteria',13);

--
-- Table structure for table `commcare_org_purposes`
--

CREATE TABLE `commcare_org_purposes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purpose` varchar(255) DEFAULT NULL,
  `ord` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ord` (`ord`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commcare_org_purposes`
--

INSERT INTO `commcare_org_purposes` VALUES (1,'Animal Welfare',1),(2,'Arts & Culture',2),(3,'Education',3),(4,'Emergency Services',4),(5,'Environment/Construction',5),(6,'Health',6),(7,'Movember',7),(8,'Social Welfare',8),(9,'Sport and Recreation',9),(10,'Youth Programs/Services',10),(11,'Other',11);

--
-- Table structure for table `commcare_submissions`
--

CREATE TABLE `commcare_submissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `serial_id` int(11) NOT NULL,
  `load_id` int(11) DEFAULT NULL,
  `service_number` int(11) NOT NULL,
  `which_application` tinyint(4) NOT NULL,
  `is_inkind` bit(1) DEFAULT b'0',
  `is_movember` bit(1) DEFAULT b'0',
  `movember_id` int(11) DEFAULT NULL,
  `movember_team_name` varchar(255) DEFAULT NULL,
  `applicant_name` varchar(64) NOT NULL,
  `applicant_division` int(11) NOT NULL,
  `applicant_work_addr` varchar(255) NOT NULL,
  `applicant_postcode` int(11) NOT NULL,
  `applicant_suburb` varchar(64) NOT NULL,
  `applicant_phone` varchar(16) NOT NULL,
  `applicant_email` varchar(255) NOT NULL,
  `org_name` varchar(128) NOT NULL,
  `position_in_org` varchar(64) NOT NULL,
  `org_contact_name` varchar(64) NOT NULL,
  `org_contact_phone` varchar(16) NOT NULL,
  `org_contact_email` varchar(255) NOT NULL,
  `org_addr_line1` varchar(128) NOT NULL,
  `org_addr_line2` varchar(128) NOT NULL,
  `org_suburb` varchar(64) NOT NULL,
  `org_postcode` int(11) NOT NULL,
  `org_state` int(11) NOT NULL,
  `org_purpose` int(11) NOT NULL,
  `org_purpose_other` varchar(64) DEFAULT NULL,
  `grant_use` int(11) DEFAULT NULL,
  `grant_use_other` varchar(64) DEFAULT NULL,
  `volunteer_role` int(11) DEFAULT NULL,
  `volunteer_role_other` varchar(64) DEFAULT NULL,
  `contactable` tinyint(4) NOT NULL,
  `recc_id` int(11) NOT NULL,
  `recc_io_number` int(11) NOT NULL,
  `submission_date` datetime NOT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `amount` decimal(8,2) DEFAULT NULL,
  `justification` int(11) DEFAULT NULL,
  `decision_date` datetime DEFAULT NULL,
  `decision_user_id` int(11) DEFAULT NULL,
  `gl_account` int(11) DEFAULT NULL,
  `is_paid` bit(1) DEFAULT NULL,
  `sms_updates` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`id`),
  KEY `fk_division` (`applicant_division`),
  KEY `fk_org_purpose` (`org_purpose`),
  KEY `fk_grant_use` (`grant_use`),
  KEY `fk_volunteer_role` (`volunteer_role`),
  KEY `fk_justification` (`justification`),
  KEY `fk_decision_user` (`decision_user_id`),
  KEY `idx_recc_id` (`recc_id`),
  KEY `idx_service_number` (`service_number`),
  KEY `idx_isinkind` (`is_inkind`),
  KEY `idx_is_paid` (`is_paid`),
  KEY `idx_submission_date` (`submission_date`),
  CONSTRAINT `commcare_submissions_ibfk_1` FOREIGN KEY (`applicant_division`) REFERENCES `divisions` (`id`),
  CONSTRAINT `commcare_submissions_ibfk_2` FOREIGN KEY (`org_purpose`) REFERENCES `commcare_org_purposes` (`id`),
  CONSTRAINT `commcare_submissions_ibfk_3` FOREIGN KEY (`grant_use`) REFERENCES `commcare_grant_uses` (`id`),
  CONSTRAINT `commcare_submissions_ibfk_4` FOREIGN KEY (`volunteer_role`) REFERENCES `commcare_volunteer_roles` (`id`),
  CONSTRAINT `commcare_submissions_ibfk_5` FOREIGN KEY (`justification`) REFERENCES `commcare_justifications` (`id`),
  CONSTRAINT `commcare_submissions_ibfk_6` FOREIGN KEY (`decision_user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `commcare_submissions_ibfk_7` FOREIGN KEY (`recc_id`) REFERENCES `reccs` (`id`),
  CONSTRAINT `commcare_submissions_ibfk_8` FOREIGN KEY (`recc_id`) REFERENCES `reccs` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commcare_submissions`
--

INSERT INTO `commcare_submissions` VALUES (1,1,NULL,41491,1,'\0','\0',NULL,'','Gino Guerrera ',1,'Grd Flr, Blg 3, Oatley',2035,'','414192101','','KU Randwick Coogee Preschool','','','','','PO Box 267','','Randwick',2031,2,3,NULL,NULL,NULL,NULL,NULL,0,1,219020074,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(2,2,NULL,48056,1,'\0','\0',NULL,'','Nick Ellem',2,'Level 1, 33 Judd St, Oatley',2017,'','428963682','','TS Sydney - Australian Navy Cadets','','','','','PO Box 343','','Drummoyne',2047,2,10,NULL,NULL,NULL,NULL,NULL,1,1,219020074,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(3,3,NULL,47062,1,'\0','\0',NULL,'','Zoe Trueman',7,'Level 22, 570 George St, Sydney',2034,'','92694099','','Cure Cancer Australia Foundation/Can Too','','','','','PO Box R185','','Royal Exchange',1225,2,6,NULL,NULL,NULL,NULL,NULL,1,1,219020074,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(4,4,NULL,44647,1,'\0','\0',NULL,'','Gregory Bartolo',2,'Building 5, Level 1, 25-27 Pomeroy St, Homebush',2042,'','93946877','','Cure Cancer Australia Foundation/Can Too','','','','','Level 6, 15-17','Young St','Sydney',2000,3,6,NULL,NULL,NULL,NULL,NULL,1,1,219020074,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(5,5,NULL,51899,1,'\0','\0',NULL,'','Andrew Back',2,'Level 13, RCH',2066,'','92773576','','Zoo2Zoo','','','','','7','Shire Ave','Dubbo',2830,2,6,NULL,NULL,NULL,NULL,NULL,1,2,219020075,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(6,6,NULL,54077,1,'\0','\0',NULL,'','Anthony Parks',1,'Meadowbank Training Centre',2065,'','402742444','','The Salvation Army Oasis Youth Support Network','','','','','365','Crown St','Surry Hills',2010,2,11,NULL,NULL,NULL,NULL,NULL,0,2,219020075,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(7,7,NULL,50238,1,'','\0',NULL,'','Nicholas Brice',1,'Bldg 3, Homebush Depot',2121,'','93946974','','South Narrabeen Surf Lifesaving Club','','','','','1200','Pittwater Rd','Narrabeen',2101,2,4,NULL,NULL,NULL,NULL,NULL,1,2,159020435,'2010-07-01 00:00:00',1,0.00,NULL,'2010-07-01 00:00:00',NULL,NULL,'','\0'),(8,8,NULL,46982,1,'\0','\0',NULL,'','Ross Marks',1,'Bldg 1, Hornsby Depot',2747,'','402175580','','Prostate Cancer Foundation of Australia','','','','','PO Box 1332','','Lane Cove',1595,2,6,NULL,NULL,NULL,NULL,NULL,1,2,219020075,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(9,9,NULL,42727,2,'\0','\0',NULL,'','Pat Keefe',2,'1st Flr, Bldg 3, Oatley',2518,'','95855886','','Bellambi SLSC Inc.','','','','','','Morgan Place','Bellambi',2518,2,4,NULL,NULL,NULL,NULL,NULL,1,3,219020076,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(10,10,NULL,42727,1,'\0','\0',NULL,'','Pat Keefe',2,'1st Flr, Bldg 3, Oatley',2518,'','95855886','','The Illawarra Woodworkers Group Inc.','','','','','Fairy Meadow Primary School','','Fairy Meadow',2519,3,11,NULL,NULL,NULL,NULL,NULL,1,3,219020076,'2010-07-01 00:00:00',0,0.00,1,'2010-07-01 00:00:00',NULL,738050,'\0','\0'),(11,11,NULL,46630,1,'\0','\0',NULL,'','Claire Hirst',5,'Lv 8, HOB',2224,'','92694738','','Gymea North Public School P&C','','','','','','Ruby Rd','Gymea',2227,2,3,NULL,NULL,NULL,NULL,NULL,1,3,219020076,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(12,12,NULL,42103,1,'\0','\0',NULL,'','Spencer Steinwede',4,'Gnd Flr, Bldg 6, Zetland',2207,'','418616860','','Rockdale State Emergency Service','','','','','109','Highgate St','Bexley',2207,2,4,NULL,NULL,NULL,NULL,NULL,1,3,219020076,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(13,13,NULL,42046,1,'','\0',NULL,'','Peter Stephanou',3,'Lv 6, HOB',2225,'','92694632','','The Miranda Bombers AFL Club','','','','','Waratah Oval No.4','Rawson Ave','Sutherland',2232,2,9,NULL,NULL,NULL,NULL,NULL,0,3,159020435,'2010-07-01 00:00:00',1,0.00,NULL,'2010-07-01 00:00:00',NULL,NULL,'','\0'),(14,14,NULL,51552,1,'','\0',NULL,'','Scott Edwards',6,'Lv 19, RCH',2227,'','92693403','','Gymea Bay Care & Leisure','','','','','PO Box 537','','Gymea',2227,2,9,NULL,NULL,NULL,NULL,NULL,0,3,159020435,'2010-07-01 00:00:00',1,0.00,NULL,'2010-07-01 00:00:00',NULL,NULL,'','\0'),(15,15,NULL,34491,1,'\0','\0',NULL,'','Warrick Lang',1,'Noraville Depot',2259,'','417234114','','Norah Head Search & Rescue','','','','','639','Maitland St','Norah Head',2263,2,4,NULL,NULL,NULL,NULL,NULL,1,5,219020078,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(16,16,NULL,52622,1,'\0','\0',NULL,'','Daniel Farrugia',1,'Gosford Depot Attn: Gary Creary',2251,'','401799205','','Avoca Football Club','','','','','Po Box 6216','','Kincumber',2251,2,9,NULL,NULL,NULL,NULL,NULL,0,5,219020078,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(17,17,NULL,50934,1,'\0','\0',NULL,'','Steven Joseph',1,'Blg 4, West Gosford Depot',2260,'','407897695','','Wamberal NSW RFS Brigade','','','','','Tumbi Road','Tumbi Road','Wamberal',2260,2,4,NULL,NULL,NULL,NULL,NULL,0,5,219020078,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(18,18,NULL,38221,1,'\0','\0',NULL,'','Martin  Hutchinson',1,'West Gosford Substation',2256,'','418967086','','Woy Woy Football Club','','','','','PO Box 142 ','','Woy Woy',2256,2,9,NULL,NULL,NULL,NULL,NULL,0,5,219020078,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(19,19,NULL,44074,1,'\0','\0',NULL,'','Ben Stadlemann',1,'Unit 2, Tuggerah',2261,'','43998179','','Dry July Foundation','','','','','PO Box 751','','Randwick',2031,2,6,NULL,NULL,NULL,NULL,NULL,1,5,219020078,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(20,20,NULL,35806,1,'\0','\0',NULL,'','Robert  James',1,'Bldg 5, West Gosford Depot',2250,'','43258761','','Matcham Holgate NSW RFS Brigade','','','','','15','Wattle Tree Rd','Holgate',2250,2,4,NULL,NULL,NULL,NULL,NULL,0,5,219020078,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(21,21,NULL,43710,1,'\0','\0',NULL,'','Jeffery  Smith',1,'Suite 8, Tuggerah Business Park',2251,'','43998111','','Southern & Ettalong United Football Club','','','','','Po Box 80','','Ettalong Beach',2257,2,9,NULL,NULL,NULL,NULL,NULL,0,5,219020078,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(22,22,NULL,46856,1,'\0','\0',NULL,'','Gary  Mcdermott',1,'Noraville Depot',2263,'','43258604','','Warnervale Netball Club','','','','','9','Lupin Close','Woongarrah',2259,2,9,NULL,NULL,NULL,NULL,NULL,1,5,219020078,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(23,23,NULL,41248,1,'\0','\0',NULL,'','Mark  Gilligan',1,'Noraville Depot',2250,'','43258772','','Ourimbah - Wyoming Junior Rugby League Club','','','','','PO Box 166','','Ourimbah',2258,2,9,NULL,NULL,NULL,NULL,NULL,1,5,219020078,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(24,24,NULL,54071,1,'','\0',NULL,'','Alan  Roberts',2,'Suite 7 & 8 Tuggerah',2250,'','401431617','','Brisbane Waters Rural Fire Service','','','','','','Pateman Rd','Erina',2250,2,4,NULL,NULL,NULL,NULL,NULL,1,5,159020435,'2010-07-01 00:00:00',1,0.00,NULL,'2010-07-01 00:00:00',NULL,NULL,'','\0'),(25,25,NULL,47573,1,'','\0',NULL,'','David Hedger',1,'Bldg 2, Hornsby',2250,'','439905903','','Holgate Primary School','','','','','189','Wattle Tree Rd','Holgate',2250,2,3,NULL,NULL,NULL,NULL,NULL,1,5,159020435,'2010-07-01 00:00:00',1,0.00,NULL,'2010-07-01 00:00:00',NULL,NULL,'','\0'),(26,26,NULL,44557,1,'\0','\0',NULL,'','Michael Griffiths',2,'Block B, Wallsend Admin Building',2298,'','49519679','','Scouts Australia - 1st New Lambton Group','','','','','','Cnr Queens Rd & Fleet St','New Lambton',2305,2,10,NULL,NULL,NULL,NULL,NULL,0,6,219020079,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(27,27,NULL,44989,1,'\0','\0',NULL,'','Michael Fitzpatrick',4,'Contact Centre, Block A, Wallsend Admin',2285,'','49519553','','Debra Australia Inc','','','','','PO Box 226','','Pittsworth',4356,4,6,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(28,28,NULL,46417,1,'\0','\0',NULL,'','Craig Elliott',4,'Corporate House - Elermore Vale',2290,'','49101312','','Dudley Redhead Junior Soccer Club','','','','','57','Geraldton Avenue','Redhead',2290,2,9,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(29,29,NULL,51097,1,'\0','\0',NULL,'','Renee White',4,'Block A, Wallsend Admin Building',2290,'','49519960','','Dudley Redhead Junior Soccer Club','','','','','57','Geraldton Avenue','Redhead',2290,2,9,NULL,NULL,NULL,NULL,NULL,0,6,219020079,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(30,30,NULL,50580,1,'\0','\0',NULL,'','Lisa Mapstone',4,'Contact Centre, Block A, Wallsend Admin',2290,'','49510131','','Felton Street Early Learning Centre','','','','','Felton Street','Felton Street','Gateshead',2290,2,3,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(31,31,NULL,46948,1,'\0','\0',NULL,'','Patricia Conway',4,'Contact Centre, Block A, Wallsend Admin',2290,'','49519998','','Dudley Redhead Junior Soccer Club','','','','','57','Geraldton Avenue','Redhead',2290,2,9,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(32,32,NULL,48660,1,'\0','\0',NULL,'','Rebecca  Greentree',4,'Block A East, Wallsend Admin Building',2287,'','49519926','','Greyhound Rescue','','','','','14','Athlone Cres','Kilarney Heights',2087,2,1,NULL,NULL,NULL,NULL,NULL,0,6,219020079,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(33,33,NULL,48762,1,'\0','\0',NULL,'','Jason Hepple',1,'Block A, Wallsend Admin Building',2290,'','49519431','','Dudley Redhead Junior Soccer Club','','','','','57','Geraldton Avenue','Redhead',2290,2,9,NULL,NULL,NULL,NULL,NULL,0,6,219020079,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(34,34,NULL,45682,1,'\0','\0',NULL,'','Steven Dimmock',4,'Building 3, Abbot Street Depot',2290,'','409839235','','Dudley Redhead Junior Soccer Club','','','','','57','Geraldton Avenue','Redhead',2290,2,9,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(35,35,NULL,39833,2,'\0','\0',NULL,'','Adam McLennon',4,'Block A, Wallsend Admin Building',2290,'','414192458','','Dudley Redhead Junior Soccer Club','','','','','57','Geraldton Avenue','Redhead',2290,2,9,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(36,36,NULL,46390,1,'\0','\0',NULL,'','Chelsea Lenton',4,'Contact Centre, Block A, Wallsend Admin',2287,'','49510860','','RSPCA','','','','','40822','Burlington Place','Rutherford',2320,2,1,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(37,37,NULL,48653,1,'\0','\0',NULL,'','Pamela Richards',4,'Block C, Wallsend Admin Building',2323,'','49519498','','Mayfield Senior Soccer Club','','','','','PO Box 348','','Mayfield',2304,2,9,NULL,NULL,NULL,NULL,NULL,0,6,219020079,'2010-07-01 00:00:00',0,0.00,8,'2010-07-01 00:00:00',NULL,738050,'\0','\0'),(38,38,NULL,45989,1,'\0','\0',NULL,'','Scott O\'Bryan',1,'Singleton Depot Orchard Ave Singleton',2330,'','69719748','','Singleton Pre-School','','','','','','York Street','Singleton',2330,2,3,NULL,NULL,NULL,NULL,NULL,1,7,219020080,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(39,39,NULL,45907,1,'\0','\0',NULL,'','Michael Judge',1,'Singleton Depot Orchard Ave Singleton',2330,'','65719731','','King Stree Public School P & C Assn','','','','','','King Street ','Singleton',2330,3,3,NULL,NULL,NULL,NULL,NULL,1,7,219020080,'2010-07-01 00:00:00',1,300.00,NULL,'2010-07-01 00:00:00',NULL,738050,'','\0'),(40,40,NULL,47841,1,'\0','\0',NULL,'','Renae Johnson',5,'Lvl 11, HOB',2113,'','92694465','','RSPCA NSW','','','','','62','Hume Highway','Chullora',2190,2,1,NULL,NULL,NULL,NULL,NULL,1,1,219020074,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(41,41,NULL,40188,1,'\0','\0',NULL,'','Nick Speranza',1,'130 Johnson Avenue, Zetland',2138,'','96639354','','The Lupus Association of NSW Inc','','','','','55','Wicks Road','North Ryde',2113,2,6,NULL,NULL,NULL,NULL,NULL,0,1,219020074,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(42,42,NULL,53368,1,'\0','\0',NULL,'','Tim Youle',8,'Level 23, HOB',2086,'','92692449','','KU Bambara Road Preschool','','','','','','Cnr Bambara Rd and Forest Way','Belrose',2085,2,11,NULL,NULL,NULL,NULL,NULL,1,2,219020075,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(43,43,NULL,43724,1,'\0','\0',NULL,'','Tom Emeleus',8,'Bldg 9A, Homebush Depot',2114,'','93946551','','Oxfan Australia','','','','','PO Box 1711','','Strawberry Hils',2012,2,11,NULL,NULL,NULL,NULL,NULL,1,2,219020075,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(44,44,NULL,47077,1,'\0','\0',NULL,'','Marian Attfield',1,'Level 1, 5-7 Bryson St, Chatswood',2079,'','85696376','','Lifeline, Harbour to Hawkesbury','','','','','4','Park Ave','Gordon',2072,2,11,NULL,NULL,NULL,NULL,NULL,0,2,219020075,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(45,45,NULL,40472,1,'\0','\0',NULL,'','John Boyce',1,'Gore Hill Depot',2103,'','94675521','','Cicada Australia Inc.','','','','','PO Box 5028','','South Turramurra',2074,3,6,NULL,NULL,NULL,NULL,NULL,0,2,219020075,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(46,46,NULL,53345,1,'\0','\0',NULL,'','Jessica Kleinberg',1,'Level 1, 5-7 Bryson St, Chatswood',2111,'','85696381','','Engineers Without Borders','','','','','PO Box 388','','Melbourne',3205,7,11,NULL,NULL,NULL,NULL,NULL,1,2,219020075,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(47,47,NULL,33836,1,'\0','\0',NULL,'','Gerard Chrimes',4,'Bldg 5, Chatswood',2206,'','94105132','','Undercliffe Public School','','','','','','Bayview Ave','Earlwood',2206,2,3,NULL,NULL,NULL,NULL,NULL,1,3,219020076,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(48,48,NULL,48888,1,'\0','\0',NULL,'','Jim Graham',1,'Lvl 1, Blg 5, Oatley',2227,'','409077184','','Gymea Gorillas JRLFC','','','','','PO Box 792','','Gymea',2227,2,9,NULL,NULL,NULL,NULL,NULL,1,3,219020076,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(49,49,NULL,39256,1,'\0','\0',NULL,'','Chris Philips',1,'Bldg 5, Zetland',2207,'','96639309','','The Lupus Association of NSW Inc.','','','','','55','Wicks Rd','North Ryde',2113,2,6,NULL,NULL,NULL,NULL,NULL,0,3,219020076,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(50,50,NULL,46869,1,'\0','\0',NULL,'','Martin Keyes',2,'Lvl 1, Blg 3, Oatley',2230,'','412674413','','Marton Soccer Club','','','','','PO Box 562','','Engadine',2233,2,9,NULL,NULL,NULL,NULL,NULL,0,3,219020076,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(51,51,NULL,46637,1,'','\0',NULL,'','Jared Barclay',1,'Lvl 2, Blg 1, Oatley',2232,'','414192102','','North Cronulla Surf Club','','','','','','Cnr Prince & Mitchell Rd','Cronulla',2230,2,4,NULL,NULL,NULL,NULL,NULL,0,3,159020435,'2010-08-01 00:00:00',1,0.00,NULL,'2010-08-01 00:00:00',NULL,NULL,'','\0'),(52,52,NULL,40174,1,'\0','\0',NULL,'','Chris Lynch',1,'Blg 5, Zetland',2211,'','408202145','','Illawarra RFS','','','','','','Old Illawarra Rd','Illawong',2234,2,4,NULL,NULL,NULL,NULL,NULL,0,4,219020077,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(53,53,NULL,48142,1,'\0','\0',NULL,'','Stephen Ashton',1,'Lvl 1, Blg 1, Oatley',2170,'','95855945','','MS Australia','','','','','80','Betty Cuthbert Drive','Lidcombe',2141,2,6,NULL,NULL,NULL,NULL,NULL,0,4,219020077,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(54,54,NULL,53260,1,'\0','\0',NULL,'','Mano Muhunthan',2,'Lvl 13, RCH',2145,'','82601761','','Girraween Public School','','','','','','Bando Rd','Girraween',2145,2,3,NULL,NULL,NULL,NULL,NULL,0,4,219020077,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(55,55,NULL,34133,1,'\0','\0',NULL,'','Stephen Simmons',1,'Gnd Flr, Blg 1, Oatley',2214,'','95855666','','Revesby Heights Junior Cricket Club','','','','','Neptune Park','Edinburgh Drive','Revesby Heights',2212,2,9,NULL,NULL,NULL,NULL,NULL,0,4,219020077,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(56,56,NULL,47835,1,'\0','\0',NULL,'','Tony Khalife',2,'St Davids Rd Haberfield',2045,'','407256413','','Auburn West Public School','','','','','','Chiswick Rd','Auburn',2144,2,3,NULL,NULL,NULL,NULL,NULL,0,4,219020077,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(57,57,NULL,48770,1,'\0','\0',NULL,'','Peter Flood',5,'Lvl 11, HOB',2567,'','92692056','','MS Australia','','','','','2A/10','Carrington St','Marrickville',2204,2,6,NULL,NULL,NULL,NULL,NULL,0,4,219020077,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(58,58,NULL,46762,1,'\0','\0',NULL,'','Tim Dorrian',1,'Gore Hill Depot',2138,'','419146401','','Concord West Public School','','','','','378','Concord Road','Concord West',2138,2,3,NULL,NULL,NULL,NULL,NULL,0,4,219020077,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(59,59,NULL,39935,1,'\0','\0',NULL,'','Robert Addie',1,'Lvl 1, Blg 3, Homebush',2155,'','93946562','','Baulkham Hills Australian Football Club','','','','','PO Box 6610 ','','Baulkham Hills BC',2153,2,9,NULL,NULL,NULL,NULL,NULL,0,4,219020077,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(60,60,NULL,41336,1,'\0','\0',NULL,'','Tony Vella',1,'Noraville Depot',2257,'','43258656','','MS Australia','','','','','Private Bag 4444','','Artarmon',1570,2,6,NULL,NULL,NULL,NULL,NULL,1,5,219020078,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(61,61,NULL,35087,1,'\0','\0',NULL,'','Phil Wilson',1,'Noraville Depot',2250,'','43258762','','Cancer Council','','','','','153','Dowling St','Wooloomooloo',2011,2,6,NULL,NULL,NULL,NULL,NULL,1,5,219020078,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(62,62,NULL,38469,1,'\0','\0',NULL,'','Wayne  Vaughan',1,'Noraville Depot',2261,'','43258714','','MS Australia','','','','','Private Bag 4444','','Artarmon',1570,2,6,NULL,NULL,NULL,NULL,NULL,1,5,219020078,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(63,63,NULL,49894,1,'\0','\0',NULL,'','Peter Coulton',1,'Noraville Depot',2261,'','407060148','','Cancer Council','','','','','PO Box 816','','Potts Point',1335,2,6,NULL,NULL,NULL,NULL,NULL,0,5,219020078,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(64,64,NULL,43710,2,'\0','\0',NULL,'','Jeffery Smith',1,'Tuggerah',2251,'','407105415','','Bobbi Dillon Fundraising touch Football Day','','','','','PO Box 279','','Woy Woy',2256,2,11,NULL,NULL,NULL,NULL,NULL,0,5,219020078,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(65,65,NULL,45152,1,'\0','\0',NULL,'','Garry Craig',2,'Block B - Wallsend Admin Building',2287,'','49514033','','Port Hunter Basketball Club','','','','','68A','Wolfe St ','Newcastle',2300,2,9,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(66,66,NULL,44827,1,'\0','\0',NULL,'','Martin  Clarke',2,'Block B - Wallsend Admin Building',2287,'','49519338','','Belswans Junior Soccer Club','','','','','PO Box 3007','','Blacksmiths',2281,2,9,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(67,67,NULL,44924,1,'\0','\0',NULL,'','Pauline Roberts',4,'Block C - Wallsend Admin Building',2287,'','49510841','','Cancer Council','','','','','153','Dowling St','Wooloomooloo',2011,2,6,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(68,68,NULL,45975,1,'\0','\0',NULL,'','Craig Garland',2,'Building 15 - Abbot Street Depot',2287,'','409366286','','Cameron Park Rural Fire Brigade','','','','','PO Box 103','','West Wallsend',2286,2,11,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(69,69,NULL,39833,1,'\0','\0',NULL,'','Adam McLennon',4,'16 Dryandra Place Redhead NSW 2290',2287,'','414192458','','Redhead Rugrats Playgroup','','','','','Girl Guides Hall','Steel St','Redhead',2290,2,3,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(70,70,NULL,52133,1,'\0','\0',NULL,'','Luke Barfield',4,'Block B - Wallsend Admin Building',2287,'','49510112','','MS Australia','','','','','Private Bag 4444','','Artarmon',1570,2,6,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(71,71,NULL,52134,1,'\0','\0',NULL,'','Rebecca  Rees',4,'Block B - Wallsend Admin Building',2287,'','49101459','','MS Australia','','','','','Private Bag 4444','','Artarmon',1570,2,6,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(72,72,NULL,47401,1,'\0','\0',NULL,'','Christian Bell',4,'Block B - Wallsend Admin Building',2287,'','49539287','','MS Australia','','','','','Private Bag 4444','','Artarmon',1570,2,6,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(73,73,NULL,47423,1,'\0','\0',NULL,'','Mark  De Krey',1,'Building 3 - Abbot Street Depot',2287,'','49510118','','Pelaw Mains Titans Soccer Club','','','','','PO Box 472','','Kurri Kurri',2327,2,9,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(74,74,NULL,47130,1,'\0','\0',NULL,'','Karl Bamber',4,'Block B - Wallsend Admin Building',2287,'','49101266','','MS Australia','','','','','Private Bag 4444','','Artarmon',1570,2,6,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(75,75,NULL,53254,1,'\0','\0',NULL,'','Danielle Scott',4,'Block B - Wallsend Admin Building',2287,'','49519322','','MS Australia','','','','','Private Bag 4444','','Artarmon',1570,2,6,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(76,76,NULL,47133,1,'\0','\0',NULL,'','Peter Bryan',4,'Block B - Wallsend Admin Building',2287,'','49101342','','MS Australia','','','','','Private Bag 4444','','Artarmon',1570,2,6,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(77,77,NULL,52210,1,'\0','\0',NULL,'','Erin  Counsell',4,'Block B - Wallsend Admin Building',2287,'','49519656','','MS Australia','','','','','Private Bag 4444','','Artarmon',1570,2,6,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(78,78,NULL,45669,1,'\0','\0',NULL,'','Doug  Pickering',2,'Block A - Wallsend Admin Building',2287,'','49519610','','MS Australia','','','','','Private Bag 4444','','Artarmon',1570,2,6,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(79,79,NULL,44468,1,'\0','\0',NULL,'','Leanne  Kerby',1,'6 Roberts St Charlestown',2289,'','49420836','','Cancer Council','','','','','22','Lambton Rd','Broadmeadow',2292,2,6,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(80,80,NULL,48698,1,'\0','\0',NULL,'','Andrew Moriarty',6,'Block B - Wallsend Admin Building',2287,'','49101268','','Plattsburg Public School P & C Association','','','','','','Ranclaud St','Wallsend',2287,2,3,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(81,81,NULL,49688,1,'\0','\0',NULL,'','Damien Barnard',1,'Building 3 - Abbot Street Depot',2287,'','437591941','','Cardiff Heights Christian Fellowship','','','','','30','Northville Dr','Edgeworth',2285,2,11,NULL,NULL,NULL,NULL,NULL,0,6,219020079,'2010-08-01 00:00:00',0,0.00,NULL,'2010-08-01 00:00:00',NULL,738050,'\0','\0'),(82,82,NULL,45036,1,'\0','\0',NULL,'','Lynne Powell',1,'Building 16 - Abbot Street Depot',2307,'','49510117','','Shortland Devils Netball Club','','','','','23','Waller St','Shortland',2287,2,9,NULL,NULL,NULL,NULL,NULL,0,6,219020079,'2010-08-01 00:00:00',0,0.00,NULL,'2010-08-01 00:00:00',NULL,738050,'\0','\0'),(83,83,NULL,47729,1,'\0','\0',NULL,'','James Hickey',2,'Block B - Wallsend Admin Building',2315,'','49510873','','Care For China ','','','','','216','Beales Rd','Greensborough',3088,2,11,NULL,NULL,NULL,NULL,NULL,0,6,219020079,'2010-08-01 00:00:00',0,0.00,NULL,'2010-08-01 00:00:00',NULL,738050,'\0','\0'),(84,84,NULL,46144,1,'\0','\0',NULL,'','Michael Brown',1,'Muswellbrook Depot ',2330,'','427016178','','Riding for the Disabled','','','','','','Sandy Creek Rd','Muswellbrook',2333,2,11,NULL,NULL,NULL,NULL,NULL,1,7,219020080,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(85,85,NULL,44591,2,'\0','\0',NULL,'','Nicholas  Burley',1,'Singleton Depot Orchard Ave Singleton',2330,'','65719716','','Singleton Heights Pre-School','','','','','','Dorsman Dr ','Singleton',2330,2,3,NULL,NULL,NULL,NULL,NULL,1,7,219020080,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(86,86,NULL,44591,1,'\0','\0',NULL,'','Nicholas  Burley',1,'Singleton Depot Orchard Ave Singleton',2330,'','65719716','','SingletonHeights Public School','','','','','','Dorsman Dr ','Singleton',2330,2,3,NULL,NULL,NULL,NULL,NULL,1,7,219020080,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(87,87,NULL,46205,1,'\0','\0',NULL,'','Bruce Bennett',1,'Muswellbrook Depot ',2333,'','428238689','','Cystic Fibrosis','','','','','PO Box 254','','North Ryde',1670,2,6,NULL,NULL,NULL,NULL,NULL,1,7,219020080,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(88,88,NULL,48532,1,'\0','\0',NULL,'','Gary  Davis',1,'Muswellbrook Depot ',2333,'','428412483','','Scone Amateur Athletics Club','','','','','PO Box 69','','Scone',2337,2,9,NULL,NULL,NULL,NULL,NULL,1,7,219020080,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(89,89,NULL,46208,1,'\0','\0',NULL,'','Craig Manwarring',1,'Muswellbrook Depot ',2333,'','428474217','','Muswellbrook Child Care Centre','','','','','','Skellatar St','Muswellbrook',2333,2,3,NULL,NULL,NULL,NULL,NULL,1,7,219020080,'2010-08-01 00:00:00',1,300.00,NULL,'2010-08-01 00:00:00',NULL,738050,'','\0'),(90,90,NULL,50802,1,'\0','\0',NULL,'','Perry Stephenson',2,'Level 10, RCH, 24 Campbell St, Sydney',2035,'','434950878','','MS Australia','','','','','Private Bag 4444','','Artamon',1570,2,6,NULL,NULL,NULL,NULL,NULL,1,1,219020074,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(91,91,NULL,47149,1,'\0','\0',NULL,'','Joshua  Hayden',2,'Level 8, RCH, 24 Campbell St, Sydney',2007,'','92726226','','Dragon\'s Abreast Australia','','','','','PO Box 36923','','Winnellie',821,3,6,NULL,NULL,NULL,NULL,NULL,1,1,219020074,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(92,92,NULL,47153,1,'\0','\0',NULL,'','Michael Portelli',2,'Level 8, RCH, 24 Campbell St, Sydney',2007,'','92723524','','Dragon\'s Abreast Australia','','','','','PO Box 36923','','Winnellie',821,3,6,NULL,NULL,NULL,NULL,NULL,1,1,219020074,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(93,93,NULL,46877,1,'\0','\0',NULL,'','Jenny  Griffen',6,' Level 19, HOB 570 George St Sydney',2050,'','92692625','','Dragon\'s Abreast Australia','','','','','PO Box 36923','','Winnellie',821,3,6,NULL,NULL,NULL,NULL,NULL,1,1,219020074,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(94,94,NULL,51103,1,'\0','\0',NULL,'','Jullian  North',2,'Level 8, RCH, 24 Campbell St, Sydney',2050,'','92923790','','Dragon\'s Abreast Australia','','','','','PO Box 36923','','Winnellie',821,3,6,NULL,NULL,NULL,NULL,NULL,1,1,219020074,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(95,95,NULL,30715,1,'','\0',NULL,'','Garry O\'Brien',1,'Building 3, 25 - 27 Pomeroy St, Homebush',2007,'','93946973','','Glebe/Leichhardt PCYC','','','','','40635','Minogue Cresent','Glebe',2037,2,10,NULL,NULL,NULL,NULL,NULL,1,1,159020435,'2010-09-01 00:00:00',1,0.00,NULL,'2010-09-01 00:00:00',NULL,NULL,'','\0'),(96,96,NULL,47254,1,'\0','\0',NULL,'','Anna Richardson',2,'Level 8, RCH',2077,'','92723724','','Dragons Abreast Australia','','','','','GPO Box 1948','','Darwin',801,3,6,NULL,NULL,NULL,NULL,NULL,1,2,219020075,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(97,97,NULL,50198,1,'\0','\0',NULL,'','Joseph Canaris',1,'Level 8, RCH',2092,'','404186167','','Dragons Abreast Australia','','','','','GPO Box 1948','','Darwin',801,3,6,NULL,NULL,NULL,NULL,NULL,0,2,219020075,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(98,98,NULL,46658,1,'\0','\0',NULL,'','Jill Brett',1,'Bldg 5, Chatswood Depot',2087,'','94105470','','Dragons Abreast Australia','','','','','GPO Box 1948','','Darwin',801,3,6,NULL,NULL,NULL,NULL,NULL,0,2,219020075,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(99,99,NULL,49727,1,'\0','\0',NULL,'','Chun Yik Lim',6,'Level 8, HOB',2067,'','92694389','','Dragons Abreast Australia','','','','','GPO Box 1948','','Darwin',801,3,6,NULL,NULL,NULL,NULL,NULL,0,2,219020075,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(100,100,NULL,49447,1,'\0','\0',NULL,'','Lauren Tan',3,'Level 6, HOB',2064,'','92694662','','Dragons Abreast Australia','','','','','GPO Box 1948','','Darwin',801,3,6,NULL,NULL,NULL,NULL,NULL,0,2,219020075,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(101,101,NULL,50762,1,'\0','\0',NULL,'','Emma Cunningham',6,'Level 14, HOB',2065,'','92692762','','Dragons Abreast Australia','','','','','GPO Box 1948','','Darwin',801,3,6,NULL,NULL,NULL,NULL,NULL,1,2,219020075,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(102,102,NULL,54053,1,'\0','\0',NULL,'','Steven Hancock',1,'Oatley',2226,'','88785032','','World Vision','','','','','153','Pacific Hwy','Charlestown',2290,2,11,NULL,NULL,NULL,NULL,NULL,1,3,219020076,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(103,103,NULL,48178,1,'\0','\0',NULL,'','David Barlow',1,'Bldg 5, Zetland',2519,'','448469146','','Bulli Surf Life Saving Club','','','','','','Trinity Row','Bulli',2516,2,4,NULL,NULL,NULL,NULL,NULL,1,3,219020076,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(104,104,NULL,50512,1,'\0','\0',NULL,'','Michelle Fretten',2,'Bldg 1, Homebush',2229,'','93946678','','Elouera Surf Life Saving Club','','','','','','Mitchell Rd','Cronulla',2230,2,4,NULL,NULL,NULL,NULL,NULL,1,3,219020076,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(105,105,NULL,49670,1,'\0','\0',NULL,'','Diane Rozos',5,'Lv 11, HOB',2223,'','92692984','','RSPCA NSW','','','','','62','Hume Hwy','Chullora',2190,2,1,NULL,NULL,NULL,NULL,NULL,0,3,219020076,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(106,106,NULL,37853,1,'\0','\0',NULL,'','Julie Brasher',4,'Lv 11, RCH',2234,'','439304508','','Cancer Council NSW','','','','','155','Dowling St','Woolloomooloo',2011,2,6,NULL,NULL,NULL,NULL,NULL,0,3,219020076,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(107,107,NULL,52688,1,'\0','\0',NULL,'','Michael Henry',1,'Gnd Flr, Bldg 1, Homebush',2227,'','88785032','','Elouera Surf Life Saving Club','','','','','','Mitchell Rd','Cronulla',2230,2,4,NULL,NULL,NULL,NULL,NULL,0,3,219020076,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(108,108,NULL,48697,1,'\0','\0',NULL,'','Mark de Lacey',3,'Lv 3, HOB',2232,'','439134070','','Dragons Abreast Australia Gift Account','','','','','GPO Box 1948','','Darwin NT',801,2,6,NULL,NULL,NULL,NULL,NULL,1,3,219020076,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(109,109,NULL,48888,2,'\0','\0',NULL,'','James Graham',1,'Lv 1, Bldg 2, Oatley',2227,'','409077184','','Sutherland Little Athletics','','','','','PO Box 374','','Sutherland',1499,2,9,NULL,NULL,NULL,NULL,NULL,0,3,219020076,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(110,110,NULL,40245,1,'\0','\0',NULL,'','James Hunkin',2,'Lv 15, HOB',2219,'','92697379','','1st Oatley Bay Rover Crew','','','','','','Annette St','Oatley',2223,2,10,NULL,NULL,NULL,NULL,NULL,1,3,219020076,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(111,111,NULL,40245,2,'\0','\0',NULL,'','James Hunkin',2,'Lv 15, HOB',2219,'','92697379','','Sans Souci Girl Guides','','','','','','Sandringham St','Sans Souci',2219,2,10,NULL,NULL,NULL,NULL,NULL,1,3,219020076,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(112,112,NULL,51501,1,'\0','\0',NULL,'','Victoria Watson',2,'Gnd Flr, Bldg 2, Homebush',2560,'','93946002','','RSPCA NSW','','','','','62','Hume Hwy','Chullora',2190,2,1,NULL,NULL,NULL,NULL,NULL,1,3,219020076,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(113,113,NULL,48907,1,'\0','\0',NULL,'','May Beadle',1,'Top Flr, Bldg 1, Oatley',2207,'','95855609','','Dragons Abreast Australia Gift Account','','','','','GPO Box 1948','','Darwin',801,3,6,NULL,NULL,NULL,NULL,NULL,0,3,219020076,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(114,114,NULL,48783,1,'\0','\0',NULL,'','Celia Harris',2,'CMT, 14 Nelson St Chatswood',2117,'','35310','','North Rocks/Carlingford Little Athletics','','','','','5','Dunmore Rd','Epping',2121,2,9,NULL,NULL,NULL,NULL,NULL,1,4,219020077,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(115,115,NULL,44067,2,'\0','\0',NULL,'','Jonathan Mallin',2,'Gnd Flr, Bdg 1, Homebush',2776,'','36763','','Blackheath RFS','','','','','','Station St','Blackheath',2785,2,4,NULL,NULL,NULL,NULL,NULL,1,4,219020077,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(116,116,NULL,44067,1,'\0','\0',NULL,'','Jonathan Mallin',2,'Gnd Flr, Bdg 1, Homebush',2776,'','36763','','Springwood Boys Brigade','','','','','14A','The Avenue','Warrimoo',2774,2,10,NULL,NULL,NULL,NULL,NULL,1,4,219020077,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(117,117,NULL,44068,1,'\0','\0',NULL,'','Joel McElveney',1,'Gnd Flr, Bdg 1, 51-59 Bridge Rd, Hornsby',2154,'','38315','','Oxfam','','','','','PO Box 1711 ','','Strawberry Hills',2012,2,11,NULL,NULL,NULL,NULL,NULL,1,4,219020077,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(118,118,NULL,39935,1,'\0','\0',NULL,'','Robert Addie',1,'Bdg 3, Homebush',2155,'','36562','','Baulkham Hills Australian Football Club','','','','','PO Box 6610','','Baulkham Hills BC',2153,2,11,NULL,NULL,NULL,NULL,NULL,1,4,219020077,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(119,119,NULL,37796,1,'\0','\0',NULL,'','Stephen Hodge',1,'Gnd Flr, Blg 3, Hornsby',2147,'','38224','','St Bernadette\'s Lalor Park Parent Group','','','','','18','Wheeler St','Lalor Park',2147,2,3,NULL,NULL,NULL,NULL,NULL,1,4,219020077,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(120,120,NULL,32928,1,'\0','\0',NULL,'','Allan Brooker',1,'Bdg 5, Homebush',2168,'','412814686','','NUSwim','','','','','PO Box 22','Union Building','Newcastle University',2308,2,9,NULL,NULL,NULL,NULL,NULL,1,4,219020077,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(121,121,NULL,43569,1,'','\0',NULL,'','Rene Ison',1,'Bdg 5, Homebush',2146,'','36603','','Pendle Hill Cub Scouts','','','','','Scout Hall','Civic Park Targo Rd','Pendle Hill',2145,2,10,NULL,NULL,NULL,NULL,NULL,1,4,159020435,'2010-09-01 00:00:00',1,0.00,NULL,'2010-09-01 00:00:00',NULL,NULL,'','\0'),(122,122,NULL,41754,1,'\0','\0',NULL,'','Russell Hokin',1,'Silverwater Training Centre',2557,'','437408873','','Mount Annan Swimming Club','','','','','PO Box 352','','Narellan',2567,2,9,NULL,NULL,NULL,NULL,NULL,1,4,219020077,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(123,123,NULL,43567,1,'\0','\0',NULL,'','Troy Metcalfe',1,'Gosford',2262,'','407293833','','Rural Fire Services Wamberal','','','','','','Tumbi rd','Wamberal',2260,2,4,NULL,NULL,NULL,NULL,NULL,1,5,219020078,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(124,124,NULL,39963,1,'\0','\0',NULL,'','Paul  Stubbs',1,'Chatswood',2259,'','418471622','','Wyong Water polo','','','','','16','Mountain Ash rd','Hamlyn Terrace',2259,2,9,NULL,NULL,NULL,NULL,NULL,1,5,219020078,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(125,125,NULL,46510,1,'\0','\0',NULL,'','Greg Irvine',1,'Noraville',2262,'','409322794','','Budgewoi Junior Guides','','','','','','Narambi rd','Buff Point',2262,2,10,NULL,NULL,NULL,NULL,NULL,0,5,219020078,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(126,126,NULL,43467,1,'\0','\0',NULL,'','Michael  Strong',1,'Noraville',2259,'','408671187','','M.S Australia','','','','','Private Bag 4444','','Artarmon',4444,2,6,NULL,NULL,NULL,NULL,NULL,0,5,219020078,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(127,127,NULL,38638,1,'\0','\0',NULL,'','John Lyons',1,'Noraville',2261,'','43258767','','M.S Australia','','','','','Private Bag 4444','','Artarmon',4444,2,6,NULL,NULL,NULL,NULL,NULL,1,5,219020078,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(128,128,NULL,39064,1,'\0','\0',NULL,'','William  Stien',1,'Noraville',2261,'','418961926','','M.S Australia','','','','','Private Bag 4444','','Artarmon',4444,2,6,NULL,NULL,NULL,NULL,NULL,1,5,219020078,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(129,129,NULL,38590,1,'\0','\0',NULL,'','Warrick  Lang',1,'Noraville',2259,'','38590','','M.S Australia','','','','','Private Bag 4444','','Artarmon',4444,2,6,NULL,NULL,NULL,NULL,NULL,1,5,219020078,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(130,130,NULL,53015,1,'\0','\0',NULL,'','Ben Vaughan',1,'Gosford',2261,'','419637895','','M.S Australia','','','','','Private Bag 4444','','Artarmon',4444,2,6,NULL,NULL,NULL,NULL,NULL,0,5,219020078,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(131,131,NULL,50673,1,'\0','\0',NULL,'','Sean mcGaharan',1,'Gosford',2263,'','38609','','M.S Australia','','','','','Private Bag 4444','','Artarmon',4444,2,6,NULL,NULL,NULL,NULL,NULL,0,5,219020078,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(132,132,NULL,46518,1,'','\0',NULL,'','Robert  Arber',1,'Gosford',2256,'','419483569','','Marine Rescue','','','','','','Kurrawa av','Point Clair',2256,2,4,NULL,NULL,NULL,NULL,NULL,0,5,159020435,'2010-09-01 00:00:00',1,0.00,NULL,'2010-09-01 00:00:00',NULL,NULL,'','\0'),(133,133,NULL,44988,1,'\0','\0',NULL,'','Tracey Neilson',4,'Block C - Wallsend Admin Building',2287,'','49510307','','St Johns Primary School P & F Association','','','','','','Dickson St','Lambton',2299,2,3,NULL,NULL,NULL,NULL,NULL,0,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(134,134,NULL,45505,1,'\0','\0',NULL,'','Paul McGuinnes',1,'Building 14 - Abbott St Depot',2299,'','418242360','','NUSwim Swimming Club','','','','','PO Box 22 ','','Callaghan ',2308,2,9,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(135,135,NULL,52161,1,'\0','\0',NULL,'','Allan Brooker',6,'Block C - Wallsend Admin Building',2324,'','458713279','','NUSwim Swimming Club','','','','','PO Box 22 ','','Callaghan ',2308,2,9,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(136,136,NULL,49580,1,'\0','\0',NULL,'','Leonie Martin',4,'Block C - Wallsend Admin Building',2285,'','131502','','Glendale Early Education Centre','','','','','','Stockland Dr','Glendale',2285,2,3,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(137,137,NULL,44684,1,'\0','\0',NULL,'','Kerri  McCaw',4,'Block C - Wallsend Admin Building',2324,'','49510806','','Seaham Public School P & C','','','','','','Still St','Seaham',2324,2,3,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(138,138,NULL,44441,1,'\0','\0',NULL,'','Fiona Thurlow',4,'Block C - Wallsend Admin Building',2305,'','131502','','New Lambton Junior Soccer Club','','','','','PO Box 209','','New Lambton',2305,2,9,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(139,139,NULL,47350,1,'\0','\0',NULL,'','Darragh O\'Hagan',4,'Block B - Wallsend Admin Building',2291,'','49510765','','MS Australia','','','','','Private Bag 4444','','Artarmon ',1570,2,6,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(140,140,NULL,54544,1,'\0','\0',NULL,'','Greg Smith',4,'Block B - Wallsend Admin Building',2323,'','49544086','','MS Australia','','','','','Private Bag 4444','','Artarmon ',1570,2,6,NULL,NULL,NULL,NULL,NULL,0,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(141,141,NULL,47649,1,'\0','\0',NULL,'','Liz Reid',4,'Block C - Wallsend Admin Building',2290,'','49519556','','Down Syndrome Association of NSW','','','','','','Mabel St','Georgetown',2298,2,6,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(142,142,NULL,47473,1,'\0','\0',NULL,'','Lesa Bradford',4,'Block C - Wallsend Admin Building',2322,'','131502','','Thornton Park Junior Cricket Club','','','','','','Taylor Ave','Thornton',2322,2,9,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(143,143,NULL,45670,1,'\0','\0',NULL,'','Simon Young',1,'Building 3 - Abbot Street Depot',2289,'','408653136','','Hamilton South Public School','','','','','96','Kenrick St','Merewether',2291,2,3,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(144,144,NULL,49614,1,'\0','\0',NULL,'','Megan Bailey',2,'Block A - Wallsend Admin Building',2291,'','49519280','','Henry St Community Pre-School','','','','','','Henry St','Merewether',2291,2,3,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(145,145,NULL,50933,1,'\0','\0',NULL,'','Matthew  Ophir',1,'Building 3 - Abbot Street Depot',2289,'','408653136','','Adamstown Primary School P & C','','','','','1A','Bryant St','Adamstown',2291,2,3,NULL,NULL,NULL,NULL,NULL,1,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(146,146,NULL,47412,1,'\0','\0',NULL,'','Louise  Sneddon',4,'Block C - Wallsend Admin Building',2287,'','49070129','','Newcastle Netball Association','','','','','','Union St','Newcastle',2300,2,9,NULL,NULL,NULL,NULL,NULL,0,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(147,147,NULL,46048,1,'\0','\0',NULL,'','Christopher Cox',1,'Building 3 - Abbot Street Depot',2290,'','419236763','','Newcastle Talent Education Association ','','','','','27','Kendella Pde','Kahibah',2290,2,11,NULL,NULL,NULL,NULL,NULL,0,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(148,148,NULL,46739,1,'\0','\0',NULL,'','Paul McGlynn',2,'Block A - Wallsend Admin Building',2280,'','49519352','','Lake Macquarie Winds','','','','','PO Box 3071','','Valentine',2280,2,11,NULL,NULL,NULL,NULL,NULL,0,6,219020079,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(149,149,NULL,46207,1,'\0','\0',NULL,'','Jody Ingold',1,'Muswellbrook Depot ',2333,'','59023','','Relay for Life','','','','','','','Muswellbrook',2333,2,6,NULL,NULL,NULL,NULL,NULL,0,7,219020080,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(150,150,NULL,45967,1,'\0','\0',NULL,'','Garry Jones',1,'Singleton Depot Orchard Ave Singleton',2333,'','59716','','Police Citizens Heights Cricket Club','','','','','17','Bathurst St','Singleton',2330,2,9,NULL,NULL,NULL,NULL,NULL,0,7,219020080,'2010-09-01 00:00:00',1,300.00,NULL,'2010-09-01 00:00:00',NULL,738050,'','\0'),(151,96,NULL,55945,1,'\0','\0',NULL,'','Stacey Wakjer',6,'RCH',2029,'Rose Bay','0412886976','','Test Org 2','Testing','Test Only','','','1','Test Street','Rose Bay',2029,2,1,NULL,1,NULL,12,'Test',0,1,219020074,'2011-04-08 08:56:12',1,300.00,NULL,'2011-04-08 11:43:24',42,738050,'','\0'),(152,97,NULL,55067,1,'\0','\0',NULL,'','Martin Harris',7,'Level: 19, George St.',2021,'Paddington','0427513271','','Sample','Chair','Mr Smith','0427513271','chair@sample.com.au','1','Org','Paddington',2021,2,2,NULL,2,NULL,1,NULL,1,1,219020074,'2011-04-08 12:09:43',0,NULL,1,'2011-04-08 12:10:53',3,NULL,NULL,'\0'),(153,98,NULL,55067,2,'\0','\0',NULL,'','Martin Harris',7,'Level: 19, George St.',2021,'Paddington','0427513271','','Real Org','CEO','Mr John','0427513271','john@real.com.au','1','tree','Balmain',2041,2,1,NULL,1,NULL,1,NULL,1,1,219020074,'2011-04-08 12:15:21',1,300.00,NULL,'2011-05-17 10:28:24',2,738050,'','\0'),(154,133,NULL,52439,1,'\0','\0',NULL,'','Seija Wolk',3,'Level: 9, George St.',2259,'Wadalba','0427513271','','Charity','Leader','Charity Jones','0298989898','charity@charity.com','1','wer','Wadalba',2259,2,2,NULL,8,NULL,1,NULL,0,5,219020078,'2011-04-08 12:21:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'),(155,99,NULL,55702,1,'\0','\0',NULL,'','Tess Ariotti',7,'HOB',2000,'sydney','0427513271','tariotti@energy.com','hoyg','flyuhg','hfig','','','4','tgiugiu','Sydney South',1231,2,2,NULL,1,NULL,2,NULL,0,1,219020074,'2011-04-08 12:31:36',1,300.00,NULL,'2011-05-17 10:28:24',2,738050,'','\0'),(156,100,NULL,47720,1,'\0','\0',NULL,'','Myra Basic',5,'Level: 11, George St.',2041,'Balmain','0427513271','','yifryuf','yufyu','ugfiuf','','','47','gtfyu','Pymble',2073,2,1,NULL,1,NULL,1,NULL,0,1,219020074,'2011-04-08 12:42:52',0,NULL,9,'2011-05-17 10:28:50',2,NULL,NULL,'\0'),(157,102,NULL,46658,3,'','\0',NULL,'','Jill Brett',1,'Level: 1, Bldg 5, Chatswood',2057,'Chatswood','0427513271','','retgra','Arhyaerh','drhgarehg','','','34','sgh','Chatswood',2057,2,2,NULL,NULL,NULL,1,NULL,1,2,219020075,'2011-04-08 13:08:09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'),(158,114,NULL,23654,1,'\0','\0',NULL,'','Denis Partridge',4,'Level: 1, Homebush Business Village',2224,'Kangaroo Point','0427513271','','adhgrea','dryhar','dsrhyae','','','arya','34','Rydalmere',2116,2,2,NULL,3,NULL,1,NULL,1,3,219020076,'2011-04-08 13:09:14',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'),(159,115,NULL,46658,1,'\0','\0',NULL,'','Jill Brett',1,'Level: 1, Bldg 5, Chatswood',2219,'Sans Souci','0427513271','','dsfqwr','argareg','argyraegra','','','23','artg','Sans Souci',2219,2,4,NULL,2,NULL,2,NULL,1,3,219020076,'2011-04-08 13:10:24',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0'),(160,123,NULL,44455,1,'\0','\0',NULL,'','Lawrence Bolton',1,'Level: 1, Bldg 1, Hornsby',2119,'Cheltenham','0411111111','','esiru','ashrek','srekfj','','','PO Box 444','hfjhy','Cheltenham',2119,2,10,NULL,8,NULL,11,NULL,1,4,219020077,'2011-04-20 08:59:16',1,300.00,NULL,'2011-05-24 13:13:28',42,738050,NULL,'\0'),(161,124,NULL,39887,1,'\0','\0',NULL,NULL,'Peter Terry',1,'Chatswood',2564,'Glenquarrie','0412341232','','rwewe','tqwertwr','qwerwer','0232434235','','3','qwerty','Fairfield',2165,2,1,NULL,2,NULL,1,NULL,1,4,219020077,'2011-05-25 15:46:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'\0');

--
-- Table structure for table `commcare_submissions_inkind_uses`
--

CREATE TABLE `commcare_submissions_inkind_uses` (
  `submission_id` int(11) NOT NULL,
  `interior_lighting` tinyint(4) DEFAULT '0',
  `fans` tinyint(4) DEFAULT '0',
  `floodlighting` tinyint(4) DEFAULT '0',
  `powerpoints` tinyint(4) DEFAULT '0',
  `switchboards` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`submission_id`),
  CONSTRAINT `commcare_submissions_inkind_uses_ibfk_1` FOREIGN KEY (`submission_id`) REFERENCES `commcare_submissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commcare_submissions_inkind_uses`
--

INSERT INTO `commcare_submissions_inkind_uses` VALUES (157,1,1,1,1,1);

--
-- Table structure for table `commcare_volunteer_roles`
--

CREATE TABLE `commcare_volunteer_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(255) DEFAULT NULL,
  `ord` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ord` (`ord`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commcare_volunteer_roles`
--

INSERT INTO `commcare_volunteer_roles` VALUES (1,'Administration/Clerical',1),(2,'Coach',2),(3,'Co-orindator',3),(4,'Event assistance',4),(5,'Fundraiser',5),(6,'One-off event participant',6),(7,'President',7),(8,'Registrations',8),(9,'Secretary',9),(10,'Support',10),(11,'Volunteer',11),(12,'Other',12);

--
-- Table structure for table `divisions`
--

CREATE TABLE `divisions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `divisions`
--

INSERT INTO `divisions` VALUES (1,'DO&R'),(2,'TSO'),(3,'SP&R'),(4,'Shared Services'),(5,'Retail'),(6,'Finance & Corporate'),(7,'Office of the MD'),(8,'Human Resources');

--
-- Table structure for table `document_groups`
--

CREATE TABLE `document_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `document_groups`
--

INSERT INTO `document_groups` VALUES (2,'CommCare Marketing Docs'),(1,'CommCare RECC User Docs');

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text,
  `filepath` varchar(255) DEFAULT NULL,
  `document_group` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `documents`
--

INSERT INTO `documents` VALUES (1,'Community Care Overview',NULL,'docs/community_care_overview.pdf',1),(2,'Community Care Council Charter',NULL,'docs/community_care_council_charter.pdf',1),(3,'RECC Charter',NULL,'docs/recc_charter.pdf',1),(4,'RECC Member Appointment Process',NULL,'docs/recc_member_appointment_process.pdf',1),(5,'RECC Member Chart',NULL,'docs/recc_member_chart.pdf',1),(6,'RECC Member Application Form',NULL,'docs/recc_member_application_form.pdf',1),(7,'RECC Meeting Agenda',NULL,'docs/recc_meeting_agenda.doc',1),(8,'RECC Meeting Minutes',NULL,'docs/recc_meeting_minutes.doc',1),(9,'Payroll Giving',NULL,'docs/payroll_giving.pdf',1),(10,'Payroll Giving New Charity Registration',NULL,'docs/payroll_giving_new_charity_registration.pdf',1),(11,'Cash Grant Application hardcopy',NULL,'docs/cash_grant_application_hardcopy.pdf',1),(12,'Electrical Job Applicaiton hardcopy',NULL,'docs/electrical_job_application _hardcopy.pdf',1);

--
-- Table structure for table `forms`
--

CREATE TABLE `forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `forms`
--

INSERT INTO `forms` VALUES (1,'CommCare','Community Care Program Application'),(2,'TravelTime','Application for Reimbursement for Traveling'),(3,'SiteInspect','Site Inspection Forms');

--
-- Table structure for table `holidays`
--

CREATE TABLE `holidays` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` int(11) DEFAULT NULL,
  `month` tinyint(4) DEFAULT NULL,
  `day` tinyint(4) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_date` (`year`,`month`,`day`),
  KEY `idx_year` (`year`),
  KEY `idx_month` (`month`),
  KEY `idx_day` (`day`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `holidays`
--

INSERT INTO `holidays` VALUES (1,NULL,12,25,'Christmas');

--
-- Table structure for table `login_codes`
--

CREATE TABLE `login_codes` (
  `code` varchar(64) NOT NULL,
  `user_id` int(11) NOT NULL,
  `valid_until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_id`,`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `login_codes`
--

INSERT INTO `login_codes` VALUES ('a338dd33b13a620e1d7fc11d3c542126',46,'2011-06-04 09:39:50'),('6c9a754e7991448c9e8b1e5d3a1dec4d',47,'2011-06-04 09:39:53'),('15b1e7d49fd20466e417f68dd0df1dfc',52,'2011-06-04 09:39:54'),('828af3883f681bd61f516c606a2ef4cb',55,'2011-06-04 09:39:55'),('901b76efe7c7454db1022501193f87d7',57,'2011-06-04 09:39:56'),('e63212096ce2e1fb316cd78eecd231f6',67,'2011-06-04 09:39:56'),('d713c63e54f1f17531c2f9fcb359a6a0',85,'2011-06-04 09:39:58');

--
-- Table structure for table `paygrades`
--

CREATE TABLE `paygrades` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acronym` varchar(16) DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `rate` decimal(8,2) DEFAULT NULL,
  `parent_paygrade` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_name` (`name`),
  KEY `idx_acronym` (`acronym`)
) ENGINE=InnoDB AUTO_INCREMENT=426 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `paygrades`
--

INSERT INTO `paygrades` VALUES (1,'J1','J1',8.89,NULL),(2,'J2','J2',9.34,NULL),(3,'J3','J3',9.80,NULL),(4,'J4','J4',10.29,NULL),(5,'J5','J5',10.80,NULL),(6,'J6','J6',11.35,NULL),(7,'J7','J7',11.91,NULL),(8,'J8','J8',12.51,NULL),(9,'J9','J9',13.13,NULL),(10,'J10','J10',13.79,NULL),(11,'J10-5','J10+SR',13.79,10),(12,'J10-7','J10+SR80',13.79,10),(13,'J11','J11',14.48,NULL),(14,'J12','J12',15.20,NULL),(15,'J13','J13',15.96,NULL),(16,'J14','J14',16.75,NULL),(17,'J14-5','J14+SR',16.75,16),(18,'J14-7','J14+SR80',16.75,16),(19,'J15','J15',17.60,NULL),(20,'J15-5','J15+SR',17.60,19),(21,'J16','J16',18.47,NULL),(22,'J17','J17',19.40,NULL),(23,'J17-5','J17+SR',19.40,22),(24,'J17-7','J17+SR80',19.40,22),(25,'J18','J18',20.37,NULL),(26,'J18-5','J18+SR',20.37,25),(27,'1','1',20.87,NULL),(28,'2','2',21.28,NULL),(29,'2-1','2+EL',21.28,28),(30,'2-2','2+ELSR',21.28,28),(31,'2-5','2+SR',21.28,28),(32,'2-7','2+SR80',21.28,28),(33,'3','3',21.70,NULL),(34,'4','4',22.11,NULL),(35,'5','5',22.55,NULL),(36,'6','6',22.98,NULL),(37,'6-5','6+SR',22.98,36),(38,'7','7',23.43,NULL),(39,'7-6','7+SREO',23.43,38),(40,'8','8',23.89,NULL),(41,'8-5','8+SR',23.89,40),(42,'8-6','8+SREO',23.89,40),(43,'9','9',24.37,NULL),(44,'9-5','9+SR',24.37,43),(45,'9-6','9+SREO',24.37,43),(46,'10','10',24.86,NULL),(47,'10-5','10+SR',24.86,46),(48,'10-6','10+SREO',24.86,46),(49,'10Y','10Y',24.95,NULL),(50,'10Y-6','10Y+SREO',24.95,49),(51,'11','11',25.36,NULL),(52,'11-1','11+EL',25.36,51),(53,'11-5','11+SR',25.36,51),(54,'11-6','11+SREO',25.36,51),(55,'12','12',25.86,NULL),(56,'12-5','12+SR',25.86,55),(57,'12-6','12+SREO',25.86,55),(58,'12Y','12Y',25.95,NULL),(59,'12Y-1','12Y+EL',25.95,58),(60,'12Y-2','12Y+ELSR',25.95,58),(61,'12Y-5','12Y+SR',25.95,58),(62,'13','13',26.39,NULL),(63,'13-5','13+SR',26.39,62),(64,'13-6','13+SREO',26.39,62),(65,'14','14',26.91,NULL),(66,'14-5','14+SR',26.91,65),(67,'14-6','14+SREO',26.91,65),(68,'14Y','14Y',27.00,NULL),(69,'15','15',27.45,NULL),(70,'15-1','15+EL',27.45,69),(71,'15-2','15+ELSR',27.45,69),(72,'15-5','15+SR',27.45,69),(73,'15-6','15+SREO',27.45,69),(74,'15-7','15+SR80',27.45,69),(75,'15F','15+CTA',27.45,69),(76,'15M','15+PLTA',27.45,69),(77,'15P','15+PTA+PRA',27.45,69),(78,'15W','15+PTA{NO PRA}',27.45,69),(79,'15Y','15Y',27.54,NULL),(80,'15Y-1','15Y+EL',27.54,79),(81,'15Y-2','15Y+ELSR',27.54,79),(82,'15Y-5','15Y+SR',27.54,79),(83,'16','16',27.99,NULL),(84,'16-1','16+EL',27.99,83),(85,'16-2','16+ELSR',27.99,83),(86,'16-5','16+SR',27.99,83),(87,'16-6','16+SREO',27.99,83),(88,'16F','16+CTA',27.99,83),(89,'16M','16+PLTA',27.99,83),(90,'16P','16+PTA+PRA',27.99,83),(91,'16W','16+PTA{NO PRA}',27.99,83),(92,'16Y','16Y',28.09,NULL),(93,'16Y-1','16Y+EL',28.09,92),(94,'16Y-2','16Y+ELSR',28.09,92),(95,'16Y-5','16Y+SR',28.09,92),(96,'17','17',28.56,NULL),(97,'17-1','17+EL',28.56,96),(98,'17-2','17+ELSR',28.56,96),(99,'17-5','17+SR',28.56,96),(100,'17-6','17+SREO',28.56,96),(101,'18','18',29.13,NULL),(102,'18-1','18+EL',29.13,101),(103,'18-2','18+ELSR',29.13,101),(104,'18-5','18+SR',29.13,101),(105,'18-6','18+SREO',29.13,101),(106,'18-7','18+SR80',29.13,101),(107,'18F','18+CTA',29.13,101),(108,'18M','18+PLTA',29.13,101),(109,'18M-7','18+PLTA+SR80',29.13,101),(110,'18P','18+PTA+PRA',29.13,101),(111,'18W','18+PTA{NO PRA}',29.13,101),(112,'18Y','18Y',29.22,NULL),(113,'18Y-1','18Y+EL',29.22,112),(114,'18Y-2','18Y+ELSR',29.22,112),(115,'18Y-5','18Y+SR',29.22,112),(116,'18Y-6','18Y+SREO',29.22,112),(117,'19','19',29.72,NULL),(118,'19-1','19+EL',29.72,117),(119,'19-2','19+ELSR',29.72,117),(120,'19-5','19+SR',29.72,117),(121,'19-6','19+SREO',29.72,117),(122,'19F','19+CTA',29.72,117),(123,'19P','19+PTA+PRA',29.72,117),(124,'19W','19+PTA{NO PRA}',29.72,117),(125,'19Y','19Y',29.82,NULL),(126,'19Y-2','19Y+ELSR',29.82,125),(127,'20','20',30.31,NULL),(128,'20-1','20+EL',30.31,127),(129,'20-2','20+ELSR',30.31,127),(130,'20-5','20+SR',30.31,127),(131,'20-6','20+SREO',30.31,127),(132,'20-7','20+SR80',30.31,127),(133,'20F','20+CTA',30.31,127),(134,'20M','20+PLTA',30.31,127),(135,'20M-7','20+PLTA+SR80',30.31,127),(136,'20P','20+PTA+PRA',30.31,127),(137,'20P-7','20+PTA+PRA+SR80',30.31,127),(138,'20W','20+PTA{NO PRA}',30.31,127),(139,'20Y','20Y',30.41,NULL),(140,'20Y-1','20Y+EL',30.41,139),(141,'20Y-2','20Y+ELSR',30.41,139),(142,'20Y-5','20Y+SR',30.41,139),(143,'21','21',30.92,NULL),(144,'21-1','21+EL',30.92,143),(145,'21-2','21+ELSR',30.92,143),(146,'21-5','21+SR',30.92,143),(147,'21-6','21+SREO',30.92,143),(148,'21-7','21+SR80',30.92,143),(149,'21F','21+CTA',30.92,143),(150,'21F-7','21+CTA+SR80',30.92,143),(151,'21P','21+PTA+PRA',30.92,143),(152,'21P-7','21+PTA+PRA+SR80',30.92,143),(153,'21W','21+PTA{NO PRA}',30.92,143),(154,'21Y','21Y',31.02,NULL),(155,'21Y-1','21Y+EL',31.02,154),(156,'21Y-2','21Y+ELSR',31.02,154),(157,'21Y-5','21Y+SR',31.02,154),(158,'22','22',31.53,NULL),(159,'22-1','22+EL',31.53,158),(160,'22-2','22+ELSR',31.53,158),(161,'22-5','22+SR',31.53,158),(162,'22-6','22+SREO',31.53,158),(163,'22-7','22+SR80',31.53,158),(164,'22Y','22Y',31.63,NULL),(165,'22Y-1','22Y+EL',31.63,164),(166,'22Y-2','22Y+ELSR',31.63,164),(167,'22Y-5','22Y+SR',31.63,164),(168,'22Y-6','22Y+SREO',31.63,164),(169,'23','23',32.16,NULL),(170,'23-1','23+EL',32.16,169),(171,'23-2','23+ELSR',32.16,169),(172,'23-5','23+SR',32.16,169),(173,'23-6','23+SREO',32.16,169),(174,'23-7','23+SR80',32.16,169),(175,'23F','23+CTA',32.16,169),(176,'23F-7','23+CTA+SR80',32.16,169),(177,'24','24',32.80,NULL),(178,'24-1','24+EL',32.80,177),(179,'24-2','24+ELSR',32.80,177),(180,'24-5','24+SR',32.80,177),(181,'24-6','24+SREO',32.80,177),(182,'24-7','24+SR80',32.80,177),(183,'24Y','24Y',32.92,NULL),(184,'24Y-1','24Y+EL',32.92,183),(185,'24Y-2','24Y+ELSR',32.92,183),(186,'24Y-5','24Y+SR',32.92,183),(187,'25','25',33.46,NULL),(188,'25-1','25+EL',33.46,187),(189,'25-2','25+ELSR',33.46,187),(190,'25-5','25+SR',33.46,187),(191,'25-6','25+SREO',33.46,187),(192,'25-7','25+SR80',33.46,187),(193,'25-E1','25+E1',33.46,187),(194,'26','26',34.13,NULL),(195,'26-1','26+EL',34.13,194),(196,'26-2','26+ELSR',34.13,194),(197,'26-5','26+SR',34.13,194),(198,'26-6','26+SREO',34.13,194),(199,'26-7','26+SR80',34.13,194),(200,'26F','26+CTA',34.13,194),(201,'26F-7','26+CTA+SR80',34.13,194),(202,'26P','26+PTA+PRA',34.13,194),(203,'26P-7','26+PTA+PRA+SR80',34.13,194),(204,'26W','26+PTA{NO PRA}',34.13,194),(205,'26Y','26Y',34.24,NULL),(206,'26Y-1','26Y+EL',34.24,205),(207,'26Y-2','26Y+ELSR',34.24,205),(208,'26Y-5','26Y+SR',34.24,205),(209,'27','27',34.81,NULL),(210,'27-1','27+EL',34.81,209),(211,'27-2','27+ELSR',34.81,209),(212,'27-5','27+SR',34.81,209),(213,'27-6','27+SREO',34.81,209),(214,'27-7','27+SR80',34.81,209),(215,'27Y','27Y',34.93,NULL),(216,'27Y-1','27Y+EL',34.93,215),(217,'27Y-2','27Y+ELSR',34.93,215),(218,'27Y-5','27Y+SR',34.93,215),(219,'28','28',35.51,NULL),(220,'28-1','28+EL',35.51,219),(221,'28-2','28+ELSR',35.51,219),(222,'28-5','28+SR',35.51,219),(223,'28-6','28+SREO',35.51,219),(224,'28-7','28+SR80',35.51,219),(225,'28F','28+CTA',35.51,219),(226,'28P','28+PTA+PRA',35.51,219),(227,'28P-7','28+PTA+PRA+SR80',35.51,219),(228,'28Y','28Y',35.63,NULL),(229,'28Y-5','28Y+SR',35.63,228),(230,'29','29',36.22,NULL),(231,'29-1','29+EL',36.22,230),(232,'29-2','29+ELSR',36.22,230),(233,'29-5','29+SR',36.22,230),(234,'29-6','29+SREO',36.22,230),(235,'29-7','29+SR80',36.22,230),(236,'29-E1','29+E1',36.22,230),(237,'29Y','29Y',36.34,NULL),(238,'29Y-1','29Y+EL',36.34,237),(239,'29Y-2','29Y+ELSR',36.34,237),(240,'29Y-5','29Y+SR',36.34,237),(241,'30','30',36.95,NULL),(242,'30-1','30+EL',36.95,241),(243,'30-2','30+ELSR',36.95,241),(244,'30-5','30+SR',36.95,241),(245,'30-6','30+SREO',36.95,241),(246,'30-7','30+SR80',36.95,241),(247,'30Y','30Y',37.08,NULL),(248,'30Y-1','30Y+EL',37.08,247),(249,'30Y-2','30Y+ELSR',37.08,247),(250,'30Y-5','30Y+SR',37.08,247),(251,'31','31',37.68,NULL),(252,'31-1','31+EL',37.68,251),(253,'31-2','31+ELSR',37.68,251),(254,'31-5','31+SR',37.68,251),(255,'31-6','31+SREO',37.68,251),(256,'31-7','31+SR80',37.68,251),(257,'32','32',38.44,NULL),(258,'32-1','32+EL',38.44,257),(259,'32-2','32+ELSR',38.44,257),(260,'32-5','32+SR',38.44,257),(261,'32-6','32+SREO',38.44,257),(262,'32-7','32+SR80',38.44,257),(263,'32F-7','32+CTA+SR80',38.44,257),(264,'32P-7','32+PTA+PRA+SR80',38.44,257),(265,'32Y','32Y',38.57,NULL),(266,'32Y-1','32Y+EL',38.57,265),(267,'32Y-2','32Y+ELSR',38.57,265),(268,'32Y-5','32Y+SR',38.57,265),(269,'33','33',39.21,NULL),(270,'33-1','33+EL',39.21,269),(271,'33-2','33+ELSR',39.21,269),(272,'33-5','33+SR',39.21,269),(273,'33-6','33+SREO',39.21,269),(274,'33-7','33+SR80',39.21,269),(275,'33Y','33Y',39.34,NULL),(276,'33Y-2','33Y+ELSR',39.34,275),(277,'34','34',39.99,NULL),(278,'34-1','34+EL',39.99,277),(279,'34-2','34+ELSR',39.99,277),(280,'34-5','34+SR',39.99,277),(281,'34-7','34+SR80',39.99,277),(282,'34Y','34Y',40.12,NULL),(283,'34Y-2','34Y+ELSR',40.12,282),(284,'35','35',40.79,NULL),(285,'35-1','35+EL',40.79,284),(286,'35-2','35+ELSR',40.79,284),(287,'35-5','35+SR',40.79,284),(288,'35-6','35+SREO',40.79,284),(289,'35-7','35+SR80',40.79,284),(290,'35Y','35Y',40.92,NULL),(291,'35Y-1','35Y+EL',40.92,290),(292,'35Y-2','35Y+ELSR',40.92,290),(293,'35Y-5','35Y+SR',40.92,290),(294,'36','36',41.60,NULL),(295,'36-1','36+EL',41.60,294),(296,'36-2','36+ELSR',41.60,294),(297,'36-5','36+SR',41.60,294),(298,'36-6','36+SREO',41.60,294),(299,'36-7','36+SR80',41.60,294),(300,'36Y','36Y',41.75,NULL),(301,'37','37',42.44,NULL),(302,'37-1','37+EL',42.44,301),(303,'37-2','37+ELSR',42.44,301),(304,'37-5','37+SR',42.44,301),(305,'37-7','37+SR80',42.44,301),(306,'37Y','37Y',42.58,NULL),(307,'37Y-2','37Y+ELSR',42.58,306),(308,'38','38',43.29,NULL),(309,'38-1','38+EL',43.29,308),(310,'38-2','38+ELSR',43.29,308),(311,'38-5','38+SR',43.29,308),(312,'38-6','38+SREO',43.29,308),(313,'38-7','38+SR80',43.29,308),(314,'39','39',44.15,NULL),(315,'39-1','39+EL',44.15,314),(316,'39-2','39+ELSR',44.15,314),(317,'39-5','39+SR',44.15,314),(318,'39-7','39+SR80',44.15,314),(319,'40','40',45.04,NULL),(320,'40-1','40+EL',45.04,319),(321,'40-2','40+ELSR',45.04,319),(322,'40-5','40+SR',45.04,319),(323,'40-6','40+SREO',45.04,319),(324,'40-7','40+SR80',45.04,319),(325,'41','41',45.93,NULL),(326,'41-1','41+EL',45.93,325),(327,'41-2','41+ELSR',45.93,325),(328,'41-5','41+SR',45.93,325),(329,'41-6','41+SREO',45.93,325),(330,'41-7','41+SR80',45.93,325),(331,'41Y','41Y',46.09,NULL),(332,'41Y-2','41Y+ELSR',46.09,331),(333,'42','42',46.85,NULL),(334,'42-1','42+EL',46.85,333),(335,'42-2','42+ELSR',46.85,333),(336,'42-5','42+SR',46.85,333),(337,'42-6','42+SREO',46.85,333),(338,'42-7','42+SR80',46.85,333),(339,'43','43',47.79,NULL),(340,'43-1','43+EL',47.79,339),(341,'43-2','43+ELSR',47.79,339),(342,'43-5','43+SR',47.79,339),(343,'43-6','43+SREO',47.79,339),(344,'43-7','43+SR80',47.79,339),(345,'43Y','43Y',47.95,NULL),(346,'43Y-2','43Y+ELSR',47.95,345),(347,'44','44',48.75,NULL),(348,'44-1','44+EL',48.75,347),(349,'44-2','44+ELSR',48.75,347),(350,'44-5','44+SR',48.75,347),(351,'44-7','44+SR80',48.75,347),(352,'44Y','44Y',48.91,NULL),(353,'44Y-1','44Y+EL',48.91,352),(354,'44Y-2','44Y+ELSR',48.91,352),(355,'44Y-5','44Y+SR',48.91,352),(356,'45','45',49.72,NULL),(357,'45-1','45+EL',49.72,356),(358,'45-2','45+ELSR',49.72,356),(359,'45-5','45+SR',49.72,356),(360,'45-6','45+SREO',49.72,356),(361,'45-7','45+SR80',49.72,356),(362,'46','46',50.72,NULL),(363,'46-1','46+EL',50.72,362),(364,'46-2','46+ELSR',50.72,362),(365,'46-5','46+SR',50.72,362),(366,'46-6','46+SREO',50.72,362),(367,'46-7','46+SR80',50.72,362),(368,'46-E1','46+E1',50.72,362),(369,'46-E2','46+E2',50.72,362),(370,'47','47',51.73,NULL),(371,'47-1','47+EL',51.73,370),(372,'47-2','47+ELSR',51.73,370),(373,'47-5','47+SR',51.73,370),(374,'47-7','47+SR80',51.73,370),(375,'47Y','47Y',51.91,NULL),(376,'48','48',52.76,NULL),(377,'48-1','48+EL',52.76,376),(378,'48-2','48+ELSR',52.76,376),(379,'48-5','48+SR',52.76,376),(380,'48-7','48+SR80',52.76,376),(381,'49','49',53.82,NULL),(382,'49-1','49+EL',53.82,381),(383,'49-2','49+ELSR',53.82,381),(384,'49Y-5','49+SR',53.82,381),(385,'49-7','49+SR80',53.82,381),(386,'49-E1','49+E1',53.82,381),(387,'49-E2','49+E2',53.82,381),(388,'49Y','49Y',54.01,NULL),(389,'49Y-1','49Y+EL',54.01,388),(390,'49Y-2','49Y+ELSR',54.01,388),(391,'50','50',54.90,NULL),(392,'50-1','50+EL',54.90,391),(393,'50-2','50+ELSR',54.90,391),(394,'50-5','50+SR',54.90,391),(395,'51','51',56.00,NULL),(396,'51-1','51+EL',56.00,395),(397,'51-2','51+ELSR',56.00,395),(398,'51-5','51+SR',56.00,395),(399,'51-7','51+SR80',56.00,395),(400,'52','52',57.11,NULL),(401,'52-1','52+EL',57.11,400),(402,'52-2','52+ELSR',57.11,400),(403,'52-5','52+SR',57.11,400),(404,'53','53',58.26,NULL),(405,'53-1','53+EL',58.26,404),(406,'53-2','53+ELSR',58.26,404),(407,'53-5','53+SR',58.26,404),(408,'53-E1','53+E1',58.26,404),(409,'53-E2','53+E2',58.26,404),(410,'54','54',59.42,NULL),(411,'54-2','54+ELSR',59.42,410),(412,'54-5','54+SR',59.42,410),(413,'55','55',60.62,NULL),(414,'55-2','55+ELSR',60.62,413),(415,'55-E2','55+E2',60.62,413),(416,'56','56',61.83,NULL),(417,'57','57',63.06,NULL),(418,'57-2','57+ELSR',63.06,417),(419,'57-E2','57+E2',63.06,417),(420,'58','58',64.32,NULL),(421,'58-8','58+SKR',64.32,420),(422,'59','59',65.62,NULL),(423,'60','60',66.92,NULL),(424,'23Y-2','23Y+ELSR',36.56,NULL),(425,'23Y-5','23Y+SR',35.60,NULL);

--
-- Table structure for table `permission_resources`
--

CREATE TABLE `permission_resources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `permission_resources`
--

INSERT INTO `permission_resources` VALUES (1,'traveltime_submissions',NULL),(2,'traveltime_payroll',NULL),(3,'commcare_stats',NULL),(4,'commcare_report',NULL),(5,'commcare_submissions',NULL),(6,'commcare_inkind_submissions',NULL),(7,'user_passwords',NULL);

--
-- Table structure for table `permission_roles`
--

CREATE TABLE `permission_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `permission_roles`
--

INSERT INTO `permission_roles` VALUES (1,'traveltime_manager',NULL),(2,'traveltime_superuser',NULL),(3,'commcare_recc',NULL),(4,'commcare_superuser',NULL),(5,'commcare_accounts',NULL),(6,'commcare_apprentice_managers',NULL),(7,'traveltime_payroll',NULL);

--
-- Table structure for table `permission_rules`
--

CREATE TABLE `permission_rules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `role_id` int(11) NOT NULL,
  `resource_id` int(11) NOT NULL,
  `allowed` bit(1) DEFAULT b'1',
  PRIMARY KEY (`id`),
  KEY `idx_name` (`name`),
  KEY `fk_role_id` (`role_id`),
  KEY `fk_permission_resource_id` (`resource_id`),
  CONSTRAINT `permission_rules_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `permission_roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `permission_rules_ibfk_2` FOREIGN KEY (`resource_id`) REFERENCES `permission_resources` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `permission_rules`
--

INSERT INTO `permission_rules` VALUES (1,'view_managed',1,1,''),(2,'edit_managed',1,1,''),(3,'view_managed',1,2,''),(4,'view_all',2,1,''),(5,'edit_all',2,1,''),(6,'view_all',2,2,''),(7,'view_all',3,3,''),(8,'view_all',3,4,''),(9,'view_location_managed',3,5,''),(10,'view_glaccount_managed',3,5,''),(11,'view_all',3,5,''),(12,'edit_managed',3,5,''),(13,'view_location_managed',3,6,''),(14,'view_glaccount_managed',3,6,''),(15,'view_all',3,6,''),(16,'edit_managed',3,6,''),(17,'view_all',4,3,''),(18,'view_all',4,4,''),(19,'view_location_all',4,5,''),(20,'view_glaccount_all',4,5,''),(21,'view_all',4,5,''),(22,'edit_all',4,5,''),(23,'view_location_all',4,6,''),(24,'view_glaccount_all',4,6,''),(25,'view_all',4,6,''),(26,'edit_all',4,6,''),(27,'view_all',5,3,''),(28,'view_all',5,4,''),(29,'view_all',5,5,''),(30,'view_location_all',5,5,''),(31,'view_glaccount_all',5,5,''),(32,'set_paid_all',5,5,''),(33,'view_location_all',5,6,''),(34,'view_glaccount_all',5,6,''),(35,'view_all',5,6,''),(36,'set_paid_all',5,6,''),(37,'view_all',6,3,''),(38,'view_all',6,4,''),(39,'view_all',6,5,''),(40,'view_location_all',6,6,''),(41,'edit_location_all',6,6,''),(42,'view_glaccount_all',6,6,''),(43,'edit_glaccount_all',6,6,''),(44,'view_all',6,6,''),(45,'edit_all',6,6,''),(46,'view_all',7,2,''),(47,'edit_all',2,7,''),(48,'edit_all',4,7,'');

--
-- Table structure for table `reccs`
--

CREATE TABLE `reccs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `acronym` varchar(16) NOT NULL,
  `ord` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `acronym` (`acronym`),
  UNIQUE KEY `ord` (`ord`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reccs`
--

INSERT INTO `reccs` VALUES (1,'Sydney','SYD',1),(2,'North','NTH',2),(3,'South','STH',3),(4,'West','WST',4),(5,'Central Coast','CCT',5),(6,'Lower Hunter','LHT',6),(7,'Upper Hunter','UHT',7);

--
-- Table structure for table `si_audit_types`
--

CREATE TABLE `si_audit_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_audit_types`
--

INSERT INTO `si_audit_types` VALUES (1,'Inspection'),(2,'Baseline'),(3,'Observation');

--
-- Table structure for table `si_contract_types`
--

CREATE TABLE `si_contract_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_contract_types`
--

INSERT INTO `si_contract_types` VALUES (1,'Vegetation Management'),(2,'Contract Cable Lying'),(3,'Servicing Street Lighting Luminaires'),(4,'Reinforcement of Poles'),(5,'Contract Cable Laying');

--
-- Table structure for table `si_contractors`
--

CREATE TABLE `si_contractors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_contractors`
--

INSERT INTO `si_contractors` VALUES (1,'Active Tree Services'),(2,'peter haskins'),(3,'Bastow'),(4,'andrew pepping'),(5,'Conneq'),(6,'frank jones'),(7,'Subakette'),(8,'david anderson'),(9,'Utility Asset Management'),(10,'peter saunders'),(11,'mark zuckerberg'),(12,'Ausgrid Contractor Safety'),(13,'');

--
-- Table structure for table `si_employees`
--

CREATE TABLE `si_employees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email_addr` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_employees`
--

INSERT INTO `si_employees` VALUES (1,'Bob Keegan','bkeegan@energy.com.au'),(2,'tim bradley',''),(3,'Chris Cridland','ccridland@energy.com.au'),(4,'Geoff Fletcher','gfletcher@energy.com.au'),(5,'matt clarke',''),(6,'Allan Ghadban','AGhadban@energy.com.au'),(7,'Roger Harris','rharris@energy.com.au'),(8,'stan brown',''),(9,'Peter Edwards','pedwards@energy.com.au'),(10,'john peters',''),(11,'Benjamin Barker','BBarker@energy.com.au'),(12,'Frank Malkoun','FrankMalkoun@energy.com.au'),(13,'peter walsh',''),(14,'Dane Dawson','ddawson@energy.com.au'),(15,'Ian Rembridge','irembridge@energy.com.au'),(16,'tom hanson',''),(17,'Marc Deltoer','mdeltoer@energy.com.au'),(18,'Joe Bloggs',''),(19,'Steve Burke','SBurke@ausgrid.com.au'),(20,'Bill',''),(21,'Steven Burke','SBurke@energy.com.au');

--
-- Table structure for table `si_inspection_personnel`
--

CREATE TABLE `si_inspection_personnel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `inspection_id` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `num` int(11) DEFAULT NULL,
  `position_id` int(11) NOT NULL,
  `training_comments` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_inspection_personnel`
--


--
-- Table structure for table `si_inspection_personnel_trainings`
--

CREATE TABLE `si_inspection_personnel_trainings` (
  `personnel_id` int(11) NOT NULL,
  `training_id` int(11) NOT NULL,
  `has` bit(1) DEFAULT NULL,
  PRIMARY KEY (`personnel_id`,`training_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_inspection_personnel_trainings`
--


--
-- Table structure for table `si_inspection_queries`
--

CREATE TABLE `si_inspection_queries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `display_id` varchar(16) DEFAULT NULL,
  `inspection_id` int(11) NOT NULL,
  `query_id` int(11) NOT NULL,
  `value` tinyint(4) DEFAULT NULL,
  `action_required` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1102 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_inspection_queries`
--

INSERT INTO `si_inspection_queries` VALUES (1,'1.1',1,98,0,'\0'),(2,'1.2',1,83,0,'\0'),(3,'1.3',1,1,0,'\0'),(4,'1.4',1,2,0,'\0'),(5,'1.5',1,10,0,'\0'),(6,'2.1',1,112,0,'\0'),(7,'2.2',1,47,0,'\0'),(8,'2.3',1,57,0,'\0'),(9,'2.4',1,56,0,'\0'),(10,'2.5',1,33,0,'\0'),(11,'2.6',1,44,0,'\0'),(12,'2.7',1,46,0,'\0'),(13,'2.8',1,27,0,'\0'),(14,'2.9',1,22,0,'\0'),(15,'2.10',1,26,0,'\0'),(16,'2.11',1,25,0,'\0'),(17,'2.12',1,113,0,'\0'),(18,'2.13',1,114,0,'\0'),(19,'2.14',1,24,0,'\0'),(20,'2.15',1,45,0,'\0'),(21,'2.16',1,53,0,'\0'),(22,'2.17',1,40,0,'\0'),(23,'3.1',1,60,0,'\0'),(24,'3.2',1,58,0,'\0'),(25,'3.3',1,64,0,'\0'),(26,'3.4',1,68,0,'\0'),(27,'3.5',1,66,0,'\0'),(28,'4.1',1,74,0,'\0'),(29,'4.2',1,115,0,'\0'),(30,'4.3',1,77,0,'\0'),(31,'4.4',1,111,0,'\0'),(32,'4.5',1,92,0,'\0'),(33,'4.6',1,102,0,'\0'),(34,'4.7',1,103,0,'\0'),(35,'4.8',1,76,0,'\0'),(36,'4.9',1,78,0,'\0'),(37,'4.10',1,84,0,'\0'),(38,'4.11',1,94,0,'\0'),(39,'4.12',1,71,0,'\0'),(40,'4.13',1,101,0,'\0'),(41,'4.14',1,91,0,'\0'),(42,'4.15',1,107,0,'\0'),(43,'4.16',1,79,0,'\0'),(44,'4.17',1,75,0,'\0'),(45,'5.1',1,41,0,'\0'),(46,'5.2',1,39,0,'\0'),(47,'5.3',1,72,0,'\0'),(48,'5.4',1,100,0,'\0'),(49,'5.5',1,37,0,'\0'),(50,'6.1',1,49,0,'\0'),(51,'6.2',1,29,0,'\0'),(52,'6.3',1,43,0,'\0'),(53,'6.4',1,50,0,'\0'),(54,'6.5',1,51,0,'\0'),(55,'7.1',1,99,0,'\0'),(56,'7.2',1,54,0,'\0'),(57,'7.3',1,23,0,'\0'),(58,'7.4',1,52,1,'\0'),(59,'7.5',1,7,0,'\0'),(60,'7.6',1,82,0,'\0'),(61,'7.7',1,3,0,'\0'),(62,'7.8',1,28,0,'\0'),(63,'7.9',1,30,0,'\0'),(64,'7.10',1,73,0,'\0'),(65,'7.11',1,70,0,'\0'),(66,'7.12',1,34,0,'\0'),(67,'7.13',1,11,0,'\0'),(68,'7.14',1,95,0,'\0'),(69,'7.15',1,105,0,'\0'),(70,'7.16',1,9,0,'\0'),(71,'7.17',1,13,0,'\0'),(72,'7.18',1,110,0,'\0'),(73,'7.19',1,106,0,'\0'),(74,'8.1',1,80,0,'\0'),(75,'8.2',1,116,1,'\0'),(76,'8.3',1,89,NULL,'\0'),(77,'8.4',1,20,NULL,'\0'),(78,'8.5',1,5,NULL,'\0'),(79,'8.6',1,4,NULL,'\0'),(80,'8.7',1,19,0,'\0'),(81,'8.8',1,85,0,'\0'),(82,'8.9',1,108,0,'\0'),(83,'8.10',1,12,0,'\0'),(84,'8.11',1,35,0,'\0'),(85,'8.12',1,36,0,'\0'),(86,'8.13',1,17,0,'\0'),(87,'8.14',1,18,0,'\0'),(88,'8.15',1,88,0,'\0'),(89,'8.16',1,87,0,'\0'),(90,'8.17',1,16,0,'\0'),(91,'8.18',1,15,0,'\0'),(92,'8.19',1,8,0,'\0'),(93,'8.20',1,48,0,'\0'),(94,'8.21',1,38,0,'\0'),(95,'8.22',1,6,0,'\0'),(96,'1.1',2,98,1,'\0'),(97,'1.2',2,83,0,'\0'),(98,'1.3',2,1,0,'\0'),(99,'1.4',2,2,0,'\0'),(100,'1.5',2,10,0,'\0'),(101,'2.1',2,112,0,'\0'),(102,'2.2',2,47,0,'\0'),(103,'2.3',2,57,0,'\0'),(104,'2.4',2,56,0,'\0'),(105,'2.5',2,33,0,'\0'),(106,'2.6',2,44,0,'\0'),(107,'2.7',2,46,0,'\0'),(108,'2.8',2,27,0,'\0'),(109,'2.9',2,22,0,'\0'),(110,'2.10',2,26,0,'\0'),(111,'2.11',2,113,0,'\0'),(112,'2.12',2,25,0,'\0'),(113,'2.13',2,117,0,'\0'),(114,'2.14',2,45,0,'\0'),(115,'2.15',2,53,0,'\0'),(116,'2.16',2,40,0,'\0'),(117,'3.1',2,60,0,'\0'),(118,'3.2',2,69,0,'\0'),(119,'3.3',2,63,0,'\0'),(120,'3.4',2,62,0,'\0'),(121,'3.5',2,65,0,'\0'),(122,'3.6',2,67,0,'\0'),(123,'4.1',2,74,1,'\0'),(124,'4.2',2,77,0,'\0'),(125,'4.3',2,111,1,'\0'),(126,'4.4',2,92,0,'\0'),(127,'4.5',2,102,0,'\0'),(128,'4.6',2,103,0,'\0'),(129,'4.7',2,76,0,'\0'),(130,'4.8',2,78,0,'\0'),(131,'4.9',2,84,1,'\0'),(132,'4.10',2,94,0,'\0'),(133,'4.11',2,71,0,'\0'),(134,'4.12',2,101,0,'\0'),(135,'4.13',2,91,0,'\0'),(136,'4.14',2,107,0,'\0'),(137,'4.15',2,118,0,'\0'),(138,'4.16',2,119,0,'\0'),(139,'5.1',2,41,1,'\0'),(140,'5.2',2,39,0,'\0'),(141,'5.3',2,72,0,'\0'),(142,'5.4',2,100,1,'\0'),(143,'5.5',2,55,1,'\0'),(144,'5.6',2,21,1,'\0'),(145,'5.7',2,42,0,'\0'),(146,'5.8',2,37,0,'\0'),(147,'6.1',2,49,0,'\0'),(148,'6.2',2,29,0,'\0'),(149,'6.3',2,43,0,'\0'),(150,'6.4',2,50,0,'\0'),(151,'6.5',2,51,0,'\0'),(152,'7.1',2,120,0,'\0'),(153,'7.2',2,54,0,'\0'),(154,'7.3',2,23,0,'\0'),(155,'7.4',2,52,0,'\0'),(156,'7.5',2,7,0,'\0'),(157,'7.6',2,82,0,'\0'),(158,'7.7',2,3,0,'\0'),(159,'7.8',2,28,0,'\0'),(160,'7.9',2,30,0,'\0'),(161,'7.10',2,73,0,'\0'),(162,'7.11',2,70,0,'\0'),(163,'7.12',2,34,0,'\0'),(164,'7.13',2,14,0,'\0'),(165,'7.14',2,11,0,'\0'),(166,'7.15',2,95,0,'\0'),(167,'7.16',2,109,0,'\0'),(168,'7.17',2,104,0,'\0'),(169,'7.18',2,90,0,'\0'),(170,'7.19',2,121,0,'\0'),(171,'7.20',2,122,0,'\0'),(172,'7.21',2,86,0,'\0'),(173,'7.22',2,106,0,'\0'),(174,'1.1',3,98,NULL,'\0'),(175,'1.2',3,83,NULL,'\0'),(176,'1.3',3,1,NULL,'\0'),(177,'1.4',3,2,1,'\0'),(178,'1.5',3,10,0,'\0'),(179,'2.1',3,112,0,'\0'),(180,'2.2',3,47,0,'\0'),(181,'2.3',3,57,0,'\0'),(182,'2.4',3,56,0,'\0'),(183,'2.5',3,33,0,'\0'),(184,'2.6',3,44,0,'\0'),(185,'2.7',3,46,0,'\0'),(186,'2.8',3,27,0,'\0'),(187,'2.9',3,22,0,'\0'),(188,'2.10',3,26,0,'\0'),(189,'2.11',3,25,0,'\0'),(190,'2.12',3,31,0,'\0'),(191,'2.13',3,24,0,'\0'),(192,'2.14',3,45,0,'\0'),(193,'2.15',3,53,0,'\0'),(194,'2.16',3,40,0,'\0'),(195,'3.1',3,60,0,'\0'),(196,'3.2',3,69,1,'\0'),(197,'4.1',3,74,0,'\0'),(198,'4.2',3,115,0,'\0'),(199,'4.3',3,77,0,'\0'),(200,'4.4',3,111,0,'\0'),(201,'4.5',3,92,0,'\0'),(202,'4.6',3,102,0,'\0'),(203,'4.7',3,103,0,'\0'),(204,'4.8',3,76,0,'\0'),(205,'4.9',3,78,0,'\0'),(206,'4.10',3,84,0,'\0'),(207,'4.11',3,94,0,'\0'),(208,'4.12',3,71,0,'\0'),(209,'4.13',3,101,0,'\0'),(210,'4.14',3,91,0,'\0'),(211,'4.15',3,107,0,'\0'),(212,'4.16',3,79,0,'\0'),(213,'4.17',3,75,0,'\0'),(214,'5.1',3,41,0,'\0'),(215,'5.2',3,39,0,'\0'),(216,'5.3',3,72,0,'\0'),(217,'5.4',3,100,0,'\0'),(218,'5.5',3,37,0,'\0'),(219,'6.1',3,49,0,'\0'),(220,'6.2',3,29,0,'\0'),(221,'6.3',3,43,0,'\0'),(222,'6.4',3,50,0,'\0'),(223,'6.5',3,51,0,'\0'),(224,'7.1',3,99,0,'\0'),(225,'7.2',3,54,0,'\0'),(226,'7.3',3,23,0,'\0'),(227,'7.4',3,52,0,'\0'),(228,'7.5',3,7,0,'\0'),(229,'7.6',3,82,0,'\0'),(230,'7.7',3,3,0,'\0'),(231,'7.8',3,28,0,'\0'),(232,'7.9',3,30,0,'\0'),(233,'7.10',3,73,0,'\0'),(234,'7.11',3,70,0,'\0'),(235,'7.12',3,34,0,'\0'),(236,'7.13',3,11,0,'\0'),(237,'7.14',3,95,0,'\0'),(238,'7.15',3,105,0,'\0'),(239,'7.16',3,106,0,'\0'),(240,'8.1',3,80,1,'\0'),(241,'8.2',3,116,NULL,'\0'),(242,'8.3',3,89,NULL,'\0'),(243,'8.4',3,20,0,'\0'),(244,'8.5',3,5,1,'\0'),(245,'8.6',3,4,0,'\0'),(246,'8.7',3,19,0,'\0'),(247,'8.8',3,85,0,'\0'),(248,'8.9',3,108,0,'\0'),(249,'8.10',3,12,0,'\0'),(250,'8.11',3,35,0,'\0'),(251,'8.12',3,36,0,'\0'),(252,'8.13',3,17,0,'\0'),(253,'8.14',3,18,0,'\0'),(254,'8.15',3,88,0,'\0'),(255,'8.16',3,87,0,'\0'),(256,'8.17',3,16,0,'\0'),(257,'8.18',3,15,0,'\0'),(258,'8.19',3,8,0,'\0'),(259,'8.20',3,48,0,'\0'),(260,'8.21',3,38,0,'\0'),(261,'8.22',3,6,1,'\0'),(262,'1.1',4,98,0,'\0'),(263,'1.2',4,83,0,'\0'),(264,'1.3',4,1,0,'\0'),(265,'1.4',4,2,0,'\0'),(266,'1.5',4,10,0,'\0'),(267,'2.1',4,112,1,'\0'),(268,'2.2',4,47,0,'\0'),(269,'2.3',4,57,1,'\0'),(270,'2.4',4,56,1,'\0'),(271,'2.5',4,33,1,'\0'),(272,'2.6',4,44,1,'\0'),(273,'2.7',4,46,0,'\0'),(274,'2.8',4,27,1,'\0'),(275,'2.9',4,22,0,'\0'),(276,'2.10',4,26,1,'\0'),(277,'2.11',4,113,0,'\0'),(278,'2.12',4,25,1,'\0'),(279,'2.13',4,117,0,'\0'),(280,'2.14',4,45,0,'\0'),(281,'2.15',4,53,0,'\0'),(282,'2.16',4,40,0,'\0'),(283,'3.1',4,60,1,'\0'),(284,'3.2',4,69,1,'\0'),(285,'3.3',4,63,1,'\0'),(286,'3.4',4,62,0,'\0'),(287,'3.5',4,65,0,'\0'),(288,'3.6',4,67,1,'\0'),(289,'4.1',4,74,1,'\0'),(290,'4.2',4,77,0,'\0'),(291,'4.3',4,111,0,'\0'),(292,'4.4',4,92,0,'\0'),(293,'4.5',4,102,0,'\0'),(294,'4.6',4,103,0,'\0'),(295,'4.7',4,76,0,'\0'),(296,'4.8',4,78,0,'\0'),(297,'4.9',4,84,0,'\0'),(298,'4.10',4,94,0,'\0'),(299,'4.11',4,71,0,'\0'),(300,'4.12',4,101,0,'\0'),(301,'4.13',4,91,0,'\0'),(302,'4.14',4,107,0,'\0'),(303,'4.15',4,118,0,'\0'),(304,'4.16',4,119,0,'\0'),(305,'5.1',4,41,0,'\0'),(306,'5.2',4,39,0,'\0'),(307,'5.3',4,72,0,'\0'),(308,'5.4',4,100,0,'\0'),(309,'5.5',4,55,0,'\0'),(310,'5.6',4,21,0,'\0'),(311,'5.7',4,42,0,'\0'),(312,'5.8',4,37,0,'\0'),(313,'6.1',4,49,0,'\0'),(314,'6.2',4,29,0,'\0'),(315,'6.3',4,43,0,'\0'),(316,'6.4',4,50,0,'\0'),(317,'6.5',4,51,0,'\0'),(318,'7.1',4,120,0,'\0'),(319,'7.2',4,54,0,'\0'),(320,'7.3',4,23,0,'\0'),(321,'7.4',4,52,0,'\0'),(322,'7.5',4,7,0,'\0'),(323,'7.6',4,82,0,'\0'),(324,'7.7',4,3,0,'\0'),(325,'7.8',4,28,0,'\0'),(326,'7.9',4,30,0,'\0'),(327,'7.10',4,73,0,'\0'),(328,'7.11',4,70,0,'\0'),(329,'7.12',4,34,0,'\0'),(330,'7.13',4,14,0,'\0'),(331,'7.14',4,11,0,'\0'),(332,'7.15',4,95,0,'\0'),(333,'7.16',4,109,0,'\0'),(334,'7.17',4,104,0,'\0'),(335,'7.18',4,90,0,'\0'),(336,'7.19',4,121,0,'\0'),(337,'7.20',4,122,0,'\0'),(338,'7.21',4,86,0,'\0'),(339,'7.22',4,106,0,'\0'),(340,'1.1',5,98,0,'\0'),(341,'1.2',5,83,0,'\0'),(342,'1.3',5,1,0,'\0'),(343,'1.4',5,2,0,'\0'),(344,'1.5',5,10,0,'\0'),(345,'2.1',5,112,0,'\0'),(346,'2.2',5,47,0,'\0'),(347,'2.3',5,57,0,'\0'),(348,'2.4',5,56,0,'\0'),(349,'2.5',5,33,0,'\0'),(350,'2.6',5,44,0,'\0'),(351,'2.7',5,46,0,'\0'),(352,'2.8',5,27,0,'\0'),(353,'2.9',5,22,0,'\0'),(354,'2.10',5,26,0,'\0'),(355,'2.11',5,25,0,'\0'),(356,'2.12',5,53,0,'\0'),(357,'2.13',5,40,0,'\0'),(358,'3.1',5,60,0,'\0'),(359,'3.2',5,69,0,'\0'),(360,'3.3',5,67,0,'\0'),(361,'4.1',5,74,0,'\0'),(362,'4.2',5,123,0,'\0'),(363,'4.3',5,77,0,'\0'),(364,'4.4',5,111,0,'\0'),(365,'4.5',5,124,0,'\0'),(366,'4.6',5,92,0,'\0'),(367,'4.7',5,102,0,'\0'),(368,'4.8',5,103,0,'\0'),(369,'4.9',5,76,0,'\0'),(370,'4.10',5,78,0,'\0'),(371,'4.11',5,84,0,'\0'),(372,'4.12',5,94,0,'\0'),(373,'4.13',5,71,0,'\0'),(374,'4.14',5,101,0,'\0'),(375,'4.15',5,91,0,'\0'),(376,'4.16',5,107,0,'\0'),(377,'4.17',5,75,0,'\0'),(378,'5.1',5,41,1,'\0'),(379,'5.2',5,39,1,'\0'),(380,'5.3',5,72,NULL,'\0'),(381,'5.4',5,100,NULL,'\0'),(382,'5.5',5,37,NULL,'\0'),(383,'6.1',5,49,0,'\0'),(384,'6.2',5,29,0,'\0'),(385,'6.3',5,43,0,'\0'),(386,'6.4',5,50,0,'\0'),(387,'6.5',5,51,0,'\0'),(388,'7.1',5,99,0,'\0'),(389,'7.2',5,54,0,'\0'),(390,'7.3',5,23,0,'\0'),(391,'7.4',5,52,0,'\0'),(392,'7.5',5,7,0,'\0'),(393,'7.6',5,82,0,'\0'),(394,'7.7',5,3,0,'\0'),(395,'7.8',5,28,0,'\0'),(396,'7.9',5,30,0,'\0'),(397,'7.10',5,73,0,'\0'),(398,'7.11',5,70,0,'\0'),(399,'7.12',5,34,0,'\0'),(400,'7.13',5,11,0,'\0'),(401,'7.14',5,95,0,'\0'),(402,'7.15',5,105,0,'\0'),(403,'7.16',5,109,0,'\0'),(404,'7.17',5,32,0,'\0'),(405,'7.18',5,97,0,'\0'),(406,'7.19',5,96,0,'\0'),(407,'7.20',5,14,0,'\0'),(408,'7.21',5,106,0,'\0'),(409,'1.1',6,98,1,'\0'),(410,'1.2',6,83,1,'\0'),(411,'1.3',6,1,0,'\0'),(412,'1.4',6,2,1,'\0'),(413,'1.5',6,10,1,'\0'),(414,'2.1',6,112,0,'\0'),(415,'2.2',6,47,0,'\0'),(416,'2.3',6,57,0,'\0'),(417,'2.4',6,56,0,'\0'),(418,'2.5',6,33,0,'\0'),(419,'2.6',6,44,0,'\0'),(420,'2.7',6,46,0,'\0'),(421,'2.8',6,27,0,'\0'),(422,'2.9',6,22,0,'\0'),(423,'2.10',6,26,0,'\0'),(424,'2.11',6,25,0,'\0'),(425,'2.12',6,53,0,'\0'),(426,'2.13',6,40,0,'\0'),(427,'3.1',6,60,0,'\0'),(428,'3.2',6,69,0,'\0'),(429,'3.3',6,67,0,'\0'),(430,'4.1',6,74,1,'\0'),(431,'4.2',6,123,1,'\0'),(432,'4.3',6,77,0,'\0'),(433,'4.4',6,111,1,'\0'),(434,'4.5',6,124,0,'\0'),(435,'4.6',6,92,1,'\0'),(436,'4.7',6,102,0,'\0'),(437,'4.8',6,103,1,'\0'),(438,'4.9',6,76,1,'\0'),(439,'4.10',6,78,0,'\0'),(440,'4.11',6,84,1,'\0'),(441,'4.12',6,94,1,'\0'),(442,'4.13',6,71,1,'\0'),(443,'4.14',6,101,0,'\0'),(444,'4.15',6,91,0,'\0'),(445,'4.16',6,107,0,'\0'),(446,'4.17',6,75,0,'\0'),(447,'5.1',6,41,0,'\0'),(448,'5.2',6,39,0,'\0'),(449,'5.3',6,72,0,'\0'),(450,'5.4',6,100,0,'\0'),(451,'5.5',6,37,0,'\0'),(452,'6.1',6,49,1,'\0'),(453,'6.2',6,29,1,'\0'),(454,'6.3',6,43,1,'\0'),(455,'6.4',6,50,1,'\0'),(456,'6.5',6,51,1,'\0'),(457,'7.1',6,99,1,'\0'),(458,'7.2',6,54,1,'\0'),(459,'7.3',6,23,1,'\0'),(460,'7.4',6,52,1,'\0'),(461,'7.5',6,7,1,'\0'),(462,'7.6',6,82,1,'\0'),(463,'7.7',6,3,1,'\0'),(464,'7.8',6,28,0,'\0'),(465,'7.9',6,30,0,'\0'),(466,'7.10',6,73,0,'\0'),(467,'7.11',6,70,0,'\0'),(468,'7.12',6,34,0,'\0'),(469,'7.13',6,11,0,'\0'),(470,'7.14',6,95,0,'\0'),(471,'7.15',6,105,0,'\0'),(472,'7.16',6,109,0,'\0'),(473,'7.17',6,32,0,'\0'),(474,'7.18',6,97,0,'\0'),(475,'7.19',6,96,0,'\0'),(476,'7.20',6,14,0,'\0'),(477,'7.21',6,106,0,'\0'),(478,'1.1',7,98,1,'\0'),(479,'1.2',7,83,0,'\0'),(480,'1.3',7,1,1,'\0'),(481,'1.4',7,2,0,'\0'),(482,'1.5',7,10,0,'\0'),(483,'2.1',7,112,1,'\0'),(484,'2.2',7,47,0,'\0'),(485,'2.3',7,57,0,'\0'),(486,'2.4',7,56,0,'\0'),(487,'2.5',7,33,0,'\0'),(488,'2.6',7,44,0,'\0'),(489,'2.7',7,46,0,'\0'),(490,'2.8',7,27,0,'\0'),(491,'2.9',7,22,0,'\0'),(492,'2.10',7,26,0,'\0'),(493,'2.11',7,113,0,'\0'),(494,'2.12',7,25,0,'\0'),(495,'2.13',7,117,0,'\0'),(496,'2.14',7,45,0,'\0'),(497,'2.15',7,53,0,'\0'),(498,'2.16',7,40,0,'\0'),(499,'3.1',7,60,0,'\0'),(500,'3.2',7,69,0,'\0'),(501,'3.3',7,63,0,'\0'),(502,'3.4',7,62,0,'\0'),(503,'3.5',7,65,0,'\0'),(504,'3.6',7,67,0,'\0'),(505,'4.1',7,74,1,'\0'),(506,'4.2',7,77,0,'\0'),(507,'4.3',7,111,0,'\0'),(508,'4.4',7,92,0,'\0'),(509,'4.5',7,102,0,'\0'),(510,'4.6',7,103,0,'\0'),(511,'4.7',7,76,0,'\0'),(512,'4.8',7,78,0,'\0'),(513,'4.9',7,84,0,'\0'),(514,'4.10',7,94,0,'\0'),(515,'4.11',7,71,0,'\0'),(516,'4.12',7,101,0,'\0'),(517,'4.13',7,91,0,'\0'),(518,'4.14',7,107,0,'\0'),(519,'4.15',7,118,0,'\0'),(520,'4.16',7,119,0,'\0'),(521,'5.1',7,41,0,'\0'),(522,'5.2',7,39,0,'\0'),(523,'5.3',7,72,0,'\0'),(524,'5.4',7,100,0,'\0'),(525,'5.5',7,55,0,'\0'),(526,'5.6',7,21,0,'\0'),(527,'5.7',7,42,0,'\0'),(528,'5.8',7,37,0,'\0'),(529,'6.1',7,49,0,'\0'),(530,'6.2',7,29,0,'\0'),(531,'6.3',7,43,0,'\0'),(532,'6.4',7,50,0,'\0'),(533,'6.5',7,51,0,'\0'),(534,'7.1',7,120,0,'\0'),(535,'7.2',7,54,0,'\0'),(536,'7.3',7,23,1,'\0'),(537,'7.4',7,52,0,'\0'),(538,'7.5',7,7,0,'\0'),(539,'7.6',7,82,0,'\0'),(540,'7.7',7,3,0,'\0'),(541,'7.8',7,28,0,'\0'),(542,'7.9',7,30,0,'\0'),(543,'7.10',7,73,0,'\0'),(544,'7.11',7,70,0,'\0'),(545,'7.12',7,34,0,'\0'),(546,'7.13',7,14,0,'\0'),(547,'7.14',7,11,0,'\0'),(548,'7.15',7,95,0,'\0'),(549,'7.16',7,109,0,'\0'),(550,'7.17',7,104,0,'\0'),(551,'7.18',7,90,0,'\0'),(552,'7.19',7,121,0,'\0'),(553,'7.20',7,122,0,'\0'),(554,'7.21',7,86,0,'\0'),(555,'7.22',7,106,0,'\0'),(556,'1.1',8,98,1,'\0'),(557,'1.2',8,83,0,'\0'),(558,'1.3',8,1,0,'\0'),(559,'1.4',8,2,0,'\0'),(560,'1.5',8,10,0,'\0'),(561,'2.1',8,112,0,'\0'),(562,'2.2',8,47,0,'\0'),(563,'2.3',8,57,0,'\0'),(564,'2.4',8,56,0,'\0'),(565,'2.5',8,33,0,'\0'),(566,'2.6',8,44,0,'\0'),(567,'2.7',8,46,0,'\0'),(568,'2.8',8,27,0,'\0'),(569,'2.9',8,22,0,'\0'),(570,'2.10',8,26,0,'\0'),(571,'2.11',8,113,0,'\0'),(572,'2.12',8,25,0,'\0'),(573,'2.13',8,117,0,'\0'),(574,'2.14',8,45,0,'\0'),(575,'2.15',8,53,0,'\0'),(576,'2.16',8,40,0,'\0'),(577,'3.1',8,60,0,'\0'),(578,'3.2',8,69,0,'\0'),(579,'3.3',8,63,0,'\0'),(580,'3.4',8,62,0,'\0'),(581,'3.5',8,65,0,'\0'),(582,'3.6',8,67,0,'\0'),(583,'4.1',8,74,1,'\0'),(584,'4.2',8,77,0,'\0'),(585,'4.3',8,111,0,'\0'),(586,'4.4',8,92,1,'\0'),(587,'4.5',8,102,0,'\0'),(588,'4.6',8,103,0,'\0'),(589,'4.7',8,76,0,'\0'),(590,'4.8',8,78,0,'\0'),(591,'4.9',8,84,0,'\0'),(592,'4.10',8,94,0,'\0'),(593,'4.11',8,71,0,'\0'),(594,'4.12',8,101,0,'\0'),(595,'4.13',8,91,0,'\0'),(596,'4.14',8,107,0,'\0'),(597,'4.15',8,118,0,'\0'),(598,'4.16',8,119,0,'\0'),(599,'5.1',8,41,0,'\0'),(600,'5.2',8,39,0,'\0'),(601,'5.3',8,72,0,'\0'),(602,'5.4',8,100,0,'\0'),(603,'5.5',8,55,0,'\0'),(604,'5.6',8,21,0,'\0'),(605,'5.7',8,42,0,'\0'),(606,'5.8',8,37,0,'\0'),(607,'6.1',8,49,1,'\0'),(608,'6.2',8,29,0,'\0'),(609,'6.3',8,43,1,'\0'),(610,'6.4',8,50,0,'\0'),(611,'6.5',8,51,1,'\0'),(612,'7.1',8,120,0,'\0'),(613,'7.2',8,54,0,'\0'),(614,'7.3',8,23,0,'\0'),(615,'7.4',8,52,0,'\0'),(616,'7.5',8,7,0,'\0'),(617,'7.6',8,82,0,'\0'),(618,'7.7',8,3,0,'\0'),(619,'7.8',8,28,0,'\0'),(620,'7.9',8,30,0,'\0'),(621,'7.10',8,73,0,'\0'),(622,'7.11',8,70,0,'\0'),(623,'7.12',8,34,0,'\0'),(624,'7.13',8,14,0,'\0'),(625,'7.14',8,11,0,'\0'),(626,'7.15',8,95,0,'\0'),(627,'7.16',8,109,0,'\0'),(628,'7.17',8,104,0,'\0'),(629,'7.18',8,90,0,'\0'),(630,'7.19',8,121,0,'\0'),(631,'7.20',8,122,0,'\0'),(632,'7.21',8,86,0,'\0'),(633,'7.22',8,106,0,'\0'),(634,'1.1',9,98,1,'\0'),(635,'1.2',9,83,0,'\0'),(636,'1.3',9,1,1,'\0'),(637,'1.4',9,2,0,'\0'),(638,'1.5',9,10,0,'\0'),(639,'2.1',9,112,1,'\0'),(640,'2.2',9,47,0,'\0'),(641,'2.3',9,57,0,'\0'),(642,'2.4',9,56,0,'\0'),(643,'2.5',9,33,0,'\0'),(644,'2.6',9,44,0,'\0'),(645,'2.7',9,46,0,'\0'),(646,'2.8',9,27,0,'\0'),(647,'2.9',9,22,0,'\0'),(648,'2.10',9,26,0,'\0'),(649,'2.11',9,113,0,'\0'),(650,'2.12',9,25,0,'\0'),(651,'2.13',9,117,0,'\0'),(652,'2.14',9,45,0,'\0'),(653,'2.15',9,53,0,'\0'),(654,'2.16',9,40,0,'\0'),(655,'3.1',9,60,0,'\0'),(656,'3.2',9,69,0,'\0'),(657,'3.3',9,63,0,'\0'),(658,'3.4',9,62,0,'\0'),(659,'3.5',9,65,0,'\0'),(660,'3.6',9,67,0,'\0'),(661,'4.1',9,74,1,'\0'),(662,'4.2',9,77,0,'\0'),(663,'4.3',9,111,0,'\0'),(664,'4.4',9,92,0,'\0'),(665,'4.5',9,102,0,'\0'),(666,'4.6',9,103,0,'\0'),(667,'4.7',9,76,0,'\0'),(668,'4.8',9,78,0,'\0'),(669,'4.9',9,84,0,'\0'),(670,'4.10',9,94,0,'\0'),(671,'4.11',9,71,0,'\0'),(672,'4.12',9,101,0,'\0'),(673,'4.13',9,91,0,'\0'),(674,'4.14',9,107,0,'\0'),(675,'4.15',9,118,0,'\0'),(676,'4.16',9,119,0,'\0'),(677,'5.1',9,41,0,'\0'),(678,'5.2',9,39,0,'\0'),(679,'5.3',9,72,0,'\0'),(680,'5.4',9,100,0,'\0'),(681,'5.5',9,55,0,'\0'),(682,'5.6',9,21,0,'\0'),(683,'5.7',9,42,0,'\0'),(684,'5.8',9,37,0,'\0'),(685,'6.1',9,49,0,'\0'),(686,'6.2',9,29,0,'\0'),(687,'6.3',9,43,0,'\0'),(688,'6.4',9,50,0,'\0'),(689,'6.5',9,51,0,'\0'),(690,'7.1',9,120,0,'\0'),(691,'7.2',9,54,0,'\0'),(692,'7.3',9,23,1,'\0'),(693,'7.4',9,52,0,'\0'),(694,'7.5',9,7,0,'\0'),(695,'7.6',9,82,0,'\0'),(696,'7.7',9,3,0,'\0'),(697,'7.8',9,28,0,'\0'),(698,'7.9',9,30,0,'\0'),(699,'7.10',9,73,0,'\0'),(700,'7.11',9,70,0,'\0'),(701,'7.12',9,34,0,'\0'),(702,'7.13',9,14,0,'\0'),(703,'7.14',9,11,0,'\0'),(704,'7.15',9,95,0,'\0'),(705,'7.16',9,109,0,'\0'),(706,'7.17',9,104,0,'\0'),(707,'7.18',9,90,0,'\0'),(708,'7.19',9,121,0,'\0'),(709,'7.20',9,122,0,'\0'),(710,'7.21',9,86,0,'\0'),(711,'7.22',9,106,0,'\0'),(712,'1.1',10,98,1,'\0'),(713,'1.2',10,83,0,'\0'),(714,'1.3',10,1,0,'\0'),(715,'1.4',10,2,0,'\0'),(716,'1.5',10,10,0,'\0'),(717,'2.1',10,112,0,'\0'),(718,'2.2',10,47,0,'\0'),(719,'2.3',10,57,0,'\0'),(720,'2.4',10,56,0,'\0'),(721,'2.5',10,33,0,'\0'),(722,'2.6',10,44,0,'\0'),(723,'2.7',10,46,0,'\0'),(724,'2.8',10,27,0,'\0'),(725,'2.9',10,22,0,'\0'),(726,'2.10',10,26,0,'\0'),(727,'2.11',10,113,0,'\0'),(728,'2.12',10,25,0,'\0'),(729,'2.13',10,117,0,'\0'),(730,'2.14',10,45,0,'\0'),(731,'2.15',10,53,0,'\0'),(732,'2.16',10,40,0,'\0'),(733,'3.1',10,60,0,'\0'),(734,'3.2',10,69,0,'\0'),(735,'3.3',10,63,0,'\0'),(736,'3.4',10,62,0,'\0'),(737,'3.5',10,65,0,'\0'),(738,'3.6',10,67,0,'\0'),(739,'4.1',10,74,1,'\0'),(740,'4.2',10,77,0,'\0'),(741,'4.3',10,111,0,'\0'),(742,'4.4',10,92,1,'\0'),(743,'4.5',10,102,0,'\0'),(744,'4.6',10,103,0,'\0'),(745,'4.7',10,76,0,'\0'),(746,'4.8',10,78,0,'\0'),(747,'4.9',10,84,0,'\0'),(748,'4.10',10,94,0,'\0'),(749,'4.11',10,71,0,'\0'),(750,'4.12',10,101,0,'\0'),(751,'4.13',10,91,0,'\0'),(752,'4.14',10,107,0,'\0'),(753,'4.15',10,118,0,'\0'),(754,'4.16',10,119,0,'\0'),(755,'5.1',10,41,0,'\0'),(756,'5.2',10,39,0,'\0'),(757,'5.3',10,72,0,'\0'),(758,'5.4',10,100,0,'\0'),(759,'5.5',10,55,0,'\0'),(760,'5.6',10,21,0,'\0'),(761,'5.7',10,42,0,'\0'),(762,'5.8',10,37,0,'\0'),(763,'6.1',10,49,1,'\0'),(764,'6.2',10,29,0,'\0'),(765,'6.3',10,43,1,'\0'),(766,'6.4',10,50,0,'\0'),(767,'6.5',10,51,1,'\0'),(768,'7.1',10,120,0,'\0'),(769,'7.2',10,54,0,'\0'),(770,'7.3',10,23,0,'\0'),(771,'7.4',10,52,0,'\0'),(772,'7.5',10,7,0,'\0'),(773,'7.6',10,82,0,'\0'),(774,'7.7',10,3,0,'\0'),(775,'7.8',10,28,0,'\0'),(776,'7.9',10,30,0,'\0'),(777,'7.10',10,73,0,'\0'),(778,'7.11',10,70,0,'\0'),(779,'7.12',10,34,0,'\0'),(780,'7.13',10,14,0,'\0'),(781,'7.14',10,11,0,'\0'),(782,'7.15',10,95,0,'\0'),(783,'7.16',10,109,0,'\0'),(784,'7.17',10,104,0,'\0'),(785,'7.18',10,90,0,'\0'),(786,'7.19',10,121,0,'\0'),(787,'7.20',10,122,0,'\0'),(788,'7.21',10,86,0,'\0'),(789,'7.22',10,106,0,'\0'),(790,'1.1',11,98,1,'\0'),(791,'1.2',11,83,0,'\0'),(792,'1.3',11,1,1,'\0'),(793,'1.4',11,2,0,'\0'),(794,'1.5',11,10,0,'\0'),(795,'2.1',11,112,1,'\0'),(796,'2.2',11,47,0,'\0'),(797,'2.3',11,57,0,'\0'),(798,'2.4',11,56,0,'\0'),(799,'2.5',11,33,0,'\0'),(800,'2.6',11,44,0,'\0'),(801,'2.7',11,46,0,'\0'),(802,'2.8',11,27,0,'\0'),(803,'2.9',11,22,0,'\0'),(804,'2.10',11,26,0,'\0'),(805,'2.11',11,113,0,'\0'),(806,'2.12',11,25,0,'\0'),(807,'2.13',11,117,0,'\0'),(808,'2.14',11,45,0,'\0'),(809,'2.15',11,53,0,'\0'),(810,'2.16',11,40,0,'\0'),(811,'3.1',11,60,0,'\0'),(812,'3.2',11,69,0,'\0'),(813,'3.3',11,63,0,'\0'),(814,'3.4',11,62,0,'\0'),(815,'3.5',11,65,0,'\0'),(816,'3.6',11,67,0,'\0'),(817,'4.1',11,74,1,'\0'),(818,'4.2',11,77,0,'\0'),(819,'4.3',11,111,0,'\0'),(820,'4.4',11,92,0,'\0'),(821,'4.5',11,102,0,'\0'),(822,'4.6',11,103,0,'\0'),(823,'4.7',11,76,0,'\0'),(824,'4.8',11,78,0,'\0'),(825,'4.9',11,84,0,'\0'),(826,'4.10',11,94,0,'\0'),(827,'4.11',11,71,0,'\0'),(828,'4.12',11,101,0,'\0'),(829,'4.13',11,91,0,'\0'),(830,'4.14',11,107,0,'\0'),(831,'4.15',11,118,0,'\0'),(832,'4.16',11,119,0,'\0'),(833,'5.1',11,41,0,'\0'),(834,'5.2',11,39,0,'\0'),(835,'5.3',11,72,0,'\0'),(836,'5.4',11,100,0,'\0'),(837,'5.5',11,55,0,'\0'),(838,'5.6',11,21,0,'\0'),(839,'5.7',11,42,0,'\0'),(840,'5.8',11,37,0,'\0'),(841,'6.1',11,49,0,'\0'),(842,'6.2',11,29,0,'\0'),(843,'6.3',11,43,0,'\0'),(844,'6.4',11,50,0,'\0'),(845,'6.5',11,51,0,'\0'),(846,'7.1',11,120,0,'\0'),(847,'7.2',11,54,0,'\0'),(848,'7.3',11,23,1,'\0'),(849,'7.4',11,52,0,'\0'),(850,'7.5',11,7,0,'\0'),(851,'7.6',11,82,0,'\0'),(852,'7.7',11,3,0,'\0'),(853,'7.8',11,28,0,'\0'),(854,'7.9',11,30,0,'\0'),(855,'7.10',11,73,0,'\0'),(856,'7.11',11,70,0,'\0'),(857,'7.12',11,34,0,'\0'),(858,'7.13',11,14,0,'\0'),(859,'7.14',11,11,0,'\0'),(860,'7.15',11,95,0,'\0'),(861,'7.16',11,109,0,'\0'),(862,'7.17',11,104,0,'\0'),(863,'7.18',11,90,0,'\0'),(864,'7.19',11,121,0,'\0'),(865,'7.20',11,122,0,'\0'),(866,'7.21',11,86,0,'\0'),(867,'7.22',11,106,0,'\0'),(868,'1.1',12,98,1,'\0'),(869,'1.2',12,83,0,'\0'),(870,'1.3',12,1,0,'\0'),(871,'1.4',12,2,0,'\0'),(872,'1.5',12,10,0,'\0'),(873,'2.1',12,112,0,'\0'),(874,'2.2',12,47,0,'\0'),(875,'2.3',12,57,0,'\0'),(876,'2.4',12,56,0,'\0'),(877,'2.5',12,33,0,'\0'),(878,'2.6',12,44,0,'\0'),(879,'2.7',12,46,0,'\0'),(880,'2.8',12,27,0,'\0'),(881,'2.9',12,22,0,'\0'),(882,'2.10',12,26,0,'\0'),(883,'2.11',12,113,0,'\0'),(884,'2.12',12,25,0,'\0'),(885,'2.13',12,117,0,'\0'),(886,'2.14',12,45,0,'\0'),(887,'2.15',12,53,0,'\0'),(888,'2.16',12,40,0,'\0'),(889,'3.1',12,60,0,'\0'),(890,'3.2',12,69,0,'\0'),(891,'3.3',12,63,0,'\0'),(892,'3.4',12,62,0,'\0'),(893,'3.5',12,65,0,'\0'),(894,'3.6',12,67,0,'\0'),(895,'4.1',12,74,1,'\0'),(896,'4.2',12,77,0,'\0'),(897,'4.3',12,111,0,'\0'),(898,'4.4',12,92,1,'\0'),(899,'4.5',12,102,0,'\0'),(900,'4.6',12,103,0,'\0'),(901,'4.7',12,76,0,'\0'),(902,'4.8',12,78,0,'\0'),(903,'4.9',12,84,0,'\0'),(904,'4.10',12,94,0,'\0'),(905,'4.11',12,71,0,'\0'),(906,'4.12',12,101,0,'\0'),(907,'4.13',12,91,0,'\0'),(908,'4.14',12,107,0,'\0'),(909,'4.15',12,118,0,'\0'),(910,'4.16',12,119,0,'\0'),(911,'5.1',12,41,0,'\0'),(912,'5.2',12,39,0,'\0'),(913,'5.3',12,72,0,'\0'),(914,'5.4',12,100,0,'\0'),(915,'5.5',12,55,0,'\0'),(916,'5.6',12,21,0,'\0'),(917,'5.7',12,42,0,'\0'),(918,'5.8',12,37,0,'\0'),(919,'6.1',12,49,1,'\0'),(920,'6.2',12,29,0,'\0'),(921,'6.3',12,43,1,'\0'),(922,'6.4',12,50,0,'\0'),(923,'6.5',12,51,1,'\0'),(924,'7.1',12,120,0,'\0'),(925,'7.2',12,54,0,'\0'),(926,'7.3',12,23,0,'\0'),(927,'7.4',12,52,0,'\0'),(928,'7.5',12,7,0,'\0'),(929,'7.6',12,82,0,'\0'),(930,'7.7',12,3,0,'\0'),(931,'7.8',12,28,0,'\0'),(932,'7.9',12,30,0,'\0'),(933,'7.10',12,73,0,'\0'),(934,'7.11',12,70,0,'\0'),(935,'7.12',12,34,0,'\0'),(936,'7.13',12,14,0,'\0'),(937,'7.14',12,11,0,'\0'),(938,'7.15',12,95,0,'\0'),(939,'7.16',12,109,0,'\0'),(940,'7.17',12,104,0,'\0'),(941,'7.18',12,90,0,'\0'),(942,'7.19',12,121,0,'\0'),(943,'7.20',12,122,0,'\0'),(944,'7.21',12,86,0,'\0'),(945,'7.22',12,106,0,'\0'),(946,'1.1',13,98,1,'\0'),(947,'1.2',13,83,0,'\0'),(948,'1.3',13,1,1,'\0'),(949,'1.4',13,2,0,'\0'),(950,'1.5',13,10,0,'\0'),(951,'2.1',13,112,1,'\0'),(952,'2.2',13,47,0,'\0'),(953,'2.3',13,57,0,'\0'),(954,'2.4',13,56,0,'\0'),(955,'2.5',13,33,0,'\0'),(956,'2.6',13,44,0,'\0'),(957,'2.7',13,46,0,'\0'),(958,'2.8',13,27,0,'\0'),(959,'2.9',13,22,0,'\0'),(960,'2.10',13,26,0,'\0'),(961,'2.11',13,113,0,'\0'),(962,'2.12',13,25,0,'\0'),(963,'2.13',13,117,0,'\0'),(964,'2.14',13,45,0,'\0'),(965,'2.15',13,53,0,'\0'),(966,'2.16',13,40,0,'\0'),(967,'3.1',13,60,0,'\0'),(968,'3.2',13,69,0,'\0'),(969,'3.3',13,63,0,'\0'),(970,'3.4',13,62,0,'\0'),(971,'3.5',13,65,0,'\0'),(972,'3.6',13,67,0,'\0'),(973,'4.1',13,74,1,'\0'),(974,'4.2',13,77,0,'\0'),(975,'4.3',13,111,0,'\0'),(976,'4.4',13,92,0,'\0'),(977,'4.5',13,102,0,'\0'),(978,'4.6',13,103,0,'\0'),(979,'4.7',13,76,0,'\0'),(980,'4.8',13,78,0,'\0'),(981,'4.9',13,84,0,'\0'),(982,'4.10',13,94,0,'\0'),(983,'4.11',13,71,0,'\0'),(984,'4.12',13,101,0,'\0'),(985,'4.13',13,91,0,'\0'),(986,'4.14',13,107,0,'\0'),(987,'4.15',13,118,0,'\0'),(988,'4.16',13,119,0,'\0'),(989,'5.1',13,41,0,'\0'),(990,'5.2',13,39,0,'\0'),(991,'5.3',13,72,0,'\0'),(992,'5.4',13,100,0,'\0'),(993,'5.5',13,55,0,'\0'),(994,'5.6',13,21,0,'\0'),(995,'5.7',13,42,0,'\0'),(996,'5.8',13,37,0,'\0'),(997,'6.1',13,49,0,'\0'),(998,'6.2',13,29,0,'\0'),(999,'6.3',13,43,0,'\0'),(1000,'6.4',13,50,0,'\0'),(1001,'6.5',13,51,0,'\0'),(1002,'7.1',13,120,0,'\0'),(1003,'7.2',13,54,0,'\0'),(1004,'7.3',13,23,1,'\0'),(1005,'7.4',13,52,0,'\0'),(1006,'7.5',13,7,0,'\0'),(1007,'7.6',13,82,0,'\0'),(1008,'7.7',13,3,0,'\0'),(1009,'7.8',13,28,0,'\0'),(1010,'7.9',13,30,0,'\0'),(1011,'7.10',13,73,0,'\0'),(1012,'7.11',13,70,0,'\0'),(1013,'7.12',13,34,0,'\0'),(1014,'7.13',13,14,0,'\0'),(1015,'7.14',13,11,0,'\0'),(1016,'7.15',13,95,0,'\0'),(1017,'7.16',13,109,0,'\0'),(1018,'7.17',13,104,0,'\0'),(1019,'7.18',13,90,0,'\0'),(1020,'7.19',13,121,0,'\0'),(1021,'7.20',13,122,0,'\0'),(1022,'7.21',13,86,0,'\0'),(1023,'7.22',13,106,0,'\0'),(1024,'1.1',14,98,1,'\0'),(1025,'1.2',14,83,0,'\0'),(1026,'1.3',14,1,0,'\0'),(1027,'1.4',14,2,0,'\0'),(1028,'1.5',14,10,0,'\0'),(1029,'2.1',14,112,0,'\0'),(1030,'2.2',14,47,0,'\0'),(1031,'2.3',14,57,0,'\0'),(1032,'2.4',14,56,0,'\0'),(1033,'2.5',14,33,0,'\0'),(1034,'2.6',14,44,0,'\0'),(1035,'2.7',14,46,0,'\0'),(1036,'2.8',14,27,0,'\0'),(1037,'2.9',14,22,0,'\0'),(1038,'2.10',14,26,0,'\0'),(1039,'2.11',14,113,0,'\0'),(1040,'2.12',14,25,0,'\0'),(1041,'2.13',14,117,0,'\0'),(1042,'2.14',14,45,0,'\0'),(1043,'2.15',14,53,0,'\0'),(1044,'2.16',14,40,0,'\0'),(1045,'3.1',14,60,0,'\0'),(1046,'3.2',14,69,0,'\0'),(1047,'3.3',14,63,0,'\0'),(1048,'3.4',14,62,0,'\0'),(1049,'3.5',14,65,0,'\0'),(1050,'3.6',14,67,0,'\0'),(1051,'4.1',14,74,1,'\0'),(1052,'4.2',14,77,0,'\0'),(1053,'4.3',14,111,0,'\0'),(1054,'4.4',14,92,1,'\0'),(1055,'4.5',14,102,0,'\0'),(1056,'4.6',14,103,0,'\0'),(1057,'4.7',14,76,0,'\0'),(1058,'4.8',14,78,0,'\0'),(1059,'4.9',14,84,0,'\0'),(1060,'4.10',14,94,0,'\0'),(1061,'4.11',14,71,0,'\0'),(1062,'4.12',14,101,0,'\0'),(1063,'4.13',14,91,0,'\0'),(1064,'4.14',14,107,0,'\0'),(1065,'4.15',14,118,0,'\0'),(1066,'4.16',14,119,0,'\0'),(1067,'5.1',14,41,0,'\0'),(1068,'5.2',14,39,0,'\0'),(1069,'5.3',14,72,0,'\0'),(1070,'5.4',14,100,0,'\0'),(1071,'5.5',14,55,0,'\0'),(1072,'5.6',14,21,0,'\0'),(1073,'5.7',14,42,0,'\0'),(1074,'5.8',14,37,0,'\0'),(1075,'6.1',14,49,1,'\0'),(1076,'6.2',14,29,0,'\0'),(1077,'6.3',14,43,1,'\0'),(1078,'6.4',14,50,0,'\0'),(1079,'6.5',14,51,1,'\0'),(1080,'7.1',14,120,0,'\0'),(1081,'7.2',14,54,0,'\0'),(1082,'7.3',14,23,0,'\0'),(1083,'7.4',14,52,0,'\0'),(1084,'7.5',14,7,0,'\0'),(1085,'7.6',14,82,0,'\0'),(1086,'7.7',14,3,0,'\0'),(1087,'7.8',14,28,0,'\0'),(1088,'7.9',14,30,0,'\0'),(1089,'7.10',14,73,0,'\0'),(1090,'7.11',14,70,0,'\0'),(1091,'7.12',14,34,0,'\0'),(1092,'7.13',14,14,0,'\0'),(1093,'7.14',14,11,0,'\0'),(1094,'7.15',14,95,0,'\0'),(1095,'7.16',14,109,0,'\0'),(1096,'7.17',14,104,0,'\0'),(1097,'7.18',14,90,0,'\0'),(1098,'7.19',14,121,0,'\0'),(1099,'7.20',14,122,0,'\0'),(1100,'7.21',14,86,0,'\0'),(1101,'7.22',14,106,0,'\0');

--
-- Table structure for table `si_inspection_query_add_info`
--

CREATE TABLE `si_inspection_query_add_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `inspection_id` int(11) NOT NULL,
  `inspection_query_id` int(11) DEFAULT NULL,
  `comment` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_inspection_query_add_info`
--

INSERT INTO `si_inspection_query_add_info` VALUES (1,1,NULL,'out by 6 months'),(2,1,NULL,'this is the 2nd time this week'),(3,2,NULL,'this is the first occurance'),(4,2,NULL,'this needs to improve'),(5,2,NULL,'job site is not secure'),(6,3,NULL,'need to be in place'),(7,3,NULL,'extremely untidy'),(8,3,NULL,'not good enough'),(9,4,NULL,'safety on site is not acceptable'),(10,4,NULL,'unacceptable'),(11,4,NULL,'needs to be on site all the time'),(12,5,NULL,'wil need to come back tomorrow'),(13,7,480,'Trip hazards not listed on HAC'),(14,7,505,'Bill Sneezby had no ID'),(15,7,536,'Extinguisher missing tag'),(16,9,636,'Trip hazards not listed on HAC'),(17,9,661,'Bill Sneezby had no ID'),(18,9,692,'Extinguisher missing tag'),(19,11,792,'Trip hazards not listed on HAC'),(20,11,817,'Bill Sneezby had no ID'),(21,11,848,'Extinguisher missing tag'),(22,13,948,'Trip hazards not listed on HAC'),(23,13,973,'Bill Sneezby had no ID'),(24,13,1004,'Extinguisher missing tag');

--
-- Table structure for table `si_inspections`
--

CREATE TABLE `si_inspections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `inspection_id` varchar(64) DEFAULT NULL,
  `site_id` int(11) NOT NULL,
  `contract_type_id` int(11) NOT NULL,
  `audit_type_id` int(11) NOT NULL,
  `contractor_id` int(11) NOT NULL,
  `subcontractor_id` int(11) NOT NULL,
  `when_date` date DEFAULT NULL,
  `site_inspector_id` int(11) NOT NULL,
  `site_supervisor_id` int(11) NOT NULL,
  `contract_officer_id` int(11) NOT NULL,
  `is_active` bit(1) NOT NULL,
  `control_officer_recomm` text,
  `remedial_action_plan` text,
  `preventative_action_plan` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_inspections`
--

INSERT INTO `si_inspections` VALUES (1,'BK-VM.I-56 glebe p-2011.03.28-11:5',1,1,1,1,2,'2011-03-28',1,2,3,'\0','','',''),(2,'GF-CCL.B-12 moore s-2011.03.28-10:49',2,2,2,3,4,'2011-03-28',4,5,6,'\0','','',''),(3,'RH-SSLL.I-33 smith s-2011.03.28-11:16',3,3,1,5,6,'2011-03-28',7,8,9,'\0','','',''),(4,'RH-CCL.B-543 parram-2011.03.28-10:56',4,2,2,7,8,'2011-03-28',7,10,11,'\0','','',''),(5,'FM-RoP.O-234 booth-2011.03.28-11:12',5,4,3,9,10,'2011-03-28',12,13,14,'\0','','',''),(6,'IR-RoP.O-123 evergr-2011.03.15-18:19',6,4,3,9,11,'2011-03-15',15,16,17,'\0','','',''),(7,'RH-CCL.O-abbott str-2011.05.27-10:29',7,5,3,12,13,'2011-05-27',7,18,19,'\0','','',''),(8,'RH-CCL.O-123 abbott-2011.05.27-10:58',8,5,3,12,13,'2011-05-27',7,20,21,'\0','','',''),(9,'RH-CCL.O-abbott str-2011.05.27-10:29',7,5,3,12,13,'2011-05-27',7,18,19,'\0','','',''),(10,'RH-CCL.O-123 abbott-2011.05.27-10:58',8,5,3,12,13,'2011-05-27',7,20,21,'\0','','',''),(11,'RH-CCL.O-abbott str-2011.05.27-10:29',7,5,3,12,13,'2011-05-27',7,18,19,'\0','','',''),(12,'RH-CCL.O-123 abbott-2011.05.27-10:58',8,5,3,12,13,'2011-05-27',7,20,21,'\0','','',''),(13,'RH-CCL.O-abbott str-2011.05.27-10:29',7,5,3,12,13,'2011-05-27',7,18,19,'\0','','',''),(14,'RH-CCL.O-123 abbott-2011.05.27-10:58',8,5,3,12,13,'2011-05-27',7,20,21,'\0','','','');

--
-- Table structure for table `si_position_training_req_types`
--

CREATE TABLE `si_position_training_req_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_position_training_req_types`
--


--
-- Table structure for table `si_position_trainings`
--

CREATE TABLE `si_position_trainings` (
  `position_id` int(11) NOT NULL,
  `training_id` int(11) NOT NULL,
  `position_training_req_type` int(11) NOT NULL,
  PRIMARY KEY (`position_id`,`training_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_position_trainings`
--


--
-- Table structure for table `si_positions`
--

CREATE TABLE `si_positions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `inspection_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_positions`
--


--
-- Table structure for table `si_queries`
--

CREATE TABLE `si_queries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `query_type_id` int(11) DEFAULT NULL,
  `query_category_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_queries`
--

INSERT INTO `si_queries` VALUES (1,'All hazards have not been identified',NULL,NULL,1),(2,'Appropriate control measures are not in place',NULL,NULL,1),(3,'Audible reversing alarm not operational',NULL,NULL,1),(4,'Base controls and transfer lever are not operational',NULL,NULL,1),(5,'Basket controls do not function correctly',NULL,NULL,1),(6,'Boom relief valve not identifiable or operational',NULL,NULL,1),(7,'Burns Kit not complete and or in date',NULL,NULL,1),(8,'CDD not in working order or has a karabiner and sufficient rope',NULL,NULL,1),(9,'Chipper emergency stop not operational',NULL,NULL,1),(10,'Control measures have not been reviewed when conditions have changed',NULL,NULL,1),(11,'Crew is unable to access communication from site (i.e. mobile phone)',NULL,NULL,3),(12,'Dead Man Switch is not operational (can be by-passed)',NULL,NULL,1),(13,'Earthing chain is not fitted',NULL,NULL,1),(14,'Electrical leads not tagged and or out of date',NULL,NULL,1),(15,'Emergency hydraulic shut off valve not fitted or operational',NULL,NULL,1),(16,'Emergency rescue pump not identifiable or operational',NULL,NULL,1),(17,'Emergency stops not fitted at both stations',NULL,NULL,1),(18,'Emergency stops not operational at both stations',NULL,NULL,1),(19,'EWP bleed points and auxiliary pump are not operational',NULL,NULL,1),(20,'EWP deck is not clear of obstructions',NULL,NULL,1),(21,'Excavations not properly covered or fenced',NULL,NULL,1),(22,'Eye protection not being worn',NULL,NULL,1),(23,'Fire Extinguisher not tested and or tagged',NULL,NULL,1),(24,'Full face shield not being worn',NULL,NULL,1),(25,'Hand Protection not being worn',NULL,NULL,1),(26,'Hearing protection not being worn',NULL,NULL,1),(27,'Hi Vis clothing not being worn',NULL,NULL,1),(28,'Insufficient Traffic Control Devices',NULL,NULL,1),(29,'Insufficient Traffic Control devices on site',NULL,NULL,1),(30,'Insufficient Wheel Chocks (min 2)',NULL,NULL,1),(31,'Insulating gloves with over glovesnot being worn',NULL,NULL,1),(32,'Lifting slings and chains are out of date and or in poor condition',NULL,NULL,1),(33,'Long pants & or long sleeves (rolled down) not being worn',NULL,NULL,1),(34,'Low voltage Rescue Kit not onsite / complete and or in date',NULL,NULL,1),(35,'Manual Slew not fitted',NULL,NULL,1),(36,'Manual Slew not operational',NULL,NULL,1),(37,'Noise is not adequately managed',NULL,NULL,1),(38,'One man emergency recovery not possible',NULL,NULL,1),(39,'Pedestrians are not managed adequately',NULL,NULL,1),(40,'Potentially Hazardous work practice observed',NULL,NULL,1),(41,'Public safety is compromised',NULL,NULL,1),(42,'Road plates not secured, non-slip coated or edged.',NULL,NULL,1),(43,'Safety Barriers are not in accordance with installation specifications',NULL,NULL,1),(44,'Safety footwear not being worn',NULL,NULL,1),(45,'Safety Harness not in date and or good condition',NULL,NULL,1),(46,'Safety Helmet not being worn or has expired.',NULL,NULL,1),(47,'Staff appear not to be working in accordance with SWMS / procedures',NULL,NULL,1),(48,'There is not sufficient space around controls to recover in emergency',NULL,NULL,1),(49,'Traffic Control is not in accordance with TCP',NULL,NULL,1),(50,'Traffic Control Plan is not suited to the conditions',NULL,NULL,1),(51,'Traffic Controllers do not have the necessesary qualifications',NULL,NULL,1),(52,'Type B First Aid Kit not complete and or in date',NULL,NULL,1),(53,'Unsafe work practice observed',NULL,NULL,1),(54,'Vehicle stabilisers are not operational and or without leaks',NULL,NULL,1),(55,'Work compounds not secure or in an unsafe or untidy state',NULL,NULL,1),(56,'Work is not in accordance with SWMS',NULL,NULL,1),(57,'Worksite SWMS have not been identified',NULL,NULL,1),(58,'Cutting not in accordance with contract and AS 4373 requirements',NULL,NULL,2),(59,'Inappropriate Control of fallout (wind direction / ground sheets)',NULL,NULL,2),(60,'Inappropriate management of chemicals',NULL,NULL,2),(61,'Inappropriate management of chemicals / paints',NULL,NULL,2),(62,'Inappropriate management of sediment',NULL,NULL,2),(63,'Inappropriate Management of soil',NULL,NULL,2),(64,'Inappropriate management of trimmings',NULL,NULL,2),(65,'Loads not covered',NULL,NULL,2),(66,'Personnel are not aware of relevant environmental, heritage and cultural issues.',NULL,NULL,2),(67,'Protection of Vegetation not in accordance with NUS 174c',NULL,NULL,2),(68,'Site cleanup is not in accordance with the contract (within 48 hrs)',NULL,NULL,2),(69,'Site not properly cleaned up',NULL,NULL,2),(70,'Spill Kit not on plant',NULL,NULL,2),(71,'Access permit (where required) not on site',NULL,NULL,3),(72,'Access to private property is hindered',NULL,NULL,3),(73,'Contract Signage correct and or not visible at 25m (rear + Kerb)',NULL,NULL,3),(74,'Contractor ID card/s not on site',NULL,NULL,3),(75,'Electrical insulation test certificates for plant and equip. (6 mths) out of date or not on site',NULL,NULL,3),(76,'Electrical Safety Rules out of date or not on site',NULL,NULL,3),(77,'Energy Industry Network Passport/s not on site',NULL,NULL,3),(78,'Environmental Procedures NUS 174C not on site',NULL,NULL,3),(79,'EWP / Crane operators manual not on site',NULL,NULL,3),(80,'EWP does not comply with AS 1418.10 (interim) 2004',NULL,NULL,3),(81,'EWP WorkCover certificate/s  (WP/C2) (each operator) not on site',NULL,NULL,3),(82,'Flashing Light not as per RTA requirements',NULL,NULL,3),(83,'HAC form has not been completed correctly',NULL,NULL,3),(84,'HAC forms and Matrix incorrectly completed or not on site',NULL,NULL,3),(85,'Harness and lanyard does not compy AS 1891 < 10 yrs from DOM',NULL,NULL,3),(86,'Hydraulic systems have leaks and or in poor condition',NULL,NULL,3),(87,'Insulated hand / hydraulic tools not tagged',NULL,NULL,3),(88,'Insulated hand / hydraulic tools not tested',NULL,NULL,1),(89,'Insulation Test Certificate out of date',NULL,NULL,1),(90,'Load covers not in use or in poor condition',NULL,NULL,2),(91,'MSDS for each hazardous substance not on site',NULL,NULL,1),(92,'Network Standard NS-209 Operate in proximity to power lines not on site',NULL,NULL,1),(93,'NS 209  \"A\" & \"B\" plates missing',NULL,NULL,1),(94,'OHS incident / injury report form (1 x Blank accident report form) not on site',NULL,NULL,3),(95,'Overall condition of vehicle is below standard',NULL,NULL,1),(96,'Pinning Plant not in Current Conditional Registration',NULL,NULL,1),(97,'Pinning Plant not in good condition',NULL,NULL,3),(98,'Pre-work discussion has not been carried out',NULL,NULL,2),(99,'Registration label not applied and or current',NULL,NULL,2),(100,'Required Notifications have not been issued within the required timeframe',NULL,NULL,1),(101,'RTA Stand and Operate Permit not on site',NULL,NULL,1),(102,'Safe Work Method Statement(s) not on site',NULL,NULL,2),(103,'Traffic Control Plans (TS520, RTA or company specific) not on site',NULL,NULL,2),(104,'Tyres / tracks are not in good condition',NULL,NULL,2),(105,'Tyres are not in good condition',NULL,NULL,1),(106,'Unauthorised plant on site',NULL,NULL,1),(107,'Vehicle  /  EWP / Crane-Borer Log Book not completed or not on site',NULL,NULL,2),(108,'Vehicle has a closed circuit hydraulic system',NULL,NULL,1),(109,'Vehicle Loading Crane is not in accordance with AS 1418.11 - 2007',NULL,NULL,3),(110,'Warning signs on chipper are not clear and/or legible',NULL,NULL,3),(111,'Work Procedures (Quality, safety and environmental plan) not on site',NULL,NULL,3),(112,'No senior first aider on site',NULL,NULL,3),(113,'Respiratory protection not being worn',NULL,NULL,3),(114,'Chainsaw chaps not in good condition or not being worn',NULL,NULL,3),(115,'EWP WorkCover certificate/s  (WP each operator) not on site',NULL,NULL,3),(116,'NS 209 \"A\" & \"B\" plates missing',NULL,NULL,3),(117,'Gas Monitor not on site, not in date or not operated correctly',NULL,NULL,3),(118,'Network Standard NS-156 Working near EA cables (August 10)  not current and or not on site',NULL,NULL,1),(119,'Dial Before You Dig not relative to site and or not on site',NULL,NULL,2),(120,'Registration label / plates not applied and or current',NULL,NULL,1),(121,'A & B Plates not fitted where required',NULL,NULL,3),(122,'Lifting slings and chains are in not date and or good order',NULL,NULL,3),(123,'WorkCover certificate/s not on site',NULL,NULL,3),(124,'Network Standard NS-156 Working near EA cables',NULL,NULL,3);

--
-- Table structure for table `si_query_categories`
--

CREATE TABLE `si_query_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_query_categories`
--

INSERT INTO `si_query_categories` VALUES (1,'Safety'),(2,'Environmental'),(3,'Miscellaneous');

--
-- Table structure for table `si_query_types`
--

CREATE TABLE `si_query_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_query_types`
--

INSERT INTO `si_query_types` VALUES (1,'SiteRiskAssessment'),(2,'Safety'),(3,'Environment'),(4,'Documentation'),(5,'PublicImpact'),(6,'TrafficControl'),(7,'PlantMachinery'),(8,'ElevatedPlatforms');

--
-- Table structure for table `si_sites`
--

CREATE TABLE `si_sites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `suburb` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_sites`
--

INSERT INTO `si_sites` VALUES (1,'56 glebe point rd','glebe'),(2,'12 moore street ','ryde'),(3,'33 smith street ','chatswood'),(4,'543 parramatta road ','Concord'),(5,'234 booth street','annandale'),(6,'123 evergreen terrace','spiijhyuuu'),(7,'Abbott Street ','Wallsend'),(8,'123 Abbott St','Wallsend');

--
-- Table structure for table `si_trainings`
--

CREATE TABLE `si_trainings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `si_trainings`
--


--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `acronym` varchar(8) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `acronym` (`acronym`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `states`
--

INSERT INTO `states` VALUES (1,'ACT','Australian Capital Territory'),(2,'NSW','New South Wales'),(3,'NT','Northern Territory'),(4,'QLD','Queensland'),(5,'SA','South Australia'),(6,'TAS','Tasmania'),(7,'VIC','Victoria'),(8,'WA','Western Australia');

--
-- Table structure for table `submissions`
--

CREATE TABLE `submissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `form_id` int(11) NOT NULL,
  `load_date` datetime DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_form_id` (`form_id`),
  KEY `idx_filename` (`filename`),
  CONSTRAINT `submissions_ibfk_1` FOREIGN KEY (`form_id`) REFERENCES `forms` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `submissions`
--


--
-- Table structure for table `traveltime_delegations`
--

CREATE TABLE `traveltime_delegations` (
  `delegator` int(11) NOT NULL,
  `delegatee` int(11) NOT NULL,
  `date_from` date NOT NULL,
  `date_to` date NOT NULL,
  KEY `fk_users_delegator` (`delegator`),
  KEY `fk_users_delegatee` (`delegatee`),
  KEY `idx_date_from` (`date_from`),
  KEY `idx_date_to` (`date_to`),
  CONSTRAINT `traveltime_delegations_ibfk_1` FOREIGN KEY (`delegator`) REFERENCES `users` (`id`),
  CONSTRAINT `traveltime_delegations_ibfk_2` FOREIGN KEY (`delegatee`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `traveltime_delegations`
--

INSERT INTO `traveltime_delegations` VALUES (46,2,'2011-05-17','2011-05-18'),(47,2,'2011-05-18','2011-05-27');

--
-- Table structure for table `traveltime_duty_types`
--

CREATE TABLE `traveltime_duty_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `acronym` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `acronym` (`acronym`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `traveltime_duty_types`
--

INSERT INTO `traveltime_duty_types` VALUES (1,'Normal Shift','NS'),(2,'Normal Shift + OT','NS+OT'),(3,'Call Out','CO'),(4,'OT Only','OTO');

--
-- Table structure for table `traveltime_managers`
--

CREATE TABLE `traveltime_managers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cost_centre` varchar(5) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_cost_centre` (`cost_centre`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `traveltime_managers`
--

INSERT INTO `traveltime_managers` VALUES (1,'1668',46),(2,'1633',47),(3,'5109',48),(4,'4718',49),(5,'1647',50),(6,'1630',51),(7,'1616',52),(8,'1608',53),(9,'1761',54),(10,'1916',55),(11,'1649',56),(12,'1619',57),(13,'1648',58),(14,'5103',59),(15,'5108',60),(16,'1632',61),(17,'1635',62),(18,'1651',63),(19,'1637',64),(20,'1617',65),(21,'1666',66),(22,'1609',67),(23,'1762a',68),(24,'1622',69),(25,'1732',70),(26,'5002',71),(27,'1660',72),(28,'1667',73),(29,'2011a',74),(30,'1665',75),(31,'1631',76),(32,'1618',77),(33,'1610',78),(34,'1644',79),(35,'3704a',80),(36,'2006',81),(37,'1629',82),(38,'1640',83),(39,'1915',84),(40,'1639',85),(41,'2011b',86),(42,'1620',87),(43,'1912',88),(44,'5110',89),(45,'4720',90),(46,'1641',91),(47,'1669',92),(48,'1762b',93),(49,'5105',94),(50,'1607',95),(51,'1623',96),(52,'1621',97),(53,'1636',98),(54,'3704b',99);

--
-- Table structure for table `traveltime_submission_timedetails`
--

CREATE TABLE `traveltime_submission_timedetails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `submission_id` int(11) NOT NULL,
  `travel_day` date NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `from_suburb` varchar(128) NOT NULL,
  `to_suburb` varchar(128) NOT NULL,
  `transport_type` int(11) NOT NULL,
  `duty_type` int(11) NOT NULL,
  `paygrade` int(11) DEFAULT NULL,
  `acting_other_paygrade` bit(1) NOT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `status_changer` int(11) DEFAULT NULL,
  `status_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_users_status_changer` (`status_changer`),
  KEY `fk_paygrade` (`paygrade`),
  KEY `fk_duty_type` (`duty_type`),
  KEY `fk_submission` (`submission_id`),
  KEY `idx_status` (`status`),
  CONSTRAINT `traveltime_submission_timedetails_ibfk_1` FOREIGN KEY (`status_changer`) REFERENCES `users` (`id`),
  CONSTRAINT `traveltime_submission_timedetails_ibfk_2` FOREIGN KEY (`paygrade`) REFERENCES `paygrades` (`id`),
  CONSTRAINT `traveltime_submission_timedetails_ibfk_3` FOREIGN KEY (`duty_type`) REFERENCES `traveltime_duty_types` (`id`),
  CONSTRAINT `traveltime_submission_timedetails_ibfk_4` FOREIGN KEY (`submission_id`) REFERENCES `traveltime_submissions` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `traveltime_submission_timedetails`
--

INSERT INTO `traveltime_submission_timedetails` VALUES (1,1,'2011-03-14','02:00:00','12:30:00','Garden Island','Haberfield',1,1,8,'',1,46,'2011-04-22 05:47:02'),(2,2,'2011-03-28','06:00:00','19:00:00','Darlinghurst','Earlwood',2,1,NULL,'\0',NULL,NULL,NULL),(3,2,'2011-03-30','16:30:00','02:00:00','Ramsgate','Darlinghurst',3,1,NULL,'\0',NULL,NULL,NULL),(4,3,'2011-03-28','07:00:00','16:00:00','Leichhardt','Chatswood',2,2,NULL,'\0',NULL,NULL,NULL),(5,4,'2011-03-29','09:00:00','22:00:00','Coogee','Silverwater',4,3,NULL,'\0',NULL,NULL,NULL),(6,5,'2011-03-30','06:00:00','19:00:00','Paddington','Faulconbridge',3,1,NULL,'\0',NULL,NULL,NULL),(7,5,'2011-03-30','07:00:00','17:00:00','Paddington','Wahroonga',3,2,NULL,'\0',NULL,NULL,NULL),(8,5,'2011-03-30','19:00:00','03:00:00','Paddington','Abbotsbury',3,2,NULL,'\0',NULL,NULL,NULL),(9,8,'2011-04-05','06:00:00','12:00:00','Grays Point','Chatswood',2,2,NULL,'\0',NULL,NULL,NULL),(10,11,'2011-04-08','06:00:00','10:00:00','Illawong','Rodd Point',3,3,NULL,'\0',NULL,NULL,NULL),(11,11,'2011-04-10','06:00:00','12:00:00','Illawong','Rodd Point',3,3,NULL,'\0',NULL,NULL,NULL),(12,12,'2011-04-04','08:00:00','10:00:00','Tacoma','Oak Flats',4,3,NULL,'\0',NULL,NULL,NULL),(13,12,'2011-04-06','08:00:00','10:00:00','Tacoma','Abbotsbury',4,3,NULL,'\0',NULL,NULL,NULL),(14,12,'2011-04-07','04:00:00','06:00:00','Tacoma','East Branxton',4,3,NULL,'\0',NULL,NULL,NULL),(15,12,'2011-04-08','10:00:00','11:00:00','Tacoma','Quakers Hill',4,3,NULL,'\0',NULL,NULL,NULL),(16,12,'2011-04-10','23:00:00','04:00:00','Tacoma','Wadalba',4,3,NULL,'\0',NULL,NULL,NULL),(17,13,'2011-03-28','03:00:00','18:00:00','Fairfield','Holsworthy',1,1,NULL,'\0',NULL,NULL,NULL),(18,14,'2011-04-04','01:01:00','04:04:00','Earlwood','Galston',2,1,NULL,'\0',NULL,NULL,NULL),(19,15,'2011-04-04','01:01:00','04:04:00','Earlwood','Galston',2,1,NULL,'\0',NULL,NULL,NULL),(20,16,'2011-04-04','01:01:00','04:04:00','Earlwood','Galston',2,1,NULL,'\0',NULL,NULL,NULL),(21,16,'2011-04-06','02:00:00','04:00:00','Wadalba','Sadleir',2,1,NULL,'\0',NULL,NULL,NULL),(22,17,'2011-04-07','01:00:00','02:02:00','Jamberoo','Ramsgate',4,1,NULL,'\0',NULL,NULL,NULL),(23,17,'2011-04-09','03:12:00','02:11:00','Zetland','Sandhills',1,3,NULL,'\0',NULL,NULL,NULL),(24,18,'2011-04-11','02:01:00','01:03:00','Abbotsford','Daceyville',1,1,NULL,'\0',NULL,NULL,NULL),(25,18,'2011-04-11','02:01:00','06:04:00','Rankin Park','Umina',1,1,NULL,'\0',NULL,NULL,NULL),(26,18,'2011-04-11','02:03:00','06:03:00','Eagle Vale','Fairlight',1,3,NULL,'\0',NULL,NULL,NULL),(27,18,'2011-04-11','02:05:00','05:02:00','Ramsgate','Yagoona',1,3,NULL,'\0',NULL,NULL,NULL),(28,18,'2011-04-11','03:01:00','02:05:00','Sandgate','Fairlight',1,1,NULL,'\0',NULL,NULL,NULL),(29,18,'2011-04-11','03:22:00','11:02:00','Galston','Tahmoor',1,3,NULL,'\0',NULL,NULL,NULL),(30,18,'2011-04-11','04:02:00','12:03:00','Galston','Eagleton',1,1,NULL,'\0',NULL,NULL,NULL),(31,18,'2011-04-13','02:05:00','04:03:00','Kangaroo Point','Jamberoo',4,3,NULL,'\0',NULL,NULL,NULL),(32,19,'2011-04-11','01:02:00','07:02:00','Wahroonga','Fairlight',1,1,NULL,'\0',NULL,NULL,NULL),(33,19,'2011-04-11','01:02:00','07:02:00','Fairlight','Wahroonga',1,1,NULL,'\0',NULL,NULL,NULL),(34,23,'2011-04-25','23:00:00','03:00:00','Eagle Vale','Dalwood',1,1,27,'\0',NULL,NULL,NULL),(35,24,'2011-04-25','06:00:00','12:00:00','Leichhardt','Chatswood',1,1,NULL,'\0',NULL,NULL,NULL),(36,25,'2011-04-26','06:00:00','12:00:00','Leichhardt','Chatswood',3,2,NULL,'\0',NULL,NULL,NULL),(37,26,'2011-04-26','06:00:00','12:00:00','Leichhardt','Illawong',1,1,27,'\0',NULL,NULL,NULL),(38,27,'2011-04-25','06:00:00','12:00:00','Manly','Lochinvar',3,3,27,'\0',1,46,'2011-05-05 08:45:59'),(39,27,'2011-04-27','06:00:00','12:00:00','Manly','Lochinvar',3,3,27,'\0',NULL,NULL,NULL),(40,27,'2011-04-28','06:00:00','12:00:00','Manly','Lochinvar',3,3,27,'\0',NULL,NULL,NULL),(41,27,'2011-04-29','06:00:00','12:00:00','Manly','Lochinvar',3,3,27,'\0',NULL,NULL,NULL),(42,27,'2011-05-01','06:00:00','12:00:00','Manly','Lochinvar',3,3,27,'\0',NULL,NULL,NULL),(43,28,'2011-04-25','06:00:00','12:00:00','Fairlight','Quakers Hill',3,3,27,'\0',NULL,NULL,NULL),(44,29,'2011-04-25','06:00:00','16:00:00','Halloran','Yango Creek',1,1,NULL,'\0',NULL,NULL,NULL),(45,29,'2011-04-29','04:00:00','15:00:00','Eagleton','Laguna',3,1,NULL,'',NULL,NULL,NULL),(46,30,'2011-04-26','06:00:00','12:00:00','Bellevue Hill','Chatswood',2,2,NULL,'\0',NULL,NULL,NULL),(47,31,'2011-04-05','06:00:00','12:00:00','city','Bellevue Hill',1,1,20,'',1,73,'2011-05-10 15:42:40'),(48,31,'2011-04-06','06:00:00','12:00:00','city','Bellevue Hill',1,1,20,'',1,73,'2011-05-10 15:42:40'),(49,31,'2011-04-09','06:00:00','12:00:00','city','Bellevue Hill',1,1,20,'',1,73,'2011-05-10 15:42:40'),(50,32,'2011-05-04','08:00:00','12:00:00','Surry Hills','Bellevue Hill',3,3,95,'',1,73,'2011-05-10 15:45:04'),(51,32,'2011-05-05','13:00:00','17:00:00','Surry Hills','Bellevue Hill',3,3,95,'',0,73,'2011-05-10 15:45:04'),(52,32,'2011-05-06','14:00:00','14:30:00','Surry Hills','Bellevue Hill',3,3,95,'',0,73,'2011-05-10 15:45:04'),(53,32,'2011-05-08','06:00:00','12:00:00','Surry Hills','Bellevue Hill',3,3,95,'',1,73,'2011-05-10 15:45:04'),(54,32,'2011-05-08','12:30:00','16:30:00','Surry Hills','Bellevue Hill',3,3,95,'',1,73,'2011-05-10 15:45:04'),(55,33,'2011-03-28','06:00:00','12:00:00','Woolloomooloo','Bellevue Hill',4,3,NULL,'\0',1,73,'2011-05-10 15:50:22'),(56,33,'2011-03-30','11:00:00','13:00:00','Woolloomooloo','Bellevue Hill',4,3,NULL,'\0',1,73,'2011-05-10 15:50:23'),(57,33,'2011-03-31','07:00:00','13:00:00','Woolloomooloo','Bellevue Hill',4,3,NULL,'\0',1,73,'2011-05-10 15:50:23'),(58,33,'2011-04-01','09:30:00','11:30:00','Woolloomooloo','Bellevue Hill',4,3,NULL,'\0',0,73,'2011-05-10 15:50:23'),(59,33,'2011-04-03','06:30:00','10:30:00','Woolloomooloo','Bellevue Hill',4,3,NULL,'\0',0,73,'2011-05-10 15:50:23'),(60,34,'2011-05-02','06:00:00','12:00:00','Rhodes','Surry Hills',3,3,95,'',1,73,'2011-05-10 15:50:14'),(61,34,'2011-05-04','07:00:00','09:00:00','Rhodes','Bellevue Hill',2,3,95,'',1,73,'2011-05-10 15:50:14'),(62,34,'2011-05-05','11:00:00','14:00:00','Rhodes','Bellevue Hill',3,3,95,'',1,73,'2011-05-10 15:50:14'),(63,34,'2011-05-06','08:00:00','15:00:00','Rhodes','Bellevue Hill',3,3,95,'',1,73,'2011-05-10 15:50:14'),(64,34,'2011-05-08','09:00:00','17:30:00','Rhodes','Bellevue Hill',3,3,95,'',1,73,'2011-05-10 15:50:14'),(65,35,'2011-05-02','06:00:00','12:00:00','Ingleburn','Bellevue Hill',3,3,95,'',1,73,'2011-05-10 15:49:31'),(66,35,'2011-05-04','07:00:00','13:00:00','Ingleburn','Bellevue Hill',3,1,95,'',0,73,'2011-05-10 15:49:31'),(67,35,'2011-05-05','07:00:00','13:00:00','Ingleburn','Bellevue Hill',3,3,95,'',1,73,'2011-05-10 15:49:31'),(68,35,'2011-05-08','10:00:00','16:00:00','Ingleburn','Bellevue Hill',3,3,95,'',1,73,'2011-05-10 15:49:31'),(69,36,'2011-05-07','06:00:00','12:00:00','Oak Flats','Abbotsbury',1,1,6,'',NULL,46,'2011-05-11 10:18:52'),(70,36,'2011-05-07','06:00:00','12:00:00','Abbotsbury','Oak Flats',1,1,208,'',NULL,46,'2011-05-11 10:18:52'),(71,37,'2011-03-29','06:00:00','12:00:00','Tempe','Homebush',1,1,19,'',1,99,'2011-05-09 14:18:34'),(72,37,'2011-03-30','06:00:00','12:00:00','Tempe','Homebush',1,1,19,'',1,99,'2011-05-09 14:18:34'),(73,37,'2011-04-02','07:00:00','15:00:00','Tempe','Homebush',1,1,19,'',1,99,'2011-05-09 14:18:34'),(74,38,'2011-04-26','12:00:00','13:00:00','wamberal','city',2,2,4,'',1,73,'2011-05-10 15:48:12'),(75,39,'2011-05-02','11:00:00','15:00:00','Terrigal','Glebe',4,4,3,'',1,73,'2011-05-10 15:48:03'),(76,40,'2011-05-02','06:00:00','16:30:00','Leichhardt','Chatswood',1,1,NULL,'\0',NULL,NULL,NULL),(77,41,'2011-05-02','06:00:00','12:00:00','Leichhardt','Daceyville',1,1,NULL,'\0',NULL,NULL,NULL),(78,42,'2011-02-28','06:00:00','12:00:00','Turramurra','Hornsby Depot',3,4,92,'',1,99,'2011-05-16 14:30:44'),(79,42,'2011-03-02','08:00:00','13:00:00','Turramurra','Hornsby Depot',3,4,92,'',1,99,'2011-05-16 14:30:44'),(80,42,'2011-03-03','06:00:00','18:00:00','Turramurra','Hornsby Depot',3,4,92,'',1,99,'2011-05-16 14:30:44'),(81,42,'2011-03-04','01:00:00','05:00:00','Turramurra','Hornsby Depot',3,4,92,'',1,99,'2011-05-16 14:30:44'),(82,42,'2011-03-06','11:00:00','23:00:00','Turramurra','Hornsby Depot',3,4,92,'',1,99,'2011-05-16 14:31:00'),(83,43,'2011-01-31','06:00:00','12:00:00','Gladesville','Homebush Depot',4,4,NULL,'\0',1,99,'2011-05-16 14:42:39'),(84,43,'2011-02-02','06:00:00','12:00:00','Gladesville','Homebush Depot',4,4,NULL,'\0',1,99,'2011-05-16 14:42:39'),(85,43,'2011-02-03','01:00:00','06:00:00','Gladesville','Homebush Depot',4,4,NULL,'\0',1,99,'2011-05-16 14:42:39'),(86,43,'2011-02-06','08:00:00','16:45:00','Gladesville','Homebush Depot',4,4,NULL,'\0',1,99,'2011-05-16 14:42:39'),(87,44,'2011-01-10','06:00:00','12:00:00','Riverstone','Hornsby Depot',2,4,92,'',1,99,'2011-05-17 12:00:28'),(88,44,'2011-01-12','07:00:00','15:00:00','Riverstone','Head Office Building',2,4,92,'',1,99,'2011-05-17 12:00:28'),(89,44,'2011-01-13','08:00:00','16:00:00','Riverstone','Head Office Building',2,4,92,'',1,99,'2011-05-17 12:00:28'),(90,44,'2011-01-14','01:00:00','19:00:00','Riverstone','Head Office Building',2,4,92,'',1,99,'2011-05-17 12:00:28'),(91,44,'2011-01-16','10:00:00','19:00:00','Riverstone','Head Office Building',2,4,92,'',1,99,'2011-05-17 12:00:28'),(92,45,'2011-05-02','07:00:00','15:00:00','Westleigh','Southern Region',3,1,101,'',1,99,'2011-05-17 12:12:11'),(93,45,'2011-05-04','08:15:00','19:00:00','Westleigh','Hornsby Depot',3,1,101,'',1,99,'2011-05-17 12:12:11'),(94,45,'2011-05-05','19:00:00','23:00:00','Westleigh','Head Office Building',3,1,101,'',1,99,'2011-05-17 12:12:11'),(95,45,'2011-05-08','12:00:00','18:00:00','Westleigh','Hornsby Depot',3,1,101,'',1,99,'2011-05-17 12:12:11'),(96,46,'2011-05-10','00:00:00','00:00:00','Bondi','Bondi',2,1,83,'',0,99,'2011-05-24 11:27:09'),(97,47,'2011-05-19','06:00:00','12:00:00','Minchinbury','Penrith',1,4,87,'',NULL,47,'2011-05-24 15:15:18'),(98,47,'2011-05-20','06:00:00','12:00:00','Minchinbury','Penrith',2,3,299,'',NULL,47,'2011-05-24 15:15:18'),(99,47,'2011-05-21','06:00:00','12:00:00','Minchinbury','Penrith',3,2,425,'',NULL,47,'2011-05-24 15:15:18'),(100,47,'2011-05-22','06:00:00','12:00:00','Minchinbury','Penrith',4,1,159,'',NULL,47,'2011-05-24 15:15:18');

--
-- Table structure for table `traveltime_submissions`
--

CREATE TABLE `traveltime_submissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `submission_date` datetime NOT NULL,
  `load_id` int(11) DEFAULT NULL,
  `service_number` int(11) NOT NULL,
  `employee_name` varchar(128) NOT NULL,
  `employee_suburb` varchar(128) NOT NULL,
  `weekend_sunday` date NOT NULL,
  `manager_id` int(11) NOT NULL,
  `section_location` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_manager_id` (`manager_id`),
  KEY `idx_employee_name` (`employee_name`),
  KEY `idx_service_number` (`service_number`),
  KEY `idx_submission_date` (`submission_date`),
  CONSTRAINT `traveltime_submissions_ibfk_1` FOREIGN KEY (`manager_id`) REFERENCES `traveltime_managers` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `traveltime_submissions`
--

INSERT INTO `traveltime_submissions` VALUES (1,'2011-03-20 08:21:45',NULL,39887,'Peter Terry','Garden Island','2011-03-20',1,'IT & Communications Development (Chatswood)'),(2,'2011-04-01 09:52:51',NULL,43880,'Michael Tyler','Darlinghurst','2011-04-03',1,'IT & Communications Development (Bldg 5, Chatswood)'),(3,'2011-04-01 09:56:22',NULL,47802,'Matthew Clarke','Leichhardt','2011-04-03',7,'IT & Communications Development (Level: 5, Chatswood)'),(4,'2011-04-01 09:59:51',NULL,55513,'Jeff Rogers','Coogee','2011-04-03',1,'Training (Level: Grd Flr, Bldg 1, Chatswood)'),(5,'2011-04-01 10:14:36',NULL,51264,'Andy Lau','Paddington','2011-04-03',2,'IT & Communications Development (Level: Grd Flr, Bldg 5, Chatswood)'),(6,'2011-04-01 11:22:32',NULL,47802,'Matthew Clarke','Leichhardt','2011-04-03',1,'IT & Communications Development (Level: 5, Chatswood)'),(7,'2011-04-01 13:16:42',NULL,47802,'Matthew Clarke','Leichhardt','2011-04-03',1,'IT & Communications Development (Level: 5, Chatswood)'),(8,'2011-04-12 10:51:59',NULL,47802,'Matthew Clarke','Grays Point','2011-04-10',10,'IT & Communications Development (Level: 5, Chatswood)'),(9,'2011-04-12 11:16:43',NULL,47802,'Matthew Clarke','Erskineville','2011-04-10',13,'IT & Communications Development (Level: 5, Chatswood)'),(10,'2011-04-12 11:18:20',NULL,47802,'Matthew Clarke','Erskineville','2011-04-10',13,'IT & Communications Development (Level: 5, Chatswood)'),(11,'2011-04-12 11:28:33',NULL,47802,'Matthew Clarke','Illawong','2011-04-10',12,'IT & Communications Development (Level: 5, Chatswood)'),(12,'2011-04-13 11:14:57',NULL,39887,'Peter Terry','Tacoma','2011-04-10',1,'IT & Communications Development (Chatswood)'),(13,'2011-04-17 18:24:05',NULL,43812,'Sean Fitzpatrick','Fairfield','2011-04-03',1,'Field Operating (Bldg 12, Wallsend Depot)'),(14,'2011-04-17 18:30:05',NULL,43880,'Michael Tyler','Wadalba','2011-04-10',1,'IT & Communications Development (Bldg 5, Chatswood)'),(15,'2011-04-18 00:40:51',NULL,43880,'Michael Tyler','Wadalba','2011-04-10',1,'IT & Communications Development (Bldg 5, Chatswood)'),(16,'2011-04-18 00:50:28',NULL,43880,'Michael Tyler','Wadalba','2011-04-10',1,'IT & Communications Development (Bldg 5, Chatswood)'),(17,'2011-04-18 01:10:15',NULL,43826,'Miriam Kapila','Zetland','2011-04-10',1,'Business Transactions (Level: Top Flr, Bldg 1, Oatley)'),(18,'2011-04-18 01:18:18',NULL,43837,'Fiona Trussell','Galston','2011-04-17',1,'Management (Level: 19, George St.)'),(19,'2011-04-19 08:05:06',NULL,43826,'Miriam Kapila','Eagleton','2011-04-17',22,'Business Transactions (Level: Top Flr, Bldg 1, Oatley)'),(20,'2011-05-03 09:41:50',NULL,47802,'Matthew Clarke','Leichhardt','2011-05-01',1,'IT & Communications Development (Level: 5, Chatswood)'),(21,'2011-05-03 10:05:17',NULL,47802,'Matthew Clarke','Leichhardt','2011-05-01',1,'IT & Communications Development (Level: 5, Chatswood)'),(22,'2011-05-03 10:56:24',NULL,47802,'Matthew Clarke','Leichhardt','2011-05-01',1,'IT & Communications Development (Level: 5, Chatswood)'),(23,'2011-05-03 11:24:51',NULL,39887,'Peter Terry','Eagle Vale','2011-05-01',1,'IT & Communications Development (Chatswood)'),(24,'2011-05-03 11:49:15',NULL,47802,'Matthew Clarke','Leichhardt','2011-05-01',1,'IT & Communications Development (Level: 5, Chatswood)'),(25,'2011-05-03 12:39:49',NULL,47802,'Matthew Clarke','Leichhardt','2011-05-01',1,'IT & Communications Development (Level: 5, Chatswood)'),(26,'2011-05-03 13:14:51',NULL,47802,'Matthew Clarke','Leichhardt','2011-05-01',1,'IT & Communications Development (Level: 5, Chatswood)'),(27,'2011-05-03 13:34:45',NULL,44503,'Leanne Dolly','Manly','2011-05-01',1,'IT & Communications Development (Bldg 5, Chatswood)'),(28,'2011-05-03 13:46:31',NULL,48556,'John Colozzi','Fairlight','2011-05-01',1,'Field Services (Zetland)'),(29,'2011-05-05 07:19:17',NULL,49884,'Joe Copetti','Dalwood','2011-05-01',1,'Development Services (Level: 10, Roden Cutler House)'),(30,'2011-05-09 09:52:54',NULL,54579,'Anne Marie Lord','Bellevue Hill','2011-05-01',40,'Management (George St.)'),(31,'2011-05-09 10:02:50',NULL,54579,'Anne Marie Lord','Bellevue Hill','2011-04-10',28,'Management (George St.)'),(32,'2011-05-09 10:07:39',NULL,54579,'Anne Marie Lord','Bellevue Hill','2011-05-08',28,'Management (George St.)'),(33,'2011-05-09 10:13:03',NULL,54579,'Anne Marie Lord','Bellevue Hill','2011-04-03',28,'Management (George St.)'),(34,'2011-05-09 10:18:04',NULL,54579,'Anne Marie Lord','Bellevue Hill','2011-05-08',28,'Management (George St.)'),(35,'2011-05-09 10:22:15',NULL,54579,'Anne Marie Lord','Bellevue Hill','2011-05-08',28,'Management (George St.)'),(36,'2011-05-09 11:17:23',NULL,47802,'Matthew Clarke','Oak Flats','2011-05-08',1,'IT & Communications Development (Level: 5, Chatswood)'),(37,'2011-05-09 13:50:06',NULL,43332,'Glenn Sheils','Tempe','2011-04-03',54,'Workers Compensation (Level: 23, George St.)'),(38,'2011-05-10 15:46:21',NULL,54579,'Anne Marie Lord','Bellevue Hill','2011-05-01',28,'Management (George St.)'),(39,'2011-05-10 15:47:43',NULL,54579,'Anne Marie Lord','Bellevue Hill','2011-05-08',28,'Management (George St.)'),(40,'2011-05-11 09:54:59',NULL,47802,'Matthew Clarke','Leichhardt','2011-05-08',1,'IT & Communications Development (Level: 5, Chatswood)'),(41,'2011-05-11 09:55:53',NULL,47802,'Matthew Clarke','Leichhardt','2011-05-08',1,'IT & Communications Development (Level: 5, Chatswood)'),(42,'2011-05-16 14:28:22',NULL,42840,'Phil South','Turramurra','2011-03-06',54,'Employee Relations & Administration (Gore Hill Depot)'),(43,'2011-05-16 14:41:55',NULL,22661,'Corry Gadaleta','Gladesville','2011-02-06',54,'Field Services (Gore Hill Depot)'),(44,'2011-05-17 11:54:38',NULL,40431,'Sam Mansweto','Riverstone','2011-01-16',54,'Workers Compensation (Level: 23, George St.)'),(45,'2011-05-17 12:11:00',NULL,41280,'Edward Jobson','Westleigh','2011-05-08',54,'Field Services (Hornsby)'),(46,'2011-05-24 11:24:50',NULL,42815,'Brian Coopman','Bondi','2011-05-15',54,'Payroll Services (Level: 23, George St.)'),(47,'2011-05-24 15:12:51',NULL,47802,'Matthew Clarke','Minchinbury','2011-05-22',2,'IT & Communications Development (Level: 5, Chatswood)');

--
-- Table structure for table `traveltime_transport_types`
--

CREATE TABLE `traveltime_transport_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `acronym` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `acronym` (`acronym`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `traveltime_transport_types`
--

INSERT INTO `traveltime_transport_types` VALUES (1,'AG Vehicle','AGV'),(2,'Private','PVT'),(3,'Public','PUB'),(4,'Taxi','TAX');

--
-- Table structure for table `user_reccs`
--

CREATE TABLE `user_reccs` (
  `user_id` int(11) NOT NULL,
  `recc_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`),
  KEY `fk_reccs_recc_id` (`recc_id`),
  CONSTRAINT `user_reccs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `user_reccs_ibfk_2` FOREIGN KEY (`recc_id`) REFERENCES `reccs` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_reccs`
--

INSERT INTO `user_reccs` VALUES (2,1),(3,1),(4,1),(5,1),(6,1),(7,2),(8,2),(9,2),(10,2),(11,2),(12,2),(13,3),(14,3),(15,3),(16,3),(17,3),(18,4),(19,4),(20,4),(21,4),(22,4),(23,4),(24,5),(25,5),(26,5),(27,5),(28,5),(29,6),(30,6),(31,6),(32,6),(33,6),(34,6),(35,7),(36,7),(37,7),(38,7),(39,7);

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `fk_roles_role_id` (`role_id`),
  CONSTRAINT `user_roles_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_roles_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `permission_roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` VALUES (44,1),(45,1),(46,1),(47,1),(48,1),(49,1),(50,1),(51,1),(52,1),(53,1),(54,1),(55,1),(56,1),(57,1),(58,1),(59,1),(62,1),(63,1),(64,1),(65,1),(66,1),(67,1),(68,1),(69,1),(70,1),(71,1),(72,1),(73,1),(74,1),(75,1),(76,1),(77,1),(78,1),(79,1),(80,1),(81,1),(82,1),(83,1),(84,1),(85,1),(86,1),(87,1),(88,1),(89,1),(90,1),(91,1),(92,1),(93,1),(94,1),(95,1),(96,1),(97,1),(98,1),(99,1),(1,2),(2,3),(3,3),(4,3),(5,3),(6,3),(7,3),(8,3),(9,3),(10,3),(11,3),(12,3),(13,3),(14,3),(15,3),(16,3),(17,3),(18,3),(19,3),(20,3),(21,3),(22,3),(23,3),(24,3),(25,3),(26,3),(27,3),(28,3),(29,3),(30,3),(31,3),(32,3),(33,3),(34,3),(35,3),(36,3),(37,3),(38,3),(39,3),(1,4),(42,4),(43,4),(41,5),(40,6),(100,7);

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `password` varchar(64) NOT NULL,
  `email_addr` varchar(128) DEFAULT NULL,
  `service_number` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_name` (`name`) USING BTREE,
  KEY `idx_service_number` (`service_number`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'Field Moe','6fc72d91a23876e51b8b7c23e72efa7c6ea928b0adc39dbbf2271fc4f862ee7f','rajakohli@hotmail.com',47187),(2,'Anthony Stuart','f49a8146e897c72bd932cf898d1d4f45c2d4d1622864c1f38308b21c043b50f1','santhony@energy.com.au',51052),(3,'Sharon Sim','1edec861519fa0663bf1be5c56df48821ae2d521ea7b1b8405108e195f3fb351','ssim@energy.com.au',50337),(4,'Sejia Wolk','775e9c909da71ed48f93c36881129f7a548e5805c5643cf2c49bdae3d35980cb','swolk@energy.com.au',52439),(5,'Jamal Cheema','79332640675f84cfb3eff4789aab216dca77428c7ced5110a6b063fde74b911f','jcheema@energy.com.au',47317),(6,'Myra Basic','5ead29c1237da3cde17112991112fc37897868f8c1866b87d69153fdac309f47','mbasic@energy.com.au',47720),(7,'Lawrence Bolton','ffc02eaad56e6b5d9d01c03daceb17886dda129b06327d9900f98264c390ad5d','lbolton@energy.com.au',44455),(8,'Sarah Hall','20da46961d59f54eb7f621ed0b438d9415eb9d49499de366cf2ada60225c337a','shall@energy.com.au',47981),(9,'Jill Brett','de34f0d970c35653935670bed3e50c77fe1dcbe31ced095d2c4964fb6f6ea13f','jbrett@energy.com.au',46658),(10,'Peter Brogan','e405320a6a3b09ff45d65354496f0eeeb3341de790e23a90ac4aeff40dac59d7','pbrogan@energy.com.au',33480),(11,'Emily Callachor','f732b22059c5f4e5351505b453613c797ad4433453a6a9f582ba39677c66dea7','ecallachor@energy.com.au',50485),(12,'Marian Attfield','65dfc47d00bcb9b86a4679c83729388aafabcac5790459c54d4e8f98aa0f1a2b','mattfiel@energy.com.au',47077),(13,'James Hunkin','7e4c2ae2355b6fa8d4e758d59f96345849bf0fb40926516eca72b135968d31f8','jhunkin@energy.com.au',40245),(14,'Peter Short','11d7e84629db79388ae6b7e035d9d9f087973f1bebdcac6f94e04aca3e782a83','pshori@energy.com.au',46955),(15,'Debbie Cobbin','49f6cb411b6703169910cbfbb6a859910b88824b085107aee9d01385bb7db7ca','dcobbin@energy.com.au',39846),(16,'Peter Hoycard','1411309d299e4d9df16c77d9837e5e0ce5b69be0f45ade23280ed53af4d59970','phoycard@energy.com.au',36965),(17,'Val Moore','45d98978f82f36717495ebd2e0326ab1f517e5710d61c532dea349f560b3c28b','vmoore@energy.com.au',46428),(18,'Tom Emeleus','f753074d5665e74a4bab3167ba1217b07aac919c8dffd8df6df0d34565fc60ba','temeleus@energy.com.au',43724),(19,'Andrew Leondiou','d4bc0244dbd9fcf53d04f0fdcce0c5ed76dc08c8140302f2b85cf60ca4b6a9f5','aleondiou@energy.com.au',39236),(20,'Narelle Smith','f5185260a2f2263362cbd5c4a52bd3e8f68689a0557583880612eab7fe6af58f','nsmith1@energy.com.au',47999),(21,'Ahmad Chehade','ed4d819ebf67c1b0be1cd5bf5a1e20ff0edbaadc5eec56ad48633b65b780d0fd','achehade@energy.com.au',47036),(22,'Evan Partridge','6d4e3914a7a4f779aee0383b6032edef6eb66e8604d9c817c727d25e8c9d6501','epartridge@energy.com.au',43705),(23,'Anthony Colebourn','aaf8e94337c92126aa3edf32d4fbf72819777668b93095899096eee4169c42e6','acolebourn@energy.com.au',47255),(24,'Paul Stubbs','ea0285486755ce0f5657d10640562076b3c93dd56a6ec06ad7e0f44839cfb2ea','pstubbs@energy.com.au',39963),(25,'Brent Bourne','eeb15066ac05fa45c6ec146680cb00554513c8a4fecefd599b4a9c0d9c5bfbf8','bbourne@energy.com.au',41852),(26,'Inez Sutton','51a58dc67b839ba2b76cc7f6a189cf055cfa0047522573b847edfe63a7690dec','isutton@energy.com.au',43942),(27,'Marke Kemp','e397017483fbc6c4260842622339d04ba48b36c9eb54f45a3dc25ae347456ae1','mkemp@energy.com.au',50936),(28,'Owen Donnelly','60a1793e6246e316ec7df689c987d3af5e0fac94daa7d79e55de03a10ff66041','',44795),(29,'Andrew Macdonald','4e2e34506a7eb1a6b76c3c893d7d81445e212da38feeb17e500db71021d2acce','amacdonald@energy.com.au',50628),(30,'Amanda Keevers','4abc13c1f58920d7b9a7d7d762176f56e245f5fca518209dc2684c639bdbab54','akeevers@energy.com.au',49582),(31,'Penny Pring-Shambler','d3dae937493053190d610a4e8e809ac79927644b2b45b4d281591a4300e6b919','ppringshambler@energy.com.au',47478),(32,'Melanie Callaghan','f1edf3a6f24701b269d6d3bc287b5f46c1b65ec453371968397492b24158a66b','mcallaghan@energy.com.au',47102),(33,'Nicole Stokeld-Hirsch','f6b1616bafdbf31a346df3ec91637d545502bbdb46f3647461f0bd4d2628bb45','nstokeldhirsch@energy.com.au',47433),(34,'Cameron Whittington','091a71895ff942bfe970acad7f6cacad6b5a9ecc991f51e13f31eb7c06689fe4','cwhittington@energy.com.au',48248),(35,'Steve Andrews','e4fd07b7002871c0b03504812e88df806f3c59e8ec4979a2fe68ec971c9b3eab','sandrews@energy.com.au',45902),(36,'Belinda Olteanu','09cd42d7564dbf92007952e1c05a58ddd356c7498cdea27efe252649626e31e5','bolteanu@energy.com.au',46911),(37,'Craig Manwarring','8d2a11057d0f5ff61383007e0f0e4d0fd99dd47206c790c81db41995596dac91','cmanwarring@energy.com.au',46208),(38,'Jim Carey','292ae0bf5a2d610ab0137554a37ebe8bdb4c176d4f62506fde616fc3b9bf49d9','jcarey@energy.com.au',44433),(39,'Ron Harmer','601bc2279f90b2935198c19865997d17b8e9252db0238384c6a9e27104d38ae2','rharmer@energy.com.au',46141),(40,'Rod Wilkinson','1de639f54a49e5bf7bc9a411effafde26c82742d92e024a07021eb0774f9a647','rwilkins@energy.com.au',34844),(41,'Scott Bulmer','52ae7400a18d1dedd40cf011672cdedc2262cd2395e45f8865321298174023fa','sbulmer@energy.com.au',42134),(42,'Tess Ariotti','fdf797b961de9caf6a32615d037b0ba15d1e2ecea1adc38b3982b539c4d90860','tariotti@energy.com.au',55702),(43,'Martin Harris','c95d7d29e59756f405e74fc1b5f28064b056fb0e5783f3294a9e69ebc7066922','martin.harris@energy.com.au',55067),(44,'Peter Terry','fea5fd7c4cbd48d397d1caa7ba88dcf37f727108ffd8041ed9126e50fef67807','pterry@energy.com.au',39887),(45,'Matthew Clarke','8b703caf73d47abc7ed88ae2890f33c015a2640c26c7f3a49481b342cd954e4c','matthew.clarke@energy.com.au',47802),(46,'Aaron Mahony','b79015ef47d997ade1fd0ae80bcabec89c15f783ff5f9aecd400a3b3d8c7d601','',46229),(47,'Adam Gaebel','c3a3cf012a64a03ecdc229e58f3a593cfd6a989646a80adfb87dc51e9852639c','',37827),(48,'Adrian Hussey','bc1c6cf5be89666f2fd8fb3ff187929296ec0715f6a0314000c527459cd5a4c5','',49448),(49,'Alex Baird','494bbd05a8dda4fc4135f9d96e1caaae56bee6708877fd0145db51c5bc0285e7','',29535),(50,'Anthony Randle','57719aba4b0f957463cf5ffedfe4dc5f29ca537f26940db35ad391ba8cc4eb89','',45580),(51,'Bill Macnaught','a8f0bbbd4b8199d46d0bc7232883539f6fab6c9b75f3e3b8aa1ed4c043ba6fee','',33514),(52,'Bob Bedford','ca7810f343690ef67b8ced57e1606e19c3a4b33247888e17a800c41b4c015d87','',40055),(53,'Bob Jones','dc723d820af2e84f8f4a1ac403614946a4d1df579bfad60d7d4a9ca61701cf77','',28598),(54,'Bob Philliponi','0f7b1c0452e8fb36d2c377d76a6a2cfa67eb3c8e5d0cb4864c1c12011794f819','',27732),(55,'Bob Porter','ac2cd4a35fe5d2cf8df552a9ae277eb64f3230df2fb4efd8a26f780a21016ab6','',24727),(56,'Cindy Wilks','c664a40a2e1afae440a1b9f51a63957a5a6e6240f4ff7348b93b78a8db350cce','',43720),(57,'Col Bramley','75f016cb4ee46ae7f9d14cd318c5d98f049b8d1437155979a3ba55dc602f23d1','',28573),(58,'Col Chapman','','',NULL),(59,'Col Pike','8cf40b5374efa9153d5cb362da3e4b1a07e7e3351d4c3f4fb5b7976d0a9f52bc','',45358),(62,'Col Steell','bbdf122554fcc33062fc8ca089f1909e42cbaacb36604fdaac404cb0c3e86074','',36592),(63,'Colin Curry','19e5ec3af16b4442209eb54d3ee468c1a1b326e2677b2c3cbf4914fbd430ba1e','',48253),(64,'Collin Smith','3ce2e6cc059cb65ae6983a0c4cfb79a47c1659e9694b978fe2b9e832e01874bf','',34969),(65,'Dave Carter','','',NULL),(66,'Dave Hedger','','',NULL),(67,'David Larter','17564e24307a78c6f81bf09e4877df619e996332e0195d823b47494797bfb07b','',42357),(68,'Geoff Herd','021b1de3b9a8120c001e57d9e66ad5930c0337aea4b795c3a3f3d98f95cc9459','',31563),(69,'Glenn Ible','ca3123fd4714760d2eff2682050c7e0fb99e54c60f3ff2dcd455c27b0c4e5641','',41122),(70,'Greg Jamieson','dbf8fac86e9b511b294733339b0453ebbcf40ef2e51d12e37dc11f37dd23c1f2','',45151),(71,'Greg McKelvey','0565e11c3c3d77ea440612db9e246c65c9916ccd56af7a649da6e4f98fddc874','',33219),(72,'Guy Munro','973e4935bd455f388eb5925aeea6a820ef429873fd909fa1bd327ddb65105f54','',44804),(73,'Jeff Corcoran','c85d8a161cb95be41ce0c18ef9d986466d06b4dc1a228ee5b633b88e542d762e','',47571),(74,'Joanne Lewis','7809a688ea94df1a969d97b9e3accf626db01b67a7fc7541250ad74d1d6bcb0c','',46524),(75,'John Bristow','1ff599ad123ec5b1fe576c6fd7f0fba1310e8b1d9b211d77ec4199e5691f1d53','',36759),(76,'John Casey','','',NULL),(77,'Joseph Duggan','c61d95f807f1c370921ce67728975e888d0e39a8b8c233f20002a19899118b1c','',21900),(78,'Kane Kennet','3d8cae98d48b2cafd88a657689e1b51ff30c4e888516e1374eb52e9a7c69fbaa','',46351),(79,'Keith McKeown','1684823dee24773af13b4d88093858999e53ed65c96c94f0dbd80eb66dff9160','',33423),(80,'Ken McGuinness','e334e45bda7496c65adaf18a7a05e109ed0673cc70dadde0d3703ef5515b6620','',43319),(81,'Kristan Keir','db474c14986ef0d640235861f744d04eb2623036c81cd99c3c69fd9643ff8cae','',47070),(82,'Marshall Parrott','0061bb958fe9daf5ad191386b9098ed2b61bd9469588152f7f84f91c6637919e','',29478),(83,'Martin Campbell','c39c24941fa8cdd9f45a65ef09b1130960b97698276890405544721a660008fb','',35680),(84,'Matthew Joyce','63e1d51cc0eb408ddbf9b717908efc50804e73289deab867e0bcd55721952343','',42027),(85,'Michael Chapman','15bf271614e5a38db8e756036891428f6f07dd045fc0a017d4fffe2f1a8fee6a','',34475),(86,'Michael Judge','754e8ca0e5d5be761c6621edfc94aca1bf7688e78908acfc9cd14293c8bc454b','',45907),(87,'Paul Riley','a343e3c8fbdcb5a871bc29cb529e91329b447ff78d42312c792024290ee5d4be','',38886),(88,'Peter Rigby','0c8dfe5b0e526ff06b09ca008942b17effc8d740dbf5b40ef44672353817804b','',31584),(89,'Peter White','de927b0056cbede900542f2947d1c91872ec30dc47301eac0c0beef937043b6f','',46123),(90,'Phil Ryan','','',NULL),(91,'Rob North','b4305576b5ff248323a66d709c4950546fd681de411bdda927ba84f76fb0ac8a','',35880),(92,'Stephen Burns','8c7d0cde81e36082073f67a95e0797a0c8b77a24419ce5b1a925a2e0def46776','',47311),(93,'Steve Sutherland','fde4905a546085869fa33939d292cfc4b76de03dbddfce68e5cebd030cee9a82','',27256),(94,'Steven Mackie','3cfb2ad44208dc30bb4c1cd976cb315273e09b36eb46f0fd1ad1e20040fc7749','',43391),(95,'Stuart Cregan','8e49d19e44c3583d1e012a5872a0b1c581a472b76a547d1060cbb7f391a00876','',40154),(96,'Terry Harris','29f312927e370794341ed2ef3379eec50c2d11532b49b945522489e709379bfd','',54170),(97,'Tony Doyle','1d09960a66c2229e675ffa639b0ded8d803448066fa3067695f9191ed9ab7626','',41040),(98,'Trevor Moss','ff5f7830eecb850e5cc278c29866c84fffa0d8a41b9cc2570fa556cd84fd536e','',37805),(99,'Trevor Upton','dedcae250522436bd02835c494d41843ead28be7e2d69ca9537547214afad1e3','',45545),(100,'Brian Coopman','59d44d422e26ddc8b748bb24fb1744d0ce9ab3883f7e25e20682781784644e4f',NULL,44444);


