-- 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;

--
-- Dumping data for table `cdb_email_templates`
--

INSERT INTO `cdb_email_templates` (`id`, `name`, `subject`, `help`, `body`) VALUES
(1, 'New consolidate notification', 'Consolidate', 'This template is used to notify the shipment of consolidated.', '                                                                                                           \r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#f62d51\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\"></td></tr>\r\n            \r\n            <tr height=\"15\"></tr>\r\n           <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hello!\r\n              </td>\r\n           </tr>\r\n           <tr><td style=\"font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;\">\r\n             [NAME], \r\n¡Sending a consolidate to you!\r\n            </td>\r\n           </tr><tr height=\"30\"></tr>\r\n            <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\">\r\n         \r\n                <br><br>\r\n                Tracking number: <b>[TRACKING]</b>\r\n                <br>\r\n                Shipping date: <b>[DELIVERY_TIME]</b>\r\n                                                                <br><br>\r\n                                                                Follow up on your consolidate by entering the following link and you will have detailed information on the status of your shipments. <br>\r\n                <br><br>\r\n                <br><br>\r\n                <a href=\"[URL_SHIP]\">Click to see consolidate tracking</a>\r\n                \r\n                <br><br><br>\r\n                Thank you,<br>\r\n                [SITE_NAME] Team,<br>\r\n               <a href=\"[URL]\">[URL]</a>\r\n             </td>\r\n           </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                \r\nTo reply to this message, you can simply reply to this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n                   '),
(2, 'I forgot my email password', 'Password Reset', 'This template is used to recover lost user password.', '                                             \r\n\r\n\r\n\r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#f62d51\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><br><br><br>\r\n                Thanks,<br>\r\n               [SITE_NAME] Team,<br><a href=\"[URL]\">[URL]</a><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\"></td></tr>\r\n            \r\n            <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hi!\r\n             </td>\r\n           </tr>\r\n           <tr><td style=\"font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;\">\r\n             <strong>[USERNAME]</strong>\r\n           </td>\r\n           </tr><tr height=\"30\"></tr>\r\n            <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\">\r\n               You\'re now a member of [SITE_NAME].\r\n                <br>\r\n                It seems that you or someone requested a new password for you.\r\n                We have generated a new password, as requested:\r\n               <br><br>\r\n                Your new password: <b>[PASSWORD]</b>\r\n                <br><br>\r\n                To use the new password you need to activate it. To do this click the link provided below and login with your new password.\r\n               <br><br>\r\n                <a href=\"[LINK]\">[LINK]</a><br>\r\n               <br><br>\r\n                You can change your password after you sign in.<hr>\r\n               Password requested from IP: [IP]</td>\r\n               \r\n                \r\n              \r\n            </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                To reply to this message you can simply reply this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n \r\n\r\n                                          '),
(3, 'Welcome Mail From Admin', 'You have been registered', 'This template is used to send welcome email, when user is added by administrator', '                                              &lt;!doctype html&gt;\r\n&lt;html&gt;\r\n\r\n&lt;head&gt;\r\n&lt;link href=&#039;https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600&#039; rel=&#039;stylesheet&#039; type=&#039;text/css&#039;&gt;\r\n&lt;/head&gt;\r\n\r\n&lt;body style=&#039;margin: 0; padding: 20px; font-family: Montserrat, Arial, sans serif; font-size: 12px;font-weight:400;word-break: break-word;color:#555;line-height: 18px;&#039;&gt;\r\n  &lt;table border=&#039;0&#039; cellpadding=&#039;0&#039; cellspacing=&#039;0&#039; width=&#039;100%&#039;&gt;\r\n   &lt;table align=&#039;center&#039; border=&#039;0&#039; cellpadding=&#039;0&#039; cellspacing=&#039;0&#039; width=&#039;100%&#039; style=&#039;max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;&#039;&gt; \r\n\r\n      &lt;tr bgcolor=&#039;#f62d51&#039; height=&#039;5px&#039;&gt;\r\n       &lt;td align=&#039;center&#039; style=&#039;font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;&#039;&gt;\r\n       &lt;/td&gt;\r\n     &lt;/tr&gt;\r\n     &lt;tr bgcolor=&#039;#f9f9f9&#039;&gt;\r\n        &lt;td style=&#039;padding:40px;&#039;&gt;\r\n          &lt;table border=&#039;0&#039; cellpadding=&#039;0&#039; cellspacing=&#039;0&#039; width=&#039;100%&#039;&gt;\r\n           &lt;tr&gt;&lt;td&gt;&lt;img src=&quot;[URL]/assets/uploads/logo.png&quot; class=&quot;logo&quot;/&gt;&lt;/td&gt;&lt;/tr&gt;\r\n           &lt;br&gt;&lt;br&gt;\r\n            &lt;tr height=&#039;30&#039;&gt;&lt;/tr&gt;\r\n           &lt;tr&gt;\r\n              &lt;td style=&#039;font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:17px; font-weight:400;&#039;&gt;\r\n              Hi! [NAME]!, Welcome You have been Registered\r\n             &lt;/td&gt;\r\n           &lt;/tr&gt;\r\n           &lt;tr height=&#039;15&#039;&gt;&lt;/tr&gt;\r\n           &lt;td style=&#039;font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;&#039;&gt;\r\n             You&#039;re now a member of [SITE_NAME].\r\n            &lt;/td&gt;\r\n           &lt;tr height=&#039;30&#039;&gt;&lt;/tr&gt;\r\n           &lt;tr&gt;\r\n              &lt;td style=&quot;margin: 40px 0;line-height: 22px; font-family: &#039;Montserrat&#039;, Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;&quot;&gt;\r\n               Here are your login details. Please keep them in a safe place:\r\n                &lt;br&gt;&lt;br&gt;\r\n                Username: &lt;b&gt;[USERNAME]&lt;/b&gt;\r\n               &lt;br&gt;\r\n                Password: &lt;b&gt;[PASSWORD]&lt;/b&gt;               \r\n                &lt;br&gt;&lt;br&gt;&lt;br&gt;\r\n                Thanks,&lt;br&gt;\r\n               [SITE_NAME] Team,&lt;br&gt;\r\n               &lt;a href=&quot;[URL]&quot;&gt;[URL]&lt;/a&gt;&lt;/em&gt;&lt;/td&gt;\r\n             &lt;/td&gt;\r\n           &lt;/tr&gt;\r\n           &lt;tr height=&#039;50&#039;&gt;&lt;/tr&gt;\r\n           &lt;tr&gt;\r\n              &lt;td style=&#039;margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;&#039;&gt;\r\n                To reply to this message you can simply reply this email.\r\n             &lt;/td&gt;\r\n           &lt;/tr&gt;\r\n         &lt;/table&gt;\r\n        &lt;/td&gt;\r\n     &lt;/tr&gt;\r\n   &lt;/table&gt; \r\n &lt;/table&gt;\r\n&lt;/body&gt;\r\n&lt;/html&gt;                                          '),
(4, 'Default mail', 'Newsletter', 'This is a default newsletter template.', '                                             &lt;link href=&quot;https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot;&gt; &lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;&gt;   &lt;/table&gt;&lt;table align=&quot;center&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot; style=&quot;max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;&quot;&gt;       &lt;tbody&gt;&lt;tr bgcolor=&quot;#f62d51&quot; height=&quot;5px&quot;&gt;        &lt;td align=&quot;center&quot; style=&quot;font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;&quot;&gt;       &lt;/td&gt;     &lt;/tr&gt;     &lt;tr bgcolor=&quot;#f9f9f9&quot;&gt;        &lt;td style=&quot;padding:40px;&quot;&gt;          &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;&gt;           &lt;tbody&gt;&lt;tr&gt;&lt;td&gt;&lt;img src=&quot;[URL]/assets/uploads/logo.png&quot; class=&quot;logo&quot;&gt;&lt;/td&gt;&lt;/tr&gt;                       &lt;tr height=&quot;15&quot;&gt;&lt;/tr&gt;           &lt;tr&gt;              &lt;td style=&quot;font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;&quot;&gt;              Hello! [NAME]!              &lt;/td&gt;           &lt;/tr&gt;           &lt;tr height=&quot;30&quot;&gt;&lt;/tr&gt;           &lt;tr&gt;              &lt;td style=&quot;margin: 40px 0;line-height: 22px; font-family: &#039;Montserrat&#039;, Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;&quot;&gt;               You are now a member of [SITE_NAME].                                &lt;br&gt;&lt;br&gt;                  You are receiving this email as part of your newsletter subscription.                 &lt;hr&gt;                  Here is the content of your newsletter                  &lt;hr&gt;                &lt;br&gt;&lt;br&gt;&lt;br&gt;                Thank you,&lt;br&gt;                [SITE_NAME] Team,&lt;br&gt;               &lt;a href=&quot;[URL]&quot;&gt;[URL]&lt;/a&gt;&lt;/td&gt;                          &lt;/tr&gt;           &lt;tr height=&quot;50&quot;&gt;&lt;/tr&gt;           &lt;tr&gt;              &lt;td style=&quot;margin: 40px 0px; line-height: 22px; word-break: break-word; padding-top: 10px; border-top: 1px solid rgb(226, 226, 226);&quot;&gt;&lt;font face=&quot;Montserrat, Arial, sans serif&quot;&gt;&lt;span style=&quot;font-size: 11px;&quot;&gt;&lt;i&gt;To stop receiving future newsletters, log in to your account and uncheck the newsletter subscription box.&lt;/i&gt;&lt;/span&gt;&lt;/font&gt;&lt;br&gt;&lt;br&gt;&lt;font face=&quot;Montserrat, Arial, sans serif&quot;&gt;&lt;span style=&quot;font-size: 12px;&quot;&gt;To reply to this message, you can simply reply to this email.&lt;/span&gt;&lt;/font&gt;&lt;br&gt;&lt;/td&gt;            &lt;/tr&gt;         &lt;/tbody&gt;&lt;/table&gt;        &lt;/td&gt;     &lt;/tr&gt;   &lt;/tbody&gt;&lt;/table&gt;                                                                      '),
(7, 'Welcome customer registration', 'Thank you for signing up for Deprixa Pro', 'This template is used to welcome newly registered user when Configuration->Registration Verification and Configuration->Auto Registration are both set to YES', '                                                                                                                                                                               <table style=\"font-family: Roboto,RobotoDraft,Helvetica,Arial,sans-serif; justify-content: center;align-items: center;font-weight: 600; max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\" align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n <tbody>\r\n   <tr>\r\n      <td class=\"m_-8364453557841243647logo\">\r\n       <a href=\"https://colbox.online\">\r\n          <img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\">\r\n       </a>          \r\n      </td>\r\n   </tr>\r\n   <tr>\r\n      <td>\r\n        <table border=\"0\" width=\"100%\" height=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n         <tbody>\r\n           <tr>\r\n              <td style=\"height:5px;width:100%;background:#ff636f\"></td>\r\n            </tr>\r\n         </tbody>\r\n        </table>\r\n      </td>\r\n   </tr>\r\n   <tr style=\"background:#f9f9f9\">\r\n     <td class=\"m_-8364453557841243647container-padding\" bgcolor=\"#fff\" style=\"background-color:#fff;padding-left:30px;padding-right:30px\">\r\n        <br><br>\r\n        <p>\r\n         [NAME]! Thanks for registering. \r\n        </p>\r\n\r\n        <p>\r\n         Great news! Your account has been activated and you can start shopping online using your US shipping address.\r\n       </p>\r\n\r\n        <table class=\"m_-8364453557841243647table\">\r\n         <tbody>\r\n           <tr>\r\n              <td class=\"m_-8364453557841243647first\">\r\n                You are now a member of [SITE_NAME].\r\n                <br>\r\n                Here are your login details. Keep them in a safe place:\r\n               <br><br>\r\n                Username: <b>[USERNAME]</b>\r\n               <br>\r\n                Password: <b>[PASSWORD]</b>\r\n               <br><br><br>\r\n              </td>\r\n             \r\n            </tr>\r\n         </tbody>\r\n        </table>\r\n\r\n        <p>Locker Address:</p>\r\n        \r\n        <table class=\"m_-8364453557841243647table\">\r\n         <tbody>\r\n           <tr>\r\n              <td class=\"m_-8364453557841243647first\"> Full name:</td>\r\n              <td><strong>[NAME]</strong></td>\r\n            </tr>\r\n\r\n           <tr>\r\n              <td class=\"m_-8364453557841243647first\">Direction Line 1:</td>\r\n              <td><strong>[VIRTUAL_LOCKER]</strong></td>\r\n            </tr>\r\n\r\n           <tr>\r\n              <td class=\"m_-8364453557841243647first\">Address line 2:</td>\r\n              <td><strong>[LOCKER]</strong></td>\r\n            </tr>\r\n\r\n           <tr>\r\n              <td class=\"m_-8364453557841243647first\">City:</td>\r\n              <td><strong>[CCOUNTRY]</strong></td>\r\n            </tr>\r\n\r\n           <tr>\r\n              <td class=\"m_-8364453557841243647first\">State:</td>\r\n             <td><strong>[CCITY]</strong></td>\r\n           </tr>\r\n\r\n           <tr>\r\n              <td class=\"m_-8364453557841243647first\">CP:</td>\r\n              <td><strong>[CPOSTAL]</strong></td>\r\n           </tr>\r\n\r\n           <tr>\r\n              <td class=\"m_-8364453557841243647first\">Phone:</td>\r\n             <td><strong>[CPHONE]</strong></td>\r\n            </tr>\r\n         </tbody>\r\n        </table>\r\n\r\n        <p>\r\n         \"Line 2\" of your address is the part that identifies you, and it is very important to include it when you add your shipping address in online stores.\r\n       </p>\r\n\r\n        <p>When your packages arrive at the warehouse, we will notify you and you can see them in your locker.<br></p>\r\n\r\n\r\n        <p>\r\n         <a style=\"background: #ff636f;border-radius: 100px;line-height: 1;border-style: none;display: inline-block;font-size: 16px;padding: 13px 22px 12px;text-decoration: none;color: white;outline: none;\" href=\"[URL]\">\r\n         Access your <span class=\"il\">locker</span> →\r\n        </a></p>\r\n\r\n        <p>\r\n         If you have any questions, just reply to this email. We are here to help you!\r\n       </p>\r\n\r\n        <p>\r\n         Best regards,<br> [SITE_NAME] Team.</p>\r\n     </td>\r\n        </tr>\r\n        <tr>\r\n          <td>\r\n            <table border=\"0\" width=\"100%\" height=\"100%\" cellpadding=\"0\" cellspacing=\"0\">\r\n              <tbody><tr>\r\n     <td style=\"height:2px;width:100%;background:#ff636f\"></td>\r\n              </tr>\r\n            </tbody></table>\r\n          </td>\r\n        </tr>\r\n        <tr>\r\n          <td align=\"center\" style=\"padding:30px;text-align:center\">\r\n            <a style=\"font-size:18px;color:#ff636f;text-decoration:none\" href=\"[URL]\">[URL]</a> - Service at your door\r\n          </td>\r\n        </tr>\r\n    </tbody>\r\n</table>                                                                                                                                                                                '),
(10, 'Updated  Tax Exemption Clearance Process Status', 'Updated  Tax Exemption Clearance Process Status', 'This template is used to Update  Tax Exemption Clearance Process Status.', '																														                                                                                                                                                                                 \r\n\r\n\r\n\r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#f62d51\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\"></td></tr>\r\n            \r\n            <tr height=\"15\"></tr>\r\n           <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hello!\r\n              </td>\r\n           </tr>\r\n           <tr><td style=\"font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;\"><p>\r\n             [NAME], </p><p>We have updated the status of your Tax Exemption Clearance Process&nbsp; .\r\n            </p></td>\r\n           </tr><tr height=\"30\"></tr>\r\n            <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\"><p><br>\r\nFollow up on your&nbsp;&nbsp;Tax Exemption Clearance Process&nbsp;by entering the following link and you will have detailed information on the status of your&nbsp;&nbsp;Tax Exemption Clearance Process.</p><p><br>\r\n                <a href=\"[URL_SHIP]\">Click to see  Tax Exemption Clearance Process Status.</a>\r\n                \r\n                <br><br><br>\r\n                Thank you,<br>\r\n                [SITE_NAME] Team,<br><br></p></td>\r\n           </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                \r\nTo reply to this message, you can simply reply to this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n \r\n\r\n                                                                                                                                                                  																												'),
(20, 'New pre alert notification', 'Pre alert', 'This template is used to notify the pre alert of packages online.', '                                                                                                                \r\n\r\n\r\n\r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#f62d51\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\"></td></tr>\r\n            \r\n            <tr height=\"15\"></tr>\r\n           <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hello!\r\n              </td>\r\n           </tr>\r\n           <tr><td style=\"font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;\">\r\n             [NAME], \r\n¡Sending a pre alert to you!\r\n            </td>\r\n           </tr><tr height=\"30\"></tr>\r\n            <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\">\r\n         \r\n                <br><br>\r\n                Tracking number: <b>[TRACKING]</b>\r\n                <br>\r\n                Shipping date: <b>[DELIVERY_TIME]</b>\r\n                                                                <br><br>\r\n                                                                Please verify your pre alert and in this way send the package to the address mentioned\r\n\r\n               <br><br>\r\n                <br><br>\r\n                <a href=\"[URL_SHIP]\">Click to see package pre alert</a>\r\n               \r\n                <br><br><br>\r\n                Thank you,<br>\r\n                [SITE_NAME] Team,<br>\r\n               <a href=\"[URL]\">[URL]</a>\r\n             </td>\r\n           </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                \r\nTo reply to this message, you can simply reply to this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n \r\n\r\n                                                                                                      '),
(12, 'Single Email', 'Single User Email', 'This template is used to email single user', '<!doctype html>\r\n<html>\r\n\r\n<head>\r\n<link href=\'https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\' rel=\'stylesheet\' type=\'text/css\'>\r\n</head>\r\n\r\n<body style=\'margin: 0; padding: 20px; font-family: Montserrat, Arial, sans serif; font-size: 12px;font-weight:400;word-break: break-word;color:#555;line-height: 18px;\'>\r\n <table border=\'0\' cellpadding=\'0\' cellspacing=\'0\' width=\'100%\'>\r\n   <table align=\'center\' border=\'0\' cellpadding=\'0\' cellspacing=\'0\' width=\'100%\' style=\'max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\'> \r\n\r\n      <tr bgcolor=\'#f62d51\' height=\'5px\'>\r\n       <td align=\'center\' style=\'font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\'>\r\n\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\'#f9f9f9\'>\r\n        <td style=\'padding:40px;\'>\r\n          <table border=\'0\' cellpadding=\'0\' cellspacing=\'0\' width=\'100%\'>\r\n           <tr><td><img src=\"assets/uploads/logo.png\" class=\"logo\"/></td></tr>\r\n           <br><br><br>\r\n            <tr height=\'15\'></tr>\r\n           <tr>\r\n              <td style=\'font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\'>\r\n              Hello [NAME]\r\n              </td>\r\n           </tr>\r\n           <tr height=\'30\'></tr>\r\n           <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\">\r\n               <br><br>\r\n                  Your message goes here...         \r\n                  \r\n                <br><br>\r\n                <span style=\'color:#846add;\'>Thanks,</span><br><br>\r\n               <span>\r\n                [SITE_NAME] Team\r\n                </span>\r\n             </td>\r\n           </tr>\r\n           <tr height=\'50\'></tr>\r\n           <tr>\r\n              <td style=\'margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\'>\r\n                To reply to this message you can simply reply this email.\r\n             </td>\r\n           </tr>\r\n         </table>\r\n        </td>\r\n     </tr>\r\n   </table> \r\n </table>\r\n</body>\r\n</html>'),
(13, 'Administrator Notification', 'New User Registration', 'This template is used to notify the administrator of the new record when Configuration- &amp; gt; Registration notification is set to YES New User Registration', '                                              \n\n\n\n&lt;link href=&quot;https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot;&gt;\n\n\n\n &lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;&gt;\n   &lt;/table&gt;&lt;table align=&quot;center&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot; style=&quot;max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;&quot;&gt; \n\n      &lt;tbody&gt;&lt;tr bgcolor=&quot;#6610f2&quot; height=&quot;5px&quot;&gt;\n        &lt;td align=&quot;center&quot; style=&quot;font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;&quot;&gt;\n       &lt;/td&gt;\n     &lt;/tr&gt;\n     &lt;tr bgcolor=&quot;#f9f9f9&quot;&gt;\n        &lt;td style=&quot;padding:40px;&quot;&gt;\n          &lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;&gt;\n           &lt;tbody&gt;&lt;tr&gt;\n             &lt;td style=&quot;font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;&quot;&gt;\n              Hello!\n              &lt;/td&gt;\n           &lt;/tr&gt;\n           \n            &lt;tr&gt;&lt;td style=&quot;font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;&quot;&gt;\n             You have a new user registration. You can log in to your administration panel to see the details:\n           &lt;/td&gt;\n           &lt;/tr&gt;&lt;tr height=&quot;30&quot;&gt;&lt;/tr&gt;\n            &lt;tr&gt;\n              &lt;td style=&quot;margin: 40px 0;line-height: 22px; font-family: &#039;Montserrat&#039;, Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;&quot;&gt;\n               Username: &lt;b&gt;[USERNAME]&lt;/b&gt;\n               &lt;br&gt;\n                Name: &lt;b&gt;[NAME]&lt;/b&gt;\n               &lt;br&gt;Address IP:   &lt;b&gt;[IP]&lt;/b&gt;\n               &lt;br&gt;\n              &lt;/td&gt;\n           &lt;/tr&gt;\n         &lt;/tbody&gt;&lt;/table&gt;\n        &lt;/td&gt;\n     &lt;/tr&gt;\n   &lt;/tbody&gt;&lt;/table&gt; \n \n\n                                          '),
(14, 'Notification of delivery of consolidate', 'Delivered consolidate', 'This template is used to notify the delivery of consolidated.', '\r\n\r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n  <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#f62d51\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\"></td></tr>\r\n            \r\n            <tr height=\"15\"></tr>\r\n           <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hello!\r\n              </td>\r\n           </tr>\r\n           <tr><td style=\"font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;\">\r\n             [NAME], \r\nWe have delivered your package.\r\n           </td>\r\n           </tr><tr height=\"30\"></tr>\r\n            <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\">\r\n               \r\nThese are the data of your consolidate. [NAME].\r\n               <br><br>\r\n                Tracking number: <b>[TRACKING]</b>\r\n                <br>\r\n                Delivery status: <b><span style=\"background: #68c251;\" class=\"label label-large\"> [COURIER] </span></b>\r\n                                                                <br>\r\n                                                                Delivery date: <b>[DELIVERY_TIME]</b>\r\n                <br><br>\r\nFollow up on your consolidate by entering the following link and you will have detailed information on the status of your consolidate.                \r\n                <br><br>\r\n                <br><br>\r\n                <a href=\"[URL_SHIP]\">Click to see consolidate tracking.</a>\r\n               \r\n                <br><br><br>\r\n                Thank you,<br>\r\n                [SITE_NAME] Team,<br>\r\n               <a href=\"[URL]\">[URL]</a>\r\n             </td>\r\n           </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                \r\nTo reply to this message, you can simply reply to this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n\r\n                                                                                                     '),
(19, 'Updated consolidate tracking', 'Updated consolidate tracking', 'This template is used to update the consolidate.', '                                                                                                                                                                                                        \r\n\r\n\r\n\r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#f62d51\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\"></td></tr>\r\n            \r\n            <tr height=\"15\"></tr>\r\n           <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hello!\r\n              </td>\r\n           </tr>\r\n           <tr><td style=\"font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;\">\r\n             [NAME], \r\nwe have updated the status of your consolidate.\r\n           </td>\r\n           </tr><tr height=\"30\"></tr>\r\n            <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\">\r\n               \r\nconsolidate has been updated. [NAME].\r\n               <br><br>\r\n                Tracking number: <b>[TRACKING]</b>\r\n                <br>\r\n                New status: <b>[COURIER] </b>\r\n                                                                <br>\r\n                                                                New address: <b>[NEW_ADDRESS]</b>\r\n                                                                <br>\r\n                                                                Comments: <b>[COMMENT]</b>\r\n                                                                <br>\r\n                                                                Update date: <b>[DELIVERY_TIME]</b>\r\n               <br><br>\r\nFollow up on your consolidate by entering the following link and you will have detailed information on the status of your consolidate.                \r\n                <br><br>\r\n                <br><br>\r\n                <a href=\"[URL_SHIP]\">Click to see consolidate tracking.</a>\r\n               \r\n                <br><br><br>\r\n                Thank you,<br>\r\n                [SITE_NAME] Team,<br>\r\n               <a href=\"[URL]\">[URL]</a>\r\n             </td>\r\n           </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                \r\nTo reply to this message, you can simply reply to this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n \r\n\r\n                                                                                                                                                                                      '),
(16, 'New shipment notification', 'Shipment notification', 'This template is used to notify customers of the shipment.', '                                                                                                                \r\n\r\n\r\n\r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#f62d51\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\"></td></tr>\r\n            \r\n            <tr height=\"15\"></tr>\r\n           <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hello!\r\n              </td>\r\n           </tr>\r\n           <tr><td style=\"font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;\">\r\n             [NAME], \r\n¡Sending a package to you!\r\n            </td>\r\n           </tr><tr height=\"30\"></tr>\r\n            <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\">\r\n         \r\n                <br><br>\r\n                Tracking number: <b>[TRACKING]</b>\r\n                <br>\r\n                Shipping date: <b>[DELIVERY_TIME]</b>\r\n                                                                <br><br>\r\n                                                                Follow up on your shipment by entering the following link and you will have detailed information on the status of your shipments. <br>\r\n               <br><br>\r\n                <br><br>\r\n                <a href=\"[URL_SHIP]\">Click to see shipment tracking</a>\r\n               \r\n                <br><br><br>\r\n                Thank you,<br>\r\n                [SITE_NAME] Team,<br>\r\n               <a href=\"[URL]\">[URL]</a>\r\n             </td>\r\n           </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                \r\nTo reply to this message, you can simply reply to this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n \r\n\r\n                                                                                                      '),
(17, 'Account activation', 'Your account has been activated', 'This template is used to notify the user when manual account activation is complete.', '                                                                                                                                                               \r\n\r\n\r\n\r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#36bea6\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/uploads/logo.png\" class=\"logo\"></td></tr>\r\n            \r\n            <tr height=\"15\"></tr>\r\n           <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hello, [NAME]!\r\n              </td>\r\n           </tr>\r\n           <tr height=\"30\"></tr>\r\n           <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\">\r\n               You are now a member of [SITE_NAME].\r\n                <br><br>\r\n                Your account is now fully activated, and you can log in to\r\n                <br><br>\r\n                <a href=\"[URL]\">[URL]</a>\r\n               <br><br><br>\r\n                Thank you,<br>\r\n                [SITE_NAME] work team,<br>\r\n                <a href=\"[URL]\">[URL]</a></td>\r\n              \r\n            </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                \r\nTo reply to this message, you can simply reply to this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n \r\n\r\n                                                                                                                                                  '),
(18, 'Notification of delivery of shipments', 'Shipment has been delivered', 'This form is used for the delivery of shipments', '                                                                                                                                                           \r\n\r\n\r\n\r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#f62d51\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\"></td></tr>\r\n            \r\n            <tr height=\"15\"></tr>\r\n           <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hello!\r\n              </td>\r\n           </tr>\r\n           <tr><td style=\"font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;\">\r\n             [NAME], \r\nWe have delivered your package.\r\n           </td>\r\n           </tr><tr height=\"30\"></tr>\r\n            <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\">\r\n               \r\nThese are the data of your shipment. [NAME].\r\n                <br><br>\r\n                Tracking number: <b>[TRACKING]</b>\r\n                <br>\r\n                Delivery status: <b><span style=\"background: #68c251;\" class=\"label label-large\"> [COURIER] </span></b>\r\n                                                                <br>\r\n                                                                Delivery date: <b>[DELIVERY_TIME]</b>\r\n                <br><br>\r\nFollow up on your shipment by entering the following link and you will have detailed information on the status of your shipments.               \r\n                <br><br>\r\n                <br><br>\r\n                <a href=\"[URL_SHIP]\">Click to see shipment tracking.</a>\r\n                \r\n                <br><br><br>\r\n                Thank you,<br>\r\n                [SITE_NAME] Team,<br>\r\n               <a href=\"[URL]\">[URL]</a>\r\n             </td>\r\n           </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                \r\nTo reply to this message, you can simply reply to this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n \r\n\r\n                                                                                                                                              ');
INSERT INTO `cdb_email_templates` (`id`, `name`, `subject`, `help`, `body`) VALUES
(21, 'New package notification', 'Package notification', 'This template is used to notify customers of the package.', '																														                                                                                                                                     \r\n\r\n\r\n\r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#f62d51\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\"></td></tr>\r\n            \r\n            <tr height=\"15\"></tr>\r\n           <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hello!\r\n              </td>\r\n           </tr>\r\n           <tr><td style=\"font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;\">\r\n             [NAME]</td>\r\n           </tr><tr height=\"30\"></tr>\r\n            <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\"><p><br>\r\n                Tracking number: <b>[TRACKING]</b>\r\n                <br>\r\n                Shipping date: <b>[DELIVERY_TIME]</b>\r\n                                                                <br><br>\r\n\r\n                            Follow up on Tax Exemption Clearance Status by entering the following link and you will have detailed information on the status of your Tax Exemption Clearance Process.<br><br>\r\n                <a href=\"[URL_SHIP]\">Click to see Tax Exemption Clearance Status</a>\r\n                \r\n                <br><br>\r\n                Thank you,<br>\r\n                [SITE_NAME] Team,<br><br></p></td>\r\n           </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                \r\nTo reply to this message, you can simply reply to this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n \r\n\r\n                                                                                                                          																												'),
(22, 'Updated package tracking', 'Updated package tracking', 'This template is used to update package.', '                                                                                                                                                                                                                              \r\n\r\n\r\n\r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#f62d51\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\"></td></tr>\r\n            \r\n            <tr height=\"15\"></tr>\r\n           <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hello!\r\n              </td>\r\n           </tr>\r\n           <tr><td style=\"font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;\">\r\n             [NAME], \r\nwe have updated the status of your package.\r\n           </td>\r\n           </tr><tr height=\"30\"></tr>\r\n            <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\">\r\n               \r\npackage has been updated. [NAME].\r\n               <br><br>\r\n                Tracking number: <b>[TRACKING]</b>\r\n                <br>\r\n                New status: <b>[COURIER] </b>\r\n                                                                <br>\r\n                                                                New address: <b>[NEW_ADDRESS]</b>\r\n                                                                <br>\r\n                                                                Comments: <b>[COMMENT]</b>\r\n                                                                <br>\r\n                                                                Update date: <b>[DELIVERY_TIME]</b>\r\n               <br><br>\r\nFollow up on your package by entering the following link and you will have detailed information on the status of your packages.               \r\n                <br><br>\r\n                <br><br>\r\n                <a href=\"[URL_SHIP]\">Click to see package tracking.</a>\r\n               \r\n                <br><br><br>\r\n                Thank you,<br>\r\n                [SITE_NAME] Team,<br>\r\n               <a href=\"[URL]\">[URL]</a>\r\n             </td>\r\n           </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                \r\nTo reply to this message, you can simply reply to this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n \r\n\r\n                                                                                                                                                                                                          '),
(23, 'Notification of delivery of package', 'Package has been delivered', 'This form is used for the delivery of package', '                                                                                                                                                                                  \r\n\r\n\r\n\r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#f62d51\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\"></td></tr>\r\n            \r\n            <tr height=\"15\"></tr>\r\n           <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hello!\r\n              </td>\r\n           </tr>\r\n           <tr><td style=\"font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;\">\r\n             [NAME], \r\nWe have delivered your package.\r\n           </td>\r\n           </tr><tr height=\"30\"></tr>\r\n            <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\">\r\n               \r\nThese are the data of your package. [NAME].\r\n               <br><br>\r\n                Tracking number: <b>[TRACKING]</b>\r\n                <br>\r\n                Delivery status: <b><span style=\"background: #68c251;\" class=\"label label-large\"> [COURIER] </span></b>\r\n                                                                <br>\r\n                                                                Delivery date: <b>[DELIVERY_TIME]</b>\r\n                <br><br>\r\nFollow up on your package by entering the following link and you will have detailed information on the status of your package.                \r\n                <br><br>\r\n                <br><br>\r\n                <a href=\"[URL_SHIP]\">Click to see package tracking.</a>\r\n               \r\n                <br><br><br>\r\n                Thank you,<br>\r\n                [SITE_NAME] Team,<br>\r\n               <a href=\"[URL]\">[URL]</a>\r\n             </td>\r\n           </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                \r\nTo reply to this message, you can simply reply to this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n \r\n\r\n                                                                                                                                                                  '),
(24, 'New shipment (pickup) customer notification', 'pickup customer notification', 'This template is used to notify customers of the pickup.', '                                                                                                                                                           \r\n\r\n\r\n\r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#f62d51\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\"></td></tr>\r\n            \r\n            <tr height=\"15\"></tr>\r\n           <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hello!\r\n              </td>\r\n           </tr>\r\n           <tr><td style=\"font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;\">\r\n             [NAME], \r\n¡Sending a shipment pickup to you!\r\n            </td>\r\n           </tr><tr height=\"30\"></tr>\r\n            <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\">\r\n         \r\n                <br><br>\r\n                Tracking number: <b>[TRACKING]</b>\r\n                <br>\r\n                Shipping date: <b>[DELIVERY_TIME]</b>\r\n                                                                <br><br>\r\n                                                               \r\n\r\n                            Notification of shipment collection was sent, verify your dashboard or pick-up lists and approval for the complete shipment to the destination.. <br><br>\r\n               <br><br>\r\n                <a href=\"[URL_SHIP]\">Click to see pickup tracking</a>\r\n               \r\n                <br><br><br>\r\n                Thank you,<br>\r\n                [SITE_NAME] Team,<br>\r\n               <a href=\"[URL]\">[URL]</a>\r\n             </td>\r\n           </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                \r\nTo reply to this message, you can simply reply to this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n \r\n\r\n                                                                                                                                              '),
(25, 'New shipment (pick up) created by the admin notifications', 'pickup admin notification', 'This template is used to notify customer of the pickup, created admin.', '                                                                                                                                                            \r\n\r\n\r\n\r\n<link href=\"https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n\r\n\r\n <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n   </table><table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;\"> \r\n\r\n      <tbody><tr bgcolor=\"#f62d51\" height=\"5px\">\r\n        <td align=\"center\" style=\"font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;\">\r\n       </td>\r\n     </tr>\r\n     <tr bgcolor=\"#f9f9f9\">\r\n        <td style=\"padding:40px;\">\r\n          <br><br><br><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n           <tbody><tr><td><img src=\"[URL]/assets/[URL_LINK]\" width=\"190\" height=\"39\"></td></tr>\r\n            \r\n            <tr height=\"15\"></tr>\r\n           <tr>\r\n              <td style=\"font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;\">\r\n              Hello!\r\n              </td>\r\n           </tr>\r\n           <tr><td style=\"font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;\">\r\n             [NAME], \r\n¡Sending a shipment pickup to you!\r\n            </td>\r\n           </tr><tr height=\"30\"></tr>\r\n            <tr>\r\n              <td style=\"margin: 40px 0;line-height: 22px; font-family: \'Montserrat\', Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;\">\r\n         \r\n                <br><br>\r\n                Tracking number: <b>[TRACKING]</b>\r\n                <br>\r\n                Shipping date: <b>[DELIVERY_TIME]</b>\r\n                                                                <br><br>\r\n                                                               \r\n\r\n                            Notification of shipment collection was sent, verify your dashboard or pick-up lists and approval for the complete shipment to the destination.. <br><br>\r\n               <br><br>\r\n                <a href=\"[URL_SHIP]\">Click to see pickup tracking</a>\r\n               \r\n                <br><br><br>\r\n                Thank you,<br>\r\n                [SITE_NAME] Team,<br>\r\n               <a href=\"[URL]\">[URL]</a>\r\n             </td>\r\n           </tr>\r\n           <tr height=\"50\"></tr>\r\n           <tr>\r\n              <td style=\"margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;\">\r\n                \r\nTo reply to this message, you can simply reply to this email.\r\n             </td>\r\n           </tr>\r\n         </tbody></table>\r\n        </td>\r\n     </tr>\r\n   </tbody></table> \r\n \r\n\r\n                                                                                                                                              '),
(26, 'Registration user ', 'Registration user ', 'This template is used to email single user', '&lt;link href=&quot;https://fonts.googleapis.com/css?family=Montserrat:300,400,500,600&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot;&gt; &lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;&gt;   &lt;/table&gt;&lt;table align=&quot;center&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot; style=&quot;max-width:500px; margin:40px auto;border-collapse: collapse;border-radius: 2px;overflow: hidden;&quot;&gt;       &lt;tbody&gt;&lt;tr bgcolor=&quot;#f62d51&quot; height=&quot;5px&quot;&gt;        &lt;td align=&quot;center&quot; style=&quot;font-family: Montserrat, Arial, sans serif; color: #fff;text-transform: uppercase;font-size: 20px;justify-content: center;align-items: center;letter-spacing: 4px;font-weight: 600;&quot;&gt;       &lt;/td&gt;     &lt;/tr&gt;     &lt;tr bgcolor=&quot;#f9f9f9&quot;&gt;        &lt;td style=&quot;padding:40px;&quot;&gt;          &lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;table border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;&gt;           &lt;tbody&gt;&lt;tr&gt;&lt;td&gt;&lt;img src=&quot;[URL]/assets/uploads/logo.png&quot; class=&quot;logo&quot;&gt;&lt;/td&gt;&lt;/tr&gt;                       &lt;tr&gt;              &lt;td style=&quot;font-family: Montserrat, Arial, sans serif; margin:0; color:#846add; font-size:20px; font-weight:400;&quot;&gt;              Hi!             &lt;/td&gt;           &lt;/tr&gt;           &lt;tr&gt;&lt;td style=&quot;font-family: Montserrat, Arial, sans serif; margin:5px 0 0; font-size: 12px; font-weight:400;word-break: break-word;color:#333;line-height: 22px; position: relative; top: 10px;&quot;&gt;             [NAME]! Thanks for registering.           &lt;/td&gt;           &lt;/tr&gt;&lt;tr height=&quot;30&quot;&gt;&lt;/tr&gt;            &lt;tr&gt;              &lt;td style=&quot;margin: 40px 0;line-height: 22px; font-family: &#039;Montserrat&#039;, Arial, sans serif; font-size: 12px;font-weight:100; word-break: break-word; color:#333;&quot;&gt;               You&#039;re now a member of [SITE_NAME].                &lt;br&gt;                Here are your login details. Please keep them in a safe place:                &lt;br&gt;&lt;br&gt;                Username: &lt;b&gt;[USERNAME]&lt;/b&gt;               &lt;br&gt;                Password: &lt;b&gt;[PASSWORD]&lt;/b&gt;                                                                &lt;br&gt;                                                                Locker: &lt;b&gt;[LOCKER]&lt;/b&gt;                &lt;br&gt;&lt;br&gt;                  The administrator of this site has requested all new accounts                 to be activated by the users who created them thus your account                 is currently inactive. To activate your account,                  please visit the link below and enter the following:                &lt;br&gt;&lt;br&gt;                &lt;span style=&quot;color:#846add;&quot;&gt;Activate Information:&lt;/span&gt;&lt;br&gt;&lt;br&gt;               &lt;span&gt;                                &lt;br&gt;                Email: [EMAIL]            &lt;/span&gt;               &lt;br&gt;&lt;br&gt;&lt;br&gt;                Thanks,&lt;br&gt;               [SITE_NAME] Team,&lt;br&gt;               &lt;a href=&quot;[URL]&quot;&gt;[URL]&lt;/a&gt;&lt;/td&gt;                          &lt;/tr&gt;           &lt;tr height=&quot;50&quot;&gt;&lt;/tr&gt;           &lt;tr&gt;              &lt;td style=&quot;margin:40px 0; line-height: 22px; font-family: Montserrat, Arial, sans serif; font-size: 12px; font-weight:400; word-break: break-word; color:#333; padding-top: 10px; border-top: 1px solid #e2e2e2;&quot;&gt;                To reply to this message you can simply reply this email.             &lt;/td&gt;           &lt;/tr&gt;         &lt;/tbody&gt;&lt;/table&gt;        &lt;/td&gt;     &lt;/tr&gt;   &lt;/tbody&gt;&lt;/table&gt;                        ');

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

