--
-- Host: localhost    Database: dugasoil_adikecourier
-- ------------------------------------------------------


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

CREATE TABLE `cdb_add_order` (
  `order_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `order_prefix` varchar(300) DEFAULT NULL,
  `order_no` varchar(350) DEFAULT NULL,
  `order_date` date DEFAULT NULL,
  `sender_id` int DEFAULT NULL,
  `sender_address_id` int DEFAULT NULL,
  `receiver_id` int DEFAULT NULL,
  `receiver_address_id` int 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 DEFAULT NULL,
  `origin_off` int DEFAULT NULL,
  `order_item_category` int DEFAULT NULL,
  `order_package` int DEFAULT NULL,
  `order_courier` int DEFAULT NULL,
  `order_service_options` int DEFAULT NULL,
  `order_deli_time` int DEFAULT NULL,
  `order_pay_mode` int DEFAULT NULL,
  `order_payment_method` int DEFAULT NULL,
  `status_courier` int DEFAULT NULL,
  `driver_id` int 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 DEFAULT NULL,
  `reason_cancel` mediumtext,
  `order_incomplete` tinyint DEFAULT '1',
  `url_payment_attach` varchar(500) DEFAULT NULL,
  `notes` mediumtext,
  `payment_date` datetime DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cdb_add_order`
--

INSERT INTO `cdb_add_order` VALUES (9,1,'THA','326271','2025-02-25',32,19,33,20,17,3,100,2.1,3,15,'5000',0,0,0,3,0,0,125000,899,0,0,19652,'2025-02-25 00:00:00',4,86,26,23,94,7,12,1,1,28,2,NULL,NULL,0,0,'2025-02-25',1,NULL,1,NULL,NULL,NULL),(10,1,'AWB','326272','2025-03-01',35,22,36,23,17,3,100,2.1,3,15,'5000',17,51,0,3,35.7,0,0,5000,0,0,5089.7,'2025-03-01 00:00:00',4,86,26,27,93,7,12,1,1,28,0,NULL,NULL,0,0,'2025-03-01',1,NULL,1,NULL,NULL,NULL),(11,1,'IDN','326274','2025-03-09',37,24,38,25,17,3,100,2.1,3,15,'5000',0,0,0,3,0,0,0,0,0,0,3,'2025-03-09 10:51:29',4,86,26,23,94,7,12,1,1,27,0,NULL,NULL,0,0,'2025-03-09',1,NULL,1,NULL,NULL,NULL),(12,1,'0','326275','2025-03-15',39,26,40,27,17,3,100,2.1,3,15,'5000',0,0,0,3,0,0,0,800,0,0,803,'2025-03-14 00:40:42',4,86,26,23,93,7,12,1,1,10,0,NULL,NULL,0,0,'2025-03-15',1,NULL,1,NULL,NULL,NULL),(13,1,'KOR','326276','2025-03-15',45,32,46,33,17,3,100,2.1,3,15,'5000',25,75,0,3,52.5,0,0,800,0,0,930.5,'2025-03-15 00:00:00',4,86,26,26,93,7,12,1,1,24,2,NULL,NULL,0,0,'2025-03-15',1,NULL,1,NULL,NULL,NULL),(14,1,'SYR','326277','2025-03-15',47,34,48,35,17,3,100,2.1,3,15,'5000',50,150,0,3,105,25.5,0,1600,0,0,1883.5,'2025-03-15 17:56:22',4,86,26,26,93,7,12,1,1,3,2,NULL,NULL,0,0,'2025-03-15',1,NULL,1,NULL,NULL,NULL),(15,1,'AWB','00326278','2025-03-21',49,36,50,37,17,3,100,2.1,3,15,'5000',17,51,0,3,35.7,0,0,5000,0,0,5089.7,'2025-03-21 00:00:00',4,86,26,27,93,7,12,1,1,24,0,NULL,NULL,0,0,'2025-03-21',1,NULL,1,NULL,NULL,NULL),(16,1,'AWB','00326278','2025-03-27',51,38,52,39,17,3,100,2.1,3,15,'5000',12,36,0,3,25.2,0,525,650,0,0,1239.2,'2025-03-27 11:10:38',4,86,27,24,93,7,12,1,1,10,2,NULL,NULL,0,0,'2025-03-27',1,NULL,1,NULL,NULL,NULL),(17,1,'AWB','326280','2025-03-27',53,40,54,41,17,3,100,2.1,3,15,'5000',12,36,0,3,25.2,0,525,650,0,0,1239.2,'2025-03-27 11:25:48',4,86,26,24,93,7,12,1,1,28,2,NULL,NULL,0,0,'2025-03-27',1,NULL,1,NULL,NULL,NULL),(18,1,'AWB','326285','2025-04-17',57,44,58,45,17,3,100,2.1,3,15,'5000',25,75,0,3,52.5,0,1050,850,0,0,2030.5,'2025-04-17 13:42:02',4,86,26,23,93,7,12,1,1,28,0,NULL,NULL,0,0,'2025-04-17',1,NULL,1,NULL,NULL,NULL);

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

CREATE TABLE `cdb_add_order_item` (
  `order_item_id` int NOT NULL AUTO_INCREMENT,
  `order_id` int 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,
  PRIMARY KEY (`order_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cdb_add_order_item`
--

INSERT INTO `cdb_add_order_item` VALUES (14,8,'ATM CARD AND CHEQUE BOOK',2.00,'0.5','0','0','0',350,12270000),(16,9,'Zixuan Chemicals',20.00,'0','0','0','0',899,125000),(18,10,'one big box and a brown envelope',2.00,'17','0','0','0',5000,0),(19,11,'Package',1.00,'0','0','0','0',0,0),(20,12,'Royalwayxpress',1.00,'0','0','0','0',800,0),(23,13,'Royalwayxpress',1.00,'25','0','0','0',800,0),(24,14,'Royalwayxpress',1.00,'25','0','0','0',800,0),(25,14,'Royalwayxpress',1.00,'25','0','0','0',800,0),(27,15,'One big box and a brown envelope',2.00,'17','0','0','0',5000,0),(28,16,'waybill',1.00,'12','0','0','0',650,3500),(29,17,'waybill',1.00,'12','0','0','0',650,3500),(30,18,'waybill',2.00,'25','0','0','0',850,7000);

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

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

--
-- Dumping data for table `cdb_address_shipments`
--

INSERT INTO `cdb_address_shipments` VALUES (10,'THA326271','NO 4 Chemical Manufacturer, Ampang Jaya Selangor','Malaysia','Kuala Lumpur','46350','1389/4 Soi Eiamying Chan Rd Thung Wat Don Sathon','Thailand','Bangkok','10120'),(11,'AWB326272','Suite 4, 130 Pitt Street, City, Sydney.','Australia','Perth','6053','1176, Regat Emas 2 Taman Bandar Baru 31900 KAMPAR PERAK','Malaysia','Kampar Perak','31900'),(12,'IDN326274','NO 4 Chemical Manufacturer, Ampang Jaya Selangor','Malaysia','Kuala Lumpur','46350','Jl Sultan Agung 33 Jaksel Setia Budi Asrama Pomdam Jaya  Indonesia','Indonesia','Jakarta Indonesia','10110'),(13,'0326275','20812 Ventura Boulevard Suite #210, Woodland Hills, CA‎','United State','California','90001','경북 구미시 고아읍 문성로20 문성파크자이 102동402 호 .','South Korea','South Korea','50532'),(14,'KOR326276','Shirley N. Weber, Ph.D., California Secretary of State 1500 11th Street Sacramento, California','United States','California','95814','경북 구미시 고아읍 문성로20 문성파크자이 102동402 호 .','South Korea','South Korea','50532'),(15,'SYR326277','Abdullah Bin Rawtha Street,, Kafar Suseh, Damascus, Syrian Arab Republic.','Syria','Syria','30891','China Hongshan District, Jade Dragon Machine Factory Changqing District, No. 49 Building Division','China','Chifeng','024000'),(16,'AWB00326278','3, Suite 31 , SJOG Wexford Medical Centre, Barry Marshall Parade, Murdoch WA 6150, Australia','Australia','Perth','WA6150','ot A/7/2/C, The Brighton Condominium, Jln Temenggong Oyang Lawai Jau, 98008 Miri Sarawak','Malaysia','Sarawak','98008'),(17,'AWB00326278','NO 4 Chemical Manufacturer, Ampang Jaya Selangor','Malaysia','Kuala Lumpur','43200','1389/4 Soi Eiamying Chan Rd Thung Wat Don Sathon','Thailand','Bangkok','10169'),(18,'AWB326280','NO 4 Chemical Manufacturer, Ampang Jaya Selangor','Malaysia','Kuala Lumpur','43200','1389/4 Soi Eiamying Chan Rd Thung Wat Don Sathon','Thailand','Bangkok','10169'),(19,'AWB326285','NO 4 Chemical Manufacturer, Ampang Jaya Selangor','Malaysia','Kuala Lumpur','43200','1389/4 Soi Eiamying Chan Rd Thung Wat Don Sathon','Thailand','BangKok','10169');

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

CREATE TABLE `cdb_branchoffices` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_branch` varchar(100) DEFAULT NULL,
  `branch_address` varchar(120) DEFAULT NULL,
  `branch_city` varchar(100) DEFAULT NULL,
  `phone_branch` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

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

INSERT INTO `cdb_branchoffices` VALUES (4,'Global Express Group','Eglistrasse 2, 8004, Switzerland','Zürich','(669) 284-3100');

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

CREATE TABLE `cdb_category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_item` varchar(120) DEFAULT NULL,
  `detail_item` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

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

INSERT INTO `cdb_category` VALUES (26,'Air Freight','Air Freight, The Sky&#39;s the Limit'),(27,'Ocean Freight','Ocean Freight, The World is Your Oyster'),(28,'Road Freight','Road Freight, All Roads Lead to SAIGON SHIPPING'),(29,'Rail Freight','Rail Freight, On Track with the New Silk Road');

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

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

--
-- Dumping data for table `cdb_charges_order`
--


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

CREATE TABLE `cdb_consolidate` (
  `consolidate_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `c_prefix` varchar(300) DEFAULT NULL,
  `c_no` varchar(350) DEFAULT NULL,
  `c_date` date DEFAULT NULL,
  `sender_id` int DEFAULT NULL,
  `sender_address_id` int DEFAULT NULL,
  `receiver_id` int DEFAULT NULL,
  `receiver_address_id` int 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 DEFAULT NULL,
  `person_receives` varchar(300) DEFAULT NULL,
  `photo_delivered` varchar(300) DEFAULT NULL,
  `seals_package` varchar(300) DEFAULT NULL,
  `status_invoice` int DEFAULT NULL,
  `url_payment_attach` varchar(350) DEFAULT NULL,
  `notes` mediumtext,
  `payment_date` datetime DEFAULT NULL,
  PRIMARY KEY (`consolidate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cdb_consolidate`
--


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

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

--
-- Dumping data for table `cdb_consolidate_detail`
--


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

CREATE TABLE `cdb_countries` (
  `id` int unsigned NOT NULL,
  `full_name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `iso_3166_2` varchar(2) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `iso_3166_3` varchar(3) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `cdb_countries` VALUES (4,'Islamic Republic of Afghanistan','AF','AFG','Afghanistan'),(8,'Republic of Albania','AL','ALB','Albania'),(10,'Antarctica','AQ','ATA','Antarctica'),(12,'Peopleâ€™s Democratic Republic of Algeria','DZ','DZA','Algeria'),(16,'Territory of American','AS','ASM','American Samoa'),(20,'Principality of Andorra','AD','AND','Andorra'),(24,'Republic of Angola','AO','AGO','Angola'),(28,'Antigua and Barbuda','AG','ATG','Antigua and Barbuda'),(31,'Republic of Azerbaijan','AZ','AZE','Azerbaijan'),(32,'Argentine Republic','AR','ARG','Argentina'),(36,'Commonwealth of Australia','AU','AUS','Australia'),(40,'Republic of Austria','AT','AUT','Austria'),(44,'Commonwealth of the Bahamas','BS','BHS','Bahamas'),(48,'Kingdom of Bahrain','BH','BHR','Bahrain'),(50,'Peopleâ€™s Republic of Bangladesh','BD','BGD','Bangladesh'),(51,'Republic of Armenia','AM','ARM','Armenia'),(52,'Barbados','BB','BRB','Barbados'),(56,'Kingdom of Belgium','BE','BEL','Belgium'),(60,'Bermuda','BM','BMU','Bermuda'),(64,'Kingdom of Bhutan','BT','BTN','Bhutan'),(68,'Plurinational State of Bolivia','BO','BOL','Bolivia, Plurinational State of'),(70,'Bosnia and Herzegovina','BA','BIH','Bosnia and Herzegovina'),(72,'Republic of Botswana','BW','BWA','Botswana'),(74,'Bouvet Island','BV','BVT','Bouvet Island'),(76,'Federative Republic of Brazil','BR','BRA','Brazil'),(84,'Belize','BZ','BLZ','Belize'),(86,'British Indian Ocean Territory','IO','IOT','British Indian Ocean Territory'),(90,'Solomon Islands','SB','SLB','Solomon Islands'),(92,'British Virgin Islands','VG','VGB','Virgin Islands, British'),(96,'Brunei Darussalam','BN','BRN','Brunei Darussalam'),(100,'Republic of Bulgaria','BG','BGR','Bulgaria'),(104,'Union of Myanmar/','MM','MMR','Myanmar'),(108,'Republic of Burundi','BI','BDI','Burundi'),(112,'Republic of Belarus','BY','BLR','Belarus'),(116,'Kingdom of Cambodia','KH','KHM','Cambodia'),(120,'Republic of Cameroon','CM','CMR','Cameroon'),(124,'Canada','CA','CAN','Canada'),(132,'Republic of Cape Verde','CV','CPV','Cape Verde'),(136,'Cayman Islands','KY','CYM','Cayman Islands'),(140,'Central African Republic','CF','CAF','Central African Republic'),(144,'Democratic Socialist Republic of Sri Lanka','LK','LKA','Sri Lanka'),(148,'Republic of Chad','TD','TCD','Chad'),(152,'Republic of Chile','CL','CHL','Chile'),(156,'Peopleâ€™s Republic of China','CN','CHN','China'),(158,'Republic of China, Taiwan (TW1)','TW','TWN','Taiwan, Province of China'),(162,'Christmas Island Territory','CX','CXR','Christmas Island'),(166,'Territory of Cocos (Keeling) Islands','CC','CCK','Cocos (Keeling) Islands'),(170,'Republic of Colombia','CO','COL','Colombia'),(174,'Union of the Comoros','KM','COM','Comoros'),(175,'Departmental Collectivity of Mayotte','YT','MYT','Mayotte'),(178,'Republic of the Congo','CG','COG','Congo'),(180,'Democratic Republic of the Congo','CD','COD','Congo, the Democratic Republic of the'),(184,'Cook Islands','CK','COK','Cook Islands'),(188,'Republic of Costa Rica','CR','CRI','Costa Rica'),(191,'Republic of Croatia','HR','HRV','Croatia'),(192,'Republic of Cuba','CU','CUB','Cuba'),(196,'Republic of Cyprus','CY','CYP','Cyprus'),(203,'Czech Republic','CZ','CZE','Czech Republic'),(204,'Republic of Benin','BJ','BEN','Benin'),(208,'Kingdom of Denmark','DK','DNK','Denmark'),(212,'Commonwealth of Dominica','DM','DMA','Dominica'),(214,'Dominican Republic','DO','DOM','Dominican Republic'),(218,'Republic of Ecuador','EC','ECU','Ecuador'),(222,'Republic of El Salvador','SV','SLV','El Salvador'),(226,'Republic of Equatorial Guinea','GQ','GNQ','Equatorial Guinea'),(231,'Federal Democratic Republic of Ethiopia','ET','ETH','Ethiopia'),(232,'State of Eritrea','ER','ERI','Eritrea'),(233,'Republic of Estonia','EE','EST','Estonia'),(234,'Faeroe Islands','FO','FRO','Faroe Islands'),(238,'Falkland Islands','FK','FLK','Falkland Islands (Malvinas)'),(239,'South Georgia and the South Sandwich Islands','GS','SGS','South Georgia and the South Sandwich Islands'),(242,'Republic of Fiji','FJ','FJI','Fiji'),(246,'Republic of Finland','FI','FIN','Finland'),(248,'Ã…land Islands','AX','ALA','Ã…land Islands'),(250,'French Republic','FR','FRA','France'),(254,'French Guiana','GF','GUF','French Guiana'),(258,'French Polynesia','PF','PYF','French Polynesia'),(260,'French Southern and Antarctic Lands','TF','ATF','French Southern Territories'),(262,'Republic of Djibouti','DJ','DJI','Djibouti'),(266,'Gabonese Republic','GA','GAB','Gabon'),(268,'Georgia','GE','GEO','Georgia'),(270,'Republic of the Gambia','GM','GMB','Gambia'),(275,NULL,'PS','PSE','Palestinian Territory, Occupied'),(276,'Federal Republic of Germany','DE','DEU','Germany'),(288,'Republic of Ghana','GH','GHA','Ghana'),(292,'Gibraltar','GI','GIB','Gibraltar'),(296,'Republic of Kiribati','KI','KIR','Kiribati'),(300,'Hellenic Republic','GR','GRC','Greece'),(304,'Greenland','GL','GRL','Greenland'),(308,'Grenada','GD','GRD','Grenada'),(312,'Guadeloupe','GP','GLP','Guadeloupe'),(316,'Territory of Guam','GU','GUM','Guam'),(320,'Republic of Guatemala','GT','GTM','Guatemala'),(324,'Republic of Guinea','GN','GIN','Guinea'),(328,'Cooperative Republic of Guyana','GY','GUY','Guyana'),(332,'Republic of Haiti','HT','HTI','Haiti'),(334,'Territory of Heard Island and McDonald Islands','HM','HMD','Heard Island and McDonald Islands'),(336,'the Holy See/ Vatican City State','VA','VAT','Holy See (Vatican City State)'),(340,'Republic of Honduras','HN','HND','Honduras'),(344,'Hong Kong Special Administrative Region of the Peopleâ€™s Republic of China (HK2)','HK','HKG','Hong Kong'),(348,'Republic of Hungary','HU','HUN','Hungary'),(352,'Republic of Iceland','IS','ISL','Iceland'),(356,'Republic of India','IN','IND','India'),(360,'Republic of Indonesia','ID','IDN','Indonesia'),(364,'Islamic Republic of Iran','IR','IRN','Iran, Islamic Republic of'),(368,'Republic of Iraq','IQ','IRQ','Iraq'),(372,'Ireland (IE1)','IE','IRL','Ireland'),(376,'State of Israel','IL','ISR','Israel'),(380,'Italian Republic','IT','ITA','Italy'),(384,'Republic of CÃ´te dâ€™Ivoire','CI','CIV','CÃ´te d\'Ivoire'),(388,'Jamaica','JM','JAM','Jamaica'),(392,'Japan','JP','JPN','Japan'),(398,'Republic of Kazakhstan','KZ','KAZ','Kazakhstan'),(400,'Hashemite Kingdom of Jordan','JO','JOR','Jordan'),(404,'Republic of Kenya','KE','KEN','Kenya'),(408,'Democratic Peopleâ€™s Republic of Korea','KP','PRK','Korea, Democratic People\'s Republic of'),(410,'Republic of Korea','KR','KOR','Korea, Republic of'),(414,'State of Kuwait','KW','KWT','Kuwait'),(417,'Kyrgyz Republic','KG','KGZ','Kyrgyzstan'),(418,'Lao Peopleâ€™s Democratic Republic','LA','LAO','Lao People\'s Democratic Republic'),(422,'Lebanese Republic','LB','LBN','Lebanon'),(426,'Kingdom of Lesotho','LS','LSO','Lesotho'),(428,'Republic of Latvia','LV','LVA','Latvia'),(430,'Republic of Liberia','LR','LBR','Liberia'),(434,'Socialist Peopleâ€™s Libyan Arab Jamahiriya','LY','LBY','Libya'),(438,'Principality of Liechtenstein','LI','LIE','Liechtenstein'),(440,'Republic of Lithuania','LT','LTU','Lithuania'),(442,'Grand Duchy of Luxembourg','LU','LUX','Luxembourg'),(446,'Macao Special Administrative Region of the Peopleâ€™s Republic of China (MO2)','MO','MAC','Macao'),(450,'Republic of Madagascar','MG','MDG','Madagascar'),(454,'Republic of Malawi','MW','MWI','Malawi'),(458,'Malaysia','MY','MYS','Malaysia'),(462,'Republic of Maldives','MV','MDV','Maldives'),(466,'Republic of Mali','ML','MLI','Mali'),(470,'Republic of Malta','MT','MLT','Malta'),(474,'Martinique','MQ','MTQ','Martinique'),(478,'Islamic Republic of Mauritania','MR','MRT','Mauritania'),(480,'Republic of Mauritius','MU','MUS','Mauritius'),(484,'United Mexican States','MX','MEX','Mexico'),(492,'Principality of Monaco','MC','MCO','Monaco'),(496,'Mongolia','MN','MNG','Mongolia'),(498,'Republic of Moldova','MD','MDA','Moldova, Republic of'),(499,'Montenegro','ME','MNE','Montenegro'),(500,'Montserrat','MS','MSR','Montserrat'),(504,'Kingdom of Morocco','MA','MAR','Morocco'),(508,'Republic of Mozambique','MZ','MOZ','Mozambique'),(512,'Sultanate of Oman','OM','OMN','Oman'),(516,'Republic of Namibia','NA','NAM','Namibia'),(520,'Republic of Nauru','NR','NRU','Nauru'),(524,'Nepal','NP','NPL','Nepal'),(528,'Kingdom of the Netherlands','NL','NLD','Netherlands'),(531,'CuraÃ§ao','CW','CUW','CuraÃ§ao'),(533,'Aruba','AW','ABW','Aruba'),(534,'Sint Maarten','SX','SXM','Sint Maarten (Dutch part)'),(535,NULL,'BQ','BES','Bonaire, Sint Eustatius and Saba'),(540,'New Caledonia','NC','NCL','New Caledonia'),(548,'Republic of Vanuatu','VU','VUT','Vanuatu'),(554,'New Zealand','NZ','NZL','New Zealand'),(558,'Republic of Nicaragua','NI','NIC','Nicaragua'),(562,'Republic of Niger','NE','NER','Niger'),(566,'Federal Republic of Nigeria','NG','NGA','Nigeria'),(570,'Niue','NU','NIU','Niue'),(574,'Territory of Norfolk Island','NF','NFK','Norfolk Island'),(578,'Kingdom of Norway','NO','NOR','Norway'),(580,'Commonwealth of the Northern Mariana Islands','MP','MNP','Northern Mariana Islands'),(581,'United States Minor Outlying Islands','UM','UMI','United States Minor Outlying Islands'),(583,'Federated States of Micronesia','FM','FSM','Micronesia, Federated States of'),(584,'Republic of the Marshall Islands','MH','MHL','Marshall Islands'),(585,'Republic of Palau','PW','PLW','Palau'),(586,'Islamic Republic of Pakistan','PK','PAK','Pakistan'),(591,'Republic of Panama','PA','PAN','Panama'),(598,'Independent State of Papua New Guinea','PG','PNG','Papua New Guinea'),(600,'Republic of Paraguay','PY','PRY','Paraguay'),(604,'Republic of Peru','PE','PER','Peru'),(608,'Republic of the Philippines','PH','PHL','Philippines'),(612,'Pitcairn Islands','PN','PCN','Pitcairn'),(616,'Republic of Poland','PL','POL','Poland'),(620,'Portuguese Republic','PT','PRT','Portugal'),(624,'Republic of Guinea-Bissau','GW','GNB','Guinea-Bissau'),(626,'Democratic Republic of East Timor','TL','TLS','Timor-Leste'),(630,'Commonwealth of Puerto Rico','PR','PRI','Puerto Rico'),(634,'State of Qatar','QA','QAT','Qatar'),(638,'RÃ©union','RE','REU','RÃ©union'),(642,'Romania','RO','ROU','Romania'),(643,'Russian Federation','RU','RUS','Russian Federation'),(646,'Republic of Rwanda','RW','RWA','Rwanda'),(652,'Collectivity of Saint BarthÃ©lemy','BL','BLM','Saint BarthÃ©lemy'),(654,'Saint Helena, Ascension and Tristan da Cunha','SH','SHN','Saint Helena, Ascension and Tristan da Cunha'),(659,'Federation of Saint Kitts and Nevis','KN','KNA','Saint Kitts and Nevis'),(660,'Anguilla','AI','AIA','Anguilla'),(662,'Saint Lucia','LC','LCA','Saint Lucia'),(663,'Collectivity of Saint Martin','MF','MAF','Saint Martin (French part)'),(666,'Territorial Collectivity of Saint Pierre and Miquelon','PM','SPM','Saint Pierre and Miquelon'),(670,'Saint Vincent and the Grenadines','VC','VCT','Saint Vincent and the Grenadines'),(674,'Republic of San Marino','SM','SMR','San Marino'),(678,'Democratic Republic of SÃ£o TomÃ© and PrÃ­ncipe','ST','STP','Sao Tome and Principe'),(682,'Kingdom of Saudi Arabia','SA','SAU','Saudi Arabia'),(686,'Republic of Senegal','SN','SEN','Senegal'),(688,'Republic of Serbia','RS','SRB','Serbia'),(690,'Republic of Seychelles','SC','SYC','Seychelles'),(694,'Republic of Sierra Leone','SL','SLE','Sierra Leone'),(702,'Republic of Singapore','SG','SGP','Singapore'),(703,'Slovak Republic','SK','SVK','Slovakia'),(704,'Socialist Republic of Vietnam','VN','VNM','Viet Nam'),(705,'Republic of Slovenia','SI','SVN','Slovenia'),(706,'Somali Republic','SO','SOM','Somalia'),(710,'Republic of South Africa','ZA','ZAF','South Africa'),(716,'Republic of Zimbabwe','ZW','ZWE','Zimbabwe'),(724,'Kingdom of Spain','ES','ESP','Spain'),(728,'Republic of South Sudan','SS','SSD','South Sudan'),(729,'Republic of the Sudan','SD','SDN','Sudan'),(732,'Western Sahara','EH','ESH','Western Sahara'),(740,'Republic of Suriname','SR','SUR','Suriname'),(744,'Svalbard and Jan Mayen','SJ','SJM','Svalbard and Jan Mayen'),(748,'Kingdom of Swaziland','SZ','SWZ','Swaziland'),(752,'Kingdom of Sweden','SE','SWE','Sweden'),(756,'Swiss Confederation','CH','CHE','Switzerland'),(760,'Syrian Arab Republic','SY','SYR','Syrian Arab Republic'),(762,'Republic of Tajikistan','TJ','TJK','Tajikistan'),(764,'Kingdom of Thailand','TH','THA','Thailand'),(768,'Togolese Republic','TG','TGO','Togo'),(772,'Tokelau','TK','TKL','Tokelau'),(776,'Kingdom of Tonga','TO','TON','Tonga'),(780,'Republic of Trinidad and Tobago','TT','TTO','Trinidad and Tobago'),(784,'United Arab Emirates','AE','ARE','United Arab Emirates'),(788,'Republic of Tunisia','TN','TUN','Tunisia'),(792,'Republic of Turkey','TR','TUR','Turkey'),(795,'Turkmenistan','TM','TKM','Turkmenistan'),(796,'Turks and Caicos Islands','TC','TCA','Turks and Caicos Islands'),(798,'Tuvalu','TV','TUV','Tuvalu'),(800,'Republic of Uganda','UG','UGA','Uganda'),(804,'Ukraine','UA','UKR','Ukraine'),(807,'the former Yugoslav Republic of Macedonia','MK','MKD','Macedonia, the former Yugoslav Republic of'),(818,'Arab Republic of Egypt','EG','EGY','Egypt'),(826,'United Kingdom of Great Britain and Northern Ireland','GB','GBR','United Kingdom'),(831,'Bailiwick of Guernsey','GG','GGY','Guernsey'),(832,'Bailiwick of Jersey','JE','JEY','Jersey'),(833,'Isle of Man','IM','IMN','Isle of Man'),(834,'United Republic of Tanzania','TZ','TZA','Tanzania, United Republic of'),(840,'United States of America','US','USA','United States'),(850,'United States Virgin Islands','VI','VIR','Virgin Islands, U.S.'),(854,'Burkina Faso','BF','BFA','Burkina Faso'),(858,'Eastern Republic of Uruguay','UY','URY','Uruguay'),(860,'Republic of Uzbekistan','UZ','UZB','Uzbekistan'),(862,'Bolivarian Republic of Venezuela','VE','VEN','Venezuela, Bolivarian Republic of'),(876,'Wallis and Futuna','WF','WLF','Wallis and Futuna'),(882,'Independent State of Samoa','WS','WSM','Samoa'),(887,'Republic of Yemen','YE','YEM','Yemen'),(894,'Republic of Zambia','ZM','ZMB','Zambia');

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

CREATE TABLE `cdb_courier_com` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=96 DEFAULT CHARSET=latin1;

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

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

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

CREATE TABLE `cdb_courier_track` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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 DEFAULT NULL,
  `office_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=77 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cdb_courier_track`
--

INSERT INTO `cdb_courier_track` VALUES (43,'THA326271','Thailand','Bangkok Thailand','This shipment has already arrived in Bangkok Thailand.','2025-02-27 00:15:29',26,86,1),(44,'THA326271','Thailand','Bangkok Thailand','This shipment has arrived, Waiting for pickup','2025-02-27 09:22:13',2,86,1),(42,'THA326271','Indonesia','Jakarta Indonesia','This shipment has been in Transit Jakarta Indonesia.','2025-02-26 13:04:40',3,86,1),(41,'THA326271',NULL,NULL,'Shipping created','2025-02-25 12:26:08',27,86,1),(45,'THA326271','Thailand','Bangkok Thailand','This shipment has been Picked up','2025-02-27 11:02:35',28,86,1),(46,'AWB326272',NULL,NULL,'Shipping created','2025-03-01 19:56:10',28,86,1),(47,'IDN326274',NULL,NULL,'Shipping created','2025-03-09 10:51:29',10,86,1),(48,'IDN326274','Malaysia','Kuala Lumpur','This shipment has departed from Kuala Lumpur Malaysia to Indonesia','2025-03-09 11:15:29',27,86,1),(49,'0326275',NULL,NULL,'Shipping created','2025-03-15 00:40:42',10,86,1),(50,'KOR326276',NULL,NULL,'Shipping created','2025-03-15 01:06:11',10,86,1),(51,'KOR326276','United States','California','This Shipment has been Departed from the United States of America','2025-03-14 01:49:35',27,86,1),(52,'KOR326276','Denmark','Copenhagen','This Shipment has been in Transit in Copenhagen Denmark','2025-03-15 08:52:11',3,86,1),(53,'SYR326277',NULL,NULL,'Shipping created','2025-03-15 17:56:22',10,86,1),(54,'SYR326277','Syrian Arab Republic','Syria','This shipment has been Departed from Syria','2025-03-15 18:02:14',27,86,1),(55,'KOR326276','Japan','Tokyo Japan','This Shipment has been in Transit in Tokyo Japan','2025-03-15 20:49:45',3,86,1),(56,'KOR326276','Korea, Republic of','South Korea','This Shipment has been On Hold in South Korea','2025-03-16 00:57:59',24,86,1),(57,'SYR326277','Japan','Tokyo Japan','This shipment has been in transit in Tokyo Japan.','2025-03-16 16:03:07',3,86,1),(58,'SYR326277','Malaysia','Kuala Lumpur Malaysia','This shipment has been in transit in Kuala Lumpur Malaysia.','2025-03-17 08:50:45',3,86,1),(59,'AWB00326278',NULL,NULL,'Shipping created','2025-03-21 19:20:22',3,86,1),(60,'AWB00326278','New Zealand','Auckland','Processing by Auckland Custom','2025-03-22 13:56:38',3,86,1),(61,'AWB00326278','Singapore','Singapore','Arrived Singapore and going through Custom Inspection','2025-03-23 08:43:58',3,86,1),(62,'AWB00326278','Malaysia','Kuala Lumpur','','2025-03-24 10:10:03',26,86,1),(63,'AWB00326278','Malaysia','Kuala Lumpur','On hold pending custom clearance','2025-03-24 10:11:29',24,86,1),(64,'AWB00326278',NULL,NULL,'Shipping created','2025-03-27 11:10:38',10,86,1),(65,'AWB326280',NULL,NULL,'Shipping created','2025-03-27 11:25:48',10,86,1),(66,'AWB326280','Malaysia','Kuala Lumpur','This Shipment has departed from Kuala Lumpur','2025-03-27 12:02:17',27,86,1),(67,'AWB326280','Indonesia','Jakarta Indonesia','This shipment has been in transit in Jakarta Indonesia','2025-03-27 19:00:25',3,86,1),(68,'AWB326280','Thailand','Bangkok Thailand','This shipment has been arrived in Bangkok Thailand','2025-03-28 13:26:15',26,86,1),(69,'AWB326280','Thailand','Bangkok Thailand','This shipment has been arrived in Bangkok Thailand, Pending for collection.','2025-03-28 13:34:20',1,86,1),(70,'AWB326280','Thailand','Bangkok','This shipment has been picked up','2025-03-28 14:13:48',28,86,1),(71,'AWB326285',NULL,NULL,'Shipping created','2025-04-17 13:42:02',10,86,1),(72,'AWB326285','Malaysia','Kuala Lumpur','This shipment has been departed from Kuala Lumpur','2025-04-17 14:25:58',27,86,1),(73,'AWB326285','Indonesia','Jakarta','This shipment has been on transit in Jakarta Indonesia.','2025-04-17 21:38:36',3,86,1),(74,'AWB326285','Thailand','Bangkok','This shipment has been Arrived in Bangkok Thailand.','2025-04-18 09:38:47',26,86,1),(75,'AWB326285','Thailand','Bangkok','This shipment has arrived in Thailand, Available for pick up','2025-04-18 11:25:51',6,86,1),(76,'AWB326285','Thailand','Bangkok','This shipment has been picked up.','2025-04-18 11:44:23',28,86,1);

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

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

--
-- Dumping data for table `cdb_customer_package_files`
--


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

CREATE TABLE `cdb_customers_packages` (
  `order_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `order_prefix` varchar(300) DEFAULT NULL,
  `order_no` varchar(350) DEFAULT NULL,
  `order_date` date DEFAULT NULL,
  `sender_id` int DEFAULT NULL,
  `sender_address_id` int 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 DEFAULT NULL,
  `origin_off` int DEFAULT NULL,
  `order_package` int DEFAULT NULL,
  `order_item_category` int DEFAULT NULL,
  `order_courier` int DEFAULT NULL,
  `order_service_options` int DEFAULT NULL,
  `order_deli_time` int DEFAULT NULL,
  `order_pay_mode` int DEFAULT NULL,
  `order_payment_method` int DEFAULT NULL,
  `status_courier` int DEFAULT NULL,
  `driver_id` int DEFAULT NULL,
  `person_receives` varchar(300) DEFAULT NULL,
  `photo_delivered` varchar(300) DEFAULT NULL,
  `status_invoice` int 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,
  `payment_date` datetime DEFAULT NULL,
  `is_prealert` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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


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

CREATE TABLE `cdb_customers_packages_detail` (
  `order_item_id` int NOT NULL AUTO_INCREMENT,
  `order_id` int 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,
  PRIMARY KEY (`order_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cdb_customers_packages_detail`
--

INSERT INTO `cdb_customers_packages_detail` VALUES (4,1,'Locker Box',1.00,'0','0','0','0',950,0);

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

CREATE TABLE `cdb_delivery_time` (
  `id` int NOT NULL AUTO_INCREMENT,
  `delitime` varchar(200) DEFAULT NULL,
  `detail` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

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

INSERT INTO `cdb_delivery_time` VALUES (12,'Global Express 3-5 DAYS','3-5 DAYS'),(13,'TNT 10-14 DAYS','10-14 DAYS'),(14,'Global Express 3-7 DAYS','3-7 DAYS');

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

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

--
-- Dumping data for table `cdb_driver_files`
--


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

CREATE TABLE `cdb_email_templates` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `help` text,
  `body` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb3;

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



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

CREATE TABLE `cdb_incoterm` (
  `id` int NOT NULL AUTO_INCREMENT,
  `inco_name` varchar(200) DEFAULT NULL,
  `detail` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

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

INSERT INTO `cdb_incoterm` 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 NOT NULL AUTO_INCREMENT,
  `met_payment` varchar(200) DEFAULT NULL,
  `detail` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

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

INSERT INTO `cdb_met_payment` 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 NOT NULL AUTO_INCREMENT,
  `title` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `body` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `author` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `created` date NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `cdb_news` 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 NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `order_id` int DEFAULT NULL,
  `notification_description` varchar(350) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `shipping_type` int DEFAULT NULL,
  `notification_date` datetime DEFAULT NULL,
  PRIMARY KEY (`notification_id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cdb_notifications`
--

INSERT INTO `cdb_notifications` VALUES (45,1,9,'There is a new shipment, please check it',1,'2025-02-25 12:26:08'),(46,1,9,'The shipping status has been updated, check it',1,'2025-02-26 13:04:40'),(47,1,9,'The shipping status has been updated, check it',1,'2025-02-27 00:15:29'),(48,1,9,'The shipping status has been updated, check it',1,'2025-02-27 09:22:13'),(49,1,9,'The shipping status has been updated, check it',1,'2025-02-27 11:02:35'),(50,1,10,'There is a new shipment, please check it',1,'2025-03-01 19:56:10'),(51,1,11,'There is a new shipment, please check it',1,'2025-03-09 10:51:30'),(52,1,11,'The shipping status has been updated, check it',1,'2025-03-09 11:15:29'),(53,1,12,'There is a new shipment, please check it',1,'2025-03-15 00:40:42'),(54,1,13,'There is a new shipment, please check it',1,'2025-03-15 01:06:11'),(55,1,13,'The shipping status has been updated, check it',1,'2025-03-15 01:49:35'),(56,1,13,'The shipping status has been updated, check it',1,'2025-03-15 08:52:11'),(57,1,14,'There is a new shipment, please check it',1,'2025-03-15 17:56:23'),(58,1,14,'The shipping status has been updated, check it',1,'2025-03-15 18:02:14'),(59,1,13,'The shipping status has been updated, check it',1,'2025-03-15 20:49:45'),(60,1,13,'The shipping status has been updated, check it',1,'2025-03-16 00:57:59'),(61,1,14,'The shipping status has been updated, check it',1,'2025-03-16 16:03:07'),(62,1,14,'The shipping status has been updated, check it',1,'2025-03-17 08:50:45'),(63,1,15,'There is a new shipment, please check it',1,'2025-03-21 19:20:23'),(64,1,15,'The shipping status has been updated, check it',1,'2025-03-22 13:56:38'),(65,1,15,'The shipping status has been updated, check it',1,'2025-03-23 08:43:58'),(66,1,15,'The shipping status has been updated, check it',1,'2025-03-24 10:10:03'),(67,1,15,'The shipping status has been updated, check it',1,'2025-03-24 10:11:29'),(68,1,16,'There is a new shipment, please check it',1,'2025-03-27 11:10:38'),(69,1,17,'There is a new shipment, please check it',1,'2025-03-27 11:25:48'),(70,1,17,'The shipping status has been updated, check it',1,'2025-03-27 12:02:17'),(71,1,17,'The shipping status has been updated, check it',1,'2025-03-27 19:00:25'),(72,1,17,'The shipping status has been updated, check it',1,'2025-03-28 13:26:15'),(73,1,17,'The shipping status has been updated, check it',1,'2025-03-28 13:34:20'),(74,1,17,'The shipping status has been updated, check it',1,'2025-03-28 14:13:48'),(75,55,NULL,'a new user has been registered',0,'2025-03-29 12:49:30'),(76,1,18,'There is a new shipment, please check it',1,'2025-04-17 13:42:02'),(77,1,18,'The shipping status has been updated, check it',1,'2025-04-17 14:25:58'),(78,1,18,'The shipping status has been updated, check it',1,'2025-04-17 21:38:36'),(79,1,18,'The shipping status has been updated, check it',1,'2025-04-18 09:38:47'),(80,1,18,'The shipping status has been updated, check it',1,'2025-04-18 11:25:51'),(81,1,18,'The shipping status has been updated, check it',1,'2025-04-18 11:44:23'),(82,59,NULL,'a new user has been registered',0,'2025-05-27 04:34:45');

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

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

--
-- Dumping data for table `cdb_notifications_users`
--

INSERT INTO `cdb_notifications_users` VALUES (1,0,1,0,0),(2,1,1,1,1),(3,15,1,0,0),(4,1,2,1,1),(5,2,3,0,0),(6,1,3,1,1),(7,18,3,0,0),(8,2,4,0,0),(9,1,4,1,1),(10,18,4,0,0),(11,2,5,0,0),(12,1,5,1,1),(13,18,5,0,0),(14,2,6,0,0),(15,1,6,1,1),(16,18,6,0,0),(17,2,7,0,0),(18,1,7,1,1),(19,18,7,0,0),(20,2,8,0,0),(21,1,8,1,1),(22,18,8,0,0),(23,2,9,0,0),(24,1,9,1,1),(25,18,9,0,0),(26,2,10,0,0),(27,1,10,1,1),(28,18,10,0,0),(29,2,11,0,0),(30,1,11,1,1),(31,20,11,0,0),(32,2,12,0,0),(33,1,12,1,1),(34,20,12,0,0),(35,2,13,0,0),(36,1,13,1,1),(37,20,13,0,0),(38,2,14,0,0),(39,1,14,1,1),(40,20,14,0,0),(41,2,15,0,0),(42,1,15,1,1),(43,20,15,0,0),(44,2,16,0,0),(45,1,16,1,1),(46,20,16,0,0),(47,2,17,0,0),(48,1,17,0,1),(49,20,17,0,0),(50,2,18,0,0),(51,1,18,0,1),(52,20,18,0,0),(53,2,19,0,0),(54,1,19,0,1),(55,22,19,0,0),(56,2,20,0,0),(57,1,20,0,1),(58,22,20,0,0),(59,2,21,0,0),(60,1,21,0,1),(61,22,21,0,0),(62,2,22,0,0),(63,1,22,0,1),(64,22,22,0,0),(65,2,23,0,0),(66,1,23,0,1),(67,22,23,0,0),(68,2,24,0,0),(69,1,24,0,1),(70,22,24,0,0),(71,2,25,0,0),(72,1,25,0,1),(73,22,25,0,0),(74,2,26,0,0),(75,1,26,0,1),(76,22,26,0,0),(77,1,27,0,1),(78,NULL,27,0,0),(79,2,28,0,0),(80,1,28,0,1),(81,24,28,0,0),(82,2,29,0,0),(83,1,29,0,1),(84,24,29,0,0),(85,2,30,0,0),(86,1,30,0,1),(87,24,30,0,0),(88,2,31,0,0),(89,1,31,0,1),(90,24,31,0,0),(91,2,32,0,0),(92,1,32,0,1),(93,24,32,0,0),(94,2,33,0,0),(95,1,33,0,1),(96,24,33,0,0),(97,2,34,0,0),(98,1,34,0,1),(99,24,34,0,0),(100,2,35,0,0),(101,1,35,0,1),(102,24,35,0,0),(103,1,36,0,1),(104,2,37,0,0),(105,1,37,0,1),(106,26,37,1,1),(107,2,38,0,0),(108,1,38,0,1),(109,26,38,1,1),(110,2,39,0,0),(111,1,39,0,1),(112,26,39,0,1),(113,0,40,0,0),(114,1,40,0,1),(115,30,40,0,0),(116,0,41,0,0),(117,1,41,1,1),(118,30,41,0,0),(119,0,42,0,0),(120,1,42,0,1),(121,30,42,0,0),(122,0,43,0,0),(123,1,43,0,1),(124,30,43,0,0),(125,0,44,0,0),(126,1,44,0,1),(127,30,44,0,0),(128,2,45,0,0),(129,1,45,1,1),(130,32,45,0,0),(131,2,46,0,0),(132,1,46,1,1),(133,32,46,0,0),(134,2,47,0,0),(135,1,47,1,1),(136,32,47,0,0),(137,2,48,0,0),(138,1,48,0,1),(139,32,48,0,0),(140,2,49,0,0),(141,1,49,0,1),(142,32,49,0,0),(143,0,50,0,0),(144,1,50,1,1),(145,35,50,0,0),(146,0,51,0,0),(147,1,51,1,1),(148,37,51,0,0),(149,0,52,0,0),(150,1,52,1,1),(151,37,52,0,0),(152,0,53,0,0),(153,1,53,1,1),(154,39,53,0,0),(155,2,54,0,0),(156,1,54,0,1),(157,41,54,0,0),(158,2,55,0,0),(159,1,55,0,1),(160,41,55,0,0),(161,2,56,0,0),(162,1,56,0,1),(163,45,56,0,0),(164,2,57,0,0),(165,1,57,0,1),(166,47,57,0,0),(167,2,58,0,0),(168,1,58,0,1),(169,47,58,0,0),(170,2,59,0,0),(171,1,59,0,1),(172,45,59,0,0),(173,2,60,0,0),(174,1,60,0,1),(175,45,60,0,0),(176,2,61,0,0),(177,1,61,0,1),(178,47,61,0,0),(179,2,62,0,0),(180,1,62,0,1),(181,47,62,0,0),(182,0,63,0,0),(183,1,63,0,1),(184,49,63,0,0),(185,0,64,0,0),(186,1,64,0,1),(187,49,64,0,0),(188,0,65,0,0),(189,1,65,0,1),(190,49,65,0,0),(191,0,66,0,0),(192,1,66,0,1),(193,49,66,0,0),(194,0,67,0,0),(195,1,67,0,1),(196,49,67,0,0),(197,2,68,0,0),(198,1,68,0,1),(199,51,68,0,0),(200,2,69,0,0),(201,1,69,0,1),(202,53,69,0,0),(203,2,70,0,0),(204,1,70,1,1),(205,53,70,0,0),(206,2,71,0,0),(207,1,71,0,1),(208,53,71,0,0),(209,2,72,0,0),(210,1,72,0,1),(211,53,72,0,0),(212,2,73,0,0),(213,1,73,0,1),(214,53,73,0,0),(215,2,74,0,0),(216,1,74,0,1),(217,53,74,0,0),(218,1,75,0,1),(219,0,76,0,0),(220,1,76,0,1),(221,57,76,0,0),(222,0,77,0,0),(223,1,77,0,1),(224,57,77,0,0),(225,0,78,0,0),(226,1,78,0,1),(227,57,78,0,0),(228,0,79,0,0),(229,1,79,0,1),(230,57,79,0,0),(231,0,80,0,0),(232,1,80,0,1),(233,57,80,0,0),(234,0,81,0,0),(235,1,81,0,1),(236,57,81,0,0),(237,1,82,0,0);

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

CREATE TABLE `cdb_offices` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=87 DEFAULT CHARSET=latin1;

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

INSERT INTO `cdb_offices` VALUES (86,'Global Express Group','RTG78','1199 E Calaveras Blvd','Milpitas, CA 95035','(669) 284-3100');

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

CREATE TABLE `cdb_order_files` (
  `id` int NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL,
  `order_id` int DEFAULT NULL,
  `date_file` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `is_consolidate` int DEFAULT '0',
  `file_type` varchar(300) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cdb_order_files`
--

INSERT INTO `cdb_order_files` VALUES (1,'order_files/1709827561_64223E07-6AE4-424B-8DA4-A6B9BC245184.jpeg',5,'2024-03-08 00:06:01','1709827561_64223E07-6AE4-424B-8DA4-A6B9BC245184.jpeg',0,'jpeg'),(2,'order_files/1709827561_9FDCA424-D61B-459F-B003-5130EBAE90B4.jpeg',5,'2024-03-08 00:06:01','1709827561_9FDCA424-D61B-459F-B003-5130EBAE90B4.jpeg',0,'jpeg');

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

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

--
-- Dumping data for table `cdb_order_user_history`
--

INSERT INTO `cdb_order_user_history` VALUES (1,1,1,'create shipment','2023-10-18 17:03:23',0),(2,1,1,'added status tracking to shipment','2023-10-18 17:08:42',0),(3,1,1,'added status tracking to shipment','2023-10-19 00:22:29',0),(4,1,1,'added status tracking to shipment','2023-10-19 09:24:25',0),(5,1,1,'added status tracking to shipment','2023-10-23 13:25:39',0),(6,1,1,'added status tracking to shipment','2023-10-23 18:59:01',0),(7,1,1,'added status tracking to shipment','2023-10-23 20:17:29',0),(8,1,1,'added status tracking to shipment','2023-10-23 21:13:03',0),(9,1,2,'create shipment','2023-12-09 02:30:11',0),(10,1,2,'added status tracking to shipment','2023-12-09 02:36:38',0),(11,1,2,'added status tracking to shipment','2023-12-09 02:38:26',0),(12,1,2,'added status tracking to shipment','2023-12-10 03:08:03',0),(13,1,2,'added status tracking to shipment','2023-12-11 16:03:25',0),(14,1,2,'added status tracking to shipment','2023-12-11 20:27:54',0),(15,1,2,'added status tracking to shipment','2023-12-11 22:56:30',0),(16,1,2,'added status tracking to shipment','2023-12-12 03:07:13',0),(17,1,3,'create shipment','2024-01-12 20:59:06',0),(18,1,3,'added status tracking to shipment','2024-01-12 21:02:49',0),(19,1,3,'added status tracking to shipment','2024-01-12 23:43:51',0),(20,1,3,'added status tracking to shipment','2024-01-13 14:49:35',0),(21,1,3,'added status tracking to shipment','2024-01-15 06:28:33',0),(22,1,3,'added status tracking to shipment','2024-01-15 15:49:10',0),(23,1,3,'added status tracking to shipment','2024-01-15 20:13:48',0),(24,1,3,'added status tracking to shipment','2024-01-16 03:35:20',0),(25,1,4,'create shipment','2024-02-24 16:43:12',0),(26,1,4,'added status tracking to shipment','2024-02-24 16:54:21',0),(27,1,4,'added status tracking to shipment','2024-02-24 20:09:53',0),(28,1,4,'added status tracking to shipment','2024-02-25 10:12:58',0),(29,1,4,'added status tracking to shipment','2024-02-26 08:26:57',0),(30,1,4,'added status tracking to shipment','2024-02-26 17:24:21',0),(31,1,4,'added status tracking to shipment','2024-02-27 03:27:03',0),(32,1,4,'added status tracking to shipment','2024-02-27 05:37:36',0),(33,26,5,'create shipping pickup','2024-03-08 00:06:04',0),(34,26,6,'create shipping pickup','2024-03-08 08:00:36',0),(35,26,7,'create shipping pickup','2024-03-18 21:38:15',0),(36,1,8,'create shipment','2025-01-21 18:39:31',0),(37,1,8,'added status tracking to shipment','2025-01-21 18:44:51',0),(38,1,8,'update shipment','2025-01-21 18:51:53',0),(39,1,8,'update shipment','2025-01-21 18:52:45',0),(40,1,8,'update shipment','2025-01-21 23:35:58',0),(41,1,8,'update shipment','2025-01-22 16:40:45',0),(42,1,8,'update shipment','2025-01-23 08:26:47',0),(43,1,8,'added status tracking to shipment','2025-01-23 08:33:42',0),(44,1,8,'added status tracking to shipment','2025-01-23 22:50:41',0),(45,1,8,'added status tracking to shipment','2025-01-27 16:07:30',0),(46,1,9,'create shipment','2025-02-25 12:26:08',0),(47,1,9,'update shipment','2025-02-25 12:30:35',0),(48,1,9,'added status tracking to shipment','2025-02-26 13:04:40',0),(49,1,9,'added status tracking to shipment','2025-02-27 00:15:29',0),(50,1,9,'added status tracking to shipment','2025-02-27 09:22:13',0),(51,1,9,'added status tracking to shipment','2025-02-27 11:02:35',0),(52,1,10,'create shipment','2025-03-01 19:56:10',0),(53,1,10,'update shipment','2025-03-01 19:58:43',0),(54,1,11,'create shipment','2025-03-09 10:51:30',0),(55,1,11,'added status tracking to shipment','2025-03-09 11:15:29',0),(56,1,12,'create shipment','2025-03-15 00:40:42',0),(57,1,13,'create shipment','2025-03-15 01:06:11',0),(58,1,13,'added status tracking to shipment','2025-03-14 01:49:35',0),(59,1,13,'update shipment','2025-03-15 02:04:27',0),(60,1,13,'update shipment','2025-03-15 02:10:40',0),(61,1,13,'added status tracking to shipment','2025-03-15 08:52:11',0),(62,1,14,'create shipment','2025-03-15 17:56:23',0),(63,1,14,'added status tracking to shipment','2025-03-15 18:02:14',0),(64,1,13,'added status tracking to shipment','2025-03-15 20:49:45',0),(65,1,13,'added status tracking to shipment','2025-03-16 00:57:59',0),(66,1,14,'added status tracking to shipment','2025-03-16 16:03:07',0),(67,1,14,'added status tracking to shipment','2025-03-17 08:50:45',0),(68,1,15,'create shipment','2025-03-21 19:20:23',0),(69,1,15,'update shipment','2025-03-21 19:21:06',0),(70,1,15,'added status tracking to shipment','2025-03-22 13:56:38',0),(71,1,15,'added status tracking to shipment','2025-03-23 08:43:58',0),(72,1,15,'added status tracking to shipment','2025-03-24 10:10:03',0),(73,1,15,'added status tracking to shipment','2025-03-24 10:11:29',0),(74,1,16,'create shipment','2025-03-27 11:10:38',0),(75,1,17,'create shipment','2025-03-27 11:25:48',0),(76,1,17,'added status tracking to shipment','2025-03-27 12:02:17',0),(77,1,17,'added status tracking to shipment','2025-03-27 19:00:25',0),(78,1,17,'added status tracking to shipment','2025-03-28 13:26:15',0),(79,1,17,'added status tracking to shipment','2025-03-28 13:34:20',0),(80,1,17,'added status tracking to shipment','2025-03-28 14:13:48',0),(81,1,18,'create shipment','2025-04-17 13:42:02',0),(82,1,18,'added status tracking to shipment','2025-04-17 14:25:58',0),(83,1,18,'added status tracking to shipment','2025-04-17 21:38:36',0),(84,1,18,'added status tracking to shipment','2025-04-18 09:38:47',0),(85,1,18,'added status tracking to shipment','2025-04-18 11:25:51',0),(86,1,18,'added status tracking to shipment','2025-04-18 11:44:23',0);

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

CREATE TABLE `cdb_packaging` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_pack` varchar(120) DEFAULT NULL,
  `detail_pack` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

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

INSERT INTO `cdb_packaging` VALUES (22,'FLAT SMALL BOX','FLAT RATE SMALL BOX $90'),(23,'FLAT MEDIUM BOX','FLAT RATE MEDIUM BOX $140'),(24,'SMALL BOX','SMALL BOX'),(25,'MEDIUM BOX','MEDIUM BOX'),(26,'EXTRA SMALL','EXTRA SMALL BOX'),(27,'LARGE BOX','LARGE BOX');

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

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

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

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

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

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

--
-- Dumping data for table `cdb_payments_gateway`
--


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

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

--
-- Dumping data for table `cdb_pre_alert`
--


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

CREATE TABLE `cdb_shipping_line` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ship_line` varchar(200) DEFAULT NULL,
  `detail` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

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

INSERT INTO `cdb_shipping_line` 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 NOT NULL AUTO_INCREMENT,
  `ship_mode` varchar(200) DEFAULT NULL,
  `detail` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

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

INSERT INTO `cdb_shipping_mode` VALUES (7,'Global Express Air','2-3 DAYS'),(8,'Global Express Container','3-5 DAYS');

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

CREATE TABLE `cdb_styles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `mod_style` varchar(200) DEFAULT NULL,
  `detail` varchar(200) DEFAULT NULL,
  `color` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

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

INSERT INTO `cdb_styles` VALUES (1,'Pending Collection','Pending Collection','#a3a3a3'),(2,'Received Office','Received Office','#36bea6'),(3,'In Transit','In Transit','#00e39a'),(4,'In Warehouse','In Warehouse','#e0ce07'),(5,'Distribution','Distribution','#cd88ee'),(6,'Available','Available (only when you must retire at the offices)','#0ae4ff'),(7,'On Route','En route for delivery (only when it\'s door to door)','#7460ee'),(8,'Delivered','Deliveries delivered','#43bd00'),(10,'Approved','Reserve Approved','#ffa6a6'),(11,'Pending','Pending','#ffbc34'),(12,'Rejected','Booking Online Canceled','#fb8c00'),(13,'Consolidate','Consolidated Shipments','#00ffbb'),(14,'Pick up','Pick up package','#2962FF'),(15,'Picked up','Picked up package','#00adf2'),(16,'No Picked up','Not picked up package','#ff008c'),(17,'Quotation','Quotation List','#00ffc4'),(18,'Pending quote','Pending quote','#68c251'),(19,'Invoiced','Quotation approved quotation','#1ac9d9'),(21,'Cancelled','cancelled','#f62d51'),(23,'Pending payment','pending payment','#ffbc34'),(24,'On Hold','Shipment Hold in Custom','#0088cc'),(25,'Custom Inspection','Custom Inspection','#141617'),(26,'Arrived','Shipment Arrived','#141715'),(27,'Departed','Shipment departed','#2cdb72'),(28,'Picked-up','Picked-up','#00cc44');

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

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

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

INSERT INTO `cdb_users_multiple_addresses` VALUES (1,'No 14 Lapaz Avenu','Ghana','Accra','43200',15),(2,'No 23 Shah Bandar Makohta','Malaysia','Cheras','43200',16),(3,'FULHAM ROAD','UNITED KINGDOM','KONDON','SW6 5PX',17),(4,'2213 POQUITO AUSTIN','USA','TX','78722',18),(5,'6900 AUDUBON DRIVE  ALLEN','USA','TX','75002',19),(6,'FULHAM ROAD','UNITED KINGDOM','LONDON','SW6 5PX',20),(7,'LOT 841, OCEAN PARK LAUTAN 5 MIRI','MALAYSIA','SARAWAK','98000',21),(8,'FULHAM ROAD','UNITED KINGDOM','LONDON','SW6 5PX',22),(9,'BLK 638 WOODLANDS RING ROAD #12-43','SINGAPORE','SINGAPORE','730638',23),(10,'FULHAM ROAD','United Kingdom','LONDON','SW6 5PX',24),(11,'P O BOX 729 PENAMPANG','MALAYSIA','SABAH','89507',25),(12,'Corrigan TX 75939','USA','Texas','75939',26),(13,'7846 FM1987  Corrigan TX 75939','USA','Texas','75939',26),(14,'7846 FM1987  Corrigan TX 75939','USA','Texas','75939',27),(15,'Dongyang Branch, Dianbai District, Maoming City, Guangdong Province','China','Dianbai','510000',28),(16,'No 56, Beijing, China','China','Beijing','065001',29),(17,'3 Wing Ming St, Cheung Sha Wan, Hong Kong','Hong Kong','Hong Kong','999077',30),(18,'Seseong,Wangsimni-Ro,24, Nagil25, Seongdong-ku, Seoul, Korea','South Korea','Seoul','01000',31),(19,'NO 4 Chemical Manufacturer, Ampang Jaya Selangor','Malaysia','Kuala Lumpur','46350',32),(20,'1389/4 Soi Eiamying Chan Rd Thung Wat Don Sathon','Thailand','Bangkok','10120',33),(21,'withson house','Australia','Perth','42100',34),(22,'Suite 4, 130 Pitt Street, City, Sydney.','Australia','Perth','6053',35),(23,'1176, Regat Emas 2 Taman Bandar Baru 31900 KAMPAR PERAK','Malaysia','Kampar Perak','31900',36),(24,'NO 4 Chemical Manufacturer, Ampang Jaya Selangor','Malaysia','Kuala Lumpur','46350',37),(25,'Jl Sultan Agung 33 Jaksel Setia Budi Asrama Pomdam Jaya  Indonesia','Indonesia','Jakarta Indonesia','10110',38),(26,'20812 Ventura Boulevard Suite #210, Woodland Hills, CA‎','United State','California','90001',39),(27,'경북 구미시 고아읍 문성로20 문성파크자이 102동402 호 .','South Korea','South Korea','50532',40),(28,'20812 Ventura Boulevard Suite #210, Woodland Hills, CA‎','United State','California','90001',41),(29,'경북 구미시 고아읍 문성로20 문성파크자이 102동402 호 .','South Korea','South Korea','50532',42),(30,'경북 구미시 고아읍 문성로20 문성파크자이 102동402 호 .','South Korea','South Korea','50532',43),(31,'Shirley N. Weber, Ph.D., California Secretary of State 1500 11th Street Sacramento, California','United States','California','95814',44),(32,'Shirley N. Weber, Ph.D., California Secretary of State 1500 11th Street Sacramento, California','United States','California','95814',45),(33,'경북 구미시 고아읍 문성로20 문성파크자이 102동402 호 .','South Korea','South Korea','50532',46),(34,'Abdullah Bin Rawtha Street,, Kafar Suseh, Damascus, Syrian Arab Republic.','Syria','Syria','30891',47),(35,'China Hongshan District, Jade Dragon Machine Factory Changqing District, No. 49 Building Division','China','Chifeng','024000',48),(36,'3, Suite 31 , SJOG Wexford Medical Centre, Barry Marshall Parade, Murdoch WA 6150, Australia','Australia','Perth','WA6150',49),(37,'ot A/7/2/C, The Brighton Condominium, Jln Temenggong Oyang Lawai Jau, 98008 Miri Sarawak','Malaysia','Sarawak','98008',50),(38,'NO 4 Chemical Manufacturer, Ampang Jaya Selangor','Malaysia','Kuala Lumpur','43200',51),(39,'1389/4 Soi Eiamying Chan Rd Thung Wat Don Sathon','Thailand','Bangkok','10169',52),(40,'NO 4 Chemical Manufacturer, Ampang Jaya Selangor','Malaysia','Kuala Lumpur','43200',53),(41,'1389/4 Soi Eiamying Chan Rd Thung Wat Don Sathon','Thailand','Bangkok','10169',54),(42,'Black 9 6A pearl Street','Philippines','CITY OF SAN FERNANDO','2002',55),(43,'NO 4 Chemical Manufacturer, Ampang Jaya Selangor','Malaysia','Kuala Lumpur','43200',56),(44,'NO 4 Chemical Manufacturer, Ampang Jaya Selangor','Malaysia','Kuala Lumpur','43200',57),(45,'1389/4 Soi Eiamying Chan Rd Thung Wat Don Sathon','Thailand','BangKok','10169',58),(46,'tecomatlan lte3 mza 9, col margarita moran velia','México','XALAPA','91097',59);

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

CREATE TABLE `cdb_zone` (
  `zone_id` int NOT NULL AUTO_INCREMENT,
  `country_code` char(2) COLLATE utf8mb3_bin NOT NULL,
  `zone_name` varchar(35) COLLATE utf8mb3_bin NOT NULL,
  PRIMARY KEY (`zone_id`),
  KEY `idx_country_code` (`country_code`),
  KEY `idx_zone_name` (`zone_name`)
) ENGINE=MyISAM AUTO_INCREMENT=425 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

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

INSERT INTO `cdb_zone` 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');


