-- https://www.phpmyadmin.net/
--

START TRANSACTION;



-- --------------------------------------------------------

--
-- Table structure for table `account_default_job_rel`
--

CREATE TABLE `account_default_job_rel` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `default_job_idfk` int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `account_fields`
--

CREATE TABLE `account_fields` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(100) NOT NULL,
  `site_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `account_field_alias`
--

CREATE TABLE `account_field_alias` (
  `invoice_idfk` int(10) UNSIGNED NOT NULL,
  `field` varchar(50) NOT NULL,
  `alias` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `account_invoice_rel`
--

CREATE TABLE `account_invoice_rel` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `invoice_idfk` int(10) UNSIGNED NOT NULL,
  `site_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `account_super_admin`
--

CREATE TABLE `account_super_admin` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `invoice_account_idfk` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `advanced_settings_default`
--

CREATE TABLE `advanced_settings_default` (
  `acc_type` enum('user_create','admin_create') NOT NULL,
  `job_priority` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `max_active_jobs` int(10) UNSIGNED NOT NULL DEFAULT 10,
  `cancel_job` tinyint(1) NOT NULL DEFAULT 1,
  `allow_cash` tinyint(1) NOT NULL DEFAULT 1,
  `hold_jobs` tinyint(1) NOT NULL DEFAULT 0,
  `admin_user` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `advanced_settings_default`
--

INSERT INTO `advanced_settings_default` (`acc_type`, `job_priority`, `max_active_jobs`, `cancel_job`, `allow_cash`, `hold_jobs`, `admin_user`) VALUES
('user_create', 3, 10, 1, 0, 1, 0),
('admin_create', 3, 10, 1, 0, 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `airports`
--

CREATE TABLE `airports` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `short_code` varchar(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `airports`
--

INSERT INTO `airports` (`id`, `name`, `short_code`) VALUES
(1, 'Bally Kelly', 'BOL'),
(2, 'Barra North Bay', 'BRR'),
(3, 'Barrow-In-Furness Walney Island', 'BWF'),
(4, 'Belfast City Airport', 'BHD'),
(5, 'Belfast Aldergrove International', 'BFS'),
(6, 'Bembridge', 'BBP'),
(7, 'Benbecula', 'BEB'),
(8, 'Birmingham Colmore Row Bus Stn', 'ZBC'),
(9, 'Birmingham International', 'BHX'),
(10, 'Yateley Blackbushe', 'BBS'),
(11, 'Blackpool', 'BLK'),
(12, 'Bournemouth International', 'BOH'),
(13, 'Bradford', 'BRF'),
(14, 'Bradford Bus Station', 'ZFC'),
(15, 'Brighton', 'BSH'),
(16, 'Bristol', 'BRS'),
(17, 'London St. Pancras Britrail Rail Zone S', 'QQS'),
(18, 'Burtonwood', 'BUT'),
(19, 'Bury St Edmunds', 'BEQ'),
(20, 'Cambridge', 'CBG'),
(21, 'Campbeltown Machrihanish', 'CAL'),
(22, 'Cardiff', 'CWL'),
(23, 'Carlisle', 'CAX'),
(24, 'Chester', 'CEG'),
(25, 'Isle Of Coll', 'COL'),
(26, 'Isle Of Colonsay', 'CSA'),
(27, 'Coventry West Midlands International Airport', 'CVT'),
(28, 'Cromarty', 'CRN'),
(29, 'Dewsbury', 'ZEQ'),
(30, 'Doncaster Robin Hood International', 'DSA'),
(31, 'Dornoch', 'DOC'),
(32, 'Dundee', 'DND'),
(33, 'Durham Tees Valley', 'MME'),
(34, 'Eday', 'EOI'),
(35, 'Edinburgh Turnhouse', 'EDI'),
(36, 'Edinburgh ScotRail', 'ZXE'),
(37, 'Enniskillen', 'ENK'),
(38, 'Exeter', 'EXT'),
(39, 'Fair Isle', 'FIE'),
(40, 'Farnborough', 'FAB'),
(41, 'Fetlar', 'FEA'),
(42, 'Filton', 'FZO'),
(43, 'Flotta', 'FLH'),
(44, 'Forres Kinloss', 'FSS'),
(45, 'Foula', 'FOA'),
(46, 'Glasgow International', 'GLA'),
(47, 'Glasgow Prestwick', 'PIK'),
(48, 'Gloucester', 'GLO'),
(49, 'Grimsby Binbrook', 'GSY'),
(50, 'Guernsey', 'GCI'),
(51, 'Hammersmith Off Line Point', 'WUK'),
(52, 'Harrogate Linton-On-Ouse', 'HRT'),
(53, 'Hatfield', 'HTF'),
(54, 'Haverfordwest', 'HAW'),
(55, 'Hendon', 'HEN'),
(56, 'High Wycombe', 'HYC'),
(57, 'Holyhead', 'HLY'),
(58, 'Hoy Island', 'HOY'),
(59, 'Humberside', 'HUY'),
(60, 'Inverness', 'INV'),
(61, 'Islay Glenegedale', 'ILY'),
(62, 'Isle Of Man Ronaldsway', 'IOM'),
(63, 'Isle Of Skye Broadford', 'SKL'),
(64, 'Isles Of Scilly St Marys', 'ISC'),
(65, 'Isles Of Scilly Tresco', 'TSO'),
(66, 'Jersey', 'JER'),
(67, 'Lands End', 'LEQ'),
(68, 'Leeds Bradford Airport', 'LBA'),
(69, 'Liverpool John Lennon (Speke)', 'LPL'),
(70, 'Biggin Hill', 'BQH'),
(71, 'London Gatwick', 'LGW'),
(72, 'London Heathrow', 'LHR'),
(73, 'London City Airport', 'LCY'),
(74, 'London-Waterloo', 'QQW'),
(75, 'Luton', 'LTN'),
(76, 'London Stansted', 'STN'),
(77, 'Londonderry Eglinton', 'LDY'),
(78, 'Manchester', 'MAN'),
(79, 'Manston Kent International', 'MSE'),
(80, 'Mildenhall', 'MHZ'),
(81, 'Milton Keynes', 'KYN'),
(82, 'Mull', 'ULL'),
(83, 'Newcastle Airport', 'NCL'),
(84, 'Newquay St Mawgan', 'NQY'),
(85, 'North Ronaldsay', 'NRL'),
(86, 'Northampton', 'ORM'),
(87, 'Northolt', 'NHT'),
(88, 'Norwich Airport', 'NWI'),
(89, 'Nottingham Airport', 'NQT'),
(90, 'East Midlands Airport', 'EMA'),
(91, 'Oban', 'OBN'),
(92, 'Orkney Island', 'KOI'),
(93, 'Outer Skerries', 'OUK'),
(94, 'Oxford Kidlington', 'OXF'),
(95, 'Papa Stour', 'PSV'),
(96, 'Papa Westray', 'PPW'),
(97, 'Penzance', 'PZE'),
(98, 'Perth', 'PSL'),
(99, 'Plymouth', 'PLH'),
(100, 'Portsmouth', 'PME'),
(101, 'Rochester', 'RCS'),
(102, 'Sanday', 'NDY'),
(103, 'Sheffield City Airport', 'SZD'),
(104, 'Shetland Islands Lerwick/Tingwall', 'LWK'),
(105, 'Shetland Islands Scatsta', 'SCS'),
(106, 'Shetland Islands Sumburgh', 'LSI'),
(107, 'Shoreham By Sea', 'ESH'),
(108, 'Southampton Eastleigh', 'SOU'),
(109, 'Southend', 'SEN'),
(110, 'St Andrews Leuchars', 'ADX'),
(111, 'Stornoway', 'SYY'),
(112, 'Stronsay', 'SOY'),
(113, 'Swansea Fairwood Comm', 'SWS'),
(114, 'Swindon', 'SWI'),
(115, 'Tiree', 'TRE'),
(116, 'Shetland Baltasound', 'UNT'),
(117, 'Aberdeen', 'ABZ'),
(118, 'Alderney The Blaye', 'ACI'),
(119, 'Andover', 'ADV'),
(120, 'Yeovilton', 'YEO'),
(121, 'Woodford', 'WFD'),
(122, 'Woodbridge', 'BYW'),
(123, 'Wick', 'WIC'),
(124, 'Whalsay', 'WHS'),
(125, 'Westray', 'WRY'),
(126, 'West Malling', 'WEM'),
(127, 'Waddington', 'WTN'),
(128, 'Upavon', 'UPV');

-- --------------------------------------------------------

--
-- Table structure for table `airport_addresses`
--

CREATE TABLE `airport_addresses` (
  `id` int(10) UNSIGNED NOT NULL,
  `list_order` smallint(5) UNSIGNED NOT NULL,
  `address` text NOT NULL,
  `site_id` int(10) UNSIGNED NOT NULL,
  `widget` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `airport_email_extra`
--

CREATE TABLE `airport_email_extra` (
  `airport_idfk` int(10) UNSIGNED NOT NULL,
  `DATA` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `airport_widget_settings`
--

CREATE TABLE `airport_widget_settings` (
  `dispatch_idfk` int(10) UNSIGNED NOT NULL,
  `form_width` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `border_colour` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `background_colour` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `body_width` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `body_height` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `button_colour` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `button_text_colour` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `font_css_url` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `font_family` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `highlight_colour` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `header_image_url` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `header_image` tinyint(1) NOT NULL DEFAULT 1,
  `via` tinyint(1) NOT NULL DEFAULT 1,
  `booking_date` tinyint(1) NOT NULL DEFAULT 1,
  `pickup_address` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `success_text` varchar(1000) DEFAULT NULL,
  `success_image` varchar(500) DEFAULT NULL,
  `for_now` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `basic_colour_scheme`
--

CREATE TABLE `basic_colour_scheme` (
  `nav_bg` varchar(6) NOT NULL DEFAULT '333333',
  `nav_links` varchar(6) NOT NULL DEFAULT 'DC241F',
  `buttons` varchar(6) NOT NULL DEFAULT 'DC241F',
  `button_border` varchar(6) NOT NULL DEFAULT 'b23434',
  `secondary_button_colour` varchar(6) NOT NULL DEFAULT '4986E7',
  `secondary_button_border` varchar(6) NOT NULL DEFAULT '4986E7'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `basic_colour_scheme`
--

INSERT INTO `basic_colour_scheme` (`nav_bg`, `nav_links`, `buttons`, `button_border`, `secondary_button_colour`, `secondary_button_border`) VALUES
('333333', 'DC241F', 'DC241F', 'b23434', '4986E7', '4986E7');

-- --------------------------------------------------------

--
-- Table structure for table `basic_settings`
--

CREATE TABLE `basic_settings` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `booking_name` varchar(101) NOT NULL,
  `default_job` int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `booked_jobs`
--

CREATE TABLE `booked_jobs` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `booking_id` varchar(10) NOT NULL,
  `request_datetime` datetime NOT NULL,
  `booking_datetime` datetime NOT NULL,
  `booking_name` varchar(101) NOT NULL,
  `vehicle_type` varchar(10) NOT NULL DEFAULT 'R4',
  `booking_phone` varchar(15) NOT NULL,
  `booking_notes` varchar(256) DEFAULT NULL,
  `pickup` text NOT NULL,
  `dest` text DEFAULT NULL,
  `vias` text DEFAULT NULL,
  `flight_no` varchar(20) DEFAULT NULL,
  `return_journey` datetime DEFAULT NULL,
  `return_booking_id` varchar(10) DEFAULT NULL,
  `recurring` varchar(10) DEFAULT NULL,
  `no_cars` smallint(5) UNSIGNED NOT NULL DEFAULT 1,
  `status` varchar(15) NOT NULL DEFAULT 'NEW',
  `payment_type` enum('CASH','CARD','PAYPAL','INVOICE') NOT NULL DEFAULT 'CASH',
  `booking_source` varchar(20) NOT NULL DEFAULT 'WEB',
  `site_id` smallint(6) NOT NULL DEFAULT 0,
  `uuid` char(36) DEFAULT NULL,
  `email` varchar(256) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `booked_jobs_invoice_acc_number`
--

CREATE TABLE `booked_jobs_invoice_acc_number` (
  `job_idfk` int(10) UNSIGNED NOT NULL,
  `invoice_account_idfk` int(10) UNSIGNED NOT NULL,
  `fields` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `booked_jobs_price`
--

CREATE TABLE `booked_jobs_price` (
  `job_idfk` int(10) UNSIGNED NOT NULL,
  `price` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `booked_jobs_sub_account_rel`
--

CREATE TABLE `booked_jobs_sub_account_rel` (
  `booked_jobs_idfk` int(10) UNSIGNED NOT NULL,
  `sub_account_idfk` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `booking_archive_id`
--

CREATE TABLE `booking_archive_id` (
  `job_idfk` int(10) UNSIGNED NOT NULL,
  `archive_id` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `booking_email_log`
--

CREATE TABLE `booking_email_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `email_date` datetime NOT NULL,
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `sent_to` varchar(256) NOT NULL,
  `job_idfk` int(10) UNSIGNED NOT NULL,
  `sent` tinyint(1) NOT NULL,
  `exception` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `booking_idempotency_keys`
--

CREATE TABLE `booking_idempotency_keys` (
  `id` int(10) UNSIGNED NOT NULL,
  `expires` int(10) UNSIGNED NOT NULL,
  `uuid` varchar(36) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `booking_post_log`
--

CREATE TABLE `booking_post_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `request_datetime` datetime NOT NULL,
  `post` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `booking_request_log`
--

CREATE TABLE `booking_request_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `post_idfk` int(10) UNSIGNED NOT NULL,
  `request` text NOT NULL,
  `response` text DEFAULT NULL,
  `booking_id` varchar(12) DEFAULT NULL,
  `job_idfk` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `booking_templates`
--

CREATE TABLE `booking_templates` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `booking_template_fields`
--

CREATE TABLE `booking_template_fields` (
  `template_idfk` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `option_idfk` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `required` tinyint(1) NOT NULL DEFAULT 0,
  `label_alias` varchar(100) DEFAULT NULL,
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  `force_value` text DEFAULT NULL,
  `visible_mobile` tinyint(1) NOT NULL DEFAULT 1,
  `airport_only` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `booking_template_options`
--

CREATE TABLE `booking_template_options` (
  `id` int(10) UNSIGNED NOT NULL,
  `field_name` varchar(100) NOT NULL,
  `type` enum('toggle','text','select') NOT NULL DEFAULT 'toggle',
  `extra` varchar(20) DEFAULT NULL,
  `info` text DEFAULT NULL,
  `has_label` tinyint(1) NOT NULL DEFAULT 1,
  `airport_only_option` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `booking_zone_timeperiod`
--

CREATE TABLE `booking_zone_timeperiod` (
  `zone_timeperiod_idfk` int(10) UNSIGNED NOT NULL,
  `booking_idfk` int(10) UNSIGNED NOT NULL,
  `booked_date` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bulk_email_cache`
--

CREATE TABLE `bulk_email_cache` (
  `id` int(10) UNSIGNED NOT NULL,
  `sent_from` varchar(256) NOT NULL,
  `content` text NOT NULL,
  `email_title` varchar(256) DEFAULT NULL,
  `email_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sent` tinyint(1) NOT NULL DEFAULT 0,
  `email_replyto` varchar(256) NOT NULL,
  `exception` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cancel_log`
--

CREATE TABLE `cancel_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `type` enum('email','web') NOT NULL,
  `booking_id` int(10) UNSIGNED NOT NULL,
  `status` enum('VIEWED','CANCELLED','FAILED') DEFAULT NULL,
  `cancel_datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `card_payments`
--

CREATE TABLE `card_payments` (
  `id` int(10) UNSIGNED NOT NULL,
  `judo_payment_ref` varchar(256) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'requested',
  `currency` varchar(3) NOT NULL DEFAULT 'GBP',
  `price` varchar(10) NOT NULL DEFAULT '1.00',
  `receipt_id` varchar(50) DEFAULT NULL,
  `card_id` varchar(50) DEFAULT NULL,
  `refunded` varchar(10) NOT NULL DEFAULT '0.00',
  `post` text NOT NULL,
  `customer_ref` varchar(256) NOT NULL,
  `payment_ref` varchar(256) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `card_payments_booked_jobs`
--

CREATE TABLE `card_payments_booked_jobs` (
  `job_idfk` int(10) UNSIGNED NOT NULL,
  `payment_idfk` int(10) UNSIGNED NOT NULL,
  `type` enum('single','multi') DEFAULT NULL,
  `price` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `card_payment_options`
--

CREATE TABLE `card_payment_options` (
  `payment_service` enum('JudoPay') NOT NULL DEFAULT 'JudoPay',
  `post_max_distance` int(11) NOT NULL DEFAULT 0,
  `post_disabled` tinyint(1) NOT NULL DEFAULT 0,
  `require_dest` tinyint(1) NOT NULL DEFAULT 0,
  `default_type` enum('post','pre') NOT NULL DEFAULT 'post',
  `fixed_fare_which` enum('post','pre') NOT NULL DEFAULT 'post',
  `fixed_fare_max_post` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `card_types`
--

CREATE TABLE `card_types` (
  `site_id` int(10) UNSIGNED NOT NULL,
  `id` int(10) UNSIGNED NOT NULL,
  `ref` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'CARD',
  `service_charge` varchar(10) NOT NULL DEFAULT '0.00',
  `service_charge_type` varchar(15) NOT NULL DEFAULT 'PERCENTAGE',
  `min_service_charge` varchar(10) NOT NULL DEFAULT '0.00',
  `accountcard_id` int(10) UNSIGNED NOT NULL,
  `card_identifier` varchar(20) NOT NULL,
  `card_name` varchar(100) NOT NULL,
  `card_type` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cc_email_booking_rel`
--

CREATE TABLE `cc_email_booking_rel` (
  `job_idfk` int(10) UNSIGNED NOT NULL,
  `cc_email` varchar(256) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cc_email_rel`
--

CREATE TABLE `cc_email_rel` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `email_address` varchar(265) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cd_card_accounts`
--

CREATE TABLE `cd_card_accounts` (
  `visa_debit` int(10) UNSIGNED DEFAULT NULL,
  `visa_credit` int(10) UNSIGNED DEFAULT NULL,
  `master_debit` int(10) UNSIGNED DEFAULT NULL,
  `master_credit` int(10) UNSIGNED DEFAULT NULL,
  `american_express` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `central_address`
--

CREATE TABLE `central_address` (
  `site_id` int(10) UNSIGNED NOT NULL,
  `lat` varchar(20) NOT NULL,
  `lng` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `central_address`
--

INSERT INTO `central_address` (`site_id`, `lat`, `lng`) VALUES
(20, '53.3903472', '-1.5024744');

-- --------------------------------------------------------

--
-- Table structure for table `complete_bookings_time`
--

CREATE TABLE `complete_bookings_time` (
  `job_idfk` int(10) UNSIGNED NOT NULL,
  `arrive_date` datetime NOT NULL,
  `contact_date` datetime NOT NULL,
  `finish_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `credit_cards`
--

CREATE TABLE `credit_cards` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `card_id` int(10) UNSIGNED NOT NULL,
  `nickname` varchar(100) NOT NULL,
  `expiry` varchar(100) NOT NULL,
  `accountcard_id` int(10) UNSIGNED NOT NULL,
  `last_four` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `css_override`
--

CREATE TABLE `css_override` (
  `css` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `default_field_value`
--

CREATE TABLE `default_field_value` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `field_id` int(10) UNSIGNED NOT NULL,
  `value` varchar(100) NOT NULL,
  `invoice_idfk` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `default_jobs`
--

CREATE TABLE `default_jobs` (
  `id` int(10) UNSIGNED NOT NULL,
  `job_name` varchar(100) NOT NULL,
  `pickup_formatted` varchar(256) NOT NULL,
  `pickup_lat` double NOT NULL,
  `pickup_lng` double NOT NULL,
  `pickup_add_id` varchar(150) DEFAULT NULL,
  `dest_formatted` varchar(256) NOT NULL DEFAULT 'AS DIRECTED',
  `dest_lat` double DEFAULT NULL,
  `dest_lng` double DEFAULT NULL,
  `dest_add_id` varchar(150) DEFAULT NULL,
  `vias` text DEFAULT NULL,
  `notes` varchar(256) DEFAULT NULL,
  `phone` varchar(14) DEFAULT NULL,
  `booker_name` varchar(50) DEFAULT NULL,
  `job_type` varchar(20) DEFAULT NULL,
  `site_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `dispatch_system_judo_pay_rel`
--

CREATE TABLE `dispatch_system_judo_pay_rel` (
  `judo_idfk` int(10) UNSIGNED NOT NULL,
  `dispatch_system_idfk` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dispatch_system_judo_pay_rel`
--

INSERT INTO `dispatch_system_judo_pay_rel` (`judo_idfk`, `dispatch_system_idfk`) VALUES
(1, 20);

-- --------------------------------------------------------

--
-- Table structure for table `dispatch_system_stripe_rel`
--

CREATE TABLE `dispatch_system_stripe_rel` (
  `stripe_idfk` int(10) UNSIGNED NOT NULL,
  `dispatch_system_idfk` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `email_additional_content`
--

CREATE TABLE `email_additional_content` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(10) DEFAULT NULL,
  `DATA` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `email_additional_content`
--

INSERT INTO `email_additional_content` (`id`, `name`, `DATA`) VALUES
(1, 'welcome', '<h1 style=\"text-align: center;\"><p><br></p></h1>'),
(2, 'bottom', '<br>');

-- --------------------------------------------------------

--
-- Table structure for table `email_cache`
--

CREATE TABLE `email_cache` (
  `id` int(10) UNSIGNED NOT NULL,
  `send_to` text NOT NULL,
  `sent_from` varchar(256) NOT NULL,
  `content` text NOT NULL,
  `email_title` varchar(256) DEFAULT NULL,
  `email_datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sent` tinyint(1) NOT NULL DEFAULT 0,
  `account_idfk` int(10) UNSIGNED NOT NULL DEFAULT 3,
  `email_replyto` varchar(256) NOT NULL,
  `exception` text DEFAULT NULL,
  `type` varchar(20) NOT NULL,
  `reference` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `email_correspondence`
--

CREATE TABLE `email_correspondence` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `email_datetime` datetime NOT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `from_email` varchar(256) NOT NULL,
  `subject` varchar(256) NOT NULL,
  `sent_to` varchar(256) NOT NULL,
  `message` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `email_footers`
--

CREATE TABLE `email_footers` (
  `id` int(10) UNSIGNED NOT NULL,
  `site_id` int(10) UNSIGNED NOT NULL,
  `DATA` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `ext_bookings_cache`
--

CREATE TABLE `ext_bookings_cache` (
  `id` int(10) UNSIGNED NOT NULL,
  `site_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `facebook_deleted`
--

CREATE TABLE `facebook_deleted` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `deleted_timestamp` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `facebook_user_id`
--

CREATE TABLE `facebook_user_id` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `facebook_id` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `favicon_timestamp`
--

CREATE TABLE `favicon_timestamp` (
  `ts` int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `favourite_addresses`
--

CREATE TABLE `favourite_addresses` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `address` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `feedback_titles`
--

CREATE TABLE `feedback_titles` (
  `id` int(10) UNSIGNED NOT NULL,
  `description` varchar(256) NOT NULL,
  `email` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `google_addresses`
--

CREATE TABLE `google_addresses` (
  `place_id` varchar(100) NOT NULL,
  `formatted` varchar(300) NOT NULL,
  `area` varchar(100) NOT NULL DEFAULT 'Search Results',
  `lat` varchar(15) NOT NULL,
  `lng` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `google_maps_settings`
--

CREATE TABLE `google_maps_settings` (
  `backend_key` varchar(256) NOT NULL DEFAULT 'KEY',
  `enable_traffic` tinyint(1) NOT NULL DEFAULT 0,
  `site_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `google_maps_settings`
--

INSERT INTO `google_maps_settings` (`backend_key`, `enable_traffic`, `site_id`) VALUES
('AIzaSyAEGelSdt8SUwQs-i2Z8JX8SoLgKJJqpdA', 0, 20);

-- --------------------------------------------------------

--
-- Table structure for table `google_user_id`
--

CREATE TABLE `google_user_id` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `google_id` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `g_fonts`
--

CREATE TABLE `g_fonts` (
  `id` int(10) UNSIGNED NOT NULL,
  `font_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `history_page_access`
--

CREATE TABLE `history_page_access` (
  `account_idfk` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `icabbi_user_id`
--

CREATE TABLE `icabbi_user_id` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `site_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `judo_card_types`
--

CREATE TABLE `judo_card_types` (
  `card_type_id` int(11) NOT NULL,
  `card_type_name` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `judo_payment_charge`
--

CREATE TABLE `judo_payment_charge` (
  `request_idfk` int(10) UNSIGNED NOT NULL,
  `pre_post` enum('pre','post') NOT NULL DEFAULT 'post',
  `charge` varchar(10) DEFAULT NULL,
  `service_charge` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `judo_payment_request`
--

CREATE TABLE `judo_payment_request` (
  `id` int(10) UNSIGNED NOT NULL,
  `booking_post` text NOT NULL,
  `reference` varchar(100) DEFAULT NULL,
  `customer_ref` varchar(100) DEFAULT NULL,
  `job_idfk` int(10) UNSIGNED DEFAULT NULL,
  `receipt_id` varchar(50) DEFAULT NULL,
  `status` enum('requested','cancelled','booked','completed') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `logged_in_logs`
--

CREATE TABLE `logged_in_logs` (
  `id` int(10) UNSIGNED NOT NULL,
  `login_date` datetime NOT NULL,
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `ip_address` varchar(15) NOT NULL,
  `hostname` varchar(256) DEFAULT NULL,
  `who` enum('user','admin') NOT NULL DEFAULT 'user',
  `user_agent` varchar(500) NOT NULL DEFAULT 'UNKNOWN'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `logged_in_logs`
--

INSERT INTO `logged_in_logs` (`id`, `login_date`, `account_idfk`, `ip_address`, `hostname`, `who`, `user_agent`) VALUES
(1, '2024-11-05 10:13:25', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(2, '2024-11-05 13:49:13', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(3, '2024-11-05 13:50:00', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(4, '2024-11-05 13:50:30', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(5, '2024-11-05 14:04:56', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(6, '2024-11-05 14:27:11', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(7, '2024-11-05 14:33:57', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(8, '2024-11-05 14:35:02', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(9, '2024-11-05 14:35:39', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(10, '2024-11-05 14:36:23', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(11, '2024-11-05 14:39:03', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(12, '2024-11-05 14:39:31', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(13, '2024-11-05 14:44:19', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(14, '2024-11-05 14:47:26', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(15, '2024-11-05 14:47:58', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(16, '2024-11-05 14:48:20', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(17, '2024-11-05 14:49:17', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(18, '2024-11-05 14:51:24', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(19, '2024-11-05 14:51:41', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(20, '2024-11-06 05:56:59', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(21, '2024-11-06 09:55:59', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(22, '2024-11-07 06:39:15', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(23, '2024-11-07 11:34:36', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(24, '2024-11-11 10:26:24', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(25, '2024-11-11 10:29:56', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(26, '2024-11-11 10:50:31', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(27, '2024-11-11 11:08:31', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(28, '2024-11-11 11:31:05', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(29, '2024-11-11 12:00:53', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(30, '2024-11-11 12:02:16', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(31, '2024-11-11 12:50:17', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(32, '2024-11-11 12:52:07', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(33, '2024-11-12 13:19:59', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(34, '2024-11-12 13:22:39', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(35, '2024-11-12 14:04:02', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(36, '2024-11-12 14:21:35', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(37, '2024-11-12 14:22:20', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(38, '2024-11-12 14:23:06', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(39, '2024-11-12 14:25:48', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(40, '2024-11-12 14:37:44', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(41, '2024-11-12 14:55:50', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(42, '2024-11-13 06:50:00', 4, '::1', 'DESKTOP-N3229FR', 'user', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36');

-- --------------------------------------------------------

--
-- Table structure for table `marketing_preference`
--

CREATE TABLE `marketing_preference` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `marketing_preference`
--

INSERT INTO `marketing_preference` (`account_idfk`, `enabled`) VALUES
(4, 0);

-- --------------------------------------------------------

--
-- Table structure for table `meet_and_greet`
--

CREATE TABLE `meet_and_greet` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `short_code` varchar(5) DEFAULT NULL,
  `full` varchar(1000) NOT NULL,
  `site_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `must_change_password`
--

CREATE TABLE `must_change_password` (
  `account_idfk` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `notification_message`
--

CREATE TABLE `notification_message` (
  `site_id` int(10) UNSIGNED NOT NULL,
  `message` text DEFAULT NULL,
  `hours` smallint(5) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `old_identifiers`
--

CREATE TABLE `old_identifiers` (
  `invoice_idfk` int(10) UNSIGNED NOT NULL,
  `identifier` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `page_access_logs`
--

CREATE TABLE `page_access_logs` (
  `id` int(10) UNSIGNED NOT NULL,
  `access_date` datetime NOT NULL,
  `logged_idfk` int(10) UNSIGNED NOT NULL,
  `page_name` varchar(15) DEFAULT NULL,
  `page_file` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `page_access_logs`
--

INSERT INTO `page_access_logs` (`id`, `access_date`, `logged_idfk`, `page_name`, `page_file`) VALUES
(1, '2024-11-05 10:13:25', 1, 'book', '/dispatch/front-end/new-booking.php'),
(2, '2024-11-05 10:13:25', 1, 'book', '/dispatch/front-end/new-booking.php'),
(3, '2024-11-05 10:14:21', 1, 'book', '/dispatch/front-end/new-booking.php'),
(4, '2024-11-05 10:14:21', 1, 'book', '/dispatch/front-end/new-booking.php'),
(5, '2024-11-05 10:17:17', 1, 'book', '/dispatch/front-end/new-booking.php'),
(6, '2024-11-05 10:17:17', 1, 'book', '/dispatch/front-end/new-booking.php'),
(7, '2024-11-05 10:20:07', 1, 'book', '/dispatch/front-end/new-booking.php'),
(8, '2024-11-05 10:20:07', 1, 'book', '/dispatch/front-end/new-booking.php'),
(9, '2024-11-05 10:20:15', 1, 'book', '/dispatch/front-end/new-booking.php'),
(10, '2024-11-05 10:20:15', 1, 'book', '/dispatch/front-end/new-booking.php'),
(11, '2024-11-05 10:20:27', 1, 'book', '/dispatch/front-end/new-booking.php'),
(12, '2024-11-05 10:20:28', 1, 'book', '/dispatch/front-end/new-booking.php'),
(13, '2024-11-05 10:21:49', 1, 'book', '/dispatch/front-end/new-booking.php'),
(14, '2024-11-05 10:21:49', 1, 'book', '/dispatch/front-end/new-booking.php'),
(15, '2024-11-05 10:22:07', 1, 'book', '/dispatch/front-end/new-booking.php'),
(16, '2024-11-05 10:22:07', 1, 'book', '/dispatch/front-end/new-booking.php'),
(17, '2024-11-05 10:24:09', 1, 'book', '/dispatch/front-end/new-booking.php'),
(18, '2024-11-05 10:24:09', 1, 'book', '/dispatch/front-end/new-booking.php'),
(19, '2024-11-05 10:24:32', 1, 'book', '/dispatch/front-end/new-booking.php'),
(20, '2024-11-05 10:24:32', 1, 'book', '/dispatch/front-end/new-booking.php'),
(21, '2024-11-05 10:25:44', 1, 'book', '/dispatch/front-end/new-booking.php'),
(22, '2024-11-05 10:25:44', 1, 'book', '/dispatch/front-end/new-booking.php'),
(23, '2024-11-05 10:27:22', 1, 'book', '/dispatch/front-end/new-booking.php'),
(24, '2024-11-05 10:27:22', 1, 'book', '/dispatch/front-end/new-booking.php'),
(25, '2024-11-05 10:27:32', 1, 'book', '/dispatch/front-end/new-booking.php'),
(26, '2024-11-05 10:27:32', 1, 'book', '/dispatch/front-end/new-booking.php'),
(27, '2024-11-05 10:29:19', 1, 'book', '/dispatch/front-end/new-booking.php'),
(28, '2024-11-05 10:29:19', 1, 'book', '/dispatch/front-end/new-booking.php'),
(29, '2024-11-05 10:29:37', 1, 'book', '/dispatch/front-end/new-booking.php'),
(30, '2024-11-05 10:29:37', 1, 'book', '/dispatch/front-end/new-booking.php'),
(31, '2024-11-05 10:29:57', 1, 'book', '/dispatch/front-end/new-booking.php'),
(32, '2024-11-05 10:29:57', 1, 'book', '/dispatch/front-end/new-booking.php'),
(33, '2024-11-05 10:32:53', 1, 'book', '/dispatch/front-end/new-booking.php'),
(34, '2024-11-05 10:32:53', 1, 'book', '/dispatch/front-end/new-booking.php'),
(35, '2024-11-05 10:33:41', 1, 'book', '/dispatch/front-end/new-booking.php'),
(36, '2024-11-05 10:33:41', 1, 'book', '/dispatch/front-end/new-booking.php'),
(37, '2024-11-05 10:40:08', 1, 'book', '/dispatch/front-end/new-booking.php'),
(38, '2024-11-05 10:40:08', 1, 'book', '/dispatch/front-end/new-booking.php'),
(39, '2024-11-05 10:43:01', 1, 'book', '/dispatch/front-end/new-booking.php'),
(40, '2024-11-05 10:43:01', 1, 'book', '/dispatch/front-end/new-booking.php'),
(41, '2024-11-05 10:43:23', 1, 'book', '/dispatch/front-end/new-booking.php'),
(42, '2024-11-05 10:43:23', 1, 'book', '/dispatch/front-end/new-booking.php'),
(43, '2024-11-05 10:54:51', 1, 'book', '/dispatch/front-end/new-booking.php'),
(44, '2024-11-05 10:54:51', 1, 'book', '/dispatch/front-end/new-booking.php'),
(45, '2024-11-05 10:55:56', 1, 'book', '/dispatch/front-end/new-booking.php'),
(46, '2024-11-05 10:55:56', 1, 'book', '/dispatch/front-end/new-booking.php'),
(47, '2024-11-05 11:13:08', 1, 'book', '/dispatch/front-end/new-booking.php'),
(48, '2024-11-05 11:13:08', 1, 'book', '/dispatch/front-end/new-booking.php'),
(49, '2024-11-05 11:14:14', 1, 'book', '/dispatch/front-end/new-booking.php'),
(50, '2024-11-05 11:14:14', 1, 'book', '/dispatch/front-end/new-booking.php'),
(51, '2024-11-05 11:14:51', 1, 'book', '/dispatch/front-end/new-booking.php'),
(52, '2024-11-05 11:14:51', 1, 'book', '/dispatch/front-end/new-booking.php'),
(53, '2024-11-05 11:16:12', 1, 'book', '/dispatch/front-end/new-booking.php'),
(54, '2024-11-05 11:16:12', 1, 'book', '/dispatch/front-end/new-booking.php'),
(55, '2024-11-05 11:35:27', 1, 'status', '/dispatch/front-end/job-status.php'),
(56, '2024-11-05 11:35:27', 1, 'status', '/dispatch/front-end/job-status.php'),
(57, '2024-11-05 11:37:35', 1, 'history', '/dispatch/front-end/history.php'),
(58, '2024-11-05 11:37:35', 1, 'history', '/dispatch/front-end/history.php'),
(59, '2024-11-05 11:37:58', 1, 'history', '/dispatch/front-end/history.php'),
(60, '2024-11-05 11:37:58', 1, 'history', '/dispatch/front-end/history.php'),
(61, '2024-11-05 11:38:10', 1, 'history', '/dispatch/front-end/history.php'),
(62, '2024-11-05 11:38:10', 1, 'history', '/dispatch/front-end/history.php'),
(63, '2024-11-05 11:38:33', 1, 'book', '/dispatch/front-end/new-booking.php'),
(64, '2024-11-05 11:38:33', 1, 'book', '/dispatch/front-end/new-booking.php'),
(65, '2024-11-05 11:58:21', 1, 'book', '/dispatch/front-end/new-booking.php'),
(66, '2024-11-05 11:58:21', 1, 'book', '/dispatch/front-end/new-booking.php'),
(67, '2024-11-05 12:07:26', 1, 'book', '/dispatch/front-end/new-booking.php'),
(68, '2024-11-05 12:07:26', 1, 'book', '/dispatch/front-end/new-booking.php'),
(69, '2024-11-05 12:09:15', 1, 'book', '/dispatch/front-end/new-booking.php'),
(70, '2024-11-05 12:09:15', 1, 'book', '/dispatch/front-end/new-booking.php'),
(71, '2024-11-05 12:09:26', 1, 'status', '/dispatch/front-end/job-status.php'),
(72, '2024-11-05 12:09:26', 1, 'status', '/dispatch/front-end/job-status.php'),
(73, '2024-11-05 12:09:29', 1, 'history', '/dispatch/front-end/history.php'),
(74, '2024-11-05 12:09:29', 1, 'history', '/dispatch/front-end/history.php'),
(75, '2024-11-05 12:09:32', 1, 'profile', '/dispatch/front-end/profile.php'),
(76, '2024-11-05 12:09:32', 1, 'profile', '/dispatch/front-end/profile.php'),
(77, '2024-11-05 12:09:48', 1, 'profile', '/dispatch/front-end/profile.php'),
(78, '2024-11-05 12:09:48', 1, 'profile', '/dispatch/front-end/profile.php'),
(79, '2024-11-05 12:14:13', 1, 'profile', '/dispatch/front-end/profile.php'),
(80, '2024-11-05 12:14:13', 1, 'profile', '/dispatch/front-end/profile.php'),
(81, '2024-11-05 12:18:34', 1, 'profile', '/dispatch/front-end/profile.php'),
(82, '2024-11-05 12:18:34', 1, 'profile', '/dispatch/front-end/profile.php'),
(83, '2024-11-05 12:19:10', 1, 'profile', '/dispatch/front-end/profile.php'),
(84, '2024-11-05 12:19:10', 1, 'profile', '/dispatch/front-end/profile.php'),
(85, '2024-11-05 12:19:50', 1, 'profile', '/dispatch/front-end/profile.php'),
(86, '2024-11-05 12:19:50', 1, 'profile', '/dispatch/front-end/profile.php'),
(87, '2024-11-05 12:22:31', 1, 'profile', '/dispatch/front-end/profile.php'),
(88, '2024-11-05 12:22:31', 1, 'profile', '/dispatch/front-end/profile.php'),
(89, '2024-11-05 12:24:57', 1, 'profile', '/dispatch/front-end/profile.php'),
(90, '2024-11-05 12:24:57', 1, 'profile', '/dispatch/front-end/profile.php'),
(91, '2024-11-05 12:26:28', 1, 'profile', '/dispatch/front-end/profile.php'),
(92, '2024-11-05 12:26:28', 1, 'profile', '/dispatch/front-end/profile.php'),
(93, '2024-11-05 12:28:44', 1, 'profile', '/dispatch/front-end/profile.php'),
(94, '2024-11-05 12:28:44', 1, 'profile', '/dispatch/front-end/profile.php'),
(95, '2024-11-05 12:29:37', 1, 'profile', '/dispatch/front-end/profile.php'),
(96, '2024-11-05 12:29:37', 1, 'profile', '/dispatch/front-end/profile.php'),
(97, '2024-11-05 12:31:19', 1, 'profile', '/dispatch/front-end/profile.php'),
(98, '2024-11-05 12:31:19', 1, 'profile', '/dispatch/front-end/profile.php'),
(99, '2024-11-05 12:32:19', 1, 'profile', '/dispatch/front-end/profile.php'),
(100, '2024-11-05 12:32:19', 1, 'profile', '/dispatch/front-end/profile.php'),
(101, '2024-11-05 12:32:58', 1, 'profile', '/dispatch/front-end/profile.php'),
(102, '2024-11-05 12:32:58', 1, 'profile', '/dispatch/front-end/profile.php'),
(103, '2024-11-05 12:33:58', 1, 'profile', '/dispatch/front-end/profile.php'),
(104, '2024-11-05 12:33:58', 1, 'profile', '/dispatch/front-end/profile.php'),
(105, '2024-11-05 12:34:12', 1, 'profile', '/dispatch/front-end/profile.php'),
(106, '2024-11-05 12:34:12', 1, 'profile', '/dispatch/front-end/profile.php'),
(107, '2024-11-05 12:35:40', 1, 'history', '/dispatch/front-end/history.php'),
(108, '2024-11-05 12:35:40', 1, 'history', '/dispatch/front-end/history.php'),
(109, '2024-11-05 12:35:42', 1, 'status', '/dispatch/front-end/job-status.php'),
(110, '2024-11-05 12:35:42', 1, 'status', '/dispatch/front-end/job-status.php'),
(111, '2024-11-05 12:35:42', 1, 'book', '/dispatch/front-end/new-booking.php'),
(112, '2024-11-05 12:35:42', 1, 'book', '/dispatch/front-end/new-booking.php'),
(113, '2024-11-05 12:46:35', 1, 'book', '/dispatch/front-end/new-booking.php'),
(114, '2024-11-05 12:46:35', 1, 'book', '/dispatch/front-end/new-booking.php'),
(115, '2024-11-05 12:51:28', 1, 'book', '/dispatch/front-end/new-booking.php'),
(116, '2024-11-05 12:51:28', 1, 'book', '/dispatch/front-end/new-booking.php'),
(117, '2024-11-05 12:52:33', 1, 'book', '/dispatch/front-end/new-booking.php'),
(118, '2024-11-05 12:52:33', 1, 'book', '/dispatch/front-end/new-booking.php'),
(119, '2024-11-05 13:09:01', 1, 'book', '/dispatch/front-end/new-booking.php'),
(120, '2024-11-05 13:09:01', 1, 'book', '/dispatch/front-end/new-booking.php'),
(121, '2024-11-05 13:10:50', 1, 'book', '/dispatch/front-end/new-booking.php'),
(122, '2024-11-05 13:10:50', 1, 'book', '/dispatch/front-end/new-booking.php'),
(123, '2024-11-05 13:17:13', 1, 'book', '/dispatch/front-end/new-booking.php'),
(124, '2024-11-05 13:17:13', 1, 'book', '/dispatch/front-end/new-booking.php'),
(125, '2024-11-05 13:22:17', 1, 'book', '/dispatch/front-end/new-booking.php'),
(126, '2024-11-05 13:22:17', 1, 'book', '/dispatch/front-end/new-booking.php'),
(127, '2024-11-05 13:27:27', 1, 'book', '/dispatch/front-end/new-booking.php'),
(128, '2024-11-05 13:27:27', 1, 'book', '/dispatch/front-end/new-booking.php'),
(129, '2024-11-05 13:35:59', 1, 'book', '/dispatch/front-end/new-booking.php'),
(130, '2024-11-05 13:35:59', 1, 'book', '/dispatch/front-end/new-booking.php'),
(131, '2024-11-05 13:36:01', 1, 'status', '/dispatch/front-end/job-status.php'),
(132, '2024-11-05 13:36:01', 1, 'status', '/dispatch/front-end/job-status.php'),
(133, '2024-11-05 13:36:05', 1, 'book', '/dispatch/front-end/new-booking.php'),
(134, '2024-11-05 13:36:05', 1, 'book', '/dispatch/front-end/new-booking.php'),
(135, '2024-11-05 13:40:02', 1, 'book', '/dispatch/front-end/new-booking.php'),
(136, '2024-11-05 13:40:02', 1, 'book', '/dispatch/front-end/new-booking.php'),
(137, '2024-11-05 13:40:25', 1, 'book', '/dispatch/front-end/new-booking.php'),
(138, '2024-11-05 13:40:25', 1, 'book', '/dispatch/front-end/new-booking.php'),
(139, '2024-11-05 13:41:08', 1, 'status', '/dispatch/front-end/job-status.php'),
(140, '2024-11-05 13:41:08', 1, 'status', '/dispatch/front-end/job-status.php'),
(141, '2024-11-05 13:41:09', 1, 'history', '/dispatch/front-end/history.php'),
(142, '2024-11-05 13:41:09', 1, 'history', '/dispatch/front-end/history.php'),
(143, '2024-11-05 13:41:19', 1, 'history', '/dispatch/front-end/history.php'),
(144, '2024-11-05 13:41:19', 1, 'history', '/dispatch/front-end/history.php'),
(145, '2024-11-05 13:44:04', 1, 'book', '/dispatch/front-end/new-booking.php'),
(146, '2024-11-05 13:44:04', 1, 'book', '/dispatch/front-end/new-booking.php'),
(147, '2024-11-05 13:44:06', 1, 'status', '/dispatch/front-end/job-status.php'),
(148, '2024-11-05 13:44:06', 1, 'status', '/dispatch/front-end/job-status.php'),
(149, '2024-11-05 13:44:07', 1, 'history', '/dispatch/front-end/history.php'),
(150, '2024-11-05 13:44:07', 1, 'history', '/dispatch/front-end/history.php'),
(151, '2024-11-05 13:44:08', 1, 'profile', '/dispatch/front-end/profile.php'),
(152, '2024-11-05 13:44:08', 1, 'profile', '/dispatch/front-end/profile.php'),
(153, '2024-11-05 13:45:21', 1, 'profile', '/dispatch/front-end/profile.php'),
(154, '2024-11-05 13:45:21', 1, 'profile', '/dispatch/front-end/profile.php'),
(155, '2024-11-05 13:49:13', 2, 'book', '/dispatch/front-end/new-booking.php'),
(156, '2024-11-05 13:49:13', 2, 'book', '/dispatch/front-end/new-booking.php'),
(157, '2024-11-05 13:50:00', 3, 'book', '/dispatch/front-end/new-booking.php'),
(158, '2024-11-05 13:50:00', 3, 'book', '/dispatch/front-end/new-booking.php'),
(159, '2024-11-05 13:50:30', 4, 'book', '/dispatch/front-end/new-booking.php'),
(160, '2024-11-05 13:50:30', 4, 'book', '/dispatch/front-end/new-booking.php'),
(161, '2024-11-05 14:04:56', 5, 'book', '/dispatch/front-end/new-booking.php'),
(162, '2024-11-05 14:04:56', 5, 'book', '/dispatch/front-end/new-booking.php'),
(163, '2024-11-05 14:05:00', 5, 'book', '/dispatch/front-end/new-booking.php'),
(164, '2024-11-05 14:05:00', 5, 'book', '/dispatch/front-end/new-booking.php'),
(165, '2024-11-05 14:05:07', 5, 'history', '/dispatch/front-end/history.php'),
(166, '2024-11-05 14:05:07', 5, 'history', '/dispatch/front-end/history.php'),
(167, '2024-11-05 14:06:23', 5, 'history', '/dispatch/front-end/history.php'),
(168, '2024-11-05 14:06:23', 5, 'history', '/dispatch/front-end/history.php'),
(169, '2024-11-05 14:06:58', 5, 'history', '/dispatch/front-end/history.php'),
(170, '2024-11-05 14:06:58', 5, 'history', '/dispatch/front-end/history.php'),
(171, '2024-11-05 14:07:22', 5, 'history', '/dispatch/front-end/history.php'),
(172, '2024-11-05 14:07:22', 5, 'history', '/dispatch/front-end/history.php'),
(173, '2024-11-05 14:07:28', 5, 'book', '/dispatch/front-end/new-booking.php'),
(174, '2024-11-05 14:07:28', 5, 'book', '/dispatch/front-end/new-booking.php'),
(175, '2024-11-05 14:14:46', 5, 'book', '/dispatch/front-end/new-booking.php'),
(176, '2024-11-05 14:14:46', 5, 'book', '/dispatch/front-end/new-booking.php'),
(177, '2024-11-05 14:22:56', 5, 'book', '/dispatch/front-end/new-booking.php'),
(178, '2024-11-05 14:22:56', 5, 'book', '/dispatch/front-end/new-booking.php'),
(179, '2024-11-05 14:26:05', 5, 'status', '/dispatch/front-end/job-status.php'),
(180, '2024-11-05 14:26:05', 5, 'status', '/dispatch/front-end/job-status.php'),
(181, '2024-11-05 14:26:09', 5, 'history', '/dispatch/front-end/history.php'),
(182, '2024-11-05 14:26:09', 5, 'history', '/dispatch/front-end/history.php'),
(183, '2024-11-05 14:26:13', 5, 'profile', '/dispatch/front-end/profile.php'),
(184, '2024-11-05 14:26:13', 5, 'profile', '/dispatch/front-end/profile.php'),
(185, '2024-11-05 14:26:17', 5, 'book', '/dispatch/front-end/new-booking.php'),
(186, '2024-11-05 14:26:17', 5, 'book', '/dispatch/front-end/new-booking.php'),
(187, '2024-11-05 14:27:11', 6, 'book', '/dispatch/front-end/new-booking.php'),
(188, '2024-11-05 14:27:11', 6, 'book', '/dispatch/front-end/new-booking.php'),
(189, '2024-11-05 14:29:00', 6, 'book', '/dispatch/front-end/new-booking.php'),
(190, '2024-11-05 14:29:00', 6, 'book', '/dispatch/front-end/new-booking.php'),
(191, '2024-11-05 14:29:23', 6, 'book', '/dispatch/front-end/new-booking.php'),
(192, '2024-11-05 14:29:23', 6, 'book', '/dispatch/front-end/new-booking.php'),
(193, '2024-11-05 14:33:57', 7, 'book', '/dispatch/front-end/new-booking.php'),
(194, '2024-11-05 14:33:57', 7, 'book', '/dispatch/front-end/new-booking.php'),
(195, '2024-11-05 14:35:02', 8, 'book', '/dispatch/front-end/new-booking.php'),
(196, '2024-11-05 14:35:02', 8, 'book', '/dispatch/front-end/new-booking.php'),
(197, '2024-11-05 14:35:39', 9, 'book', '/dispatch/front-end/new-booking.php'),
(198, '2024-11-05 14:35:39', 9, 'book', '/dispatch/front-end/new-booking.php'),
(199, '2024-11-05 14:36:23', 10, 'book', '/dispatch/front-end/new-booking.php'),
(200, '2024-11-05 14:36:23', 10, 'book', '/dispatch/front-end/new-booking.php'),
(201, '2024-11-05 14:39:03', 11, 'book', '/dispatch/front-end/new-booking.php'),
(202, '2024-11-05 14:39:03', 11, 'book', '/dispatch/front-end/new-booking.php'),
(203, '2024-11-05 14:39:31', 12, 'book', '/dispatch/front-end/new-booking.php'),
(204, '2024-11-05 14:39:31', 12, 'book', '/dispatch/front-end/new-booking.php'),
(205, '2024-11-05 14:44:19', 13, 'book', '/dispatch/front-end/new-booking.php'),
(206, '2024-11-05 14:44:19', 13, 'book', '/dispatch/front-end/new-booking.php'),
(207, '2024-11-05 14:46:23', 13, 'book', '/dispatch/front-end/new-booking.php'),
(208, '2024-11-05 14:46:24', 13, 'book', '/dispatch/front-end/new-booking.php'),
(209, '2024-11-05 14:47:26', 14, 'book', '/dispatch/front-end/new-booking.php'),
(210, '2024-11-05 14:47:26', 14, 'book', '/dispatch/front-end/new-booking.php'),
(211, '2024-11-05 14:47:58', 15, 'book', '/dispatch/front-end/new-booking.php'),
(212, '2024-11-05 14:47:58', 15, 'book', '/dispatch/front-end/new-booking.php'),
(213, '2024-11-05 14:48:20', 16, 'book', '/dispatch/front-end/new-booking.php'),
(214, '2024-11-05 14:48:20', 16, 'book', '/dispatch/front-end/new-booking.php'),
(215, '2024-11-05 14:49:18', 17, 'book', '/dispatch/front-end/new-booking.php'),
(216, '2024-11-05 14:49:18', 17, 'book', '/dispatch/front-end/new-booking.php'),
(217, '2024-11-05 14:51:25', 18, 'book', '/dispatch/front-end/new-booking.php'),
(218, '2024-11-05 14:51:25', 18, 'book', '/dispatch/front-end/new-booking.php'),
(219, '2024-11-05 14:51:41', 19, 'book', '/dispatch/front-end/new-booking.php'),
(220, '2024-11-05 14:51:41', 19, 'book', '/dispatch/front-end/new-booking.php'),
(221, '2024-11-06 05:56:59', 20, 'book', '/dispatch/front-end/new-booking.php'),
(222, '2024-11-06 05:56:59', 20, 'book', '/dispatch/front-end/new-booking.php'),
(223, '2024-11-06 07:15:50', 20, 'book', '/dispatch/front-end/new-booking.php'),
(224, '2024-11-06 07:15:50', 20, 'book', '/dispatch/front-end/new-booking.php'),
(225, '2024-11-06 07:34:39', 20, 'book', '/dispatch/front-end/new-booking.php'),
(226, '2024-11-06 07:34:39', 20, 'book', '/dispatch/front-end/new-booking.php'),
(227, '2024-11-06 09:55:30', 20, 'book', '/dispatch/front-end/new-booking.php'),
(228, '2024-11-06 09:55:30', 20, 'book', '/dispatch/front-end/new-booking.php'),
(229, '2024-11-06 09:55:36', 20, 'status', '/dispatch/front-end/job-status.php'),
(230, '2024-11-06 09:55:36', 20, 'status', '/dispatch/front-end/job-status.php'),
(231, '2024-11-06 09:55:38', 20, 'history', '/dispatch/front-end/history.php'),
(232, '2024-11-06 09:55:38', 20, 'history', '/dispatch/front-end/history.php'),
(233, '2024-11-06 09:55:39', 20, 'profile', '/dispatch/front-end/profile.php'),
(234, '2024-11-06 09:55:39', 20, 'profile', '/dispatch/front-end/profile.php'),
(235, '2024-11-06 09:55:59', 21, 'book', '/dispatch/front-end/new-booking.php'),
(236, '2024-11-06 09:55:59', 21, 'book', '/dispatch/front-end/new-booking.php'),
(237, '2024-11-06 11:10:41', 21, 'status', '/dispatch/front-end/job-status.php'),
(238, '2024-11-06 11:10:41', 21, 'status', '/dispatch/front-end/job-status.php'),
(239, '2024-11-06 11:47:17', 21, 'profile', '/dispatch/front-end/profile.php'),
(240, '2024-11-06 11:47:17', 21, 'profile', '/dispatch/front-end/profile.php'),
(241, '2024-11-06 11:47:21', 21, 'book', '/dispatch/front-end/new-booking.php'),
(242, '2024-11-06 11:47:21', 21, 'book', '/dispatch/front-end/new-booking.php'),
(243, '2024-11-06 11:47:26', 21, 'status', '/dispatch/front-end/job-status.php'),
(244, '2024-11-06 11:47:27', 21, 'status', '/dispatch/front-end/job-status.php'),
(245, '2024-11-06 11:47:29', 21, 'book', '/dispatch/front-end/new-booking.php'),
(246, '2024-11-06 11:47:29', 21, 'book', '/dispatch/front-end/new-booking.php'),
(247, '2024-11-06 13:14:58', 21, 'book', '/dispatch/front-end/new-booking.php'),
(248, '2024-11-06 13:14:58', 21, 'book', '/dispatch/front-end/new-booking.php'),
(249, '2024-11-06 13:15:54', 21, 'status', '/dispatch/front-end/job-status.php'),
(250, '2024-11-06 13:15:54', 21, 'status', '/dispatch/front-end/job-status.php'),
(251, '2024-11-06 13:15:56', 21, 'history', '/dispatch/front-end/history.php'),
(252, '2024-11-06 13:15:56', 21, 'history', '/dispatch/front-end/history.php'),
(253, '2024-11-06 13:15:57', 21, 'profile', '/dispatch/front-end/profile.php'),
(254, '2024-11-06 13:15:57', 21, 'profile', '/dispatch/front-end/profile.php'),
(255, '2024-11-06 13:15:58', 21, 'history', '/dispatch/front-end/history.php'),
(256, '2024-11-06 13:15:58', 21, 'history', '/dispatch/front-end/history.php'),
(257, '2024-11-06 13:16:03', 21, 'profile', '/dispatch/front-end/profile.php'),
(258, '2024-11-06 13:16:03', 21, 'profile', '/dispatch/front-end/profile.php'),
(259, '2024-11-06 13:16:08', 21, 'book', '/dispatch/front-end/new-booking.php'),
(260, '2024-11-06 13:16:08', 21, 'book', '/dispatch/front-end/new-booking.php'),
(261, '2024-11-06 13:17:01', 21, 'book', '/dispatch/front-end/new-booking.php'),
(262, '2024-11-06 13:17:01', 21, 'book', '/dispatch/front-end/new-booking.php'),
(263, '2024-11-06 14:14:59', 21, 'book', '/dispatch/front-end/new-booking.php'),
(264, '2024-11-06 14:14:59', 21, 'book', '/dispatch/front-end/new-booking.php'),
(265, '2024-11-07 06:39:15', 22, 'book', '/dispatch/front-end/new-booking.php'),
(266, '2024-11-07 06:39:15', 22, 'book', '/dispatch/front-end/new-booking.php'),
(267, '2024-11-07 08:11:24', 22, 'book', '/dispatch/front-end/new-booking.php'),
(268, '2024-11-07 08:11:24', 22, 'book', '/dispatch/front-end/new-booking.php'),
(269, '2024-11-07 09:15:19', 22, 'book', '/dispatch/front-end/new-booking.php'),
(270, '2024-11-07 09:15:19', 22, 'book', '/dispatch/front-end/new-booking.php'),
(271, '2024-11-07 09:23:26', 22, 'book', '/dispatch/front-end/new-booking.php'),
(272, '2024-11-07 09:23:26', 22, 'book', '/dispatch/front-end/new-booking.php'),
(273, '2024-11-07 09:24:18', 22, 'book', '/dispatch/front-end/new-booking.php'),
(274, '2024-11-07 09:24:18', 22, 'book', '/dispatch/front-end/new-booking.php'),
(275, '2024-11-07 09:24:35', 22, 'book', '/dispatch/front-end/new-booking.php'),
(276, '2024-11-07 09:24:35', 22, 'book', '/dispatch/front-end/new-booking.php'),
(277, '2024-11-07 10:26:39', 22, 'history', '/dispatch/front-end/history.php'),
(278, '2024-11-07 10:26:39', 22, 'history', '/dispatch/front-end/history.php'),
(279, '2024-11-07 10:26:40', 22, 'book', '/dispatch/front-end/new-booking.php'),
(280, '2024-11-07 10:26:40', 22, 'book', '/dispatch/front-end/new-booking.php'),
(281, '2024-11-07 10:28:31', 22, 'status', '/dispatch/front-end/job-status.php'),
(282, '2024-11-07 10:28:31', 22, 'status', '/dispatch/front-end/job-status.php'),
(283, '2024-11-07 10:28:33', 22, 'profile', '/dispatch/front-end/profile.php'),
(284, '2024-11-07 10:28:33', 22, 'profile', '/dispatch/front-end/profile.php'),
(285, '2024-11-07 10:28:35', 22, 'book', '/dispatch/front-end/new-booking.php'),
(286, '2024-11-07 10:28:35', 22, 'book', '/dispatch/front-end/new-booking.php'),
(287, '2024-11-07 10:52:28', 22, 'book', '/dispatch/front-end/new-booking.php'),
(288, '2024-11-07 10:52:28', 22, 'book', '/dispatch/front-end/new-booking.php'),
(289, '2024-11-07 11:34:36', 23, 'book', '/dispatch/front-end/new-booking.php'),
(290, '2024-11-07 11:34:36', 23, 'book', '/dispatch/front-end/new-booking.php'),
(291, '2024-11-07 14:07:40', 23, 'book', '/dispatch/front-end/new-booking.php'),
(292, '2024-11-07 14:07:40', 23, 'book', '/dispatch/front-end/new-booking.php'),
(293, '2024-11-07 14:07:44', 23, 'status', '/dispatch/front-end/job-status.php'),
(294, '2024-11-07 14:07:44', 23, 'status', '/dispatch/front-end/job-status.php'),
(295, '2024-11-07 14:07:45', 23, 'book', '/dispatch/front-end/new-booking.php'),
(296, '2024-11-07 14:07:45', 23, 'book', '/dispatch/front-end/new-booking.php'),
(297, '2024-11-11 10:26:24', 24, 'book', '/dispatch/front-end/new-booking.php'),
(298, '2024-11-11 10:26:24', 24, 'book', '/dispatch/front-end/new-booking.php'),
(299, '2024-11-11 10:29:56', 25, 'book', '/dispatch/front-end/new-booking.php'),
(300, '2024-11-11 10:29:56', 25, 'book', '/dispatch/front-end/new-booking.php'),
(301, '2024-11-11 10:50:31', 26, 'book', '/dispatch/front-end/new-booking.php'),
(302, '2024-11-11 10:50:31', 26, 'book', '/dispatch/front-end/new-booking.php'),
(303, '2024-11-11 11:08:31', 27, 'book', '/dispatch/front-end/new-booking.php'),
(304, '2024-11-11 11:08:31', 27, 'book', '/dispatch/front-end/new-booking.php'),
(305, '2024-11-11 11:09:16', 27, 'book', '/dispatch/front-end/new-booking.php'),
(306, '2024-11-11 11:09:16', 27, 'book', '/dispatch/front-end/new-booking.php'),
(307, '2024-11-11 11:09:20', 27, 'status', '/dispatch/front-end/job-status.php'),
(308, '2024-11-11 11:09:20', 27, 'status', '/dispatch/front-end/job-status.php'),
(309, '2024-11-11 11:09:22', 27, 'book', '/dispatch/front-end/new-booking.php'),
(310, '2024-11-11 11:09:22', 27, 'book', '/dispatch/front-end/new-booking.php'),
(311, '2024-11-11 11:09:48', 27, 'book', '/dispatch/front-end/new-booking.php'),
(312, '2024-11-11 11:09:48', 27, 'book', '/dispatch/front-end/new-booking.php'),
(313, '2024-11-11 11:31:05', 28, 'book', '/dispatch/front-end/new-booking.php'),
(314, '2024-11-11 11:31:05', 28, 'book', '/dispatch/front-end/new-booking.php'),
(315, '2024-11-11 11:31:07', 28, 'status', '/dispatch/front-end/job-status.php'),
(316, '2024-11-11 11:31:07', 28, 'status', '/dispatch/front-end/job-status.php'),
(317, '2024-11-11 11:31:10', 28, 'book', '/dispatch/front-end/new-booking.php'),
(318, '2024-11-11 11:31:10', 28, 'book', '/dispatch/front-end/new-booking.php'),
(319, '2024-11-11 11:31:58', 28, 'book', '/dispatch/front-end/new-booking.php'),
(320, '2024-11-11 11:31:58', 28, 'book', '/dispatch/front-end/new-booking.php'),
(321, '2024-11-11 11:32:00', 28, 'status', '/dispatch/front-end/job-status.php'),
(322, '2024-11-11 11:32:00', 28, 'status', '/dispatch/front-end/job-status.php'),
(323, '2024-11-11 11:33:58', 28, 'status', '/dispatch/front-end/job-status.php'),
(324, '2024-11-11 11:33:58', 28, 'status', '/dispatch/front-end/job-status.php'),
(325, '2024-11-11 11:34:38', 28, 'status', '/dispatch/front-end/job-status.php'),
(326, '2024-11-11 11:34:38', 28, 'status', '/dispatch/front-end/job-status.php'),
(327, '2024-11-11 11:34:48', 28, 'history', '/dispatch/front-end/history.php'),
(328, '2024-11-11 11:34:48', 28, 'history', '/dispatch/front-end/history.php'),
(329, '2024-11-11 11:35:29', 28, 'history', '/dispatch/front-end/history.php'),
(330, '2024-11-11 11:35:29', 28, 'history', '/dispatch/front-end/history.php'),
(331, '2024-11-11 11:35:40', 28, 'profile', '/dispatch/front-end/profile.php'),
(332, '2024-11-11 11:35:40', 28, 'profile', '/dispatch/front-end/profile.php'),
(333, '2024-11-11 11:36:27', 28, 'profile', '/dispatch/front-end/profile.php'),
(334, '2024-11-11 11:36:27', 28, 'profile', '/dispatch/front-end/profile.php'),
(335, '2024-11-11 12:00:53', 29, 'book', '/dispatch/front-end/new-booking.php'),
(336, '2024-11-11 12:00:53', 29, 'book', '/dispatch/front-end/new-booking.php'),
(337, '2024-11-11 12:02:16', 30, 'book', '/dispatch/front-end/new-booking.php'),
(338, '2024-11-11 12:02:16', 30, 'book', '/dispatch/front-end/new-booking.php'),
(339, '2024-11-11 12:02:18', 30, 'status', '/dispatch/front-end/job-status.php'),
(340, '2024-11-11 12:02:18', 30, 'status', '/dispatch/front-end/job-status.php'),
(341, '2024-11-11 12:02:20', 30, 'book', '/dispatch/front-end/new-booking.php'),
(342, '2024-11-11 12:02:20', 30, 'book', '/dispatch/front-end/new-booking.php'),
(343, '2024-11-11 12:02:23', 30, 'history', '/dispatch/front-end/history.php'),
(344, '2024-11-11 12:02:23', 30, 'history', '/dispatch/front-end/history.php'),
(345, '2024-11-11 12:02:25', 30, 'profile', '/dispatch/front-end/profile.php'),
(346, '2024-11-11 12:02:25', 30, 'profile', '/dispatch/front-end/profile.php'),
(347, '2024-11-11 12:02:26', 30, 'book', '/dispatch/front-end/new-booking.php'),
(348, '2024-11-11 12:02:26', 30, 'book', '/dispatch/front-end/new-booking.php'),
(349, '2024-11-11 12:50:17', 31, 'book', '/dispatch/front-end/new-booking.php'),
(350, '2024-11-11 12:50:17', 31, 'book', '/dispatch/front-end/new-booking.php'),
(351, '2024-11-11 12:52:08', 32, 'book', '/dispatch/front-end/new-booking.php'),
(352, '2024-11-11 12:52:08', 32, 'book', '/dispatch/front-end/new-booking.php'),
(353, '2024-11-12 13:19:59', 33, 'book', '/dispatch/front-end/new-booking.php'),
(354, '2024-11-12 13:19:59', 33, 'book', '/dispatch/front-end/new-booking.php'),
(355, '2024-11-12 13:20:40', 33, 'book', '/dispatch/front-end/new-booking.php'),
(356, '2024-11-12 13:20:40', 33, 'book', '/dispatch/front-end/new-booking.php'),
(357, '2024-11-12 13:20:52', 33, 'book', '/dispatch/front-end/new-booking.php'),
(358, '2024-11-12 13:20:52', 33, 'book', '/dispatch/front-end/new-booking.php'),
(359, '2024-11-12 13:21:12', 33, 'book', '/dispatch/front-end/new-booking.php'),
(360, '2024-11-12 13:21:12', 33, 'book', '/dispatch/front-end/new-booking.php'),
(361, '2024-11-12 13:22:01', 33, 'book', '/dispatch/front-end/new-booking.php'),
(362, '2024-11-12 13:22:01', 33, 'book', '/dispatch/front-end/new-booking.php'),
(363, '2024-11-12 13:22:40', 34, 'book', '/dispatch/front-end/new-booking.php'),
(364, '2024-11-12 13:22:40', 34, 'book', '/dispatch/front-end/new-booking.php'),
(365, '2024-11-12 13:23:31', 34, 'book', '/dispatch/front-end/new-booking.php'),
(366, '2024-11-12 13:23:31', 34, 'book', '/dispatch/front-end/new-booking.php'),
(367, '2024-11-12 13:24:06', 34, 'book', '/dispatch/front-end/new-booking.php'),
(368, '2024-11-12 13:24:06', 34, 'book', '/dispatch/front-end/new-booking.php'),
(369, '2024-11-12 13:25:31', 34, 'status', '/dispatch/front-end/job-status.php'),
(370, '2024-11-12 13:25:31', 34, 'status', '/dispatch/front-end/job-status.php'),
(371, '2024-11-12 13:25:33', 34, 'history', '/dispatch/front-end/history.php'),
(372, '2024-11-12 13:25:33', 34, 'history', '/dispatch/front-end/history.php'),
(373, '2024-11-12 13:25:35', 34, 'profile', '/dispatch/front-end/profile.php'),
(374, '2024-11-12 13:25:35', 34, 'profile', '/dispatch/front-end/profile.php'),
(375, '2024-11-12 14:04:02', 35, 'book', '/dispatch/front-end/new-booking.php'),
(376, '2024-11-12 14:04:02', 35, 'book', '/dispatch/front-end/new-booking.php'),
(377, '2024-11-12 14:04:39', 35, 'profile', '/dispatch/front-end/profile.php'),
(378, '2024-11-12 14:04:39', 35, 'profile', '/dispatch/front-end/profile.php'),
(379, '2024-11-12 14:04:55', 35, 'profile', '/dispatch/front-end/profile.php'),
(380, '2024-11-12 14:04:55', 35, 'profile', '/dispatch/front-end/profile.php'),
(381, '2024-11-12 14:05:26', 35, 'profile', '/dispatch/front-end/profile.php'),
(382, '2024-11-12 14:05:26', 35, 'profile', '/dispatch/front-end/profile.php'),
(383, '2024-11-12 14:05:42', 35, 'profile', '/dispatch/front-end/profile.php'),
(384, '2024-11-12 14:05:42', 35, 'profile', '/dispatch/front-end/profile.php'),
(385, '2024-11-12 14:08:48', 35, 'profile', '/dispatch/front-end/profile.php'),
(386, '2024-11-12 14:08:48', 35, 'profile', '/dispatch/front-end/profile.php'),
(387, '2024-11-12 14:09:02', 35, 'profile', '/dispatch/front-end/profile.php'),
(388, '2024-11-12 14:09:02', 35, 'profile', '/dispatch/front-end/profile.php'),
(389, '2024-11-12 14:09:27', 35, 'profile', '/dispatch/front-end/profile.php'),
(390, '2024-11-12 14:09:27', 35, 'profile', '/dispatch/front-end/profile.php'),
(391, '2024-11-12 14:09:35', 35, 'profile', '/dispatch/front-end/profile.php'),
(392, '2024-11-12 14:09:35', 35, 'profile', '/dispatch/front-end/profile.php'),
(393, '2024-11-12 14:11:43', 35, 'profile', '/dispatch/front-end/profile.php'),
(394, '2024-11-12 14:11:43', 35, 'profile', '/dispatch/front-end/profile.php'),
(395, '2024-11-12 14:12:44', 35, 'profile', '/dispatch/front-end/profile.php'),
(396, '2024-11-12 14:12:44', 35, 'profile', '/dispatch/front-end/profile.php'),
(397, '2024-11-12 14:13:01', 35, 'profile', '/dispatch/front-end/profile.php'),
(398, '2024-11-12 14:13:01', 35, 'profile', '/dispatch/front-end/profile.php'),
(399, '2024-11-12 14:13:41', 35, 'profile', '/dispatch/front-end/profile.php'),
(400, '2024-11-12 14:13:41', 35, 'profile', '/dispatch/front-end/profile.php'),
(401, '2024-11-12 14:13:49', 35, 'profile', '/dispatch/front-end/profile.php'),
(402, '2024-11-12 14:13:49', 35, 'profile', '/dispatch/front-end/profile.php'),
(403, '2024-11-12 14:13:56', 35, 'profile', '/dispatch/front-end/profile.php'),
(404, '2024-11-12 14:13:56', 35, 'profile', '/dispatch/front-end/profile.php'),
(405, '2024-11-12 14:14:32', 35, 'profile', '/dispatch/front-end/profile.php'),
(406, '2024-11-12 14:14:32', 35, 'profile', '/dispatch/front-end/profile.php'),
(407, '2024-11-12 14:14:42', 35, 'profile', '/dispatch/front-end/profile.php'),
(408, '2024-11-12 14:14:42', 35, 'profile', '/dispatch/front-end/profile.php'),
(409, '2024-11-12 14:15:20', 35, 'profile', '/dispatch/front-end/profile.php'),
(410, '2024-11-12 14:15:20', 35, 'profile', '/dispatch/front-end/profile.php'),
(411, '2024-11-12 14:15:37', 35, 'profile', '/dispatch/front-end/profile.php'),
(412, '2024-11-12 14:15:37', 35, 'profile', '/dispatch/front-end/profile.php'),
(413, '2024-11-12 14:17:35', 35, 'profile', '/dispatch/front-end/profile.php'),
(414, '2024-11-12 14:17:35', 35, 'profile', '/dispatch/front-end/profile.php'),
(415, '2024-11-12 14:18:17', 35, 'profile', '/dispatch/front-end/profile.php'),
(416, '2024-11-12 14:18:17', 35, 'profile', '/dispatch/front-end/profile.php'),
(417, '2024-11-12 14:18:59', 35, 'profile', '/dispatch/front-end/profile.php'),
(418, '2024-11-12 14:18:59', 35, 'profile', '/dispatch/front-end/profile.php'),
(419, '2024-11-12 14:19:05', 35, 'history', '/dispatch/front-end/history.php'),
(420, '2024-11-12 14:19:05', 35, 'history', '/dispatch/front-end/history.php'),
(421, '2024-11-12 14:19:13', 35, 'book', '/dispatch/front-end/new-booking.php'),
(422, '2024-11-12 14:19:13', 35, 'book', '/dispatch/front-end/new-booking.php'),
(423, '2024-11-12 14:19:19', 35, 'status', '/dispatch/front-end/job-status.php'),
(424, '2024-11-12 14:19:19', 35, 'status', '/dispatch/front-end/job-status.php'),
(425, '2024-11-12 14:21:35', 36, 'book', '/dispatch/front-end/new-booking.php'),
(426, '2024-11-12 14:21:35', 36, 'book', '/dispatch/front-end/new-booking.php'),
(427, '2024-11-12 14:22:20', 37, 'book', '/dispatch/front-end/new-booking.php'),
(428, '2024-11-12 14:22:20', 37, 'book', '/dispatch/front-end/new-booking.php'),
(429, '2024-11-12 14:23:06', 38, 'book', '/dispatch/front-end/new-booking.php'),
(430, '2024-11-12 14:23:06', 38, 'book', '/dispatch/front-end/new-booking.php'),
(431, '2024-11-12 14:25:48', 39, 'book', '/dispatch/front-end/new-booking.php'),
(432, '2024-11-12 14:25:48', 39, 'book', '/dispatch/front-end/new-booking.php'),
(433, '2024-11-12 14:37:44', 40, 'book', '/dispatch/front-end/new-booking.php'),
(434, '2024-11-12 14:37:44', 40, 'book', '/dispatch/front-end/new-booking.php'),
(435, '2024-11-12 14:38:02', 40, 'book', '/dispatch/front-end/new-booking.php'),
(436, '2024-11-12 14:38:02', 40, 'book', '/dispatch/front-end/new-booking.php'),
(437, '2024-11-12 14:38:12', 40, 'book', '/dispatch/front-end/new-booking.php'),
(438, '2024-11-12 14:38:12', 40, 'book', '/dispatch/front-end/new-booking.php'),
(439, '2024-11-12 14:55:50', 41, 'book', '/dispatch/front-end/new-booking.php'),
(440, '2024-11-12 14:55:50', 41, 'book', '/dispatch/front-end/new-booking.php'),
(441, '2024-11-13 06:50:00', 42, 'book', '/dispatch/front-end/new-booking.php'),
(442, '2024-11-13 06:50:00', 42, 'book', '/dispatch/front-end/new-booking.php');

-- --------------------------------------------------------

--
-- Table structure for table `page_names`
--

CREATE TABLE `page_names` (
  `file_name` varchar(30) NOT NULL,
  `link_name` varchar(34) NOT NULL,
  `has_nav` tinyint(1) NOT NULL DEFAULT 1,
  `nav_label` varchar(50) DEFAULT NULL,
  `has_title` tinyint(1) NOT NULL DEFAULT 1,
  `page_title` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `page_names`
--

INSERT INTO `page_names` (`file_name`, `link_name`, `has_nav`, `nav_label`, `has_title`, `page_title`) VALUES
('track.php', 'track', 0, 'NULL', 1, 'Track My Taxi');

-- --------------------------------------------------------

--
-- Table structure for table `past_addresses`
--

CREATE TABLE `past_addresses` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `address_id` varchar(512) NOT NULL,
  `address` varchar(500) NOT NULL,
  `pickup` int(11) NOT NULL DEFAULT 0,
  `destination` int(11) NOT NULL DEFAULT 0,
  `dispatch_idfk` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `payment_types`
--

CREATE TABLE `payment_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` enum('cash','card','paypal','invoice') DEFAULT NULL,
  `label` varchar(20) DEFAULT NULL,
  `disabled` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `payment_type_template_rel`
--

CREATE TABLE `payment_type_template_rel` (
  `payment_type_idfk` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `template_idfk` int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `popular_addresses`
--

CREATE TABLE `popular_addresses` (
  `id` int(10) UNSIGNED NOT NULL,
  `list_order` smallint(5) UNSIGNED NOT NULL,
  `address` text NOT NULL,
  `site_id` int(10) UNSIGNED NOT NULL,
  `widget` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `quick_book_settings`
--

CREATE TABLE `quick_book_settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `template_idfk` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `use_captcha` tinyint(1) NOT NULL DEFAULT 1,
  `tag_line` text DEFAULT NULL,
  `css` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `repeat_bookings`
--

CREATE TABLE `repeat_bookings` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `site_id` int(10) UNSIGNED NOT NULL,
  `booking` text DEFAULT NULL,
  `repeat_days` text DEFAULT NULL,
  `repeat_until` datetime NOT NULL,
  `repeat_from` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `repeat_bookings_rel`
--

CREATE TABLE `repeat_bookings_rel` (
  `repeat_idfk` int(10) UNSIGNED NOT NULL,
  `booking_idfk` int(10) UNSIGNED NOT NULL,
  `booking_datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `return_booking_rel`
--

CREATE TABLE `return_booking_rel` (
  `job_idfk` int(10) UNSIGNED NOT NULL,
  `return_job_idfk` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `return_discount`
--

CREATE TABLE `return_discount` (
  `id` int(10) UNSIGNED NOT NULL,
  `discount` varchar(3) NOT NULL,
  `site_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sagepay_accounts`
--

CREATE TABLE `sagepay_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_name` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `live` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sage_booking_cache`
--

CREATE TABLE `sage_booking_cache` (
  `id` int(10) UNSIGNED NOT NULL,
  `transaction_id` varchar(100) NOT NULL,
  `account_idfk` int(10) UNSIGNED NOT NULL DEFAULT 3,
  `email` text NOT NULL,
  `booking_name` varchar(256) DEFAULT NULL,
  `booking` text NOT NULL,
  `post` text NOT NULL,
  `booking_id` int(10) UNSIGNED DEFAULT NULL,
  `sage_received` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sage_redirect_post_log`
--

CREATE TABLE `sage_redirect_post_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `request_datetime` datetime DEFAULT NULL,
  `session` text DEFAULT NULL,
  `post` text DEFAULT NULL,
  `server` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `site_sage_rel`
--

CREATE TABLE `site_sage_rel` (
  `site_idfk` int(10) UNSIGNED NOT NULL,
  `sage_idfk` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `site_sage_rel`
--

INSERT INTO `site_sage_rel` (`site_idfk`, `sage_idfk`) VALUES
(20, 10);

-- --------------------------------------------------------

--
-- Table structure for table `sub_accounts`
--

CREATE TABLE `sub_accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(50) NOT NULL,
  `reference` varchar(50) NOT NULL,
  `colour` varchar(7) NOT NULL,
  `disabled` tinyint(1) NOT NULL DEFAULT 0,
  `invoice_idfk` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sub_account_labels`
--

CREATE TABLE `sub_account_labels` (
  `invoice_idfk` int(10) UNSIGNED NOT NULL,
  `singular` varchar(30) NOT NULL,
  `plural` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sub_account_labels`
--

INSERT INTO `sub_account_labels` (`invoice_idfk`, `singular`, `plural`) VALUES
(9181, 'Department', 'Departments');

-- --------------------------------------------------------

--
-- Table structure for table `sub_account_reference_field`
--

CREATE TABLE `sub_account_reference_field` (
  `invoice_account_idfk` int(10) UNSIGNED NOT NULL,
  `field_name` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sub_account_users`
--

CREATE TABLE `sub_account_users` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `sub_account_idfk` int(10) UNSIGNED NOT NULL,
  `flags` smallint(6) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `system_addresses`
--

CREATE TABLE `system_addresses` (
  `id` int(10) UNSIGNED NOT NULL,
  `list_order` smallint(5) UNSIGNED NOT NULL,
  `address` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `site_id` int(10) UNSIGNED NOT NULL,
  `widget` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `system_addresses_config`
--

CREATE TABLE `system_addresses_config` (
  `site_id` int(10) UNSIGNED NOT NULL,
  `expires` bigint(20) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `system_default_styles`
--

CREATE TABLE `system_default_styles` (
  `button_background` varchar(7) DEFAULT NULL,
  `button_text` varchar(7) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `system_default_styles`
--

INSERT INTO `system_default_styles` (`button_background`, `button_text`) VALUES
('#f28c19', '#333333');

-- --------------------------------------------------------

--
-- Table structure for table `this_firm`
--

CREATE TABLE `this_firm` (
  `long_name` varchar(150) NOT NULL,
  `short_name` varchar(100) NOT NULL,
  `logo_url` varchar(200) DEFAULT NULL,
  `copyright_notice` varchar(150) DEFAULT NULL,
  `phonenumber` varchar(15) NOT NULL,
  `website_url` varchar(256) DEFAULT NULL,
  `webbooker_url` varchar(256) DEFAULT NULL,
  `firm_idfk` smallint(6) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `this_firm`
--

INSERT INTO `this_firm` (`long_name`, `short_name`, `logo_url`, `copyright_notice`, `phonenumber`, `website_url`, `webbooker_url`, `firm_idfk`) VALUES
('Arrow Cars', 'Arrow Cars', NULL, 'Nova Rides Ltd T/A Arrow Cars', '01132585888', 'http://localhost/dispatch/frontend', 'http://localhost/dispatch/frontend', 1);

-- --------------------------------------------------------

--
-- Table structure for table `timeperiods`
--

CREATE TABLE `timeperiods` (
  `id` int(10) UNSIGNED NOT NULL,
  `start` varchar(8) NOT NULL,
  `end` varchar(8) NOT NULL,
  `days` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `precedence` smallint(5) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tracking`
--

CREATE TABLE `tracking` (
  `google_tag_manager` varchar(20) DEFAULT NULL,
  `facebook_conversions` varchar(30) DEFAULT NULL,
  `admaxim` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tracking`
--

INSERT INTO `tracking` (`google_tag_manager`, `facebook_conversions`, `admaxim`) VALUES
(NULL, NULL, 0);

-- --------------------------------------------------------

--
-- Table structure for table `user_central_address`
--

CREATE TABLE `user_central_address` (
  `account_idfk` int(10) UNSIGNED NOT NULL,
  `lat` varchar(20) NOT NULL,
  `lng` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `vehicle_types`
--

CREATE TABLE `vehicle_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `icabbi_id` int(10) UNSIGNED NOT NULL,
  `key_name` varchar(4) DEFAULT NULL,
  `title` varchar(50) DEFAULT NULL,
  `seats` smallint(6) DEFAULT NULL,
  `wheelchair` tinyint(1) DEFAULT NULL,
  `executive` tinyint(1) DEFAULT NULL,
  `saloon` tinyint(1) DEFAULT NULL,
  `luggage` smallint(6) DEFAULT NULL,
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  `display_order` smallint(5) UNSIGNED NOT NULL DEFAULT 1,
  `site_id` int(10) UNSIGNED NOT NULL,
  `large_luggage` smallint(6) NOT NULL DEFAULT 0,
  `image_file` varchar(256) DEFAULT NULL,
  `small_luggage` smallint(6) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `zones`
--

CREATE TABLE `zones` (
  `id` int(10) UNSIGNED NOT NULL,
  `zone_id` int(10) UNSIGNED NOT NULL,
  `site_idfk` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `zone_timeperiods`
--

CREATE TABLE `zone_timeperiods` (
  `id` int(10) UNSIGNED NOT NULL,
  `zone_idfk` int(10) UNSIGNED NOT NULL,
  `timeperiod_idfk` int(10) UNSIGNED NOT NULL,
  `max_bookings` smallint(6) NOT NULL DEFAULT 100
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for table `account_default_job_rel`
--
ALTER TABLE `account_default_job_rel`
  ADD PRIMARY KEY (`account_idfk`,`default_job_idfk`),
  ADD KEY `account_idfk` (`account_idfk`),
  ADD KEY `default_job_idfk` (`default_job_idfk`);

--
-- Indexes for table `account_fields`
--
ALTER TABLE `account_fields`
  ADD PRIMARY KEY (`id`,`site_id`),
  ADD KEY `account_fields_ibfk_1` (`site_id`);

--
-- Indexes for table `account_field_alias`
--
ALTER TABLE `account_field_alias`
  ADD PRIMARY KEY (`invoice_idfk`,`field`);

--
-- Indexes for table `account_invoice_rel`
--
ALTER TABLE `account_invoice_rel`
  ADD PRIMARY KEY (`account_idfk`,`invoice_idfk`),
  ADD KEY `invoice_idfk` (`invoice_idfk`);

--
-- Indexes for table `account_super_admin`
--
ALTER TABLE `account_super_admin`
  ADD PRIMARY KEY (`account_idfk`,`invoice_account_idfk`),
  ADD KEY `account_super_admin_invoice_accounts_id_fk` (`invoice_account_idfk`);

--
-- Indexes for table `advanced_settings_default`
--
ALTER TABLE `advanced_settings_default`
  ADD UNIQUE KEY `acc_type` (`acc_type`);

--
-- Indexes for table `airports`
--
ALTER TABLE `airports`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `airport_addresses`
--
ALTER TABLE `airport_addresses`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `airport_addresses` ADD FULLTEXT KEY `address` (`address`);

--
-- Indexes for table `airport_email_extra`
--
ALTER TABLE `airport_email_extra`
  ADD PRIMARY KEY (`airport_idfk`);

--
-- Indexes for table `airport_widget_settings`
--
ALTER TABLE `airport_widget_settings`
  ADD PRIMARY KEY (`dispatch_idfk`);

--
-- Indexes for table `basic_settings`
--
ALTER TABLE `basic_settings`
  ADD PRIMARY KEY (`account_idfk`);

--
-- Indexes for table `booked_jobs`
--
ALTER TABLE `booked_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `booked_jobs_uuid_uindex` (`uuid`),
  ADD KEY `account_idfk` (`account_idfk`),
  ADD KEY `booking_datetime` (`booking_datetime`),
  ADD KEY `booking_id` (`booking_id`);

--
-- Indexes for table `booked_jobs_invoice_acc_number`
--
ALTER TABLE `booked_jobs_invoice_acc_number`
  ADD KEY `job_idfk` (`job_idfk`);

--
-- Indexes for table `booked_jobs_price`
--
ALTER TABLE `booked_jobs_price`
  ADD PRIMARY KEY (`job_idfk`);

--
-- Indexes for table `booked_jobs_sub_account_rel`
--
ALTER TABLE `booked_jobs_sub_account_rel`
  ADD PRIMARY KEY (`booked_jobs_idfk`),
  ADD KEY `booked_jobs_sub_account_rel_sub_accounts_id_fk` (`sub_account_idfk`);

--
-- Indexes for table `booking_archive_id`
--
ALTER TABLE `booking_archive_id`
  ADD PRIMARY KEY (`job_idfk`);

--
-- Indexes for table `booking_email_log`
--
ALTER TABLE `booking_email_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `job_idfk` (`job_idfk`),
  ADD KEY `account_idfk` (`account_idfk`);

--
-- Indexes for table `booking_idempotency_keys`
--
ALTER TABLE `booking_idempotency_keys`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `booking_post_log`
--
ALTER TABLE `booking_post_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_idfk` (`account_idfk`);

--
-- Indexes for table `booking_request_log`
--
ALTER TABLE `booking_request_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `post_idfk` (`post_idfk`),
  ADD KEY `job_idfk` (`job_idfk`);

--
-- Indexes for table `booking_templates`
--
ALTER TABLE `booking_templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `booking_template_fields`
--
ALTER TABLE `booking_template_fields`
  ADD PRIMARY KEY (`template_idfk`,`option_idfk`);

--
-- Indexes for table `booking_template_options`
--
ALTER TABLE `booking_template_options`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `booking_zone_timeperiod`
--
ALTER TABLE `booking_zone_timeperiod`
  ADD PRIMARY KEY (`booking_idfk`),
  ADD KEY `booking_zone_timeperiod_ibfk_1` (`zone_timeperiod_idfk`);

--
-- Indexes for table `bulk_email_cache`
--
ALTER TABLE `bulk_email_cache`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cancel_log`
--
ALTER TABLE `cancel_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `card_payments`
--
ALTER TABLE `card_payments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `card_payments_booked_jobs`
--
ALTER TABLE `card_payments_booked_jobs`
  ADD PRIMARY KEY (`job_idfk`,`payment_idfk`),
  ADD KEY `payment_idfk` (`payment_idfk`);

--
-- Indexes for table `card_types`
--
ALTER TABLE `card_types`
  ADD PRIMARY KEY (`site_id`,`id`);

--
-- Indexes for table `cc_email_booking_rel`
--
ALTER TABLE `cc_email_booking_rel`
  ADD KEY `cc_email_booking_rel_ibfk_1` (`job_idfk`);

--
-- Indexes for table `cc_email_rel`
--
ALTER TABLE `cc_email_rel`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cc_email_rel_ibfk_1` (`account_idfk`);

--
-- Indexes for table `central_address`
--
ALTER TABLE `central_address`
  ADD PRIMARY KEY (`site_id`);

--
-- Indexes for table `complete_bookings_time`
--
ALTER TABLE `complete_bookings_time`
  ADD PRIMARY KEY (`job_idfk`);

--
-- Indexes for table `credit_cards`
--
ALTER TABLE `credit_cards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `credit_cards_ibfk_1` (`account_idfk`);

--
-- Indexes for table `default_field_value`
--
ALTER TABLE `default_field_value`
  ADD PRIMARY KEY (`account_idfk`,`field_id`,`invoice_idfk`),
  ADD KEY `default_field_value_ibfk_2` (`invoice_idfk`);

--
-- Indexes for table `default_jobs`
--
ALTER TABLE `default_jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `job_name` (`job_name`);

--
-- Indexes for table `dispatch_system_judo_pay_rel`
--
ALTER TABLE `dispatch_system_judo_pay_rel`
  ADD PRIMARY KEY (`dispatch_system_idfk`),
  ADD KEY `dispatch_system_judo_pay_rel_judopay_keys_id_fk` (`judo_idfk`);

--
-- Indexes for table `dispatch_system_stripe_rel`
--
ALTER TABLE `dispatch_system_stripe_rel`
  ADD PRIMARY KEY (`dispatch_system_idfk`),
  ADD KEY `dispatch_system_stripe_rel_stripe_api_keys_id_fk` (`stripe_idfk`);

--
-- Indexes for table `email_additional_content`
--
ALTER TABLE `email_additional_content`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `email_cache`
--
ALTER TABLE `email_cache`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_idfk` (`account_idfk`);

--
-- Indexes for table `email_correspondence`
--
ALTER TABLE `email_correspondence`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_idfk` (`account_idfk`);

--
-- Indexes for table `email_footers`
--
ALTER TABLE `email_footers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ext_bookings_cache`
--
ALTER TABLE `ext_bookings_cache`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ext_1` (`site_id`);

--
-- Indexes for table `facebook_deleted`
--
ALTER TABLE `facebook_deleted`
  ADD PRIMARY KEY (`account_idfk`);

--
-- Indexes for table `facebook_user_id`
--
ALTER TABLE `facebook_user_id`
  ADD PRIMARY KEY (`account_idfk`),
  ADD KEY `facebook_id` (`facebook_id`);

--
-- Indexes for table `favourite_addresses`
--
ALTER TABLE `favourite_addresses`
  ADD KEY `account_idfk` (`account_idfk`);

--
-- Indexes for table `feedback_titles`
--
ALTER TABLE `feedback_titles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `google_addresses`
--
ALTER TABLE `google_addresses`
  ADD PRIMARY KEY (`place_id`);

--
-- Indexes for table `google_maps_settings`
--
ALTER TABLE `google_maps_settings`
  ADD KEY `google_maps_settings_ibfk_1` (`site_id`);

--
-- Indexes for table `google_user_id`
--
ALTER TABLE `google_user_id`
  ADD PRIMARY KEY (`account_idfk`),
  ADD KEY `google_id` (`google_id`);

--
-- Indexes for table `g_fonts`
--
ALTER TABLE `g_fonts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `history_page_access`
--
ALTER TABLE `history_page_access`
  ADD KEY `history_page_access_ibfk_1` (`account_idfk`);

--
-- Indexes for table `icabbi_user_id`
--
ALTER TABLE `icabbi_user_id`
  ADD PRIMARY KEY (`account_idfk`);

--
-- Indexes for table `judo_card_types`
--
ALTER TABLE `judo_card_types`
  ADD PRIMARY KEY (`card_type_id`);

--
-- Indexes for table `judo_payment_charge`
--
ALTER TABLE `judo_payment_charge`
  ADD PRIMARY KEY (`request_idfk`);

--
-- Indexes for table `judo_payment_request`
--
ALTER TABLE `judo_payment_request`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `logged_in_logs`
--
ALTER TABLE `logged_in_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_idfk` (`account_idfk`);

--
-- Indexes for table `marketing_preference`
--
ALTER TABLE `marketing_preference`
  ADD PRIMARY KEY (`account_idfk`);

--
-- Indexes for table `meet_and_greet`
--
ALTER TABLE `meet_and_greet`
  ADD PRIMARY KEY (`id`,`site_id`),
  ADD KEY `meet_and_greet_ibfk_1` (`site_id`);

--
-- Indexes for table `must_change_password`
--
ALTER TABLE `must_change_password`
  ADD PRIMARY KEY (`account_idfk`);

--
-- Indexes for table `old_identifiers`
--
ALTER TABLE `old_identifiers`
  ADD PRIMARY KEY (`invoice_idfk`);

--
-- Indexes for table `page_access_logs`
--
ALTER TABLE `page_access_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `logged_idfk` (`logged_idfk`);

--
-- Indexes for table `page_names`
--
ALTER TABLE `page_names`
  ADD PRIMARY KEY (`file_name`);

--
-- Indexes for table `past_addresses`
--
ALTER TABLE `past_addresses`
  ADD PRIMARY KEY (`account_idfk`,`address_id`,`dispatch_idfk`),
  ADD KEY `past_addresses_dispatch_systems_null_fk` (`dispatch_idfk`),
  ADD KEY `past_addresses_ibfk_1` (`account_idfk`);

--
-- Indexes for table `payment_types`
--
ALTER TABLE `payment_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `payment_type_template_rel`
--
ALTER TABLE `payment_type_template_rel`
  ADD PRIMARY KEY (`template_idfk`,`payment_type_idfk`);

--
-- Indexes for table `popular_addresses`
--
ALTER TABLE `popular_addresses`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `popular_addresses` ADD FULLTEXT KEY `address` (`address`);

--
-- Indexes for table `quick_book_settings`
--
ALTER TABLE `quick_book_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `template_idfk` (`template_idfk`);

--
-- Indexes for table `repeat_bookings`
--
ALTER TABLE `repeat_bookings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `repeat_bookings_ibfk_1` (`account_idfk`);

--
-- Indexes for table `repeat_bookings_rel`
--
ALTER TABLE `repeat_bookings_rel`
  ADD KEY `repeat_bookings_rel_ibfk_1` (`repeat_idfk`),
  ADD KEY `repeat_bookings_rel_ibfk_2` (`booking_idfk`);

--
-- Indexes for table `return_booking_rel`
--
ALTER TABLE `return_booking_rel`
  ADD PRIMARY KEY (`job_idfk`),
  ADD KEY `return_job_idfk` (`return_job_idfk`);

--
-- Indexes for table `return_discount`
--
ALTER TABLE `return_discount`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sagepay_accounts`
--
ALTER TABLE `sagepay_accounts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sage_booking_cache`
--
ALTER TABLE `sage_booking_cache`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sage_booking_cache_ibfk_1` (`account_idfk`),
  ADD KEY `transaction_id` (`transaction_id`);

--
-- Indexes for table `sage_redirect_post_log`
--
ALTER TABLE `sage_redirect_post_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `site_sage_rel`
--
ALTER TABLE `site_sage_rel`
  ADD KEY `site_sage_rel_ibfk_1` (`site_idfk`),
  ADD KEY `site_sage_rel_ibfk_2` (`sage_idfk`);

--
-- Indexes for table `sub_accounts`
--
ALTER TABLE `sub_accounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sub_accounts_invoice_accounts_id_fk` (`invoice_idfk`);

--
-- Indexes for table `sub_account_labels`
--
ALTER TABLE `sub_account_labels`
  ADD PRIMARY KEY (`invoice_idfk`);

--
-- Indexes for table `sub_account_reference_field`
--
ALTER TABLE `sub_account_reference_field`
  ADD PRIMARY KEY (`invoice_account_idfk`);

--
-- Indexes for table `sub_account_users`
--
ALTER TABLE `sub_account_users`
  ADD PRIMARY KEY (`sub_account_idfk`,`account_idfk`),
  ADD KEY `table_name_accounts_id_fk` (`account_idfk`);

--
-- Indexes for table `system_addresses`
--
ALTER TABLE `system_addresses`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `system_addresses` ADD FULLTEXT KEY `address` (`address`);

--
-- Indexes for table `system_addresses_config`
--
ALTER TABLE `system_addresses_config`
  ADD PRIMARY KEY (`site_id`);

--
-- Indexes for table `timeperiods`
--
ALTER TABLE `timeperiods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_central_address`
--
ALTER TABLE `user_central_address`
  ADD PRIMARY KEY (`account_idfk`);

--
-- Indexes for table `vehicle_types`
--
ALTER TABLE `vehicle_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `zones`
--
ALTER TABLE `zones`
  ADD PRIMARY KEY (`id`),
  ADD KEY `zones_ibfk_1` (`site_idfk`);

--
-- Indexes for table `zone_timeperiods`
--
ALTER TABLE `zone_timeperiods`
  ADD PRIMARY KEY (`id`),
  ADD KEY `zone_timeperiods_ibfk_1` (`zone_idfk`),
  ADD KEY `zone_timeperiods_ibfk_2` (`timeperiod_idfk`);

--
-- AUTO_INCREMENT for table `airports`
--
ALTER TABLE `airports`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=129;

--
-- AUTO_INCREMENT for table `airport_addresses`
--
ALTER TABLE `airport_addresses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `booked_jobs`
--
ALTER TABLE `booked_jobs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `booking_email_log`
--
ALTER TABLE `booking_email_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `booking_idempotency_keys`
--
ALTER TABLE `booking_idempotency_keys`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `booking_post_log`
--
ALTER TABLE `booking_post_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `booking_request_log`
--
ALTER TABLE `booking_request_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bulk_email_cache`
--
ALTER TABLE `bulk_email_cache`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cancel_log`
--
ALTER TABLE `cancel_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `card_payments`
--
ALTER TABLE `card_payments`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `default_jobs`
--
ALTER TABLE `default_jobs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_cache`
--
ALTER TABLE `email_cache`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_correspondence`
--
ALTER TABLE `email_correspondence`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `email_footers`
--
ALTER TABLE `email_footers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ext_bookings_cache`
--
ALTER TABLE `ext_bookings_cache`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `judo_payment_request`
--
ALTER TABLE `judo_payment_request`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `logged_in_logs`
--
ALTER TABLE `logged_in_logs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `meet_and_greet`
--
ALTER TABLE `meet_and_greet`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `page_access_logs`
--
ALTER TABLE `page_access_logs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=443;

--
-- AUTO_INCREMENT for table `popular_addresses`
--
ALTER TABLE `popular_addresses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `quick_book_settings`
--
ALTER TABLE `quick_book_settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `repeat_bookings`
--
ALTER TABLE `repeat_bookings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `return_discount`
--
ALTER TABLE `return_discount`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sagepay_accounts`
--
ALTER TABLE `sagepay_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sage_booking_cache`
--
ALTER TABLE `sage_booking_cache`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sage_redirect_post_log`
--
ALTER TABLE `sage_redirect_post_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sub_accounts`
--
ALTER TABLE `sub_accounts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `system_addresses`
--
ALTER TABLE `system_addresses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timeperiods`
--
ALTER TABLE `timeperiods`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vehicle_types`
--
ALTER TABLE `vehicle_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `zones`
--
ALTER TABLE `zones`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `zone_timeperiods`
--
ALTER TABLE `zone_timeperiods`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `account_default_job_rel`
--
ALTER TABLE `account_default_job_rel`
  ADD CONSTRAINT `account_default_job_rel_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `account_default_job_rel_ibfk_2` FOREIGN KEY (`default_job_idfk`) REFERENCES `default_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `account_fields`
--
ALTER TABLE `account_fields`
  ADD CONSTRAINT `account_fields_ibfk_1` FOREIGN KEY (`site_id`) REFERENCES `dispatch_systems` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `account_field_alias`
--
ALTER TABLE `account_field_alias`
  ADD CONSTRAINT `account_field_alias_invoice_accounts_id_fk` FOREIGN KEY (`invoice_idfk`) REFERENCES `invoice_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `account_invoice_rel`
--
ALTER TABLE `account_invoice_rel`
  ADD CONSTRAINT `account_invoice_rel_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `account_invoice_rel_ibfk_2` FOREIGN KEY (`invoice_idfk`) REFERENCES `invoice_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `account_super_admin`
--
ALTER TABLE `account_super_admin`
  ADD CONSTRAINT `account_super_admin_accounts_id_fk` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `account_super_admin_invoice_accounts_id_fk` FOREIGN KEY (`invoice_account_idfk`) REFERENCES `invoice_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `airport_email_extra`
--
ALTER TABLE `airport_email_extra`
  ADD CONSTRAINT `airport_email_extra_ibfk_1` FOREIGN KEY (`airport_idfk`) REFERENCES `airport_addresses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `airport_widget_settings`
--
ALTER TABLE `airport_widget_settings`
  ADD CONSTRAINT `airport_widget_settings_dispatch_systems_null_fk` FOREIGN KEY (`dispatch_idfk`) REFERENCES `dispatch_systems` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `basic_settings`
--
ALTER TABLE `basic_settings`
  ADD CONSTRAINT `basic_settings_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `booked_jobs`
--
ALTER TABLE `booked_jobs`
  ADD CONSTRAINT `booked_jobs_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `booked_jobs_invoice_acc_number`
--
ALTER TABLE `booked_jobs_invoice_acc_number`
  ADD CONSTRAINT `booked_jobs_invoice_acc_number_ibfk_1` FOREIGN KEY (`job_idfk`) REFERENCES `booked_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `booked_jobs_price`
--
ALTER TABLE `booked_jobs_price`
  ADD CONSTRAINT `booked_jobs_price_ibfk_1` FOREIGN KEY (`job_idfk`) REFERENCES `booked_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `booked_jobs_sub_account_rel`
--
ALTER TABLE `booked_jobs_sub_account_rel`
  ADD CONSTRAINT `booked_jobs_sub_account_rel_booked_jobs_id_fk` FOREIGN KEY (`booked_jobs_idfk`) REFERENCES `booked_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `booked_jobs_sub_account_rel_sub_accounts_id_fk` FOREIGN KEY (`sub_account_idfk`) REFERENCES `sub_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `booking_archive_id`
--
ALTER TABLE `booking_archive_id`
  ADD CONSTRAINT `booking_archive_id_ibfk_1` FOREIGN KEY (`job_idfk`) REFERENCES `booked_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `booking_email_log`
--
ALTER TABLE `booking_email_log`
  ADD CONSTRAINT `booking_email_log_ibfk_1` FOREIGN KEY (`job_idfk`) REFERENCES `booked_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `booking_email_log_ibfk_2` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `booking_post_log`
--
ALTER TABLE `booking_post_log`
  ADD CONSTRAINT `booking_post_log_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `booking_request_log`
--
ALTER TABLE `booking_request_log`
  ADD CONSTRAINT `booking_request_log_ibfk_1` FOREIGN KEY (`post_idfk`) REFERENCES `booking_post_log` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `booking_request_log_ibfk_2` FOREIGN KEY (`job_idfk`) REFERENCES `booked_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `booking_zone_timeperiod`
--
ALTER TABLE `booking_zone_timeperiod`
  ADD CONSTRAINT `booking_zone_timeperiod_ibfk_1` FOREIGN KEY (`zone_timeperiod_idfk`) REFERENCES `zone_timeperiods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `booking_zone_timeperiod_ibfk_2` FOREIGN KEY (`booking_idfk`) REFERENCES `booked_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `card_payments_booked_jobs`
--
ALTER TABLE `card_payments_booked_jobs`
  ADD CONSTRAINT `card_payments_booked_jobs_ibfk_1` FOREIGN KEY (`job_idfk`) REFERENCES `booked_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `card_payments_booked_jobs_ibfk_2` FOREIGN KEY (`payment_idfk`) REFERENCES `card_payments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `cc_email_booking_rel`
--
ALTER TABLE `cc_email_booking_rel`
  ADD CONSTRAINT `cc_email_booking_rel_ibfk_1` FOREIGN KEY (`job_idfk`) REFERENCES `booked_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `cc_email_rel`
--
ALTER TABLE `cc_email_rel`
  ADD CONSTRAINT `cc_email_rel_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `central_address`
--
ALTER TABLE `central_address`
  ADD CONSTRAINT `central_address_ibfk_1` FOREIGN KEY (`site_id`) REFERENCES `dispatch_systems` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `complete_bookings_time`
--
ALTER TABLE `complete_bookings_time`
  ADD CONSTRAINT `complete_bookings_time_ibfk_1` FOREIGN KEY (`job_idfk`) REFERENCES `booked_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `credit_cards`
--
ALTER TABLE `credit_cards`
  ADD CONSTRAINT `credit_cards_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `default_field_value`
--
ALTER TABLE `default_field_value`
  ADD CONSTRAINT `default_field_value_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `default_field_value_ibfk_2` FOREIGN KEY (`invoice_idfk`) REFERENCES `invoice_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dispatch_system_judo_pay_rel`
--
ALTER TABLE `dispatch_system_judo_pay_rel`
  ADD CONSTRAINT `dispatch_system_judo_pay_rel_dispatch_systems_id_fk` FOREIGN KEY (`dispatch_system_idfk`) REFERENCES `dispatch_systems` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `dispatch_system_judo_pay_rel_judopay_keys_id_fk` FOREIGN KEY (`judo_idfk`) REFERENCES `judopay_keys` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `dispatch_system_stripe_rel`
--
ALTER TABLE `dispatch_system_stripe_rel`
  ADD CONSTRAINT `dispatch_system_stripe_rel_dispatch_systems_id_fk` FOREIGN KEY (`dispatch_system_idfk`) REFERENCES `dispatch_systems` (`id`),
  ADD CONSTRAINT `dispatch_system_stripe_rel_stripe_api_keys_id_fk` FOREIGN KEY (`stripe_idfk`) REFERENCES `stripe_api_keys` (`id`);

--
-- Constraints for table `email_cache`
--
ALTER TABLE `email_cache`
  ADD CONSTRAINT `email_cache_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `email_correspondence`
--
ALTER TABLE `email_correspondence`
  ADD CONSTRAINT `email_correspondence_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `facebook_user_id`
--
ALTER TABLE `facebook_user_id`
  ADD CONSTRAINT `facebook_user_id_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `favourite_addresses`
--
ALTER TABLE `favourite_addresses`
  ADD CONSTRAINT `favourite_addresses_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `google_maps_settings`
--
ALTER TABLE `google_maps_settings`
  ADD CONSTRAINT `google_maps_settings_ibfk_1` FOREIGN KEY (`site_id`) REFERENCES `dispatch_systems` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `google_user_id`
--
ALTER TABLE `google_user_id`
  ADD CONSTRAINT `google_user_id_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `history_page_access`
--
ALTER TABLE `history_page_access`
  ADD CONSTRAINT `history_page_access_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `logged_in_logs`
--
ALTER TABLE `logged_in_logs`
  ADD CONSTRAINT `logged_in_logs_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `marketing_preference`
--
ALTER TABLE `marketing_preference`
  ADD CONSTRAINT `marketing_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `meet_and_greet`
--
ALTER TABLE `meet_and_greet`
  ADD CONSTRAINT `meet_and_greet_ibfk_1` FOREIGN KEY (`site_id`) REFERENCES `dispatch_systems` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `must_change_password`
--
ALTER TABLE `must_change_password`
  ADD CONSTRAINT `must_change_password_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `old_identifiers`
--
ALTER TABLE `old_identifiers`
  ADD CONSTRAINT `old_identifiers_ibfk_1` FOREIGN KEY (`invoice_idfk`) REFERENCES `invoice_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `page_access_logs`
--
ALTER TABLE `page_access_logs`
  ADD CONSTRAINT `page_access_logs_ibfk_1` FOREIGN KEY (`logged_idfk`) REFERENCES `logged_in_logs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `past_addresses`
--
ALTER TABLE `past_addresses`
  ADD CONSTRAINT `past_addresses_dispatch_systems_null_fk` FOREIGN KEY (`dispatch_idfk`) REFERENCES `dispatch_systems` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `past_addresses_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `payment_type_template_rel`
--
ALTER TABLE `payment_type_template_rel`
  ADD CONSTRAINT `payment_type_template_rel_ibfk_1` FOREIGN KEY (`template_idfk`) REFERENCES `booking_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `quick_book_settings`
--
ALTER TABLE `quick_book_settings`
  ADD CONSTRAINT `quick_book_settings_ibfk_1` FOREIGN KEY (`template_idfk`) REFERENCES `booking_templates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `repeat_bookings`
--
ALTER TABLE `repeat_bookings`
  ADD CONSTRAINT `repeat_bookings_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `repeat_bookings_rel`
--
ALTER TABLE `repeat_bookings_rel`
  ADD CONSTRAINT `repeat_bookings_rel_ibfk_1` FOREIGN KEY (`repeat_idfk`) REFERENCES `repeat_bookings` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `repeat_bookings_rel_ibfk_2` FOREIGN KEY (`booking_idfk`) REFERENCES `booked_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `return_booking_rel`
--
ALTER TABLE `return_booking_rel`
  ADD CONSTRAINT `return_booking_rel_ibfk_1` FOREIGN KEY (`job_idfk`) REFERENCES `booked_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `return_booking_rel_ibfk_2` FOREIGN KEY (`return_job_idfk`) REFERENCES `booked_jobs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sage_booking_cache`
--
ALTER TABLE `sage_booking_cache`
  ADD CONSTRAINT `sage_booking_cache_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `site_sage_rel`
--
ALTER TABLE `site_sage_rel`
  ADD CONSTRAINT `site_sage_rel_ibfk_1` FOREIGN KEY (`site_idfk`) REFERENCES `dispatch_systems` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `site_sage_rel_ibfk_2` FOREIGN KEY (`sage_idfk`) REFERENCES `sagepay_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sub_accounts`
--
ALTER TABLE `sub_accounts`
  ADD CONSTRAINT `sub_accounts_invoice_accounts_id_fk` FOREIGN KEY (`invoice_idfk`) REFERENCES `invoice_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sub_account_labels`
--
ALTER TABLE `sub_account_labels`
  ADD CONSTRAINT `sub_account_labels_invoice_accounts_id_fk` FOREIGN KEY (`invoice_idfk`) REFERENCES `invoice_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sub_account_reference_field`
--
ALTER TABLE `sub_account_reference_field`
  ADD CONSTRAINT `sub_account_reference_field_invoice_accounts_id_fk` FOREIGN KEY (`invoice_account_idfk`) REFERENCES `invoice_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sub_account_users`
--
ALTER TABLE `sub_account_users`
  ADD CONSTRAINT `table_name_accounts_id_fk` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `table_name_sub_accounts_id_fk` FOREIGN KEY (`sub_account_idfk`) REFERENCES `sub_accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `user_central_address`
--
ALTER TABLE `user_central_address`
  ADD CONSTRAINT `user_central_address_ibfk_1` FOREIGN KEY (`account_idfk`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `zones`
--
ALTER TABLE `zones`
  ADD CONSTRAINT `zones_ibfk_1` FOREIGN KEY (`site_idfk`) REFERENCES `dispatch_systems` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `zone_timeperiods`
--
ALTER TABLE `zone_timeperiods`
  ADD CONSTRAINT `zone_timeperiods_ibfk_1` FOREIGN KEY (`zone_idfk`) REFERENCES `zones` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `zone_timeperiods_ibfk_2` FOREIGN KEY (`timeperiod_idfk`) REFERENCES `timeperiods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