--
-- 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_settings`
--

CREATE TABLE `cdb_settings` (
  `id` int(11) NOT NULL,
  `site_name` varchar(50) DEFAULT NULL,
  `c_nit` varchar(30) DEFAULT NULL,
  `c_phone` varchar(30) DEFAULT NULL,
  `cell_phone` varchar(30) DEFAULT NULL,
  `c_address` varchar(60) DEFAULT NULL,
  `locker_address` text DEFAULT NULL,
  `c_country` varchar(60) DEFAULT NULL,
  `c_city` varchar(60) DEFAULT NULL,
  `c_postal` varchar(30) DEFAULT NULL,
  `site_email` varchar(40) DEFAULT NULL,
  `mailer` enum('PHP','SMTP') DEFAULT 'PHP',
  `smtp_names` varchar(120) DEFAULT NULL,
  `email_address` varchar(120) DEFAULT NULL,
  `smtp_host` varchar(120) DEFAULT NULL,
  `smtp_user` varchar(120) DEFAULT NULL,
  `smtp_password` varchar(60) DEFAULT NULL,
  `smtp_port` varchar(10) DEFAULT NULL,
  `smtp_secure` varchar(10) DEFAULT NULL,
  `interms` text DEFAULT NULL,
  `signing_customer` varchar(60) DEFAULT NULL,
  `signing_company` varchar(60) DEFAULT NULL,
  `site_url` varchar(200) DEFAULT NULL,
  `paypal_client_id` varchar(250) DEFAULT NULL,
  `public_key_stripe` varchar(300) DEFAULT NULL,
  `secret_key_stripe` varchar(300) DEFAULT NULL,
  `public_key_paystack` varchar(500) DEFAULT NULL,
  `secret_key_paystack` varchar(500) DEFAULT NULL,
  `active_paypal` tinyint(4) DEFAULT NULL,
  `active_paystack` tinyint(4) DEFAULT NULL,
  `active_stripe` tinyint(4) DEFAULT NULL,
  `active_attach_proof` tinyint(4) DEFAULT NULL,
  `active_whatsapp` tinyint(4) DEFAULT NULL,
  `twilio_sid` varchar(500) DEFAULT NULL,
  `twilio_token` varchar(500) DEFAULT NULL,
  `twilio_number` varchar(500) DEFAULT NULL,
  `thumb_w` varchar(4) DEFAULT NULL,
  `thumb_h` varchar(4) DEFAULT NULL,
  `logo` varchar(500) DEFAULT NULL,
  `favicon` varchar(500) DEFAULT NULL,
  `backup` varchar(600) DEFAULT NULL,
  `version` varchar(5) DEFAULT NULL,
  `prefix` varchar(6) DEFAULT NULL,
  `track_digit` varchar(15) DEFAULT NULL,
  `prefix_con` varchar(6) DEFAULT NULL,
  `track_container` varchar(12) DEFAULT NULL,
  `prefix_consolidate` varchar(6) DEFAULT NULL,
  `track_consolidate` varchar(12) DEFAULT NULL,
  `track_online_shopping` varchar(20) DEFAULT NULL,
  `prefix_online_shopping` varchar(20) DEFAULT NULL,
  `tax` varchar(4) DEFAULT NULL,
  `insurance` varchar(4) DEFAULT NULL,
  `value_weight` varchar(16) DEFAULT NULL,
  `meter` varchar(16) DEFAULT NULL,
  `c_tariffs` varchar(4) DEFAULT NULL,
  `currency` varchar(120) DEFAULT NULL,
  `timezone` varchar(120) DEFAULT NULL,
  `language` varchar(120) DEFAULT NULL,
  `min_cost_tax` float(5,2) DEFAULT NULL,
  `notify_admin` varchar(200) DEFAULT NULL,
  `user_limit` varchar(200) DEFAULT NULL,
  `reg_allowed` varchar(200) DEFAULT NULL,
  `auto_verify` varchar(200) DEFAULT NULL,
  `reg_verify` varchar(200) DEFAULT NULL,
  `user_perpage` varchar(200) DEFAULT NULL,
  `declared_tax` float NOT NULL,
  `min_cost_declared_tax` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `cdb_settings`
--

INSERT INTO `cdb_settings` (`id`, `site_name`, `c_nit`, `c_phone`, `cell_phone`, `c_address`, `locker_address`, `c_country`, `c_city`, `c_postal`, `site_email`, `mailer`, `smtp_names`, `email_address`, `smtp_host`, `smtp_user`, `smtp_password`, `smtp_port`, `smtp_secure`, `interms`, `signing_customer`, `signing_company`, `site_url`, `paypal_client_id`, `public_key_stripe`, `secret_key_stripe`, `public_key_paystack`, `secret_key_paystack`, `active_paypal`, `active_paystack`, `active_stripe`, `active_attach_proof`, `active_whatsapp`, `twilio_sid`, `twilio_token`, `twilio_number`, `thumb_w`, `thumb_h`, `logo`, `favicon`, `backup`, `version`, `prefix`, `track_digit`, `prefix_con`, `track_container`, `prefix_consolidate`, `track_consolidate`, `track_online_shopping`, `prefix_online_shopping`, `tax`, `insurance`, `value_weight`, `meter`, `c_tariffs`, `currency`, `timezone`, `language`, `min_cost_tax`, `notify_admin`, `user_limit`, `reg_allowed`, `auto_verify`, `reg_verify`, `user_perpage`, `declared_tax`, `min_cost_declared_tax`) VALUES
(1, 'SSI GROUP', '800124570-87', '+252 (619) 277 - 900 ', '6692843100', '1199 E Calaveras Blvd', '1770 NW 96th Ave. Doral â€&#34; FL 33172-2317', 'US', 'Miami', '95035', 'info@ssigroupltd.com', 'PHP', 'OKELLO', 'info@nextgenit.co.ke', 'smtp.mydomain.com', 'info@mydomain.com', '1234567890', '587', 'TLS', 'ACCEPTED: This Invoice is a title value in accordance with the provisions of art. 3 of law 1231 of July 17/08. The signature by third parties in representation, mandate or other quality on behalf of the buyer implies its obligation in accordance with art. 640 of the commercial code.', 'SIGNATURE / SEAL WHO RECEIVES', 'COMPANY SIGNATURE', 'https://ssigroup.so/track/application/', '', '', '', '', '', 1, 1, 1, 1, 0, '', '', '', '200', '200', 'uploads/1685438976_logo2-01.png', 'uploads/1685438976_logo2-01.png', NULL, '6.3.7', 'AWB', '6', NULL, NULL, 'COEE', '6', '6', 'CPI', '17', '3', '3', '5000', '2.1', 'USD', 'Africa/Mogadishu', 'en', 100.00, '1', '1', '1', '1', '0', '', 15, 50);

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

--
-- 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`
--

