/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.15-MariaDB, for Linux (x86_64)
--
-- Host: 127.0.0.1    Database: ordermarket
-- ------------------------------------------------------
-- Server version	11.8.8-MariaDB-ubu2404

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `counties`
--

DROP TABLE IF EXISTS `counties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `counties` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `region_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `latitude` decimal(10,7) DEFAULT NULL,
  `longitude` decimal(10,7) DEFAULT NULL,
  `eastings` int(11) DEFAULT NULL,
  `northings` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `counties_slug_unique` (`slug`),
  KEY `counties_region_id_foreign` (`region_id`),
  CONSTRAINT `counties_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `counties`
--

LOCK TABLES `counties` WRITE;
/*!40000 ALTER TABLE `counties` DISABLE KEYS */;
INSERT INTO `counties` VALUES
(1,1,'Cornwall','cornwall',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(2,1,'Devon','devon',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(3,1,'Dorset','dorset',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(4,1,'Gloucestershire','gloucestershire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(5,1,'Somerset','somerset',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(6,1,'Bristol','bristol',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(7,1,'Wiltshire','wiltshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(8,2,'Berkshire','berkshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(9,2,'Buckinghamshire','buckinghamshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(10,2,'West Sussex','west-sussex',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(11,2,'Hampshire','hampshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(12,2,'Kent','kent',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(13,2,'London','london',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(14,2,'Oxfordshire','oxfordshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(15,2,'Surrey','surrey',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(16,2,'East Sussex','east-sussex',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(17,2,'Isle of Wight','isle-of-wight',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(18,3,'Bedfordshire','bedfordshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(19,3,'Cambridgeshire','cambridgeshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(20,3,'Essex','essex',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(21,3,'Hertfordshire','hertfordshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(22,3,'Norfolk','norfolk',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(23,3,'Suffolk','suffolk',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(24,4,'Herefordshire','herefordshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(25,4,'Shropshire','shropshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(26,4,'Staffordshire','staffordshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(27,4,'Warwickshire','warwickshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(28,4,'West Midlands','west-midlands',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(29,4,'Worcestershire','worcestershire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(30,5,'Derbyshire','derbyshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(31,5,'Leicestershire','leicestershire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(32,5,'Lincolnshire','lincolnshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(33,5,'Northamptonshire','northamptonshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(34,5,'Nottinghamshire','nottinghamshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(35,5,'Rutland','rutland',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(36,6,'West Yorkshire','west-yorkshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(37,6,'North Yorkshire','north-yorkshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(38,6,'East Riding of Yorkshire','east-riding-of-yorkshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(39,6,'South Yorkshire','south-yorkshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(40,7,'Cheshire','cheshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(41,7,'Lancashire','lancashire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(42,7,'Manchester','manchester',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(43,7,'Merseyside','merseyside',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(44,7,'Isle of Man','isle-of-man',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(45,7,'Cumbria','cumbria',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(46,7,'Tyne and Wear','tyne-and-wear',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(47,8,'Durham','durham',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(48,8,'Northumberland','northumberland',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(49,9,'Wrexham','wrexham',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(50,9,'Cardiganshire','cardiganshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(51,9,'Carmarthenshire','carmarthenshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(52,9,'Denbighshire','denbighshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(53,9,'Flintshire','flintshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(54,9,'Glamorgan','glamorgan',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(55,9,'Monmouthshire','monmouthshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(56,9,'Pembrokeshire','pembrokeshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(57,9,'Newport','newport',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(58,9,'Anglesey','anglesey',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(59,9,'Neath Port Talbot','neath-port-talbot',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(60,9,'Caerphilly','caerphilly',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(61,9,'Swansea','swansea',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(62,9,'Powys','powys',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(63,9,'Gwynedd','gwynedd',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(64,9,'Merthyr Tydfil','merthyr-tydfil',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(65,9,'Conwy','conwy',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(66,9,'Cardiff','cardiff',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(67,9,'Blaenau Gwent','blaenau-gwent',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(68,9,'Torfaen','torfaen',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(69,9,'Rhondda Cynon Taff','rhondda-cynon-taff',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(70,10,'Ayrshire','ayrshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(71,10,'Dumfries and Galloway','dumfries-and-galloway',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(72,10,'East Lothian','east-lothian',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(73,10,'Lanarkshire','lanarkshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(74,10,'Midlothian','midlothian',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(75,10,'Renfrewshire','renfrewshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(76,10,'West Lothian','west-lothian',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(77,10,'Scottish Borders','scottish-borders',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(78,10,'Edinburgh','edinburgh',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(79,10,'Glasgow','glasgow',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(80,11,'Angus','angus',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(81,11,'Argyll and Bute','argyll-and-bute',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(82,11,'Clackmannanshire','clackmannanshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(83,11,'Dunbartonshire','dunbartonshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(84,11,'Fife','fife',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(85,11,'Perth and Kinross','perth-and-kinross',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(86,11,'Stirlingshire','stirlingshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(87,11,'Dundee','dundee',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(88,12,'Aberdeenshire','aberdeenshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(89,12,'Nairnshire','nairnshire',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(90,12,'Orkney','orkney',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(91,12,'Shetland Isles','shetland-isles',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(92,12,'Highland','highland',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(93,12,'Western Isles','western-isles',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(94,12,'Moray','moray',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(95,13,'County Antrim','county-antrim',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(96,13,'County Armagh','county-armagh',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(97,13,'County Down','county-down',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(98,13,'County Fermanagh','county-fermanagh',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(99,13,'County Londonderry','county-londonderry',0.0000000,0.0000000,NULL,NULL,NULL,NULL),
(100,13,'County Tyrone','county-tyrone',0.0000000,0.0000000,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `counties` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-07-26 12:12:06