laravel-cache-distance_matrix:f2713c03ab4ea7b0cd022d0e2e6365d3	a:1:{i:0;a:2:{s:11:"distance_km";d:324.927;s:16:"duration_minutes";d:206.15;}}	1774408321
laravel-cache-zone_lookup:10:51.40632:-0.67533	[encoded data, 4936 characters]	1774408930
laravel-cache-distance_matrix:a76e468aeb1ea36be9bd1cf13f1e9e21	a:1:{i:0;a:2:{s:11:"distance_km";d:26.561;s:16:"duration_minutes";d:33.68333333333333;}}	1774408941
laravel-cache-zone_lookup:cache_version	i:11;	2089682625
laravel-cache-zone_lookup:11:51.40632:-0.67533	TzoxNToiQXBwXE1vZGVsc1xab25lIjozNDp7czoxMzoiACoAY29ubmVjdGlvbiI7czo1OiJwZ3NxbCI7czo4OiIAKgB0YWJsZSI7czo1OiJ6b25lcyI7czoxMzoiACoAcHJpbWFyeUtleSI7czoyOiJpZCI7czoxMDoiACoAa2V5VHlwZSI7czozOiJpbnQiO3M6MTI6ImluY3JlbWVudGluZyI7YjoxO3M6NzoiACoAd2l0aCI7YTowOnt9czoxMjoiACoAd2l0aENvdW50IjthOjA6e31zOjE5OiJwcmV2ZW50c0xhenlMb2FkaW5nIjtiOjA7czoxMDoiACoAcGVyUGFnZSI7aToxNTtzOjY6ImV4aXN0cyI7YjoxO3M6MTg6Indhc1JlY2VudGx5Q3JlYXRlZCI7YjowO3M6Mjg6IgAqAGVzY2FwZVdoZW5DYXN0aW5nVG9TdHJpbmciO2I6MDtzOjEzOiIAKgBhdHRyaWJ1dGVzIjthOjExOntzOjI6ImlkIjtpOjU7czo0OiJuYW1lIjtzOjU6IkFzY290IjtzOjQ6ImNvZGUiO3M6NToiYXNjb3QiO3M6NjoiYWN0aXZlIjtiOjE7czoxMDoiY3JlYXRlZF9hdCI7czoxOToiMjAyNi0wMy0yNCAwMzoyMzo0NSI7czoxMDoidXBkYXRlZF9hdCI7czoxOToiMjAyNi0wMy0yNCAwMzoyMzo0NSI7czo4OiJnZW9tZXRyeSI7czoyMzg6InsidHlwZSI6IlBvbHlnb24iLCJjb29yZGluYXRlcyI6W1tbLTAuNzAzNzE5MjMyMTU5Mzk5LDUxLjQyNDc0OTAyNDgwMTUxNF0sWy0wLjY1ODU4MzI5MDc0MzcxOTYsNTEuNDM0MDYwMzg3NDY0MTFdLFstMC42MTc5NDA1Nzc1MjA4OTQ3LDUxLjM4OTQxMjgwNzAzNjYxNF0sWy0wLjY4NTA0MzgyMTIyMjUyMTgsNTEuMzc0ODQyMDU3NTM2MTU2XSxbLTAuNzAzNzE5MjMyMTU5Mzk5LDUxLjQyNDc0OTAyNDgwMTUxNF1dXX0iO3M6NDoidHlwZSI7czo4OiJzdWJ1cmJhbiI7czoxMDoicGlja3VwX2ZlZSI7czo0OiIwLjAwIjtzOjExOiJkcm9wb2ZmX2ZlZSI7czo0OiIwLjAwIjtzOjk6InN1cmNoYXJnZSI7czo0OiIwLjAwIjt9czoxMToiACoAb3JpZ2luYWwiO2E6MTE6e3M6MjoiaWQiO2k6NTtzOjQ6Im5hbWUiO3M6NToiQXNjb3QiO3M6NDoiY29kZSI7czo1OiJhc2NvdCI7czo2OiJhY3RpdmUiO2I6MTtzOjEwOiJjcmVhdGVkX2F0IjtzOjE5OiIyMDI2LTAzLTI0IDAzOjIzOjQ1IjtzOjEwOiJ1cGRhdGVkX2F0IjtzOjE5OiIyMDI2LTAzLTI0IDAzOjIzOjQ1IjtzOjg6Imdlb21ldHJ5IjtzOjIzODoieyJ0eXBlIjoiUG9seWdvbiIsImNvb3JkaW5hdGVzIjpbW1stMC43MDM3MTkyMzIxNTkzOTksNTEuNDI0NzQ5MDI0ODAxNTE0XSxbLTAuNjU4NTgzMjkwNzQzNzE5Niw1MS40MzQwNjAzODc0NjQxMV0sWy0wLjYxNzk0MDU3NzUyMDg5NDcsNTEuMzg5NDEyODA3MDM2NjE0XSxbLTAuNjg1MDQzODIxMjIyNTIxOCw1MS4zNzQ4NDIwNTc1MzYxNTZdLFstMC43MDM3MTkyMzIxNTkzOTksNTEuNDI0NzQ5MDI0ODAxNTE0XV1dfSI7czo0OiJ0eXBlIjtzOjg6InN1YnVyYmFuIjtzOjEwOiJwaWNrdXBfZmVlIjtzOjQ6IjAuMDAiO3M6MTE6ImRyb3BvZmZfZmVlIjtzOjQ6IjAuMDAiO3M6OToic3VyY2hhcmdlIjtzOjQ6IjAuMDAiO31zOjEwOiIAKgBjaGFuZ2VzIjthOjA6e31zOjExOiIAKgBwcmV2aW91cyI7YTowOnt9czo4OiIAKgBjYXN0cyI7YTo1OntzOjg6Imdlb21ldHJ5IjtzOjIxOiJBcHBcQ2FzdHNcUG9seWdvbkNhc3QiO3M6NjoiYWN0aXZlIjtzOjc6ImJvb2xlYW4iO3M6MTA6InBpY2t1cF9mZWUiO3M6OToiZGVjaW1hbDoyIjtzOjExOiJkcm9wb2ZmX2ZlZSI7czo5OiJkZWNpbWFsOjIiO3M6OToic3VyY2hhcmdlIjtzOjk6ImRlY2ltYWw6MiI7fXM6MTc6IgAqAGNsYXNzQ2FzdENhY2hlIjthOjA6e31zOjIxOiIAKgBhdHRyaWJ1dGVDYXN0Q2FjaGUiO2E6MDp7fXM6MTM6IgAqAGRhdGVGb3JtYXQiO047czoxMDoiACoAYXBwZW5kcyI7YTowOnt9czoxOToiACoAZGlzcGF0Y2hlc0V2ZW50cyI7YTowOnt9czoxNDoiACoAb2JzZXJ2YWJsZXMiO2E6MDp7fXM6MTI6IgAqAHJlbGF0aW9ucyI7YTowOnt9czoxMDoiACoAdG91Y2hlcyI7YTowOnt9czoyNzoiACoAcmVsYXRpb25BdXRvbG9hZENhbGxiYWNrIjtOO3M6MjY6IgAqAHJlbGF0aW9uQXV0b2xvYWRDb250ZXh0IjtOO3M6MTA6InRpbWVzdGFtcHMiO2I6MTtzOjEzOiJ1c2VzVW5pcXVlSWRzIjtiOjA7czo5OiIAKgBoaWRkZW4iO2E6MDp7fXM6MTA6IgAqAHZpc2libGUiO2E6MDp7fXM6MTE6IgAqAGZpbGxhYmxlIjthOjg6e2k6MDtzOjQ6Im5hbWUiO2k6MTtzOjQ6ImNvZGUiO2k6MjtzOjQ6InR5cGUiO2k6MztzOjg6Imdlb21ldHJ5IjtpOjQ7czo2OiJhY3RpdmUiO2k6NTtzOjEwOiJwaWNrdXBfZmVlIjtpOjY7czoxMToiZHJvcG9mZl9mZWUiO2k6NztzOjk6InN1cmNoYXJnZSI7fXM6MTA6IgAqAGd1YXJkZWQiO2E6MTp7aTowO3M6MToiKiI7fXM6MTI6IgAqAGF1ZGl0YWJsZSI7YTo3OntpOjA7czo0OiJuYW1lIjtpOjE7czo0OiJjb2RlIjtpOjI7czo0OiJ0eXBlIjtpOjM7czo2OiJhY3RpdmUiO2k6NDtzOjEwOiJwaWNrdXBfZmVlIjtpOjU7czoxMToiZHJvcG9mZl9mZWUiO2k6NjtzOjk6InN1cmNoYXJnZSI7fX0=	1774409086
laravel-cache-zone_lookup:11:51.4713:-0.48776	[encoded data, 4788 characters]	1774409092
laravel-cache-distance_matrix:2700f4415a1671183afe2adfc369ec2b	a:1:{i:0;a:2:{s:11:"distance_km";d:18.731;s:16:"duration_minutes";d:26.25;}}	1774409098
laravel-cache-zone_lookup:11:51.41217:-0.67948	TzoxNToiQXBwXE1vZGVsc1xab25lIjozNDp7czoxMzoiACoAY29ubmVjdGlvbiI7czo1OiJwZ3NxbCI7czo4OiIAKgB0YWJsZSI7czo1OiJ6b25lcyI7czoxMzoiACoAcHJpbWFyeUtleSI7czoyOiJpZCI7czoxMDoiACoAa2V5VHlwZSI7czozOiJpbnQiO3M6MTI6ImluY3JlbWVudGluZyI7YjoxO3M6NzoiACoAd2l0aCI7YTowOnt9czoxMjoiACoAd2l0aENvdW50IjthOjA6e31zOjE5OiJwcmV2ZW50c0xhenlMb2FkaW5nIjtiOjA7czoxMDoiACoAcGVyUGFnZSI7aToxNTtzOjY6ImV4aXN0cyI7YjoxO3M6MTg6Indhc1JlY2VudGx5Q3JlYXRlZCI7YjowO3M6Mjg6IgAqAGVzY2FwZVdoZW5DYXN0aW5nVG9TdHJpbmciO2I6MDtzOjEzOiIAKgBhdHRyaWJ1dGVzIjthOjExOntzOjI6ImlkIjtpOjU7czo0OiJuYW1lIjtzOjU6IkFzY290IjtzOjQ6ImNvZGUiO3M6NToiYXNjb3QiO3M6NjoiYWN0aXZlIjtiOjE7czoxMDoiY3JlYXRlZF9hdCI7czoxOToiMjAyNi0wMy0yNCAwMzoyMzo0NSI7czoxMDoidXBkYXRlZF9hdCI7czoxOToiMjAyNi0wMy0yNCAwMzoyMzo0NSI7czo4OiJnZW9tZXRyeSI7czoyMzg6InsidHlwZSI6IlBvbHlnb24iLCJjb29yZGluYXRlcyI6W1tbLTAuNzAzNzE5MjMyMTU5Mzk5LDUxLjQyNDc0OTAyNDgwMTUxNF0sWy0wLjY1ODU4MzI5MDc0MzcxOTYsNTEuNDM0MDYwMzg3NDY0MTFdLFstMC42MTc5NDA1Nzc1MjA4OTQ3LDUxLjM4OTQxMjgwNzAzNjYxNF0sWy0wLjY4NTA0MzgyMTIyMjUyMTgsNTEuMzc0ODQyMDU3NTM2MTU2XSxbLTAuNzAzNzE5MjMyMTU5Mzk5LDUxLjQyNDc0OTAyNDgwMTUxNF1dXX0iO3M6NDoidHlwZSI7czo4OiJzdWJ1cmJhbiI7czoxMDoicGlja3VwX2ZlZSI7czo0OiIwLjAwIjtzOjExOiJkcm9wb2ZmX2ZlZSI7czo0OiIwLjAwIjtzOjk6InN1cmNoYXJnZSI7czo0OiIwLjAwIjt9czoxMToiACoAb3JpZ2luYWwiO2E6MTE6e3M6MjoiaWQiO2k6NTtzOjQ6Im5hbWUiO3M6NToiQXNjb3QiO3M6NDoiY29kZSI7czo1OiJhc2NvdCI7czo2OiJhY3RpdmUiO2I6MTtzOjEwOiJjcmVhdGVkX2F0IjtzOjE5OiIyMDI2LTAzLTI0IDAzOjIzOjQ1IjtzOjEwOiJ1cGRhdGVkX2F0IjtzOjE5OiIyMDI2LTAzLTI0IDAzOjIzOjQ1IjtzOjg6Imdlb21ldHJ5IjtzOjIzODoieyJ0eXBlIjoiUG9seWdvbiIsImNvb3JkaW5hdGVzIjpbW1stMC43MDM3MTkyMzIxNTkzOTksNTEuNDI0NzQ5MDI0ODAxNTE0XSxbLTAuNjU4NTgzMjkwNzQzNzE5Niw1MS40MzQwNjAzODc0NjQxMV0sWy0wLjYxNzk0MDU3NzUyMDg5NDcsNTEuMzg5NDEyODA3MDM2NjE0XSxbLTAuNjg1MDQzODIxMjIyNTIxOCw1MS4zNzQ4NDIwNTc1MzYxNTZdLFstMC43MDM3MTkyMzIxNTkzOTksNTEuNDI0NzQ5MDI0ODAxNTE0XV1dfSI7czo0OiJ0eXBlIjtzOjg6InN1YnVyYmFuIjtzOjEwOiJwaWNrdXBfZmVlIjtzOjQ6IjAuMDAiO3M6MTE6ImRyb3BvZmZfZmVlIjtzOjQ6IjAuMDAiO3M6OToic3VyY2hhcmdlIjtzOjQ6IjAuMDAiO31zOjEwOiIAKgBjaGFuZ2VzIjthOjA6e31zOjExOiIAKgBwcmV2aW91cyI7YTowOnt9czo4OiIAKgBjYXN0cyI7YTo1OntzOjg6Imdlb21ldHJ5IjtzOjIxOiJBcHBcQ2FzdHNcUG9seWdvbkNhc3QiO3M6NjoiYWN0aXZlIjtzOjc6ImJvb2xlYW4iO3M6MTA6InBpY2t1cF9mZWUiO3M6OToiZGVjaW1hbDoyIjtzOjExOiJkcm9wb2ZmX2ZlZSI7czo5OiJkZWNpbWFsOjIiO3M6OToic3VyY2hhcmdlIjtzOjk6ImRlY2ltYWw6MiI7fXM6MTc6IgAqAGNsYXNzQ2FzdENhY2hlIjthOjA6e31zOjIxOiIAKgBhdHRyaWJ1dGVDYXN0Q2FjaGUiO2E6MDp7fXM6MTM6IgAqAGRhdGVGb3JtYXQiO047czoxMDoiACoAYXBwZW5kcyI7YTowOnt9czoxOToiACoAZGlzcGF0Y2hlc0V2ZW50cyI7YTowOnt9czoxNDoiACoAb2JzZXJ2YWJsZXMiO2E6MDp7fXM6MTI6IgAqAHJlbGF0aW9ucyI7YTowOnt9czoxMDoiACoAdG91Y2hlcyI7YTowOnt9czoyNzoiACoAcmVsYXRpb25BdXRvbG9hZENhbGxiYWNrIjtOO3M6MjY6IgAqAHJlbGF0aW9uQXV0b2xvYWRDb250ZXh0IjtOO3M6MTA6InRpbWVzdGFtcHMiO2I6MTtzOjEzOiJ1c2VzVW5pcXVlSWRzIjtiOjA7czo5OiIAKgBoaWRkZW4iO2E6MDp7fXM6MTA6IgAqAHZpc2libGUiO2E6MDp7fXM6MTE6IgAqAGZpbGxhYmxlIjthOjg6e2k6MDtzOjQ6Im5hbWUiO2k6MTtzOjQ6ImNvZGUiO2k6MjtzOjQ6InR5cGUiO2k6MztzOjg6Imdlb21ldHJ5IjtpOjQ7czo2OiJhY3RpdmUiO2k6NTtzOjEwOiJwaWNrdXBfZmVlIjtpOjY7czoxMToiZHJvcG9mZl9mZWUiO2k6NztzOjk6InN1cmNoYXJnZSI7fXM6MTA6IgAqAGd1YXJkZWQiO2E6MTp7aTowO3M6MToiKiI7fXM6MTI6IgAqAGF1ZGl0YWJsZSI7YTo3OntpOjA7czo0OiJuYW1lIjtpOjE7czo0OiJjb2RlIjtpOjI7czo0OiJ0eXBlIjtpOjM7czo2OiJhY3RpdmUiO2k6NDtzOjEwOiJwaWNrdXBfZmVlIjtpOjU7czoxMToiZHJvcG9mZl9mZWUiO2k6NjtzOjk6InN1cmNoYXJnZSI7fX0=	1774409126
laravel-cache-distance_matrix:03db04a9b90061a28cb4a3f426414494	a:1:{i:0;a:2:{s:11:"distance_km";d:26.022;s:16:"duration_minutes";d:31.283333333333335;}}	1774409136
laravel-cache-zone_lookup:11:51.87867:-0.42003	[encoded data, 4892 characters]	1774450381
laravel-cache-distance_matrix:1d70bb1afe8ebbedd0b97d1962da3a37	a:1:{i:0;a:2:{s:11:"distance_km";d:57.115;s:16:"duration_minutes";d:44.68333333333333;}}	1774450385
laravel-cache-distance_matrix:2ecb903d1dc86e86ce99146fd1a6455c	a:2:{i:0;a:2:{s:11:"distance_km";d:18.488;s:16:"duration_minutes";d:18.05;}i:1;a:2:{s:11:"distance_km";d:39.865;s:16:"duration_minutes";d:54.7;}}	1774450639
laravel-cache-distance_matrix:0464f3e675ee590db68b11313832ed10	a:1:{i:0;a:2:{s:11:"distance_km";d:14.081;s:16:"duration_minutes";d:23.45;}}	1774492082
laravel-cache-zone_lookup:11:53.79444:-1.54758	[encoded data, 4892 characters]	1774492104
laravel-cache-distance_matrix:daae86226c437cca3cc8b73205f51625	a:1:{i:0;a:2:{s:11:"distance_km";d:315.843;s:16:"duration_minutes";d:201.98333333333332;}}	1774492108
laravel-cache-distance_matrix:5343267ad5e58eb9df49330b2a52778e	a:1:{i:0;a:2:{s:11:"distance_km";d:27.577;s:16:"duration_minutes";d:48.766666666666666;}}	1774492132
laravel-cache-zone_lookup:11:51.37695:-0.09569	[encoded data, 4892 characters]	1774492148
laravel-cache-distance_matrix:54f4086661be0848b6d5f1d79085bb12	a:1:{i:0;a:2:{s:11:"distance_km";d:66.419;s:16:"duration_minutes";d:64.01666666666667;}}	1774492151
laravel-cache-distance_matrix:038a6dfcbf9c1d1e692358b7526d0db5	a:1:{i:0;a:2:{s:11:"distance_km";d:14.9;s:16:"duration_minutes";d:22.7;}}	1774494375
laravel-cache-zone_lookup:11:51.57481:-0.09213	[encoded data, 4892 characters]	1774494577
laravel-cache-zone_lookup:11:51.48223:-0.63474	[encoded data, 4936 characters]	1774494584
laravel-cache-zone_lookup:11:51.51057:-0.59037	[encoded data, 4936 characters]	1774494594
laravel-cache-distance_matrix:1a1a3f9a365ed6228ecb8a4763d84e7e	a:2:{i:0;a:2:{s:11:"distance_km";d:2.678;s:16:"duration_minutes";d:7.5;}i:1;a:2:{s:11:"distance_km";d:6.104;s:16:"duration_minutes";d:12.833333333333334;}}	1774494597
laravel-cache-distance_matrix:3821d4bb5f47c61f2592cf854a0c82b5	a:3:{i:0;a:2:{s:11:"distance_km";d:2.678;s:16:"duration_minutes";d:7.5;}i:1;a:2:{s:11:"distance_km";d:6.104;s:16:"duration_minutes";d:12.833333333333334;}i:2;a:2:{s:11:"distance_km";d:13.214;s:16:"duration_minutes";d:22.6;}}	1774494680
laravel-cache-geocode:61e9c06ea9a85a5088a499df6458d276	N;	1774496292
laravel-cache-zone_lookup:11:51.46799:-0.45505	[encoded data, 4788 characters]	1774497057
laravel-cache-zone_lookup:11:51.05977:-1.31014	[encoded data, 4892 characters]	1774497064
laravel-cache-distance_matrix:e53e406013f5421b9c0062026e89d073	a:1:{i:0;a:2:{s:11:"distance_km";d:84.894;s:16:"duration_minutes";d:62.71666666666667;}}	1774497065
laravel-cache-distance_matrix:b17f96157810971fda44152a111ed232	a:1:{i:0;a:2:{s:11:"distance_km";d:15.997;s:16:"duration_minutes";d:22.883333333333333;}}	1774498204
laravel-cache-zone_lookup:11:51.47118:-0.48866	[encoded data, 4788 characters]	1774563065
laravel-cache-zone_lookup:11:51.47342:-0.49168	[encoded data, 4788 characters]	1774563076
laravel-cache-zone_lookup:11:51.48389:-0.6044	[encoded data, 4936 characters]	1774563085
laravel-cache-distance_matrix:1a597c0e56759fe32bc37f27c31c5ea8	a:1:{i:0;a:2:{s:11:"distance_km";d:12.904;s:16:"duration_minutes";d:17.333333333333332;}}	1774563087
laravel-cache-zone_lookup:11:51.50743:-0.12718	[encoded data, 4164 characters]	1774563149
laravel-cache-distance_matrix:1a6cdb59704e1f413b3c942f45f5318c	a:2:{i:0;a:2:{s:11:"distance_km";d:31.692;s:16:"duration_minutes";d:48.93333333333333;}i:1;a:2:{s:11:"distance_km";d:36.435;s:16:"duration_minutes";d:54.68333333333333;}}	1774563151
laravel-cache-zone_lookup:11:51.47944:-0.46383	[encoded data, 4788 characters]	1774563381
laravel-cache-geocode:f1290186a5d0b1ceab27f4e77c0c5d68	N;	1774563390
laravel-cache-distance_matrix:be5a550a6ef274a86b183545e8e6b532	a:2:{i:0;a:2:{s:11:"distance_km";d:27.553;s:16:"duration_minutes";d:47.46666666666667;}i:1;a:2:{s:11:"distance_km";d:36.435;s:16:"duration_minutes";d:54.68333333333333;}}	1774563394
laravel-cache-distance_matrix:6fbf28a2b00f16c149c9d0384ef987da	a:1:{i:0;a:2:{s:11:"distance_km";d:14.782;s:16:"duration_minutes";d:19.316666666666666;}}	1774566696
laravel-cache-system_settings	a:4:{s:16:"measurement_unit";s:5:"miles";s:15:"currency_symbol";s:2:"£";s:13:"currency_code";s:3:"GBP";s:15:"default_zone_id";i:1;}	1774490464
laravel-cache-distance_matrix:0d62eccda2cb5792e50ac9062947d348	a:1:{i:0;a:2:{s:11:"distance_km";d:30.529;s:16:"duration_minutes";d:54.63333333333333;}}	1774573350
laravel-cache-zone_lookup:11:51.4622:-0.47523	[encoded data, 4788 characters]	1774573397
laravel-cache-distance_matrix:32a9bc5e82d115833814f819589111cc	a:1:{i:0;a:2:{s:11:"distance_km";d:33.277;s:16:"duration_minutes";d:50.233333333333334;}}	1774573408
laravel-cache-distance_matrix:01074d808561d5ab443a1eb94d807cb0	a:1:{i:0;a:2:{s:11:"distance_km";d:21.249;s:16:"duration_minutes";d:22.483333333333334;}}	1774573927
laravel-cache-zone_lookup:11:51.48034:-0.61571	[encoded data, 4936 characters]	1774573927
\.


