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





--
-- Create schema tablet_comms_dev
--

--
-- Definition of table `delegations`
--

CREATE TABLE `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 `delegations_ibfk_1` FOREIGN KEY (`delegator`) REFERENCES `users` (`service_number`),
  CONSTRAINT `delegations_ibfk_2` FOREIGN KEY (`delegatee`) REFERENCES `users` (`service_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `delegations`
--



--
-- Definition of table `document_categories`
--

CREATE TABLE `document_categories` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `code` varchar(16) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `document_categories`
--

INSERT INTO `document_categories` (`id`,`code`,`name`) VALUES 
 (1,'safe','Safety'),
 (2,'comms','Comms');


--
-- Definition of table `document_types`
--

CREATE TABLE `document_types` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `doc_category_id` tinyint(4) NOT NULL,
  `name` varchar(255) NOT NULL,
  `doc_dir` varchar(45) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_doc_category` (`doc_category_id`),
  CONSTRAINT `document_types_ibfk_1` FOREIGN KEY (`doc_category_id`) REFERENCES `document_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `document_types`
--

INSERT INTO `document_types` (`id`,`doc_category_id`,`name`,`doc_dir`) VALUES 
 (1,1,'Safety Advice','sa'),
 (2,1,'Safety Alert - Ausgrid','sala'),
 (3,1,'Safety Alert - 3rd Party','salt'),
 (4,1,'Safety Scoop','scoop'),
 (5,1,'Safety Topics','stop'),
 (6,2,'Weekly Broadcasts','wbc'),
 (7,2,'COO\'s Message','coom'),
 (8,2,'NERP','nerp'),
 (9,2,'NOp - Msg from GM','nomgm'),
 (10,2,'NOp - Team Briefs','notb'),
 (11,2,'NOp - Other Div Comms','noodc'),
 (12,2,'Inside Ausgrid','ia'),
 (13,2,'Other Comms','ocomm'),
 (14,2,'Logistic News','ln');


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

