-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------





--
-- Create schema travel_time_dev
--

--
-- Definition of table `divisions`
--

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

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

INSERT INTO `divisions` (`id`,`name`) 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'),
 (9,'Energy Services');


--
-- Definition of 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=utf8;

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

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


--
-- Definition of 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=utf8;

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

INSERT INTO `holidays` (`id`,`year`,`month`,`day`,`name`) VALUES 
 (1,NULL,12,25,'Christmas');


--
-- Definition of table `login_codes`
--

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

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

INSERT INTO `login_codes` (`code`,`service_number`,`valid_until`) VALUES 
 ('2fc24264ced7cabf8eb5b8dfbb55f687',56367,'2011-10-16 14:51:31'),
 ('95a0fbbe1f707cb8a91ec62a1e28f1e6',56367,'2011-10-16 14:45:13'),
 ('9731e7e69e498d3e0b613ab73bb1b4c4',56367,'2011-10-16 14:33:33'),
 ('20fd0cc7c46c5aa8d9a0e0c1051de693',56372,'2011-10-16 13:59:16'),
 ('3d121d0b216fe29e173fb1d0371227cb',56372,'2011-10-16 14:24:11'),
 ('46b46dff15874e8d9b4f743478876eb5',56372,'2011-10-16 14:28:50'),
 ('89da99efda279c96dabdfef3caa9394b',56372,'2011-10-09 16:05:23'),
 ('b7c1ded26862246fc3d8cf649259acbf',56372,'2011-10-16 14:19:40'),
 ('ccd99f0c0134ddbcac07315bcd10074d',56372,'2011-10-16 13:56:42'),
 ('fb4ba5002a6e779cce6835917690568d',56372,'2011-10-16 14:00:03'),
 ('44b0223ac699b64849863f115927fc17',99935,'2011-10-09 12:48:28'),
 ('6d75aeffc41507c084f2ea0cbf1bce6b',99935,'2011-10-16 15:08:52');


--
-- Definition of 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=440 DEFAULT CHARSET=utf8;

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

INSERT INTO `paygrades` (`id`,`acronym`,`name`,`rate`,`parent_paygrade`) VALUES 
 (1,'J1','J1','9.25',NULL),
 (2,'J2','J2','9.72',NULL),
 (3,'J3','J3','10.20',NULL),
 (4,'J4','J4','10.71',NULL),
 (5,'J5','J5','11.24',NULL),
 (6,'J6','J6','11.80',NULL),
 (7,'J7','J7','12.39',NULL),
 (8,'J8','J8','13.01',NULL),
 (9,'J9','J9','13.66',NULL),
 (10,'J10','J10','14.35',NULL),
 (11,'J10-5','J10+SR','17.81',10),
 (12,'J10-7','J10+SR80','17.12',10),
 (13,'J11','J11','15.06',NULL),
 (14,'J12','J12','15.81',NULL),
 (15,'J13','J13','16.61',NULL),
 (16,'J14','J14','17.43',NULL),
 (17,'J14-5','J14+SR','20.90',16),
 (18,'J14-7','J14+SR80','20.21',16),
 (19,'J15','J15','18.31',NULL),
 (20,'J15-5','J15+SR','21.77',19),
 (21,'J16','J16','19.21',NULL),
 (22,'J17','J17','20.18',NULL),
 (23,'J17-5','J17+SR','23.65',22),
 (24,'J17-7','J17+SR80','22.96',22),
 (25,'J18','J18','21.19',NULL),
 (26,'J18-5','J18+SR','24.66',25),
 (27,'1','1','21.71',NULL),
 (28,'2','2','22.14',NULL),
 (29,'2-1','2+EL','23.13',28),
 (30,'2-2','2+ELSR','26.60',28),
 (31,'2-5','2+SR','25.61',28),
 (32,'2-7','2+SR80','24.92',28),
 (33,'3','3','22.57',NULL),
 (34,'4','4','23.01',NULL),
 (35,'5','5','23.46',NULL),
 (36,'6','6','23.91',NULL),
 (37,'6-5','6+SR','27.38',36),
 (38,'7','7','24.38',NULL),
 (39,'7-6','7+SREO','26.46',38),
 (40,'8','8','24.86',NULL),
 (41,'8-5','8+SR','28.33',40),
 (42,'8-6','8+SREO','26.94',40),
 (43,'9','9','25.35',NULL),
 (44,'9-5','9+SR','28.82',43),
 (45,'9-6','9+SREO','27.44',43),
 (46,'10','10','25.86',NULL),
 (47,'10-5','10+SR','29.33',46),
 (48,'10-6','10+SREO','27.95',46),
 (49,'10Y','10Y','25.95',NULL),
 (50,'10Y-6','10Y+SREO','28.03',49),
 (51,'11','11','26.38',NULL),
 (52,'11-1','11+EL','27.37',51),
 (53,'11-5','11+SR','29.85',51),
 (54,'11-6','11+SREO','28.46',51),
 (55,'12','12','26.91',NULL),
 (56,'12-5','12+SR','30.38',55),
 (57,'12-6','12+SREO','28.99',55),
 (58,'12Y','12Y','27.00',NULL),
 (59,'12Y-1','12Y+EL','27.99',58),
 (60,'12Y-2','12Y+ELSR','31.46',58),
 (61,'12Y-5','12Y+SR','30.47',58),
 (62,'13','13','27.46',NULL),
 (63,'13-5','13+SR','30.92',62),
 (64,'13-6','13+SREO','29.54',62),
 (65,'14','14','28.00',NULL),
 (66,'14-5','14+SR','31.47',65),
 (67,'14-6','14+SREO','30.08',65),
 (68,'14Y','14Y','28.10',NULL),
 (69,'15','15','28.56',NULL),
 (70,'15-1','15+EL','29.55',69),
 (71,'15-2','15+ELSR','33.02',69),
 (72,'15-5','15+SR','32.02',69),
 (73,'15-6','15+SREO','30.64',69),
 (74,'15-7','15+SR80','31.33',69),
 (75,'15F','15+CTA','29.31',69),
 (76,'15M','15+PLTA','29.17',69),
 (77,'15P','15+PTA+PRA','29.91',69),
 (78,'15W','15+PTA{NO PRA}','29.23',69),
 (79,'15Y','15Y','28.65',NULL),
 (80,'15Y-1','15Y+EL','29.64',79),
 (81,'15Y-2','15Y+ELSR','33.11',79),
 (82,'15Y-5','15Y+SR','32.12',79),
 (83,'16','16','29.13',NULL),
 (84,'16-1','16+EL','30.12',83),
 (85,'16-2','16+ELSR','33.59',83),
 (86,'16-5','16+SR','32.59',83),
 (87,'16-6','16+SREO','31.21',83),
 (88,'16F','16+CTA','29.88',83),
 (89,'16M','16+PLTA','29.74',83),
 (90,'16P','16+PTA+PRA','30.48',83),
 (91,'16W','16+PTA{NO PRA}','29.80',83),
 (92,'16Y','16Y','29.22',NULL),
 (93,'16Y-1','16Y+EL','30.22',92),
 (94,'16Y-2','16Y+ELSR','33.68',92),
 (95,'16Y-5','16Y+SR','32.69',92),
 (96,'17','17','29.71',NULL),
 (97,'17-1','17+EL','30.70',96),
 (98,'17-2','17+ELSR','34.17',96),
 (99,'17-5','17+SR','33.18',96),
 (100,'17-6','17+SREO','31.79',96),
 (101,'18','18','30.30',NULL),
 (102,'18-1','18+EL','31.29',101),
 (103,'18-2','18+ELSR','34.76',101),
 (104,'18-5','18+SR','33.77',101),
 (105,'18-6','18+SREO','32.38',101),
 (106,'18-7','18+SR80','33.08',101),
 (107,'18F','18+CTA','31.06',101),
 (108,'18M','18+PLTA','30.92',101),
 (109,'18M-7','18+PLTA+SR80','33.74',101),
 (110,'18P','18+PTA+PRA','31.66',101),
 (111,'18W','18+PTA{NO PRA}','30.98',101),
 (112,'18Y','18Y','30.40',NULL),
 (113,'18Y-1','18Y+EL','31.40',112),
 (114,'18Y-2','18Y+ELSR','34.86',112),
 (115,'18Y-5','18Y+SR','33.87',112),
 (116,'18Y-6','18Y+SREO','32.49',112),
 (117,'19','19','30.92',NULL),
 (118,'19-1','19+EL','31.91',117),
 (119,'19-2','19+ELSR','35.38',117),
 (120,'19-5','19+SR','34.38',117),
 (121,'19-6','19+SREO','33.00',117),
 (122,'19F','19+CTA','31.67',117),
 (123,'19P','19+PTA+PRA','32.27',117),
 (124,'19W','19+PTA{NO PRA}','31.59',117),
 (125,'19Y','19Y','31.02',NULL),
 (126,'19Y-2','19Y+ELSR','35.48',125),
 (127,'20','20','31.53',NULL),
 (128,'20-1','20+EL','32.53',127),
 (129,'20-2','20+ELSR','35.99',127),
 (130,'20-5','20+SR','35.00',127),
 (131,'20-6','20+SREO','33.62',127),
 (132,'20-7','20+SR80','34.31',127),
 (133,'20F','20+CTA','32.29',127),
 (134,'20M','20+PLTA','32.15',127),
 (135,'20M-7','20+PLTA+SR80','34.92',127),
 (136,'20P','20+PTA+PRA','32.89',127),
 (137,'20P-7','20+PTA+PRA+SR80','35.67',127),
 (138,'20W','20+PTA{NO PRA}','32.21',127),
 (139,'20Y','20Y','31.64',NULL),
 (140,'20Y-1','20Y+EL','32.63',139),
 (141,'20Y-2','20Y+ELSR','36.10',139),
 (142,'20Y-5','20Y+SR','35.11',139),
 (143,'21','21','32.17',NULL),
 (144,'21-1','21+EL','33.16',143),
 (145,'21-2','21+ELSR','36.63',143),
 (146,'21-5','21+SR','35.63',143),
 (147,'21-6','21+SREO','34.25',143),
 (148,'21-7','21+SR80','34.94',143),
 (149,'21F','21+CTA','32.92',143),
 (150,'21F-7','21+CTA+SR80','35.75',143),
 (151,'21P','21+PTA+PRA','33.52',143),
 (152,'21P-7','21+PTA+PRA+SR80','36.36',143),
 (153,'21W','21+PTA{NO PRA}','32.84',143),
 (154,'21Y','21Y','32.27',NULL),
 (155,'21Y-1','21Y+EL','33.27',154),
 (156,'21Y-2','21Y+ELSR','36.73',154),
 (157,'21Y-5','21Y+SR','35.74',154),
 (158,'22','22','32.80',NULL),
 (159,'22-1','22+EL','33.79',158),
 (160,'22-2','22+ELSR','37.26',158),
 (161,'22-5','22+SR','36.27',158),
 (162,'22-6','22+SREO','34.88',158),
 (163,'22-7','22+SR80','35.58',158),
 (164,'22Y','22Y','32.91',NULL),
 (165,'22Y-1','22Y+EL','33.90',164),
 (166,'22Y-2','22Y+ELSR','37.37',164),
 (167,'22Y-5','22Y+SR','36.38',164),
 (168,'22Y-6','22Y+SREO','34.99',164),
 (169,'23','23','33.46',NULL),
 (170,'23-1','23+EL','34.45',169),
 (171,'23-2','23+ELSR','37.92',169),
 (172,'23-5','23+SR','36.93',169),
 (173,'23-6','23+SREO','35.54',169),
 (174,'23-7','23+SR80','36.24',169),
 (175,'23F','23+CTA','34.22',169),
 (176,'23F-7','23+CTA+SR80','36.99',169),
 (177,'24','24','34.13',NULL),
 (178,'24-1','24+EL','35.12',177),
 (179,'24-2','24+ELSR','38.59',177),
 (180,'24-5','24+SR','37.60',177),
 (181,'24-6','24+SREO','36.21',177),
 (182,'24-7','24+SR80','36.91',177),
 (183,'24Y','24Y','34.25',NULL),
 (184,'24Y-1','24Y+EL','35.24',183),
 (185,'24Y-2','24Y+ELSR','38.71',183),
 (186,'24Y-5','24Y+SR','37.71',183),
 (187,'25','25','34.81',NULL),
 (188,'25-1','25+EL','35.80',187),
 (189,'25-2','25+ELSR','39.27',187),
 (190,'25-5','25+SR','38.28',187),
 (191,'25-6','25+SREO','36.89',187),
 (192,'25-7','25+SR80','37.59',187),
 (193,'25-E1','25+E1','36.69',187),
 (194,'26','26','35.50',NULL),
 (195,'26-1','26+EL','36.50',194),
 (196,'26-2','26+ELSR','39.96',194),
 (197,'26-5','26+SR','38.97',194),
 (198,'26-6','26+SREO','37.59',194),
 (199,'26-7','26+SR80','38.28',194),
 (200,'26F','26+CTA','36.26',194),
 (201,'26F-7','26+CTA+SR80','39.04',194),
 (202,'26P','26+PTA+PRA','36.86',194),
 (203,'26P-7','26+PTA+PRA+SR80','39.70',194),
 (204,'26W','26+PTA{NO PRA}','36.18',194),
 (205,'26Y','26Y','35.63',NULL),
 (206,'26Y-1','26Y+EL','36.62',205),
 (207,'26Y-2','26Y+ELSR','40.08',205),
 (208,'26Y-5','26Y+SR','39.09',205),
 (209,'27','27','36.22',NULL),
 (210,'27-1','27+EL','37.21',209),
 (211,'27-2','27+ELSR','40.68',209),
 (212,'27-5','27+SR','39.69',209),
 (213,'27-6','27+SREO','38.30',209),
 (214,'27-7','27+SR80','38.99',209),
 (215,'27Y','27Y','36.34',NULL),
 (216,'27Y-1','27Y+EL','37.34',215),
 (217,'27Y-2','27Y+ELSR','40.80',215),
 (218,'27Y-5','27Y+SR','39.81',215),
 (219,'28','28','36.94',NULL),
 (220,'28-1','28+EL','37.93',219),
 (221,'28-2','28+ELSR','41.40',219),
 (222,'28-5','28+SR','40.41',219),
 (223,'28-6','28+SREO','39.02',219),
 (224,'28-7','28+SR80','39.71',219),
 (225,'28F','28+CTA','37.70',219),
 (226,'28P','28+PTA+PRA','38.33',219),
 (227,'28P-7','28+PTA+PRA+SR80','41.16',219),
 (228,'28Y','28Y','37.07',NULL),
 (229,'28Y-5','28Y+SR','40.53',228),
 (230,'29','29','37.68',NULL),
 (231,'29-1','29+EL','38.67',230),
 (232,'29-2','29+ELSR','42.14',230),
 (233,'29-5','29+SR','41.15',230),
 (234,'29-6','29+SREO','39.76',230),
 (235,'29-7','29+SR80','40.46',230),
 (236,'29-E1','29+E1','39.56',230),
 (237,'29Y','29Y','37.81',NULL),
 (238,'29Y-1','29Y+EL','38.80',237),
 (239,'29Y-2','29Y+ELSR','42.27',237),
 (240,'29Y-5','29Y+SR','41.28',237),
 (241,'30','30','38.44',NULL),
 (242,'30-1','30+EL','39.43',241),
 (243,'30-2','30+ELSR','42.90',241),
 (244,'30-5','30+SR','41.91',241),
 (245,'30-6','30+SREO','40.52',241),
 (246,'30-7','30+SR80','41.22',241),
 (247,'30Y','30Y','38.57',NULL),
 (248,'30Y-1','30Y+EL','39.56',247),
 (249,'30Y-2','30Y+ELSR','43.03',247),
 (250,'30Y-5','30Y+SR','42.04',247),
 (251,'31','31','39.20',NULL),
 (252,'31-1','31+EL','40.19',251),
 (253,'31-2','31+ELSR','43.66',251),
 (254,'31-5','31+SR','42.67',251),
 (255,'31-6','31+SREO','41.28',251),
 (256,'31-7','31+SR80','41.98',251),
 (257,'32','32','40.00',NULL),
 (258,'32-1','32+EL','40.99',257),
 (259,'32-2','32+ELSR','44.46',257),
 (260,'32-5','32+SR','43.47',257),
 (261,'32-6','32+SREO','42.08',257),
 (262,'32-7','32+SR80','42.77',257),
 (263,'32F-7','32+CTA+SR80','43.53',257),
 (264,'32P-7','32+PTA+PRA+SR80','44.13',257),
 (265,'32Y','32Y','40.13',NULL),
 (266,'32Y-1','32Y+EL','41.12',265),
 (267,'32Y-2','32Y+ELSR','44.59',265),
 (268,'32Y-5','32Y+SR','43.60',265),
 (269,'33','33','40.79',NULL),
 (270,'33-1','33+EL','41.78',269),
 (271,'33-2','33+ELSR','45.25',269),
 (272,'33-5','33+SR','44.26',269),
 (273,'33-6','33+SREO','42.87',269),
 (274,'33-7','33+SR80','43.57',269),
 (275,'33Y','33Y','40.93',NULL),
 (276,'33Y-2','33Y+ELSR','45.39',275),
 (277,'34','34','41.60',NULL),
 (278,'34-1','34+EL','42.60',277),
 (279,'34-2','34+ELSR','46.06',277),
 (280,'34-5','34+SR','45.07',277),
 (281,'34-7','34+SR80','44.38',277),
 (282,'34Y','34Y','41.75',NULL),
 (283,'34Y-2','34Y+ELSR','46.21',282),
 (284,'35','35','42.43',NULL),
 (285,'35-1','35+EL','43.42',284),
 (286,'35-2','35+ELSR','46.89',284),
 (287,'35-5','35+SR','45.90',284),
 (288,'35-6','35+SREO','44.51',284),
 (289,'35-7','35+SR80','45.21',284),
 (290,'35Y','35Y','42.58',NULL),
 (291,'35Y-1','35Y+EL','43.57',290),
 (292,'35Y-2','35Y+ELSR','47.04',290),
 (293,'35Y-5','35Y+SR','46.05',290),
 (294,'36','36','43.29',NULL),
 (295,'36-1','36+EL','44.28',294),
 (296,'36-2','36+ELSR','47.74',294),
 (297,'36-5','36+SR','46.75',294),
 (298,'36-6','36+SREO','45.37',294),
 (299,'36-7','36+SR80','46.06',294),
 (300,'36Y','36Y','43.43',NULL),
 (301,'37','37','44.15',NULL),
 (302,'37-1','37+EL','45.15',301),
 (303,'37-2','37+ELSR','48.61',301),
 (304,'37-5','37+SR','47.62',301),
 (305,'37-7','37+SR80','46.93',301),
 (306,'37Y','37Y','44.30',NULL),
 (307,'37Y-2','37Y+ELSR','48.76',306),
 (308,'38','38','45.04',NULL),
 (309,'38-1','38+EL','46.03',308),
 (310,'38-2','38+ELSR','49.50',308),
 (311,'38-5','38+SR','48.50',308),
 (312,'38-6','38+SREO','47.12',308),
 (313,'38-7','38+SR80','47.81',308),
 (314,'39','39','45.93',NULL),
 (315,'39-1','39+EL','46.93',314),
 (316,'39-2','39+ELSR','50.39',314),
 (317,'39-5','39+SR','49.40',314),
 (318,'39-7','39+SR80','48.71',314),
 (319,'40','40','46.86',NULL),
 (320,'40-1','40+EL','47.85',319),
 (321,'40-2','40+ELSR','51.32',319),
 (322,'40-5','40+SR','50.32',319),
 (323,'40-6','40+SREO','48.94',319),
 (324,'40-7','40+SR80','49.63',319),
 (325,'41','41','47.79',NULL),
 (326,'41-1','41+EL','48.78',325),
 (327,'41-2','41+ELSR','52.25',325),
 (328,'41-5','41+SR','51.26',325),
 (329,'41-6','41+SREO','49.87',325),
 (330,'41-7','41+SR80','50.56',325),
 (331,'41Y','41Y','47.95',NULL),
 (332,'41Y-2','41Y+ELSR','52.41',331),
 (333,'42','42','48.74',NULL),
 (334,'42-1','42+EL','49.74',333),
 (335,'42-2','42+ELSR','53.20',333),
 (336,'42-5','42+SR','52.21',333),
 (337,'42-6','42+SREO','50.83',333),
 (338,'42-7','42+SR80','51.52',333),
 (339,'43','43','49.72',NULL),
 (340,'43-1','43+EL','50.71',339),
 (341,'43-2','43+ELSR','54.18',339),
 (342,'43-5','43+SR','53.18',339),
 (343,'43-6','43+SREO','51.80',339),
 (344,'43-7','43+SR80','52.49',339),
 (345,'43Y','43Y','49.89',NULL),
 (346,'43Y-2','43Y+ELSR','54.34',345),
 (347,'44','44','50.71',NULL),
 (348,'44-1','44+EL','51.71',347),
 (349,'44-2','44+ELSR','55.17',347),
 (350,'44-5','44+SR','54.18',347),
 (351,'44-7','44+SR80','53.49',347),
 (352,'44Y','44Y','50.89',NULL),
 (353,'44Y-1','44Y+EL','51.88',352),
 (354,'44Y-2','44Y+ELSR','55.35',352),
 (355,'44Y-5','44Y+SR','54.35',352),
 (356,'45','45','51.72',NULL),
 (357,'45-1','45+EL','52.72',356),
 (358,'45-2','45+ELSR','56.18',356),
 (359,'45-5','45+SR','55.19',356),
 (360,'45-6','45+SREO','53.80',356),
 (361,'45-7','45+SR80','54.50',356),
 (362,'46','46','52.77',NULL),
 (363,'46-1','46+EL','54.88',362),
 (364,'46-2','46+ELSR','57.23',362),
 (365,'46-5','46+SR','56.24',362),
 (366,'46-6','46+SREO','54.85',362),
 (367,'46-7','46+SR80','55.54',362),
 (368,'46-E1','46+E1','54.65',362),
 (369,'46-E2','46+E2','56.82',362),
 (370,'47','47','53.82',NULL),
 (371,'47-1','47+EL','54.81',370),
 (372,'47-2','47+ELSR','58.28',370),
 (373,'47-5','47+SR','57.29',370),
 (374,'47-7','47+SR80','56.60',370),
 (375,'47Y','47Y','54.01',NULL),
 (376,'48','48','54.90',NULL),
 (377,'48-1','48+EL','55.89',376),
 (378,'48-2','48+ELSR','59.35',376),
 (379,'48-5','48+SR','58.36',376),
 (380,'48-7','48+SR80','57.67',376),
 (381,'49','49','56.00',NULL),
 (382,'49-1','49+EL','56.99',381),
 (383,'49-2','49+ELSR','60.46',381),
 (384,'49Y-5','49Y+SR','59.66',381),
 (385,'49-7','49+SR80','58.77',381),
 (386,'49-E1','49+E1','57.88',381),
 (387,'49-E2','49+E2','60.04',381),
 (388,'49Y','49Y','56.19',NULL),
 (389,'49Y-1','49Y+EL','57.18',388),
 (390,'49Y-2','49Y+ELSR','60.65',388),
 (391,'50','50','57.12',NULL),
 (392,'50-1','50+EL','58.11',391),
 (393,'50-2','50+ELSR','61.57',391),
 (394,'50-5','50+SR','60.58',391),
 (395,'51','51','58.26',NULL),
 (396,'51-1','51+EL','59.25',395),
 (397,'51-2','51+ELSR','62.72',395),
 (398,'51-5','51+SR','61.73',395),
 (399,'51-7','51+SR80','61.04',395),
 (400,'52','52','59.42',NULL),
 (401,'52-1','52+EL','60.41',400),
 (402,'52-2','52+ELSR','63.88',400),
 (403,'52-5','52+SR','62.89',400),
 (404,'53','53','60.61',NULL),
 (405,'53-1','53+EL','61.61',404),
 (406,'53-2','53+ELSR','65.07',404),
 (407,'53-5','53+SR','64.08',404),
 (408,'53-E1','53+E1','62.49',404),
 (409,'53-E2','53+E2','64.66',404),
 (410,'54','54','61.82',NULL),
 (411,'54-2','54+ELSR','66.28',410),
 (412,'54-5','54+SR','65.29',410),
 (413,'55','55','63.07',NULL),
 (414,'55-2','55+ELSR','67.53',413),
 (415,'55-E2','55+E2','67.11',413),
 (416,'56','56','64.33',NULL),
 (417,'57','57','65.61',NULL),
 (418,'57-2','57+ELSR','70.07',417),
 (419,'57-E2','57+E2','69.65',417),
 (420,'58','58','66.92',NULL),
 (421,'58-8','58+SKR','68.37',420),
 (422,'59','59','68.27',NULL),
 (423,'60','60','69.62',NULL),
 (424,'23Y-2','23Y+ELSR','38.03',NULL),
 (425,'23Y-5','23Y+SR','37.04',NULL),
 (426,'4-5','4+SR','26.48',34),
 (427,'34-E1','34+E1','43.48',277),
 (428,'52-7','52+SR80','62.20',400),
 (429,'56-2','56+ELSR','68.79',416),
 (430,'EA1','PM&S EA LVL 1','72.71',NULL),
 (431,'EA1-E1','PM&S EA LVL 1+E1','73.15',430),
 (432,'EA1-E2','PM&S EA LVL 1+E2','75.31',430),
 (433,'EA2','PM&S EA LVL 2','76.77',NULL),
 (434,'EA2-E1','PM&S EA LVL 2+E1','77.20',433),
 (435,'EA2-E2','PM&S EA LVL 2+E2','79.37',433),
 (436,'EA3','PM&S EA LVL 3','82.99',NULL),
 (437,'EA3-E1','PM&S EA LVL 3+E1','83.43',436),
 (438,'EA3-E2','PM&S EA LVL 3+E2','85.59',436),
 (439,'49-5','49+SR','59.47',381);