--
-- TOC entry 6224 (class 0 OID 16446)
-- Dependencies: 227
-- Data for Name: cache_locks; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.cache_locks (key, owner, expiration) FROM stdin;
\.


--
-- TOC entry 6248 (class 0 OID 16700)
-- Dependencies: 251
-- Data for Name: distance_rules; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.distance_rules (id, zone_id, breakpoint_set_id, base_price, currency, active, created_at, updated_at, destination_zone_id, minimum_fare, name, description) FROM stdin;
7	3	1	5.00	USD	t	2026-03-21 01:29:15	2026-03-21 01:29:15	3	7.00	\N	\N
9	1	4	20.00	USD	t	2026-03-24 02:02:03	2026-03-24 02:45:16	1	100.00	Default Zone (intra-zone)	Applies only when both pickup and drop-off are in "Default Zone". Base fare 20.00 USD. Minimum fare 100.00 USD. Per-kilometre pricing uses the breakpoint set "Out of area to Out of area". Time-of-day rates, if configured for this origin zone, apply to waiting time. This rule is active.
8	1	10	10.00	USD	t	2026-03-24 01:48:36	2026-03-24 02:46:14	4	20.00	Out of Area → Central London East	Applies to trips that start in "Default Zone" and end in "Central London East". Base fare 10.00 USD. Minimum fare 20.00 USD. Per-kilometre pricing uses the breakpoint set "Out of Area to London". Time-of-day rates, if configured for this origin zone, apply to waiting time. This rule is active.
10	1	5	20.00	USD	t	2026-03-24 02:49:37	2026-03-24 02:49:37	3	100.00	Out of Area to Local Area	Applies to trips that start in "Default Zone" and end in "Local Area". Base fare 20.00 USD. Minimum fare 100.00 USD. Per-kilometre pricing uses the breakpoint set "Out of Area to Local Area". Time-of-day rates, if configured for this origin zone, apply to waiting time. This rule is active.
\.


