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





--
-- Create schema somersby_training
--

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

CREATE TABLE `login_codes` (
  `user_service_number` int(11) NOT NULL,
  `code` varchar(64) NOT NULL,
  `valid_until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_service_number`,`code`),
  CONSTRAINT `login_codes_ibfk_1` FOREIGN KEY (`user_service_number`) REFERENCES `users` (`service_number`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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



--
-- 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 DEFAULT CHARSET=latin1;

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



--
-- 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 DEFAULT CHARSET=latin1;

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



--
-- 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 DEFAULT CHARSET=latin1;

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



--
-- Definition of table `room_activities`
--

CREATE TABLE `room_activities` (
  `room_id` int(11) NOT NULL,
  `activity_date` date NOT NULL,
  `activity_name` varchar(255) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`room_id`,`activity_date`),
  CONSTRAINT `room_activities_ibfk_1` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `room_activities`
--

INSERT INTO `room_activities` (`room_id`,`activity_date`,`activity_name`,`created`,`updated`) VALUES 
 (1,'2012-01-23','ESR Initial Training','2012-01-23 14:26:01','0000-00-00 00:00:00'),
 (1,'2012-01-24','SUBS + SWNUGCs','2012-01-23 14:25:30','0000-00-00 00:00:00'),
 (1,'2012-01-25','','2012-01-23 14:27:51','0000-00-00 00:00:00'),
 (1,'2012-02-02','','2012-01-23 14:29:01','0000-00-00 00:00:00'),
 (1,'2012-02-06','These training rooms can be booked through Resource Reservation ','2012-01-24 09:40:13','0000-00-00 00:00:00'),
 (1,'2012-02-07','These training rooms can be booked through Resource Reservation ','2012-01-24 09:40:22','0000-00-00 00:00:00'),
 (1,'2012-02-08','These training rooms can be booked through Resource Reservation ','2012-01-30 07:18:29','0000-00-00 00:00:00'),
 (1,'2012-02-09','These training rooms can be booked through Resource Reservation ','2012-02-06 07:28:38','0000-00-00 00:00:00'),
 (1,'2012-02-10','These training rooms can be booked through Resource Reservation ','2012-02-06 07:28:48','0000-00-00 00:00:00'),
 (1,'2012-02-15','','2012-02-06 15:19:45','0000-00-00 00:00:00'),
 (1,'2012-02-16','Corp HR: OHS IT System ','2012-02-09 13:56:01','0000-00-00 00:00:00'),
 (1,'2012-02-20','ESR Initial (SUBS TRAINING)','2012-01-23 14:30:24','0000-00-00 00:00:00'),
 (1,'2012-02-21','SUBS + SWNUC\'s','2012-01-23 14:30:31','0000-00-00 00:00:00'),
 (1,'2012-02-22','','2012-02-20 07:53:27','0000-00-00 00:00:00'),
 (1,'2012-02-23','','2012-01-23 14:30:52','0000-00-00 00:00:00'),
 (1,'2012-02-27','These training rooms can be booked through Resource Reservation ','2012-02-20 07:54:11','0000-00-00 00:00:00'),
 (1,'2012-02-28','These training rooms can be booked through Resource Reservation ','2012-01-23 14:32:56','0000-00-00 00:00:00'),
 (1,'2012-02-29','These training rooms can be booked through Resource Reservation ','2012-01-23 14:34:02','0000-00-00 00:00:00'),
 (1,'2012-03-01','Be Safe Day','2012-02-06 15:22:13','0000-00-00 00:00:00'),
 (1,'2012-03-02','','2012-02-06 15:21:24','0000-00-00 00:00:00'),
 (1,'2012-03-05','','2012-01-23 14:35:08','0000-00-00 00:00:00'),
 (1,'2012-03-06','These training rooms can be booked through Resource Reservation ','2012-01-23 14:35:15','0000-00-00 00:00:00'),
 (1,'2012-03-07','These training rooms can be booked through Resource Reservation ','2012-01-23 14:35:23','0000-00-00 00:00:00'),
 (1,'2012-03-08','These training rooms can be booked through Resource Reservation ','2012-01-23 14:35:30','0000-00-00 00:00:00'),
 (1,'2012-03-12','These training rooms can be booked through Resource Reservation ','2012-03-06 07:32:30','0000-00-00 00:00:00'),
 (1,'2012-03-13','','2012-01-24 09:41:42','0000-00-00 00:00:00'),
 (1,'2012-03-14','','2012-01-24 09:41:50','0000-00-00 00:00:00'),
 (1,'2012-03-19','','2012-01-23 14:36:09','0000-00-00 00:00:00'),
 (1,'2012-03-22','','2012-03-22 07:47:42','0000-00-00 00:00:00'),
 (1,'2012-03-23','','2012-03-22 18:46:55','0000-00-00 00:00:00'),
 (1,'2012-03-26','2B Assessment held in the training yard','2012-03-26 06:04:42','0000-00-00 00:00:00'),
 (1,'2012-04-02','','2012-03-26 06:15:50','0000-00-00 00:00:00'),
 (1,'2012-04-03','','2012-04-02 12:41:02','0000-00-00 00:00:00'),
 (1,'2012-04-04','','2012-04-02 07:07:24','0000-00-00 00:00:00'),
 (1,'2012-04-05','','2012-04-03 07:10:43','0000-00-00 00:00:00'),
 (1,'2012-04-06','Happy Easter','2012-04-05 06:26:21','0000-00-00 00:00:00'),
 (1,'2012-04-07','Happy Easter','2012-04-05 06:26:43','0000-00-00 00:00:00'),
 (1,'2012-04-08','Happy Easter','2012-04-05 06:27:05','0000-00-00 00:00:00'),
 (1,'2012-04-09','Happy Easter','2012-04-05 06:27:24','0000-00-00 00:00:00'),
 (1,'2012-04-11','','2012-03-29 14:52:58','0000-00-00 00:00:00'),
 (1,'2012-04-16','','2012-01-31 15:00:15','0000-00-00 00:00:00'),
 (1,'2012-04-17','Safety Consultative Group: Quarterly Meeting','2012-02-06 15:24:04','0000-00-00 00:00:00'),
 (1,'2012-04-18','','2012-03-12 09:27:51','0000-00-00 00:00:00'),
 (1,'2012-04-19','','2012-03-12 09:28:10','0000-00-00 00:00:00'),
 (1,'2012-04-24','','2012-03-12 09:28:30','0000-00-00 00:00:00'),
 (1,'2012-04-25','','2012-03-12 09:28:49','0000-00-00 00:00:00'),
 (1,'2012-04-26','','2012-03-12 09:29:01','0000-00-00 00:00:00'),
 (1,'2012-04-27','','2012-04-16 09:47:12','0000-00-00 00:00:00'),
 (1,'2012-04-30','','2012-03-20 15:25:22','0000-00-00 00:00:00'),
 (1,'2012-05-01','Protection Usergroup Meeting','2012-03-12 09:29:19','0000-00-00 00:00:00'),
 (1,'2012-05-02','Owning your Career Training - Part A ','2012-01-31 15:04:30','0000-00-00 00:00:00'),
 (1,'2012-05-03','','2012-03-12 09:30:39','0000-00-00 00:00:00'),
 (1,'2012-05-04','Meeting','2012-03-26 06:11:03','0000-00-00 00:00:00'),
 (1,'2012-05-08','','2012-04-17 07:07:41','0000-00-00 00:00:00'),
 (1,'2012-05-09','Regulatory Training RF0002','2012-03-26 08:59:41','0000-00-00 00:00:00'),
 (1,'2012-05-10','','2012-05-04 09:13:40','0000-00-00 00:00:00'),
 (1,'2012-05-14','','2012-05-09 08:57:15','0000-00-00 00:00:00'),
 (1,'2012-05-15','ESR Initial 1st Day','2012-04-16 09:51:16','0000-00-00 00:00:00'),
 (1,'2012-05-16','','2012-01-31 15:07:16','0000-00-00 00:00:00'),
 (1,'2012-05-17','','2012-04-16 09:52:39','0000-00-00 00:00:00'),
 (1,'2012-05-18','SWNUC\'s ','2012-04-16 09:53:05','0000-00-00 00:00:00'),
 (1,'2012-05-21','Business Continuity Planning Site Visit','2012-01-31 15:00:28','0000-00-00 00:00:00'),
 (1,'2012-05-22','','2012-04-16 09:53:44','0000-00-00 00:00:00'),
 (1,'2012-05-23','','2012-04-16 09:54:11','0000-00-00 00:00:00'),
 (1,'2012-05-24','','2012-05-14 15:42:12','0000-00-00 00:00:00'),
 (1,'2012-05-25','','2012-01-31 15:07:53','0000-00-00 00:00:00'),
 (1,'2012-05-28','RESTRICTED OPERATOR REACCREDITATION TRAINING (Jeff Williams) UMINA & NORAVILLE ROOMS COMBINED','2012-04-16 09:55:20','0000-00-00 00:00:00'),
 (1,'2012-05-29','RESTRICTED OPERATOR REACCREDITATION TRAINING (Jeff Williams) UMINA & NORAVILLE ROOMS COMBINED','2012-04-16 09:55:52','0000-00-00 00:00:00'),
 (1,'2012-05-30','Cancelled RESTRICTED OPERATOR REACCREDITATION TRAINING (Jeff Williams) UMINA & NORAVILLE ROOMS COMBINED','2012-04-16 09:56:22','0000-00-00 00:00:00'),
 (1,'2012-05-31','RESTRICTED OPERATOR REACCREDITATION TRAINING (Jeff Williams) UMINA & NORAVILLE ROOMS COMBINED','2012-04-16 09:56:47','0000-00-00 00:00:00'),
 (1,'2012-06-01','Cancelled RESTRICTED OPERATOR REACCREDITATION TRAINING (Jeff Williams) UMINA & NORAVILLE ROOMS COMBINED','2012-04-16 09:57:13','0000-00-00 00:00:00'),
 (1,'2012-06-04','Review Investigation form','2012-05-29 13:42:14','0000-00-00 00:00:00'),
 (1,'2012-06-05','Protection Testing Group','2012-05-14 15:44:23','0000-00-00 00:00:00'),
 (1,'2012-06-06','','2012-06-05 10:38:02','0000-00-00 00:00:00'),
 (1,'2012-06-07','','2012-04-16 09:57:48','0000-00-00 00:00:00'),
 (1,'2012-06-08','','2012-06-01 08:35:05','0000-00-00 00:00:00'),
 (1,'2012-06-12','','2012-04-16 09:58:17','0000-00-00 00:00:00'),
 (1,'2012-06-13','','2012-05-29 13:45:49','0000-00-00 00:00:00'),
 (1,'2012-06-18','SC1200 Training ESR','2012-01-31 15:00:55','0000-00-00 00:00:00'),
 (1,'2012-06-19','Subs entry Day 2','2012-04-16 09:58:52','0000-00-00 00:00:00'),
 (1,'2012-06-20','Regs Training DAY 3','2012-05-10 11:34:04','0000-00-00 00:00:00'),
 (1,'2012-06-21','Regs Training 4th Day of SC1200','2012-04-16 09:59:12','0000-00-00 00:00:00'),
 (1,'2012-06-25','','2012-06-13 15:01:35','0000-00-00 00:00:00'),
 (1,'2012-06-26','','2012-05-29 13:57:36','0000-00-00 00:00:00'),
 (1,'2012-06-27','','2012-05-29 13:58:11','0000-00-00 00:00:00'),
 (1,'2012-06-28','','2012-05-29 14:04:10','0000-00-00 00:00:00'),
 (1,'2012-06-29','Tech Training Yearly review','2012-02-20 09:27:32','0000-00-00 00:00:00'),
 (1,'2012-07-02','','2012-06-28 15:25:06','0000-00-00 00:00:00'),
 (1,'2012-07-03','Protection Meeting','2012-06-01 08:43:10','0000-00-00 00:00:00'),
 (1,'2012-07-04','','2012-06-13 15:08:22','0000-00-00 00:00:00'),
 (1,'2012-07-05','Training - Andrew Loukopoulos','2012-06-01 08:43:44','0000-00-00 00:00:00'),
 (1,'2012-07-06','','2012-06-28 15:25:48','0000-00-00 00:00:00'),
 (1,'2012-07-11','Owning your Career Training - Part A ','2012-01-31 15:08:30','0000-00-00 00:00:00'),
 (1,'2012-07-12','','2012-03-19 14:31:26','0000-00-00 00:00:00'),
 (1,'2012-07-16','','2012-01-31 15:01:16','0000-00-00 00:00:00'),
 (1,'2012-07-17','','2012-06-27 08:37:30','0000-00-00 00:00:00'),
 (1,'2012-07-18','','2012-06-01 08:45:24','0000-00-00 00:00:00'),
 (1,'2012-07-19','','2012-06-01 08:46:15','0000-00-00 00:00:00'),
 (1,'2012-07-23','','2012-06-01 08:47:06','0000-00-00 00:00:00'),
 (1,'2012-07-24','','2012-06-01 08:47:27','0000-00-00 00:00:00'),
 (1,'2012-07-25','','2012-01-31 15:09:59','0000-00-00 00:00:00'),
 (1,'2012-07-26','','2012-06-01 08:47:57','0000-00-00 00:00:00'),
 (1,'2012-07-27','','2012-06-01 08:48:12','0000-00-00 00:00:00'),
 (1,'2012-07-30','','2012-06-01 08:48:32','0000-00-00 00:00:00'),
 (1,'2012-07-31','','2012-06-01 08:48:48','0000-00-00 00:00:00'),
 (1,'2012-08-01','','2012-06-01 08:49:07','0000-00-00 00:00:00'),
 (1,'2012-08-02','','2012-06-27 08:40:32','0000-00-00 00:00:00'),
 (1,'2012-08-06','Safe Work Aloft Training','2012-06-01 08:49:29','0000-00-00 00:00:00'),
 (1,'2012-08-07','Safe Work Aloft Training','2012-06-01 08:49:45','0000-00-00 00:00:00'),
 (1,'2012-08-08','Ausgrid Protection Testing Group','2012-06-01 08:49:57','0000-00-00 00:00:00'),
 (1,'2012-08-09','','2012-06-01 08:50:11','0000-00-00 00:00:00'),
 (1,'2012-08-10','','2012-06-01 08:50:24','0000-00-00 00:00:00'),
 (1,'2012-08-13','M1574 update meeting','2012-06-01 08:50:40','0000-00-00 00:00:00'),
 (1,'2012-08-14','','2012-06-27 08:43:28','0000-00-00 00:00:00'),
 (1,'2012-08-15','','2012-06-27 08:43:57','0000-00-00 00:00:00'),
 (1,'2012-08-16','','2012-06-27 08:44:39','0000-00-00 00:00:00'),
 (1,'2012-08-20','','2012-01-31 15:01:42','0000-00-00 00:00:00'),
 (1,'2012-08-21','','2012-05-10 12:01:12','0000-00-00 00:00:00'),
 (1,'2012-08-22','','2012-05-10 12:01:50','0000-00-00 00:00:00'),
 (1,'2012-08-23','','2012-07-25 10:11:08','0000-00-00 00:00:00'),
 (1,'2012-08-24','','2012-01-31 15:10:36','0000-00-00 00:00:00'),
 (1,'2012-08-27','Graduate Training Week','2012-06-01 08:51:58','0000-00-00 00:00:00'),
 (1,'2012-08-28','Graduate Training Week','2012-06-01 08:52:23','0000-00-00 00:00:00'),
 (1,'2012-08-29','Graduate Training Week','2012-06-01 08:52:36','0000-00-00 00:00:00'),
 (1,'2012-08-30','Graduate Training Week','2012-06-01 08:52:52','0000-00-00 00:00:00'),
 (1,'2012-08-31','Graduate Training Week','2012-06-01 08:53:07','0000-00-00 00:00:00'),
 (1,'2012-09-04','','2012-07-25 08:17:44','0000-00-00 00:00:00'),
 (1,'2012-09-05','REX Masterclass','2012-07-25 08:18:35','0000-00-00 00:00:00'),
 (1,'2012-09-06','','2012-07-25 08:19:21','0000-00-00 00:00:00'),
 (1,'2012-09-10','','2012-08-06 15:45:36','0000-00-00 00:00:00'),
 (1,'2012-09-11','','2012-07-25 08:19:59','0000-00-00 00:00:00'),
 (1,'2012-09-12','Cable Jointers','2012-07-25 08:20:32','0000-00-00 00:00:00'),
 (1,'2012-09-13','','2012-07-27 15:17:45','0000-00-00 00:00:00'),
 (1,'2012-09-17','','2012-01-31 15:02:01','0000-00-00 00:00:00'),
 (1,'2012-09-18','ESR INITIAL 1ST DAY SC1200','2012-07-30 16:37:52','0000-00-00 00:00:00'),
 (1,'2012-09-19','SUBS ENTRY 2nd DAY SC1200','2012-07-30 16:38:52','0000-00-00 00:00:00'),
 (1,'2012-09-20','Restricted Operator Training ','2012-07-30 16:39:57','0000-00-00 00:00:00'),
 (1,'2012-09-21','SUBS 4th DAY SC1200','2012-07-30 16:40:45','0000-00-00 00:00:00'),
 (1,'2012-09-24','ESR Initial (Subs Training)','2012-08-06 16:03:45','0000-00-00 00:00:00'),
 (1,'2012-09-25','Health & Safety: Site Managers w/K Gillespie','2012-08-23 08:58:51','0000-00-00 00:00:00'),
 (1,'2012-09-26','','2012-08-31 14:18:47','0000-00-00 00:00:00'),
 (1,'2012-09-28','C2 Training - David Hedger\'s Group','2012-09-21 06:24:00','0000-00-00 00:00:00'),
 (1,'2012-10-02','Health & Safety: Site Managers w/K Gillespie','2012-08-23 08:59:41','0000-00-00 00:00:00'),
 (1,'2012-10-03','Booked by Julie Westrup Ext:31573','2012-08-06 16:04:28','0000-00-00 00:00:00'),
 (1,'2012-10-04','Booked by Julie Westrup Ext:31573','2012-08-06 16:04:57','0000-00-00 00:00:00'),
 (1,'2012-10-05','Booked by Julie Westrup Ext:31573','2012-09-21 06:28:26','0000-00-00 00:00:00'),
 (1,'2012-10-08','','2012-09-21 06:30:30','0000-00-00 00:00:00'),
 (1,'2012-10-09','','2012-08-23 09:00:29','0000-00-00 00:00:00'),
 (1,'2012-10-10','','2012-08-06 16:05:48','0000-00-00 00:00:00'),
 (1,'2012-10-11','','2012-09-21 06:32:44','0000-00-00 00:00:00'),
 (1,'2012-10-12','','2012-09-21 06:33:27','0000-00-00 00:00:00'),
 (1,'2012-10-15','','2012-01-31 15:02:22','0000-00-00 00:00:00'),
 (1,'2012-10-16','','2012-08-06 16:33:01','0000-00-00 00:00:00'),
 (1,'2012-10-17','','2012-08-23 09:01:40','0000-00-00 00:00:00'),
 (1,'2012-10-18','','2012-09-21 06:35:20','0000-00-00 00:00:00'),
 (1,'2012-10-19','','2012-10-05 08:30:09','0000-00-00 00:00:00'),
 (1,'2012-10-22','SC1100 - ESR DAY 1','2012-08-31 14:41:24','0000-00-00 00:00:00'),
 (1,'2012-10-23','Health & Safety: Site Managers w/K Gillespie','2012-08-23 09:02:08','0000-00-00 00:00:00'),
 (1,'2012-10-24','SC1100 - SWNUC\'S - DAY3','2012-09-03 07:38:10','0000-00-00 00:00:00'),
 (1,'2012-10-25','Guideline for Live LV work in Distribution Centres - Working Group','2012-09-03 07:38:42','0000-00-00 00:00:00'),
 (1,'2012-10-26','','2012-09-03 07:39:24','0000-00-00 00:00:00'),
 (1,'2012-10-29','SC1200 - ESR - DAY 1','2012-08-06 16:33:43','0000-00-00 00:00:00'),
 (1,'2012-10-30','SC1200 - SUBS ENTRY - DAY 2','2012-08-06 16:34:16','0000-00-00 00:00:00'),
 (1,'2012-10-31','SC1200 - REGS - DAY 3','2012-08-06 16:34:45','0000-00-00 00:00:00'),
 (1,'2012-11-01','SC1200 - SWNUC\'s - DAY 4','2012-07-30 16:49:06','0000-00-00 00:00:00'),
 (1,'2012-11-02','Health & Safety: Site Managers w/K Gillespie','2012-07-30 16:50:04','0000-00-00 00:00:00'),
 (1,'2012-11-05','','2012-03-19 14:33:01','0000-00-00 00:00:00'),
 (1,'2012-11-06','Reg Training - RF0002','2012-03-19 14:33:12','0000-00-00 00:00:00'),
 (1,'2012-11-07','RF0002 - Reg Training Col White','2012-03-19 14:33:28','0000-00-00 00:00:00'),
 (1,'2012-11-08','Reg Training - RF0002 Col White','2012-03-19 14:33:39','0000-00-00 00:00:00'),
 (1,'2012-11-09','','2012-03-19 14:33:54','0000-00-00 00:00:00'),
 (1,'2012-11-12','','2012-03-19 14:34:26','0000-00-00 00:00:00'),
 (1,'2012-11-13','Reg Training - RF0002 Col White','2012-03-19 14:34:36','0000-00-00 00:00:00'),
 (1,'2012-11-14','Reg Training - RF0002 Col White','2012-03-19 14:34:48','0000-00-00 00:00:00'),
 (1,'2012-11-15','Reg Training - RF0002 Col White','2012-03-19 14:35:04','0000-00-00 00:00:00'),
 (1,'2012-11-16','','2012-03-19 14:35:17','0000-00-00 00:00:00'),
 (1,'2012-11-19','','2012-01-31 15:02:44','0000-00-00 00:00:00'),
 (1,'2012-11-20','Reg Training - RF0002 Col White','2012-07-30 16:45:33','0000-00-00 00:00:00'),
 (1,'2012-11-21','Reg Training - RF0002 Col White','2012-07-30 16:46:07','0000-00-00 00:00:00'),
 (1,'2012-11-22','Reg Training - RF0002 Col White','2012-07-30 16:46:39','0000-00-00 00:00:00'),
 (1,'2012-11-23','','2012-10-05 08:43:31','0000-00-00 00:00:00'),
 (1,'2012-11-27','Reg Training - RF0002 Col White','2012-07-30 16:47:09','0000-00-00 00:00:00'),
 (1,'2012-11-28','Reg Training - RF0002 Col White','2012-07-30 16:47:39','0000-00-00 00:00:00'),
 (1,'2012-11-29','','2012-10-05 08:44:27','0000-00-00 00:00:00'),
 (1,'2012-11-30','Reg Training - RF0002 Col White','2012-07-30 16:48:13','0000-00-00 00:00:00'),
 (1,'2012-12-06','','2012-08-06 16:39:48','0000-00-00 00:00:00'),
 (1,'2012-12-17','','2012-01-31 15:03:02','0000-00-00 00:00:00'),
 (1,'2012-12-25','Merry Xmas','2012-08-06 16:40:39','0000-00-00 00:00:00'),
 (2,'2012-01-23','','2012-01-23 14:26:01','0000-00-00 00:00:00'),
 (2,'2012-01-24','','2012-01-23 14:25:30','0000-00-00 00:00:00'),
 (2,'2012-01-25','','2012-01-23 14:27:51','0000-00-00 00:00:00'),
 (2,'2012-02-02','','2012-01-23 14:29:01','0000-00-00 00:00:00'),
 (2,'2012-02-06','','2012-01-24 09:40:13','0000-00-00 00:00:00'),
 (2,'2012-02-07','LVFR (2B) 7am to 3.30pm','2012-01-24 09:40:22','0000-00-00 00:00:00'),
 (2,'2012-02-08',' 	 LVFR (2B) 7am to 3.30pm ','2012-01-30 07:18:29','0000-00-00 00:00:00'),
 (2,'2012-02-09','','2012-02-06 07:28:38','0000-00-00 00:00:00'),
 (2,'2012-02-10','','2012-02-06 07:28:48','0000-00-00 00:00:00'),
 (2,'2012-02-15','','2012-02-06 15:19:45','0000-00-00 00:00:00'),
 (2,'2012-02-16','','2012-02-09 13:56:01','0000-00-00 00:00:00'),
 (2,'2012-02-20','','2012-01-23 14:30:24','0000-00-00 00:00:00'),
 (2,'2012-02-21','','2012-01-23 14:30:31','0000-00-00 00:00:00'),
 (2,'2012-02-22','Validation Meeting - Review Ausgrid\'s WorkCover Compliance Documentation','2012-02-20 07:53:27','0000-00-00 00:00:00'),
 (2,'2012-02-23','','2012-01-23 14:30:52','0000-00-00 00:00:00'),
 (2,'2012-02-27','','2012-02-20 07:54:11','0000-00-00 00:00:00'),
 (2,'2012-02-28','WNPL Practical Training','2012-01-23 14:32:56','0000-00-00 00:00:00'),
 (2,'2012-02-29','','2012-01-23 14:34:02','0000-00-00 00:00:00'),
 (2,'2012-03-01','','2012-02-06 15:22:13','0000-00-00 00:00:00'),
 (2,'2012-03-02','','2012-02-06 15:21:24','0000-00-00 00:00:00'),
 (2,'2012-03-05','','2012-01-23 14:35:08','0000-00-00 00:00:00'),
 (2,'2012-03-06','LVFR (2B) 7am to 3.30pm','2012-01-23 14:35:15','0000-00-00 00:00:00'),
 (2,'2012-03-07','LVFR (2B) 7am to 3.30pm','2012-01-23 14:35:23','0000-00-00 00:00:00'),
 (2,'2012-03-08','','2012-01-23 14:35:30','0000-00-00 00:00:00'),
 (2,'2012-03-12','','2012-03-06 07:32:30','0000-00-00 00:00:00'),
 (2,'2012-03-13','LVFR (2B) 7am to 3.30pm','2012-01-24 09:41:42','0000-00-00 00:00:00'),
 (2,'2012-03-14','LVFR (2B) 7am to 3.30pm','2012-01-24 09:41:50','0000-00-00 00:00:00'),
 (2,'2012-03-19','','2012-01-23 14:36:09','0000-00-00 00:00:00'),
 (2,'2012-03-22','','2012-03-22 07:47:42','0000-00-00 00:00:00'),
 (2,'2012-03-23','','2012-03-22 18:46:55','0000-00-00 00:00:00'),
 (2,'2012-03-26','','2012-03-26 06:04:42','0000-00-00 00:00:00'),
 (2,'2012-04-02','','2012-03-26 06:15:50','0000-00-00 00:00:00'),
 (2,'2012-04-03','Mgmt. Systems Group meeting','2012-04-02 12:41:02','0000-00-00 00:00:00'),
 (2,'2012-04-04','','2012-04-02 07:07:24','0000-00-00 00:00:00'),
 (2,'2012-04-05','','2012-04-03 07:10:43','0000-00-00 00:00:00'),
 (2,'2012-04-06','Happy Easter','2012-04-05 06:26:21','0000-00-00 00:00:00'),
 (2,'2012-04-07','Happy Easter','2012-04-05 06:26:43','0000-00-00 00:00:00'),
 (2,'2012-04-08','Happy Easter','2012-04-05 06:27:05','0000-00-00 00:00:00'),
 (2,'2012-04-09','Happy Easter','2012-04-05 06:27:24','0000-00-00 00:00:00'),
 (2,'2012-04-11','','2012-03-29 14:52:58','0000-00-00 00:00:00'),
 (2,'2012-04-16','','2012-01-31 15:00:15','0000-00-00 00:00:00'),
 (2,'2012-04-17','2B LVFR','2012-02-06 15:24:04','0000-00-00 00:00:00'),
 (2,'2012-04-18','2B LVFR','2012-03-12 09:27:51','0000-00-00 00:00:00'),
 (2,'2012-04-19','','2012-03-12 09:28:10','0000-00-00 00:00:00'),
 (2,'2012-04-24','PDS Review, Section Register Check, Rebrand Check','2012-03-12 09:28:30','0000-00-00 00:00:00'),
 (2,'2012-04-25','','2012-03-12 09:28:49','0000-00-00 00:00:00'),
 (2,'2012-04-26','','2012-03-12 09:29:01','0000-00-00 00:00:00'),
 (2,'2012-04-27','Major Projects Leadership Team Meeting','2012-04-16 09:47:12','0000-00-00 00:00:00'),
 (2,'2012-04-30','','2012-03-20 15:25:22','0000-00-00 00:00:00'),
 (2,'2012-05-01','2B LVFR','2012-03-12 09:29:19','0000-00-00 00:00:00'),
 (2,'2012-05-02','2B LVFR','2012-01-31 15:04:30','0000-00-00 00:00:00'),
 (2,'2012-05-03','Cat 3 Training','2012-03-12 09:30:39','0000-00-00 00:00:00'),
 (2,'2012-05-04','Somersby Training Centre Open day','2012-03-26 06:11:03','0000-00-00 00:00:00'),
 (2,'2012-05-08','2B LVFR','2012-04-17 07:07:41','0000-00-00 00:00:00'),
 (2,'2012-05-09','2B LVFR','2012-03-26 08:59:41','0000-00-00 00:00:00'),
 (2,'2012-05-10','','2012-05-04 09:13:40','0000-00-00 00:00:00'),
 (2,'2012-05-14','2B Low Voltage Fuse Replacement training course update','2012-05-09 08:57:15','0000-00-00 00:00:00'),
 (2,'2012-05-15','2B LVFR','2012-04-16 09:51:16','0000-00-00 00:00:00'),
 (2,'2012-05-16','2B LVFR','2012-01-31 15:07:16','0000-00-00 00:00:00'),
 (2,'2012-05-17','','2012-04-16 09:52:39','0000-00-00 00:00:00'),
 (2,'2012-05-18','','2012-04-16 09:53:05','0000-00-00 00:00:00'),
 (2,'2012-05-21','','2012-01-31 15:00:28','0000-00-00 00:00:00'),
 (2,'2012-05-22','2B LVFR','2012-04-16 09:53:44','0000-00-00 00:00:00'),
 (2,'2012-05-23','2B LVFR','2012-04-16 09:54:11','0000-00-00 00:00:00'),
 (2,'2012-05-24','Validation Meeting: Review Learning Resources for Basic Scaffolding Unit','2012-05-14 15:42:12','0000-00-00 00:00:00'),
 (2,'2012-05-25','','2012-01-31 15:07:53','0000-00-00 00:00:00'),
 (2,'2012-05-28','','2012-04-16 09:55:20','0000-00-00 00:00:00'),
 (2,'2012-05-29','2B LVFR','2012-04-16 09:55:52','0000-00-00 00:00:00'),
 (2,'2012-05-30','2B LVFR','2012-04-16 09:56:22','0000-00-00 00:00:00'),
 (2,'2012-05-31','','2012-04-16 09:56:47','0000-00-00 00:00:00'),
 (2,'2012-06-01','','2012-04-16 09:57:13','0000-00-00 00:00:00'),
 (2,'2012-06-04','','2012-05-29 13:42:14','0000-00-00 00:00:00'),
 (2,'2012-06-05','2B Training','2012-05-14 15:44:23','0000-00-00 00:00:00'),
 (2,'2012-06-06','2B Training','2012-06-05 10:38:02','0000-00-00 00:00:00'),
 (2,'2012-06-07','Audit Preparation - Kate Gillespie (0467 800 360)','2012-04-16 09:57:48','0000-00-00 00:00:00'),
 (2,'2012-06-08','','2012-06-01 08:35:05','0000-00-00 00:00:00'),
 (2,'2012-06-12','','2012-04-16 09:58:17','0000-00-00 00:00:00'),
 (2,'2012-06-13','','2012-05-29 13:45:49','0000-00-00 00:00:00'),
 (2,'2012-06-18','','2012-01-31 15:00:55','0000-00-00 00:00:00'),
 (2,'2012-06-19','Scaffolding Validation Meeting Part 2: Assessment Review','2012-04-16 09:58:52','0000-00-00 00:00:00'),
 (2,'2012-06-20','Interviews','2012-05-10 11:34:04','0000-00-00 00:00:00'),
 (2,'2012-06-21','','2012-04-16 09:59:12','0000-00-00 00:00:00'),
 (2,'2012-06-25','','2012-06-13 15:01:35','0000-00-00 00:00:00'),
 (2,'2012-06-26','2B LVFR training','2012-05-29 13:57:36','0000-00-00 00:00:00'),
 (2,'2012-06-27','2B LVFR training','2012-05-29 13:58:11','0000-00-00 00:00:00'),
 (2,'2012-06-28','','2012-05-29 14:04:10','0000-00-00 00:00:00'),
 (2,'2012-06-29','Tech Training Yearly review','2012-02-20 09:27:32','0000-00-00 00:00:00'),
 (2,'2012-07-02','','2012-06-28 15:25:06','0000-00-00 00:00:00'),
 (2,'2012-07-03','','2012-06-01 08:43:10','0000-00-00 00:00:00'),
 (2,'2012-07-04','','2012-06-13 15:08:22','0000-00-00 00:00:00'),
 (2,'2012-07-05','','2012-06-01 08:43:44','0000-00-00 00:00:00'),
 (2,'2012-07-06','','2012-06-28 15:25:48','0000-00-00 00:00:00'),
 (2,'2012-07-11','','2012-01-31 15:08:30','0000-00-00 00:00:00'),
 (2,'2012-07-12','','2012-03-19 14:31:26','0000-00-00 00:00:00'),
 (2,'2012-07-16','','2012-01-31 15:01:16','0000-00-00 00:00:00'),
 (2,'2012-07-17','Review DG for Customer Switchboard isolation and complete risk assessment','2012-06-27 08:37:30','0000-00-00 00:00:00'),
 (2,'2012-07-18','','2012-06-01 08:45:24','0000-00-00 00:00:00'),
 (2,'2012-07-19','','2012-06-01 08:46:15','0000-00-00 00:00:00'),
 (2,'2012-07-23','Dogging Training','2012-06-01 08:47:06','0000-00-00 00:00:00'),
 (2,'2012-07-24','Dogging Training','2012-06-01 08:47:27','0000-00-00 00:00:00'),
 (2,'2012-07-25','Dogging Training','2012-01-31 15:09:59','0000-00-00 00:00:00'),
 (2,'2012-07-26','Dogging Training','2012-06-01 08:47:57','0000-00-00 00:00:00'),
 (2,'2012-07-27','Dogging Training','2012-06-01 08:48:12','0000-00-00 00:00:00'),
 (2,'2012-07-30','Dogging Training','2012-06-01 08:48:32','0000-00-00 00:00:00'),
 (2,'2012-07-31','Dogging Training','2012-06-01 08:48:48','0000-00-00 00:00:00'),
 (2,'2012-08-01','Dogging Training','2012-06-01 08:49:07','0000-00-00 00:00:00'),
 (2,'2012-08-02','Dogging Assessment day','2012-06-27 08:40:32','0000-00-00 00:00:00'),
 (2,'2012-08-06','Dogging Training','2012-06-01 08:49:29','0000-00-00 00:00:00'),
 (2,'2012-08-07','Dogging Training','2012-06-01 08:49:45','0000-00-00 00:00:00'),
 (2,'2012-08-08','Dogging Training','2012-06-01 08:49:57','0000-00-00 00:00:00'),
 (2,'2012-08-09','Dogging Training','2012-06-01 08:50:11','0000-00-00 00:00:00'),
 (2,'2012-08-10','Dogging Training','2012-06-01 08:50:24','0000-00-00 00:00:00'),
 (2,'2012-08-13','Dogging Training','2012-06-01 08:50:40','0000-00-00 00:00:00'),
 (2,'2012-08-14','','2012-06-27 08:43:28','0000-00-00 00:00:00'),
 (2,'2012-08-15','Dogging Assessment','2012-06-27 08:43:57','0000-00-00 00:00:00'),
 (2,'2012-08-16','','2012-06-27 08:44:39','0000-00-00 00:00:00'),
 (2,'2012-08-20','','2012-01-31 15:01:42','0000-00-00 00:00:00'),
 (2,'2012-08-21','Luminaire M1396 Wayne Mitchell','2012-05-10 12:01:12','0000-00-00 00:00:00'),
 (2,'2012-08-22','Luminaire M1396 Wayne Mitchell','2012-05-10 12:01:50','0000-00-00 00:00:00'),
 (2,'2012-08-23','Luminaire M1396 Wayne Mitchell','2012-07-25 10:11:08','0000-00-00 00:00:00'),
 (2,'2012-08-24','Luminaire M1396 Wayne Mitchell','2012-01-31 15:10:36','0000-00-00 00:00:00'),
 (2,'2012-08-27','','2012-06-01 08:51:58','0000-00-00 00:00:00'),
 (2,'2012-08-28','Luminaire M1399 for WMonk','2012-06-01 08:52:23','0000-00-00 00:00:00'),
 (2,'2012-08-29','Luminaire M1399 for WMonk','2012-06-01 08:52:36','0000-00-00 00:00:00'),
 (2,'2012-08-30','','2012-06-01 08:52:52','0000-00-00 00:00:00'),
 (2,'2012-08-31','','2012-06-01 08:53:07','0000-00-00 00:00:00'),
 (2,'2012-09-04','','2012-07-25 08:17:44','0000-00-00 00:00:00'),
 (2,'2012-09-05','','2012-07-25 08:18:35','0000-00-00 00:00:00'),
 (2,'2012-09-06','','2012-07-25 08:19:21','0000-00-00 00:00:00'),
 (2,'2012-09-10','','2012-08-06 15:45:36','0000-00-00 00:00:00'),
 (2,'2012-09-11','Luminaire M1397 ','2012-07-25 08:19:59','0000-00-00 00:00:00'),
 (2,'2012-09-12','','2012-07-25 08:20:32','0000-00-00 00:00:00'),
 (2,'2012-09-13','','2012-07-27 15:17:45','0000-00-00 00:00:00'),
 (2,'2012-09-17','','2012-01-31 15:02:01','0000-00-00 00:00:00'),
 (2,'2012-09-18','','2012-07-30 16:37:52','0000-00-00 00:00:00'),
 (2,'2012-09-19','','2012-07-30 16:38:52','0000-00-00 00:00:00'),
 (2,'2012-09-20','','2012-07-30 16:39:57','0000-00-00 00:00:00'),
 (2,'2012-09-21','','2012-07-30 16:40:45','0000-00-00 00:00:00'),
 (2,'2012-09-24','','2012-08-06 16:03:45','0000-00-00 00:00:00'),
 (2,'2012-09-25','','2012-08-23 08:58:51','0000-00-00 00:00:00'),
 (2,'2012-09-26','','2012-08-31 14:18:47','0000-00-00 00:00:00'),
 (2,'2012-09-28','','2012-09-21 06:24:00','0000-00-00 00:00:00'),
 (2,'2012-10-02','C2 Training','2012-08-23 08:59:41','0000-00-00 00:00:00'),
 (2,'2012-10-03','','2012-08-06 16:04:29','0000-00-00 00:00:00'),
 (2,'2012-10-04','','2012-08-06 16:04:57','0000-00-00 00:00:00'),
 (2,'2012-10-05','','2012-09-21 06:28:26','0000-00-00 00:00:00'),
 (2,'2012-10-08','','2012-09-21 06:30:30','0000-00-00 00:00:00'),
 (2,'2012-10-09','C2 Training','2012-08-23 09:00:29','0000-00-00 00:00:00'),
 (2,'2012-10-10','','2012-08-06 16:05:48','0000-00-00 00:00:00'),
 (2,'2012-10-11','Kate Gillespie - 0467 800 360','2012-09-21 06:32:44','0000-00-00 00:00:00'),
 (2,'2012-10-12','','2012-09-21 06:33:27','0000-00-00 00:00:00'),
 (2,'2012-10-15','','2012-01-31 15:02:22','0000-00-00 00:00:00'),
 (2,'2012-10-16','C2 Training','2012-08-06 16:33:01','0000-00-00 00:00:00'),
 (2,'2012-10-17','C2 Training','2012-08-23 09:01:40','0000-00-00 00:00:00'),
 (2,'2012-10-18','C2 Training','2012-09-21 06:35:20','0000-00-00 00:00:00'),
 (2,'2012-10-19','','2012-10-05 08:30:09','0000-00-00 00:00:00'),
 (2,'2012-10-22','OSA restricted operators training','2012-08-31 14:41:24','0000-00-00 00:00:00'),
 (2,'2012-10-23','OSA restricted operators training','2012-08-23 09:02:08','0000-00-00 00:00:00'),
 (2,'2012-10-24','OSA restricted operators training','2012-09-03 07:38:10','0000-00-00 00:00:00'),
 (2,'2012-10-25','OSA restricted operators training','2012-09-03 07:38:42','0000-00-00 00:00:00'),
 (2,'2012-10-26','OSA restricted operators training','2012-09-03 07:39:24','0000-00-00 00:00:00'),
 (2,'2012-10-29','','2012-08-06 16:33:43','0000-00-00 00:00:00'),
 (2,'2012-10-30','','2012-08-06 16:34:16','0000-00-00 00:00:00'),
 (2,'2012-10-31','','2012-08-06 16:34:45','0000-00-00 00:00:00'),
 (2,'2012-11-01','','2012-07-30 16:49:06','0000-00-00 00:00:00'),
 (2,'2012-11-02','','2012-07-30 16:50:04','0000-00-00 00:00:00'),
 (2,'2012-11-05','','2012-03-19 14:33:01','0000-00-00 00:00:00'),
 (2,'2012-11-06','','2012-03-19 14:33:12','0000-00-00 00:00:00'),
 (2,'2012-11-07','Rex Training','2012-03-19 14:33:28','0000-00-00 00:00:00'),
 (2,'2012-11-08','C2 Training','2012-03-19 14:33:39','0000-00-00 00:00:00'),
 (2,'2012-11-09','C2 Training','2012-03-19 14:33:54','0000-00-00 00:00:00'),
 (2,'2012-11-12','Yellow Card Training','2012-03-19 14:34:26','0000-00-00 00:00:00'),
 (2,'2012-11-13','C2 Training','2012-03-19 14:34:36','0000-00-00 00:00:00'),
 (2,'2012-11-14','C2 Training','2012-03-19 14:34:48','0000-00-00 00:00:00'),
 (2,'2012-11-15','C2 Training','2012-03-19 14:35:04','0000-00-00 00:00:00'),
 (2,'2012-11-16','C2 Training','2012-03-19 14:35:17','0000-00-00 00:00:00'),
 (2,'2012-11-19','','2012-01-31 15:02:44','0000-00-00 00:00:00'),
 (2,'2012-11-20','2B LVFR','2012-07-30 16:45:33','0000-00-00 00:00:00'),
 (2,'2012-11-21','2B LVFR','2012-07-30 16:46:07','0000-00-00 00:00:00'),
 (2,'2012-11-22','','2012-07-30 16:46:39','0000-00-00 00:00:00'),
 (2,'2012-11-23','','2012-10-05 08:43:31','0000-00-00 00:00:00'),
 (2,'2012-11-27','','2012-07-30 16:47:09','0000-00-00 00:00:00'),
 (2,'2012-11-28','','2012-07-30 16:47:39','0000-00-00 00:00:00'),
 (2,'2012-11-29','','2012-10-05 08:44:27','0000-00-00 00:00:00'),
 (2,'2012-11-30','','2012-07-30 16:48:13','0000-00-00 00:00:00'),
 (2,'2012-12-06','','2012-08-06 16:39:48','0000-00-00 00:00:00'),
 (2,'2012-12-17','','2012-01-31 15:03:02','0000-00-00 00:00:00'),
 (2,'2012-12-25','Merry Xmas','2012-08-06 16:40:39','0000-00-00 00:00:00'),
 (3,'2012-01-23','','2012-01-23 14:26:01','0000-00-00 00:00:00'),
 (3,'2012-01-24','','2012-01-23 14:25:30','0000-00-00 00:00:00'),
 (3,'2012-01-25','','2012-01-23 14:27:51','0000-00-00 00:00:00'),
 (3,'2012-02-02','ASP Statutory Training 7am to 3.30pm','2012-01-23 14:29:01','0000-00-00 00:00:00'),
 (3,'2012-02-06','','2012-01-24 09:40:13','0000-00-00 00:00:00'),
 (3,'2012-02-07','','2012-01-24 09:40:22','0000-00-00 00:00:00'),
 (3,'2012-02-08','','2012-01-30 07:18:29','0000-00-00 00:00:00'),
 (3,'2012-02-09','','2012-02-06 07:28:38','0000-00-00 00:00:00'),
 (3,'2012-02-10','','2012-02-06 07:28:48','0000-00-00 00:00:00'),
 (3,'2012-02-15','Staff Club Board Meeting','2012-02-06 15:19:45','0000-00-00 00:00:00'),
 (3,'2012-02-16','','2012-02-09 13:56:01','0000-00-00 00:00:00'),
 (3,'2012-02-20','Cat 3 Training','2012-01-23 14:30:24','0000-00-00 00:00:00'),
 (3,'2012-02-21','Cat 3 Training','2012-01-23 14:30:31','0000-00-00 00:00:00'),
 (3,'2012-02-22','','2012-02-20 07:53:27','0000-00-00 00:00:00'),
 (3,'2012-02-23','Cat 3 Training','2012-01-23 14:30:52','0000-00-00 00:00:00'),
 (3,'2012-02-27','','2012-02-20 07:54:11','0000-00-00 00:00:00'),
 (3,'2012-02-28','RT0002 - EWP Esc/EWP CD/PoleTop/CPR/LVR&R/1st Aid','2012-01-23 14:32:56','0000-00-00 00:00:00'),
 (3,'2012-02-29','','2012-01-23 14:34:02','0000-00-00 00:00:00'),
 (3,'2012-03-01','ASP Statutory Training','2012-02-06 15:22:13','0000-00-00 00:00:00'),
 (3,'2012-03-02','Booked by Tracee Dagg','2012-02-06 15:21:24','0000-00-00 00:00:00'),
 (3,'2012-03-05','','2012-01-23 14:35:08','0000-00-00 00:00:00'),
 (3,'2012-03-06','','2012-01-23 14:35:15','0000-00-00 00:00:00'),
 (3,'2012-03-07','','2012-01-23 14:35:23','0000-00-00 00:00:00'),
 (3,'2012-03-08','','2012-01-23 14:35:30','0000-00-00 00:00:00'),
 (3,'2012-03-12','','2012-03-06 07:32:30','0000-00-00 00:00:00'),
 (3,'2012-03-13','','2012-01-24 09:41:42','0000-00-00 00:00:00'),
 (3,'2012-03-14','','2012-01-24 09:41:50','0000-00-00 00:00:00'),
 (3,'2012-03-19','','2012-01-23 14:36:09','0000-00-00 00:00:00'),
 (3,'2012-03-22','','2012-03-22 07:47:42','0000-00-00 00:00:00'),
 (3,'2012-03-23','','2012-03-22 18:46:55','0000-00-00 00:00:00'),
 (3,'2012-03-26','','2012-03-26 06:04:42','0000-00-00 00:00:00'),
 (3,'2012-04-02','Lake Munmorah Lessons learnt workshop','2012-03-26 06:15:50','0000-00-00 00:00:00'),
 (3,'2012-04-03','','2012-04-02 12:41:02','0000-00-00 00:00:00'),
 (3,'2012-04-04','','2012-04-02 07:07:24','0000-00-00 00:00:00'),
 (3,'2012-04-05','','2012-04-03 07:10:43','0000-00-00 00:00:00'),
 (3,'2012-04-06','Happy Easter','2012-04-05 06:26:21','0000-00-00 00:00:00'),
 (3,'2012-04-07','Happy Easter','2012-04-05 06:26:43','0000-00-00 00:00:00'),
 (3,'2012-04-08','Happy Easter','2012-04-05 06:27:05','0000-00-00 00:00:00'),
 (3,'2012-04-09','Happy Easter','2012-04-05 06:27:24','0000-00-00 00:00:00'),
 (3,'2012-04-11','Drug & Alcohol Testing','2012-03-29 14:52:58','0000-00-00 00:00:00'),
 (3,'2012-04-16','','2012-01-31 15:00:15','0000-00-00 00:00:00'),
 (3,'2012-04-17','confined spaces training','2012-02-06 15:24:04','0000-00-00 00:00:00'),
 (3,'2012-04-18','confined spaces training','2012-03-12 09:27:51','0000-00-00 00:00:00'),
 (3,'2012-04-19','confined spaces training','2012-03-12 09:28:10','0000-00-00 00:00:00'),
 (3,'2012-04-24','confined spaces training','2012-03-12 09:28:30','0000-00-00 00:00:00'),
 (3,'2012-04-25','confined spaces training','2012-03-12 09:28:49','0000-00-00 00:00:00'),
 (3,'2012-04-26','confined spaces training','2012-03-12 09:29:01','0000-00-00 00:00:00'),
 (3,'2012-04-27','','2012-04-16 09:47:12','0000-00-00 00:00:00'),
 (3,'2012-04-30','Cat 3 Training','2012-03-20 15:25:22','0000-00-00 00:00:00'),
 (3,'2012-05-01','Confined Spaces training','2012-03-12 09:29:19','0000-00-00 00:00:00'),
 (3,'2012-05-02','confined spaces training','2012-01-31 15:04:30','0000-00-00 00:00:00'),
 (3,'2012-05-03','confined spaces training','2012-03-12 09:30:39','0000-00-00 00:00:00'),
 (3,'2012-05-04','Somersby Training Centre Open day','2012-03-26 06:11:03','0000-00-00 00:00:00'),
 (3,'2012-05-08','','2012-04-17 07:07:41','0000-00-00 00:00:00'),
 (3,'2012-05-09','','2012-03-26 08:59:41','0000-00-00 00:00:00'),
 (3,'2012-05-10','','2012-05-04 09:13:40','0000-00-00 00:00:00'),
 (3,'2012-05-14','','2012-05-09 08:57:15','0000-00-00 00:00:00'),
 (3,'2012-05-15','','2012-04-16 09:51:16','0000-00-00 00:00:00'),
 (3,'2012-05-16','','2012-01-31 15:07:16','0000-00-00 00:00:00'),
 (3,'2012-05-17','','2012-04-16 09:52:39','0000-00-00 00:00:00'),
 (3,'2012-05-18','','2012-04-16 09:53:05','0000-00-00 00:00:00'),
 (3,'2012-05-21','Hac Training','2012-01-31 15:00:28','0000-00-00 00:00:00'),
 (3,'2012-05-22','','2012-04-16 09:53:44','0000-00-00 00:00:00'),
 (3,'2012-05-23','','2012-04-16 09:54:11','0000-00-00 00:00:00'),
 (3,'2012-05-24','Booked from 8.30 am to service Data Projector','2012-05-14 15:42:12','0000-00-00 00:00:00'),
 (3,'2012-05-25','Combined Strategy Meeting - FSM\'s & Operations Managers','2012-01-31 15:07:53','0000-00-00 00:00:00'),
 (3,'2012-05-28','','2012-04-16 09:55:20','0000-00-00 00:00:00'),
 (3,'2012-05-29','','2012-04-16 09:55:52','0000-00-00 00:00:00'),
 (3,'2012-05-30','','2012-04-16 09:56:22','0000-00-00 00:00:00'),
 (3,'2012-05-31','','2012-04-16 09:56:47','0000-00-00 00:00:00'),
 (3,'2012-06-01','','2012-04-16 09:57:13','0000-00-00 00:00:00'),
 (3,'2012-06-04','','2012-05-29 13:42:14','0000-00-00 00:00:00'),
 (3,'2012-06-05','','2012-05-14 15:44:23','0000-00-00 00:00:00'),
 (3,'2012-06-06','','2012-06-05 10:38:02','0000-00-00 00:00:00'),
 (3,'2012-06-07','','2012-04-16 09:57:48','0000-00-00 00:00:00'),
 (3,'2012-06-08','','2012-06-01 08:35:05','0000-00-00 00:00:00'),
 (3,'2012-06-12','','2012-04-16 09:58:17','0000-00-00 00:00:00'),
 (3,'2012-06-13','','2012-05-29 13:45:49','0000-00-00 00:00:00'),
 (3,'2012-06-18','','2012-01-31 15:00:55','0000-00-00 00:00:00'),
 (3,'2012-06-19','2B Training','2012-04-16 09:58:52','0000-00-00 00:00:00'),
 (3,'2012-06-20','2B Training','2012-05-10 11:34:04','0000-00-00 00:00:00'),
 (3,'2012-06-21','','2012-04-16 09:59:12','0000-00-00 00:00:00'),
 (3,'2012-06-25','CA0003','2012-06-13 15:01:35','0000-00-00 00:00:00'),
 (3,'2012-06-26','CA0003','2012-05-29 13:57:36','0000-00-00 00:00:00'),
 (3,'2012-06-27','CA0003','2012-05-29 13:58:11','0000-00-00 00:00:00'),
 (3,'2012-06-28','CA0003','2012-05-29 14:04:10','0000-00-00 00:00:00'),
 (3,'2012-06-29','Tech Training Yearly review','2012-02-20 09:27:32','0000-00-00 00:00:00'),
 (3,'2012-07-02','Safe Working Aloft - Wayne Monk','2012-06-28 15:25:06','0000-00-00 00:00:00'),
 (3,'2012-07-03','Safe Working Aloft - Wayne Monk','2012-06-01 08:43:10','0000-00-00 00:00:00'),
 (3,'2012-07-04','Safe Working Aloft - Wayne Monk','2012-06-13 15:08:22','0000-00-00 00:00:00'),
 (3,'2012-07-05','Safe Working Aloft - Wayne Monk','2012-06-01 08:43:44','0000-00-00 00:00:00'),
 (3,'2012-07-06','Safe Working Aloft - Wayne Monk','2012-06-28 15:25:48','0000-00-00 00:00:00'),
 (3,'2012-07-11','','2012-01-31 15:08:30','0000-00-00 00:00:00'),
 (3,'2012-07-12','Safe Work Aloft','2012-03-19 14:31:26','0000-00-00 00:00:00'),
 (3,'2012-07-16','Meeting to discuss Training course M1574','2012-01-31 15:01:16','0000-00-00 00:00:00'),
 (3,'2012-07-17','','2012-06-27 08:37:30','0000-00-00 00:00:00'),
 (3,'2012-07-18','','2012-06-01 08:45:24','0000-00-00 00:00:00'),
 (3,'2012-07-19','','2012-06-01 08:46:15','0000-00-00 00:00:00'),
 (3,'2012-07-23','','2012-06-01 08:47:06','0000-00-00 00:00:00'),
 (3,'2012-07-24','','2012-06-01 08:47:27','0000-00-00 00:00:00'),
 (3,'2012-07-25','','2012-01-31 15:09:59','0000-00-00 00:00:00'),
 (3,'2012-07-26','','2012-06-01 08:47:57','0000-00-00 00:00:00'),
 (3,'2012-07-27','','2012-06-01 08:48:12','0000-00-00 00:00:00'),
 (3,'2012-07-30','Review M1574 training notes','2012-06-01 08:48:32','0000-00-00 00:00:00'),
 (3,'2012-07-31','','2012-06-01 08:48:48','0000-00-00 00:00:00'),
 (3,'2012-08-01','','2012-06-01 08:49:07','0000-00-00 00:00:00'),
 (3,'2012-08-02','Team brief + HAC training','2012-06-27 08:40:32','0000-00-00 00:00:00'),
 (3,'2012-08-06','5-day HSR Training Session: P Knox','2012-06-01 08:49:29','0000-00-00 00:00:00'),
 (3,'2012-08-07','5-day HSR Training Session: P Knox','2012-06-01 08:49:45','0000-00-00 00:00:00'),
 (3,'2012-08-08','5-day HSR Training Session: P Knox','2012-06-01 08:49:57','0000-00-00 00:00:00'),
 (3,'2012-08-09','','2012-06-01 08:50:11','0000-00-00 00:00:00'),
 (3,'2012-08-10','','2012-06-01 08:50:24','0000-00-00 00:00:00'),
 (3,'2012-08-13','5-day HSR Training Session: P Knox','2012-06-01 08:50:40','0000-00-00 00:00:00'),
 (3,'2012-08-14','5-day HSR Training Session: P Knox','2012-06-27 08:43:28','0000-00-00 00:00:00'),
 (3,'2012-08-15','','2012-06-27 08:43:57','0000-00-00 00:00:00'),
 (3,'2012-08-16','','2012-06-27 08:44:39','0000-00-00 00:00:00'),
 (3,'2012-08-20','','2012-01-31 15:01:42','0000-00-00 00:00:00'),
 (3,'2012-08-21','','2012-05-10 12:01:12','0000-00-00 00:00:00'),
 (3,'2012-08-22','','2012-05-10 12:01:50','0000-00-00 00:00:00'),
 (3,'2012-08-23','','2012-07-25 10:11:08','0000-00-00 00:00:00'),
 (3,'2012-08-24','Combined Strategy Meeting - FSM\'s & Operations Managers','2012-01-31 15:10:36','0000-00-00 00:00:00'),
 (3,'2012-08-27','','2012-06-01 08:51:58','0000-00-00 00:00:00'),
 (3,'2012-08-28','','2012-06-01 08:52:23','0000-00-00 00:00:00'),
 (3,'2012-08-29','','2012-06-01 08:52:36','0000-00-00 00:00:00'),
 (3,'2012-08-30','','2012-06-01 08:52:52','0000-00-00 00:00:00'),
 (3,'2012-08-31','','2012-06-01 08:53:07','0000-00-00 00:00:00'),
 (3,'2012-09-04','M1574 Training Course update','2012-07-25 08:17:44','0000-00-00 00:00:00'),
 (3,'2012-09-05','','2012-07-25 08:18:35','0000-00-00 00:00:00'),
 (3,'2012-09-06','','2012-07-25 08:19:21','0000-00-00 00:00:00'),
 (3,'2012-09-10','Luminaire M1397 ','2012-08-06 15:45:36','0000-00-00 00:00:00'),
 (3,'2012-09-11','','2012-07-25 08:19:59','0000-00-00 00:00:00'),
 (3,'2012-09-12','Luminaire M1397 ','2012-07-25 08:20:32','0000-00-00 00:00:00'),
 (3,'2012-09-13','Luminaire M1397 ','2012-07-27 15:17:45','0000-00-00 00:00:00'),
 (3,'2012-09-17','Cat 3 Training (Wayne Monk)','2012-01-31 15:02:01','0000-00-00 00:00:00'),
 (3,'2012-09-18','Cat 3 Training (Wayne Monk)','2012-07-30 16:37:52','0000-00-00 00:00:00'),
 (3,'2012-09-19','Cat 3 Training (Wayne Monk)','2012-07-30 16:38:52','0000-00-00 00:00:00'),
 (3,'2012-09-20','Cat 3 Training','2012-07-30 16:39:57','0000-00-00 00:00:00'),
 (3,'2012-09-21','','2012-07-30 16:40:45','0000-00-00 00:00:00'),
 (3,'2012-09-24','','2012-08-06 16:03:45','0000-00-00 00:00:00'),
 (3,'2012-09-25','OHS System Demonstration','2012-08-23 08:58:51','0000-00-00 00:00:00'),
 (3,'2012-09-26','','2012-08-31 14:18:47','0000-00-00 00:00:00'),
 (3,'2012-09-28','','2012-09-21 06:24:00','0000-00-00 00:00:00'),
 (3,'2012-10-02','','2012-08-23 08:59:41','0000-00-00 00:00:00'),
 (3,'2012-10-03','','2012-08-06 16:04:29','0000-00-00 00:00:00'),
 (3,'2012-10-04','','2012-08-06 16:04:57','0000-00-00 00:00:00'),
 (3,'2012-10-05','','2012-09-21 06:28:26','0000-00-00 00:00:00'),
 (3,'2012-10-08','M1574 update','2012-09-21 06:30:30','0000-00-00 00:00:00'),
 (3,'2012-10-09','','2012-08-23 09:00:29','0000-00-00 00:00:00'),
 (3,'2012-10-10','','2012-08-06 16:05:48','0000-00-00 00:00:00'),
 (3,'2012-10-11','','2012-09-21 06:32:44','0000-00-00 00:00:00'),
 (3,'2012-10-12','','2012-09-21 06:33:27','0000-00-00 00:00:00'),
 (3,'2012-10-15','','2012-01-31 15:02:22','0000-00-00 00:00:00'),
 (3,'2012-10-16','','2012-08-06 16:33:01','0000-00-00 00:00:00'),
 (3,'2012-10-17','','2012-08-23 09:01:40','0000-00-00 00:00:00'),
 (3,'2012-10-18','','2012-09-21 06:35:20','0000-00-00 00:00:00'),
 (3,'2012-10-19','','2012-10-05 08:30:09','0000-00-00 00:00:00'),
 (3,'2012-10-22','','2012-08-31 14:41:24','0000-00-00 00:00:00'),
 (3,'2012-10-23','SC1100 DAY 2 - REGS','2012-08-23 09:02:08','0000-00-00 00:00:00'),
 (3,'2012-10-24','','2012-09-03 07:38:10','0000-00-00 00:00:00'),
 (3,'2012-10-25','','2012-09-03 07:38:42','0000-00-00 00:00:00'),
 (3,'2012-10-26','','2012-09-03 07:39:24','0000-00-00 00:00:00'),
 (3,'2012-10-29','','2012-08-06 16:33:43','0000-00-00 00:00:00'),
 (3,'2012-10-30','','2012-08-06 16:34:16','0000-00-00 00:00:00'),
 (3,'2012-10-31','','2012-08-06 16:34:45','0000-00-00 00:00:00'),
 (3,'2012-11-01','','2012-07-30 16:49:06','0000-00-00 00:00:00'),
 (3,'2012-11-02','','2012-07-30 16:50:04','0000-00-00 00:00:00'),
 (3,'2012-11-05','','2012-03-19 14:33:01','0000-00-00 00:00:00'),
 (3,'2012-11-06','HSR Training: Day 4','2012-03-19 14:33:12','0000-00-00 00:00:00'),
 (3,'2012-11-07','Ausgrid Protection Test Group','2012-03-19 14:33:28','0000-00-00 00:00:00'),
 (3,'2012-11-08','','2012-03-19 14:33:39','0000-00-00 00:00:00'),
 (3,'2012-11-09','','2012-03-19 14:33:54','0000-00-00 00:00:00'),
 (3,'2012-11-12','','2012-03-19 14:34:26','0000-00-00 00:00:00'),
 (3,'2012-11-13','1-Day HSR Training - Refresher','2012-03-19 14:34:36','0000-00-00 00:00:00'),
 (3,'2012-11-14','','2012-03-19 14:34:48','0000-00-00 00:00:00'),
 (3,'2012-11-15','','2012-03-19 14:35:04','0000-00-00 00:00:00'),
 (3,'2012-11-16','SE1000 Initial','2012-03-19 14:35:17','0000-00-00 00:00:00'),
 (3,'2012-11-19','','2012-01-31 15:02:44','0000-00-00 00:00:00'),
 (3,'2012-11-20','M1574','2012-07-30 16:45:33','0000-00-00 00:00:00'),
 (3,'2012-11-21','','2012-07-30 16:46:07','0000-00-00 00:00:00'),
 (3,'2012-11-22','','2012-07-30 16:46:39','0000-00-00 00:00:00'),
 (3,'2012-11-23','','2012-10-05 08:43:31','0000-00-00 00:00:00'),
 (3,'2012-11-27','','2012-07-30 16:47:09','0000-00-00 00:00:00'),
 (3,'2012-11-28','','2012-07-30 16:47:39','0000-00-00 00:00:00'),
 (3,'2012-11-29','','2012-10-05 08:44:27','0000-00-00 00:00:00'),
 (3,'2012-11-30','','2012-07-30 16:48:13','0000-00-00 00:00:00'),
 (3,'2012-12-06','','2012-08-06 16:39:48','0000-00-00 00:00:00'),
 (3,'2012-12-17','','2012-01-31 15:03:02','0000-00-00 00:00:00'),
 (3,'2012-12-25','Merry Xmas','2012-08-06 16:40:39','0000-00-00 00:00:00'),
 (4,'2012-01-23','','2012-01-23 14:26:01','0000-00-00 00:00:00'),
 (4,'2012-01-24','','2012-01-23 14:25:30','0000-00-00 00:00:00'),
 (4,'2012-01-25','CPR/R&R LV Initial 7.30am to 11.30am','2012-01-23 14:27:51','0000-00-00 00:00:00'),
 (4,'2012-02-02','','2012-01-23 14:29:01','0000-00-00 00:00:00'),
 (4,'2012-02-06','','2012-01-24 09:40:13','0000-00-00 00:00:00'),
 (4,'2012-02-07','','2012-01-24 09:40:22','0000-00-00 00:00:00'),
 (4,'2012-02-08','','2012-01-30 07:18:29','0000-00-00 00:00:00'),
 (4,'2012-02-09','','2012-02-06 07:28:38','0000-00-00 00:00:00'),
 (4,'2012-02-10','','2012-02-06 07:28:48','0000-00-00 00:00:00'),
 (4,'2012-02-15','','2012-02-06 15:19:45','0000-00-00 00:00:00'),
 (4,'2012-02-16','Corp HR: OHS IT System ','2012-02-09 13:56:01','0000-00-00 00:00:00'),
 (4,'2012-02-20','OS&A Meeting','2012-01-23 14:30:24','0000-00-00 00:00:00'),
 (4,'2012-02-21','','2012-01-23 14:30:31','0000-00-00 00:00:00'),
 (4,'2012-02-22','CPR / Release from LV Initial','2012-02-20 07:53:27','0000-00-00 00:00:00'),
 (4,'2012-02-23','','2012-01-23 14:30:52','0000-00-00 00:00:00'),
 (4,'2012-02-27','','2012-02-20 07:54:11','0000-00-00 00:00:00'),
 (4,'2012-02-28','RT0002 - EWP Esc/EWP CD/PoleTop/CPR/LVR&R/1st Aid','2012-01-23 14:32:56','0000-00-00 00:00:00'),
 (4,'2012-02-29','','2012-01-23 14:34:02','0000-00-00 00:00:00'),
 (4,'2012-03-01','Be Safe Day','2012-02-06 15:22:13','0000-00-00 00:00:00'),
 (4,'2012-03-02','','2012-02-06 15:21:24','0000-00-00 00:00:00'),
 (4,'2012-03-05','','2012-01-23 14:35:08','0000-00-00 00:00:00'),
 (4,'2012-03-06','','2012-01-23 14:35:15','0000-00-00 00:00:00'),
 (4,'2012-03-07','','2012-01-23 14:35:23','0000-00-00 00:00:00'),
 (4,'2012-03-08','','2012-01-23 14:35:30','0000-00-00 00:00:00'),
 (4,'2012-03-12','','2012-03-06 07:32:30','0000-00-00 00:00:00'),
 (4,'2012-03-13','','2012-01-24 09:41:42','0000-00-00 00:00:00'),
 (4,'2012-03-14','','2012-01-24 09:41:50','0000-00-00 00:00:00'),
 (4,'2012-03-19','OS&A Meeting','2012-01-23 14:36:09','0000-00-00 00:00:00'),
 (4,'2012-03-22','OS&A Meeting ','2012-03-22 07:47:42','0000-00-00 00:00:00'),
 (4,'2012-03-23','','2012-03-22 18:46:55','0000-00-00 00:00:00'),
 (4,'2012-03-26','','2012-03-26 06:04:42','0000-00-00 00:00:00'),
 (4,'2012-04-02','Pole Top EWP rescue & CCD','2012-03-26 06:15:50','0000-00-00 00:00:00'),
 (4,'2012-04-03','Pole Top EWP rescue & CCD','2012-04-02 12:41:02','0000-00-00 00:00:00'),
 (4,'2012-04-04','Pole Top EWP rescue & CCD','2012-04-02 07:07:24','0000-00-00 00:00:00'),
 (4,'2012-04-05','Pole Top EWP rescue & CCD','2012-04-03 07:10:43','0000-00-00 00:00:00'),
 (4,'2012-04-06','Happy Easter','2012-04-05 06:26:21','0000-00-00 00:00:00'),
 (4,'2012-04-07','Happy Easter','2012-04-05 06:26:43','0000-00-00 00:00:00'),
 (4,'2012-04-08','Happy Easter','2012-04-05 06:27:05','0000-00-00 00:00:00'),
 (4,'2012-04-09','Happy Easter','2012-04-05 06:27:24','0000-00-00 00:00:00'),
 (4,'2012-04-11','','2012-03-29 14:52:58','0000-00-00 00:00:00'),
 (4,'2012-04-16','OS&A Meeting ','2012-01-31 15:00:15','0000-00-00 00:00:00'),
 (4,'2012-04-17','Safety Consultative Group: Quarterly Meeting','2012-02-06 15:24:04','0000-00-00 00:00:00'),
 (4,'2012-04-18','','2012-03-12 09:27:51','0000-00-00 00:00:00'),
 (4,'2012-04-19','','2012-03-12 09:28:10','0000-00-00 00:00:00'),
 (4,'2012-04-24','','2012-03-12 09:28:30','0000-00-00 00:00:00'),
 (4,'2012-04-25','','2012-03-12 09:28:49','0000-00-00 00:00:00'),
 (4,'2012-04-26','','2012-03-12 09:29:01','0000-00-00 00:00:00'),
 (4,'2012-04-27','','2012-04-16 09:47:12','0000-00-00 00:00:00'),
 (4,'2012-04-30','','2012-03-20 15:25:22','0000-00-00 00:00:00'),
 (4,'2012-05-01','Cat 3 Training','2012-03-12 09:29:19','0000-00-00 00:00:00'),
 (4,'2012-05-02','Cat 3 Training','2012-01-31 15:04:30','0000-00-00 00:00:00'),
 (4,'2012-05-03','Meeting','2012-03-12 09:30:39','0000-00-00 00:00:00'),
 (4,'2012-05-04','Somersby Training Centre Open day','2012-03-26 06:11:03','0000-00-00 00:00:00'),
 (4,'2012-05-08','','2012-04-17 07:07:41','0000-00-00 00:00:00'),
 (4,'2012-05-09','','2012-03-26 08:59:41','0000-00-00 00:00:00'),
 (4,'2012-05-10','','2012-05-04 09:13:40','0000-00-00 00:00:00'),
 (4,'2012-05-14','','2012-05-09 08:57:15','0000-00-00 00:00:00'),
 (4,'2012-05-15','','2012-04-16 09:51:16','0000-00-00 00:00:00'),
 (4,'2012-05-16','','2012-01-31 15:07:16','0000-00-00 00:00:00'),
 (4,'2012-05-17','Regs Training 3rd Day','2012-04-16 09:52:39','0000-00-00 00:00:00'),
 (4,'2012-05-18','','2012-04-16 09:53:05','0000-00-00 00:00:00'),
 (4,'2012-05-21','OS&A Meeting ','2012-01-31 15:00:28','0000-00-00 00:00:00'),
 (4,'2012-05-22','','2012-04-16 09:53:44','0000-00-00 00:00:00'),
 (4,'2012-05-23','RF0001 - Refresher','2012-04-16 09:54:11','0000-00-00 00:00:00'),
 (4,'2012-05-24','','2012-05-14 15:42:12','0000-00-00 00:00:00'),
 (4,'2012-05-25','','2012-01-31 15:07:53','0000-00-00 00:00:00'),
 (4,'2012-05-28','RESTRICTED OPERATOR REACCREDITATION TRAINING (Jeff Williams) UMINA & NORAVILLE ROOMS COMBINED','2012-04-16 09:55:20','0000-00-00 00:00:00'),
 (4,'2012-05-29','RESTRICTED OPERATOR REACCREDITATION TRAINING (Jeff Williams) UMINA & NORAVILLE ROOMS COMBINED','2012-04-16 09:55:52','0000-00-00 00:00:00'),
 (4,'2012-05-30','Cancelled RESTRICTED OPERATOR REACCREDITATION TRAINING (Jeff Williams) UMINA & NORAVILLE ROOMS COMBINED','2012-04-16 09:56:22','0000-00-00 00:00:00'),
 (4,'2012-05-31','RESTRICTED OPERATOR REACCREDITATION TRAINING (Jeff Williams) UMINA & NORAVILLE ROOMS COMBINED','2012-04-16 09:56:47','0000-00-00 00:00:00'),
 (4,'2012-06-01','Cancelled RESTRICTED OPERATOR REACCREDITATION TRAINING (Jeff Williams) UMINA & NORAVILLE ROOMS COMBINED','2012-04-16 09:57:13','0000-00-00 00:00:00'),
 (4,'2012-06-04','Review Investigation form','2012-05-29 13:42:14','0000-00-00 00:00:00'),
 (4,'2012-06-05','Reg Training - Ray Byrnes','2012-05-14 15:44:23','0000-00-00 00:00:00'),
 (4,'2012-06-06','','2012-06-05 10:38:02','0000-00-00 00:00:00'),
 (4,'2012-06-07','Regulatory Training','2012-04-16 09:57:48','0000-00-00 00:00:00'),
 (4,'2012-06-08','Regulatory Training Booked by Davinia Field','2012-06-01 08:35:05','0000-00-00 00:00:00'),
 (4,'2012-06-12','Regulatory Training','2012-04-16 09:58:17','0000-00-00 00:00:00'),
 (4,'2012-06-13','Reg Training - Ray Byrnes','2012-05-29 13:45:49','0000-00-00 00:00:00'),
 (4,'2012-06-18','OS&A Meeting ','2012-01-31 15:00:55','0000-00-00 00:00:00'),
 (4,'2012-06-19','Regulatory Training','2012-04-16 09:58:52','0000-00-00 00:00:00'),
 (4,'2012-06-20','Confined Spaces Training - Ray Byrnes','2012-05-10 11:34:04','0000-00-00 00:00:00'),
 (4,'2012-06-21','Regulatory Training','2012-04-16 09:59:12','0000-00-00 00:00:00'),
 (4,'2012-06-25','','2012-06-13 15:01:35','0000-00-00 00:00:00'),
 (4,'2012-06-26','','2012-05-29 13:57:36','0000-00-00 00:00:00'),
 (4,'2012-06-27','Class 5H Training Jeff Williams','2012-05-29 13:58:11','0000-00-00 00:00:00'),
 (4,'2012-06-28','Class 5H Training Jeff Williams','2012-05-29 14:04:10','0000-00-00 00:00:00'),
 (4,'2012-06-29','Tech Training Yearly review','2012-02-20 09:27:32','0000-00-00 00:00:00'),
 (4,'2012-07-02','','2012-06-28 15:25:06','0000-00-00 00:00:00'),
 (4,'2012-07-03','Reg Training - RF0002','2012-06-01 08:43:10','0000-00-00 00:00:00'),
 (4,'2012-07-04','Reg Training - M1028 ','2012-06-13 15:08:22','0000-00-00 00:00:00'),
 (4,'2012-07-05','','2012-06-01 08:43:44','0000-00-00 00:00:00'),
 (4,'2012-07-06','','2012-06-28 15:25:48','0000-00-00 00:00:00'),
 (4,'2012-07-11','APR Training Course','2012-01-31 15:08:30','0000-00-00 00:00:00'),
 (4,'2012-07-12','APR Training Course','2012-03-19 14:31:26','0000-00-00 00:00:00'),
 (4,'2012-07-16','OS&A Meeting ','2012-01-31 15:01:16','0000-00-00 00:00:00'),
 (4,'2012-07-17','','2012-06-27 08:37:30','0000-00-00 00:00:00'),
 (4,'2012-07-18','Reg Training - RF0002','2012-06-01 08:45:24','0000-00-00 00:00:00'),
 (4,'2012-07-19','Reg Training - RF0001','2012-06-01 08:46:15','0000-00-00 00:00:00'),
 (4,'2012-07-23','','2012-06-01 08:47:06','0000-00-00 00:00:00'),
 (4,'2012-07-24','','2012-06-01 08:47:27','0000-00-00 00:00:00'),
 (4,'2012-07-25','Restricted Ops Training','2012-01-31 15:09:59','0000-00-00 00:00:00'),
 (4,'2012-07-26','','2012-06-01 08:47:57','0000-00-00 00:00:00'),
 (4,'2012-07-27','','2012-06-01 08:48:12','0000-00-00 00:00:00'),
 (4,'2012-07-30','','2012-06-01 08:48:32','0000-00-00 00:00:00'),
 (4,'2012-07-31','','2012-06-01 08:48:48','0000-00-00 00:00:00'),
 (4,'2012-08-01','','2012-06-01 08:49:07','0000-00-00 00:00:00'),
 (4,'2012-08-02','RF0001 - Reg Training','2012-06-27 08:40:32','0000-00-00 00:00:00'),
 (4,'2012-08-06','RF0001 - Reg Training','2012-06-01 08:49:29','0000-00-00 00:00:00'),
 (4,'2012-08-07','AB1008 - Reg Training','2012-06-01 08:49:45','0000-00-00 00:00:00'),
 (4,'2012-08-08','RF0001 - Reg Training','2012-06-01 08:49:57','0000-00-00 00:00:00'),
 (4,'2012-08-09','RF0001 - Reg Training','2012-06-01 08:50:11','0000-00-00 00:00:00'),
 (4,'2012-08-10','','2012-06-01 08:50:24','0000-00-00 00:00:00'),
 (4,'2012-08-13','Safe Work Aloft','2012-06-01 08:50:40','0000-00-00 00:00:00'),
 (4,'2012-08-14','Safe Work Aloft','2012-06-27 08:43:28','0000-00-00 00:00:00'),
 (4,'2012-08-15','M1028 - Reg Training','2012-06-27 08:43:57','0000-00-00 00:00:00'),
 (4,'2012-08-16','RF0002 - Reg Training','2012-06-27 08:44:39','0000-00-00 00:00:00'),
 (4,'2012-08-20','OS&A Meeting ','2012-01-31 15:01:42','0000-00-00 00:00:00'),
 (4,'2012-08-21','P1210 -  1 day Initial (electrically qualified) ','2012-05-10 12:01:12','0000-00-00 00:00:00'),
 (4,'2012-08-22','','2012-05-10 12:01:50','0000-00-00 00:00:00'),
 (4,'2012-08-23','','2012-07-25 10:11:08','0000-00-00 00:00:00'),
 (4,'2012-08-24','','2012-01-31 15:10:36','0000-00-00 00:00:00'),
 (4,'2012-08-27','','2012-06-01 08:51:58','0000-00-00 00:00:00'),
 (4,'2012-08-28','','2012-06-01 08:52:23','0000-00-00 00:00:00'),
 (4,'2012-08-29','','2012-06-01 08:52:36','0000-00-00 00:00:00'),
 (4,'2012-08-30','RF0002 - Reg Training','2012-06-01 08:52:52','0000-00-00 00:00:00'),
 (4,'2012-08-31','','2012-06-01 08:53:07','0000-00-00 00:00:00'),
 (4,'2012-09-04','RF0001 - Reg Training','2012-07-25 08:17:44','0000-00-00 00:00:00'),
 (4,'2012-09-05','REX Masterclass','2012-07-25 08:18:35','0000-00-00 00:00:00'),
 (4,'2012-09-06','RF0002 - Reg Training','2012-07-25 08:19:21','0000-00-00 00:00:00'),
 (4,'2012-09-10','','2012-08-06 15:45:36','0000-00-00 00:00:00'),
 (4,'2012-09-11','RF0001 - Reg Training','2012-07-25 08:19:59','0000-00-00 00:00:00'),
 (4,'2012-09-12','Confined Spaces - Refresher','2012-07-25 08:20:32','0000-00-00 00:00:00'),
 (4,'2012-09-13','','2012-07-27 15:17:45','0000-00-00 00:00:00'),
 (4,'2012-09-17','OS&A Meeting ','2012-01-31 15:02:01','0000-00-00 00:00:00'),
 (4,'2012-09-18','M1574 update Meeting','2012-07-30 16:37:52','0000-00-00 00:00:00'),
 (4,'2012-09-19','','2012-07-30 16:38:52','0000-00-00 00:00:00'),
 (4,'2012-09-20','REGS 3rd DAY SC1200','2012-07-30 16:39:57','0000-00-00 00:00:00'),
 (4,'2012-09-21','','2012-07-30 16:40:45','0000-00-00 00:00:00'),
 (4,'2012-09-24','','2012-08-06 16:03:45','0000-00-00 00:00:00'),
 (4,'2012-09-25','Health & Safety: Site Managers w/K Gillespie','2012-08-23 08:58:51','0000-00-00 00:00:00'),
 (4,'2012-09-26','','2012-08-31 14:18:47','0000-00-00 00:00:00'),
 (4,'2012-09-28','','2012-09-21 06:24:00','0000-00-00 00:00:00'),
 (4,'2012-10-02','Health & Safety: Site Managers w/K Gillespie','2012-08-23 08:59:41','0000-00-00 00:00:00'),
 (4,'2012-10-03','RF0002 - EWP Rescue/EWP CDE/Pole Top Rescue ','2012-08-06 16:04:29','0000-00-00 00:00:00'),
 (4,'2012-10-04','RF0002 - EWP Rescue/EWP CDE/Pole Top Rescue','2012-08-06 16:04:57','0000-00-00 00:00:00'),
 (4,'2012-10-05','','2012-09-21 06:28:26','0000-00-00 00:00:00'),
 (4,'2012-10-08','C2 Training','2012-09-21 06:30:30','0000-00-00 00:00:00'),
 (4,'2012-10-09','','2012-08-23 09:00:29','0000-00-00 00:00:00'),
 (4,'2012-10-10','C2 Training','2012-08-06 16:05:48','0000-00-00 00:00:00'),
 (4,'2012-10-11','C2 Training','2012-09-21 06:32:44','0000-00-00 00:00:00'),
 (4,'2012-10-12','C2 Training','2012-09-21 06:33:27','0000-00-00 00:00:00'),
 (4,'2012-10-15','OS&A Meeting ','2012-01-31 15:02:22','0000-00-00 00:00:00'),
 (4,'2012-10-16','RF0001 - CPR/RRLV/First Aid in ESI Environment','2012-08-06 16:33:01','0000-00-00 00:00:00'),
 (4,'2012-10-17','','2012-08-23 09:01:40','0000-00-00 00:00:00'),
 (4,'2012-10-18','','2012-09-21 06:35:20','0000-00-00 00:00:00'),
 (4,'2012-10-19','Yellow Card Training','2012-10-05 08:30:09','0000-00-00 00:00:00'),
 (4,'2012-10-22','','2012-08-31 14:41:24','0000-00-00 00:00:00'),
 (4,'2012-10-23','Health & Safety: Site Managers w/K Gillespie','2012-08-23 09:02:08','0000-00-00 00:00:00'),
 (4,'2012-10-24','','2012-09-03 07:38:10','0000-00-00 00:00:00'),
 (4,'2012-10-25','','2012-09-03 07:38:42','0000-00-00 00:00:00'),
 (4,'2012-10-26','','2012-09-03 07:39:24','0000-00-00 00:00:00'),
 (4,'2012-10-29','M1028 - Confined Spaces Refresher','2012-08-06 16:33:43','0000-00-00 00:00:00'),
 (4,'2012-10-30','M1028 - Confined Spaces Refresher','2012-08-06 16:34:16','0000-00-00 00:00:00'),
 (4,'2012-10-31','M1028 - Confined Spaces Refresher','2012-08-06 16:34:45','0000-00-00 00:00:00'),
 (4,'2012-11-01','P1210R','2012-07-30 16:49:06','0000-00-00 00:00:00'),
 (4,'2012-11-02','Health & Safety: Site Managers w/K Gillespie','2012-07-30 16:50:04','0000-00-00 00:00:00'),
 (4,'2012-11-05','APR Training Course','2012-03-19 14:33:01','0000-00-00 00:00:00'),
 (4,'2012-11-06','APR Training Course','2012-03-19 14:33:12','0000-00-00 00:00:00'),
 (4,'2012-11-07','APR Training Course','2012-03-19 14:33:28','0000-00-00 00:00:00'),
 (4,'2012-11-08','APR Training Course','2012-03-19 14:33:39','0000-00-00 00:00:00'),
 (4,'2012-11-09','APR Training Course','2012-03-19 14:33:54','0000-00-00 00:00:00'),
 (4,'2012-11-12','APR Training Course','2012-03-19 14:34:26','0000-00-00 00:00:00'),
 (4,'2012-11-13','APR Training Course','2012-03-19 14:34:36','0000-00-00 00:00:00'),
 (4,'2012-11-14','SC1200 - DAY 3 - RF0001','2012-03-19 14:34:48','0000-00-00 00:00:00'),
 (4,'2012-11-15','DAY 4 - SC1100','2012-03-19 14:35:04','0000-00-00 00:00:00'),
 (4,'2012-11-16','','2012-03-19 14:35:17','0000-00-00 00:00:00'),
 (4,'2012-11-19','OS&A Meeting ','2012-01-31 15:02:44','0000-00-00 00:00:00'),
 (4,'2012-11-20','','2012-07-30 16:45:33','0000-00-00 00:00:00'),
 (4,'2012-11-21','','2012-07-30 16:46:07','0000-00-00 00:00:00'),
 (4,'2012-11-22','','2012-07-30 16:46:39','0000-00-00 00:00:00'),
 (4,'2012-11-23','','2012-10-05 08:43:31','0000-00-00 00:00:00'),
 (4,'2012-11-27','','2012-07-30 16:47:09','0000-00-00 00:00:00'),
 (4,'2012-11-28','','2012-07-30 16:47:39','0000-00-00 00:00:00'),
 (4,'2012-11-29','','2012-10-05 08:44:27','0000-00-00 00:00:00'),
 (4,'2012-11-30','','2012-07-30 16:48:13','0000-00-00 00:00:00'),
 (4,'2012-12-06','','2012-08-06 16:39:48','0000-00-00 00:00:00'),
 (4,'2012-12-17','OS&A Meeting ','2012-01-31 15:03:02','0000-00-00 00:00:00'),
 (4,'2012-12-25','Merry Xmas','2012-08-06 16:40:39','0000-00-00 00:00:00'),
 (5,'2012-01-23','','2012-01-23 14:26:01','0000-00-00 00:00:00'),
 (5,'2012-01-24','ESR initial Training 12pm to 4pm','2012-01-23 14:25:30','0000-00-00 00:00:00'),
 (5,'2012-01-25','','2012-01-23 14:27:51','0000-00-00 00:00:00'),
 (5,'2012-02-02','ASP Statutory Training 7am to 11am','2012-01-23 14:29:01','0000-00-00 00:00:00'),
 (5,'2012-02-06','','2012-01-24 09:40:13','0000-00-00 00:00:00'),
 (5,'2012-02-07','','2012-01-24 09:40:22','0000-00-00 00:00:00'),
 (5,'2012-02-08','','2012-01-30 07:18:29','0000-00-00 00:00:00'),
 (5,'2012-02-09','','2012-02-06 07:28:38','0000-00-00 00:00:00'),
 (5,'2012-02-10','','2012-02-06 07:28:48','0000-00-00 00:00:00'),
 (5,'2012-02-15','','2012-02-06 15:19:45','0000-00-00 00:00:00'),
 (5,'2012-02-16','','2012-02-09 13:56:01','0000-00-00 00:00:00'),
 (5,'2012-02-20','','2012-01-23 14:30:24','0000-00-00 00:00:00'),
 (5,'2012-02-21','','2012-01-23 14:30:31','0000-00-00 00:00:00'),
 (5,'2012-02-22','','2012-02-20 07:53:27','0000-00-00 00:00:00'),
 (5,'2012-02-23','','2012-01-23 14:30:52','0000-00-00 00:00:00'),
 (5,'2012-02-27','','2012-02-20 07:54:11','0000-00-00 00:00:00'),
 (5,'2012-02-28','','2012-01-23 14:32:56','0000-00-00 00:00:00'),
 (5,'2012-02-29','','2012-01-23 14:34:02','0000-00-00 00:00:00'),
 (5,'2012-03-01','ASP Statutory Training','2012-02-06 15:22:13','0000-00-00 00:00:00'),
 (5,'2012-03-02','','2012-02-06 15:21:24','0000-00-00 00:00:00'),
 (5,'2012-03-05','','2012-01-23 14:35:08','0000-00-00 00:00:00'),
 (5,'2012-03-06','','2012-01-23 14:35:15','0000-00-00 00:00:00'),
 (5,'2012-03-07','','2012-01-23 14:35:23','0000-00-00 00:00:00'),
 (5,'2012-03-08','','2012-01-23 14:35:30','0000-00-00 00:00:00'),
 (5,'2012-03-12','','2012-03-06 07:32:30','0000-00-00 00:00:00'),
 (5,'2012-03-13','','2012-01-24 09:41:42','0000-00-00 00:00:00'),
 (5,'2012-03-14','','2012-01-24 09:41:50','0000-00-00 00:00:00'),
 (5,'2012-03-19','','2012-01-23 14:36:09','0000-00-00 00:00:00'),
 (5,'2012-03-22','','2012-03-22 07:47:42','0000-00-00 00:00:00'),
 (5,'2012-03-23','Corp OHS: Contractor Safety Working Group','2012-03-22 18:46:55','0000-00-00 00:00:00'),
 (5,'2012-03-26','','2012-03-26 06:04:42','0000-00-00 00:00:00'),
 (5,'2012-04-02','','2012-03-26 06:15:50','0000-00-00 00:00:00'),
 (5,'2012-04-03','','2012-04-02 12:41:02','0000-00-00 00:00:00'),
 (5,'2012-04-04','Contractor Inductions (Room Booking Cancelled)','2012-04-02 07:07:24','0000-00-00 00:00:00'),
 (5,'2012-04-05','','2012-04-03 07:10:43','0000-00-00 00:00:00'),
 (5,'2012-04-06','Happy Easter','2012-04-05 06:26:21','0000-00-00 00:00:00'),
 (5,'2012-04-07','Happy Easter','2012-04-05 06:26:43','0000-00-00 00:00:00'),
 (5,'2012-04-08','Happy Easter','2012-04-05 06:27:05','0000-00-00 00:00:00'),
 (5,'2012-04-09','Happy Easter','2012-04-05 06:27:24','0000-00-00 00:00:00'),
 (5,'2012-04-11','','2012-03-29 14:52:58','0000-00-00 00:00:00'),
 (5,'2012-04-16','','2012-01-31 15:00:15','0000-00-00 00:00:00'),
 (5,'2012-04-17','','2012-02-06 15:24:04','0000-00-00 00:00:00'),
 (5,'2012-04-18','','2012-03-12 09:27:51','0000-00-00 00:00:00'),
 (5,'2012-04-19','','2012-03-12 09:28:10','0000-00-00 00:00:00'),
 (5,'2012-04-24','Contractor Induction','2012-03-12 09:28:30','0000-00-00 00:00:00'),
 (5,'2012-04-25','','2012-03-12 09:28:49','0000-00-00 00:00:00'),
 (5,'2012-04-26','','2012-03-12 09:29:01','0000-00-00 00:00:00'),
 (5,'2012-04-27','','2012-04-16 09:47:12','0000-00-00 00:00:00'),
 (5,'2012-04-30','','2012-03-20 15:25:22','0000-00-00 00:00:00'),
 (5,'2012-05-01','','2012-03-12 09:29:19','0000-00-00 00:00:00'),
 (5,'2012-05-02','Owning your Career Training - Part A ','2012-01-31 15:04:30','0000-00-00 00:00:00'),
 (5,'2012-05-03','Training in Procedure and Documentation Writing','2012-03-12 09:30:39','0000-00-00 00:00:00'),
 (5,'2012-05-04','Somersby Training Centre Open day','2012-03-26 06:11:03','0000-00-00 00:00:00'),
 (5,'2012-05-08','','2012-04-17 07:07:41','0000-00-00 00:00:00'),
 (5,'2012-05-09','Contractor Induction','2012-03-26 08:59:41','0000-00-00 00:00:00'),
 (5,'2012-05-10','','2012-05-04 09:13:40','0000-00-00 00:00:00'),
 (5,'2012-05-14','','2012-05-09 08:57:15','0000-00-00 00:00:00'),
 (5,'2012-05-15','ESR Initial','2012-04-16 09:51:16','0000-00-00 00:00:00'),
 (5,'2012-05-16','Subs Entry 2nd Day','2012-01-31 15:07:16','0000-00-00 00:00:00'),
 (5,'2012-05-17','','2012-04-16 09:52:39','0000-00-00 00:00:00'),
 (5,'2012-05-18','','2012-04-16 09:53:05','0000-00-00 00:00:00'),
 (5,'2012-05-21','Business Continuity Planning Site Visit','2012-01-31 15:00:28','0000-00-00 00:00:00'),
 (5,'2012-05-22','ESR/Enviro Refresher','2012-04-16 09:53:44','0000-00-00 00:00:00'),
 (5,'2012-05-23','','2012-04-16 09:54:11','0000-00-00 00:00:00'),
 (5,'2012-05-24','','2012-05-14 15:42:12','0000-00-00 00:00:00'),
 (5,'2012-05-25','','2012-01-31 15:07:53','0000-00-00 00:00:00'),
 (5,'2012-05-28','','2012-04-16 09:55:20','0000-00-00 00:00:00'),
 (5,'2012-05-29','','2012-04-16 09:55:52','0000-00-00 00:00:00'),
 (5,'2012-05-30','','2012-04-16 09:56:22','0000-00-00 00:00:00'),
 (5,'2012-05-31','','2012-04-16 09:56:47','0000-00-00 00:00:00'),
 (5,'2012-06-01','','2012-04-16 09:57:13','0000-00-00 00:00:00'),
 (5,'2012-06-04','','2012-05-29 13:42:14','0000-00-00 00:00:00'),
 (5,'2012-06-05','','2012-05-14 15:44:23','0000-00-00 00:00:00');
INSERT INTO `room_activities` (`room_id`,`activity_date`,`activity_name`,`created`,`updated`) VALUES 
 (5,'2012-06-06','','2012-06-05 10:38:02','0000-00-00 00:00:00'),
 (5,'2012-06-07','','2012-04-16 09:57:48','0000-00-00 00:00:00'),
 (5,'2012-06-08','','2012-06-01 08:35:05','0000-00-00 00:00:00'),
 (5,'2012-06-12','','2012-04-16 09:58:17','0000-00-00 00:00:00'),
 (5,'2012-06-13','','2012-05-29 13:45:49','0000-00-00 00:00:00'),
 (5,'2012-06-18','Subs SC1200 Training ESR','2012-01-31 15:00:55','0000-00-00 00:00:00'),
 (5,'2012-06-19','Contractor Induction','2012-04-16 09:58:52','0000-00-00 00:00:00'),
 (5,'2012-06-20','TSO Safety Meeting','2012-05-10 11:34:04','0000-00-00 00:00:00'),
 (5,'2012-06-21','RF0003  Tony Bagnall','2012-04-16 09:59:12','0000-00-00 00:00:00'),
 (5,'2012-06-25','','2012-06-13 15:01:35','0000-00-00 00:00:00'),
 (5,'2012-06-26','OHS Investigation Form - Familiarisation of Inv form and process','2012-05-29 13:57:36','0000-00-00 00:00:00'),
 (5,'2012-06-27','Cadet Training','2012-05-29 13:58:11','0000-00-00 00:00:00'),
 (5,'2012-06-28','','2012-05-29 14:04:10','0000-00-00 00:00:00'),
 (5,'2012-06-29','Tech Training Yearly review','2012-02-20 09:27:32','0000-00-00 00:00:00'),
 (5,'2012-07-02','','2012-06-28 15:25:06','0000-00-00 00:00:00'),
 (5,'2012-07-03','','2012-06-01 08:43:10','0000-00-00 00:00:00'),
 (5,'2012-07-04','','2012-06-13 15:08:22','0000-00-00 00:00:00'),
 (5,'2012-07-05','Reg Training - RF0003','2012-06-01 08:43:44','0000-00-00 00:00:00'),
 (5,'2012-07-06','','2012-06-28 15:25:48','0000-00-00 00:00:00'),
 (5,'2012-07-11','Owning your Career Training - Part A ','2012-01-31 15:08:30','0000-00-00 00:00:00'),
 (5,'2012-07-12','','2012-03-19 14:31:26','0000-00-00 00:00:00'),
 (5,'2012-07-16','User testing (UAT) - Investigation Form','2012-01-31 15:01:16','0000-00-00 00:00:00'),
 (5,'2012-07-17','','2012-06-27 08:37:30','0000-00-00 00:00:00'),
 (5,'2012-07-18','','2012-06-01 08:45:24','0000-00-00 00:00:00'),
 (5,'2012-07-19','','2012-06-01 08:46:15','0000-00-00 00:00:00'),
 (5,'2012-07-23','REX Testing','2012-06-01 08:47:06','0000-00-00 00:00:00'),
 (5,'2012-07-24','','2012-06-01 08:47:27','0000-00-00 00:00:00'),
 (5,'2012-07-25','','2012-01-31 15:09:59','0000-00-00 00:00:00'),
 (5,'2012-07-26','','2012-06-01 08:47:57','0000-00-00 00:00:00'),
 (5,'2012-07-27','','2012-06-01 08:48:12','0000-00-00 00:00:00'),
 (5,'2012-07-30','','2012-06-01 08:48:32','0000-00-00 00:00:00'),
 (5,'2012-07-31','Contractor Inductions','2012-06-01 08:48:48','0000-00-00 00:00:00'),
 (5,'2012-08-01','RF0003 - Reg Training','2012-06-01 08:49:07','0000-00-00 00:00:00'),
 (5,'2012-08-02','','2012-06-27 08:40:32','0000-00-00 00:00:00'),
 (5,'2012-08-06','','2012-06-01 08:49:29','0000-00-00 00:00:00'),
 (5,'2012-08-07','RF0003 - Reg Training','2012-06-01 08:49:45','0000-00-00 00:00:00'),
 (5,'2012-08-08','REX Technical Training ','2012-06-01 08:49:57','0000-00-00 00:00:00'),
 (5,'2012-08-09','','2012-06-01 08:50:11','0000-00-00 00:00:00'),
 (5,'2012-08-10','','2012-06-01 08:50:24','0000-00-00 00:00:00'),
 (5,'2012-08-13','','2012-06-01 08:50:40','0000-00-00 00:00:00'),
 (5,'2012-08-14','RF0003 - Reg Training','2012-06-27 08:43:28','0000-00-00 00:00:00'),
 (5,'2012-08-15','RF0003 - Reg Training','2012-06-27 08:43:57','0000-00-00 00:00:00'),
 (5,'2012-08-16','RF0003 - Reg Training','2012-06-27 08:44:39','0000-00-00 00:00:00'),
 (5,'2012-08-20','','2012-01-31 15:01:42','0000-00-00 00:00:00'),
 (5,'2012-08-21','','2012-05-10 12:01:12','0000-00-00 00:00:00'),
 (5,'2012-08-22','','2012-05-10 12:01:50','0000-00-00 00:00:00'),
 (5,'2012-08-23','','2012-07-25 10:11:08','0000-00-00 00:00:00'),
 (5,'2012-08-24','','2012-01-31 15:10:36','0000-00-00 00:00:00'),
 (5,'2012-08-27','','2012-06-01 08:51:58','0000-00-00 00:00:00'),
 (5,'2012-08-28','','2012-06-01 08:52:23','0000-00-00 00:00:00'),
 (5,'2012-08-29','','2012-06-01 08:52:36','0000-00-00 00:00:00'),
 (5,'2012-08-30','','2012-06-01 08:52:52','0000-00-00 00:00:00'),
 (5,'2012-08-31','','2012-06-01 08:53:07','0000-00-00 00:00:00'),
 (5,'2012-09-04','REX Training','2012-07-25 08:17:44','0000-00-00 00:00:00'),
 (5,'2012-09-05','Ausgrid Protection Testing Group','2012-07-25 08:18:35','0000-00-00 00:00:00'),
 (5,'2012-09-06','','2012-07-25 08:19:21','0000-00-00 00:00:00'),
 (5,'2012-09-10','','2012-08-06 15:45:36','0000-00-00 00:00:00'),
 (5,'2012-09-11','Contractor Induction','2012-07-25 08:19:59','0000-00-00 00:00:00'),
 (5,'2012-09-12','RF0003 - Reg Training','2012-07-25 08:20:32','0000-00-00 00:00:00'),
 (5,'2012-09-13','REX Training ','2012-07-27 15:17:45','0000-00-00 00:00:00'),
 (5,'2012-09-17','','2012-01-31 15:02:01','0000-00-00 00:00:00'),
 (5,'2012-09-18','ESR INITIAL 12pm -400pm','2012-07-30 16:37:52','0000-00-00 00:00:00'),
 (5,'2012-09-19','SUBS ENTRY 2nd DAY SC1200','2012-07-30 16:38:52','0000-00-00 00:00:00'),
 (5,'2012-09-20','','2012-07-30 16:39:57','0000-00-00 00:00:00'),
 (5,'2012-09-21','','2012-07-30 16:40:45','0000-00-00 00:00:00'),
 (5,'2012-09-24','ESR Initial (Subs Training)','2012-08-06 16:03:45','0000-00-00 00:00:00'),
 (5,'2012-09-25','Health & Safety: Site Managers w/K Gillespie','2012-08-23 08:58:51','0000-00-00 00:00:00'),
 (5,'2012-09-26','TSO Contractor Inductions','2012-08-31 14:18:47','0000-00-00 00:00:00'),
 (5,'2012-09-28','','2012-09-21 06:24:00','0000-00-00 00:00:00'),
 (5,'2012-10-02','Health & Safety: Site Managers w/K Gillespie','2012-08-23 08:59:41','0000-00-00 00:00:00'),
 (5,'2012-10-03','','2012-08-06 16:04:29','0000-00-00 00:00:00'),
 (5,'2012-10-04','','2012-08-06 16:04:57','0000-00-00 00:00:00'),
 (5,'2012-10-05','','2012-09-21 06:28:26','0000-00-00 00:00:00'),
 (5,'2012-10-08','','2012-09-21 06:30:30','0000-00-00 00:00:00'),
 (5,'2012-10-09','','2012-08-23 09:00:29','0000-00-00 00:00:00'),
 (5,'2012-10-10','REX Training ','2012-08-06 16:05:48','0000-00-00 00:00:00'),
 (5,'2012-10-11','Contractor Safety Training','2012-09-21 06:32:44','0000-00-00 00:00:00'),
 (5,'2012-10-12','','2012-09-21 06:33:27','0000-00-00 00:00:00'),
 (5,'2012-10-15','RF0003 - ESR/Environment','2012-01-31 15:02:23','0000-00-00 00:00:00'),
 (5,'2012-10-16','','2012-08-06 16:33:01','0000-00-00 00:00:00'),
 (5,'2012-10-17','','2012-08-23 09:01:40','0000-00-00 00:00:00'),
 (5,'2012-10-18','','2012-09-21 06:35:20','0000-00-00 00:00:00'),
 (5,'2012-10-19','','2012-10-05 08:30:09','0000-00-00 00:00:00'),
 (5,'2012-10-22','SC1100 - ESR DAY 1','2012-08-31 14:41:24','0000-00-00 00:00:00'),
 (5,'2012-10-23','Health & Safety: Site Managers w/K Gillespie','2012-08-23 09:02:08','0000-00-00 00:00:00'),
 (5,'2012-10-24','','2012-09-03 07:38:10','0000-00-00 00:00:00'),
 (5,'2012-10-25','TSO Contractor Inductions','2012-09-03 07:38:42','0000-00-00 00:00:00'),
 (5,'2012-10-26','TSO Contractor Inductions','2012-09-03 07:39:24','0000-00-00 00:00:00'),
 (5,'2012-10-29','SC1200 - ESR - DAY 1','2012-08-06 16:33:43','0000-00-00 00:00:00'),
 (5,'2012-10-30','SC1200 - SUBS ENTRY - DAY 2','2012-08-06 16:34:16','0000-00-00 00:00:00'),
 (5,'2012-10-31','','2012-08-06 16:34:45','0000-00-00 00:00:00'),
 (5,'2012-11-01','REX Training ','2012-07-30 16:49:06','0000-00-00 00:00:00'),
 (5,'2012-11-02','Health & Safety: Site Managers w/K Gillespie','2012-07-30 16:50:04','0000-00-00 00:00:00'),
 (5,'2012-11-05','Contractor Inductions for Crane Ops','2012-03-19 14:33:01','0000-00-00 00:00:00'),
 (5,'2012-11-06','M1028 - confined spaces refresher','2012-03-19 14:33:12','0000-00-00 00:00:00'),
 (5,'2012-11-07','C2 Training','2012-03-19 14:33:28','0000-00-00 00:00:00'),
 (5,'2012-11-08','','2012-03-19 14:33:39','0000-00-00 00:00:00'),
 (5,'2012-11-09','','2012-03-19 14:33:54','0000-00-00 00:00:00'),
 (5,'2012-11-12','SC1200 - DAY 1 ESR & DAY 2 SUBS','2012-03-19 14:34:26','0000-00-00 00:00:00'),
 (5,'2012-11-13','SC1200 - DAY 1 ESR & DAY 2 SUBS','2012-03-19 14:34:36','0000-00-00 00:00:00'),
 (5,'2012-11-14','Business Continuity Alternate Site Facility Exercise','2012-03-19 14:34:48','0000-00-00 00:00:00'),
 (5,'2012-11-15','Business Continuity Facilities Exercise (over 2 days)','2012-03-19 14:35:04','0000-00-00 00:00:00'),
 (5,'2012-11-16','','2012-03-19 14:35:17','0000-00-00 00:00:00'),
 (5,'2012-11-19','','2012-01-31 15:02:44','0000-00-00 00:00:00'),
 (5,'2012-11-20','','2012-07-30 16:45:33','0000-00-00 00:00:00'),
 (5,'2012-11-21','','2012-07-30 16:46:07','0000-00-00 00:00:00'),
 (5,'2012-11-22','','2012-07-30 16:46:39','0000-00-00 00:00:00'),
 (5,'2012-11-23','TSO Contractor Inductions','2012-10-05 08:43:31','0000-00-00 00:00:00'),
 (5,'2012-11-27','','2012-07-30 16:47:09','0000-00-00 00:00:00'),
 (5,'2012-11-28','','2012-07-30 16:47:39','0000-00-00 00:00:00'),
 (5,'2012-11-29','TSO Contractor Inductions','2012-10-05 08:44:27','0000-00-00 00:00:00'),
 (5,'2012-11-30','TSO Contractor Inductions','2012-07-30 16:48:13','0000-00-00 00:00:00'),
 (5,'2012-12-06','RF0003 - Reg Training','2012-08-06 16:39:48','0000-00-00 00:00:00'),
 (5,'2012-12-17','','2012-01-31 15:03:02','0000-00-00 00:00:00'),
 (5,'2012-12-25','Merry Xmas','2012-08-06 16:40:39','0000-00-00 00:00:00');


--
-- Definition of table `rooms`
--

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

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` (`id`,`name`) VALUES 
 (1,'Noraville Training Room'),
 (2,'Ourimbah Conference Room'),
 (3,'Somersby Training Room'),
 (4,'Umina Training Room'),
 (5,'West Gosford Computer Room');


--
-- 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=latin1;

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





