DROP TABLE IF EXISTS `tblCounty`;
CREATE TABLE `tblCounty` (
  `fldCountyID` int(10) unsigned NOT NULL auto_increment,
  `fldCountry` varchar(100) NOT NULL default '0',
  `fldCounty` varchar(100) NOT NULL default '',
  `fldDateAdded` int(10) NOT NULL default '0',
  `fldDateModified` int(10) NOT NULL default '0',
  PRIMARY KEY  (`fldCountyID`)
) TYPE=MyISAM;


INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (1, 'England', 'Bedfordshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (2, 'England', 'Buckinghamshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (3, 'England', 'Cambridgeshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (4, 'England', 'Cheshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (5, 'England', 'Cornwall and Isles of Scilly', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (6, 'England', 'Cumbria', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (7, 'England', 'Derbyshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (8, 'England', 'Devon', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (9, 'England', 'Dorset', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (10, 'England', 'Durham', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (11, 'England', 'East Sussex', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (12, 'England', 'Essex', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (13, 'England', 'Gloucestershire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (14, 'England', 'Greater London', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (15, 'England', 'Greater Manchester', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (16, 'England', 'Hampshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (17, 'England', 'Hertfordshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (18, 'England', 'Kent', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (19, 'England', 'Lancashire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (20, 'England', 'Leicestershire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (21, 'England', 'Lincolnshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (22, 'England', 'Merseyside', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (23, 'England', 'Norfolk', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (24, 'England', 'North Yorkshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (25, 'England', 'Northamptonshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (26, 'England', 'Northumberland', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (27, 'England', 'Nottinghamshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (28, 'England', 'Oxfordshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (29, 'England', 'Shropshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (30, 'England', 'Somerset', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (31, 'England', 'South Yorkshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (32, 'England', 'Staffordshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (33, 'England', 'Suffolk', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (34, 'England', 'Surrey', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (35, 'England', 'Tyne and Wear', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (36, 'England', 'Warwickshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (37, 'England', 'West Midlands', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (38, 'England', 'West Sussex', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (39, 'England', 'West Yorkshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (40, 'England', 'Wiltshire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (41, 'England', 'Worcestershire', 1180355704, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (42, 'Wales', 'Flintshire', 1180355750, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (43, 'Wales', 'Glamorgan', 1180355750, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (44, 'Wales', 'Merionethshire', 1180355750, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (45, 'Wales', 'Monmouthshire', 1180355750, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (46, 'Wales', 'Montgomeryshire', 1180355750, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (47, 'Wales', 'Pembrokeshire', 1180355750, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (48, 'Wales', 'Radnorshire', 1180355750, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (49, 'Wales', 'Anglesey', 1180355750, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (50, 'Wales', 'Breconshire', 1180355750, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (51, 'Wales', 'Caernarvonshire', 1180355750, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (52, 'Wales', 'Cardiganshire', 1180355750, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (53, 'Wales', 'Carmarthenshire', 1180355750, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (54, 'Wales', 'Denbighshire', 1180355750, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (55, 'Scotland', 'Kirkcudbrightshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (56, 'Scotland', 'Lanarkshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (57, 'Scotland', 'Midlothian', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (58, 'Scotland', 'Moray', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (59, 'Scotland', 'Nairnshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (60, 'Scotland', 'Orkney', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (61, 'Scotland', 'Peebleshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (62, 'Scotland', 'Perthshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (63, 'Scotland', 'Renfrewshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (64, 'Scotland', 'Ross & Cromarty', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (65, 'Scotland', 'Roxburghshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (66, 'Scotland', 'Selkirkshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (67, 'Scotland', 'Shetland', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (68, 'Scotland', 'Stirlingshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (69, 'Scotland', 'Sutherland', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (70, 'Scotland', 'West Lothian', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (71, 'Scotland', 'Wigtownshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (72, 'Scotland', 'Aberdeenshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (73, 'Scotland', 'Angus', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (74, 'Scotland', 'Argyll', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (75, 'Scotland', 'Ayrshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (76, 'Scotland', 'Banffshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (77, 'Scotland', 'Berwickshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (78, 'Scotland', 'Bute', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (79, 'Scotland', 'Caithness', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (80, 'Scotland', 'Clackmannanshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (81, 'Scotland', 'Dumfriesshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (82, 'Scotland', 'Dumbartonshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (83, 'Scotland', 'East Lothian', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (84, 'Scotland', 'Fife', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (85, 'Scotland', 'Inverness', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (86, 'Scotland', 'Kincardineshire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (87, 'Scotland', 'Kinross-shire', 1180355805, 0);
INSERT INTO `tblCounty` (`fldCountyID`, `fldCountry`, `fldCounty`, `fldDateAdded`, `fldDateModified`) VALUES (88, 'England', 'London', 1180355934, 0);