--
-- TOC entry 6229 (class 0 OID 16488)
-- Dependencies: 232
-- Data for Name: failed_jobs; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.failed_jobs (id, uuid, connection, queue, payload, exception, failed_at) FROM stdin;
\.


--
-- TOC entry 6242 (class 0 OID 16630)
-- Dependencies: 245
-- Data for Name: fixed_prices; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.fixed_prices (id, zone_id, vehicle_type_id, amount, currency, active, created_at, updated_at, origin_zone_id, destination_zone_id, valid_from, valid_to) FROM stdin;
1	2	1	25.00	USD	t	2026-03-19 01:44:25	2026-03-19 01:44:25	2	3	2026-03-19 01:44:00	2026-03-31 01:44:00
2	3	1	25.00	USD	t	2026-03-19 01:44:53	2026-03-19 01:44:53	3	2	2026-03-19 01:44:00	2026-03-31 01:44:00
3	5	1	31.00	USD	t	2026-03-24 03:24:35	2026-03-24 03:25:17	5	2	2026-03-24 03:24:00	2029-10-24 03:24:00
\.


--
-- TOC entry 6227 (class 0 OID 16473)
-- Dependencies: 230
-- Data for Name: job_batches; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.job_batches (id, name, total_jobs, pending_jobs, failed_jobs, failed_job_ids, options, cancelled_at, created_at, finished_at) FROM stdin;
\.