--
-- Definition of 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=utf8;

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

INSERT INTO `permission_resources` (`id`,`name`,`description`) 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);


--
-- Definition of 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=utf8;

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

INSERT INTO `permission_roles` (`id`,`name`,`description`) 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);


--
-- Definition of 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=50 DEFAULT CHARSET=utf8;

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

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


--
-- Definition of 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=utf8;

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



--
-- Definition of table `traveltime_delegations`
--

CREATE TABLE `traveltime_delegations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `delegator` int(11) NOT NULL,
  `delegatee` int(11) NOT NULL,
  `date_from` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `active` bit(1) DEFAULT b'1',
  PRIMARY KEY (`id`),
  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` (`service_number`),
  CONSTRAINT `traveltime_delegations_ibfk_2` FOREIGN KEY (`delegatee`) REFERENCES `users` (`service_number`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

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

INSERT INTO `traveltime_delegations` (`id`,`delegator`,`delegatee`,`date_from`,`date_to`,`active`) VALUES 
 (1,47187,99935,'2011-10-16','2011-10-18',0x01),
 (3,47187,56367,'2011-10-09','2011-10-26',0x01);


--
-- Definition of 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=utf8;

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

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


--
-- Definition of table `traveltime_managers`
--

CREATE TABLE `traveltime_managers` (
  `service_number` int(11) NOT NULL,
  `cost_centre` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`service_number`),
  KEY `idx_cost_centre` (`cost_centre`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `traveltime_managers` (`service_number`,`cost_centre`) VALUES 
 (49929,'1005'),
 (30538,'101'),
 (46444,'1010'),
 (39803,'104'),
 (49411,'104'),
 (45667,'108'),
 (44967,'111'),
 (48520,'114'),
 (50092,'114'),
 (43852,'115'),
 (30710,'1501'),
 (30001,'1602'),
 (42002,'1602'),
 (39074,'1604'),
 (28598,'1606'),
 (30004,'1606'),
 (43709,'1606'),
 (43788,'1606'),
 (44079,'1606'),
 (47498,'1606'),
 (47748,'1606'),
 (48035,'1606'),
 (40154,'1607'),
 (42357,'1609'),
 (47032,'1609'),
 (42181,'1610'),
 (44599,'1610'),
 (46351,'1610'),
 (21900,'1615'),
 (26654,'1615'),
 (31582,'1615'),
 (36759,'1615'),
 (38886,'1615'),
 (39725,'1615'),
 (40055,'1615'),
 (40864,'1615'),
 (41040,'1615'),
 (41122,'1615'),
 (54170,'1615'),
 (27700,'1617'),
 (46307,'1624'),
 (30270,'1628'),
 (40253,'1628'),
 (42024,'1628'),
 (53342,'1628'),
 (29478,'1629'),
 (39580,'1629'),
 (43352,'1629'),
 (33514,'1630'),
 (34936,'1630'),
 (39713,'1631'),
 (36592,'1632'),
 (37827,'1633'),
 (42731,'1634'),
 (37805,'1636'),
 (34969,'1637'),
 (39073,'1638'),
 (49599,'1638'),
 (49748,'1638'),
 (34475,'1639'),
 (39734,'1639'),
 (35680,'1640'),
 (37779,'1640'),
 (40026,'1640'),
 (35880,'1641'),
 (35997,'1641'),
 (34474,'1642'),
 (35087,'1643'),
 (33423,'1644'),
 (44235,'1646'),
 (45289,'1646'),
 (45364,'1646'),
 (45381,'1646'),
 (45580,'1646'),
 (46056,'1646'),
 (48724,'1646'),
 (49448,'1646'),
 (47760,'1650'),
 (48253,'1651'),
 (45196,'1652'),
 (46010,'1653'),
 (43720,'1659'),
 (44804,'1659'),
 (45898,'1659'),
 (45921,'1659'),
 (45931,'1659'),
 (45971,'1659'),
 (28274,'1663'),
 (47573,'1666'),
 (39730,'1667'),
 (47571,'1667'),
 (46229,'1668'),
 (47311,'1669'),
 (43051,'1701'),
 (43818,'1701'),
 (44639,'1701'),
 (40348,'1706'),
 (42013,'1707'),
 (43439,'1707'),
 (28577,'1709'),
 (32544,'1715'),
 (41399,'1716'),
 (24712,'1717'),
 (45140,'1718'),
 (36820,'1719'),
 (34383,'1724'),
 (45183,'1725'),
 (47761,'1726'),
 (45261,'1730'),
 (46447,'1730'),
 (45212,'1731'),
 (45151,'1732'),
 (45213,'1733'),
 (45164,'1734'),
 (42148,'1740'),
 (40580,'1741'),
 (30719,'1742'),
 (33196,'1743'),
 (46696,'1744'),
 (41963,'1750'),
 (29956,'1751'),
 (33057,'1760'),
 (27732,'1761'),
 (44067,'1761'),
 (27256,'1762'),
 (31563,'1762'),
 (47745,'1762'),
 (44706,'1805'),
 (46665,'1805'),
 (22706,'1809'),
 (55892,'1809'),
 (30993,'1812'),
 (45685,'1812'),
 (22169,'1821'),
 (39810,'1821'),
 (43944,'1821'),
 (46448,'1821'),
 (51783,'1821'),
 (48069,'1831'),
 (49303,'1831'),
 (21393,'1832'),
 (29026,'1832'),
 (42150,'1836'),
 (47815,'1836'),
 (51950,'1836'),
 (45247,'1837'),
 (54900,'1837'),
 (54901,'1837'),
 (44436,'1838'),
 (44425,'1839'),
 (39085,'1842'),
 (48868,'1843'),
 (44164,'1901'),
 (29980,'1911'),
 (40368,'1911'),
 (44285,'1911'),
 (31584,'1912'),
 (47055,'1913'),
 (47750,'1913'),
 (42027,'1915'),
 (24727,'1916'),
 (30396,'1926'),
 (47014,'1926'),
 (50916,'1926'),
 (41870,'1931'),
 (50488,'1931'),
 (40860,'1940'),
 (53241,'1940'),
 (44106,'2001'),
 (47344,'2001'),
 (46175,'2005'),
 (47070,'2006'),
 (45907,'2011'),
 (46079,'2011'),
 (46113,'2011'),
 (46524,'2011'),
 (34158,'2101'),
 (39887,'2101'),
 (43880,'2101'),
 (46845,'2101'),
 (47187,'2101'),
 (47802,'2101'),
 (44035,'2106'),
 (44778,'2106'),
 (37062,'2111'),
 (18713,'2116'),
 (28654,'2117'),
 (24747,'2118'),
 (24784,'2118'),
 (33908,'2118'),
 (38177,'2118'),
 (38242,'2118'),
 (43183,'2118'),
 (47075,'2118'),
 (44679,'2119'),
 (41466,'2124'),
 (47135,'2124'),
 (28505,'2129'),
 (30844,'2129'),
 (42226,'2129'),
 (42017,'2211'),
 (44384,'2222'),
 (47333,'2222'),
 (28638,'2223'),
 (30755,'2223'),
 (38289,'2223'),
 (47785,'2224'),
 (50024,'2224'),
 (33630,'2225'),
 (46109,'2225'),
 (50970,'2225'),
 (16148,'2303'),
 (35058,'2303'),
 (36301,'2303'),
 (39798,'2303'),
 (45737,'2303'),
 (31609,'2502'),
 (39076,'2502'),
 (39885,'2502'),
 (47111,'2503'),
 (29985,'2504'),
 (41393,'2504'),
 (43861,'2504'),
 (46836,'2504'),
 (42141,'2505'),
 (47399,'2506'),
 (42143,'2507'),
 (43098,'2507'),
 (46713,'2507'),
 (48392,'2507'),
 (34081,'2508'),
 (34511,'2508'),
 (46751,'2508'),
 (47293,'2508'),
 (46360,'2509'),
 (50527,'2509'),
 (21389,'2512'),
 (22166,'2514'),
 (28607,'2514'),
 (43129,'2514'),
 (34187,'2516'),
 (44943,'2517'),
 (42046,'2530'),
 (42140,'2530'),
 (45701,'2530'),
 (47012,'2530'),
 (47672,'2530'),
 (48355,'2530'),
 (22971,'2801'),
 (32357,'2801'),
 (48908,'2805'),
 (49417,'2805'),
 (50000,'2805'),
 (44102,'2901'),
 (38775,'3101'),
 (50394,'311'),
 (43926,'315'),
 (47878,'315'),
 (49859,'315'),
 (53247,'315'),
 (53262,'315'),
 (49029,'325'),
 (50078,'325'),
 (51768,'325'),
 (34573,'3306'),
 (45270,'3311'),
 (33259,'3401'),
 (50632,'3401'),
 (33482,'3403'),
 (34778,'3403'),
 (45511,'3404'),
 (31002,'3405'),
 (38908,'3405'),
 (33459,'3406'),
 (45281,'3406'),
 (21014,'3511'),
 (46525,'3518'),
 (26765,'3523'),
 (32304,'3601'),
 (40339,'3607'),
 (48372,'3607'),
 (41058,'3615'),
 (42318,'3615'),
 (49953,'3701'),
 (51162,'3701'),
 (43785,'3710'),
 (34882,'3712'),
 (45150,'3714'),
 (45545,'3714'),
 (39584,'3715'),
 (39820,'3715'),
 (43319,'3715'),
 (47015,'3716'),
 (47263,'3716'),
 (26809,'3717'),
 (34992,'3717'),
 (39825,'3717'),
 (40731,'3717'),
 (41437,'3717'),
 (44393,'3717'),
 (45241,'3717'),
 (55386,'3718'),
 (44429,'3801'),
 (46703,'402'),
 (51532,'402'),
 (44336,'4301'),
 (44684,'4301'),
 (44924,'4301'),
 (45820,'4301'),
 (45821,'4301'),
 (46390,'4301'),
 (46537,'4301'),
 (46997,'4301'),
 (47437,'4301'),
 (48878,'4301'),
 (51531,'4301'),
 (51795,'4301'),
 (53578,'4301'),
 (54715,'4301'),
 (55783,'4301'),
 (40212,'4302'),
 (40904,'4302'),
 (42707,'4302'),
 (44892,'4305'),
 (47797,'4306'),
 (48364,'4307'),
 (50738,'4309'),
 (53622,'4309'),
 (44134,'4310'),
 (44616,'4310'),
 (48857,'4310'),
 (48886,'4310'),
 (52872,'4310'),
 (53674,'4310'),
 (54230,'4310'),
 (44013,'4315'),
 (46940,'4315'),
 (44424,'4318'),
 (51007,'4322'),
 (53513,'4322'),
 (47495,'4331'),
 (36982,'4505'),
 (31451,'4508'),
 (32384,'4508'),
 (41440,'4508'),
 (47095,'4508'),
 (46526,'4509'),
 (47090,'4509'),
 (39921,'4510'),
 (47201,'4510'),
 (49423,'4510'),
 (46748,'4511'),
 (55998,'4511'),
 (30717,'4520'),
 (38194,'4521'),
 (46419,'4521'),
 (48046,'4521'),
 (47396,'4522'),
 (45738,'4605'),
 (50421,'4605'),
 (41789,'4606'),
 (44084,'4606'),
 (46828,'4606'),
 (47363,'4606'),
 (48020,'4606'),
 (48027,'4606'),
 (44050,'4608'),
 (45029,'4608'),
 (45730,'4608'),
 (47170,'4608'),
 (50568,'4608'),
 (48421,'4610'),
 (30753,'4611'),
 (40723,'4611'),
 (40727,'4611'),
 (42631,'4611'),
 (42652,'4611'),
 (43063,'4611'),
 (43466,'4611'),
 (45290,'4611'),
 (43407,'4613'),
 (47591,'4613'),
 (49412,'4613'),
 (53900,'4613'),
 (54398,'4613'),
 (28149,'4618'),
 (34001,'4618'),
 (43731,'4618'),
 (45654,'4618'),
 (34062,'4621'),
 (42156,'4621'),
 (40395,'4622'),
 (40644,'4634'),
 (40808,'4634'),
 (43423,'4701'),
 (40382,'4702'),
 (52460,'4702'),
 (44942,'4707'),
 (40863,'4708'),
 (36815,'4709'),
 (30158,'4710'),
 (51121,'4710'),
 (44430,'4711'),
 (46666,'4715'),
 (48142,'4715'),
 (28606,'4716'),
 (32588,'4717'),
 (51265,'4717'),
 (29535,'4718'),
 (27459,'4719'),
 (33629,'4720'),
 (46747,'4803'),
 (44590,'4804'),
 (51972,'4805'),
 (46918,'4806'),
 (56372,'4806'),
 (44051,'4808'),
 (49664,'4809'),
 (24774,'4810'),
 (53198,'4810'),
 (44463,'4811'),
 (48660,'4811'),
 (44572,'4813'),
 (51013,'4815'),
 (46726,'4907'),
 (44014,'4909'),
 (44446,'4909'),
 (44783,'4909'),
 (46924,'4909'),
 (46932,'4909'),
 (47309,'4909'),
 (47381,'4909'),
 (46926,'4930'),
 (47360,'4930'),
 (47801,'4930'),
 (52981,'4930'),
 (41068,'4941'),
 (43014,'4950'),
 (48388,'4950'),
 (34132,'4951'),
 (44955,'4951'),
 (45007,'4951'),
 (46393,'4951'),
 (46797,'4951'),
 (46912,'4951'),
 (20750,'5001'),
 (33219,'5002'),
 (26012,'5003'),
 (50991,'5003'),
 (51912,'5003'),
 (30724,'5004'),
 (46715,'5005'),
 (49019,'5010'),
 (49523,'504'),
 (51080,'504'),
 (38599,'506'),
 (43094,'5101'),
 (46202,'5102'),
 (45358,'5103'),
 (43391,'5105'),
 (46123,'5110'),
 (37853,'5211'),
 (47124,'5211'),
 (47125,'5211'),
 (47347,'5211'),
 (47375,'5211'),
 (47597,'5211'),
 (47861,'5211'),
 (49367,'5211'),
 (45422,'5212'),
 (45768,'5212'),
 (45814,'5212'),
 (47126,'5212'),
 (47127,'5212'),
 (47133,'5212'),
 (45770,'5213'),
 (36974,'5300'),
 (40735,'5300'),
 (44781,'5300'),
 (48334,'5300'),
 (48521,'5300'),
 (48616,'5300'),
 (49808,'5300'),
 (41525,'6501'),
 (51834,'6501'),
 (33596,'6601'),
 (55874,'6601'),
 (35064,'6603'),
 (48697,'6603'),
 (45292,'6606'),
 (48042,'6606'),
 (49649,'6607'),
 (50608,'6607'),
 (39075,'6701'),
 (32410,'6710'),
 (34168,'6711'),
 (40032,'6711'),
 (45383,'6711'),
 (48822,'6711'),
 (49245,'6711'),
 (53489,'6711'),
 (46591,'6801'),
 (31607,'6809'),
 (32411,'6809'),
 (32414,'6809'),
 (33606,'6809'),
 (43416,'6809'),
 (46440,'6809'),
 (46724,'6809'),
 (46989,'6809'),
 (49033,'6809'),
 (49267,'6809'),
 (49711,'6809'),
 (52396,'6809'),
 (54132,'6809'),
 (48327,'6810'),
 (31564,'6811'),
 (34060,'6811'),
 (39045,'6811'),
 (39678,'6811'),
 (39727,'6811'),
 (44517,'6811'),
 (44609,'6811'),
 (45792,'6811'),
 (47320,'6811'),
 (48147,'6811'),
 (48423,'6811'),
 (34074,'6812'),
 (46621,'6812'),
 (50081,'6813'),
 (50818,'6814'),
 (54124,'6814'),
 (49574,'6815'),
 (30703,'6901'),
 (47351,'6901'),
 (52849,'6901'),
 (54713,'6901'),
 (49916,'6902'),
 (32412,'6906'),
 (45158,'6906'),
 (46429,'6906'),
 (49271,'6906'),
 (48374,'6907'),
 (43336,'6908'),
 (51568,'6908'),
 (46739,'6909'),
 (50810,'6909'),
 (33593,'6923'),
 (45324,'6923'),
 (51527,'6923'),
 (48358,'6924'),
 (44331,'6925'),
 (51062,'6925'),
 (51835,'6925'),
 (47321,'6926'),
 (47500,'6926'),
 (48905,'6926'),
 (49795,'6926'),
 (50436,'6926'),
 (51109,'6926'),
 (51115,'6926'),
 (51160,'6926'),
 (53197,'6926'),
 (53544,'6926'),
 (53788,'6926'),
 (53789,'6926'),
 (54510,'6926'),
 (54703,'6926'),
 (54807,'6926'),
 (55229,'6926'),
 (55393,'6926'),
 (55433,'6926'),
 (55506,'6926'),
 (56090,'6926'),
 (56367,'6926'),
 (44092,'7015'),
 (45436,'7017'),
 (49956,'7017'),
 (54639,'7017'),
 (38087,'7018'),
 (43666,'7101'),
 (46738,'7101'),
 (33689,'7102'),
 (44673,'7102'),
 (45669,'7102'),
 (34769,'7111'),
 (47422,'7111'),
 (53796,'7111'),
 (45628,'7112'),
 (53916,'7112'),
 (43426,'7201'),
 (47136,'7301'),
 (51740,'7302'),
 (53271,'7302'),
 (49647,'7303'),
 (54575,'7305'),
 (38369,'7306'),
 (49710,'7306'),
 (51758,'7306'),
 (53495,'7402'),
 (53875,'7402'),
 (51529,'7405'),
 (53294,'7405'),
 (47203,'7407'),
 (48990,'7407'),
 (51552,'7407'),
 (56084,'7407'),
 (53212,'7408'),
 (47840,'7409'),
 (43028,'7410'),
 (51060,'7410'),
 (31672,'7412'),
 (47343,'7412'),
 (50922,'7413'),
 (52385,'7415'),
 (49421,'7421'),
 (49923,'7421'),
 (53696,'7421'),
 (49924,'7422'),
 (44091,'7424'),
 (43526,'7425'),
 (47058,'7425'),
 (56302,'7429'),
 (26013,'7430'),
 (35129,'7430'),
 (43761,'7430'),
 (43776,'7430'),
 (53251,'7430'),
 (55182,'7430'),
 (45011,'7431'),
 (45121,'7431'),
 (47145,'7431'),
 (54880,'7431'),
 (54966,'7431'),
 (55094,'7431'),
 (50913,'7433'),
 (53770,'7433'),
 (55948,'7440'),
 (48328,'7441'),
 (48698,'7441'),
 (49926,'7451'),
 (51106,'7451'),
 (52058,'7451'),
 (50587,'7452'),
 (50618,'7452'),
 (53567,'7452'),
 (53798,'7452'),
 (44492,'7458'),
 (47876,'7458'),
 (48546,'7458'),
 (52488,'7458'),
 (46745,'7459'),
 (50308,'7459'),
 (55889,'7459'),
 (48400,'7602'),
 (49361,'7602'),
 (49453,'7602'),
 (53913,'7802'),
 (52836,'7806'),
 (43632,'7808'),
 (53181,'7808'),
 (44975,'7809'),
 (53471,'7809'),
 (41803,'7810'),
 (42815,'7810'),
 (51710,'7811'),
 (50838,'7812'),
 (52816,'7814'),
 (51824,'8004'),
 (52524,'8004'),
 (43837,'8501'),
 (47735,'8503'),
 (42993,'8504'),
 (47831,'8504'),
 (30058,'8506'),
 (44263,'8508'),
 (40136,'8518'),
 (47227,'8519'),
 (50442,'8519'),
 (44952,'8524'),
 (49001,'8524'),
 (40165,'8526'),
 (42543,'8526'),
 (45888,'8526'),
 (50927,'8526'),
 (27414,'8528'),
 (47804,'8528'),
 (53673,'8528'),
 (33467,'8531'),
 (44052,'8532'),
 (44886,'8538'),
 (48266,'8542'),
 (48951,'8543'),
 (50598,'8543'),
 (50089,'8546'),
 (53188,'8548'),
 (51628,'8707'),
 (30821,'8713'),
 (50938,'8713'),
 (37487,'9001'),
 (41680,'9001'),
 (47064,'9001'),
 (43927,'9101'),
 (99935,'9102'),
 (46964,'9103'),
 (44794,'9201'),
 (46867,'9201'),
 (49276,'9301'),
 (26169,'9303'),
 (44702,'9502'),
 (48321,'9502'),
 (41403,'9801'),
 (51178,'9801');


--
-- Definition of table `traveltime_payroll_exports`
--

CREATE TABLE `traveltime_payroll_exports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `when_requested` datetime NOT NULL,
  `requester` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_requester` (`requester`),
  CONSTRAINT `traveltime_payroll_exports_ibfk_1` FOREIGN KEY (`requester`) REFERENCES `users` (`service_number`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `traveltime_payroll_exports`
--

INSERT INTO `traveltime_payroll_exports` (`id`,`when_requested`,`requester`) VALUES 
 (1,'2011-10-09 15:46:12',47187);


--
-- Definition of 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,
  `paygrade_rate` decimal(8,2) 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,
  `payroll_export_id` int(11) 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`),
  KEY `fk_export` (`payroll_export_id`),
  CONSTRAINT `traveltime_submission_timedetails_ibfk_1` FOREIGN KEY (`status_changer`) REFERENCES `users` (`service_number`),
  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`),
  CONSTRAINT `traveltime_submission_timedetails_ibfk_5` FOREIGN KEY (`payroll_export_id`) REFERENCES `traveltime_payroll_exports` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8;

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

INSERT INTO `traveltime_submission_timedetails` (`id`,`submission_id`,`travel_day`,`start_time`,`end_time`,`from_suburb`,`to_suburb`,`transport_type`,`duty_type`,`paygrade`,`paygrade_rate`,`acting_other_paygrade`,`status`,`status_changer`,`status_date`,`payroll_export_id`) VALUES 
 (1,3,'2011-09-19','06:00:00','14:30:00','Glebe','Chatswood Depot',1,1,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:09',1),
 (2,3,'2011-09-19','06:00:00','14:30:00','Chatswood Depot','Glebe',1,1,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:09',1),
 (3,3,'2011-09-20','06:00:00','15:30:00','Glebe','North Sydney Depot',2,2,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:09',1),
 (4,3,'2011-09-20','06:00:00','15:30:00','North Sydney Depot','Glebe',2,2,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:09',1),
 (5,3,'2011-09-21','06:00:00','14:30:00','Glebe','Sydney',3,3,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:09',1),
 (6,3,'2011-09-21','06:00:00','14:30:00','Sydney','Glebe',3,3,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:09',1),
 (7,3,'2011-09-22','06:00:00','14:30:00','Glebe','Annandale',4,4,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:09',1),
 (8,3,'2011-09-22','06:00:00','14:30:00','Annandale','Glebe',4,4,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:09',1),
 (9,4,'2011-09-19','06:00:00','15:30:00','Granville','Tuggerah',1,1,NULL,NULL,0x00,1,39713,'2011-09-29 11:12:30',1),
 (10,4,'2011-09-19','06:00:00','15:30:00','Tuggerah','Granville',1,1,NULL,NULL,0x00,1,39713,'2011-09-29 11:12:30',1),
 (11,4,'2011-09-20','07:00:00','16:30:00','Granville','Wollongong',2,2,NULL,NULL,0x00,1,39713,'2011-09-29 11:12:30',1),
 (12,4,'2011-09-20','07:00:00','16:30:00','Wollongong','Granville',2,2,NULL,NULL,0x00,1,39713,'2011-09-29 11:12:30',1),
 (13,4,'2011-09-21','06:00:00','14:30:00','Granville','Katoomba',3,3,NULL,NULL,0x00,1,39713,'2011-09-29 11:12:30',1),
 (14,4,'2011-09-21','06:00:00','14:30:00','Katoomba','Granville',3,3,NULL,NULL,0x00,1,39713,'2011-09-29 11:12:30',1),
 (15,4,'2011-09-22','06:00:00','18:22:00','Granville','Singleton',4,4,NULL,NULL,0x00,1,39713,'2011-09-29 11:12:30',1),
 (16,4,'2011-09-22','06:00:00','18:22:00','Singleton','Granville',4,4,NULL,NULL,0x00,1,39713,'2011-09-29 11:12:30',1),
 (17,5,'2011-09-19','06:00:00','14:56:00','Annandale','Chatswood',1,1,NULL,NULL,0x00,1,47187,'2011-10-09 11:13:34',1),
 (18,5,'2011-09-19','06:00:00','14:56:00','Chatswood','Annandale',1,1,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:20',1),
 (19,5,'2011-09-20','05:00:00','23:00:00','Annandale','Silverwater (auburn)',1,2,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:20',1),
 (20,5,'2011-09-20','05:00:00','23:00:00','Silverwater (auburn)','Annandale',1,2,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:20',1),
 (21,5,'2011-09-22','02:00:00','08:00:00','Annandale','Petersham',2,3,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:20',1),
 (22,5,'2011-09-22','02:00:00','08:00:00','Petersham','Annandale',2,3,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:20',1),
 (23,5,'2011-09-24','06:00:00','11:00:00','Annandale','Penrith',1,4,439,'59.47',0x01,1,39713,'2011-09-29 11:13:20',1),
 (24,5,'2011-09-24','06:00:00','11:00:00','Penrith','Annandale',1,4,439,'59.47',0x01,1,39713,'2011-09-29 11:13:20',1),
 (25,5,'2011-09-25','06:00:00','19:23:00','Annandale','Wollongong',2,4,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:20',1),
 (26,5,'2011-09-25','06:00:00','19:23:00','Wollongong','Annandale',2,4,NULL,NULL,0x00,1,39713,'2011-09-29 11:13:20',1),
 (27,6,'2011-09-19','06:00:00','14:00:00','Penrith','Silverwater (auburn)',1,1,384,'59.66',0x01,1,39713,'2011-09-29 11:12:22',1),
 (28,6,'2011-09-19','06:00:00','14:00:00','Silverwater (auburn)','Penrith',1,1,384,'59.66',0x01,1,39713,'2011-09-29 11:12:22',1),
 (29,6,'2011-09-21','06:00:00','12:00:00','Penrith','Silverwater (auburn)',1,2,390,'60.65',0x01,1,39713,'2011-09-29 11:12:22',1),
 (30,6,'2011-09-21','06:00:00','12:00:00','Silverwater (auburn)','Penrith',1,2,390,'60.65',0x01,1,39713,'2011-09-29 11:12:22',1),
 (31,6,'2011-09-23','06:00:00','14:00:00','Penrith','Chipping Norton',3,3,206,'36.62',0x01,1,39713,'2011-09-29 11:12:22',1),
 (32,6,'2011-09-23','06:00:00','14:00:00','Chipping Norton','Penrith',3,3,206,'36.62',0x01,1,39713,'2011-09-29 11:12:22',1),
 (33,6,'2011-09-24','06:00:00','14:00:00','Penrith','Silverwater (auburn)',4,4,427,'43.48',0x01,1,39713,'2011-09-29 11:12:22',1),
 (34,6,'2011-09-24','06:00:00','14:00:00','Silverwater (auburn)','Penrith',4,4,427,'43.48',0x01,1,39713,'2011-09-29 11:12:22',1),
 (35,6,'2011-09-25','06:00:00','14:00:00','Penrith','Revesby Heights',1,4,50,'28.03',0x01,1,39713,'2011-09-29 11:12:22',1),
 (36,6,'2011-09-25','06:00:00','14:00:00','Revesby Heights','Penrith',1,4,50,'28.03',0x01,1,39713,'2011-09-29 11:12:22',1),
 (37,7,'2011-09-19','06:00:00','16:00:00','Leichhardt','Chatswood Depot',2,2,NULL,NULL,0x01,NULL,NULL,NULL,NULL),
 (38,7,'2011-09-19','06:00:00','16:00:00','Chatswood Depot','Leichhardt',2,2,NULL,NULL,0x01,NULL,NULL,NULL,NULL),
 (39,7,'2011-09-24','07:00:00','15:30:00','Leichhardt','Pymble Depot',3,2,NULL,NULL,0x00,NULL,NULL,NULL,NULL),
 (40,7,'2011-09-24','07:00:00','15:30:00','Pymble Depot','Leichhardt',3,2,NULL,NULL,0x00,NULL,NULL,NULL,NULL),
 (41,8,'2011-09-19','06:00:00','17:30:00','Leichhardt','Chatswood Depot',1,2,NULL,NULL,0x00,NULL,NULL,NULL,NULL),
 (42,8,'2011-09-19','06:00:00','17:30:00','Chatswood Depot','Leichhardt',1,2,NULL,NULL,0x00,NULL,NULL,NULL,NULL),
 (43,8,'2011-09-24','08:00:00','15:30:00','Glebe','Pymble Depot',2,1,NULL,NULL,0x00,NULL,NULL,NULL,NULL),
 (44,8,'2011-09-24','08:00:00','15:30:00','Pymble Depot','Glebe',2,1,NULL,NULL,0x00,NULL,NULL,NULL,NULL),
 (45,9,'2011-09-19','07:00:00','17:00:00','Leichhardt','Chatswood Depot',1,2,NULL,NULL,0x00,NULL,NULL,NULL,NULL),
 (46,9,'2011-09-19','07:00:00','17:00:00','Chatswood Depot','Leichhardt',1,2,NULL,NULL,0x00,NULL,NULL,NULL,NULL),
 (47,9,'2011-09-24','06:00:00','15:30:00','Glebe','Pymble Depot',2,3,NULL,NULL,0x00,NULL,NULL,NULL,NULL),
 (48,9,'2011-09-24','06:00:00','15:30:00','Pymble Depot','Glebe',2,3,NULL,NULL,0x00,NULL,NULL,NULL,NULL),
 (49,10,'2011-09-19','06:00:00','18:00:00','Leichhardt','Chatswood Depot',1,2,NULL,NULL,0x00,NULL,NULL,NULL,NULL),
 (50,10,'2011-09-19','06:00:00','18:00:00','Chatswood Depot','Leichhardt',1,2,NULL,NULL,0x00,NULL,NULL,NULL,NULL),
 (51,11,'2011-09-19','06:30:00','16:30:00','Leichhardt','Chatswood Depot',1,2,NULL,NULL,0x00,NULL,NULL,NULL,NULL),
 (52,11,'2011-09-19','06:30:00','16:30:00','Chatswood Depot','Leichhardt',1,2,NULL,NULL,0x00,NULL,NULL,NULL,NULL);


--
-- Definition of 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_cost_centre` 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` (`service_number`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

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

INSERT INTO `traveltime_submissions` (`id`,`submission_date`,`load_id`,`service_number`,`employee_name`,`employee_suburb`,`weekend_sunday`,`manager_id`,`section_cost_centre`) VALUES 
 (3,'2011-09-29 09:38:04',NULL,54070,'Aaron Mcintyre','Glebe','2011-09-25',39713,'Training - 3719'),
 (4,'2011-09-29 10:28:55',NULL,51460,'Matthew Maher','Granville','2011-09-25',39713,'Training - 3719'),
 (5,'2011-09-29 10:39:58',NULL,47263,'Aaron Carter','Annandale','2011-09-25',39713,'Training - 3716'),
 (6,'2011-09-29 11:10:15',NULL,41437,'Graeme Westrup','Penrith','2011-09-25',39713,'Training - 3717'),
 (7,'2011-09-30 08:51:39',NULL,47802,'Matthew Clarke','Leichhardt','2011-09-25',43880,'Business Systems Development - 2101'),
 (8,'2011-09-30 08:55:09',NULL,47802,'Matthew Clarke','Leichhardt','2011-09-25',43880,'Business Systems Development - 2101'),
 (9,'2011-09-30 10:16:02',NULL,47802,'Matthew Clarke','Leichhardt','2011-09-25',43880,'Business Systems Development - 2101'),
 (10,'2011-09-30 13:55:16',NULL,44390,'Anthony Hack','Leichhardt','2011-09-25',39713,'Field Services - 1631'),
 (11,'2011-09-30 14:32:44',NULL,44390,'Anthony Hack','Leichhardt','2011-09-25',39713,'Field Services - 1631');


--
-- Definition of 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=utf8;

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

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


--
-- Definition of table `user_roles`
--

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

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

INSERT INTO `user_roles` (`service_number`,`role_id`) VALUES 
 (16148,1),
 (18713,1),
 (20750,1),
 (21014,1),
 (21389,1),
 (21393,1),
 (21900,1),
 (22166,1),
 (22169,1),
 (22706,1),
 (22971,1),
 (24712,1),
 (24727,1),
 (24747,1),
 (24774,1),
 (24784,1),
 (26012,1),
 (26013,1),
 (26169,1),
 (26654,1),
 (26765,1),
 (26809,1),
 (27256,1),
 (27414,1),
 (27459,1),
 (27700,1),
 (27732,1),
 (28149,1),
 (28274,1),
 (28505,1),
 (28577,1),
 (28598,1),
 (28606,1),
 (28607,1),
 (28638,1),
 (28654,1),
 (29026,1),
 (29478,1),
 (29535,1),
 (29956,1),
 (29980,1),
 (29985,1),
 (30001,1),
 (30004,1),
 (30058,1),
 (30158,1),
 (30270,1),
 (30396,1),
 (30538,1),
 (30703,1),
 (30710,1),
 (30717,1),
 (30719,1),
 (30724,1),
 (30753,1),
 (30755,1),
 (30821,1),
 (30844,1),
 (30993,1),
 (31002,1),
 (31451,1),
 (31563,1),
 (31564,1),
 (31582,1),
 (31584,1),
 (31607,1),
 (31609,1),
 (31672,1),
 (32304,1),
 (32357,1),
 (32384,1),
 (32410,1),
 (32411,1),
 (32412,1),
 (32414,1),
 (32544,1),
 (32588,1),
 (33057,1),
 (33196,1),
 (33219,1),
 (33259,1),
 (33423,1),
 (33459,1),
 (33467,1),
 (33482,1),
 (33514,1),
 (33593,1),
 (33596,1),
 (33606,1),
 (33629,1),
 (33630,1),
 (33689,1),
 (33908,1),
 (34001,1),
 (34060,1),
 (34062,1),
 (34074,1),
 (34081,1),
 (34132,1),
 (34158,1),
 (34168,1),
 (34187,1),
 (34383,1),
 (34474,1),
 (34475,1),
 (34511,1),
 (34573,1),
 (34769,1),
 (34778,1),
 (34882,1),
 (34936,1),
 (34969,1),
 (34992,1),
 (35058,1),
 (35064,1),
 (35087,1),
 (35129,1),
 (35680,1),
 (35880,1),
 (35997,1),
 (36301,1),
 (36592,1),
 (36759,1),
 (36815,1),
 (36820,1),
 (36974,1),
 (36982,1),
 (37062,1),
 (37487,1),
 (37779,1),
 (37805,1),
 (37827,1),
 (37853,1),
 (38087,1),
 (38177,1),
 (38194,1),
 (38242,1),
 (38289,1),
 (38369,1),
 (38599,1),
 (38775,1),
 (38886,1),
 (38908,1),
 (39045,1),
 (39073,1),
 (39074,1),
 (39075,1),
 (39076,1),
 (39085,1),
 (39580,1),
 (39584,1),
 (39678,1),
 (39713,1),
 (39725,1),
 (39727,1),
 (39730,1),
 (39734,1),
 (39798,1),
 (39803,1),
 (39810,1),
 (39820,1),
 (39825,1),
 (39885,1),
 (39921,1),
 (40026,1),
 (40032,1),
 (40055,1),
 (40136,1),
 (40154,1),
 (40165,1),
 (40212,1),
 (40253,1),
 (40339,1),
 (40348,1),
 (40368,1),
 (40382,1),
 (40395,1),
 (40580,1),
 (40644,1),
 (40723,1),
 (40727,1),
 (40731,1),
 (40735,1),
 (40808,1),
 (40860,1),
 (40863,1),
 (40864,1),
 (40904,1),
 (41040,1),
 (41058,1),
 (41068,1),
 (41122,1),
 (41393,1),
 (41399,1),
 (41403,1),
 (41437,1),
 (41440,1),
 (41466,1),
 (41525,1),
 (41680,1),
 (41789,1),
 (41803,1),
 (41870,1),
 (41963,1),
 (42002,1),
 (42013,1),
 (42017,1),
 (42024,1),
 (42027,1),
 (42046,1),
 (42140,1),
 (42141,1),
 (42143,1),
 (42148,1),
 (42150,1),
 (42156,1),
 (42181,1),
 (42226,1),
 (42318,1),
 (42357,1),
 (42543,1),
 (42631,1),
 (42652,1),
 (42707,1),
 (42731,1),
 (42993,1),
 (43014,1),
 (43028,1),
 (43051,1),
 (43063,1),
 (43094,1),
 (43098,1),
 (43129,1),
 (43183,1),
 (43319,1),
 (43336,1),
 (43352,1),
 (43391,1),
 (43407,1),
 (43416,1),
 (43423,1),
 (43426,1),
 (43439,1),
 (43466,1),
 (43526,1),
 (43632,1),
 (43666,1),
 (43709,1),
 (43720,1),
 (43731,1),
 (43761,1),
 (43776,1),
 (43785,1),
 (43788,1),
 (43818,1),
 (43837,1),
 (43852,1),
 (43861,1),
 (43880,1),
 (43926,1),
 (43927,1),
 (43944,1),
 (44013,1),
 (44014,1),
 (44035,1),
 (44050,1),
 (44051,1),
 (44052,1),
 (44067,1),
 (44079,1),
 (44084,1),
 (44091,1),
 (44092,1),
 (44102,1),
 (44106,1),
 (44134,1),
 (44164,1),
 (44235,1),
 (44263,1),
 (44285,1),
 (44331,1),
 (44336,1),
 (44384,1),
 (44393,1),
 (44424,1),
 (44425,1),
 (44429,1),
 (44430,1),
 (44436,1),
 (44446,1),
 (44463,1),
 (44492,1),
 (44517,1),
 (44572,1),
 (44590,1),
 (44599,1),
 (44609,1),
 (44616,1),
 (44639,1),
 (44673,1),
 (44679,1),
 (44684,1),
 (44702,1),
 (44706,1),
 (44778,1),
 (44781,1),
 (44783,1),
 (44794,1),
 (44804,1),
 (44886,1),
 (44892,1),
 (44924,1),
 (44942,1),
 (44943,1),
 (44952,1),
 (44955,1),
 (44967,1),
 (44975,1),
 (45007,1),
 (45011,1),
 (45029,1),
 (45121,1),
 (45140,1),
 (45150,1),
 (45151,1),
 (45158,1),
 (45164,1),
 (45183,1),
 (45196,1),
 (45212,1),
 (45213,1),
 (45241,1),
 (45247,1),
 (45261,1),
 (45270,1),
 (45281,1),
 (45289,1),
 (45290,1),
 (45292,1),
 (45324,1),
 (45358,1),
 (45364,1),
 (45381,1),
 (45383,1),
 (45422,1),
 (45436,1),
 (45511,1),
 (45545,1),
 (45580,1),
 (45628,1),
 (45654,1),
 (45667,1),
 (45669,1),
 (45685,1),
 (45701,1),
 (45730,1),
 (45737,1),
 (45738,1),
 (45768,1),
 (45770,1),
 (45792,1),
 (45814,1),
 (45820,1),
 (45821,1),
 (45888,1),
 (45898,1),
 (45907,1),
 (45921,1),
 (45931,1),
 (45971,1),
 (46010,1),
 (46056,1),
 (46079,1),
 (46109,1),
 (46113,1),
 (46123,1),
 (46175,1),
 (46202,1),
 (46229,1),
 (46307,1),
 (46351,1),
 (46360,1),
 (46390,1),
 (46393,1),
 (46419,1),
 (46429,1),
 (46440,1),
 (46444,1),
 (46447,1),
 (46448,1),
 (46524,1),
 (46525,1),
 (46526,1),
 (46537,1),
 (46591,1),
 (46621,1),
 (46665,1),
 (46666,1),
 (46696,1),
 (46703,1),
 (46713,1),
 (46715,1),
 (46724,1),
 (46726,1),
 (46738,1),
 (46739,1),
 (46745,1),
 (46747,1),
 (46748,1),
 (46751,1),
 (46797,1),
 (46828,1),
 (46836,1),
 (46845,1),
 (46867,1),
 (46912,1),
 (46918,1),
 (46924,1),
 (46926,1),
 (46932,1),
 (46940,1),
 (46964,1),
 (46989,1),
 (46997,1),
 (47012,1),
 (47014,1),
 (47015,1),
 (47032,1),
 (47055,1),
 (47058,1),
 (47064,1),
 (47070,1),
 (47075,1),
 (47090,1),
 (47095,1),
 (47111,1),
 (47124,1),
 (47125,1),
 (47126,1),
 (47127,1),
 (47133,1),
 (47135,1),
 (47136,1),
 (47145,1),
 (47170,1),
 (47201,1),
 (47203,1),
 (47227,1),
 (47263,1),
 (47293,1),
 (47309,1),
 (47311,1),
 (47320,1),
 (47321,1),
 (47333,1),
 (47343,1),
 (47344,1),
 (47347,1),
 (47351,1),
 (47360,1),
 (47363,1),
 (47375,1),
 (47381,1),
 (47396,1),
 (47399,1),
 (47422,1),
 (47437,1),
 (47495,1),
 (47498,1),
 (47500,1),
 (47571,1),
 (47573,1),
 (47591,1),
 (47597,1),
 (47672,1),
 (47735,1),
 (47745,1),
 (47748,1),
 (47750,1),
 (47760,1),
 (47761,1),
 (47785,1),
 (47797,1),
 (47801,1),
 (47804,1),
 (47815,1),
 (47831,1),
 (47840,1),
 (47861,1),
 (47876,1),
 (47878,1),
 (48020,1),
 (48027,1),
 (48035,1),
 (48042,1),
 (48046,1),
 (48069,1),
 (48142,1),
 (48147,1),
 (48253,1),
 (48266,1),
 (48321,1),
 (48327,1),
 (48328,1),
 (48334,1),
 (48355,1),
 (48358,1),
 (48364,1),
 (48372,1),
 (48374,1),
 (48388,1),
 (48392,1),
 (48400,1),
 (48421,1),
 (48423,1),
 (48520,1),
 (48521,1),
 (48546,1),
 (48616,1),
 (48660,1),
 (48697,1),
 (48698,1),
 (48724,1),
 (48822,1),
 (48857,1),
 (48868,1),
 (48878,1),
 (48886,1),
 (48905,1),
 (48908,1),
 (48951,1),
 (48990,1),
 (49001,1),
 (49019,1),
 (49029,1),
 (49033,1),
 (49245,1),
 (49267,1),
 (49271,1),
 (49276,1),
 (49303,1),
 (49361,1),
 (49367,1),
 (49411,1),
 (49412,1),
 (49417,1),
 (49421,1),
 (49423,1),
 (49448,1),
 (49453,1),
 (49523,1),
 (49574,1),
 (49599,1),
 (49647,1),
 (49649,1),
 (49664,1),
 (49710,1),
 (49711,1),
 (49748,1),
 (49795,1),
 (49808,1),
 (49859,1),
 (49916,1),
 (49923,1),
 (49924,1),
 (49926,1),
 (49929,1),
 (49953,1),
 (49956,1),
 (50000,1),
 (50024,1),
 (50078,1),
 (50081,1),
 (50089,1),
 (50092,1),
 (50308,1),
 (50394,1),
 (50421,1),
 (50436,1),
 (50442,1),
 (50488,1),
 (50527,1),
 (50568,1),
 (50587,1),
 (50598,1),
 (50608,1),
 (50618,1),
 (50632,1),
 (50738,1),
 (50810,1),
 (50818,1),
 (50838,1),
 (50913,1),
 (50916,1),
 (50922,1),
 (50927,1),
 (50938,1),
 (50970,1),
 (50991,1),
 (51007,1),
 (51013,1),
 (51060,1),
 (51062,1),
 (51080,1),
 (51106,1),
 (51109,1),
 (51115,1),
 (51121,1),
 (51160,1),
 (51162,1),
 (51178,1),
 (51265,1),
 (51527,1),
 (51529,1),
 (51531,1),
 (51532,1),
 (51552,1),
 (51568,1),
 (51628,1),
 (51710,1),
 (51740,1),
 (51758,1),
 (51768,1),
 (51783,1),
 (51795,1),
 (51824,1),
 (51834,1),
 (51835,1),
 (51912,1),
 (51950,1),
 (51972,1),
 (52058,1),
 (52385,1),
 (52396,1),
 (52460,1),
 (52488,1),
 (52524,1),
 (52816,1),
 (52836,1),
 (52849,1),
 (52872,1),
 (52981,1),
 (53181,1),
 (53188,1),
 (53197,1),
 (53198,1),
 (53212,1),
 (53241,1),
 (53247,1),
 (53251,1),
 (53262,1),
 (53271,1),
 (53294,1),
 (53342,1),
 (53471,1),
 (53489,1),
 (53495,1),
 (53513,1),
 (53544,1),
 (53567,1),
 (53578,1),
 (53622,1),
 (53673,1),
 (53674,1),
 (53696,1),
 (53770,1),
 (53788,1),
 (53789,1),
 (53796,1),
 (53798,1),
 (53875,1),
 (53900,1),
 (53913,1),
 (53916,1),
 (54124,1),
 (54132,1),
 (54170,1),
 (54230,1),
 (54398,1),
 (54510,1),
 (54575,1),
 (54639,1),
 (54703,1),
 (54713,1),
 (54715,1),
 (54807,1),
 (54880,1),
 (54900,1),
 (54901,1),
 (54966,1),
 (55094,1),
 (55182,1),
 (55229,1),
 (55386,1),
 (55393,1),
 (55433,1),
 (55506,1),
 (55783,1),
 (55874,1),
 (55889,1),
 (55892,1),
 (55948,1),
 (55998,1),
 (56084,1),
 (56090,1),
 (56302,1),
 (56367,1),
 (56372,1),
 (99935,1),
 (39887,2),
 (47187,2),
 (47802,2),
 (47187,6),
 (42094,7),
 (42815,7);


--
-- Definition of table `users`
--

CREATE TABLE `users` (
  `service_number` int(11) NOT NULL,
  `first_name` varchar(32) DEFAULT NULL,
  `last_name` varchar(32) DEFAULT NULL,
  `email_addr` varchar(64) DEFAULT NULL,
  `password` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`service_number`),
  KEY `idx_first_name` (`first_name`),
  KEY `idx_last_name` (`last_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `users` (`service_number`,`first_name`,`last_name`,`email_addr`,`password`) VALUES 
 (16148,'John','Ainsworth','jainsworth@ausgrid.com.au',''),
 (18713,'Murray','Taylor','murray_taylor@ausgrid.com.au',''),
 (20750,'Neil','Austen','nausten@ausgrid.com.au',''),
 (21014,'Michael','McHatton','mmchatton@ausgrid.com.au',''),
 (21389,'Henry','Zarth','hzarth@ausgrid.com.au',''),
 (21393,'Michael','Peacock','mpeacock@ausgrid.com.au',''),
 (21900,'Joseph','Duggan','jduggan@ausgrid.com.au','c61d95f807f1c370921ce67728975e888d0e39a8b8c233f20002a19899118b1c'),
 (22166,'Carlo','Vitale','cvitale@ausgrid.com.au',''),
 (22169,'Phil','Hudson','phudson@ausgrid.com.au',''),
 (22706,'Warren','Squire','wsquire@ausgrid.com.au',''),
 (22971,'Frank','Camilleri','fcamilleri@ausgrid.com.au',''),
 (24712,'Phillip','Gallop','pgallop@ausgrid.com.au',''),
 (24727,'Bob','Porter','bporter@ausgrid.com.au','ac2cd4a35fe5d2cf8df552a9ae277eb64f3230df2fb4efd8a26f780a21016ab6'),
 (24747,'John','Allen','jallen@ausgrid.com.au',''),
 (24774,'Roley','Tyrrell','rtyrrell@ausgrid.com.au',''),
 (24784,'Phil','Jenkinson','pjenkins@ausgrid.com.au',''),
 (26012,'Allan','Hopkins','ahopkins@ausgrid.com.au',''),
 (26013,'Bruce','Jacobsen','bjacobse@ausgrid.com.au',''),
 (26169,'Danny','West','dwest@ausgrid.com.au',''),
 (26654,'David','Carter','dcarter@ausgrid.com.au',''),
 (26765,'Glenn','Walker','glennwalker@ausgrid.com.au',''),
 (26809,'Mick','Morrisey','mmorrisey@ausgrid.com.au',''),
 (27256,'Steve','Sutherland','ssutherl@ausgrid.com.au','fde4905a546085869fa33939d292cfc4b76de03dbddfce68e5cebd030cee9a82'),
 (27414,'Gary','Smith','garysmith@ausgrid.com.au',''),
 (27459,'Bob','Ibbotson','bibbotso@ausgrid.com.au',''),
 (27700,'Stephen','Hayward','shayward@ausgrid.com.au',''),
 (27732,'Bob','Philliponi','bphilliponi@ausgrid.com.au','0f7b1c0452e8fb36d2c377d76a6a2cfa67eb3c8e5d0cb4864c1c12011794f819'),
 (28149,'Peter','Navin','pnavin@ausgrid.com.au',''),
 (28274,'Steve','Daniels','sdaniels@ausgrid.com.au',''),
 (28505,'Paul','Strachan','pstrachan@ausgrid.com.au',''),
 (28577,'Barry','Buckley','bbuckley@ausgrid.com.au',''),
 (28598,'Bob','Jones','bjones@ausgrid.com.au','dc723d820af2e84f8f4a1ac403614946a4d1df579bfad60d7d4a9ca61701cf77'),
 (28606,'Chris','Mason','cmason@ausgrid.com.au',''),
 (28607,'John','Mettam','jmettam@ausgrid.com.au',''),
 (28638,'Peter','Adler','padler@ausgrid.com.au',''),
 (28654,'Mark','O\'Sullivan','mark_osullivan@ausgrid.com.au',''),
 (29026,'Dennis','Simpson','dsimpson@ausgrid.com.au',''),
 (29478,'Marshall','Parrott','mparrott@ausgrid.com.au','0061bb958fe9daf5ad191386b9098ed2b61bd9469588152f7f84f91c6637919e'),
 (29535,'Alex','Baird','abaird@ausgrid.com.au','494bbd05a8dda4fc4135f9d96e1caaae56bee6708877fd0145db51c5bc0285e7'),
 (29956,'Charlie','Galea','cgalea@ausgrid.com.au',''),
 (29980,'Paul','Tapp','ptapp@ausgrid.com.au',''),
 (29985,'John','Wigley','jwigley@ausgrid.com.au',''),
 (30001,'Bryn','Berrett','bberrett@ausgrid.com.au',''),
 (30004,'Alan','Martin','amartin@ausgrid.com.au',''),
 (30058,'Geoffrey','Ashton','gashton@ausgrid.com.au',''),
 (30158,'John','Koutsounadis','jkoutsounadis@ausgrid.com.au',''),
 (30270,'Alan','Burgess','aburgess@ausgrid.com.au',''),
 (30396,'John','Barker','jbarker@ausgrid.com.au',''),
 (30538,'Dave','Waterson','dwaterson@ausgrid.com.au',''),
 (30703,'Keith','Newland','knewland@ausgrid.com.au',''),
 (30710,'John','Eisenhuth','jeisenhuth@ausgrid.com.au',''),
 (30717,'Kevin','Carroll','kcarroll@ausgrid.com.au',''),
 (30719,'Steve','Artlett','sartlett@ausgrid.com.au',''),
 (30724,'Paul','Benjamin','pbenjamin@ausgrid.com.au',''),
 (30753,'Chris','McGlynn','cmcglynn@ausgrid.com.au',''),
 (30755,'Steve','Nash','snash@ausgrid.com.au',''),
 (30821,'Phil','Gudmunson','pgudmunson@ausgrid.com.au',''),
 (30844,'Tim','Renshaw','trenshaw@ausgrid.com.au',''),
 (30993,'Chris','Touhill','ctouhill@ausgrid.com.au',''),
 (31002,'Ross','Priday','rpriday@ausgrid.com.au',''),
 (31451,'Noel','Dyer','ndyer@ausgrid.com.au',''),
 (31563,'Geoff','Herd','gherd@ausgrid.com.au','021b1de3b9a8120c001e57d9e66ad5930c0337aea4b795c3a3f3d98f95cc9459'),
 (31564,'Ron','Inch','rinch@ausgrid.com.au',''),
 (31582,'Ian','Purves','ipurves@ausgrid.com.au',''),
 (31584,'Peter','Rigby','prigby@ausgrid.com.au','0c8dfe5b0e526ff06b09ca008942b17effc8d740dbf5b40ef44672353817804b'),
 (31607,'Paul','Howarth','phowarth@ausgrid.com.au',''),
 (31609,'Ian','Whitehurst','iwhitehurst@ausgrid.com.au',''),
 (31672,'David','Cash','dcash@ausgrid.com.au',''),
 (32304,'Martin','O\'Brien','martin_obrien@ausgrid.com.au',''),
 (32357,'John','Cola','jcola@ausgrid.com.au',''),
 (32384,'Michael','Pont','mpont@ausgrid.com.au',''),
 (32410,'John','Hartman','jhartman@ausgrid.com.au',''),
 (32411,'Terry','Fagan','tfagan@ausgrid.com.au',''),
 (32412,'Bob','Cantwell','bcantwell@ausgrid.com.au',''),
 (32414,'Steve','McHardy','smchardy@ausgrid.com.au',''),
 (32544,'Tony','Ams','tams@ausgrid.com.au',''),
 (32588,'John','McInnes','jmcinnes@ausgrid.com.au',''),
 (33057,'Colin','Peacock','cpeacock@ausgrid.com.au',''),
 (33196,'Warren','Artlett','wartlett@ausgrid.com.au',''),
 (33219,'Greg','McKelvey','gmckelvey@ausgrid.com.au','0565e11c3c3d77ea440612db9e246c65c9916ccd56af7a649da6e4f98fddc874'),
 (33259,'Steven','Wilkinson','swilkinson@ausgrid.com.au',''),
 (33423,'Keith','McKeown','kmckeown@ausgrid.com.au','1684823dee24773af13b4d88093858999e53ed65c96c94f0dbd80eb66dff9160'),
 (33459,'Joe','Frare','jfrare@ausgrid.com.au',''),
 (33467,'Charles','Ephraims','cephraims@ausgrid.com.au',''),
 (33482,'Mal','Ellis','mellis@ausgrid.com.au',''),
 (33514,'Bill','Macnaught','bmacnaught@ausgrid.com.au','a8f0bbbd4b8199d46d0bc7232883539f6fab6c9b75f3e3b8aa1ed4c043ba6fee'),
 (33593,'Neil','Gordon','ngordon@ausgrid.com.au',''),
 (33596,'Peter','York','pyork@ausgrid.com.au',''),
 (33606,'Gary','Crawford','gcrawford@ausgrid.com.au',''),
 (33629,'Phillip','Ryan','phillip.ryan@ausgrid.com.au','90bf4eade6e2bc13025f81a49c73470a888a95f6d3424eae0914cba46a39fabf'),
 (33630,'Robert','Sloan','rsloan@ausgrid.com.au',''),
 (33689,'Noel','Cook','ncook@ausgrid.com.au',''),
 (33908,'Peter','Higgs','phiggs@ausgrid.com.au',''),
 (34001,'Colin','Skillicorn','cskillicorn@ausgrid.com.au',''),
 (34060,'Steve','Buncombe','sbuncombe@ausgrid.com.au',''),
 (34062,'Max','Carstedt','mcarstedt@ausgrid.com.au',''),
 (34074,'Phil','Gates','pgates@ausgrid.com.au',''),
 (34081,'Peter','Jarvis','pjarvis@ausgrid.com.au',''),
 (34132,'Greg','Spake','gspake@ausgrid.com.au',''),
 (34158,'Rick','Brown','rick.brown@ausgrid.com.au',''),
 (34168,'Terry','Lampard','tlampard@ausgrid.com.au',''),
 (34187,'Peter','Power','ppower@ausgrid.com.au',''),
 (34383,'Gary','Parker','gparker@ausgrid.com.au',''),
 (34474,'Steve','Cawley','scawley@ausgrid.com.au',''),
 (34475,'Michael','Chapman','michael_chapman@ausgrid.com.au','15bf271614e5a38db8e756036891428f6f07dd045fc0a017d4fffe2f1a8fee6a'),
 (34511,'Peter','Turrin','pturrin@ausgrid.com.au',''),
 (34573,'Wayne','Atkins','watkins@ausgrid.com.au',''),
 (34769,'Carmel','Donnellan','carmeldonnellan@ausgrid.com.au',''),
 (34778,'George','Vella','gvella@ausgrid.com.au',''),
 (34882,'Arthur','Grech','agrech@ausgrid.com.au',''),
 (34936,'Michael','Guerrera','michael.guerrera@ausgrid.com.au',''),
 (34969,'Collin','Smith','collinsmith@ausgrid.com.au','3ce2e6cc059cb65ae6983a0c4cfb79a47c1659e9694b978fe2b9e832e01874bf'),
 (34992,'Greg','Tegart','gtegart@ausgrid.com.au',''),
 (35058,'Martin','Cannon','mcannon@ausgrid.com.au',''),
 (35064,'Peter','Huby','phuby@ausgrid.com.au',''),
 (35087,'Phil','Wilson','pwilson@ausgrid.com.au',''),
 (35129,'Mick','Ehsman','mehsman@ausgrid.com.au',''),
 (35680,'Martin','Campbell','mcampbell@ausgrid.com.au','c39c24941fa8cdd9f45a65ef09b1130960b97698276890405544721a660008fb'),
 (35880,'Rob','North','rnorth@ausgrid.com.au','b4305576b5ff248323a66d709c4950546fd681de411bdda927ba84f76fb0ac8a'),
 (35997,'Bruce','Wilson','brucewilson@ausgrid.com.au',''),
 (36301,'Guy','Grunwald','guygrunwald@ausgrid.com.au',''),
 (36592,'Col','Steell','csteell@ausgrid.com.au','bbdf122554fcc33062fc8ca089f1909e42cbaacb36604fdaac404cb0c3e86074'),
 (36759,'John','Bristow','jbristow@ausgrid.com.au','8aaa5e58acc4b08a0a64bb21585f772f6800888bc54170a451c5507ad17b214c'),
 (36815,'Lloyd','Cuerel','lcuerel@ausgrid.com.au',''),
 (36820,'Stephen','Davis','stephen.davis@ausgrid.com.au',''),
 (36974,'Chris','Hunter','chunter@ausgrid.com.au',''),
 (36982,'Lynton','Jamieson','ljamieson@ausgrid.com.au',''),
 (37062,'Margaret','Hinds','mhinds@ausgrid.com.au',''),
 (37487,'Noel','Kean','nkean@ausgrid.com.au',''),
 (37779,'John','Pearson','jpearson@ausgrid.com.au',''),
 (37805,'Trevor','Moss','tmoss@ausgrid.com.au','ff5f7830eecb850e5cc278c29866c84fffa0d8a41b9cc2570fa556cd84fd536e'),
 (37827,'Adam','Gaebel','agaebel@ausgrid.com.au','65db536d7559db8f158391456813810712b5a6bde6857df14c054f351f0817d8'),
 (37853,'Julie','Brasher','jbrasher@ausgrid.com.au',''),
 (38087,'Phil','McKee','pmckee@ausgrid.com.au',''),
 (38177,'Craig','Cole','ccole@ausgrid.com.au',''),
 (38194,'Ken','Spake','kspake@ausgrid.com.au',''),
 (38242,'Steven','Lowe','slowe@ausgrid.com.au',''),
 (38289,'Jovan','Gligic','jgligic@ausgrid.com.au',''),
 (38369,'Paul','Beger','pbeger@ausgrid.com.au',''),
 (38599,'Chris','Barry','cbarry@ausgrid.com.au',''),
 (38775,'Walter','Stefani','wstefani@ausgrid.com.au',''),
 (38886,'Paul','Riley','priley@ausgrid.com.au','a343e3c8fbdcb5a871bc29cb529e91329b447ff78d42312c792024290ee5d4be'),
 (38908,'Robert','O\'Connor','ro\'connor@ausgrid.com.au',''),
 (39045,'Nabil','Issa','nissa@ausgrid.com.au',''),
 (39073,'Tom','Wilcox','twilcox@ausgrid.com.au',''),
 (39074,'David','Pengilly','dpengilly@ausgrid.com.au',''),
 (39075,'Craig','Moody','cmoody@ausgrid.com.au',''),
 (39076,'Gary','Keedle','gkeedle@ausgrid.com.au',''),
 (39085,'Peter','Cole','pcole@ausgrid.com.au',''),
 (39580,'Reuben','Stroud','rstroud@ausgrid.com.au',''),
 (39584,'Robert','Allison','rallison@ausgrid.com.au',''),
 (39678,'Amir','Hanna','amirhanna@ausgrid.com.au',''),
 (39713,'John B','Casey','matthew.clarke@ausgrid.com.au','951c9763668c63320b10c89444a2c5510bbd02e8cde71811f293950461f7aba8'),
 (39725,'Jeff','Graham','jgraham@ausgrid.com.au',''),
 (39727,'John','Hardwick','jhardwick@ausgrid.com.au',''),
 (39730,'Michael','Hudson','mhudson@ausgrid.com.au',''),
 (39734,'Warwick','Kemble','wkemble@ausgrid.com.au',''),
 (39798,'Brett','Hooper','bhooper@ausgrid.com.au',''),
 (39803,'Peter','Murray','pmurray@ausgrid.com.au',''),
 (39810,'Rick','Dunstan','rick.dunstan@ausgrid.com.au',''),
 (39820,'Shane','Rogers','srogers@ausgrid.com.au',''),
 (39825,'Bradley','Cahill','bcahill@ausgrid.com.au',''),
 (39885,'Michael','Taylor','mtaylor@ausgrid.com.au',''),
 (39887,'Peter','Terry','pterry@ausgrid.com.au','6cb7165687fb8f0bd51e29651723a22d5b839d9ea5b3ef9701012c9b1806bfce'),
 (39921,'Grant','Hooper','ghooper@ausgrid.com.au',''),
 (40026,'Gregory','Sturgess','gsturges@ausgrid.com.au',''),
 (40032,'Brett','Grenfell','bgrenfell@ausgrid.com.au',''),
 (40055,'Bob','Bedford','bbedford@ausgrid.com.au','ca7810f343690ef67b8ced57e1606e19c3a4b33247888e17a800c41b4c015d87'),
 (40136,'Donna','Welch','dwelch@ausgrid.com.au',''),
 (40154,'Stuart','Cregan','scregan@ausgrid.com.au','8e49d19e44c3583d1e012a5872a0b1c581a472b76a547d1060cbb7f391a00876'),
 (40165,'Tim','Graham','tgraham@ausgrid.com.au',''),
 (40212,'Darren','Powell','dpowell@ausgrid.com.au',''),
 (40253,'Peter','Gledhill','pgledhill@ausgrid.com.au',''),
 (40339,'Greg','Moore','gmoore@ausgrid.com.au',''),
 (40348,'John','Vaartjes','jvaartjes@ausgrid.com.au',''),
 (40368,'Phil','Harlum','pharlum@ausgrid.com.au',''),
 (40382,'David','Twigg','dtwigg@ausgrid.com.au',''),
 (40395,'John','Diong','jdiong@ausgrid.com.au',''),
 (40580,'Roman','Kielich','rkielich@ausgrid.com.au',''),
 (40644,'Lee','Coleman','lcoleman@ausgrid.com.au',''),
 (40723,'Paul','Dickson','pdickson@ausgrid.com.au',''),
 (40727,'Kurt','Filipitsch','kfilipitsch@ausgrid.com.au',''),
 (40731,'Phillip','Harris','pharris@ausgrid.com.au',''),
 (40735,'Nick','Karayannis','nkarayannis@ausgrid.com.au',''),
 (40808,'Michael','Abdilla','mabdilla@ausgrid.com.au',''),
 (40860,'Con','Hindi','chindi@ausgrid.com.au',''),
 (40863,'John','Menegus','jmenegus@ausgrid.com.au',''),
 (40864,'Neil','Smith','neil.smith@ausgrid.com.au',''),
 (40904,'John K','Sutton','jksutton@ausgrid.com.au',''),
 (41040,'Tony','Doyle','tdoyle@ausgrid.com.au','1d09960a66c2229e675ffa639b0ded8d803448066fa3067695f9191ed9ab7626'),
 (41058,'Grant','Robinson','grobinson@ausgrid.com.au',''),
 (41068,'Michael','Johnson','mjohnson@ausgrid.com.au',''),
 (41122,'Glenn','Ible','gible@ausgrid.com.au','ca3123fd4714760d2eff2682050c7e0fb99e54c60f3ff2dcd455c27b0c4e5641'),
 (41393,'George','Dapas','gdapas@ausgrid.com.au',''),
 (41399,'Peter','Gleeson','pgleeson@ausgrid.com.au',''),
 (41403,'Bill','Hannan','bhannan@ausgrid.com.au',''),
 (41437,'Graeme','Westrup','gwestrup@ausgrid.com.au',''),
 (41440,'Richard','Tangye','richard.tangye@ausgrid.com.au',''),
 (41466,'Tony','Damaso','tdamaso@ausgrid.com.au',''),
 (41525,'Trevor','Armstrong','tarmstrong@ausgrid.com.au',''),
 (41680,'Bruce','Lee','blee@ausgrid.com.au',''),
 (41789,'Kim','Sunjic','ksunjic@ausgrid.com.au',''),
 (41803,'Richard','Pomana','rpomana@ausgrid.com.au',''),
 (41870,'Peter','Barber','pbarber@ausgrid.com.au',''),
 (41963,'Stephen','Lam','slam@ausgrid.com.au',''),
 (42002,'Craig','Penny','cpenny@ausgrid.com.au',''),
 (42013,'Craig','Burton','cburton@ausgrid.com.au',''),
 (42017,'Dave De','Freitas','ddefreitas@ausgrid.com.au',''),
 (42024,'Owen','Giltinan','ogiltinan@ausgrid.com.au',''),
 (42027,'Matthew','Joyce','mjoyce@ausgrid.com.au','63e1d51cc0eb408ddbf9b717908efc50804e73289deab867e0bcd55721952343'),
 (42046,'Peter','Stephanou','pstephanou@ausgrid.com.au',''),
 (42094,'Gerard','Mifsud','gmifsud@ausgrid.com.au','e6aa58fda05186c04c2f04b7b9ffc62f0038df93e593fef58127bf723c3f74c3'),
 (42140,'Peter','Gaudron','pgaudron@ausgrid.com.au',''),
 (42141,'Geoff','Doherty','gdoherty@ausgrid.com.au',''),
 (42143,'Pamela','Henderson','phenderson@ausgrid.com.au',''),
 (42148,'Phil','Ramsay','pramsay@ausgrid.com.au',''),
 (42150,'James','Hart','jhart@ausgrid.com.au',''),
 (42156,'Martin','Mulcahy','mmulcahy@ausgrid.com.au',''),
 (42181,'Brad','Bishop','bbishop@ausgrid.com.au',''),
 (42226,'Shane','Douglas','sdouglas@ausgrid.com.au',''),
 (42318,'Jeffrey','Fountain','jfountain@ausgrid.com.au',''),
 (42357,'David','Larter','dlarter@ausgrid.com.au','17564e24307a78c6f81bf09e4877df619e996332e0195d823b47494797bfb07b'),
 (42543,'Darren','Quinn','dquinn@ausgrid.com.au',''),
 (42631,'Gregory','Field','gjfield@ausgrid.com.au',''),
 (42652,'Dale','Peterson','dpeterson@ausgrid.com.au',''),
 (42707,'Lyndal','Broadhurst','lbroadhurst@ausgrid.com.au',''),
 (42731,'Graham','Marshall','gmarshall@ausgrid.com.au',''),
 (42815,'Brian','Coopman','bcoopman@ausgrid.com.au','2986e1e989eb76252521f960e70006a5eb791ae1fb738d939451171503acb796'),
 (42993,'Jason','Prince','jprince@ausgrid.com.au',''),
 (43014,'Darren','Lewis','dlewis@ausgrid.com.au',''),
 (43028,'Keri','Stehlin','kstehlin@ausgrid.com.au',''),
 (43051,'David','Fisher','dfisher@ausgrid.com.au',''),
 (43063,'Michael','McMaster','mmcmaster@ausgrid.com.au',''),
 (43094,'Matthew','Hindson','mhindson@ausgrid.com.au',''),
 (43098,'Andrew','Vandenbergh','andrewv@ausgrid.com.au',''),
 (43129,'Stephen','Lunn','slunn@ausgrid.com.au',''),
 (43183,'Robert','Brien','rbrien@ausgrid.com.au',''),
 (43319,'Ken','McGuinness','kmcguinn@ausgrid.com.au','e334e45bda7496c65adaf18a7a05e109ed0673cc70dadde0d3703ef5515b6620'),
 (43336,'Mike','Ringland','mringland@ausgrid.com.au',''),
 (43352,'Chris','Balbi','cbalbi@ausgrid.com.au',''),
 (43391,'Steven','Mackie','smackie@ausgrid.com.au','3cfb2ad44208dc30bb4c1cd976cb315273e09b36eb46f0fd1ad1e20040fc7749'),
 (43407,'Robert','Lowe','rlowe@ausgrid.com.au',''),
 (43416,'James','Howard','jhoward@ausgrid.com.au',''),
 (43423,'Jeffrey','Barnsley','jbarnsley@ausgrid.com.au',''),
 (43426,'Teresa Di','Paolo','tdipaolo@ausgrid.com.au',''),
 (43439,'Cesare','Chiodi','cchiodi@ausgrid.com.au',''),
 (43466,'Frank','Storey','fstorey@ausgrid.com.au',''),
 (43526,'John','Newbery','jnewbery@ausgrid.com.au',''),
 (43632,'Llinos','Walters','lwalters@ausgrid.com.au',''),
 (43666,'Rob','Bareham','rbareham@ausgrid.com.au',''),
 (43709,'John','Slender','jslender@ausgrid.com.au',''),
 (43720,'Cindy','Wilks','cwilks@ausgrid.com.au','c664a40a2e1afae440a1b9f51a63957a5a6e6240f4ff7348b93b78a8db350cce'),
 (43731,'Andrew','Harrison','aharrison@ausgrid.com.au',''),
 (43761,'Jennifer','Brown','jbrown@ausgrid.com.au',''),
 (43776,'Cameron','Martlew','cmartlew@ausgrid.com.au',''),
 (43785,'Neil','Denby','ndenby@ausgrid.com.au',''),
 (43788,'Michael','Head','mhead@ausgrid.com.au',''),
 (43818,'Deborah','Young','dyoung@ausgrid.com.au',''),
 (43837,'Fiona','Trussell','ftrussell@ausgrid.com.au',''),
 (43852,'Gabriel','Lee','gqlee@ausgrid.com.au',''),
 (43861,'Kevin','Hamblin','khamblin@ausgrid.com.au',''),
 (43880,'Michael','Tyler','fmoe@ausgrid.com.au',''),
 (43926,'Peter','Hickey','phickey@ausgrid.com.au',''),
 (43927,'Lisa','Maffina','lmaffina@ausgrid.com.au',''),
 (43944,'Katina','Gallen','kgallen@ausgrid.com.au',''),
 (44013,'Chris','Kamarinos','ckamarinos@ausgrid.com.au',''),
 (44014,'Andrew','Leece','aleece@ausgrid.com.au',''),
 (44035,'Geoff','Fletcher','gfletcher@ausgrid.com.au',''),
 (44050,'Peter','Cross','pcross@ausgrid.com.au',''),
 (44051,'Stuart','Whetham','swhetham@ausgrid.com.au',''),
 (44052,'Keith','Brown','kbrown@ausgrid.com.au',''),
 (44067,'Jonathan','Mallin','jmallin@ausgrid.com.au',''),
 (44079,'Luke','White','luke_white@ausgrid.com.au',''),
 (44084,'Ben','Curry','ben_curry@ausgrid.com.au',''),
 (44091,'Craig','Barclay','cbarclay@ausgrid.com.au',''),
 (44092,'Keith','Yates','kyates@ausgrid.com.au',''),
 (44102,'Denis','Shanahan','dshanahan@ausgrid.com.au',''),
 (44106,'David','Barr','dbarr@ausgrid.com.au',''),
 (44134,'Herb','Sapsford','hsapsford@ausgrid.com.au',''),
 (44164,'John','Merlino','jmerlino@ausgrid.com.au',''),
 (44235,'Karmen','Wang','kwang@ausgrid.com.au',''),
 (44263,'Max','Owen','max.owen@ausgrid.com.au',''),
 (44285,'Tony','Boakes','tboakes@ausgrid.com.au',''),
 (44331,'Jeff','Fry','jfry@ausgrid.com.au',''),
 (44336,'Stephanie','Lindsay','slindsay@ausgrid.com.au',''),
 (44384,'Simon','Stewart','simon.stewart@ausgrid.com.au',''),
 (44393,'Andrew','Loukopoulos','aloukopoulos@ausgrid.com.au',''),
 (44424,'Rebecca','Sharp','rsharp@ausgrid.com.au',''),
 (44425,'Glenn','Cooper','glenn.cooper@ausgrid.com.au',''),
 (44429,'Neil','Roberts','nroberts@ausgrid.com.au',''),
 (44430,'Colin','Casha','ccasha@ausgrid.com.au',''),
 (44436,'Ross','Hughes','ross.hughes@ausgrid.com.au',''),
 (44446,'Mario','Sousa','msousa@ausgrid.com.au',''),
 (44463,'Cheryl','Webb','cwebb@ausgrid.com.au',''),
 (44492,'Sean','Dengate','sdengate@ausgrid.com.au',''),
 (44517,'David','Thebridge','dthebrid@ausgrid.com.au',''),
 (44572,'Catherine','Dunlop','cdunlop@ausgrid.com.au',''),
 (44590,'John','Carroll','jcarroll@ausgrid.com.au',''),
 (44599,'Gerry','Markou','gmarkou@ausgrid.com.au',''),
 (44609,'Murray','Chandler','murray.chandler@ausgrid.com.au',''),
 (44616,'Chris','Lianos','clianos@ausgrid.com.au',''),
 (44639,'Sam','Sofi','ssofi@ausgrid.com.au',''),
 (44673,'Joanne','Meek','jmeek@ausgrid.com.au',''),
 (44679,'Leisa','Thompson','lthompson@ausgrid.com.au',''),
 (44684,'Kerri','McCaw','kmccaw@ausgrid.com.au',''),
 (44702,'George','Maltabarow','gmaltaba@ausgrid.com.au',''),
 (44706,'David','Eccles','deccles@ausgrid.com.au',''),
 (44778,'Bob','Keegan','bkeegan@ausgrid.com.au',''),
 (44781,'Susan A','Walton','swalton@ausgrid.com.au',''),
 (44783,'Angela','Jukic','ajukic@ausgrid.com.au',''),
 (44794,'Susan','Bailey','sbailey@ausgrid.com.au',''),
 (44804,'Guy','Munro','gmunro@ausgrid.com.au','973e4935bd455f388eb5925aeea6a820ef429873fd909fa1bd327ddb65105f54'),
 (44886,'Chicko','Abraham','cabraham@ausgrid.com.au',''),
 (44892,'Will','Wylie','wwylie@ausgrid.com.au',''),
 (44924,'Pauline','Roberts','proberts@ausgrid.com.au',''),
 (44942,'Ron','Gill','rgill@ausgrid.com.au',''),
 (44943,'Wade','Cooke','wcooke@ausgrid.com.au',''),
 (44952,'Grant','Greene-Smith','ggreenes@ausgrid.com.au',''),
 (44955,'Megan','Allen','mallen@ausgrid.com.au',''),
 (44967,'Iain','Atkins','iatkins@ausgrid.com.au',''),
 (44975,'Nicole','Lewis','nlewis@ausgrid.com.au',''),
 (45007,'Janine','Cullen','jcullen@ausgrid.com.au',''),
 (45011,'Adam','Jackson','ajackson@ausgrid.com.au',''),
 (45029,'Lisa','Leslie','lleslie@ausgrid.com.au',''),
 (45121,'Russell','Cusack','rcusack@ausgrid.com.au',''),
 (45140,'Bill','Rowney','browney@ausgrid.com.au',''),
 (45150,'Greg','Jaeger','gjaeger@ausgrid.com.au',''),
 (45151,'Greg','Jamieson','gjamieson@ausgrid.com.au','dbf8fac86e9b511b294733339b0453ebbcf40ef2e51d12e37dc11f37dd23c1f2'),
 (45158,'Mick','Gray','mkgray@ausgrid.com.au',''),
 (45164,'Peter','Mateer','pmateer@ausgrid.com.au',''),
 (45183,'Allan','Searl','asearl@ausgrid.com.au',''),
 (45196,'Ron','Prince','rprince@ausgrid.com.au',''),
 (45212,'Peter','Roffey','proffey@ausgrid.com.au',''),
 (45213,'Harry','Bullen','hbullen@ausgrid.com.au',''),
 (45241,'Ken','Bell','kbell@ausgrid.com.au',''),
 (45247,'Bill','Carman','bcarman@ausgrid.com.au',''),
 (45261,'Andrew','Pendlebury','apendlebury@ausgrid.com.au',''),
 (45270,'Martin','Reeves','mreeves@ausgrid.com.au',''),
 (45281,'Alan','Jones','alan.jones@ausgrid.com.au',''),
 (45289,'John','Oswald','joswald@ausgrid.com.au',''),
 (45290,'Steve','Power','spower@ausgrid.com.au',''),
 (45292,'John','Donkin','jdonkin@ausgrid.com.au',''),
 (45324,'Paul','Myors','pmyors@ausgrid.com.au',''),
 (45358,'Col','Pike','col.pike@ausgrid.com.au','8cf40b5374efa9153d5cb362da3e4b1a07e7e3351d4c3f4fb5b7976d0a9f52bc'),
 (45364,'Les','Beacher','lbeacher@ausgrid.com.au',''),
 (45381,'Ed','King','eking@ausgrid.com.au',''),
 (45383,'Derek','Barrie','dbarrie@ausgrid.com.au',''),
 (45422,'Mark','Allan','mallan@ausgrid.com.au',''),
 (45436,'Rob','Baxter','bbaxter@ausgrid.com.au',''),
 (45511,'Darrel','Williams','darrelwilliams@ausgrid.com.au',''),
 (45545,'Trevor','Upton','tupton@ausgrid.com.au','dedcae250522436bd02835c494d41843ead28be7e2d69ca9537547214afad1e3'),
 (45580,'Anthony','Randle','arandle@ausgrid.com.au','57719aba4b0f957463cf5ffedfe4dc5f29ca537f26940db35ad391ba8cc4eb89'),
 (45628,'Greg','Macfarlane','gmacfarlane@ausgrid.com.au',''),
 (45654,'Lynette','Landkauf','llandkauf@ausgrid.com.au',''),
 (45667,'Nicholas','Convery','nconvery@ausgrid.com.au',''),
 (45669,'Doug','Pickering','dpickering@ausgrid.com.au',''),
 (45685,'Christine','Stone','cstone@ausgrid.com.au',''),
 (45701,'Matthew','Jolliffe','mjolliff@ausgrid.com.au',''),
 (45730,'Sharon','Williams','swilliam@ausgrid.com.au',''),
 (45737,'Joanne','Jackson','jjackson@ausgrid.com.au',''),
 (45738,'Adam','Spink','aspink@ausgrid.com.au',''),
 (45768,'Leigh','Ball','lball@ausgrid.com.au',''),
 (45770,'Daniel','Hansen','dhansen@ausgrid.com.au',''),
 (45792,'David','Wilkinson','dwilkins@ausgrid.com.au',''),
 (45814,'Jane','Keevers','jkeevers@ausgrid.com.au',''),
 (45820,'Sharon','Gibbs','sgibbs@ausgrid.com.au',''),
 (45821,'Kathy','Robertson','kathyrobertson@ausgrid.com.au',''),
 (45888,'Paul','McDonald','pmcdonald@ausgrid.com.au',''),
 (45898,'John','Marselos','jmarselos@ausgrid.com.au',''),
 (45907,'Michael','Judge','mjudge@ausgrid.com.au','754e8ca0e5d5be761c6621edfc94aca1bf7688e78908acfc9cd14293c8bc454b'),
 (45921,'Pat','Boyle','pboyle@ausgrid.com.au',''),
 (45931,'Colin','Chapman','cchapman@ausgrid.com.au',''),
 (45971,'Greg','Skinner','gskinner@ausgrid.com.au',''),
 (46010,'Craig','Garbutt','cgarbutt@ausgrid.com.au',''),
 (46056,'Darren','Jenkins','darrenjenkins@ausgrid.com.au',''),
 (46079,'Roley','Gaffney','rgaffney@ausgrid.com.au',''),
 (46109,'Bernie','Daniels','bdaniels@ausgrid.com.au',''),
 (46113,'Geoff','Blyth','gblyth@ausgrid.com.au',''),
 (46123,'Peter','White','peter_white@ausgrid.com.au','4ed8712d7d744cb7f4bce3074f294e83aa89866725c9fd98c0544e95f8c87270'),
 (46175,'Gareth','Fleming','gfleming@ausgrid.com.au',''),
 (46202,'Ian','Hall','ihall@ausgrid.com.au',''),
 (46229,'Aaron','Mahony','amahony@ausgrid.com.au','50ccf501bcda9f55dcceb8afa8b409c97c07eff9aeb0159b348db951bc0dca2a'),
 (46307,'Aaron','Russell','arussell@ausgrid.com.au',''),
 (46351,'Kane','Kennett','kkennett@ausgrid.com.au','3d8cae98d48b2cafd88a657689e1b51ff30c4e888516e1374eb52e9a7c69fbaa'),
 (46360,'Joanne','Johnston','joanne.johnston@ausgrid.com.au',''),
 (46390,'Chelsea','Lenton','clenton@ausgrid.com.au',''),
 (46393,'Mary-Helen','Shorthouse','mshortho@ausgrid.com.au',''),
 (46419,'Nadina','Shepheard','nshephea@ausgrid.com.au',''),
 (46429,'Michael','Steadman','michael.steadman@ausgrid.com.au',''),
 (46440,'Matt','Cooper','mcooper@ausgrid.com.au',''),
 (46444,'Keith','Robertson','keithrobertson@ausgrid.com.au',''),
 (46447,'Ryan','Hudson','ryan.hudson@ausgrid.com.au',''),
 (46448,'Santo','Ragusa','sragusa@ausgrid.com.au',''),
 (46524,'Joanne','Lewis','jlewis@ausgrid.com.au','7809a688ea94df1a969d97b9e3accf626db01b67a7fc7541250ad74d1d6bcb0c'),
 (46525,'George','Kowalski','gkowalski@ausgrid.com.au',''),
 (46526,'Peter','Leate','pleate@ausgrid.com.au',''),
 (46537,'Sarah','Jensen','sjensen@ausgrid.com.au',''),
 (46591,'Peter','Birk','pbirk@ausgrid.com.au',''),
 (46621,'Chris','Amos','camos@ausgrid.com.au',''),
 (46665,'Glenn','Ford','gford@ausgrid.com.au',''),
 (46666,'Cedric','Halforty','chalfort@ausgrid.com.au',''),
 (46696,'Des','Houston','dhouston@ausgrid.com.au',''),
 (46703,'Paul N','Dixon','pdixon2@ausgrid.com.au',''),
 (46713,'Ashwin','Prasad','aprasad@ausgrid.com.au',''),
 (46715,'Jonathan','Hopson','jhopson@ausgrid.com.au',''),
 (46724,'Caroline','Taurany','ctaurany@ausgrid.com.au',''),
 (46726,'Neil','Fathulla','nfathulla@ausgrid.com.au',''),
 (46738,'Martene','Archer','marcher@ausgrid.com.au',''),
 (46739,'Paul','McGlynn','pmcglynn@ausgrid.com.au',''),
 (46745,'Lyndon','Wilkin','lwilkin@ausgrid.com.au',''),
 (46747,'Aaron','Brown','abrown@ausgrid.com.au',''),
 (46748,'Lisa','Bajramovic','lbajramovic@ausgrid.com.au',''),
 (46751,'Darko','Grcev','dgrcev@ausgrid.com.au',''),
 (46797,'Fiona','Roffey','froffey@ausgrid.com.au',''),
 (46828,'Tahana','Collins','tcollins@ausgrid.com.au',''),
 (46836,'Rick','Martin','rmartin@ausgrid.com.au',''),
 (46845,'Bruce','Napper','bnapper@ausgrid.com.au',''),
 (46867,'Bernadette','Reilly','breilly@ausgrid.com.au',''),
 (46912,'Stacey','Turnbull','sturnbul@ausgrid.com.au',''),
 (46918,'Katrina','Mukevski','kmukevski@ausgrid.com.au',''),
 (46924,'Olivera','Petrovska','opetrovska@ausgrid.com.au',''),
 (46926,'Benjamin','Thomas','bthomas@ausgrid.com.au',''),
 (46932,'Terry','Tran','terry.tran@ausgrid.com.au',''),
 (46940,'David I','Williams','dwilliams3@ausgrid.com.au',''),
 (46964,'Simon','Arnold','sarnold@ausgrid.com.au',''),
 (46989,'Mark','Appleton','mappleton@ausgrid.com.au',''),
 (46997,'Roxanne','Brown','rbrown@ausgrid.com.au',''),
 (47012,'Karl','Ghest','kghest@ausgrid.com.au',''),
 (47014,'Luka','Krivacic','lkrivacic@ausgrid.com.au',''),
 (47015,'Tobias','Keating','tkeating1@ausgrid.com.au',''),
 (47032,'Nick','Taylor','ntaylor@ausgrid.com.au',''),
 (47055,'Jason','Wall','jwall@ausgrid.com.au',''),
 (47058,'Keith','Agbohlah','kagbohlah@ausgrid.com.au',''),
 (47064,'Robert','Curtis','rcurtis@ausgrid.com.au',''),
 (47070,'Kristan','Keir','kkeir@ausgrid.com.au','db474c14986ef0d640235861f744d04eb2623036c81cd99c3c69fd9643ff8cae'),
 (47075,'Penny','Angel','pangel@ausgrid.com.au',''),
 (47090,'Frank','Steele','fsteele@ausgrid.com.au',''),
 (47095,'Paul','Mackenzie','pmackenz@ausgrid.com.au',''),
 (47111,'Paul','Hartley','phartley@ausgrid.com.au',''),
 (47124,'Nigel','McComb','nmccomb@ausgrid.com.au',''),
 (47125,'Darren','Bird','dbird@ausgrid.com.au',''),
 (47126,'Kathy','Roth','kroth@ausgrid.com.au',''),
 (47127,'Paul','Bull','pbull@ausgrid.com.au',''),
 (47133,'Peter','Bryan','pbryan@ausgrid.com.au',''),
 (47135,'Geoff','Staples','gstaples@ausgrid.com.au',''),
 (47136,'Catherine','O\'Neill','coneill@ausgrid.com.au',''),
 (47145,'Alex','Klujin','aklujin@ausgrid.com.au',''),
 (47170,'Mitchell','Ockerby','mockerby@ausgrid.com.au',''),
 (47187,'Field','Moe','fmoe@ausgrid.com.au','fb713c21e41eb734eaec5801f9283023512bd941d30fd113cecf3ddc786942f7'),
 (47201,'Tim','Harmey','tharmey@ausgrid.com.au',''),
 (47203,'Jenny','Bacani','jbacani@ausgrid.com.au',''),
 (47227,'Ian','Packman','ipackman@ausgrid.com.au',''),
 (47263,'Aaron','Carter','acarter@ausgrid.com.au',''),
 (47293,'Neil','O\'Kelly','nokelly@ausgrid.com.au',''),
 (47309,'Ross','McAlpine','rmcalpine@ausgrid.com.au',''),
 (47311,'Stephen','Burns','sburns@ausgrid.com.au','8c7d0cde81e36082073f67a95e0797a0c8b77a24419ce5b1a925a2e0def46776'),
 (47320,'Alex','Dean','adean@ausgrid.com.au',''),
 (47321,'Daniel','Burke','dburke@ausgrid.com.au',''),
 (47333,'Mark','Stace','mstace@ausgrid.com.au',''),
 (47343,'Ron','Menner','rmenner@ausgrid.com.au',''),
 (47344,'Anthony','Fahey','afahey@ausgrid.com.au',''),
 (47347,'Ian','Morris','imorris@ausgrid.com.au',''),
 (47351,'Cassia','Flynn','cflynn@ausgrid.com.au',''),
 (47360,'Geetha','Rajendran','grajendr@ausgrid.com.au',''),
 (47363,'Anu','Dhiwaharan','adhiwaha@ausgrid.com.au',''),
 (47375,'Saizad','Ali','sali@ausgrid.com.au',''),
 (47381,'Adrian','Turner','aturner1@ausgrid.com.au',''),
 (47396,'Nancy','Livrinik','nlivrini@ausgrid.com.au',''),
 (47399,'Asoka','Subhawickrama','asubhawi@ausgrid.com.au',''),
 (47422,'Phillip','Hall','phall@ausgrid.com.au',''),
 (47437,'Rachael','Morante','rmorante@ausgrid.com.au',''),
 (47495,'Jim','Johnston','jjohnston@ausgrid.com.au',''),
 (47498,'Anosh','Prasad','anosh.prasad@ausgrid.com.au',''),
 (47500,'Adrian','Clark','adrian.clark@ausgrid.com.au',''),
 (47571,'Jeff','Corcoran','jcorcoran@ausgrid.com.au','c85d8a161cb95be41ce0c18ef9d986466d06b4dc1a228ee5b633b88e542d762e'),
 (47573,'David','Hedger','dhedger@ausgrid.com.au',''),
 (47591,'Bradley Lan','Kam','blankam@ausgrid.com.au',''),
 (47597,'Mark','Barclay','mbarclay@ausgrid.com.au',''),
 (47672,'Aaron','Ashe','aashe@ausgrid.com.au',''),
 (47735,'Christina','Scott','cscott@ausgrid.com.au',''),
 (47745,'Frank','Hodgkinson','fhodgkinson@ausgrid.com.au',''),
 (47748,'Rob','Reid','rob.reid@ausgrid.com.au',''),
 (47750,'Gareth','Tulloch','gtulloch@ausgrid.com.au',''),
 (47760,'Brad','Smith','bradsmith@ausgrid.com.au',''),
 (47761,'Stuart','Donaldson','sdonaldson@ausgrid.com.au',''),
 (47785,'Naresh','Sharma','nsharma@ausgrid.com.au',''),
 (47797,'Jason','Ventrice','jventrice@ausgrid.com.au',''),
 (47801,'Tricia','Pham','tpham@ausgrid.com.au',''),
 (47802,'Matthew','Clarke','matthew.clarke@ausgrid.com.au','b89e034fcb7a5716a1c6acbc114561179a5f0a677f59315a3d388c0cbe00a0de'),
 (47804,'Richard','Parker','richardparker@ausgrid.com.au',''),
 (47815,'Kristy-Lee','Callinan','kcallinan@ausgrid.com.au',''),
 (47831,'Helen','Hickinbottom','hhickinbottom@ausgrid.com.au',''),
 (47840,'Samuel','Lee','samuel.lee@ausgrid.com.au',''),
 (47861,'Rogelio','Paradeza','rparadeza@ausgrid.com.au',''),
 (47876,'Alex','Wong','awong@ausgrid.com.au',''),
 (47878,'Tracey','Hale','thale@ausgrid.com.au',''),
 (48020,'William','Jones','wjones@ausgrid.com.au',''),
 (48027,'Kim','Chea','kchea@ausgrid.com.au',''),
 (48035,'Steve','Taylor','staylor@ausgrid.com.au',''),
 (48042,'Christopher','Migocki','cmigocki@ausgrid.com.au',''),
 (48046,'Karen','Foster','kfoster@ausgrid.com.au',''),
 (48069,'Alan','Turner','aturner@ausgrid.com.au',''),
 (48142,'Stephen','Ashton','sashton@ausgrid.com.au',''),
 (48147,'Gary','Winsor','gwinsor@ausgrid.com.au',''),
 (48253,'Colin','Curry','ccurry@ausgrid.com.au','19e5ec3af16b4442209eb54d3ee468c1a1b326e2677b2c3cbf4914fbd430ba1e'),
 (48266,'Megan','Kingsbury','mkingsbury@ausgrid.com.au',''),
 (48321,'Debra','Ward','dward@ausgrid.com.au',''),
 (48327,'Judith','Meeske','jmeeske@ausgrid.com.au',''),
 (48328,'Melanie','Wilmot','mwilmot@ausgrid.com.au',''),
 (48334,'Ken','Sackville','ksackville@ausgrid.com.au',''),
 (48355,'Elias','Achkar','eachkar@ausgrid.com.au',''),
 (48358,'Melanie','Hodges','mhodges@ausgrid.com.au',''),
 (48364,'Adam','Purcell','apurcell@ausgrid.com.au',''),
 (48372,'Graham','Manuel','gmanuel@ausgrid.com.au',''),
 (48374,'Michael','Walsh','mwalsh@ausgrid.com.au',''),
 (48388,'Natasha','Young','natasha.young@ausgrid.com.au',''),
 (48392,'Wayne','Armstrong','warmstrong@ausgrid.com.au',''),
 (48400,'Kylie','Yates','kylie.yates@ausgrid.com.au',''),
 (48421,'James Von','Stieglitz','jvonstieglitz@ausgrid.com.au',''),
 (48423,'Michael','Lopes','mlopes@ausgrid.com.au',''),
 (48520,'Warwick','Milgate','wmilgate@ausgrid.com.au',''),
 (48521,'Daniel','Manning','daniel.manning@ausgrid.com.au',''),
 (48546,'Mano','Kant','mkant@ausgrid.com.au',''),
 (48616,'Kylie Morton','Bright','kbright@ausgrid.com.au',''),
 (48660,'Rebecca','Greentree','rgreentree@ausgrid.com.au',''),
 (48697,'Mark De','Lacey','mdelacey@ausgrid.com.au',''),
 (48698,'Andrew','Moriarty','amoriarty@ausgrid.com.au',''),
 (48724,'Sunny','Bhasin','sbhasin@ausgrid.com.au',''),
 (48822,'Mark','Thomson','markthomson@ausgrid.com.au',''),
 (48857,'Robert','Tester','rtester@ausgrid.com.au',''),
 (48868,'Robert','Corke','rcorke@ausgrid.com.au',''),
 (48878,'Rebecca','Crittenden','rcrittenden@ausgrid.com.au',''),
 (48886,'Jody','Armadoros','jarmadoros@ausgrid.com.au',''),
 (48905,'James','Tan','jtan@ausgrid.com.au',''),
 (48908,'Michael','Owens','mowens@ausgrid.com.au',''),
 (48951,'Craig','James','craig.james@ausgrid.com.au',''),
 (48990,'Matthew','Ward','mward@ausgrid.com.au',''),
 (49001,'Stephen','Morgan','smorgan@ausgrid.com.au',''),
 (49019,'Timothy','Harwood','tharwood@ausgrid.com.au',''),
 (49029,'Terry','Reid','treid@ausgrid.com.au',''),
 (49033,'John','Hele','jhele@ausgrid.com.au',''),
 (49245,'Michael','Scott','mscott@ausgrid.com.au',''),
 (49267,'Ping','Tan','ptan@ausgrid.com.au',''),
 (49271,'Stephen','Simmonds','ssimmonds@ausgrid.com.au',''),
 (49276,'Sharron','Kennedy','skennedy@ausgrid.com.au',''),
 (49303,'Mark','Bennett','mbennett@ausgrid.com.au',''),
 (49361,'Anthony','O\'Brien','anthony.obrien@ausgrid.com.au',''),
 (49367,'Scott','Carter','scarter@ausgrid.com.au',''),
 (49411,'Vivek','Beri','vberi@ausgrid.com.au',''),
 (49412,'Garry','Jeffery','gjeffery@ausgrid.com.au',''),
 (49417,'Alex','Drakulic','adrakulic@ausgrid.com.au',''),
 (49421,'Edwin','Shaw','eshaw@ausgrid.com.au',''),
 (49423,'Craig','Hersant','chersant@ausgrid.com.au',''),
 (49448,'Adrian','Hussey','ahussey@ausgrid.com.au','bc1c6cf5be89666f2fd8fb3ff187929296ec0715f6a0314000c527459cd5a4c5'),
 (49453,'Jane','Hamilton','jhamilton@ausgrid.com.au',''),
 (49523,'Michelle','Monaghan','mmonaghan@ausgrid.com.au',''),
 (49574,'Paul','Colebourn','pcolebourn@ausgrid.com.au',''),
 (49599,'Jeff','Debono','jdebono@ausgrid.com.au',''),
 (49647,'Brendon','Crown','bcrown@ausgrid.com.au',''),
 (49649,'Gary','Hunter','ghunter@ausgrid.com.au',''),
 (49664,'Rod','Thomas','rthomas@ausgrid.com.au',''),
 (49710,'Jacqueline','Brothers','jbrothers@ausgrid.com.au',''),
 (49711,'Steven','O\'Donnell','so\'donnell@ausgrid.com.au',''),
 (49748,'Stephen','Head','shead@ausgrid.com.au',''),
 (49795,'Phillip','King','pking@ausgrid.com.au',''),
 (49808,'Neil','Purser','npurser@ausgrid.com.au',''),
 (49859,'Penny','Hunt','phunt@ausgrid.com.au',''),
 (49916,'Michael','Munro','mmunro@ausgrid.com.au',''),
 (49923,'Leslie','Franchi','lfranchi@ausgrid.com.au',''),
 (49924,'Nitin','Devikar','ndevikar@ausgrid.com.au',''),
 (49926,'Pradip','Pal','ppal@ausgrid.com.au',''),
 (49929,'Mike','Bailey','mbailey@ausgrid.com.au',''),
 (49953,'Aaron John','Russell','ajrussell@ausgrid.com.au',''),
 (49956,'Kevin','Smith','kevin.smith@ausgrid.com.au',''),
 (50000,'Rob','Schumacher','rschumacher@ausgrid.com.au',''),
 (50024,'Saroj','Samantara','ssamanta@ausgrid.com.au',''),
 (50078,'Drew','Hamilton','dhamilton@ausgrid.com.au',''),
 (50081,'Greg','Harris','greg.harris@ausgrid.com.au',''),
 (50089,'Andrew','Nash','anash@ausgrid.com.au',''),
 (50092,'Murray','Eivers','meivers@ausgrid.com.au',''),
 (50308,'Craig','Hutchinson','chutchinson@ausgrid.com.au',''),
 (50394,'Catherine','Marshall','cmarshall@ausgrid.com.au',''),
 (50421,'Les','Smith','les.smith@ausgrid.com.au',''),
 (50436,'Shannon','Frohlich-Terpstra','sfrohlich@ausgrid.com.au',''),
 (50442,'Kate','Gunton','kgunton@ausgrid.com.au',''),
 (50488,'Stephen','Constable','sconstable@ausgrid.com.au',''),
 (50527,'Taras','Mencinsky','tmencinsky@ausgrid.com.au',''),
 (50568,'Ben','Mallard','bmallard@ausgrid.com.au',''),
 (50587,'Rajesh','Kumar','rajesh.kumar@ausgrid.com.au',''),
 (50598,'Kyla','Sayers','ksayers@ausgrid.com.au',''),
 (50608,'Mark','Round','mround@ausgrid.com.au',''),
 (50618,'Niaz Ur','Rehman','nrehman@ausgrid.com.au',''),
 (50632,'Corban','Bugg','cbugg@ausgrid.com.au',''),
 (50738,'Darren','Sutton','dsutton@ausgrid.com.au',''),
 (50810,'Johan','Grove','jgrove@ausgrid.com.au',''),
 (50818,'Bala','Subramaniam','bsubramaniam@ausgrid.com.au',''),
 (50838,'Andrew','Sill','asill@ausgrid.com.au',''),
 (50913,'Julian','Luton','jluton@ausgrid.com.au',''),
 (50916,'Conal','Doherty','cdoherty@ausgrid.com.au',''),
 (50922,'Scott','Taylor','scott.taylor@ausgrid.com.au',''),
 (50927,'Paul','Ryan','paul.ryan@ausgrid.com.au',''),
 (50938,'Ian','Starrett','istarrett@ausgrid.com.au',''),
 (50970,'Wilma','Penrose','wpenrose@ausgrid.com.au',''),
 (50991,'Terry','McGovern','tmcgovern@ausgrid.com.au',''),
 (51007,'Nathan','Ball','nball@ausgrid.com.au',''),
 (51013,'Rebekah','Oldfield','roldfield@ausgrid.com.au',''),
 (51060,'Natalie','Topouzian','ntopouzian@ausgrid.com.au',''),
 (51062,'Wayne','Thomas','wthomas@ausgrid.com.au',''),
 (51080,'Jane','Mills','jmills@ausgrid.com.au',''),
 (51106,'Samuel Y','Lee','sylee@ausgrid.com.au',''),
 (51109,'Joe','Aglieco','jaglieco@ausgrid.com.au',''),
 (51115,'Ian','Watt','iwatt@ausgrid.com.au',''),
 (51121,'James','Alexander','jamesalexander@ausgrid.com.au',''),
 (51160,'Terry','Daly','tdaly@ausgrid.com.au',''),
 (51162,'Lynnda','Lim-Huynh','llim-huynh@ausgrid.com.au',''),
 (51178,'Lisa','Riordan','lriordan@ausgrid.com.au',''),
 (51265,'Tony','Markoski','tmarkoski@ausgrid.com.au',''),
 (51527,'Craig','Tupper','ctupper@ausgrid.com.au',''),
 (51529,'Stephen','Johnson','stephen.johnson@ausgrid.com.au',''),
 (51531,'Nerida','Gosling','ngosling@ausgrid.com.au',''),
 (51532,'Sean Van','Wyk','svanwyk@ausgrid.com.au',''),
 (51552,'Scott','Edwards','scott.edwards@ausgrid.com.au',''),
 (51568,'Danny','Hui','dhui@ausgrid.com.au',''),
 (51628,'John','Davis','johndavis@ausgrid.com.au',''),
 (51710,'Peter','Farrell','pfarrell@ausgrid.com.au',''),
 (51740,'John','Thomson','john.thomson@ausgrid.com.au',''),
 (51758,'Jason','Smith','jason.smith@ausgrid.com.au',''),
 (51768,'Jonathan','Chapman','jonathan.chapman@ausgrid.com.au',''),
 (51783,'Peter','Eedy','peedy@ausgrid.com.au',''),
 (51795,'Elizabeth','Kelvin','ekelvin@ausgrid.com.au',''),
 (51824,'Jason','Lowe','jlowe@ausgrid.com.au',''),
 (51834,'Eric','Pozorski','epozorski@ausgrid.com.au',''),
 (51835,'Ann','Kelly','annkelly@ausgrid.com.au',''),
 (51912,'Anna','Quinten','aquinten@ausgrid.com.au',''),
 (51950,'Matthew','Gencur','mgencur@ausgrid.com.au',''),
 (51972,'Dana','Cooper','dcooper@ausgrid.com.au',''),
 (52058,'Anthony','Gray','anthony.gray@ausgrid.com.au',''),
 (52385,'Michael','Turner','mturner@ausgrid.com.au',''),
 (52396,'Greg','Strain','gstrain@ausgrid.com.au',''),
 (52460,'Emily','Miller','emiller@ausgrid.com.au',''),
 (52488,'Ashley','McDougall','amcdougall@ausgrid.com.au',''),
 (52524,'Tony','Tarrant','ttarrant@ausgrid.com.au',''),
 (52816,'Tony','Lloyd','tlloyd@ausgrid.com.au',''),
 (52836,'Raelee','Hobson','rhobson@ausgrid.com.au',''),
 (52849,'Mike','Tshaikiwsky','mtshaikiwsky@ausgrid.com.au',''),
 (52872,'Katherine','Shackel','kshackel@ausgrid.com.au',''),
 (52981,'Malcolm','Wood','malcolmwood@ausgrid.com.au',''),
 (53181,'Maree','Slater','mslater@ausgrid.com.au',''),
 (53188,'Daniel','Byrne','dbyrne@ausgrid.com.au',''),
 (53197,'Lauren','Marcellin','lmarcellin@ausgrid.com.au',''),
 (53198,'Craig','Shepherd','cshepherd@ausgrid.com.au',''),
 (53212,'Berta','Bergmann','bbergmann@ausgrid.com.au',''),
 (53241,'Greg','Whitbourn','gwhitbourn@ausgrid.com.au',''),
 (53247,'Emma','Needs','eneeds@ausgrid.com.au',''),
 (53251,'Ian','Westmoreland','iwestmoreland@ausgrid.com.au',''),
 (53262,'Andrew','Pogson','apogson@ausgrid.com.au',''),
 (53271,'Robert','Telford','rtelford@ausgrid.com.au',''),
 (53294,'Mark','Dutch','mdutch@ausgrid.com.au',''),
 (53342,'Dion','Roche','droche@ausgrid.com.au',''),
 (53471,'Scott M','Paine','smpaine@ausgrid.com.au',''),
 (53489,'Andrew','Lloyd','alloyd@ausgrid.com.au',''),
 (53495,'Natalie','Budovsky','nbudovsky@ausgrid.com.au',''),
 (53513,'Melissa','Zamudio','mzamudio@ausgrid.com.au',''),
 (53544,'Jozua','Haumann','jhaumann@ausgrid.com.au',''),
 (53567,'Ahsan','Taqweem','ataqweem@ausgrid.com.au',''),
 (53578,'Angela','Gilmour','agilmour@ausgrid.com.au',''),
 (53622,'Fatima','Bazzi','fbazzi@ausgrid.com.au',''),
 (53673,'Russell','Murdoch','rmurdoch@ausgrid.com.au',''),
 (53674,'Peta','Jurd','pjurd@ausgrid.com.au',''),
 (53696,'Karen','Thornton','kthornton@ausgrid.com.au',''),
 (53770,'Matt','Silvester','msilvester@ausgrid.com.au',''),
 (53788,'Nick','Poulos','npoulos@ausgrid.com.au',''),
 (53789,'Leliza','Manoto','lmanoto@ausgrid.com.au',''),
 (53796,'Rani','Deo','rdeo@ausgrid.com.au',''),
 (53798,'Gary','Stewart','gstewart@ausgrid.com.au',''),
 (53875,'Ross','Matheson','rmatheson@ausgrid.com.au',''),
 (53900,'Erol','Teber','eteber@ausgrid.com.au',''),
 (53913,'Shaun','Soh','ssoh@ausgrid.com.au',''),
 (53916,'Andrew','Macpherson','amacpherson@ausgrid.com.au',''),
 (54124,'Jenny','Lord','jlord@ausgrid.com.au',''),
 (54132,'Neel','Don','ndon@ausgrid.com.au',''),
 (54170,'Terry','Harris','tharris@ausgrid.com.au','29f312927e370794341ed2ef3379eec50c2d11532b49b945522489e709379bfd'),
 (54230,'Kirsty','Grant','kgrant@ausgrid.com.au',''),
 (54398,'Peter','Baehnisch','pbaehnisch@ausgrid.com.au',''),
 (54510,'Matthew','Ritchie','mritchie@ausgrid.com.au',''),
 (54575,'Scott','Wallace','swallace@ausgrid.com.au',''),
 (54639,'John','Duck','jduck@ausgrid.com.au',''),
 (54703,'Len','Solis','lsolis@ausgrid.com.au',''),
 (54713,'Thu','Nguyen','thu.nguyen@ausgrid.com.au',''),
 (54715,'Amba','Walton','awalton@ausgrid.com.au',''),
 (54807,'Peter','Mortimer','pmortimer@ausgrid.com.au',''),
 (54880,'Nina','Genikis','ngenikis@ausgrid.com.au',''),
 (54900,'Lachlan','McKerrow','lmckerrow@ausgrid.com.au',''),
 (54901,'Gordon','McMurray','gmcmurray@ausgrid.com.au',''),
 (54966,'Charlie','Wahhab','cwahhab@ausgrid.com.au',''),
 (55094,'Michael','Channon','mchannon@ausgrid.com.au',''),
 (55182,'Peter','Gilligan','pgilligan@ausgrid.com.au',''),
 (55229,'Baden','Wright','baden.wright@ausgrid.com.au',''),
 (55386,'Shellie','Chapman','shellie.chapman@ausgrid.com.au',''),
 (55393,'Kelvin','Proctor','kproctor@ausgrid.com.au',''),
 (55433,'Veronika','Tothova','vtothova@ausgrid.com.au',''),
 (55506,'Philip','Tuffin','ptuffin@ausgrid.com.au',''),
 (55783,'Todd','Gordon','tgordon@ausgrid.com.au',''),
 (55874,'Brad','Fletcher','bfletcher@ausgrid.com.au',''),
 (55889,'Domenic','Ventura','dventura@ausgrid.com.au',''),
 (55892,'Wayne','Hobden','whobden@ausgrid.com.au',''),
 (55948,'Jason','Warburton','jwarburton@ausgrid.com.au',''),
 (55998,'David','Walsh','dwalsh@ausgrid.com.au',''),
 (56084,'Megan Jane','Hill','mhill@ausgrid.com.au',''),
 (56090,'Jennifer','Favelle','jfavelle@ausgrid.com.au',''),
 (56302,'Braith','Tomlinson','btomlinson@ausgrid.com.au',''),
 (56367,'Gary','Warner','fmoe@ausgrid.com.au','1a8b0c4c3068a4ab3bab6fdc902178fb2abe7a970daa3b8f3498701515d2b1e1'),
 (56372,'Joyti','Sharma','fmoe@ausgrid.com.au','5346b9453331acfa2d0e9a21d09cdcd56b1332349d14a7c6e1b323684fedb27b'),
 (99935,'John','Conde','fmoe@ausgrid.com.au','86779c03479f549a26a2ffc0fd8193f0ba1f089f1cac1c027c57a203101d21dd');




