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

START TRANSACTION;



--
-- Database: `eeptlhuq_database`
--

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

--
-- Table structure for table `cdb_address_shipments`
--

CREATE TABLE `cdb_address_shipments` (
  `id` int(11) NOT NULL,
  `order_track` varchar(350) DEFAULT NULL,
  `sender_address` varchar(300) DEFAULT NULL,
  `sender_country` varchar(300) DEFAULT NULL,
  `sender_city` varchar(300) DEFAULT NULL,
  `sender_zip_code` varchar(300) DEFAULT NULL,
  `recipient_address` varchar(300) DEFAULT NULL,
  `recipient_country` varchar(300) DEFAULT NULL,
  `recipient_city` varchar(300) DEFAULT NULL,
  `recipient_zip_code` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cdb_add_order`
--

CREATE TABLE `cdb_add_order` (
  `order_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `order_prefix` varchar(300) DEFAULT NULL,
  `order_no` varchar(350) DEFAULT NULL,
  `order_date` date DEFAULT NULL,
  `sender_id` int(11) DEFAULT NULL,
  `sender_address_id` int(11) DEFAULT NULL,
  `receiver_id` int(11) DEFAULT NULL,
  `receiver_address_id` int(11) DEFAULT NULL,
  `tax_value` float DEFAULT NULL,
  `tax_insurance_value` float DEFAULT NULL,
  `total_insured_value` float DEFAULT NULL,
  `tax_custom_tariffis_value` float DEFAULT NULL,
  `value_weight` float DEFAULT NULL,
  `declared_value` float DEFAULT NULL,
  `volumetric_percentage` varchar(300) DEFAULT NULL,
  `total_weight` float DEFAULT NULL,
  `sub_total` float DEFAULT NULL,
  `tax_discount` float DEFAULT NULL,
  `total_tax_insurance` float DEFAULT NULL,
  `total_tax_custom_tariffis` float DEFAULT NULL,
  `total_tax` float DEFAULT NULL,
  `total_declared_value` float DEFAULT NULL,
  `total_fixed_value` float DEFAULT NULL,
  `total_tax_discount` float DEFAULT NULL,
  `total_reexp` float DEFAULT NULL,
  `total_order` float DEFAULT NULL,
  `order_datetime` datetime DEFAULT NULL,
  `agency` int(11) DEFAULT NULL,
  `origin_off` int(11) DEFAULT NULL,
  `order_item_category` int(11) DEFAULT NULL,
  `order_package` int(11) DEFAULT NULL,
  `order_courier` int(11) DEFAULT NULL,
  `order_service_options` int(11) DEFAULT NULL,
  `order_deli_time` int(11) DEFAULT NULL,
  `order_pay_mode` int(11) DEFAULT NULL,
  `order_payment_method` int(11) DEFAULT NULL,
  `status_courier` int(11) DEFAULT NULL,
  `driver_id` int(11) DEFAULT NULL,
  `person_receives` varchar(300) DEFAULT NULL,
  `photo_delivered` varchar(300) DEFAULT NULL,
  `is_pickup` tinyint(1) DEFAULT 0,
  `is_consolidate` tinyint(1) DEFAULT 0,
  `due_date` date DEFAULT NULL,
  `status_invoice` int(11) DEFAULT NULL,
  `reason_cancel` mediumtext DEFAULT NULL,
  `order_incomplete` tinyint(4) DEFAULT 1,
  `url_payment_attach` varchar(500) DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `payment_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cdb_add_order_item`
--

CREATE TABLE `cdb_add_order_item` (
  `order_item_id` int(11) NOT NULL,
  `order_id` int(11) DEFAULT NULL,
  `order_item_description` varchar(250) DEFAULT NULL,
  `order_item_quantity` decimal(10,2) DEFAULT NULL,
  `order_item_weight` varchar(120) DEFAULT NULL,
  `order_item_length` varchar(120) DEFAULT NULL,
  `order_item_width` varchar(120) DEFAULT NULL,
  `order_item_height` varchar(120) DEFAULT NULL,
  `order_item_fixed_value` float DEFAULT NULL,
  `order_item_declared_value` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cdb_branchoffices`
--

CREATE TABLE `cdb_branchoffices` (
  `id` int(10) NOT NULL,
  `name_branch` varchar(100) DEFAULT NULL,
  `branch_address` varchar(120) DEFAULT NULL,
  `branch_city` varchar(100) DEFAULT NULL,
  `phone_branch` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdb_branchoffices`
--

INSERT INTO `cdb_branchoffices` (`id`, `name_branch`, `branch_address`, `branch_city`, `phone_branch`) VALUES
(4, 'Deprixa Miami', '1199 E Calaveras Blvd', 'MIami, 435345gt', '(669) 284-3100');

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

--
-- Table structure for table `cdb_category`
--

CREATE TABLE `cdb_category` (
  `id` int(5) NOT NULL,
  `name_item` varchar(120) DEFAULT NULL,
  `detail_item` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdb_category`
--

INSERT INTO `cdb_category` (`id`, `name_item`, `detail_item`) VALUES
(26, 'Air Freight', 'Air Freight, The Sky&#39;s the Limit'),
(27, 'Ocean Freight', 'Ocean Freight, The World is Your Oyster');

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

--
-- Table structure for table `cdb_charges_order`
--

CREATE TABLE `cdb_charges_order` (
  `id_charge` int(11) NOT NULL,
  `order_id` int(11) DEFAULT NULL,
  `charge_date` date DEFAULT NULL,
  `total` double(5,2) DEFAULT NULL,
  `number_reference` varchar(500) DEFAULT NULL,
  `payment_type` int(11) DEFAULT NULL,
  `note` varchar(500) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cdb_consolidate`
--

CREATE TABLE `cdb_consolidate` (
  `consolidate_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `c_prefix` varchar(300) DEFAULT NULL,
  `c_no` varchar(350) DEFAULT NULL,
  `c_date` date DEFAULT NULL,
  `sender_id` int(11) DEFAULT NULL,
  `sender_address_id` int(11) DEFAULT NULL,
  `receiver_id` int(11) DEFAULT NULL,
  `receiver_address_id` int(11) DEFAULT NULL,
  `tax_value` float DEFAULT NULL,
  `tax_insurance_value` float DEFAULT NULL,
  `total_insured_value` float DEFAULT NULL,
  `tax_custom_tariffis_value` float DEFAULT NULL,
  `value_weight` float DEFAULT NULL,
  `volumetric_percentage` varchar(300) DEFAULT NULL,
  `total_weight` float DEFAULT NULL,
  `sub_total` float DEFAULT NULL,
  `tax_discount` float DEFAULT NULL,
  `total_tax_insurance` float DEFAULT NULL,
  `total_tax_custom_tariffis` float DEFAULT NULL,
  `total_tax` float DEFAULT NULL,
  `total_tax_discount` float DEFAULT NULL,
  `total_reexp` float DEFAULT NULL,
  `total_order` float DEFAULT NULL,
  `order_datetime` datetime DEFAULT NULL,
  `agency` varchar(250) DEFAULT NULL,
  `origin_off` varchar(250) DEFAULT NULL,
  `order_package` varchar(250) DEFAULT NULL,
  `order_item_category` varchar(250) DEFAULT NULL,
  `order_courier` varchar(250) DEFAULT NULL,
  `order_service_options` varchar(250) DEFAULT NULL,
  `order_deli_time` varchar(250) DEFAULT NULL,
  `order_pay_mode` varchar(250) DEFAULT NULL,
  `status_courier` varchar(250) DEFAULT NULL,
  `driver_id` int(11) DEFAULT NULL,
  `person_receives` varchar(300) DEFAULT NULL,
  `photo_delivered` varchar(300) DEFAULT NULL,
  `seals_package` varchar(300) DEFAULT NULL,
  `status_invoice` int(11) DEFAULT NULL,
  `url_payment_attach` varchar(350) DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `payment_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cdb_consolidate_detail`
--

CREATE TABLE `cdb_consolidate_detail` (
  `detail_id` int(11) NOT NULL,
  `consolidate_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `order_prefix` varchar(300) DEFAULT NULL,
  `order_no` varchar(300) DEFAULT NULL,
  `weight` varchar(300) DEFAULT NULL,
  `length` varchar(300) DEFAULT NULL,
  `width` varchar(300) DEFAULT NULL,
  `height` varchar(300) DEFAULT NULL,
  `weight_vol` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cdb_countries`
--

CREATE TABLE `cdb_countries` (
  `id` int(10) UNSIGNED NOT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  `iso_3166_2` varchar(2) NOT NULL DEFAULT '',
  `iso_3166_3` varchar(3) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cdb_countries`
--

INSERT INTO `cdb_countries` (`id`, `full_name`, `iso_3166_2`, `iso_3166_3`, `name`) VALUES
(4, 'AirwayBill Number', 'AW', 'AWB', 'AWB'),
(8, 'Bill of Levy', 'BL', 'BL', 'BL');

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

--
-- Table structure for table `cdb_courier_com`
--

CREATE TABLE `cdb_courier_com` (
  `id` int(10) NOT NULL,
  `name_com` varchar(100) DEFAULT NULL,
  `address_cou` varchar(120) DEFAULT NULL,
  `phone_cou` varchar(20) DEFAULT NULL,
  `country_cou` varchar(100) DEFAULT NULL,
  `city_cou` varchar(100) DEFAULT NULL,
  `postal_cou` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdb_courier_com`
--

INSERT INTO `cdb_courier_com` (`id`, `name_com`, `address_cou`, `phone_cou`, `country_cou`, `city_cou`, `postal_cou`) VALUES
(93, 'Deprixa Express', 'claveland', '457435724', 'US', 'Miami, CA', '596'),
(94, 'Deprixa Delivery', '158/2 Hoang Hoa Tham, Phuong 12', '0908 287 882', 'Mi', 'hiat man set', '345345'),
(95, 'Deprixa EMS', 'HANG HOT SFAS', '2351346413', 'COPA', 'ANT', '324532');

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

--
-- Table structure for table `cdb_courier_track`
--

CREATE TABLE `cdb_courier_track` (
  `id` int(10) NOT NULL,
  `order_track` varchar(100) DEFAULT NULL,
  `t_dest` varchar(255) DEFAULT NULL,
  `t_city` varchar(250) DEFAULT NULL,
  `comments` varchar(255) DEFAULT NULL,
  `t_date` datetime DEFAULT NULL,
  `status_courier` int(11) DEFAULT NULL,
  `office_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cdb_customers_packages`
--

CREATE TABLE `cdb_customers_packages` (
  `order_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `order_prefix` varchar(300) DEFAULT NULL,
  `order_no` varchar(350) DEFAULT NULL,
  `order_date` date DEFAULT NULL,
  `sender_id` int(11) DEFAULT NULL,
  `sender_address_id` int(11) DEFAULT NULL,
  `tax_value` float DEFAULT NULL,
  `tax_insurance_value` float DEFAULT NULL,
  `total_insured_value` float DEFAULT NULL,
  `tax_custom_tariffis_value` float DEFAULT NULL,
  `value_weight` float DEFAULT NULL,
  `declared_value` float DEFAULT NULL,
  `volumetric_percentage` varchar(300) DEFAULT NULL,
  `total_weight` float DEFAULT NULL,
  `sub_total` float DEFAULT NULL,
  `tax_discount` float DEFAULT NULL,
  `total_tax_insurance` float DEFAULT NULL,
  `total_tax_custom_tariffis` float DEFAULT NULL,
  `total_tax` float DEFAULT NULL,
  `total_declared_value` float DEFAULT NULL,
  `total_fixed_value` float DEFAULT NULL,
  `total_tax_discount` float DEFAULT NULL,
  `total_reexp` float DEFAULT NULL,
  `total_order` float DEFAULT NULL,
  `order_datetime` datetime DEFAULT NULL,
  `agency` int(11) DEFAULT NULL,
  `origin_off` int(11) DEFAULT NULL,
  `order_package` int(11) DEFAULT NULL,
  `order_item_category` int(11) DEFAULT NULL,
  `order_courier` int(11) DEFAULT NULL,
  `order_service_options` int(11) DEFAULT NULL,
  `order_deli_time` int(11) DEFAULT NULL,
  `order_pay_mode` int(11) DEFAULT NULL,
  `order_payment_method` int(11) DEFAULT NULL,
  `status_courier` int(11) DEFAULT NULL,
  `driver_id` int(11) DEFAULT NULL,
  `person_receives` varchar(300) DEFAULT NULL,
  `photo_delivered` varchar(300) DEFAULT NULL,
  `status_invoice` int(11) DEFAULT NULL,
  `tracking_purchase` varchar(300) DEFAULT NULL,
  `provider_purchase` varchar(300) DEFAULT NULL,
  `price_purchase` double(5,2) DEFAULT NULL,
  `url_payment_attach` varchar(300) DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `payment_date` datetime DEFAULT NULL,
  `is_prealert` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdb_customers_packages`
--

INSERT INTO `cdb_customers_packages` (`order_id`, `user_id`, `order_prefix`, `order_no`, `order_date`, `sender_id`, `sender_address_id`, `tax_value`, `tax_insurance_value`, `total_insured_value`, `tax_custom_tariffis_value`, `value_weight`, `declared_value`, `volumetric_percentage`, `total_weight`, `sub_total`, `tax_discount`, `total_tax_insurance`, `total_tax_custom_tariffis`, `total_tax`, `total_declared_value`, `total_fixed_value`, `total_tax_discount`, `total_reexp`, `total_order`, `order_datetime`, `agency`, `origin_off`, `order_package`, `order_item_category`, `order_courier`, `order_service_options`, `order_deli_time`, `order_pay_mode`, `order_payment_method`, `status_courier`, `driver_id`, `person_receives`, `photo_delivered`, `status_invoice`, `tracking_purchase`, `provider_purchase`, `price_purchase`, `url_payment_attach`, `notes`, `payment_date`, `is_prealert`) VALUES
(26, 1, 'AWB', 'work...alaaaa', '2023-06-09', 15, 2, 17, 3, 100, 2.1, 3, 15, '5000', 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 3, '2023-06-09 11:07:16', 0, 0, 24, 26, 0, 0, 0, NULL, NULL, 7, 0, NULL, NULL, 2, 'zfsgfdsgdfgfdgs', '', 0.00, NULL, NULL, NULL, 0),
(27, 1, 'AWB', 'whastapapaaaa', '2023-06-09', 15, 2, 17, 3, 100, 2.1, 3, 15, '5000', 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 3, '2023-06-09 11:25:11', 0, 0, 24, 26, 0, 0, 0, NULL, NULL, 5, 0, NULL, NULL, 2, 'aaaaaaaaaa', '', 0.00, NULL, NULL, NULL, 0),
(28, 1, 'AWB', 'mcaanakacharger typec', '2023-06-09', 15, 2, 17, 3, 100, 2.1, 3, 15, '5000', 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 3, '2023-06-09 11:35:34', 0, 0, 24, 26, 0, 0, 0, NULL, NULL, 4, 0, NULL, NULL, 2, 'tryerywrt', '', 0.00, NULL, NULL, NULL, 0),
(29, 1, 'AWB', 'mbona', '2023-06-09', 15, 2, 17, 3, 100, 2.1, 3, 15, '5000', 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 3, '2023-06-09 11:54:53', 0, 0, 24, 26, 0, 0, 0, NULL, NULL, 5, 0, NULL, NULL, 2, 'zfsgfdsg', '', 0.00, NULL, NULL, NULL, 0),
(30, 1, 'AWB', 'kataandoutanijualeo', '2023-06-09', 15, 2, 17, 3, 100, 2.1, 3, 15, '5000', 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 3, '2023-06-09 12:22:10', 0, 0, 24, 26, 0, 0, 0, NULL, NULL, 8, 0, NULL, NULL, 2, 'aki yanani', '', 0.00, NULL, NULL, NULL, 0),
(31, 1, 'AWB', 'sasawwe', '2023-06-09', 15, 2, 17, 3, 100, 2.1, 3, 15, '5000', 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 3, '2023-06-09 12:25:19', 0, 0, 24, 26, 0, 0, 0, NULL, NULL, 6, 0, NULL, NULL, 2, 'huchiki kuniboo', '', 0.00, NULL, NULL, NULL, 0);

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

--
-- Table structure for table `cdb_customers_packages_detail`
--

CREATE TABLE `cdb_customers_packages_detail` (
  `order_item_id` int(11) NOT NULL,
  `order_id` int(11) DEFAULT NULL,
  `order_item_description` varchar(250) DEFAULT NULL,
  `order_item_quantity` varchar(300) DEFAULT NULL,
  `order_item_weight` varchar(120) DEFAULT NULL,
  `order_item_length` varchar(120) DEFAULT NULL,
  `order_item_width` varchar(120) DEFAULT NULL,
  `order_item_height` varchar(120) DEFAULT NULL,
  `order_item_fixed_value` float DEFAULT NULL,
  `order_item_declared_value` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cdb_customer_package_files`
--

CREATE TABLE `cdb_customer_package_files` (
  `id` int(11) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `date_file` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `file_type` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cdb_delivery_time`
--

CREATE TABLE `cdb_delivery_time` (
  `id` int(11) NOT NULL,
  `delitime` varchar(200) DEFAULT NULL,
  `detail` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdb_delivery_time`
--

INSERT INTO `cdb_delivery_time` (`id`, `delitime`, `detail`) VALUES
(12, 'DHL 7-10 DAYS', '7-10 DAYS'),
(13, 'TNT 10-14 DAYS', '10-14 DAYS');

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

--
-- Table structure for table `cdb_driver_files`
--

CREATE TABLE `cdb_driver_files` (
  `id` int(11) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `driver_id` int(11) DEFAULT NULL,
  `date_file` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `file_type` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cdb_email_templates`
--

CREATE TABLE `cdb_email_templates` (
  `id` int(5) NOT NULL,
  `name` varchar(200) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `help` text DEFAULT NULL,
  `body` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;




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

--
-- Table structure for table `cdb_incoterm`
--

CREATE TABLE `cdb_incoterm` (
  `id` int(11) NOT NULL,
  `inco_name` varchar(200) DEFAULT NULL,
  `detail` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdb_incoterm`
--

INSERT INTO `cdb_incoterm` (`id`, `inco_name`, `detail`) VALUES
(1, 'EXW', 'EXW - ExWorks'),
(2, 'FCA', 'FCA - Free Carrier'),
(3, 'FAS', 'FAS - Free Alongside Ship'),
(4, 'FOB', 'FOB - Free On Board'),
(5, 'CFR', 'CFR - Cost and Freight'),
(6, 'CIF', 'CIF - Cost, Insurance, Freight'),
(7, 'CIP', 'CIP - Carriage and Insurance Paid'),
(8, 'CPT', 'CPT - Carriage Paid To'),
(9, 'DAF', 'DAF - Delivered At Frontier'),
(10, 'DES', 'DES - Delivered Ex Ship'),
(11, 'DEQ', 'DEQ - Delivered Ex Quay'),
(12, 'DDU', 'DDU - Delivered Duty Unpaid'),
(13, 'DDP', 'DDP - Delivered Duty Paid'),
(14, 'DAT', 'DAT – Delivered at Terminal (named terminal at port or place of destination)'),
(15, 'DAP', 'DAP - Delivered At Place (named place of destination)');

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

--
-- Table structure for table `cdb_met_payment`
--

CREATE TABLE `cdb_met_payment` (
  `id` int(11) NOT NULL,
  `met_payment` varchar(200) DEFAULT NULL,
  `detail` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdb_met_payment`
--

INSERT INTO `cdb_met_payment` (`id`, `met_payment`, `detail`) VALUES
(1, 'Cash', 'Cash Payment'),
(2, 'Credit Card', 'Payment with Credit Card'),
(5, 'Wire Transfer', 'Payment with Wire transfer'),
(6, 'Paypal', 'Paypal');

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

--
-- Table structure for table `cdb_news`
--

CREATE TABLE `cdb_news` (
  `id` int(11) NOT NULL,
  `title` varchar(55) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `body` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `author` varchar(55) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `created` date NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `cdb_news`
--

INSERT INTO `cdb_news` (`id`, `title`, `body`, `author`, `created`, `active`) VALUES
(6, 'Welcome to our Client Area!', '&lt;p&gt;We are pleased to announce the new release DEPRIXA PRO v6.3.4.2&lt;br&gt;&lt;/p&gt;', 'Administrator', '2021-09-17', 1);

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

--
-- Table structure for table `cdb_notifications`
--

CREATE TABLE `cdb_notifications` (
  `notification_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `notification_description` varchar(350) DEFAULT NULL,
  `shipping_type` int(11) DEFAULT NULL,
  `notification_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cdb_notifications_users`
--

CREATE TABLE `cdb_notifications_users` (
  `id_notifi_user` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `notification_id` int(11) DEFAULT NULL,
  `notification_read` tinyint(1) DEFAULT 0,
  `notification_status` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cdb_offices`
--

CREATE TABLE `cdb_offices` (
  `id` int(10) NOT NULL,
  `name_off` varchar(100) DEFAULT NULL,
  `code_off` varchar(60) DEFAULT NULL,
  `address` varchar(120) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `phone_off` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdb_offices`
--

INSERT INTO `cdb_offices` (`id`, `name_off`, `code_off`, `address`, `city`, `phone_off`) VALUES
(86, 'Handled by Us', '001', '000000', 'Nairobi', '0101146023'),
(87, 'Approved', '002', '000000', 'Nairobi', '0101146023'),
(88, 'Handed over to another clearance company', '003', '000000', 'Nairobi', '0101146023'),
(91, 'Pending', '005', '000000', 'Nairobi', '0101146023');

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

--
-- Table structure for table `cdb_order_files`
--

CREATE TABLE `cdb_order_files` (
  `id` int(11) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `date_file` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `is_consolidate` int(11) DEFAULT 0,
  `file_type` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cdb_order_user_history`
--

CREATE TABLE `cdb_order_user_history` (
  `history_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `action` varchar(500) DEFAULT NULL,
  `date_history` datetime DEFAULT NULL,
  `is_consolidate` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cdb_packaging`
--

CREATE TABLE `cdb_packaging` (
  `id` int(5) NOT NULL,
  `name_pack` varchar(120) DEFAULT NULL,
  `detail_pack` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdb_packaging`
--

INSERT INTO `cdb_packaging` (`id`, `name_pack`, `detail_pack`) VALUES
(22, '40ft Reefer', '40 FT'),
(23, '40ft Dry', '40 FT'),
(24, '20ft Dry', '20ft'),
(25, 'N/A (Selected if Mode of Transport is Air)', 'Air'),
(26, '20ft Reefer', '20FT');

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

--
-- Table structure for table `cdb_payments_gateway`
--

CREATE TABLE `cdb_payments_gateway` (
  `id` int(11) NOT NULL,
  `order_track` varchar(300) DEFAULT NULL,
  `order_track_customer_id` int(11) DEFAULT NULL,
  `gateway` varchar(300) DEFAULT NULL,
  `payment_transaction` varchar(300) DEFAULT NULL,
  `amount` double(5,2) DEFAULT NULL,
  `status` varchar(300) DEFAULT NULL,
  `type_transaccition_courier` varchar(300) DEFAULT NULL,
  `currency` varchar(300) DEFAULT NULL,
  `date_payment` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cdb_payment_methods`
--

CREATE TABLE `cdb_payment_methods` (
  `id` int(11) NOT NULL,
  `label` varchar(200) DEFAULT NULL,
  `days` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cdb_payment_methods`
--

INSERT INTO `cdb_payment_methods` (`id`, `label`, `days`) VALUES
(1, 'Cash', 0),
(3, '15 day credit', 15),
(4, '5 day credit', 5);

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

--
-- Table structure for table `cdb_pre_alert`
--

CREATE TABLE `cdb_pre_alert` (
  `pre_alert_id` int(11) NOT NULL,
  `tracking` varchar(200) DEFAULT NULL,
  `provider_shop` varchar(200) DEFAULT NULL,
  `courier_com` int(11) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `purchase_price` double(5,2) DEFAULT NULL,
  `package_description` mediumtext DEFAULT NULL,
  `estimated_date` date DEFAULT NULL,
  `prealert_date` datetime DEFAULT NULL,
  `url_invoice` varchar(300) DEFAULT NULL,
  `is_package` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cdb_shipping_line`
--

CREATE TABLE `cdb_shipping_line` (
  `id` int(11) NOT NULL,
  `ship_line` varchar(200) DEFAULT NULL,
  `detail` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdb_shipping_line`
--

INSERT INTO `cdb_shipping_line` (`id`, `ship_line`, `detail`) VALUES
(1, 'Atlantic Container Line', 'Freight forwarding - Atlantic Container Line'),
(2, 'American President Lines', 'Freight forwarding - American President Lines (APL)'),
(3, 'Atlantic Ro-Ro Carriers', 'Atlantic Ro-Ro Carriers'),
(4, 'China Shipping', 'Freight forwarding - China Shipping'),
(5, 'CMA CGM', 'Freight forwarding - CMA CGM Group'),
(6, 'Evergreen Marine Corp.', 'Freight forwarding - Evergreen Marine Corp (EMC)'),
(7, 'Fesco Transportation Group', 'FESCO Transportation Group'),
(8, 'Hanjin Shipping', 'Hanjin Shipping - Container Carrier'),
(9, 'Hamburg Süd Group', 'Hamburg Süd Group - Ocean Freight'),
(10, 'Hapag Lloyd', 'Freight forwarding - Hapag-Lloyd'),
(11, 'Maersk Sealand', 'Freight forwarding - Maersk Line'),
(12, 'MSC Mediterranean Shipping Company', 'Freight forwarding - Mediterranean Shipping Company'),
(13, 'OOCL Logistics', 'OOCL Vessel &amp; Rail Tracking'),
(14, 'Safmarine', 'Safmarine Container Lines'),
(15, 'Zim Integrated Shipping Services', 'Freight forwarding - ZIM Integrated Shipping Services'),
(16, 'Wallenius Lines', 'Freight forwarding - Wallenius Logistics');

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

--
-- Table structure for table `cdb_shipping_mode`
--

CREATE TABLE `cdb_shipping_mode` (
  `id` int(11) NOT NULL,
  `ship_mode` varchar(200) DEFAULT NULL,
  `detail` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdb_shipping_mode`
--

INSERT INTO `cdb_shipping_mode` (`id`, `ship_mode`, `detail`) VALUES
(7, 'DEPRIXA Air', '2-3 DAYS'),
(8, 'Deprixa Container', '3-5 DAYS');

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

--
-- Table structure for table `cdb_styles`
--

CREATE TABLE `cdb_styles` (
  `id` int(11) NOT NULL,
  `mod_style` varchar(200) DEFAULT NULL,
  `detail` varchar(200) DEFAULT NULL,
  `color` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cdb_styles`
--

INSERT INTO `cdb_styles` (`id`, `mod_style`, `detail`, `color`) VALUES
(1, 'TE Application Received', 'TE Application Received', '#a3a3a3'),
(2, 'TE Submitted to MOFA', 'TE Submitted to MOFA', '#36bea6'),
(3, 'TE Approval Received from MOFA', 'TE Approval Received from MOFA', '#00e39a'),
(4, 'TE Submitted to Approving Ministry', 'TE Submitted to Approving Ministry', '#e0ce07'),
(5, 'TE Approval Received from Approving Ministry', 'TE Approval Received from Approving Ministry', '#cd88ee'),
(6, 'TE Submitted to Ministry of Finance', 'TE Submitted to Ministry of Finance', '#0ae4ff'),
(7, 'TE Approval Received from Ministry of Finance', 'TE Approval Received from Ministry of Finance', '#7460ee'),
(88, '(Selected if supplies is medical related)', 'Not Applicable (N/A)', '#7460ee');

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

--
-- Table structure for table `cdb_users_multiple_addresses`
--

CREATE TABLE `cdb_users_multiple_addresses` (
  `id_addresses` int(11) NOT NULL,
  `address` varchar(300) DEFAULT NULL,
  `country` varchar(300) DEFAULT NULL,
  `city` varchar(300) DEFAULT NULL,
  `zip_code` varchar(300) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cdb_users_multiple_addresses`
--

INSERT INTO `cdb_users_multiple_addresses` (`id_addresses`, `address`, `country`, `city`, `zip_code`, `user_id`) VALUES
(1, '000000', 'Kenya', 'Nairobi', '000000', 13),
(2, '000000', 'Kenya', 'Nairobi', '000000', 15),
(3, '000000', 'Kenya', 'Nairobi', '000000', 16);

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

--
-- Table structure for table `cdb_zone`
--

CREATE TABLE `cdb_zone` (
  `zone_id` int(10) NOT NULL,
  `country_code` char(2) NOT NULL,
  `zone_name` varchar(35) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `cdb_zone`
--

INSERT INTO `cdb_zone` (`zone_id`, `country_code`, `zone_name`) VALUES
(1, 'AD', 'Europe/Andorra'),
(2, 'AE', 'Asia/Dubai'),
(3, 'AF', 'Asia/Kabul'),
(4, 'AG', 'America/Antigua'),
(5, 'AI', 'America/Anguilla'),
(6, 'AL', 'Europe/Tirane'),
(7, 'AM', 'Asia/Yerevan'),
(8, 'AO', 'Africa/Luanda'),
(9, 'AQ', 'Antarctica/McMurdo'),
(10, 'AQ', 'Antarctica/Casey'),
(11, 'AQ', 'Antarctica/Davis'),
(12, 'AQ', 'Antarctica/DumontDUrville'),
(13, 'AQ', 'Antarctica/Mawson'),
(14, 'AQ', 'Antarctica/Palmer'),
(15, 'AQ', 'Antarctica/Rothera'),
(16, 'AQ', 'Antarctica/Syowa'),
(17, 'AQ', 'Antarctica/Troll'),
(18, 'AQ', 'Antarctica/Vostok'),
(19, 'AR', 'America/Argentina/Buenos_Aires'),
(20, 'AR', 'America/Argentina/Cordoba'),
(21, 'AR', 'America/Argentina/Salta'),
(22, 'AR', 'America/Argentina/Jujuy'),
(23, 'AR', 'America/Argentina/Tucuman'),
(24, 'AR', 'America/Argentina/Catamarca'),
(25, 'AR', 'America/Argentina/La_Rioja'),
(26, 'AR', 'America/Argentina/San_Juan'),
(27, 'AR', 'America/Argentina/Mendoza'),
(28, 'AR', 'America/Argentina/San_Luis'),
(29, 'AR', 'America/Argentina/Rio_Gallegos'),
(30, 'AR', 'America/Argentina/Ushuaia'),
(31, 'AS', 'Pacific/Pago_Pago'),
(32, 'AT', 'Europe/Vienna'),
(33, 'AU', 'Australia/Lord_Howe'),
(34, 'AU', 'Antarctica/Macquarie'),
(35, 'AU', 'Australia/Hobart'),
(36, 'AU', 'Australia/Currie'),
(37, 'AU', 'Australia/Melbourne'),
(38, 'AU', 'Australia/Sydney'),
(39, 'AU', 'Australia/Broken_Hill'),
(40, 'AU', 'Australia/Brisbane'),
(41, 'AU', 'Australia/Lindeman'),
(42, 'AU', 'Australia/Adelaide'),
(43, 'AU', 'Australia/Darwin'),
(44, 'AU', 'Australia/Perth'),
(45, 'AU', 'Australia/Eucla'),
(46, 'AW', 'America/Aruba'),
(47, 'AX', 'Europe/Mariehamn'),
(48, 'AZ', 'Asia/Baku'),
(49, 'BA', 'Europe/Sarajevo'),
(50, 'BB', 'America/Barbados'),
(51, 'BD', 'Asia/Dhaka'),
(52, 'BE', 'Europe/Brussels'),
(53, 'BF', 'Africa/Ouagadougou'),
(54, 'BG', 'Europe/Sofia'),
(55, 'BH', 'Asia/Bahrain'),
(56, 'BI', 'Africa/Bujumbura'),
(57, 'BJ', 'Africa/Porto-Novo'),
(58, 'BL', 'America/St_Barthelemy'),
(59, 'BM', 'Atlantic/Bermuda'),
(60, 'BN', 'Asia/Brunei'),
(61, 'BO', 'America/La_Paz'),
(62, 'BQ', 'America/Kralendijk'),
(63, 'BR', 'America/Noronha'),
(64, 'BR', 'America/Belem'),
(65, 'BR', 'America/Fortaleza'),
(66, 'BR', 'America/Recife'),
(67, 'BR', 'America/Araguaina'),
(68, 'BR', 'America/Maceio'),
(69, 'BR', 'America/Bahia'),
(70, 'BR', 'America/Sao_Paulo'),
(71, 'BR', 'America/Campo_Grande'),
(72, 'BR', 'America/Cuiaba'),
(73, 'BR', 'America/Santarem'),
(74, 'BR', 'America/Porto_Velho'),
(75, 'BR', 'America/Boa_Vista'),
(76, 'BR', 'America/Manaus'),
(77, 'BR', 'America/Eirunepe'),
(78, 'BR', 'America/Rio_Branco'),
(79, 'BS', 'America/Nassau'),
(80, 'BT', 'Asia/Thimphu'),
(81, 'BW', 'Africa/Gaborone'),
(82, 'BY', 'Europe/Minsk'),
(83, 'BZ', 'America/Belize'),
(84, 'CA', 'America/St_Johns'),
(85, 'CA', 'America/Halifax'),
(86, 'CA', 'America/Glace_Bay'),
(87, 'CA', 'America/Moncton'),
(88, 'CA', 'America/Goose_Bay'),
(89, 'CA', 'America/Blanc-Sablon'),
(90, 'CA', 'America/Toronto'),
(91, 'CA', 'America/Nipigon'),
(92, 'CA', 'America/Thunder_Bay'),
(93, 'CA', 'America/Iqaluit'),
(94, 'CA', 'America/Pangnirtung'),
(95, 'CA', 'America/Atikokan'),
(96, 'CA', 'America/Winnipeg'),
(97, 'CA', 'America/Rainy_River'),
(98, 'CA', 'America/Resolute'),
(99, 'CA', 'America/Rankin_Inlet'),
(100, 'CA', 'America/Regina'),
(101, 'CA', 'America/Swift_Current'),
(102, 'CA', 'America/Edmonton'),
(103, 'CA', 'America/Cambridge_Bay'),
(104, 'CA', 'America/Yellowknife'),
(105, 'CA', 'America/Inuvik'),
(106, 'CA', 'America/Creston'),
(107, 'CA', 'America/Dawson_Creek'),
(108, 'CA', 'America/Fort_Nelson'),
(109, 'CA', 'America/Vancouver'),
(110, 'CA', 'America/Whitehorse'),
(111, 'CA', 'America/Dawson'),
(112, 'CC', 'Indian/Cocos'),
(113, 'CD', 'Africa/Kinshasa'),
(114, 'CD', 'Africa/Lubumbashi'),
(115, 'CF', 'Africa/Bangui'),
(116, 'CG', 'Africa/Brazzaville'),
(117, 'CH', 'Europe/Zurich'),
(118, 'CI', 'Africa/Abidjan'),
(119, 'CK', 'Pacific/Rarotonga'),
(120, 'CL', 'America/Santiago'),
(121, 'CL', 'America/Punta_Arenas'),
(122, 'CL', 'Pacific/Easter'),
(123, 'CM', 'Africa/Douala'),
(124, 'CN', 'Asia/Shanghai'),
(125, 'CN', 'Asia/Urumqi'),
(126, 'CO', 'America/Bogota'),
(127, 'CR', 'America/Costa_Rica'),
(128, 'CU', 'America/Havana'),
(129, 'CV', 'Atlantic/Cape_Verde'),
(130, 'CW', 'America/Curacao'),
(131, 'CX', 'Indian/Christmas'),
(132, 'CY', 'Asia/Nicosia'),
(133, 'CY', 'Asia/Famagusta'),
(134, 'CZ', 'Europe/Prague'),
(135, 'DE', 'Europe/Berlin'),
(136, 'DE', 'Europe/Busingen'),
(137, 'DJ', 'Africa/Djibouti'),
(138, 'DK', 'Europe/Copenhagen'),
(139, 'DM', 'America/Dominica'),
(140, 'DO', 'America/Santo_Domingo'),
(141, 'DZ', 'Africa/Algiers'),
(142, 'EC', 'America/Guayaquil'),
(143, 'EC', 'Pacific/Galapagos'),
(144, 'EE', 'Europe/Tallinn'),
(145, 'EG', 'Africa/Cairo'),
(146, 'EH', 'Africa/El_Aaiun'),
(147, 'ER', 'Africa/Asmara'),
(148, 'ES', 'Europe/Madrid'),
(149, 'ES', 'Africa/Ceuta'),
(150, 'ES', 'Atlantic/Canary'),
(151, 'ET', 'Africa/Addis_Ababa'),
(152, 'FI', 'Europe/Helsinki'),
(153, 'FJ', 'Pacific/Fiji'),
(154, 'FK', 'Atlantic/Stanley'),
(155, 'FM', 'Pacific/Chuuk'),
(156, 'FM', 'Pacific/Pohnpei'),
(157, 'FM', 'Pacific/Kosrae'),
(158, 'FO', 'Atlantic/Faroe'),
(159, 'FR', 'Europe/Paris'),
(160, 'GA', 'Africa/Libreville'),
(161, 'GB', 'Europe/London'),
(162, 'GD', 'America/Grenada'),
(163, 'GE', 'Asia/Tbilisi'),
(164, 'GF', 'America/Cayenne'),
(165, 'GG', 'Europe/Guernsey'),
(166, 'GH', 'Africa/Accra'),
(167, 'GI', 'Europe/Gibraltar'),
(168, 'GL', 'America/Godthab'),
(169, 'GL', 'America/Danmarkshavn'),
(170, 'GL', 'America/Scoresbysund'),
(171, 'GL', 'America/Thule'),
(172, 'GM', 'Africa/Banjul'),
(173, 'GN', 'Africa/Conakry'),
(174, 'GP', 'America/Guadeloupe'),
(175, 'GQ', 'Africa/Malabo'),
(176, 'GR', 'Europe/Athens'),
(177, 'GS', 'Atlantic/South_Georgia'),
(178, 'GT', 'America/Guatemala'),
(179, 'GU', 'Pacific/Guam'),
(180, 'GW', 'Africa/Bissau'),
(181, 'GY', 'America/Guyana'),
(182, 'HK', 'Asia/Hong_Kong'),
(183, 'HN', 'America/Tegucigalpa'),
(184, 'HR', 'Europe/Zagreb'),
(185, 'HT', 'America/Port-au-Prince'),
(186, 'HU', 'Europe/Budapest'),
(187, 'ID', 'Asia/Jakarta'),
(188, 'ID', 'Asia/Pontianak'),
(189, 'ID', 'Asia/Makassar'),
(190, 'ID', 'Asia/Jayapura'),
(191, 'IE', 'Europe/Dublin'),
(192, 'IL', 'Asia/Jerusalem'),
(193, 'IM', 'Europe/Isle_of_Man'),
(194, 'IN', 'Asia/Kolkata'),
(195, 'IO', 'Indian/Chagos'),
(196, 'IQ', 'Asia/Baghdad'),
(197, 'IR', 'Asia/Tehran'),
(198, 'IS', 'Atlantic/Reykjavik'),
(199, 'IT', 'Europe/Rome'),
(200, 'JE', 'Europe/Jersey'),
(201, 'JM', 'America/Jamaica'),
(202, 'JO', 'Asia/Amman'),
(203, 'JP', 'Asia/Tokyo'),
(204, 'KE', 'Africa/Nairobi'),
(205, 'KG', 'Asia/Bishkek'),
(206, 'KH', 'Asia/Phnom_Penh'),
(207, 'KI', 'Pacific/Tarawa'),
(208, 'KI', 'Pacific/Enderbury'),
(209, 'KI', 'Pacific/Kiritimati'),
(210, 'KM', 'Indian/Comoro'),
(211, 'KN', 'America/St_Kitts'),
(212, 'KP', 'Asia/Pyongyang'),
(213, 'KR', 'Asia/Seoul'),
(214, 'KW', 'Asia/Kuwait'),
(215, 'KY', 'America/Cayman'),
(216, 'KZ', 'Asia/Almaty'),
(217, 'KZ', 'Asia/Qyzylorda'),
(218, 'KZ', 'Asia/Aqtobe'),
(219, 'KZ', 'Asia/Aqtau'),
(220, 'KZ', 'Asia/Atyrau'),
(221, 'KZ', 'Asia/Oral'),
(222, 'LA', 'Asia/Vientiane'),
(223, 'LB', 'Asia/Beirut'),
(224, 'LC', 'America/St_Lucia'),
(225, 'LI', 'Europe/Vaduz'),
(226, 'LK', 'Asia/Colombo'),
(227, 'LR', 'Africa/Monrovia'),
(228, 'LS', 'Africa/Maseru'),
(229, 'LT', 'Europe/Vilnius'),
(230, 'LU', 'Europe/Luxembourg'),
(231, 'LV', 'Europe/Riga'),
(232, 'LY', 'Africa/Tripoli'),
(233, 'MA', 'Africa/Casablanca'),
(234, 'MC', 'Europe/Monaco'),
(235, 'MD', 'Europe/Chisinau'),
(236, 'ME', 'Europe/Podgorica'),
(237, 'MF', 'America/Marigot'),
(238, 'MG', 'Indian/Antananarivo'),
(239, 'MH', 'Pacific/Majuro'),
(240, 'MH', 'Pacific/Kwajalein'),
(241, 'MK', 'Europe/Skopje'),
(242, 'ML', 'Africa/Bamako'),
(243, 'MM', 'Asia/Yangon'),
(244, 'MN', 'Asia/Ulaanbaatar'),
(245, 'MN', 'Asia/Hovd'),
(246, 'MN', 'Asia/Choibalsan'),
(247, 'MO', 'Asia/Macau'),
(248, 'MP', 'Pacific/Saipan'),
(249, 'MQ', 'America/Martinique'),
(250, 'MR', 'Africa/Nouakchott'),
(251, 'MS', 'America/Montserrat'),
(252, 'MT', 'Europe/Malta'),
(253, 'MU', 'Indian/Mauritius'),
(254, 'MV', 'Indian/Maldives'),
(255, 'MW', 'Africa/Blantyre'),
(256, 'MX', 'America/Mexico_City'),
(257, 'MX', 'America/Cancun'),
(258, 'MX', 'America/Merida'),
(259, 'MX', 'America/Monterrey'),
(260, 'MX', 'America/Matamoros'),
(261, 'MX', 'America/Mazatlan'),
(262, 'MX', 'America/Chihuahua'),
(263, 'MX', 'America/Ojinaga'),
(264, 'MX', 'America/Hermosillo'),
(265, 'MX', 'America/Tijuana'),
(266, 'MX', 'America/Bahia_Banderas'),
(267, 'MY', 'Asia/Kuala_Lumpur'),
(268, 'MY', 'Asia/Kuching'),
(269, 'MZ', 'Africa/Maputo'),
(270, 'NA', 'Africa/Windhoek'),
(271, 'NC', 'Pacific/Noumea'),
(272, 'NE', 'Africa/Niamey'),
(273, 'NF', 'Pacific/Norfolk'),
(274, 'NG', 'Africa/Lagos'),
(275, 'NI', 'America/Managua'),
(276, 'NL', 'Europe/Amsterdam'),
(277, 'NO', 'Europe/Oslo'),
(278, 'NP', 'Asia/Kathmandu'),
(279, 'NR', 'Pacific/Nauru'),
(280, 'NU', 'Pacific/Niue'),
(281, 'NZ', 'Pacific/Auckland'),
(282, 'NZ', 'Pacific/Chatham'),
(283, 'OM', 'Asia/Muscat'),
(284, 'PA', 'America/Panama'),
(285, 'PE', 'America/Lima'),
(286, 'PF', 'Pacific/Tahiti'),
(287, 'PF', 'Pacific/Marquesas'),
(288, 'PF', 'Pacific/Gambier'),
(289, 'PG', 'Pacific/Port_Moresby'),
(290, 'PG', 'Pacific/Bougainville'),
(291, 'PH', 'Asia/Manila'),
(292, 'PK', 'Asia/Karachi'),
(293, 'PL', 'Europe/Warsaw'),
(294, 'PM', 'America/Miquelon'),
(295, 'PN', 'Pacific/Pitcairn'),
(296, 'PR', 'America/Puerto_Rico'),
(297, 'PS', 'Asia/Gaza'),
(298, 'PS', 'Asia/Hebron'),
(299, 'PT', 'Europe/Lisbon'),
(300, 'PT', 'Atlantic/Madeira'),
(301, 'PT', 'Atlantic/Azores'),
(302, 'PW', 'Pacific/Palau'),
(303, 'PY', 'America/Asuncion'),
(304, 'QA', 'Asia/Qatar'),
(305, 'RE', 'Indian/Reunion'),
(306, 'RO', 'Europe/Bucharest'),
(307, 'RS', 'Europe/Belgrade'),
(308, 'RU', 'Europe/Kaliningrad'),
(309, 'RU', 'Europe/Moscow'),
(310, 'RU', 'Europe/Simferopol'),
(311, 'RU', 'Europe/Volgograd'),
(312, 'RU', 'Europe/Kirov'),
(313, 'RU', 'Europe/Astrakhan'),
(314, 'RU', 'Europe/Saratov'),
(315, 'RU', 'Europe/Ulyanovsk'),
(316, 'RU', 'Europe/Samara'),
(317, 'RU', 'Asia/Yekaterinburg'),
(318, 'RU', 'Asia/Omsk'),
(319, 'RU', 'Asia/Novosibirsk'),
(320, 'RU', 'Asia/Barnaul'),
(321, 'RU', 'Asia/Tomsk'),
(322, 'RU', 'Asia/Novokuznetsk'),
(323, 'RU', 'Asia/Krasnoyarsk'),
(324, 'RU', 'Asia/Irkutsk'),
(325, 'RU', 'Asia/Chita'),
(326, 'RU', 'Asia/Yakutsk'),
(327, 'RU', 'Asia/Khandyga'),
(328, 'RU', 'Asia/Vladivostok'),
(329, 'RU', 'Asia/Ust-Nera'),
(330, 'RU', 'Asia/Magadan'),
(331, 'RU', 'Asia/Sakhalin'),
(332, 'RU', 'Asia/Srednekolymsk'),
(333, 'RU', 'Asia/Kamchatka'),
(334, 'RU', 'Asia/Anadyr'),
(335, 'RW', 'Africa/Kigali'),
(336, 'SA', 'Asia/Riyadh'),
(337, 'SB', 'Pacific/Guadalcanal'),
(338, 'SC', 'Indian/Mahe'),
(339, 'SD', 'Africa/Khartoum'),
(340, 'SE', 'Europe/Stockholm'),
(341, 'SG', 'Asia/Singapore'),
(342, 'SH', 'Atlantic/St_Helena'),
(343, 'SI', 'Europe/Ljubljana'),
(344, 'SJ', 'Arctic/Longyearbyen'),
(345, 'SK', 'Europe/Bratislava'),
(346, 'SL', 'Africa/Freetown'),
(347, 'SM', 'Europe/San_Marino'),
(348, 'SN', 'Africa/Dakar'),
(349, 'SO', 'Africa/Mogadishu'),
(350, 'SR', 'America/Paramaribo'),
(351, 'SS', 'Africa/Juba'),
(352, 'ST', 'Africa/Sao_Tome'),
(353, 'SV', 'America/El_Salvador'),
(354, 'SX', 'America/Lower_Princes'),
(355, 'SY', 'Asia/Damascus'),
(356, 'SZ', 'Africa/Mbabane'),
(357, 'TC', 'America/Grand_Turk'),
(358, 'TD', 'Africa/Ndjamena'),
(359, 'TF', 'Indian/Kerguelen'),
(360, 'TG', 'Africa/Lome'),
(361, 'TH', 'Asia/Bangkok'),
(362, 'TJ', 'Asia/Dushanbe'),
(363, 'TK', 'Pacific/Fakaofo'),
(364, 'TL', 'Asia/Dili'),
(365, 'TM', 'Asia/Ashgabat'),
(366, 'TN', 'Africa/Tunis'),
(367, 'TO', 'Pacific/Tongatapu'),
(368, 'TR', 'Europe/Istanbul'),
(369, 'TT', 'America/Port_of_Spain'),
(370, 'TV', 'Pacific/Funafuti'),
(371, 'TW', 'Asia/Taipei'),
(372, 'TZ', 'Africa/Dar_es_Salaam'),
(373, 'UA', 'Europe/Kiev'),
(374, 'UA', 'Europe/Uzhgorod'),
(375, 'UA', 'Europe/Zaporozhye'),
(376, 'UG', 'Africa/Kampala'),
(377, 'UM', 'Pacific/Midway'),
(378, 'UM', 'Pacific/Wake'),
(379, 'US', 'America/New_York'),
(380, 'US', 'America/Detroit'),
(381, 'US', 'America/Kentucky/Louisville'),
(382, 'US', 'America/Kentucky/Monticello'),
(383, 'US', 'America/Indiana/Indianapolis'),
(384, 'US', 'America/Indiana/Vincennes'),
(385, 'US', 'America/Indiana/Winamac'),
(386, 'US', 'America/Indiana/Marengo'),
(387, 'US', 'America/Indiana/Petersburg'),
(388, 'US', 'America/Indiana/Vevay'),
(389, 'US', 'America/Chicago'),
(390, 'US', 'America/Indiana/Tell_City'),
(391, 'US', 'America/Indiana/Knox'),
(392, 'US', 'America/Menominee'),
(393, 'US', 'America/North_Dakota/Center'),
(394, 'US', 'America/North_Dakota/New_Salem'),
(395, 'US', 'America/North_Dakota/Beulah'),
(396, 'US', 'America/Denver'),
(397, 'US', 'America/Boise'),
(398, 'US', 'America/Phoenix'),
(399, 'US', 'America/Los_Angeles'),
(400, 'US', 'America/Anchorage'),
(401, 'US', 'America/Juneau'),
(402, 'US', 'America/Sitka'),
(403, 'US', 'America/Metlakatla'),
(404, 'US', 'America/Yakutat'),
(405, 'US', 'America/Nome'),
(406, 'US', 'America/Adak'),
(407, 'US', 'Pacific/Honolulu'),
(408, 'UY', 'America/Montevideo'),
(409, 'UZ', 'Asia/Samarkand'),
(410, 'UZ', 'Asia/Tashkent'),
(411, 'VA', 'Europe/Vatican'),
(412, 'VC', 'America/St_Vincent'),
(413, 'VE', 'America/Caracas'),
(414, 'VG', 'America/Tortola'),
(415, 'VI', 'America/St_Thomas'),
(416, 'VN', 'Asia/Ho_Chi_Minh'),
(417, 'VU', 'Pacific/Efate'),
(418, 'WF', 'Pacific/Wallis'),
(419, 'WS', 'Pacific/Apia'),
(420, 'YE', 'Asia/Aden'),
(421, 'YT', 'Indian/Mayotte'),
(422, 'ZA', 'Africa/Johannesburg'),
(423, 'ZM', 'Africa/Lusaka'),
(424, 'ZW', 'Africa/Harare');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `cdb_add_order`
--
ALTER TABLE `cdb_add_order`
  ADD PRIMARY KEY (`order_id`);

--
-- Indexes for table `cdb_add_order_item`
--
ALTER TABLE `cdb_add_order_item`
  ADD PRIMARY KEY (`order_item_id`);

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

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

--
-- Indexes for table `cdb_charges_order`
--
ALTER TABLE `cdb_charges_order`
  ADD PRIMARY KEY (`id_charge`);

--
-- Indexes for table `cdb_consolidate`
--
ALTER TABLE `cdb_consolidate`
  ADD PRIMARY KEY (`consolidate_id`);

--
-- Indexes for table `cdb_consolidate_detail`
--
ALTER TABLE `cdb_consolidate_detail`
  ADD PRIMARY KEY (`detail_id`);

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

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

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

--
-- Indexes for table `cdb_customers_packages`
--
ALTER TABLE `cdb_customers_packages`
  ADD PRIMARY KEY (`order_id`);

--
-- Indexes for table `cdb_customers_packages_detail`
--
ALTER TABLE `cdb_customers_packages_detail`
  ADD PRIMARY KEY (`order_item_id`);

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

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

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

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

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

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

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

--
-- Indexes for table `cdb_notifications`
--
ALTER TABLE `cdb_notifications`
  ADD PRIMARY KEY (`notification_id`);

--
-- Indexes for table `cdb_notifications_users`
--
ALTER TABLE `cdb_notifications_users`
  ADD PRIMARY KEY (`id_notifi_user`);

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

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

--
-- Indexes for table `cdb_order_user_history`
--
ALTER TABLE `cdb_order_user_history`
  ADD PRIMARY KEY (`history_id`);

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

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

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

--
-- Indexes for table `cdb_pre_alert`
--
ALTER TABLE `cdb_pre_alert`
  ADD PRIMARY KEY (`pre_alert_id`);

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

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

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

--
-- Indexes for table `cdb_users_multiple_addresses`
--
ALTER TABLE `cdb_users_multiple_addresses`
  ADD PRIMARY KEY (`id_addresses`);

--
-- Indexes for table `cdb_zone`
--
ALTER TABLE `cdb_zone`
  ADD PRIMARY KEY (`zone_id`),
  ADD KEY `idx_country_code` (`country_code`),
  ADD KEY `idx_zone_name` (`zone_name`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cdb_address_shipments`
--
ALTER TABLE `cdb_address_shipments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `cdb_add_order`
--
ALTER TABLE `cdb_add_order`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cdb_add_order_item`
--
ALTER TABLE `cdb_add_order_item`
  MODIFY `order_item_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cdb_branchoffices`
--
ALTER TABLE `cdb_branchoffices`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cdb_category`
--
ALTER TABLE `cdb_category`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `cdb_charges_order`
--
ALTER TABLE `cdb_charges_order`
  MODIFY `id_charge` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cdb_consolidate`
--
ALTER TABLE `cdb_consolidate`
  MODIFY `consolidate_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cdb_consolidate_detail`
--
ALTER TABLE `cdb_consolidate_detail`
  MODIFY `detail_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cdb_courier_com`
--
ALTER TABLE `cdb_courier_com`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=96;

--
-- AUTO_INCREMENT for table `cdb_courier_track`
--
ALTER TABLE `cdb_courier_track`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89;

--
-- AUTO_INCREMENT for table `cdb_customers_packages`
--
ALTER TABLE `cdb_customers_packages`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `cdb_customers_packages_detail`
--
ALTER TABLE `cdb_customers_packages_detail`
  MODIFY `order_item_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `cdb_customer_package_files`
--
ALTER TABLE `cdb_customer_package_files`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cdb_delivery_time`
--
ALTER TABLE `cdb_delivery_time`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `cdb_driver_files`
--
ALTER TABLE `cdb_driver_files`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cdb_email_templates`
--
ALTER TABLE `cdb_email_templates`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `cdb_incoterm`
--
ALTER TABLE `cdb_incoterm`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `cdb_met_payment`
--
ALTER TABLE `cdb_met_payment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `cdb_news`
--
ALTER TABLE `cdb_news`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `cdb_notifications`
--
ALTER TABLE `cdb_notifications`
  MODIFY `notification_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=90;

--
-- AUTO_INCREMENT for table `cdb_notifications_users`
--
ALTER TABLE `cdb_notifications_users`
  MODIFY `id_notifi_user` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=266;

--
-- AUTO_INCREMENT for table `cdb_offices`
--
ALTER TABLE `cdb_offices`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;

--
-- AUTO_INCREMENT for table `cdb_order_files`
--
ALTER TABLE `cdb_order_files`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cdb_order_user_history`
--
ALTER TABLE `cdb_order_user_history`
  MODIFY `history_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cdb_packaging`
--
ALTER TABLE `cdb_packaging`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `cdb_payments_gateway`
--
ALTER TABLE `cdb_payments_gateway`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cdb_payment_methods`
--
ALTER TABLE `cdb_payment_methods`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `cdb_pre_alert`
--
ALTER TABLE `cdb_pre_alert`
  MODIFY `pre_alert_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cdb_shipping_line`
--
ALTER TABLE `cdb_shipping_line`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `cdb_shipping_mode`
--
ALTER TABLE `cdb_shipping_mode`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `cdb_styles`
--
ALTER TABLE `cdb_styles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=89;

--
-- AUTO_INCREMENT for table `cdb_users_multiple_addresses`
--
ALTER TABLE `cdb_users_multiple_addresses`
  MODIFY `id_addresses` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `cdb_zone`
--
ALTER TABLE `cdb_zone`
  MODIFY `zone_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=425;
COMMIT;

