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

START TRANSACTION;



--
-- Database: `rbakvsk6_OakwoodWebsite`
--

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

--
-- Table structure for table `driver_applications`
--

CREATE TABLE `driver_applications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `public_reference` varchar(32) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(254) NOT NULL,
  `phone` varchar(40) NOT NULL,
  `city` varchar(150) NOT NULL,
  `province_state` varchar(100) NOT NULL,
  `az_experience_years` enum('0','1','2','3','4','5_plus') NOT NULL,
  `car_hauling_experience_years` enum('0','1','2','3','4','5_plus') NOT NULL,
  `can_drive_manual` tinyint(1) UNSIGNED NOT NULL,
  `position_requested` enum('company_driver','owner_operator') NOT NULL,
  `driver_abstract_original_name` varchar(255) NOT NULL,
  `driver_abstract_stored_name` varchar(100) NOT NULL,
  `driver_abstract_relative_path` varchar(500) NOT NULL,
  `driver_abstract_mime_type` varchar(100) NOT NULL DEFAULT 'application/pdf',
  `driver_abstract_size_bytes` int(10) UNSIGNED NOT NULL,
  `driver_abstract_sha256` char(64) NOT NULL,
  `cvor_abstract_original_name` varchar(255) NOT NULL,
  `cvor_abstract_stored_name` varchar(100) NOT NULL,
  `cvor_abstract_relative_path` varchar(500) NOT NULL,
  `cvor_abstract_mime_type` varchar(100) NOT NULL DEFAULT 'application/pdf',
  `cvor_abstract_size_bytes` int(10) UNSIGNED NOT NULL,
  `cvor_abstract_sha256` char(64) NOT NULL,
  `resume_original_name` varchar(255) NOT NULL,
  `resume_stored_name` varchar(100) NOT NULL,
  `resume_relative_path` varchar(500) NOT NULL,
  `resume_mime_type` varchar(100) NOT NULL DEFAULT 'application/pdf',
  `resume_size_bytes` int(10) UNSIGNED NOT NULL,
  `resume_sha256` char(64) NOT NULL,
  `privacy_consent` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `privacy_consented_at` datetime(6) DEFAULT NULL,
  `privacy_policy_version` varchar(40) NOT NULL,
  `form_version` varchar(40) NOT NULL,
  `form_elapsed_seconds` smallint(5) UNSIGNED DEFAULT NULL,
  `application_status` enum('new','reviewing','contacted','interview','hired','declined','closed') NOT NULL DEFAULT 'new',
  `email_status` enum('pending','sent','failed') NOT NULL DEFAULT 'pending',
  `email_attempts` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `emailed_at` datetime(6) DEFAULT NULL,
  `email_last_error` varchar(500) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` varchar(1000) DEFAULT NULL,
  `browser_name` varchar(50) DEFAULT NULL,
  `browser_version` varchar(40) DEFAULT NULL,
  `operating_system` varchar(80) DEFAULT NULL,
  `device_type` varchar(20) DEFAULT NULL,
  `accept_language` varchar(255) DEFAULT NULL,
  `referrer_host` varchar(255) DEFAULT NULL,
  `referrer_path` varchar(1000) DEFAULT NULL,
  `source_path` varchar(255) NOT NULL DEFAULT '/driver-application',
  `submitted_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_at` datetime(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Native driver applications and private PDF document metadata';

--
-- Dumping data for table `driver_applications`
--

INSERT INTO `driver_applications` (`id`, `public_reference`, `first_name`, `last_name`, `email`, `phone`, `city`, `province_state`, `az_experience_years`, `car_hauling_experience_years`, `can_drive_manual`, `position_requested`, `driver_abstract_original_name`, `driver_abstract_stored_name`, `driver_abstract_relative_path`, `driver_abstract_mime_type`, `driver_abstract_size_bytes`, `driver_abstract_sha256`, `cvor_abstract_original_name`, `cvor_abstract_stored_name`, `cvor_abstract_relative_path`, `cvor_abstract_mime_type`, `cvor_abstract_size_bytes`, `cvor_abstract_sha256`, `resume_original_name`, `resume_stored_name`, `resume_relative_path`, `resume_mime_type`, `resume_size_bytes`, `resume_sha256`, `privacy_consent`, `privacy_consented_at`, `privacy_policy_version`, `form_version`, `form_elapsed_seconds`, `application_status`, `email_status`, `email_attempts`, `emailed_at`, `email_last_error`, `ip_address`, `user_agent`, `browser_name`, `browser_version`, `operating_system`, `device_type`, `accept_language`, `referrer_host`, `referrer_path`, `source_path`, `submitted_at`, `updated_at`) VALUES
(1, 'OWD-20260730-860614180A3C', 'Joe', 'Dirt', 'joedirt@rob.mozmail.com', '555-555-5555', 'Ingersoll', 'Ontario', '4', '4', 0, 'owner_operator', 'sample-drivers-abstract.pdf', 'driver-abstract-64b95a8396a54530.pdf', 'storage/uploads/driver-applications/OWD-20260730-860614180A3C/driver-abstract-64b95a8396a54530.pdf', 'application/pdf', 4263, '6e287f421d60816dc0f0ce43e286a08db7e2a86692189ff54a52d7e8b091e81f', 'sample-cvor-abstract.pdf', 'cvor-abstract-6ebca200a20d2f67.pdf', 'storage/uploads/driver-applications/OWD-20260730-860614180A3C/cvor-abstract-6ebca200a20d2f67.pdf', 'application/pdf', 5966, '7d3b0fcff8dbdbd7a8375a03c4e416bca8bde45cd002bf0806cd942ab0f1bd6e', 'sample-truck-driver-resume.pdf', 'resume-cv-da55538e47be66d3.pdf', 'storage/uploads/driver-applications/OWD-20260730-860614180A3C/resume-cv-da55538e47be66d3.pdf', 'application/pdf', 5959, '070d4c0ca8c89b88ed3acc77191a6e9e63839e91d92191f9c370e5b6035e4b30', 1, '2026-07-30 16:59:36.793201', '2026-07-30', 'native-v2', 169, 'new', 'sent', 1, '2026-07-30 16:59:36.906290', NULL, '66.203.171.66', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', 'Google Chrome', '150.0.0.0', 'Windows 10 or 11', 'desktop', 'en-US,en;q=0.9', 'oakwood1.hessler.ca', '/driver-application', '/quote', '2026-07-30 16:59:36.793201', '2026-07-30 16:59:36.906290');

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

--
-- Table structure for table `faq_items`
--

CREATE TABLE `faq_items` (
  `id` int(10) UNSIGNED NOT NULL,
  `faq_key` varchar(100) NOT NULL COMMENT 'Stable seed/import identifier',
  `section_key` varchar(50) NOT NULL COMMENT 'Page grouping, such as common or snowbirds',
  `question` varchar(500) NOT NULL,
  `answer_html` text NOT NULL,
  `sort_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Database-only FAQ content for public pages';

--
-- Dumping data for table `faq_items`
--

INSERT INTO `faq_items` (`id`, `faq_key`, `section_key`, `question`, `answer_html`, `sort_order`, `active`, `created_at`, `updated_at`) VALUES
(1, 'common-shipping-coverage', 'common', 'Does Oakwood ship vehicles across Canada and the United States?', '<p>Yes. Oakwood provides vehicle shipping across Canada and the contiguous United States, subject to route availability, timing, vehicle type, and documentation requirements.</p>', 10, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(2, 'common-direct-carrier', 'common', 'Is Oakwood a broker or a direct carrier?', '<p>Oakwood positions its vehicle shipping service around direct carrier accountability, meaning shipment planning is handled with the operating carrier team rather than passed through a broker chain.</p>', 20, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(3, 'common-quote-information', 'common', 'What information is needed for a vehicle shipping quote?', '<p>Have pickup and delivery cities, vehicle year/make/model, running status, plate or title status, preferred pickup and delivery timing, and any access restrictions ready.</p>', 30, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(4, 'common-snowbird-shipping', 'common', 'Can Oakwood help Canadian snowbirds ship vehicles to the U.S.?', '<p>Yes. Oakwood supports seasonal vehicle shipping for Canadian snowbirds travelling between Canada and U.S. destinations such as Florida, Arizona, Texas, and California, subject to route confirmation.</p>', 40, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(5, 'common-personal-items', 'common', 'Can personal items be left in the vehicle during transport?', '<p>Personal item rules can vary by route, carrier requirements, and border requirements. Ask an Oakwood expert before placing belongings in the vehicle.</p>', 50, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(6, 'common-non-running-vehicle', 'common', 'Can Oakwood move a non-running vehicle?', '<p>Possibly. Non-running vehicles require advance review because loading, equipment, access, and pricing may differ from a standard running vehicle.</p>', 60, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(7, 'common-shipping-timing', 'common', 'What affects vehicle shipping timing?', '<p>Timing depends on route, season, pickup and delivery access, vehicle type, paperwork, border requirements, weather, and carrier scheduling.</p>', 70, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(8, 'snowbirds-personal-items', 'snowbirds', 'What may I leave inside my vehicle?', '<p>You may leave:</p><ul><li>Up to 2 suitcases containing clothing and shoes</li><li>Up to 2 sets of golf clubs</li></ul><p>Please do not leave food, pet food, alcohol, medication, or electronics in the vehicle.</p>', 10, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(9, 'snowbirds-pickup-days', 'snowbirds', 'What days are vehicles picked up?', '<p>Vehicles travelling south are normally picked up on Friday or Saturday.</p><p>Vehicles returning north are normally picked up on Monday or Tuesday.</p><p>The driver will call you 1 to 2 days before pickup with an estimated arrival time.</p>', 20, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(10, 'snowbirds-home-pickup', 'snowbirds', 'Can you pick up my vehicle at my home?', '<p>Yes, provided our 80-foot transport truck can safely enter and leave your street.</p><p>The driver will make the final decision. When the driver calls, they will arrange a nearby meeting place if your street is not accessible. This may be a grocery store or large retail parking lot.</p><p>The same rule applies when your vehicle is delivered.</p>', 30, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(11, 'snowbirds-pickup-representative', 'snowbirds', 'Do I need to be there when my vehicle is picked up?', '<p>No. However, another adult must be there to meet the driver and inspect the vehicle with them.</p><p>Please enter that person’s name and telephone number in the <strong>Special Instructions</strong> section of the booking form.</p><p>The same rule applies when your vehicle is delivered.</p>', 40, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(12, 'snowbirds-payment', 'snowbirds', 'How can I pay?', '<p>E-transfer is preferred.</p><p>You may also pay by Visa or Mastercard. A 3% credit card fee will be added.</p>', 50, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(13, 'snowbirds-leased-vehicle', 'snowbirds', 'My vehicle is leased. Do I need a letter?', '<p>Yes. You need a letter from the leasing company giving you permission to use the vehicle in the United States.</p><p>The letter should include the dates you will be travelling in Florida.</p>', 60, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(14, 'snowbirds-quote-timing', 'snowbirds', 'When should I ask for a quote?', '<p>Please request your quote as early as possible, especially for:</p><ul><li>Fall trips to Florida</li><li>Spring trips back to Canada</li></ul><p>Pickup dates can be affected by seasonal demand, border requirements, the type of vehicle, and access to the pickup or delivery location.</p>', 70, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(15, 'snowbirds-insurance', 'snowbirds', 'What insurance coverage is provided?', '<p>Please read the Vehicle Shipping Agreement that was emailed to you when you booked.</p><p>It explains the insurance coverage, what to do if damage occurs, and how damage claims are handled.</p>', 80, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(16, 'snowbirds-cancellation', 'snowbirds', 'What is the cancellation policy?', '<p>Please read the Vehicle Shipping Agreement that was emailed to you when you booked.</p><p>It explains cancellation deadlines and any fees that may apply when a booking is cancelled or changed.</p>', 90, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(17, 'snowbirds-transit-time', 'snowbirds', 'How long does shipping usually take?', '<p>Most vehicles are delivered within 3 to 4 days after pickup.</p><p>Delays can sometimes happen. We will do our best to keep you informed if your delivery schedule changes.</p>', 100, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(18, 'snowbirds-location-update', 'snowbirds', 'How can I check the location of my vehicle?', '<p>Call our office during regular business hours for an update on your vehicle.</p>', 110, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(19, 'snowbirds-multiple-vehicles', 'snowbirds', 'Is there a discount for shipping more than one vehicle?', '<p>No. We use the same competitive pricing for every vehicle, regardless of how many vehicles you ship.</p>', 120, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15');

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

--
-- Table structure for table `quote_submissions`
--

CREATE TABLE `quote_submissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `public_reference` varchar(32) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(254) NOT NULL,
  `phone` varchar(40) DEFAULT NULL,
  `customer_type` varchar(20) DEFAULT NULL,
  `vehicle_year` smallint(5) UNSIGNED DEFAULT NULL,
  `vehicle_make` varchar(100) DEFAULT NULL,
  `vehicle_model` varchar(100) DEFAULT NULL,
  `operational` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `origin_city` varchar(150) DEFAULT NULL,
  `destination_city` varchar(150) DEFAULT NULL,
  `preferred_pickup_date` date DEFAULT NULL,
  `preferred_dropoff_date` date DEFAULT NULL,
  `comments` text DEFAULT NULL,
  `privacy_consent` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `privacy_consented_at` datetime(6) DEFAULT NULL,
  `privacy_policy_version` varchar(40) NOT NULL,
  `form_version` varchar(40) NOT NULL,
  `form_elapsed_seconds` smallint(5) UNSIGNED DEFAULT NULL,
  `submission_status` enum('new','contacted','quoted','booked','declined','closed') NOT NULL DEFAULT 'new',
  `email_status` enum('pending','sent','failed') NOT NULL DEFAULT 'pending',
  `email_attempts` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `emailed_at` datetime(6) DEFAULT NULL,
  `email_last_error` varchar(500) DEFAULT NULL,
  `email_copy_requested` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `email_copy_status` enum('not_requested','pending','sent','failed') NOT NULL DEFAULT 'not_requested',
  `email_copy_attempts` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `email_copy_sent_at` datetime(6) DEFAULT NULL,
  `email_copy_last_error` varchar(500) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL COMMENT 'Validated REMOTE_ADDR; IPv4 or IPv6',
  `user_agent` varchar(1000) DEFAULT NULL,
  `browser_name` varchar(50) DEFAULT NULL,
  `browser_version` varchar(40) DEFAULT NULL,
  `operating_system` varchar(80) DEFAULT NULL,
  `device_type` varchar(20) DEFAULT NULL,
  `accept_language` varchar(255) DEFAULT NULL,
  `referrer_host` varchar(255) DEFAULT NULL,
  `referrer_path` varchar(1000) DEFAULT NULL,
  `source_path` varchar(255) NOT NULL DEFAULT '/quote',
  `submitted_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_at` datetime(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Native website quote requests and request audit metadata';

--
-- Dumping data for table `quote_submissions`
--

INSERT INTO `quote_submissions` (`id`, `public_reference`, `first_name`, `last_name`, `email`, `phone`, `customer_type`, `vehicle_year`, `vehicle_make`, `vehicle_model`, `operational`, `origin_city`, `destination_city`, `preferred_pickup_date`, `preferred_dropoff_date`, `comments`, `privacy_consent`, `privacy_consented_at`, `privacy_policy_version`, `form_version`, `form_elapsed_seconds`, `submission_status`, `email_status`, `email_attempts`, `emailed_at`, `email_last_error`, `email_copy_requested`, `email_copy_status`, `email_copy_attempts`, `email_copy_sent_at`, `email_copy_last_error`, `ip_address`, `user_agent`, `browser_name`, `browser_version`, `operating_system`, `device_type`, `accept_language`, `referrer_host`, `referrer_path`, `source_path`, `submitted_at`, `updated_at`) VALUES
(1, 'OWQ-20260730-3CBE698F6821', 'Rob', 'Hessler', 'rob@oakwoodtransport.com', '555-555-5555', 'individual', 2015, 'Dodge', 'Ram', 1, 'Ingersoll', 'Florida', '2026-07-30', '2026-08-06', 'just some notes', 1, '2026-07-30 11:02:23.136736', '2026-07-30', 'native-v2', 54, 'new', 'sent', 1, '2026-07-30 11:02:23.243104', NULL, 0, 'not_requested', 0, NULL, NULL, '66.203.171.66', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', 'Google Chrome', '150.0.0.0', 'Windows 10 or 11', 'desktop', 'en-US,en;q=0.9', 'oakwood1.hessler.ca', '/quote', '/quote', '2026-07-30 11:02:23.136736', '2026-07-30 11:02:23.243104'),
(2, 'OWQ-20260730-AF4F410CA3E0', 'Joe', 'Dirt', 'joedirt@rob.mozmail.com', '555-555-5555', 'individual', 1969, 'Dodge', 'Charger', 1, 'Ingersoll', 'Florida', NULL, NULL, 'some comments', 1, '2026-07-30 11:55:28.258208', '2026-07-30', 'native-v4', 806, 'new', 'sent', 1, '2026-07-30 11:55:28.368337', NULL, 1, 'sent', 1, '2026-07-30 11:55:28.484820', NULL, '66.203.171.66', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', 'Google Chrome', '150.0.0.0', 'Windows 10 or 11', 'desktop', 'en-US,en;q=0.9', 'oakwood1.hessler.ca', '/quote', '/quote', '2026-07-30 11:55:28.258208', '2026-07-30 11:55:28.484820'),
(3, 'OWQ-20260730-4E21745E600C', '1', '1', 'joedirt@rob.mozmail.com', '555-555-5555', NULL, 1969, 'd', 'c', 1, 'Ing', 'Flo', NULL, NULL, 'asd', 1, '2026-07-30 12:21:04.351127', '2026-07-30', 'native-v4', 158, 'new', 'sent', 1, '2026-07-30 12:21:04.462095', NULL, 1, 'sent', 1, '2026-07-30 12:21:04.607043', NULL, '66.203.171.66', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', 'Google Chrome', '150.0.0.0', 'Windows 10 or 11', 'desktop', 'en-US,en;q=0.9', 'oakwood1.hessler.ca', '/quote', '/quote', '2026-07-30 12:21:04.351127', '2026-07-30 12:21:04.607043');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `setting_key` varchar(100) NOT NULL,
  `setting_value` text NOT NULL,
  `description` varchar(500) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Database-editable site settings';

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `setting_key`, `setting_value`, `description`, `created_at`, `updated_at`) VALUES
(1, 'site_phone', '519-485-4851', 'Main phone number', '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(2, 'site_toll_free', '1-800-265-4008', 'Toll-free phone number', '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(3, 'site_fax', '519-485-6098', 'Fax number', '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(4, 'google_maps', 'https://share.google/6fcx905ztMcwsfFdd', 'Google Maps share link', '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(5, 'privacy_draft', '0', 'Legacy compatibility flag; the privacy page is production-ready', '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(6, 'form_cognito_key', 'zB4sdOxPKkSKskczjtcENw', 'Cognito Forms account key', '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(8, 'form_contact_us_id', '47', 'Cognito form ID for Contact Us', '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(9, 'form_ship_cdn_snowbird', 'https://www.cognitoforms.com/OakwoodTransport/SnowbirdVehicleReturn', 'Canadian-plated and returning snowbird shipping form', '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(10, 'form_ship_usa_to_can', 'https://www.cognitoforms.com/OakwoodTransport/USToCanadaVehicleRelocation', 'United States to Canada vehicle shipping form', '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(11, 'form_ship_within_can', 'https://www.cognitoforms.com/OakwoodTransport/ShipWithinCanadaPackage', 'Within-Canada vehicle shipping form', '2026-07-30 15:00:15', '2026-07-30 15:00:15'),
(12, 'form_ship_can_to_usa', 'https://fs9.formsite.com/ld3Nd6/eqicsdziob/index.html', 'Canada to United States Form 3299 shipping form', '2026-07-30 15:00:15', '2026-07-30 15:00:15');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `driver_applications`
--
ALTER TABLE `driver_applications`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_driver_application_reference` (`public_reference`),
  ADD KEY `idx_driver_application_submitted` (`submitted_at`),
  ADD KEY `idx_driver_application_status` (`application_status`,`submitted_at`),
  ADD KEY `idx_driver_application_email_status` (`email_status`,`submitted_at`),
  ADD KEY `idx_driver_application_email` (`email`),
  ADD KEY `idx_driver_application_position` (`position_requested`,`submitted_at`);

--
-- Indexes for table `faq_items`
--
ALTER TABLE `faq_items`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_faq_key` (`faq_key`),
  ADD KEY `idx_faq_section_active_sort` (`section_key`,`active`,`sort_order`,`id`);

--
-- Indexes for table `quote_submissions`
--
ALTER TABLE `quote_submissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_quote_public_reference` (`public_reference`),
  ADD KEY `idx_quote_submitted_at` (`submitted_at`),
  ADD KEY `idx_quote_status_date` (`submission_status`,`submitted_at`),
  ADD KEY `idx_quote_email_status` (`email_status`,`submitted_at`),
  ADD KEY `idx_quote_email` (`email`),
  ADD KEY `idx_quote_ip_date` (`ip_address`,`submitted_at`),
  ADD KEY `idx_quote_email_copy_status` (`email_copy_status`,`submitted_at`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_settings_key` (`setting_key`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `driver_applications`
--
ALTER TABLE `driver_applications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `quote_submissions`
--
ALTER TABLE `quote_submissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;

