-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Aug 11, 2026 at 03:13 PM -- Server version: 10.6.27-MariaDB-cll-lve -- PHP Version: 8.4.23 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- 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?', '

Yes. Oakwood provides vehicle shipping across Canada and the contiguous United States, subject to route availability, timing, vehicle type, and documentation requirements.

', 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?', '

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.

', 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?', '

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.

', 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.?', '

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.

', 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?', '

Personal item rules can vary by route, carrier requirements, and border requirements. Ask an Oakwood expert before placing belongings in the vehicle.

', 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?', '

Possibly. Non-running vehicles require advance review because loading, equipment, access, and pricing may differ from a standard running vehicle.

', 60, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'), (7, 'common-shipping-timing', 'common', 'What affects vehicle shipping timing?', '

Timing depends on route, season, pickup and delivery access, vehicle type, paperwork, border requirements, weather, and carrier scheduling.

', 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?', '

You may leave:

Please do not leave food, pet food, alcohol, medication, or electronics in the vehicle.

', 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?', '

Vehicles travelling south are normally picked up on Friday or Saturday.

Vehicles returning north are normally picked up on Monday or Tuesday.

The driver will call you 1 to 2 days before pickup with an estimated arrival time.

', 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?', '

Yes, provided our 80-foot transport truck can safely enter and leave your street.

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.

The same rule applies when your vehicle is delivered.

', 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?', '

No. However, another adult must be there to meet the driver and inspect the vehicle with them.

Please enter that person’s name and telephone number in the Special Instructions section of the booking form.

The same rule applies when your vehicle is delivered.

', 40, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'), (12, 'snowbirds-payment', 'snowbirds', 'How can I pay?', '

E-transfer is preferred.

You may also pay by Visa or Mastercard. A 3% credit card fee will be added.

', 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?', '

Yes. You need a letter from the leasing company giving you permission to use the vehicle in the United States.

The letter should include the dates you will be travelling in Florida.

', 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?', '

Please request your quote as early as possible, especially for:

Pickup dates can be affected by seasonal demand, border requirements, the type of vehicle, and access to the pickup or delivery location.

', 70, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'), (15, 'snowbirds-insurance', 'snowbirds', 'What insurance coverage is provided?', '

Please read the Vehicle Shipping Agreement that was emailed to you when you booked.

It explains the insurance coverage, what to do if damage occurs, and how damage claims are handled.

', 80, 1, '2026-07-30 15:00:15', '2026-07-30 15:00:15'), (16, 'snowbirds-cancellation', 'snowbirds', 'What is the cancellation policy?', '

Please read the Vehicle Shipping Agreement that was emailed to you when you booked.

It explains cancellation deadlines and any fees that may apply when a booking is cancelled or changed.

', 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?', '

Most vehicles are delivered within 3 to 4 days after pickup.

Delays can sometimes happen. We will do our best to keep you informed if your delivery schedule changes.

', 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?', '

Call our office during regular business hours for an update on your vehicle.

', 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?', '

No. We use the same competitive pricing for every vehicle, regardless of how many vehicles you ship.

', 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; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;