CREATE TABLE `login_codes` (
  `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 (`service_number`,`code`),
  CONSTRAINT `login_codes_ibfk_1` FOREIGN KEY (`service_number`) REFERENCES `users` (`service_number`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `login_codes` (`service_number`,`code`,`valid_until`) VALUES 
 (43880,'0034b3b7493a79aaf767406fac6b39e9','2013-05-20 16:38:59'),
 (43880,'034aa8ec69d9506d3c4bdc71073b549a','2013-05-20 17:05:22'),
 (43880,'0cb7986f67dd2b74d87e6fa7f79c1dd1','2013-05-20 17:10:33'),
 (43880,'0dce382e4285f322ea48349072ed65bb','2013-05-20 16:56:59'),
 (43880,'12786dd4ede093e981be44387031f6c3','2013-05-20 16:39:25'),
 (43880,'149899e8484e4a5ee514b243f51bcb8a','2013-05-15 18:14:47'),
 (43880,'2248accaf044341e4a382ba1b5eca448','2013-05-20 16:58:53'),
 (43880,'285f2f321367dd02d694b8507cd6e2cf','2013-05-20 17:08:55'),
 (43880,'290e62e85901e5906087f47b53bff5c2','2013-05-20 14:44:34'),
 (43880,'321c4a5223d24b84bae564d78300a597','2013-05-20 19:07:45'),
 (43880,'354f923d497abf64ad47c5dc5dddbfe9','2013-05-20 16:42:57'),
 (43880,'368a1f06cf4e0ec0c2c98450f71b45a8','2013-05-20 17:05:52'),
 (43880,'37cad2ce4d7ca2f05fd26578d8e02f03','2013-05-16 06:59:23'),
 (43880,'3b4d2dcc5c3b6e3da4fbe0399b616f3e','2013-05-20 16:38:36'),
 (43880,'3d51ae35a71914e59a8bb6bfc2cc664c','2013-05-20 14:49:03'),
 (43880,'44c43d7a736b4e9bdc99368774f06609','2013-05-20 16:37:26'),
 (43880,'4a0fc32b148a8376172dfb553be9b246','2013-05-20 16:44:20'),
 (43880,'4bf4fe77ac178ba6fd8dfd97ef9cd5e3','2013-05-20 18:58:43'),
 (43880,'4ee8c83e0d6c2483b95100de184f6385','2013-05-20 16:57:58'),
 (43880,'53175eca00811e19fd0602ee2be6f7af','2013-05-20 19:09:05'),
 (43880,'56f1684104bb2ec12352fcd709c8e6b8','2013-05-20 15:32:32'),
 (43880,'57720f3802a0754ed227f01e12e2c936','2013-05-20 15:33:10'),
 (43880,'5b2c8dea45abdd31ef1da69bd8481b2d','2013-05-20 17:30:40'),
 (43880,'69c0c9ea97961aa96c142322876815d4','2013-05-20 18:45:15'),
 (43880,'6b0aeaa3d32431624cd829ea06aa9d96','2013-05-20 16:38:00'),
 (43880,'730c27f46d7ca1056d801c9a67cd518a','2013-05-15 18:13:00'),
 (43880,'734edc37fd5dc9c251adfb7397e4294a','2013-05-20 16:29:55'),
 (43880,'774f43aab5153e9e90e5b12d1fd4e637','2013-05-20 16:41:05'),
 (43880,'78b89c76facab810671225d862bbf7e7','2013-05-15 13:51:05'),
 (43880,'7930de06b29319c959d18ff6641a16b2','2013-05-20 16:41:52'),
 (43880,'7dca064b80378d23a3ade0dd0b4db124','2013-05-20 19:11:47'),
 (43880,'80b6d4cede39adb20aa3672a4dc86436','2013-05-20 14:47:35'),
 (43880,'8354f6610bf89bf45b4ca0b43c8dd000','2013-05-20 16:34:46'),
 (43880,'844a37f5e31966c9b414470a2678a383','2013-05-20 17:03:07'),
 (43880,'8553e36f6226ef4b9aedbf4103154784','2013-05-20 15:33:50'),
 (43880,'87ed8118a49cda4502fe34d7660f871d','2013-05-20 16:36:42'),
 (43880,'8bbf6d29729aa95e0c8907f3d06675b0','2013-05-20 18:45:47'),
 (43880,'9150339fc766829f5fb5bf97a840d28e','2013-05-20 19:12:40'),
 (43880,'94478a228c31a37a2be1da50909ea9b6','2013-05-20 16:30:38'),
 (43880,'a227c1f76be7bcfb2cb41d82db14b587','2013-05-20 14:54:54'),
 (43880,'ab2a9fa6f984e10d58199dfb97a19a64','2013-05-20 17:04:56'),
 (43880,'acb28ee869ce33d42ab5b48428c4c4b0','2013-05-20 17:04:22'),
 (43880,'b03a37f7abd4af1a5c8308eaa6714d24','2013-05-20 16:32:21'),
 (43880,'b2205eb7afea085aa7005b0ef4c29997','2013-05-20 15:28:11'),
 (43880,'b2d30f09d0b05e7689ff90575cbef9ad','2013-05-20 16:34:20'),
 (43880,'b7514c1833722441200325ca8d8acf1a','2013-05-20 19:08:43'),
 (43880,'bb22c6345fad9d2745554ed8147cc291','2013-04-22 14:11:09'),
 (43880,'bff3f980876f8222e985bb7796bdf707','2013-05-20 16:31:19'),
 (43880,'c0f46888afac6a5dac8d56042c6e7e9a','2013-05-20 14:53:45'),
 (43880,'c32f3a491a50ce359512a2d88850c641','2013-05-20 19:09:45'),
 (43880,'cfe35ece5ff9a0962d1e74fc5cf9cfad','2013-05-20 16:43:26'),
 (43880,'d1a5a18ea9a92a43e2a1b90bee953204','2013-04-22 14:10:29'),
 (43880,'d53a2ddfb96ac24452cc7baf0252bf95','2013-05-20 16:21:20'),
 (43880,'dbed7ed5561b93524cce4336a5f24c54','2013-05-20 15:30:06'),
 (43880,'dcd92d41c1101e7c2861b210c2f73623','2013-05-15 17:54:53'),
 (43880,'de983947e6308db44710c6497609cc03','2013-05-20 14:41:44'),
 (43880,'e2ffe957f7a500fe43df3a788ac17b65','2013-05-20 14:43:27'),
 (43880,'f513aa7f00e13a29e578f4f966394adc','2013-05-20 16:33:06');


--
-- Definition of table `news`
--

CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `release_date` date DEFAULT NULL,
  `exp_date` date DEFAULT NULL,
  `heading` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `footer` varchar(255) DEFAULT NULL,
  `creator` int(11) NOT NULL,
  `status_id` tinyint(4) DEFAULT '1',
  `is_deleted` tinyint(1) DEFAULT '0',
  `news_category_id` tinyint(4) NOT NULL,
  `news_type_id` tinyint(4) DEFAULT NULL,
  `date_submitted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_status` (`status_id`),
  CONSTRAINT `news_ibfk_2` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`,`release_date`,`exp_date`,`heading`,`content`,`footer`,`creator`,`status_id`,`is_deleted`,`news_category_id`,`news_type_id`,`date_submitted`) VALUES 
 (7,'2013-01-04','2013-01-31','title','content','',47187,1,0,0,NULL,'2013-03-11 16:55:52'),
 (9,'2013-01-04','2013-01-31','title','content','',47187,1,0,0,NULL,'2013-03-11 16:55:52'),
 (10,'2013-01-04','2013-01-31','title','content',NULL,21900,1,0,0,NULL,'2013-03-11 16:55:52'),
 (11,'2013-01-04','2013-01-31','title','some content here.  will be cost centres 1618 and 1619.  two files.',NULL,21900,1,0,0,NULL,'2013-03-11 16:55:52'),
 (12,'2013-01-05','2013-01-31','t','c','fc',44300,1,0,0,NULL,'2013-03-11 16:55:52'),
 (13,'2013-01-05','2013-01-31','t','c','fc',44300,1,0,0,NULL,'2013-03-11 16:55:52'),
 (14,'2013-01-06','2013-01-31','t','c','fc',44300,1,0,0,NULL,'2013-03-11 16:55:52'),
 (15,'1969-12-31','1969-12-31',NULL,NULL,NULL,44300,1,0,0,NULL,'2013-03-11 16:55:52'),
 (16,'1969-12-31','1969-12-31','','','',44300,1,0,0,NULL,'2013-03-11 16:55:52'),
 (17,'1969-12-31','1969-12-31','','','',44300,1,0,0,NULL,'2013-03-11 16:55:52'),
 (18,'2013-01-07','2013-01-31','title','content','',44300,1,0,0,NULL,'2013-03-11 16:55:52'),
 (19,'1969-12-31','1969-12-31','','','',44300,1,0,0,NULL,'2013-03-11 16:55:52'),
 (20,NULL,NULL,NULL,NULL,NULL,44300,1,0,0,NULL,'2013-03-11 16:55:52'),
 (21,'2013-01-16','2013-01-24','sdfgsdfg','sdfgsdfgsdfg','ghdfghdfh',44300,2,0,1,1,'2013-03-11 16:55:52'),
 (22,'2013-01-16','2013-01-31','title','content',NULL,43880,1,0,2,NULL,'2013-03-11 16:55:52'),
 (23,'2013-01-16','2013-01-31','title','test',NULL,43880,1,0,2,NULL,'2013-03-11 16:55:52'),
 (24,'2013-01-16','2013-01-31','title','content',NULL,43880,1,0,2,NULL,'2013-03-11 16:55:52'),
 (25,'2013-01-16','2013-01-31','title','content',NULL,47187,1,0,2,NULL,'2013-03-11 16:55:52'),
 (26,'2013-01-16','2013-01-31','title','content',NULL,43880,1,0,2,NULL,'2013-03-11 16:55:52'),
 (27,'2013-04-02','2013-04-09','Test 1 - News Only','Release Date Expiry Date News\r\n02/04/2013 09/04/2013\r\nNo Footer\r\n\r\nWhere is the carriage return?',NULL,44300,1,0,1,1,'2013-03-11 16:55:52'),
 (28,'2013-03-20','2013-06-28','Test 2 - News Only','Release Date Expiry Date\r\n20/03/2013 28/06/2013\r\nWith Footer','Test 2 - News Only',44300,1,0,1,1,'2013-03-11 16:55:52'),
 (29,'1970-01-01','1970-01-01',NULL,NULL,'Testing',44300,1,0,1,2,'2013-03-11 16:55:52'),
 (30,NULL,NULL,NULL,NULL,'Test - New safety and WB',44300,1,0,1,2,'2013-03-11 16:55:52'),
 (31,'2013-03-20','2013-03-30','Test 5 - Both no footer','Release Date Expiry Date \r\n20/03/2013 30/03/2013\r\nno footer',NULL,44300,1,0,1,3,'2013-03-11 16:55:52'),
 (32,'2013-03-28','2013-05-16','Supervisor test 1','Release Date Expiry Date News Title\r\n28/03/2013  16/05/2013\r\nSupervisor test 1\r\nNo Attachment',NULL,40154,1,0,2,NULL,'2013-03-11 16:55:52'),
 (33,'2013-03-29','2013-05-16','Supervisor test 2','Release Date Expiry Date \r\n29/03/2013 16/05/2013\r\nSupervisor test 2\r\nNo attachment\r\nTest 1 - Cancelled\r\nTest 2 - Submit',NULL,40154,2,0,2,NULL,'2013-03-11 16:55:52'),
 (34,'2013-03-29','2013-03-31','Supervisor test 3','Release Date Expiry Date \r\n29/03/2013 31/03/2013\r\nSupervisor test 3\r\nWith attachment',NULL,40154,2,0,2,NULL,'2013-03-11 16:55:52'),
 (35,'2013-03-26','2013-03-30','Supervisor 2 test 3','Release Date Expiry Date \r\n26/03/2013 30/03/2013\r\nSupervisor 2 test 3\r\nCost Centre 5108',NULL,45358,1,0,2,NULL,'2013-03-11 16:55:52'),
 (36,'2013-03-21','2013-03-30','Supervisor Test - 11/03','Supervisor Test - 11/03',NULL,40154,1,0,2,NULL,'2013-03-11 16:55:52'),
 (37,'2013-03-28','2013-04-26','Supervisor test - 11/03 #2','Supervisor test - 11/03 #2',NULL,40154,1,0,2,NULL,'2013-03-11 16:55:52'),
 (38,'2013-03-25','2013-03-30','Test for 5103','Test for 5103',NULL,45358,1,0,2,NULL,'2013-03-11 16:55:52'),
 (39,'2013-04-09','2013-04-26','Test for 5108','Test for 5108',NULL,45358,1,0,2,NULL,'2013-03-11 16:55:52'),
 (40,'2013-05-16','2013-05-27','Test for 5103 & 5108','Test for 5103 & 5108\r\n\r\nAdd more content\r\n',NULL,45358,1,0,2,NULL,'2013-03-11 16:55:52'),
 (41,'2013-03-12','2013-03-27','News Only','News only',NULL,44300,1,0,1,1,'2013-03-11 16:55:52'),
 (42,'2013-03-12','2013-03-28','News & Footer','News & Footer','News & Footer',44300,1,0,1,1,'2013-03-11 16:55:52'),
 (43,NULL,NULL,NULL,NULL,'Document Only',44300,1,0,1,2,'2013-03-11 16:55:52'),
 (44,'2013-03-12','2013-03-30','News and Doc','News and Doc','News and Doc',44300,1,0,1,3,'2013-03-11 16:55:52'),
 (45,'2013-03-21','2013-03-27','Slips, trips and falls','Slips, trips and falls caused 195 injuries at Ausgrid in 2011-2012.  ','Avoid slips & trips. Be aware & remove or isolate hazards ',44300,1,0,1,2,'2013-03-18 15:31:04'),
 (46,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-03-18 15:34:11'),
 (47,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-03-18 15:34:39'),
 (48,'1970-01-01','1970-01-01',NULL,NULL,'This is testing the slips trips and fall doco link in the footer.',44300,1,0,1,2,'2013-03-18 15:36:36'),
 (49,'2013-03-25','2013-03-30','Corp Doc Upload','Corp Doc Upload',NULL,44300,1,0,1,3,'2013-03-19 07:43:43'),
 (50,'2013-03-26','2013-03-29','Test Multiple Centres News','Testing multiple users',NULL,45358,1,0,2,NULL,'2013-03-19 10:42:41'),
 (51,'2013-03-20','2013-03-29','Update Yor Tablets','Just a reminder to Update your tablets on a weekly basis',NULL,40154,1,0,2,NULL,'2013-03-19 12:10:36'),
 (52,'2013-04-18','2013-04-26','Corp - News Only Test 1','Corp - News Only Test 1',NULL,44300,1,0,1,1,'2013-04-15 14:10:29'),
 (53,'2013-04-25','2013-04-29','Corp - News Only Test 2','Corp - News Only Test 1 with footer',NULL,44300,1,0,1,1,'2013-04-15 14:11:09'),
 (54,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-08 13:51:05'),
 (69,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-08 17:54:53'),
 (70,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-08 18:13:00'),
 (71,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-08 18:14:47'),
 (72,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-09 06:59:23'),
 (73,'2013-05-21','2013-05-30','Test News title','test news content','this is footer',44300,1,0,1,1,'2013-05-13 14:41:44'),
 (74,'2013-05-14','2013-05-21','Title 1','Content 1','Footer 1',44300,1,0,1,1,'2013-05-13 14:43:27'),
 (75,'2013-05-14','2013-05-21','Title 1','Content 1','Footer 1',44300,1,0,1,1,'2013-05-13 14:44:34'),
 (76,'2013-05-14','2013-05-21','Title 1','Content 1','Footer 1',44300,1,0,1,1,'2013-05-13 14:47:35'),
 (77,'2013-05-14','2013-05-21','Title 1','Content 1','Footer 1',44300,1,0,1,1,'2013-05-13 14:49:03'),
 (78,'2013-05-14','2013-05-21','Title 1','Content 1','Footer 1',44300,1,0,1,1,'2013-05-13 14:53:45'),
 (79,'2013-05-14','2013-05-21','Title 1','Content 1','Footer 1',44300,1,0,1,1,'2013-05-13 14:54:54'),
 (80,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 15:28:11'),
 (81,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 15:30:06'),
 (82,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 15:32:32'),
 (83,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 15:33:10'),
 (84,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 15:33:50'),
 (85,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:21:20'),
 (86,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:29:55'),
 (87,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:30:38'),
 (88,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:31:19'),
 (89,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:32:21'),
 (90,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:33:06'),
 (91,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:34:20'),
 (92,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:34:46'),
 (93,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:36:42'),
 (94,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:37:26'),
 (95,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:38:00'),
 (96,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:38:36'),
 (97,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:38:59'),
 (98,'2013-05-14','2013-05-21','Title 1','Content 1','Footer 1',44300,1,0,1,1,'2013-05-13 16:39:25'),
 (99,'2013-05-14','2013-05-21','Title 1','Content 1','Footer 1',44300,1,0,1,1,'2013-05-13 16:41:05'),
 (100,'2013-05-14','2013-05-21','Title 1','Content 1','Footer 1',44300,1,0,1,1,'2013-05-13 16:41:52'),
 (101,'2013-05-14','2013-05-21','Title 1','Content 1','Footer 1',44300,1,0,1,1,'2013-05-13 16:42:57'),
 (102,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:43:26'),
 (103,'2013-05-14','2013-05-21','Title 1','Content 1','Footer 1',44300,1,0,1,1,'2013-05-13 16:44:20'),
 (104,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:56:59'),
 (105,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:57:58'),
 (106,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 16:58:53'),
 (107,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 17:03:07'),
 (108,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 17:04:22'),
 (109,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 17:04:56'),
 (110,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 17:05:22'),
 (111,NULL,NULL,NULL,NULL,NULL,44300,1,0,1,2,'2013-05-13 17:05:52'),
 (112,'2013-05-15','2013-05-30','Test Both','News Content for Both','Footer for Both',44300,1,0,1,3,'2013-05-13 17:08:55'),
 (113,'2013-05-15','2013-05-30','Test Both','News Content for Both','Footer for Both',44300,1,0,1,3,'2013-05-13 17:10:33'),
 (114,'2013-05-15','2013-05-30','Test Both','News Content for Both','Footer for Both',44300,1,0,1,3,'2013-05-13 17:30:40'),
 (115,'2013-05-15','2013-05-30','local news test','local news content for the test',NULL,21900,1,0,2,NULL,'2013-05-13 18:45:15'),
 (116,'2013-05-15','2013-05-30','local news test','local news content for the test',NULL,21900,1,0,2,NULL,'2013-05-13 18:45:47'),
 (117,'2013-05-15','2013-05-30','local news test','local news content for the test',NULL,21900,1,0,2,NULL,'2013-05-13 18:58:43'),
 (118,'2013-05-15','2013-05-30','local news test','local news content for the test',NULL,21900,1,0,2,NULL,'2013-05-13 19:07:45'),
 (119,'2013-05-15','2013-05-30','local news test','local news content for the test',NULL,21900,1,0,2,NULL,'2013-05-13 19:08:43'),
 (120,'2013-05-15','2013-05-30','local news test','local news content for the test',NULL,21900,1,0,2,NULL,'2013-05-13 19:09:05'),
 (121,'2013-05-15','2013-05-30','local news test','local news content for the test',NULL,21900,1,0,2,NULL,'2013-05-13 19:09:45'),
 (122,'2013-05-15','2013-05-30','local news test','local news content for the test',NULL,21900,1,0,2,NULL,'2013-05-13 19:11:47'),
 (123,'2013-05-15','2013-05-30','local news test','local news content for the test',NULL,21900,1,0,2,NULL,'2013-05-13 19:12:40');


--
-- Definition of table `news_categories`
--

CREATE TABLE `news_categories` (
  `id` tinyint(4) NOT NULL,
  `code` varchar(16) NOT NULL,
  `name` varchar(255) NOT NULL,
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `news_categories`
--

INSERT INTO `news_categories` (`id`,`code`,`name`) VALUES 
 (1,'corporate','Corporate'),
 (2,'local','Local');


--
-- Definition of table `news_cost_centres`
--

CREATE TABLE `news_cost_centres` (
  `news_id` int(11) NOT NULL,
  `cost_centre` int(11) NOT NULL,
  PRIMARY KEY (`news_id`,`cost_centre`),
  CONSTRAINT `news_cost_centres_ibfk_1` FOREIGN KEY (`news_id`) REFERENCES `news` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `news_cost_centres`
--

INSERT INTO `news_cost_centres` (`news_id`,`cost_centre`) VALUES 
 (10,1618),
 (10,1619),
 (11,1618),
 (11,1619),
 (22,2101),
 (23,2101),
 (24,2101),
 (25,2101),
 (26,2101),
 (32,1607),
 (33,1607),
 (34,1607),
 (35,5108),
 (36,1607),
 (37,1607),
 (38,5103),
 (39,5108),
 (40,5103),
 (40,5108),
 (50,5103),
 (51,1607),
 (115,1618),
 (115,1619),
 (116,1618),
 (116,1619),
 (117,1618),
 (117,1619),
 (118,1618),
 (118,1619),
 (119,1618),
 (119,1619),
 (120,1618),
 (120,1619),
 (121,1618),
 (121,1619),
 (122,1618),
 (122,1619),
 (123,1618),
 (123,1619);


--
-- Definition of table `news_files`
--

CREATE TABLE `news_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `news_id` int(11) NOT NULL,
  `doc_type_id` tinyint(4) DEFAULT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `file_path` varchar(255) NOT NULL,
  `link_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_news` (`news_id`),
  KEY `idx_doc_type` (`doc_type_id`),
  CONSTRAINT `news_files_ibfk_1` FOREIGN KEY (`news_id`) REFERENCES `news` (`id`),
  CONSTRAINT `news_files_ibfk_2` FOREIGN KEY (`doc_type_id`) REFERENCES `document_types` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `news_files`
--

INSERT INTO `news_files` (`id`,`news_id`,`doc_type_id`,`file_name`,`file_path`,`link_name`) VALUES 
 (1,7,NULL,'TV Channels','comm/mdm/TV Channels',NULL),
 (2,7,NULL,'TV Channels','comm/mdm/TV Channels',NULL),
 (3,9,NULL,'TV Channels','mdm/TV Channels_2.pdf',NULL),
 (4,9,NULL,'TV Channels','mdm/TV Channels_3.pdf',NULL),
 (5,11,NULL,'TV Channels','lcomm/TV Channels.pdf',NULL),
 (6,11,NULL,'TV Channels','lcomm/TV Channels_1.pdf',NULL),
 (7,12,NULL,'TV Channels.pdf','/TV Channels.pdf',NULL),
 (8,14,3,'TV Channels.pdf','/TV Channels_1.pdf',NULL),
 (9,19,3,'TV Channels.pdf','/TV Channels_2.pdf',NULL),
 (10,20,4,'TV Channels.pdf','/TV Channels_3.pdf',NULL),
 (11,22,NULL,'TV Channels.pdf','/TV Channels_4.pdf',NULL),
 (12,22,NULL,'TV Channels.pdf','/TV Channels_5.pdf',NULL),
 (13,23,NULL,'TV Channels.pdf','/TV Channels_6.pdf',NULL),
 (14,23,NULL,'TV Channels.pdf','/TV Channels_7.pdf',NULL),
 (15,24,NULL,'TV Channels.pdf','/TV Channels_8.pdf',NULL),
 (16,24,NULL,'TV Channels.pdf','/TV Channels_9.pdf',NULL),
 (17,29,1,'Corporate Test 7.pdf','/Corporate Test 7.pdf',NULL),
 (18,29,6,'Corporate Test 8.pdf','/Corporate Test 8.pdf',NULL),
 (19,30,1,'Corporate Test 7.pdf','/Corporate Test 7_1.pdf',NULL),
 (20,30,6,'Corporate Test 8.pdf','/Corporate Test 8_1.pdf',NULL),
 (21,31,1,'Corporate Test 7.pdf','/Corporate Test 7_2.pdf',NULL),
 (22,34,NULL,'Supervisor Test 5.pdf','/Supervisor Test 5.pdf','Supervisor attachment'),
 (23,36,NULL,'Supervisor Test 5.pdf','/Supervisor Test 5_1.pdf','Supervisor Test - 11/03'),
 (24,37,NULL,'Supervisor Test 5.pdf','/Supervisor Test 5_2.pdf','Supervisor test - 11/03 #2'),
 (25,37,NULL,'Supervisor Test 6.pdf','/Supervisor Test 6.pdf','Supervisor test - 11/03 #2.1'),
 (26,40,NULL,'Supervisor Test 5.pdf','/Supervisor Test 5_3.pdf','Link Name'),
 (27,40,NULL,'Supervisor Test 6.pdf','/Supervisor Test 6_1.pdf','Link Name #2'),
 (28,31,7,'Corporate Test 8.pdf','/Corporate Test 8_2.pdf','Corp Link'),
 (29,43,5,'Corporate Test 7.pdf','/Corporate Test 7_3.pdf','Corp - Doc Only'),
 (30,44,8,'Corporate Test 7.pdf','/Corporate Test 7_4.pdf','News and Doc'),
 (31,40,NULL,'Supervisor Test 5.pdf','/Supervisor Test 5_4.pdf','Link Name #3'),
 (32,45,5,'slips trips falls - April 2013 APPROVED.pdf','/slips trips falls - April 2013 APPROVED.pdf','Slips trips and falls'),
 (33,46,5,'slips trips falls - April 2013 APPROVED.pdf','/slips trips falls - April 2013 APPROVED_1.pdf',''),
 (34,47,5,'slips trips falls - April 2013 APPROVED.pdf','/slips trips falls - April 2013 APPROVED_2.pdf',''),
 (35,48,1,'slips trips falls - April 2013 APPROVED.pdf','/slips trips falls - April 2013 APPROVED_3.pdf','Click here'),
 (36,49,9,'Corporate Test 7.pdf','/Corporate Test 7_5.pdf','Corp Doc'),
 (37,54,7,'AfariaReferenceAPIs.pdf','/AfariaReferenceAPIs.pdf','Test Validation'),
 (38,69,1,'afariareferenceapis.pdf','/afariareferenceapis.pdf','Test 2'),
 (39,70,8,'afariareferenceapis.pdf','/afariareferenceapis.pdf','dsafdsa'),
 (40,71,8,'afariareferenceapis.pdf','/afariareferenceapis_1.pdf','dsafdsa'),
 (41,72,8,'afariareferenceapis.pdf','/afariareferenceapis_2.pdf','dsafdsa'),
 (42,80,4,'afariareferenceapis.pdf','/afariareferenceapis.pdf','Link 1'),
 (43,81,4,'afariareferenceapis.pdf','/afariareferenceapis_1.pdf','Link 1'),
 (44,82,4,'afariareferenceapis.pdf','/afariareferenceapis_2.pdf','Link 1'),
 (45,83,4,'afariareferenceapis.pdf','/afariareferenceapis_3.pdf','Link 1'),
 (46,84,4,'afariareferenceapis.pdf','/afariareferenceapis_4.pdf','Link 1'),
 (47,85,4,'afariareferenceapis.pdf','/afariareferenceapis_5.pdf','Link 1'),
 (48,86,4,'afariareferenceapis.pdf','/afariareferenceapis_6.pdf','Link 1'),
 (49,87,4,'afariareferenceapis.pdf','/afariareferenceapis_7.pdf','Link 1'),
 (50,88,4,'afariareferenceapis.pdf','/afariareferenceapis_8.pdf','Link 1'),
 (51,89,4,'afariareferenceapis.pdf','/afariareferenceapis_9.pdf','Link 1'),
 (52,90,4,'afariareferenceapis.pdf','/afariareferenceapis_10.pdf','Link 1'),
 (53,91,4,'afariareferenceapis.pdf','/afariareferenceapis_11.pdf','Link 1'),
 (54,92,4,'afariareferenceapis.pdf','/afariareferenceapis_12.pdf','Link 1'),
 (55,93,4,'afariareferenceapis.pdf','/afariareferenceapis_13.pdf','Link 1'),
 (56,94,4,'afariareferenceapis.pdf','/afariareferenceapis_14.pdf','Link 1'),
 (57,95,4,'afariareferenceapis.pdf','/afariareferenceapis_15.pdf','Link 1'),
 (58,96,4,'afariareferenceapis.pdf','/afariareferenceapis_16.pdf','Link 1'),
 (59,97,4,'afariareferenceapis.pdf','/afariareferenceapis_17.pdf','Link 1'),
 (60,102,4,'afariareferenceapis.pdf','/afariareferenceapis_18.pdf','Link 1'),
 (61,104,4,'afariareferenceapis.pdf','/afariareferenceapis_19.pdf','Link 1'),
 (62,105,4,'afariareferenceapis.pdf','/afariareferenceapis_20.pdf','Link 1'),
 (63,106,4,'afariareferenceapis.pdf','/afariareferenceapis_21.pdf','Link 1'),
 (64,107,4,'afariareferenceapis.pdf','/afariareferenceapis_22.pdf','Link 1'),
 (65,108,4,'afariareferenceapis.pdf','/afariareferenceapis_23.pdf','Link 1'),
 (66,109,4,'afariareferenceapis.pdf','/afariareferenceapis_24.pdf','Link 1'),
 (67,110,4,'afariareferenceapis.pdf','/afariareferenceapis_25.pdf','Link 1'),
 (68,111,4,'afariareferenceapis.pdf','/afariareferenceapis_26.pdf','Link 1'),
 (69,112,2,'afariareferenceapis.pdf','/afariareferenceapis.pdf','Link 1'),
 (70,112,5,'d7bcd.pdf','/d7bcd.pdf','Link 2'),
 (71,112,11,'inspectionform_temp.pdf','/inspectionform_temp.pdf','Link 3'),
 (72,113,2,'afariareferenceapis.pdf','/afariareferenceapis_1.pdf','Link 1'),
 (73,113,5,'d7bcd.pdf','/d7bcd_1.pdf','Link 2'),
 (74,113,11,'inspectionform_temp.pdf','/inspectionform_temp_1.pdf','Link 3'),
 (75,114,2,'afariareferenceapis.pdf','/afariareferenceapis_2.pdf','Link 1'),
 (76,114,5,'d7bcd.pdf','/d7bcd_2.pdf','Link 2'),
 (77,114,11,'inspectionform_temp.pdf','/inspectionform_temp_2.pdf','Link 3'),
 (78,115,NULL,'afariareferenceapis.pdf','/afariareferenceapis.pdf','Test link'),
 (79,115,NULL,'afariareferenceapis.pdf','/afariareferenceapis_1.pdf','Another link'),
 (80,116,NULL,'afariareferenceapis.pdf','/afariareferenceapis_2.pdf','Test link'),
 (81,116,NULL,'afariareferenceapis.pdf','/afariareferenceapis_3.pdf','Another link'),
 (82,117,NULL,'afariareferenceapis.pdf','/afariareferenceapis_4.pdf','Test link'),
 (83,117,NULL,'afariareferenceapis.pdf','/afariareferenceapis_5.pdf','Another link'),
 (84,118,NULL,'afariareferenceapis.pdf','/afariareferenceapis_6.pdf','Test link'),
 (85,118,NULL,'afariareferenceapis.pdf','/afariareferenceapis_7.pdf','Another link'),
 (86,119,NULL,'afariareferenceapis.pdf','/afariareferenceapis_8.pdf','Test link'),
 (87,119,NULL,'afariareferenceapis.pdf','/afariareferenceapis_9.pdf','Another link'),
 (88,120,NULL,'afariareferenceapis.pdf','/afariareferenceapis_10.pdf','Test link'),
 (89,120,NULL,'afariareferenceapis.pdf','/afariareferenceapis_11.pdf','Another link'),
 (90,121,NULL,'afariareferenceapis.pdf','/afariareferenceapis_12.pdf','Test link'),
 (91,121,NULL,'afariareferenceapis.pdf','/afariareferenceapis_13.pdf','Another link'),
 (92,122,NULL,'afariareferenceapis.pdf','/afariareferenceapis_14.pdf','Test link'),
 (93,122,NULL,'afariareferenceapis.pdf','/afariareferenceapis_15.pdf','Another link'),
 (94,123,NULL,'afariareferenceapis.pdf','/afariareferenceapis_16.pdf','Test link'),
 (95,123,NULL,'afariareferenceapis.pdf','/afariareferenceapis_17.pdf','Another link');


--
-- Definition of table `news_types`
--

CREATE TABLE `news_types` (
  `id` tinyint(4) NOT NULL,
  `code` varchar(16) NOT NULL,
  `name` varchar(255) NOT NULL,
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `news_types`
--

INSERT INTO `news_types` (`id`,`code`,`name`) VALUES 
 (3,'both','Both'),
 (2,'document_only','Docuemnt Only'),
 (1,'news_only','News Only');


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

--
-- 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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

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

INSERT INTO `permission_roles` (`id`,`name`,`description`) VALUES 
 (1,'superuser',NULL),
 (2,'supervisor',NULL),
 (3,'corporate',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 DEFAULT CHARSET=utf8;

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



--
-- Definition of table `statuses`
--

CREATE TABLE `statuses` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `code` varchar(32) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `statuses`
--

INSERT INTO `statuses` (`id`,`code`,`name`) VALUES 
 (1,'pending','Pending'),
 (2,'published','Published'),
 (3,'declined','Declined');


--
-- Definition of table `user_cost_centres`
--

CREATE TABLE `user_cost_centres` (
  `service_number` int(11) NOT NULL,
  `cost_centre` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`service_number`,`cost_centre`),
  CONSTRAINT `user_cost_centres_ibfk_1` FOREIGN KEY (`service_number`) REFERENCES `users` (`service_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_cost_centres`
--

INSERT INTO `user_cost_centres` (`service_number`,`cost_centre`) VALUES 
 (21900,1618),
 (21900,1619),
 (24727,1916),
 (26654,1617),
 (27256,1762),
 (27732,1761),
 (28598,1608),
 (29478,1629),
 (29535,4718),
 (31563,1762),
 (31584,1912),
 (33219,5002),
 (33423,1644),
 (33514,1630),
 (33629,4720),
 (34475,1639),
 (34969,1637),
 (35880,1641),
 (36592,1632),
 (36592,1635),
 (36759,1665),
 (37805,1636),
 (37827,1633),
 (38050,1619),
 (38886,1620),
 (39713,1631),
 (40026,1640),
 (40055,1616),
 (40140,1621),
 (40154,1607),
 (41122,1622),
 (42027,1915),
 (42357,1609),
 (43319,3704),
 (43391,5105),
 (43720,1649),
 (43880,2101),
 (44804,1660),
 (45151,1732),
 (45164,1734),
 (45358,5103),
 (45358,5108),
 (45545,3704),
 (45580,1647),
 (45907,2011),
 (45931,1648),
 (46123,5110),
 (46229,1668),
 (46351,1610),
 (46524,2011),
 (47070,2006),
 (47311,1669),
 (47571,1667),
 (47573,1666),
 (48253,1651),
 (49448,5109),
 (49953,3704),
 (54170,1623);


--
-- 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 
 (47187,1),
 (21900,2),
 (24727,2),
 (26654,2),
 (27256,2),
 (27732,2),
 (28598,2),
 (29478,2),
 (29535,2),
 (31563,2),
 (31584,2),
 (33219,2),
 (33423,2),
 (33514,2),
 (33629,2),
 (34475,2),
 (34969,2),
 (35880,2),
 (36592,2),
 (36759,2),
 (37805,2),
 (37827,2),
 (38050,2),
 (38886,2),
 (39713,2),
 (40026,2),
 (40055,2),
 (40140,2),
 (40154,2),
 (41122,2),
 (42027,2),
 (42357,2),
 (43319,2),
 (43391,2),
 (43720,2),
 (43880,2),
 (44804,2),
 (45151,2),
 (45164,2),
 (45358,2),
 (45545,2),
 (45580,2),
 (45907,2),
 (45931,2),
 (46123,2),
 (46229,2),
 (46351,2),
 (46524,2),
 (47070,2),
 (47311,2),
 (47571,2),
 (47573,2),
 (48253,2),
 (49448,2),
 (49953,2),
 (54170,2),
 (44300,3);


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

CREATE TABLE `users` (
  `service_number` int(11) NOT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email_addr` varchar(128) 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 
 (10000,NULL,NULL,NULL,NULL),
 (21900,'Joseph','Duggan','jduggan@ausgrid.com.au',''),
 (24727,'Bob','Porter','bporter@ausgrid.com.au',''),
 (26654,'David','Carter','dcarter@ausgrid.com.au',''),
 (27256,'Steve','Sutherland','ssutherl@ausgrid.com.au',''),
 (27732,'Bob','Philliponi','bphilliponi@ausgrid.com.au',''),
 (28598,'Bob','Jones','bjones@ausgrid.com.au',''),
 (29478,'Marshall','Parrott','mparrott@ausgrid.com.au',''),
 (29535,'Alex','Baird','abaird@ausgrid.com.au',''),
 (31563,'Geoff','Herd','gherd@ausgrid.com.au',''),
 (31584,'Peter','Rigby','prigby@ausgrid.com.au',''),
 (33219,'Greg','McKelvey','gmckelvey@ausgrid.com.au',''),
 (33423,'Keith','McKeown','kmckeown@ausgrid.com.au',''),
 (33514,'Bill','Macnaught','bmacnaught@ausgrid.com.au',''),
 (33629,'Phillip','Ryan','phillip.ryan@ausgrid.com.au',''),
 (34475,'Michael','Chapman','michael_chapman@ausgrid.com.au',''),
 (34969,'Collin','Smith','collinsmith@ausgrid.com.au',''),
 (35880,'Rob','North','rnorth@ausgrid.com.au',''),
 (36592,'Col','Steell','csteell@ausgrid.com.au',''),
 (36759,'John','Bristow','jbristow@ausgrid.com.au',''),
 (37805,'Trevor','Moss','tmoss@ausgrid.com.au',''),
 (37827,'Adam','Gaebel','agaebel@ausgrid.com.au',''),
 (38050,'Claudio','Oro','coro@ausgrid.com.au',''),
 (38886,'Paul','Riley','priley@ausgrid.com.au',''),
 (39713,'John B','Casey','jcasey@ausgrid.com.au',''),
 (40026,'Gregory','Sturgess','gsturges@ausgrid.com.au',''),
 (40055,'Bob','Bedford','bbedford@ausgrid.com.au',''),
 (40140,NULL,NULL,NULL,NULL),
 (40154,'Stuart','Cregan','scregan@ausgrid.com.au',''),
 (41122,'Glenn','Ible','gible@ausgrid.com.au',''),
 (42027,'Matthew','Joyce','mjoyce@ausgrid.com.au',''),
 (42357,'David','Larter','dlarter@ausgrid.com.au',''),
 (43319,'Ken','McGuinness','kmcguinn@ausgrid.com.au',''),
 (43391,'Steven','Mackie','smackie@ausgrid.com.au',''),
 (43720,'Cindy','Wilks','cwilks@ausgrid.com.au',''),
 (43880,'Michael','Tyler','mick.tyler@ausgrid.com.au',''),
 (44300,'Sue','Chapman','schapman@ausgrid.com.au',''),
 (44804,'Guy','Munro','gmunro@ausgrid.com.au',''),
 (45151,'Greg','Jamieson','gjamieson@ausgrid.com.au',''),
 (45164,'Peter','Mateer','pmateer@ausgrid.com.au',''),
 (45358,'Col','Pike','col.pike@ausgrid.com.au',''),
 (45545,'Trevor','Upton','tupton@ausgrid.com.au',''),
 (45580,'Anthony','Randle','arandle@ausgrid.com.au',''),
 (45907,'Michael','Judge','mjudge@ausgrid.com.au',''),
 (45931,'Colin','Chapman','cchapman@ausgrid.com.au',''),
 (46123,'Peter','White','peter_white@ausgrid.com.au',''),
 (46229,'Aaron','Mahony','amahony@ausgrid.com.au',''),
 (46351,'Kane','Kennett','kkennett@ausgrid.com.au',''),
 (46524,'Joanne','Lewis','jlewis@ausgrid.com.au',''),
 (47070,'Kristan','Keir','kkeir@ausgrid.com.au',''),
 (47187,'Field','Moe','fmoe@ausgrid.com.au',''),
 (47311,'Stephen','Burns','sburns@ausgrid.com.au',''),
 (47571,'Jeff','Corcoran','jcorcoran@ausgrid.com.au',''),
 (47573,'David','Hedger','dhedger@ausgrid.com.au',''),
 (48253,'Colin','Curry','ccurry@ausgrid.com.au',''),
 (49448,'Adrian','Hussey','ahussey@ausgrid.com.au',''),
 (49953,'Aaron John','Russell','ajrussell@ausgrid.com.au',''),
 (54170,'Terry','Harris','tharris@ausgrid.com.au','');