--
-- TOC entry 6226 (class 0 OID 16458)
-- Dependencies: 229
-- Data for Name: jobs; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.jobs (id, queue, payload, attempts, reserved_at, available_at, created_at) FROM stdin;
1	fares	{"uuid":"6e13829f-bb90-412e-93b8-cbc6ba9b02b5","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:2;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773884665,"telescope_uuid":"a1557889-8656-4675-8ffc-bd70dc5c436f","delay":null}	0	\N	1773884665	1773884665
2	fares	{"uuid":"ff585cdf-0437-43ce-b617-518211aa7366","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:3;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773884665,"telescope_uuid":"a1557889-896c-40ab-8a5e-2ada32495fe2","delay":null}	0	\N	1773884665	1773884665
3	fares	{"uuid":"2a92f322-ee2e-48d0-85af-cb0b953facd3","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:3;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773884693,"telescope_uuid":"a15578b4-19bd-4486-8f1d-87a20fa1b314","delay":null}	0	\N	1773884693	1773884693
4	fares	{"uuid":"af4584c8-7cbf-4cbe-93a9-d279486f726c","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:2;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773884693,"telescope_uuid":"a15578b4-1bb3-4c14-b393-baec0db0c29c","delay":null}	0	\N	1773884693	1773884693
5	fares	{"uuid":"668e9c74-1ed3-417b-bec5-6945d7bfa50e","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:2;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773886103,"telescope_uuid":"a155811b-9ee4-4c43-8a80-b7409ae58406","delay":null}	0	\N	1773886103	1773886103
6	fares	{"uuid":"5a7a48f0-2a39-4ef6-916b-20422207e59c","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:3;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773887127,"telescope_uuid":"a1558735-e35a-4489-8f43-1794ecacbc9d","delay":null}	0	\N	1773887127	1773887127
7	dispatch	{"uuid":"d0395826-64b2-4c53-8786-db3f43fca230","displayName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","command":"O:33:\\"App\\\\Jobs\\\\ProcessDriverMatchingJob\\":2:{s:9:\\"bookingId\\";i:1;s:5:\\"queue\\";s:8:\\"dispatch\\";}","batchId":null},"createdAt":1773969107,"telescope_uuid":"a1576fda-6018-423e-865f-18c36219aec9","delay":null}	0	\N	1773969108	1773969108
8	fares	{"uuid":"e0c9cab7-bd43-4252-98eb-a153dff62f1b","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773969404,"telescope_uuid":"a157719e-5162-47da-9171-7c1946ccfde8","delay":null}	0	\N	1773969404	1773969404
9	fares	{"uuid":"b43786b1-c815-4c63-a16a-715f3a013fb2","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773969415,"telescope_uuid":"a15771af-1b35-4736-879d-3420e6222ef0","delay":null}	0	\N	1773969415	1773969415
10	fares	{"uuid":"8a90afb4-2717-4fd7-9d97-28a6d8f5b513","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773969434,"telescope_uuid":"a15771cc-e48b-4620-9070-f40d105cd0ef","delay":null}	0	\N	1773969434	1773969434
11	fares	{"uuid":"7ba54114-2599-4acc-a87c-b0caac22f01b","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773969455,"telescope_uuid":"a15771ec-592a-49c8-8c30-aa0e691047ac","delay":null}	0	\N	1773969455	1773969455
12	fares	{"uuid":"6e1036da-f2f2-47dd-b792-db5502fa8325","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773969477,"telescope_uuid":"a157720e-0e2b-42e6-b9a3-2afacf0e9a52","delay":null}	0	\N	1773969477	1773969477
13	fares	{"uuid":"b3482738-6e3e-471f-ba48-03eb08e0bb6c","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773969492,"telescope_uuid":"a1577224-c7a6-4633-84df-dc699f6ff5dc","delay":null}	0	\N	1773969492	1773969492
14	fares	{"uuid":"7350899d-acc4-4821-a2ab-d21fdeb38811","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773969505,"telescope_uuid":"a1577238-adde-44be-96e7-84463823b80c","delay":null}	0	\N	1773969505	1773969505
15	dispatch	{"uuid":"6c9d0409-0cd7-45be-98f2-6df4a12fe078","displayName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","command":"O:33:\\"App\\\\Jobs\\\\ProcessDriverMatchingJob\\":2:{s:9:\\"bookingId\\";i:2;s:5:\\"queue\\";s:8:\\"dispatch\\";}","batchId":null},"createdAt":1773970728,"telescope_uuid":"a1577983-1b90-42a8-b44e-089c56cda52f","delay":null}	0	\N	1773970728	1773970728
16	fares	{"uuid":"636d5dd6-316e-428e-844b-123191e166dc","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:2;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1773971039,"telescope_uuid":"a1577b5d-fb1f-4ca0-8935-e8aed54ee132","delay":null}	0	\N	1773971039	1773971039
17	fares	{"uuid":"68c0e814-2c09-4743-a6ac-21b38ce55f37","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774053437,"telescope_uuid":"a159667e-d75b-4734-b72b-5a66d8021736","delay":null}	0	\N	1774053437	1774053437
18	fares	{"uuid":"3f93eb91-e9b2-496e-8b6a-8086d922b951","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:3;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774056556,"telescope_uuid":"a1597916-1783-42e0-81e1-faed431f8a26","delay":null}	0	\N	1774056556	1774056556
19	fares	{"uuid":"617fdaa4-64dd-4c13-ab6a-88444d6dab16","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:3;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774057667,"telescope_uuid":"a1597fb4-9804-47e4-9868-e32ce7e2e3f8","delay":null}	0	\N	1774057667	1774057667
20	fares	{"uuid":"b46555f2-3de8-4d65-a098-fe1c9002081a","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:3;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774057974,"telescope_uuid":"a1598189-5919-409e-b6af-03ceac9137af","delay":null}	0	\N	1774057974	1774057974
21	fares	{"uuid":"67a41dac-a42e-475f-b54d-8528e946b55d","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:4;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774316916,"telescope_uuid":"a15f88f4-06f7-481d-ad20-3faaa9537d3b","delay":null}	0	\N	1774316916	1774316916
22	fares	{"uuid":"eca9bfe7-4ce9-418e-96d7-e2a7402a7368","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:4;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774316932,"telescope_uuid":"a15f890c-dd60-4ece-b5e6-20d99b4c0a50","delay":null}	0	\N	1774316932	1774316932
23	fares	{"uuid":"750a6e51-ee95-4db9-95b3-e238eb930d4f","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:3;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774317388,"telescope_uuid":"a15f8bc4-d049-447a-8160-01ffe3542c94","delay":null}	0	\N	1774317388	1774317388
24	fares	{"uuid":"e58a84e9-27c2-468f-9c81-5968534aae69","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:3;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774317412,"telescope_uuid":"a15f8be8-3a0a-4bc8-80db-bd2a6a81a392","delay":null}	0	\N	1774317412	1774317412
25	fares	{"uuid":"162d57c8-010b-4a69-b2e0-29135f0da203","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:3;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774317488,"telescope_uuid":"a15f8c5c-a2e2-4151-9936-f28cb1397d6a","delay":null}	0	\N	1774317488	1774317488
26	fares	{"uuid":"00550827-e604-4429-82f1-15dc7a1e444b","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:4;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774317610,"telescope_uuid":"a15f8d16-c2e8-45fb-9b61-46511e8d7770","delay":null}	0	\N	1774317610	1774317610
27	fares	{"uuid":"22830ac5-b9ec-4e9d-9e25-c8537db7a7bc","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774317723,"telescope_uuid":"a15f8dc3-7da8-40d6-b0da-bdff01e90f25","delay":null}	0	\N	1774317723	1774317723
28	fares	{"uuid":"4346b11a-a617-4ac2-86c0-a25d1169496f","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774318168,"telescope_uuid":"a15f9069-b679-4404-8dd9-bb129039a164","delay":null}	0	\N	1774318168	1774318168
29	fares	{"uuid":"8ed697cf-be6f-4420-b08d-e18d38e1b511","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:4;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774318436,"telescope_uuid":"a15f9203-96a5-4784-b197-87bec1d8fa1f","delay":null}	0	\N	1774318436	1774318436
30	fares	{"uuid":"5fbee646-2d5b-4203-8e68-20d7fde0e157","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774319864,"telescope_uuid":"a15f9a85-f8e7-492f-ab06-fa36353896d8","delay":null}	0	\N	1774319864	1774319864
31	fares	{"uuid":"e9a267cf-3c36-4769-8223-8e9de9d0847e","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:4;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774319864,"telescope_uuid":"a15f9a86-2671-4392-881e-9beff55fd218","delay":null}	0	\N	1774319864	1774319864
32	fares	{"uuid":"5f629baa-c971-45f2-8b80-e357adb88184","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774320316,"telescope_uuid":"a15f9d37-aa1a-4a6d-bd93-2ff7a8281ec2","delay":null}	0	\N	1774320316	1774320316
33	fares	{"uuid":"5dac8b02-f3b0-45be-a7d8-3885eb3f963f","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774320332,"telescope_uuid":"a15f9d50-4a09-4b39-9223-be59a8f90e6b","delay":null}	0	\N	1774320332	1774320332
34	fares	{"uuid":"70a8dede-3db0-44b3-b845-90d4b0962d0e","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774320374,"telescope_uuid":"a15f9d90-8291-414c-afe7-fd530e934a27","delay":null}	0	\N	1774320374	1774320374
35	fares	{"uuid":"0f06d0bc-3f3b-4eb1-93bc-669bb25778c9","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:4;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774320374,"telescope_uuid":"a15f9d90-84ba-4432-a283-d2142045b8a0","delay":null}	0	\N	1774320374	1774320374
36	fares	{"uuid":"57666e14-b774-4c67-a3f3-b6f68fd3a91c","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:1;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774320577,"telescope_uuid":"a15f9ec6-a3ba-4d33-b8f2-9cf1b23a5c12","delay":null}	0	\N	1774320577	1774320577
37	fares	{"uuid":"42ab3974-c070-4deb-b43c-603186b9a4a9","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:3;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774320577,"telescope_uuid":"a15f9ec6-a61a-44f0-ade2-5181edc807d2","delay":null}	0	\N	1774320577	1774320577
38	fares	{"uuid":"0dcb9277-25c4-4802-9fdb-d07bbeb5b1c2","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:5;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774322675,"telescope_uuid":"a15fab47-9b47-4182-ac01-06131aeea60a","delay":null}	0	\N	1774322675	1774322675
39	fares	{"uuid":"42b69907-a19c-41f5-9c7e-d9df481d0095","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:2;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774322675,"telescope_uuid":"a15fab47-9e0d-4f46-8619-c3457850cd9f","delay":null}	0	\N	1774322675	1774322675
40	fares	{"uuid":"2b05d64a-490d-497b-a97b-bea7f0176da3","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:5;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774322717,"telescope_uuid":"a15fab87-9028-47ec-a0b4-488aca261fc1","delay":null}	0	\N	1774322717	1774322717
41	fares	{"uuid":"ccd7e8e7-ee02-4918-b1c5-4a65608868bc","displayName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\RecalculateFaresForZoneJob","command":"O:35:\\"App\\\\Jobs\\\\RecalculateFaresForZoneJob\\":2:{s:6:\\"zoneId\\";i:2;s:5:\\"queue\\";s:5:\\"fares\\";}","batchId":null},"createdAt":1774322717,"telescope_uuid":"a15fab87-9279-497e-8cf7-cfcd61549266","delay":null}	0	\N	1774322717	1774322717
42	dispatch	{"uuid":"b3727c9e-45a1-4537-a893-367b62a03a21","displayName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","command":"O:33:\\"App\\\\Jobs\\\\ProcessDriverMatchingJob\\":2:{s:9:\\"bookingId\\";i:3;s:5:\\"queue\\";s:8:\\"dispatch\\";}","batchId":null},"createdAt":1774364103,"telescope_uuid":"a160a236-2c76-4aae-bab5-cd0dacc48fe6","delay":null}	0	\N	1774364103	1774364103
43	dispatch	{"uuid":"0266e457-c62b-459b-af87-530d6e2edf3a","displayName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","command":"O:33:\\"App\\\\Jobs\\\\ProcessDriverMatchingJob\\":2:{s:9:\\"bookingId\\";i:4;s:5:\\"queue\\";s:8:\\"dispatch\\";}","batchId":null},"createdAt":1774364278,"telescope_uuid":"a160a340-8fc0-410c-b5cd-67571b63c096","delay":null}	0	\N	1774364278	1774364278
44	dispatch	{"uuid":"60d8dff3-46f8-4e60-87d0-d5e850e76a38","displayName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","command":"O:33:\\"App\\\\Jobs\\\\ProcessDriverMatchingJob\\":2:{s:9:\\"bookingId\\";i:5;s:5:\\"queue\\";s:8:\\"dispatch\\";}","batchId":null},"createdAt":1774408031,"telescope_uuid":"a161a80a-6434-4fcc-b4fc-9026cb2e938a","delay":null}	0	\N	1774408031	1774408031
45	dispatch	{"uuid":"e57971b2-a2d9-4cbb-ab46-1ff583e6f10c","displayName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","command":"O:33:\\"App\\\\Jobs\\\\ProcessDriverMatchingJob\\":2:{s:9:\\"bookingId\\";i:6;s:5:\\"queue\\";s:8:\\"dispatch\\";}","batchId":null},"createdAt":1774411907,"telescope_uuid":"a161bf25-2cf9-492f-99a4-4ee59229fc6a","delay":null}	0	\N	1774411907	1774411907
46	dispatch	{"uuid":"5fdfcecf-4c3f-4160-a683-53d028148150","displayName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","command":"O:33:\\"App\\\\Jobs\\\\ProcessDriverMatchingJob\\":2:{s:9:\\"bookingId\\";i:7;s:5:\\"queue\\";s:8:\\"dispatch\\";}","batchId":null},"createdAt":1774476845,"telescope_uuid":"a1634234-7e4a-45f4-8a81-03d5c5f57ea1","delay":null}	0	\N	1774476845	1774476845
47	dispatch	{"uuid":"ffb040e3-28cc-4fc6-8718-53c6f2a3d7c6","displayName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","command":"O:33:\\"App\\\\Jobs\\\\ProcessDriverMatchingJob\\":2:{s:9:\\"bookingId\\";i:8;s:5:\\"queue\\";s:8:\\"dispatch\\";}","batchId":null},"createdAt":1774487119,"delay":null}	0	\N	1774487119	1774487119
48	notifications	{"uuid":"47cf8502-c274-436c-b0af-ef4d07056a03","displayName":"App\\\\Jobs\\\\SendNotificationJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\SendNotificationJob","command":"O:28:\\"App\\\\Jobs\\\\SendNotificationJob\\":6:{s:7:\\"channel\\";s:5:\\"email\\";s:9:\\"recipient\\";s:21:\\"umershah444@gmail.com\\";s:7:\\"subject\\";s:30:\\"Booking API-GOUK3URS Confirmed\\";s:7:\\"message\\";s:62:\\"Your booking API-GOUK3URS has been created. Total: GBP 107.86.\\";s:4:\\"data\\";N;s:5:\\"queue\\";s:13:\\"notifications\\";}","batchId":null},"createdAt":1774487119,"delay":null}	0	\N	1774487119	1774487119
49	dispatch	{"uuid":"0a5a6dbd-5ba7-48ec-a515-b44d98cc83c3","displayName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","command":"O:33:\\"App\\\\Jobs\\\\ProcessDriverMatchingJob\\":2:{s:9:\\"bookingId\\";i:9;s:5:\\"queue\\";s:8:\\"dispatch\\";}","batchId":null},"createdAt":1774487198,"delay":null}	0	\N	1774487198	1774487198
50	notifications	{"uuid":"f3096997-7cea-4e8a-ba73-bfab876683ea","displayName":"App\\\\Jobs\\\\SendNotificationJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\SendNotificationJob","command":"O:28:\\"App\\\\Jobs\\\\SendNotificationJob\\":6:{s:7:\\"channel\\";s:5:\\"email\\";s:9:\\"recipient\\";s:21:\\"umershah444@gmail.com\\";s:7:\\"subject\\";s:30:\\"Booking API-YKREPMMV Confirmed\\";s:7:\\"message\\";s:62:\\"Your booking API-YKREPMMV has been created. Total: GBP 107.86.\\";s:4:\\"data\\";N;s:5:\\"queue\\";s:13:\\"notifications\\";}","batchId":null},"createdAt":1774487198,"delay":null}	0	\N	1774487198	1774487198
51	dispatch	{"uuid":"c96e5e09-3313-4d16-98e9-bfeb562afffc","displayName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\ProcessDriverMatchingJob","command":"O:33:\\"App\\\\Jobs\\\\ProcessDriverMatchingJob\\":2:{s:9:\\"bookingId\\";i:10;s:5:\\"queue\\";s:8:\\"dispatch\\";}","batchId":null},"createdAt":1774489848,"delay":null}	0	\N	1774489848	1774489848
52	notifications	{"uuid":"2fe4f547-5eb6-4692-807c-cf584db10643","displayName":"App\\\\Jobs\\\\SendNotificationJob","job":"Illuminate\\\\Queue\\\\CallQueuedHandler@call","maxTries":null,"maxExceptions":null,"failOnTimeout":false,"backoff":null,"timeout":null,"retryUntil":null,"data":{"commandName":"App\\\\Jobs\\\\SendNotificationJob","command":"O:28:\\"App\\\\Jobs\\\\SendNotificationJob\\":6:{s:7:\\"channel\\";s:5:\\"email\\";s:9:\\"recipient\\";s:16:\\"ali786@gmail.com\\";s:7:\\"subject\\";s:30:\\"Booking API-X8JB1MCI Confirmed\\";s:7:\\"message\\";s:58:\\"Your booking API-X8JB1MCI has been created. Total: GBP 25.\\";s:4:\\"data\\";N;s:5:\\"queue\\";s:13:\\"notifications\\";}","batchId":null},"createdAt":1774489848,"delay":null}	0	\N	1774489848	1774489848
\.


--
-- TOC entry 6218 (class 0 OID 16390)
-- Dependencies: 221
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.migrations (id, migration, batch) FROM stdin;
1	0001_01_01_000000_create_users_table	1
2	0001_01_01_000001_create_cache_table	1
3	0001_01_01_000002_create_jobs_table	1
4	2026_03_18_035137_create_permission_tables	2
5	2026_03_18_035907_create_zones_table	3
6	2026_03_18_035909_create_vehicle_types_table	3
7	2026_03_18_035910_create_fixed_prices_table	3
8	2026_03_18_035911_create_breakpoint_sets_table	3
9	2026_03_18_035915_create_breakpoint_tiers_table	3
10	2026_03_18_035916_create_distance_rules_table	3
11	2026_03_18_035918_create_time_rates_table	3
12	2026_03_18_035920_create_bookings_table	4
13	2026_03_18_035921_create_booking_legs_table	4
14	2026_03_18_035922_create_api_keys_table	4
15	2026_03_18_035922_create_audit_logs_table	4
16	0001_01_01_000003_enable_postgis_extension	5
17	2026_03_19_000000_add_zone_fee_columns_to_zones_table	5
18	2026_03_19_000001_add_fare_calculation_columns	6
19	2026_03_19_002929_add_min_fare_override_to_vehicle_types_table	7
20	2026_03_19_003231_add_valid_from_valid_to_to_fixed_prices_table	8
21	2026_03_19_003318_update_fixed_prices_unique_constraint	8
22	2026_03_19_003634_add_is_global_to_breakpoint_sets_table	9
23	2026_03_19_003934_add_name_and_days_to_time_rates_table	10
24	2026_03_19_020000_add_customer_fields_to_bookings_table	11
25	2026_03_19_011246_create_rides_table	12
26	2026_03_19_013850_create_system_settings_table	13
27	2026_03_20_120000_add_zone_fees_to_booking_legs_table	14
28	2026_03_24_100000_add_zone_surcharge_to_zones_and_booking_legs	15
29	2026_03_25_120000_remove_vehicle_type_from_distance_rules_and_time_rates	16
30	2026_03_26_100000_add_name_description_to_distance_rules_table	17
31	2026_03_24_120000_add_passenger_counts_and_payment_to_bookings	18
32	2026_03_25_100000_add_flight_number_to_bookings_table	19
33	2026_03_26_120000_add_pickup_dropoff_notes_to_bookings_table	20
34	2026_03_26_140000_add_icon_to_vehicle_types_table	21
\.


--
-- TOC entry 6234 (class 0 OID 16534)
-- Dependencies: 237
-- Data for Name: model_has_permissions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.model_has_permissions (permission_id, model_type, model_id) FROM stdin;
\.


--
-- TOC entry 6235 (class 0 OID 16548)
-- Dependencies: 238
-- Data for Name: model_has_roles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.model_has_roles (role_id, model_type, model_id) FROM stdin;
1	App\\Models\\User	1
3	App\\Models\\User	2
3	App\\Models\\User	3
3	App\\Models\\User	4
3	App\\Models\\User	5
3	App\\Models\\User	6
\.


--
-- TOC entry 6221 (class 0 OID 16414)
-- Dependencies: 224
-- Data for Name: password_reset_tokens; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.password_reset_tokens (email, token, created_at) FROM stdin;
\.


--
-- TOC entry 6231 (class 0 OID 16507)
-- Dependencies: 234
-- Data for Name: permissions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.permissions (id, name, guard_name, created_at, updated_at) FROM stdin;
\.


--
-- TOC entry 6260 (class 0 OID 18006)
-- Dependencies: 268
-- Data for Name: rides; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.rides (id, booking_id, driver_id, status, created_at, updated_at) FROM stdin;
\.


--
-- TOC entry 6236 (class 0 OID 16562)
-- Dependencies: 239
-- Data for Name: role_has_permissions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.role_has_permissions (permission_id, role_id) FROM stdin;
\.


--
-- TOC entry 6233 (class 0 OID 16521)
-- Dependencies: 236
-- Data for Name: roles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.roles (id, name, guard_name, created_at, updated_at) FROM stdin;
1	admin	web	2026-03-18 03:54:13	2026-03-18 03:54:13
2	manager	web	2026-03-18 03:54:13	2026-03-18 03:54:13
3	driver	web	2026-03-19 01:14:49	2026-03-19 01:14:49
\.


--
-- TOC entry 6222 (class 0 OID 16423)
-- Dependencies: 225
-- Data for Name: sessions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sessions (id, user_id, ip_address, user_agent, payload, last_activity) FROM stdin;
GvVaeyD2K3JjX7B7YtHD0Xq1iigpMXxU8Vf3BNpw	1	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36	YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQlNXMWFNU0FVb0hiTnFpNVM3RDVMdHc5cGVOS1h5Sm1tR0VCVXhtRyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi92ZWhpY2xlLXR5cGVzIjtzOjU6InJvdXRlIjtzOjI1OiJhZG1pbi52ZWhpY2xlLXR5cGVzLmluZGV4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9	1774490048
AhoZfTFKocbvxEbK4tpumIVhHNKxed1z4bK1M0aQ	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36	YTozOntzOjY6Il90b2tlbiI7czo0MDoiUDBqbnFlOFVaYUZvRHo4RG03MTFQTElHVXNhT3RyNm5SbmIxcjNoaCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9sb2dpbiI7czo1OiJyb3V0ZSI7czoxMToiYWRtaW4ubG9naW4iO319	1774412410
\.


--
-- TOC entry 5890 (class 0 OID 17211)
-- Dependencies: 263
-- Data for Name: spatial_ref_sys; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text) FROM stdin;
\.


--
-- TOC entry 6262 (class 0 OID 18029)
-- Dependencies: 270
-- Data for Name: system_settings; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.system_settings (id, key, value, type, description, created_at, updated_at) FROM stdin;
1	measurement_unit	miles	string	Distance unit: km or miles	2026-03-19 01:46:37	2026-03-19 01:46:37
2	currency_symbol	£	string	Currency symbol for display	2026-03-19 01:46:37	2026-03-19 01:46:37
3	currency_code	GBP	string	ISO 4217 currency code	2026-03-19 01:46:37	2026-03-19 01:46:37
4	default_zone_id	1	integer	Zone ID to use when no zone found for a location	2026-03-19 01:46:37	2026-03-19 01:51:20
\.


--
-- TOC entry 6250 (class 0 OID 16734)
-- Dependencies: 253
-- Data for Name: time_rates; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.time_rates (id, zone_id, rate_per_minute, currency, minimum_minutes, active, created_at, updated_at, valid_from, valid_to, name, days) FROM stdin;
\.


--
-- TOC entry 6220 (class 0 OID 16400)
-- Dependencies: 223
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.users (id, name, email, email_verified_at, password, remember_token, created_at, updated_at) FROM stdin;
2	Driver 1	driver1@exadispatch.test	\N	$2y$12$ekC7snJHyb3S9ywIcVlWpOJkV5InztgN39F7SayYl965vDSgOURW6	\N	2026-03-19 01:14:56	2026-03-19 01:14:56
3	Driver 2	driver2@exadispatch.test	\N	$2y$12$KCtxF867DnFZAjYbb3LCBeonDTZadT99R7gFHUSjsilnG6rBpRGIS	\N	2026-03-19 01:14:57	2026-03-19 01:14:57
4	Driver 3	driver3@exadispatch.test	\N	$2y$12$M0ul7nbpPYQPFFBCmsvCXOYxSdP06.gEf9tGwoCoumGVzbZzNaHT2	\N	2026-03-19 01:14:57	2026-03-19 01:14:57
5	Driver 4	driver4@exadispatch.test	\N	$2y$12$2QtdqjYbiRn6paT9FrHWf.h7SmZfinEkVRnGjHt2JHssn6audvV1S	\N	2026-03-19 01:14:57	2026-03-19 01:14:57
6	Driver 5	driver5@exadispatch.test	\N	$2y$12$Ba17wpFT1zAPr9otf2A2ceoDqGFaWQ7NWHveAVwyXnLlskno9QCv2	\N	2026-03-19 01:14:58	2026-03-19 01:14:58
1	Admin	admin@example.com	\N	$2y$12$9cseIAo7PgXv3lppgp/.DOcyEAw84ArCaW0EMtSJGqDhFgZWj1XRW	3HcQkLKuGxF4lVgByPFgbD58El3IcNUsYYuNG08pm7rIPly3PDtGtxwrWfNb	2026-03-18 03:54:13	2026-03-18 03:54:13
\.


--
-- TOC entry 6240 (class 0 OID 16613)
-- Dependencies: 243
-- Data for Name: vehicle_types; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.vehicle_types (id, name, code, description, capacity, active, created_at, updated_at, fare_multiplier, min_fare_override, icon) FROM stdin;
6	8 Seater	8-seater	\N	8	t	2026-03-18 04:14:50	2026-03-26 01:10:33	1.75	20.00	vehicle-icons/X4VYYvCgCVW1dc8EnKEgRAgrViz6GNEIMm8SiD1p.png
4	Executive	executive	\N	4	t	2026-03-18 04:14:50	2026-03-26 01:11:21	1.50	\N	vehicle-icons/ErqgarjHKRkGMpuX7TZ0aSmYwPhM2V3IuTA99o9V.png
5	6 Seater	6-seater	\N	6	t	2026-03-18 04:14:50	2026-03-26 01:32:08	1.50	\N	vehicle-icons/6GSKo76jhS3kJqN3bAxBuIvLmhIbT9VzjmzfJxem.png
3	Estate	estate	\N	5	t	2026-03-18 04:14:50	2026-03-26 01:53:33	1.15	\N	vehicle-icons/LC9KeihOJUmIaUNF4wy5Haz4AB6qjRvNbFxgTfwN.png
2	Saloon	saloon	\N	4	t	2026-03-18 04:14:50	2026-03-26 01:53:48	1.00	\N	vehicle-icons/DbZhliERNFDBWjUwWGBi5GosHqMY8vbqlBABEZ9S.png
1	Standard	standard	\N	4	t	2026-03-18 04:14:50	2026-03-26 01:54:06	1.00	\N	vehicle-icons/kE3tEs8GTSo2gH0lsfIAyZt1V9S0vbylgha8SlaL.png
\.


--
-- TOC entry 6238 (class 0 OID 16596)
-- Dependencies: 241
-- Data for Name: zones; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.zones (id, name, code, active, created_at, updated_at, geometry, type, pickup_fee, dropoff_fee, surcharge) FROM stdin;
2	Heathrow Airport	heathrow-airport	t	2026-03-19 01:02:35	2026-03-20 01:43:59	{"type":"Polygon","coordinates":[[[-0.48751826871903386,51.48138289597047],[-0.4567909240722656,51.48170361097427],[-0.42603947094650435,51.47950438181997],[-0.41402610250888877,51.47180622940865],[-0.41402610250888877,51.47052307769669],[-0.4248381341027408,51.46560399513444],[-0.4382244589332519,51.459507874487876],[-0.4502313022272021,51.455443339802116],[-0.4596703774281985,51.457154766165345],[-0.46962431127653087,51.45758261273016],[-0.47636044652844556,51.45753676820714],[-0.483570726294611,51.45582535599527],[-0.49438409637950104,51.45593232123376],[-0.4945557995842953,51.46202891973839],[-0.49867487790212783,51.465878983689166],[-0.5012493384501315,51.4727227394407],[-0.49936135609855553,51.48042073755718],[-0.48751826871903386,51.48138289597047]]]}	airport	0.00	7.00	0.00
1	Default Zone	default	t	2026-03-18 04:14:50	2026-03-21 00:37:16	{"type":"Polygon","coordinates":[[[0.4007814640365837,50.71559117827945],[1.1973277308474286,50.972264892270424],[1.526849311555849,51.371780370423224],[1.0052503619284983,51.35463124423159],[0.8129735578488618,51.43003945474684],[1.0875420820761141,51.757640396870855],[1.977180346908889,52.56299497433862],[-1.9773088420460196,55.67758433736191],[-3.251771090222429,55.06578678387654],[-3.9764618452049088,52.66305760670557],[-5.657549406125465,51.80182153913896],[-4.196683649379199,51.62483747110962],[-3.4823822555305384,51.4060594269529],[-2.801315575205292,51.4060594010713],[-4.108715391900513,51.19311521522953],[-5.9760967051279685,49.96535596598641],[-4.020685563835318,50.190967824615484],[-2.7024118522600515,50.499452146620605],[-0.7637653017403624,50.70863445045765],[0.4007814640365837,50.71559117827945]]]}	custom	0.00	0.00	0.00
4	Central London East	central-london-east	t	2026-03-24 01:30:44	2026-03-24 01:30:44	{"type":"Polygon","coordinates":[[[-0.13933669581218225,51.52418603194774],[-0.1208017845083931,51.53038030011526],[-0.10552764463769072,51.53155498004606],[-0.07824013632937278,51.525040463865764],[-0.06468219194974979,51.50762824878712],[-0.08476167919550638,51.49373643445862],[-0.09866286267333325,51.49384331073033],[-0.11033299201274496,51.47962656695848],[-0.14585823867831585,51.49533955222416],[-0.15769998756683948,51.511367629169754],[-0.17057145375001473,51.52055451742803],[-0.13933669581218225,51.52418603194774]]]}	urban	0.00	0.00	60.00
3	Local Area	local-area	t	2026-03-19 01:43:45	2026-03-24 01:56:52	{"type":"Polygon","coordinates":[[[-0.7661278728811062,51.528305468031284],[-0.7650981555864546,51.516342819930294],[-0.74519028788981,51.50309479377024],[-0.725968898389593,51.49433188610307],[-0.6522295454521011,51.462899806921826],[-0.7342636899262068,51.45198973780534],[-0.6645861529879405,51.40146996888934],[-0.5856411603977896,51.38111785218719],[-0.5183662971470704,51.40511097167809],[-0.4716857797894036,51.43829498094665],[-0.45658325946781325,51.45113393582278],[-0.5063529287094349,51.466322036326126],[-0.5087390385706914,51.48492591617894],[-0.4867717362847435,51.49860668609052],[-0.5035904520974134,51.54175969148802],[-0.588713748455494,51.55691762123131],[-0.6285294838487833,51.56886960905847],[-0.7098771501264611,51.57761817969365],[-0.7572441456805358,51.57057677945071],[-0.7661278728811062,51.528305468031284]]]}	urban	0.00	0.00	0.00
5	Ascot	ascot	t	2026-03-24 03:23:45	2026-03-24 03:23:45	{"type":"Polygon","coordinates":[[[-0.703719232159399,51.424749024801514],[-0.6585832907437196,51.43406038746411],[-0.6179405775208947,51.389412807036614],[-0.6850438212225218,51.374842057536156],[-0.703719232159399,51.424749024801514]]]}	suburban	0.00	0.00	0.00
\.


--
-- TOC entry 6293 (class 0 OID 0)
-- Dependencies: 258
-- Name: api_keys_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.api_keys_id_seq', 2, true);


--
-- TOC entry 6294 (class 0 OID 0)
-- Dependencies: 260
-- Name: audit_logs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.audit_logs_id_seq', 267, true);


--
-- TOC entry 6295 (class 0 OID 0)
-- Dependencies: 256
-- Name: booking_legs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.booking_legs_id_seq', 12, true);


--
-- TOC entry 6296 (class 0 OID 0)
-- Dependencies: 254
-- Name: bookings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.bookings_id_seq', 10, true);


--
-- TOC entry 6297 (class 0 OID 0)
-- Dependencies: 246
-- Name: breakpoint_sets_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.breakpoint_sets_id_seq', 10, true);


--
-- TOC entry 6298 (class 0 OID 0)
-- Dependencies: 248
-- Name: breakpoint_tiers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.breakpoint_tiers_id_seq', 37, true);


--
-- TOC entry 6299 (class 0 OID 0)
-- Dependencies: 250
-- Name: distance_rules_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.distance_rules_id_seq', 10, true);


--
-- TOC entry 6300 (class 0 OID 0)
-- Dependencies: 231
-- Name: failed_jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.failed_jobs_id_seq', 1, false);


--
-- TOC entry 6301 (class 0 OID 0)
-- Dependencies: 244
-- Name: fixed_prices_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.fixed_prices_id_seq', 3, true);


--
-- TOC entry 6302 (class 0 OID 0)
-- Dependencies: 228
-- Name: jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.jobs_id_seq', 52, true);


--
-- TOC entry 6303 (class 0 OID 0)
-- Dependencies: 220
-- Name: migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.migrations_id_seq', 34, true);


--
-- TOC entry 6304 (class 0 OID 0)
-- Dependencies: 233
-- Name: permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.permissions_id_seq', 1, false);


--
-- TOC entry 6305 (class 0 OID 0)
-- Dependencies: 267
-- Name: rides_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.rides_id_seq', 1, false);


--
-- TOC entry 6306 (class 0 OID 0)
-- Dependencies: 235
-- Name: roles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.roles_id_seq', 3, true);


--
-- TOC entry 6307 (class 0 OID 0)
-- Dependencies: 269
-- Name: system_settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.system_settings_id_seq', 4, true);


--
-- TOC entry 6308 (class 0 OID 0)
-- Dependencies: 252
-- Name: time_rates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.time_rates_id_seq', 3, true);


--
-- TOC entry 6309 (class 0 OID 0)
-- Dependencies: 222
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.users_id_seq', 6, true);


--
-- TOC entry 6310 (class 0 OID 0)
-- Dependencies: 242
-- Name: vehicle_types_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.vehicle_types_id_seq', 6, true);


--
-- TOC entry 6311 (class 0 OID 0)
-- Dependencies: 240
-- Name: zones_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.zones_id_seq', 5, true);


--
-- TOC entry 6019 (class 2606 OID 16868)
-- Name: api_keys api_keys_key_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.api_keys
    ADD CONSTRAINT api_keys_key_unique UNIQUE (key);


--
-- TOC entry 6021 (class 2606 OID 16861)
-- Name: api_keys api_keys_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.api_keys
    ADD CONSTRAINT api_keys_pkey PRIMARY KEY (id);


--
-- TOC entry 6028 (class 2606 OID 16881)
-- Name: audit_logs audit_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_logs
    ADD CONSTRAINT audit_logs_pkey PRIMARY KEY (id);


--
-- TOC entry 6017 (class 2606 OID 16833)
-- Name: booking_legs booking_legs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_legs
    ADD CONSTRAINT booking_legs_pkey PRIMARY KEY (id);


--
-- TOC entry 6009 (class 2606 OID 16793)
-- Name: bookings bookings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_pkey PRIMARY KEY (id);


--
-- TOC entry 6011 (class 2606 OID 16815)
-- Name: bookings bookings_reference_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_reference_unique UNIQUE (reference);


--
-- TOC entry 5994 (class 2606 OID 16667)
-- Name: breakpoint_sets breakpoint_sets_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.breakpoint_sets
    ADD CONSTRAINT breakpoint_sets_pkey PRIMARY KEY (id);


--
-- TOC entry 5998 (class 2606 OID 16692)
-- Name: breakpoint_tiers breakpoint_tiers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.breakpoint_tiers
    ADD CONSTRAINT breakpoint_tiers_pkey PRIMARY KEY (id);


--
-- TOC entry 5953 (class 2606 OID 16455)
-- Name: cache_locks cache_locks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cache_locks
    ADD CONSTRAINT cache_locks_pkey PRIMARY KEY (key);


--
-- TOC entry 5950 (class 2606 OID 16444)
-- Name: cache cache_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cache
    ADD CONSTRAINT cache_pkey PRIMARY KEY (key);


--
-- TOC entry 6001 (class 2606 OID 16714)
-- Name: distance_rules distance_rules_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.distance_rules
    ADD CONSTRAINT distance_rules_pkey PRIMARY KEY (id);


--
-- TOC entry 6003 (class 2606 OID 32776)
-- Name: distance_rules distance_rules_zone_pair_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.distance_rules
    ADD CONSTRAINT distance_rules_zone_pair_unique UNIQUE (zone_id, destination_zone_id);


--
-- TOC entry 5960 (class 2606 OID 16503)
-- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id);


--
-- TOC entry 5962 (class 2606 OID 16505)
-- Name: failed_jobs failed_jobs_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid);


--
-- TOC entry 5991 (class 2606 OID 16643)
-- Name: fixed_prices fixed_prices_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fixed_prices
    ADD CONSTRAINT fixed_prices_pkey PRIMARY KEY (id);


--
-- TOC entry 5958 (class 2606 OID 16486)
-- Name: job_batches job_batches_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.job_batches
    ADD CONSTRAINT job_batches_pkey PRIMARY KEY (id);


--
-- TOC entry 5955 (class 2606 OID 16471)
-- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT jobs_pkey PRIMARY KEY (id);


--
-- TOC entry 5937 (class 2606 OID 16398)
-- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.migrations
    ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);


--
-- TOC entry 5973 (class 2606 OID 16547)
-- Name: model_has_permissions model_has_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.model_has_permissions
    ADD CONSTRAINT model_has_permissions_pkey PRIMARY KEY (permission_id, model_id, model_type);


--
-- TOC entry 5976 (class 2606 OID 16561)
-- Name: model_has_roles model_has_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.model_has_roles
    ADD CONSTRAINT model_has_roles_pkey PRIMARY KEY (role_id, model_id, model_type);


--
-- TOC entry 5943 (class 2606 OID 16422)
-- Name: password_reset_tokens password_reset_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.password_reset_tokens
    ADD CONSTRAINT password_reset_tokens_pkey PRIMARY KEY (email);


--
-- TOC entry 5964 (class 2606 OID 16519)
-- Name: permissions permissions_name_guard_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_name_guard_name_unique UNIQUE (name, guard_name);


--
-- TOC entry 5966 (class 2606 OID 16517)
-- Name: permissions permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.permissions
    ADD CONSTRAINT permissions_pkey PRIMARY KEY (id);


--
-- TOC entry 6034 (class 2606 OID 18016)
-- Name: rides rides_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rides
    ADD CONSTRAINT rides_pkey PRIMARY KEY (id);


--
-- TOC entry 5978 (class 2606 OID 16578)
-- Name: role_has_permissions role_has_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.role_has_permissions
    ADD CONSTRAINT role_has_permissions_pkey PRIMARY KEY (permission_id, role_id);


--
-- TOC entry 5968 (class 2606 OID 16533)
-- Name: roles roles_name_guard_name_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_name_guard_name_unique UNIQUE (name, guard_name);


--
-- TOC entry 5970 (class 2606 OID 16531)
-- Name: roles roles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_pkey PRIMARY KEY (id);


--
-- TOC entry 5946 (class 2606 OID 16432)
-- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);


--
-- TOC entry 6036 (class 2606 OID 18042)
-- Name: system_settings system_settings_key_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.system_settings
    ADD CONSTRAINT system_settings_key_unique UNIQUE (key);


--
-- TOC entry 6038 (class 2606 OID 18040)
-- Name: system_settings system_settings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.system_settings
    ADD CONSTRAINT system_settings_pkey PRIMARY KEY (id);


--
-- TOC entry 6006 (class 2606 OID 16747)
-- Name: time_rates time_rates_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.time_rates
    ADD CONSTRAINT time_rates_pkey PRIMARY KEY (id);


--
-- TOC entry 5939 (class 2606 OID 16413)
-- Name: users users_email_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_email_unique UNIQUE (email);


--
-- TOC entry 5941 (class 2606 OID 16411)
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- TOC entry 5986 (class 2606 OID 16627)
-- Name: vehicle_types vehicle_types_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vehicle_types
    ADD CONSTRAINT vehicle_types_code_unique UNIQUE (code);


--
-- TOC entry 5988 (class 2606 OID 16625)
-- Name: vehicle_types vehicle_types_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.vehicle_types
    ADD CONSTRAINT vehicle_types_pkey PRIMARY KEY (id);


--
-- TOC entry 5981 (class 2606 OID 16610)
-- Name: zones zones_code_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.zones
    ADD CONSTRAINT zones_code_unique UNIQUE (code);


--
-- TOC entry 5983 (class 2606 OID 16608)
-- Name: zones zones_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.zones
    ADD CONSTRAINT zones_pkey PRIMARY KEY (id);


--
-- TOC entry 6022 (class 1259 OID 16869)
-- Name: api_keys_prefix_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX api_keys_prefix_index ON public.api_keys USING btree (prefix);


--
-- TOC entry 6023 (class 1259 OID 16870)
-- Name: api_keys_user_id_prefix_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX api_keys_user_id_prefix_index ON public.api_keys USING btree (user_id, prefix);


--
-- TOC entry 6024 (class 1259 OID 16888)
-- Name: audit_logs_action_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX audit_logs_action_index ON public.audit_logs USING btree (action);


--
-- TOC entry 6025 (class 1259 OID 16889)
-- Name: audit_logs_created_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX audit_logs_created_at_index ON public.audit_logs USING btree (created_at);


--
-- TOC entry 6026 (class 1259 OID 16887)
-- Name: audit_logs_model_type_model_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX audit_logs_model_type_model_id_index ON public.audit_logs USING btree (model_type, model_id);


--
-- TOC entry 6029 (class 1259 OID 16890)
-- Name: audit_logs_user_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX audit_logs_user_id_index ON public.audit_logs USING btree (user_id);


--
-- TOC entry 6015 (class 1259 OID 16849)
-- Name: booking_legs_booking_id_leg_order_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX booking_legs_booking_id_leg_order_index ON public.booking_legs USING btree (booking_id, leg_order);


--
-- TOC entry 6007 (class 1259 OID 32814)
-- Name: bookings_customer_phone_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX bookings_customer_phone_index ON public.bookings USING btree (customer_phone);


--
-- TOC entry 6012 (class 1259 OID 16817)
-- Name: bookings_scheduled_at_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX bookings_scheduled_at_index ON public.bookings USING btree (scheduled_at);


--
-- TOC entry 6013 (class 1259 OID 16816)
-- Name: bookings_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX bookings_status_index ON public.bookings USING btree (status);


--
-- TOC entry 6014 (class 1259 OID 16818)
-- Name: bookings_user_id_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX bookings_user_id_status_index ON public.bookings USING btree (user_id, status);


--
-- TOC entry 5992 (class 1259 OID 16679)
-- Name: breakpoint_sets_active_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX breakpoint_sets_active_index ON public.breakpoint_sets USING btree (active);


--
-- TOC entry 5995 (class 1259 OID 16678)
-- Name: breakpoint_sets_zone_id_vehicle_type_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX breakpoint_sets_zone_id_vehicle_type_id_index ON public.breakpoint_sets USING btree (zone_id, vehicle_type_id);


--
-- TOC entry 5996 (class 1259 OID 16698)
-- Name: breakpoint_tiers_breakpoint_set_id_min_distance_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX breakpoint_tiers_breakpoint_set_id_min_distance_index ON public.breakpoint_tiers USING btree (breakpoint_set_id, min_distance);


--
-- TOC entry 5948 (class 1259 OID 16445)
-- Name: cache_expiration_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX cache_expiration_index ON public.cache USING btree (expiration);


--
-- TOC entry 5951 (class 1259 OID 16456)
-- Name: cache_locks_expiration_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX cache_locks_expiration_index ON public.cache_locks USING btree (expiration);


--
-- TOC entry 5999 (class 1259 OID 16732)
-- Name: distance_rules_active_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX distance_rules_active_index ON public.distance_rules USING btree (active);


--
-- TOC entry 5989 (class 1259 OID 16656)
-- Name: fixed_prices_active_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX fixed_prices_active_index ON public.fixed_prices USING btree (active);


--
-- TOC entry 5956 (class 1259 OID 16472)
-- Name: jobs_queue_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX jobs_queue_index ON public.jobs USING btree (queue);


--
-- TOC entry 5971 (class 1259 OID 16540)
-- Name: model_has_permissions_model_id_model_type_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX model_has_permissions_model_id_model_type_index ON public.model_has_permissions USING btree (model_id, model_type);


--
-- TOC entry 5974 (class 1259 OID 16554)
-- Name: model_has_roles_model_id_model_type_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX model_has_roles_model_id_model_type_index ON public.model_has_roles USING btree (model_id, model_type);


--
-- TOC entry 6032 (class 1259 OID 18027)
-- Name: rides_driver_id_status_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX rides_driver_id_status_index ON public.rides USING btree (driver_id, status);


--
-- TOC entry 5944 (class 1259 OID 16434)
-- Name: sessions_last_activity_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX sessions_last_activity_index ON public.sessions USING btree (last_activity);


--
-- TOC entry 5947 (class 1259 OID 16433)
-- Name: sessions_user_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX sessions_user_id_index ON public.sessions USING btree (user_id);


--
-- TOC entry 6004 (class 1259 OID 16760)
-- Name: time_rates_active_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX time_rates_active_index ON public.time_rates USING btree (active);


--
-- TOC entry 5984 (class 1259 OID 16628)
-- Name: vehicle_types_active_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX vehicle_types_active_index ON public.vehicle_types USING btree (active);


--
-- TOC entry 5979 (class 1259 OID 16611)
-- Name: zones_active_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX zones_active_index ON public.zones USING btree (active);


--
-- TOC entry 6061 (class 2606 OID 16862)
-- Name: api_keys api_keys_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.api_keys
    ADD CONSTRAINT api_keys_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- TOC entry 6062 (class 2606 OID 16882)
-- Name: audit_logs audit_logs_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_logs
    ADD CONSTRAINT audit_logs_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- TOC entry 6058 (class 2606 OID 16834)
-- Name: booking_legs booking_legs_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_legs
    ADD CONSTRAINT booking_legs_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE CASCADE;


--
-- TOC entry 6059 (class 2606 OID 16844)
-- Name: booking_legs booking_legs_dropoff_zone_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_legs
    ADD CONSTRAINT booking_legs_dropoff_zone_id_foreign FOREIGN KEY (dropoff_zone_id) REFERENCES public.zones(id) ON DELETE SET NULL;


--
-- TOC entry 6060 (class 2606 OID 16839)
-- Name: booking_legs booking_legs_pickup_zone_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.booking_legs
    ADD CONSTRAINT booking_legs_pickup_zone_id_foreign FOREIGN KEY (pickup_zone_id) REFERENCES public.zones(id) ON DELETE SET NULL;


--
-- TOC entry 6054 (class 2606 OID 16804)
-- Name: bookings bookings_dropoff_zone_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_dropoff_zone_id_foreign FOREIGN KEY (dropoff_zone_id) REFERENCES public.zones(id) ON DELETE SET NULL;


--
-- TOC entry 6055 (class 2606 OID 16799)
-- Name: bookings bookings_pickup_zone_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_pickup_zone_id_foreign FOREIGN KEY (pickup_zone_id) REFERENCES public.zones(id) ON DELETE SET NULL;


--
-- TOC entry 6056 (class 2606 OID 16794)
-- Name: bookings bookings_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- TOC entry 6057 (class 2606 OID 16809)
-- Name: bookings bookings_vehicle_type_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bookings
    ADD CONSTRAINT bookings_vehicle_type_id_foreign FOREIGN KEY (vehicle_type_id) REFERENCES public.vehicle_types(id) ON DELETE CASCADE;


--
-- TOC entry 6047 (class 2606 OID 16673)
-- Name: breakpoint_sets breakpoint_sets_vehicle_type_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.breakpoint_sets
    ADD CONSTRAINT breakpoint_sets_vehicle_type_id_foreign FOREIGN KEY (vehicle_type_id) REFERENCES public.vehicle_types(id) ON DELETE SET NULL;


--
-- TOC entry 6048 (class 2606 OID 16668)
-- Name: breakpoint_sets breakpoint_sets_zone_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.breakpoint_sets
    ADD CONSTRAINT breakpoint_sets_zone_id_foreign FOREIGN KEY (zone_id) REFERENCES public.zones(id) ON DELETE SET NULL;


--
-- TOC entry 6049 (class 2606 OID 16693)
-- Name: breakpoint_tiers breakpoint_tiers_breakpoint_set_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.breakpoint_tiers
    ADD CONSTRAINT breakpoint_tiers_breakpoint_set_id_foreign FOREIGN KEY (breakpoint_set_id) REFERENCES public.breakpoint_sets(id) ON DELETE CASCADE;


--
-- TOC entry 6050 (class 2606 OID 16725)
-- Name: distance_rules distance_rules_breakpoint_set_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.distance_rules
    ADD CONSTRAINT distance_rules_breakpoint_set_id_foreign FOREIGN KEY (breakpoint_set_id) REFERENCES public.breakpoint_sets(id) ON DELETE SET NULL;


--
-- TOC entry 6051 (class 2606 OID 17994)
-- Name: distance_rules distance_rules_destination_zone_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.distance_rules
    ADD CONSTRAINT distance_rules_destination_zone_id_foreign FOREIGN KEY (destination_zone_id) REFERENCES public.zones(id) ON DELETE SET NULL;


--
-- TOC entry 6052 (class 2606 OID 16715)
-- Name: distance_rules distance_rules_zone_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.distance_rules
    ADD CONSTRAINT distance_rules_zone_id_foreign FOREIGN KEY (zone_id) REFERENCES public.zones(id) ON DELETE CASCADE;


--
-- TOC entry 6043 (class 2606 OID 17989)
-- Name: fixed_prices fixed_prices_destination_zone_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fixed_prices
    ADD CONSTRAINT fixed_prices_destination_zone_id_foreign FOREIGN KEY (destination_zone_id) REFERENCES public.zones(id) ON DELETE SET NULL;


--
-- TOC entry 6044 (class 2606 OID 17984)
-- Name: fixed_prices fixed_prices_origin_zone_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fixed_prices
    ADD CONSTRAINT fixed_prices_origin_zone_id_foreign FOREIGN KEY (origin_zone_id) REFERENCES public.zones(id) ON DELETE SET NULL;


--
-- TOC entry 6045 (class 2606 OID 16649)
-- Name: fixed_prices fixed_prices_vehicle_type_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fixed_prices
    ADD CONSTRAINT fixed_prices_vehicle_type_id_foreign FOREIGN KEY (vehicle_type_id) REFERENCES public.vehicle_types(id) ON DELETE CASCADE;


--
-- TOC entry 6046 (class 2606 OID 16644)
-- Name: fixed_prices fixed_prices_zone_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.fixed_prices
    ADD CONSTRAINT fixed_prices_zone_id_foreign FOREIGN KEY (zone_id) REFERENCES public.zones(id) ON DELETE CASCADE;


--
-- TOC entry 6039 (class 2606 OID 16541)
-- Name: model_has_permissions model_has_permissions_permission_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.model_has_permissions
    ADD CONSTRAINT model_has_permissions_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.permissions(id) ON DELETE CASCADE;


--
-- TOC entry 6040 (class 2606 OID 16555)
-- Name: model_has_roles model_has_roles_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.model_has_roles
    ADD CONSTRAINT model_has_roles_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;


--
-- TOC entry 6063 (class 2606 OID 18017)
-- Name: rides rides_booking_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rides
    ADD CONSTRAINT rides_booking_id_foreign FOREIGN KEY (booking_id) REFERENCES public.bookings(id) ON DELETE CASCADE;


--
-- TOC entry 6064 (class 2606 OID 18022)
-- Name: rides rides_driver_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.rides
    ADD CONSTRAINT rides_driver_id_foreign FOREIGN KEY (driver_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- TOC entry 6041 (class 2606 OID 16567)
-- Name: role_has_permissions role_has_permissions_permission_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.role_has_permissions
    ADD CONSTRAINT role_has_permissions_permission_id_foreign FOREIGN KEY (permission_id) REFERENCES public.permissions(id) ON DELETE CASCADE;


--
-- TOC entry 6042 (class 2606 OID 16572)
-- Name: role_has_permissions role_has_permissions_role_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.role_has_permissions
    ADD CONSTRAINT role_has_permissions_role_id_foreign FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;


--
-- TOC entry 6053 (class 2606 OID 16748)
-- Name: time_rates time_rates_zone_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.time_rates
    ADD CONSTRAINT time_rates_zone_id_foreign FOREIGN KEY (zone_id) REFERENCES public.zones(id) ON DELETE CASCADE;


-- Completed on 2026-03-27 18:58:10

--
--

\unrestrict PrlweEtpLqx2F0oeNsFpChFcwsH1gDKQ5OfkV4PZa2SA1dObfw5RGhfvRuHuWaw