CREATE TABLE `cdb_users` (
  `id` int(11) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `name_off` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `locker` varchar(255) DEFAULT NULL,
  `userlevel` tinyint(1) UNSIGNED DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `document_type` varchar(300) DEFAULT NULL,
  `document_number` varchar(300) DEFAULT NULL,
  `fname` varchar(50) DEFAULT NULL,
  `lname` varchar(50) DEFAULT NULL,
  `avatar` varchar(350) DEFAULT NULL,
  `ip` varchar(16) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `lastlogin` datetime DEFAULT NULL,
  `lastip` varchar(16) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `enrollment` varchar(20) DEFAULT NULL,
  `vehiclecode` varchar(20) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `newsletter` tinyint(1) NOT NULL DEFAULT 0,
  `terms` varchar(120) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `create_user` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `cdb_users`
--

INSERT INTO `cdb_users` (`id`, `username`, `name_off`, `password`, `locker`, `userlevel`, `email`, `document_type`, `document_number`, `fname`, `lname`, `avatar`, `ip`, `created`, `lastlogin`, `lastip`, `notes`, `phone`, `enrollment`, `vehiclecode`, `gender`, `newsletter`, `terms`, `active`, `create_user`) VALUES
(1, 'admin', 'undefined', '$2y$10$cPg7xp947XjKaCRvxBuh5OghubEy63CfKtRV0lTusY2zQBZqmSJs6', '', 9, 'okellobrian462@gmail.com', '', '', 'SSI', 'GROUP', 'uploads/1685436997_logo2-01.png', '', '2019-01-01 01:11:46', '2023-06-09 12:24:42', '197.248.200.77', 'SSI GROUP', '+573004553322', '', '', 'Male', 1, '', 1, 0),
(2, 'driver', 'undefined', '$2y$10$bZAuZdd.gDn6qbYl9z77FOiWerUuHOrGd82MMb0.Brv2Js4OSAYd6', '', 3, 'driver@demo.com', '', '', 'JOSE', 'LARVERDE', 'uploads/1639449846_avatar-6.jpg', '', '2019-01-04 21:12:00', '2021-12-13 19:23:09', '::1', 'NONE', '+573003452233', 'MNW952', '81', 'Female', 0, '', 1, 0),
(13, 'customer', NULL, '$2y$10$Cyi4ramKztRaUdqn6sfsDe09mStTIXcgTYecYqVVzrMZxZ98GJlRC', '721201', 1, 'customer@demo.com', 'CC', '231523515', 'VALVER', 'VILLA', '', NULL, '2021-11-13 09:11:15', '2021-12-13 19:13:03', '::1', 'NONES', '+573116173300', NULL, NULL, 'Male', 1, NULL, 1, NULL),
(15, '', NULL, '', '', 1, 'info@nextgenit.co.ke', NULL, NULL, 'Brian Okello', 'NextGEnIT', NULL, NULL, '2023-06-09 09:33:41', NULL, NULL, NULL, '+254714928456', NULL, NULL, NULL, 0, NULL, 1, NULL),
(16, 'b_zab', NULL, '$2y$10$ZVmGp.kBWOjVFygLlHN2huQsM6A6xBOh8MWmiisKIutmam1/RFg4W', '835689', 1, 'b.zablon@gmail.com', NULL, NULL, 'NALIALI', 'ZABLON', NULL, NULL, '2023-06-09 10:22:43', '2023-06-09 10:23:08', '197.248.200.77', NULL, NULL, NULL, NULL, NULL, 0, 'yes', 1, NULL);

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

--
-- 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_settings`
--
ALTER TABLE `cdb_settings`
  ADD PRIMARY KEY (`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`
--
ALTER TABLE `cdb_users`
  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_settings`
--
ALTER TABLE `cdb_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- 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`
--
ALTER TABLE `cdb_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- 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;

