-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 30, 2024 at 10:08 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `robipos`
--

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

--
-- Table structure for table `countrycodes`
--

CREATE TABLE `countrycodes` (
  `id` int(50) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text,
  `status` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countrycodes`
--

INSERT INTO `countrycodes` (`id`, `name`, `code`, `description`, `status`) VALUES
(1, 'ASCENSION ISLAND ', 'AC', NULL, 'Y'),
(2, 'ANDORRA', 'AD', NULL, 'Y'),
(3, 'UNITED ARAB EMIRATES ', 'AE', NULL, 'Y'),
(4, 'ANTIGUA AND BARBUDA', 'AG', NULL, 'Y'),
(5, 'ANGUILLA', 'AI', NULL, 'Y'),
(6, 'ALBANIA ', 'AL', NULL, 'Y'),
(7, 'ARMENIA', 'AM', NULL, 'Y'),
(8, 'NETHERLANDS ANTILLES ', 'AN', NULL, 'Y'),
(9, 'ANGOLA', 'AO', NULL, 'Y'),
(10, 'ANTARCTICA', 'AQ', NULL, 'Y'),
(11, 'ARGENTINA', 'AR', NULL, 'Y'),
(12, 'AMERICAN SAMOA', 'AS', NULL, 'Y'),
(13, 'AUSTRIA', 'AT', NULL, 'Y'),
(14, 'AUSTRALIA', 'AU', NULL, 'Y'),
(15, 'ARUBA', 'AW', NULL, 'Y'),
(16, 'ALAND ISLANDS', 'AX', NULL, 'Y'),
(17, 'AZERBAIJAN', 'AZ', NULL, 'Y'),
(18, 'BOSNIA AND HERZEGOVINA ', 'BA', NULL, 'Y'),
(19, 'BARBADOS ', 'BB', NULL, 'Y'),
(20, 'BANGLADESH ', 'BD', NULL, 'Y'),
(21, 'BELGIUM ', 'BE', NULL, 'Y'),
(22, 'BURKINA FASO ', 'BF', NULL, 'Y'),
(23, 'BULGARIA ', 'BG', NULL, 'Y'),
(24, 'BAHRAIN', 'BH', NULL, 'Y'),
(25, 'BURUNDI ', 'BI', NULL, 'Y'),
(26, 'BENIN ', 'BJ', NULL, 'Y'),
(27, 'BERMUDA ', 'BM', NULL, 'Y'),
(28, 'BRUNEI DARUSSALAM ', 'BN', NULL, 'Y'),
(29, 'BOLIVIA ', 'BO', NULL, 'Y'),
(30, 'BRAZIL ', 'BR', NULL, 'Y'),
(31, 'BAHAMAS ', 'BS', NULL, 'Y'),
(32, 'BHUTAN ', 'BT', NULL, 'Y'),
(33, 'BOUVET ISLAND ', 'BV', NULL, 'Y'),
(34, 'BOTSWANA ', 'BW', NULL, 'Y'),
(35, 'BELARUS ', 'BY', NULL, 'Y'),
(36, 'BELIZE ', 'BZ', NULL, 'Y'),
(37, 'CANADA ', 'CA', NULL, 'Y'),
(38, 'COCOS (KEELING) ISLANDS ', 'CC', NULL, 'Y'),
(39, 'CONGO, DEMOCRATIC REPUBLIC ', 'CD', NULL, 'Y'),
(40, 'CENTRAL AFRICAN REPUBLIC ', 'CF', NULL, 'Y'),
(41, 'CONGO ', 'CG', NULL, 'Y'),
(42, 'SWITZERLAND ', 'CH', NULL, 'Y'),
(43, 'COTE D\'IVOIRE (IVORY COAST) ', 'CI', NULL, 'Y'),
(44, 'COOK ISLANDS ', 'CK', NULL, 'Y'),
(45, 'CHILE ', 'CL', NULL, 'Y'),
(46, 'CAMEROON ', 'CM', NULL, 'Y'),
(47, 'CHINA ', 'CN', NULL, 'Y'),
(48, 'COLOMBIA ', 'CO', NULL, 'Y'),
(49, 'COSTA RICA ', 'CR', NULL, 'Y'),
(50, 'CZECHOSLOVAKIA (FORMER) ', 'CS', NULL, 'Y'),
(51, 'CUBA ', 'CU', NULL, 'Y'),
(52, 'CAPE VERDE ', 'CV', NULL, 'Y'),
(53, 'CHRISTMAS ISLAND ', 'CX', NULL, 'Y'),
(54, 'CYPRUS ', 'CY', NULL, 'Y'),
(55, 'CZECH REPUBLIC ', 'CZ', NULL, 'Y'),
(56, 'GERMANY ', 'DE', NULL, 'Y'),
(57, 'DJIBOUTI ', 'DJ', NULL, 'Y'),
(58, 'DENMARK ', 'DK', NULL, 'Y'),
(59, 'DOMINICA ', 'DM', NULL, 'Y'),
(60, 'DOMINICAN REPUBLIC ', 'DO', NULL, 'Y'),
(61, 'ALGERIA', 'DZ', NULL, 'Y'),
(62, 'ECUADOR ', 'EC', NULL, 'Y'),
(63, 'ESTONIA ', 'EE', NULL, 'Y'),
(64, 'EGYPT ', 'EG', NULL, 'Y'),
(65, 'WESTERN SAHARA ', 'EH', NULL, 'Y'),
(66, 'ERITREA ', 'ER', NULL, 'Y'),
(67, 'SPAIN ', 'ES', NULL, 'Y'),
(68, 'ETHIOPIA ', 'ET', NULL, 'Y'),
(69, 'EUROPEAN UNION ', 'EU', NULL, 'Y'),
(70, 'FINLAND ', 'FI', NULL, 'Y'),
(71, 'FIJI ', 'FJ', NULL, 'Y'),
(72, 'FALKLAND ISLANDS (MALVINAS) ', 'FK', NULL, 'Y'),
(73, 'MICRONESIA ', 'FM', NULL, 'Y'),
(74, 'FAROE ISLANDS ', 'FO', NULL, 'Y'),
(75, 'FRANCE ', 'FR', NULL, 'Y'),
(76, 'FRANCE, METROPOLITAN ', 'FX', NULL, 'Y'),
(77, 'GABON ', 'GA', NULL, 'Y'),
(78, 'GREAT BRITAIN (UK) ', 'GB', NULL, 'Y'),
(79, 'GRENADA ', 'GD', NULL, 'Y'),
(80, 'GEORGIA ', 'GE', NULL, 'Y'),
(81, 'FRENCH GUIANA ', 'GF', NULL, 'Y'),
(82, 'GUERNSEY ', 'GG', NULL, 'Y'),
(83, 'GHANA ', 'GH', NULL, 'Y'),
(84, 'GIBRALTAR ', 'GI', NULL, 'Y'),
(85, 'GREENLAND ', 'GL', NULL, 'Y'),
(86, 'GAMBIA ', 'GM', NULL, 'Y'),
(87, 'GUINEA ', 'GN', NULL, 'Y'),
(88, 'GUADELOUPE ', 'GP', NULL, 'Y'),
(89, 'EQUATORIAL GUINEA ', 'GQ', NULL, 'Y'),
(90, 'GREECE ', 'GR', NULL, 'Y'),
(91, 'S. GEORGIA AND S. SANDWICH ISLS. ', 'GS', NULL, 'Y'),
(92, 'GUATEMALA ', 'GT', NULL, 'Y'),
(93, 'GUAM ', 'GU', NULL, 'Y'),
(94, 'GUINEA     BISSAU ', 'GW', NULL, 'Y'),
(95, 'GUYANA ', 'GY', NULL, 'Y'),
(96, 'HONG KONG ', 'HK', NULL, 'Y'),
(97, 'HEARD AND MCDONALD ISLANDS ', 'HM', NULL, 'Y'),
(98, 'HONDURAS ', 'HN', NULL, 'Y'),
(99, 'CROATIA (HRVATSKA) ', 'HR', NULL, 'Y'),
(100, 'HAITI ', 'HT', NULL, 'Y'),
(101, 'HUNGARY ', 'HU', NULL, 'Y'),
(102, 'INDONESIA ', 'ID', NULL, 'Y'),
(103, 'IRELAND ', 'IE', NULL, 'Y'),
(104, 'ISRAEL ', 'IL', NULL, 'Y'),
(105, 'ISLE OF MAN ', 'IM', NULL, 'Y'),
(106, 'INDIA ', 'IN', NULL, 'Y'),
(107, 'BRITISH INDIAN OCEAN TERRITORY ', 'IO', NULL, 'Y'),
(108, 'IRAQ ', 'IQ', NULL, 'Y'),
(109, 'IRAN ', 'IR', NULL, 'Y'),
(110, 'ICELAND ', 'IS', NULL, 'Y'),
(111, 'ITALY ', 'IT', NULL, 'Y'),
(112, 'JERSEY ', 'JE', NULL, 'Y'),
(113, 'JAMAICA ', 'JM', NULL, 'Y'),
(114, 'JORDAN ', 'JO', NULL, 'Y'),
(115, 'JAPAN ', 'JP', NULL, 'Y'),
(116, 'KENYA ', 'KE', NULL, 'Y'),
(117, 'KYRGYZSTAN ', 'KG', NULL, 'Y'),
(118, 'CAMBODIA ', 'KH', NULL, 'Y'),
(119, 'KIRIBATI ', 'KI', NULL, 'Y'),
(120, 'COMOROS ', 'KM', NULL, 'Y'),
(121, 'SAINT KITTS AND NEVIS ', 'KN', NULL, 'Y'),
(122, 'NORTH KOREA', 'KP', NULL, 'Y'),
(123, 'SOUTH KOREA', 'KR', NULL, 'Y'),
(124, 'KUWAIT ', 'KW', NULL, 'Y'),
(125, 'CAYMAN ISLANDS ', 'KY', NULL, 'Y'),
(126, 'KAZAKHSTAN ', 'KZ', NULL, 'Y'),
(127, 'LAOS ', 'LA', NULL, 'Y'),
(128, 'LEBANON ', 'LB', NULL, 'Y'),
(129, 'SAINT LUCIA ', 'LC', NULL, 'Y'),
(130, 'LIECHTENSTEIN ', 'LI', NULL, 'Y'),
(131, 'SRI LANKA ', 'LK', NULL, 'Y'),
(132, 'LIBERIA ', 'LR', NULL, 'Y'),
(133, 'LESOTHO ', 'LS', NULL, 'Y'),
(134, 'LITHUANIA ', 'LT', NULL, 'Y'),
(135, 'LUXEMBOURG ', 'LU', NULL, 'Y'),
(136, 'LATVIA ', 'LV', NULL, 'Y'),
(137, 'LIBYA ', 'LY', NULL, 'Y'),
(138, 'MOROCCO ', 'MA', NULL, 'Y'),
(139, 'MONACO ', 'MC', NULL, 'Y'),
(140, 'MOLDOVA ', 'MD', NULL, 'Y'),
(141, 'MONTENEGRO ', 'ME', NULL, 'Y'),
(142, 'MADAGASCAR ', 'MG', NULL, 'Y'),
(143, 'MARSHALL ISLANDS ', 'MH', NULL, 'Y'),
(144, 'F.Y.R.O.M. (MACEDONIA) ', 'MK', NULL, 'Y'),
(145, 'MALI ', 'ML', NULL, 'Y'),
(146, 'MYANMAR ', 'MM', NULL, 'Y'),
(147, 'MONGOLIA ', 'MN', NULL, 'Y'),
(148, 'MACAU ', 'MO', NULL, 'Y'),
(149, 'NORTHERN MARIANA ISLANDS ', 'MP', NULL, 'Y'),
(150, 'MARTINIQUE ', 'MQ', NULL, 'Y'),
(151, 'MAURITANIA ', 'MR', NULL, 'Y'),
(152, 'MONTSERRAT ', 'MS', NULL, 'Y'),
(153, 'MALTA ', 'MT', NULL, 'Y'),
(154, 'MAURITIUS ', 'MU', NULL, 'Y'),
(155, 'MALDIVES ', 'MV', NULL, 'Y'),
(156, 'MALAWI ', 'MW', NULL, 'Y'),
(157, 'MEXICO ', 'MX', NULL, 'Y'),
(158, 'MALAYSIA ', 'MY', NULL, 'Y'),
(159, 'MOZAMBIQUE ', 'MZ', NULL, 'Y'),
(160, 'NAMIBIA ', 'NA', NULL, 'Y'),
(161, 'NEW CALEDONIA ', 'NC', NULL, 'Y'),
(162, 'NIGER ', 'NE', NULL, 'Y'),
(163, 'NORFOLK ISLAND ', 'NF', NULL, 'Y'),
(164, 'NIGERIA ', 'NG', NULL, 'Y'),
(165, 'NICARAGUA ', 'NI', NULL, 'Y'),
(166, 'NETHERLANDS ', 'NL', NULL, 'Y'),
(167, 'NORWAY ', 'NO', NULL, 'Y'),
(168, 'NEPAL ', 'NP', NULL, 'Y'),
(169, 'NAURU ', 'NR', NULL, 'Y'),
(170, 'NEUTRAL ZONE ', 'NT', NULL, 'Y'),
(171, 'NIUE ', 'NU', NULL, 'Y'),
(172, 'NEW ZEALAND (AOTEAROA) ', 'NZ', NULL, 'Y'),
(173, 'OMAN ', 'OM', NULL, 'Y'),
(174, 'PANAMA ', 'PA', NULL, 'Y'),
(175, 'PERU ', 'PE', NULL, 'Y'),
(176, 'FRENCH POLYNESIA ', 'PF', NULL, 'Y'),
(177, 'PAPUA NEW GUINEA ', 'PG', NULL, 'Y'),
(178, 'PHILIPPINES ', 'PH', NULL, 'Y'),
(179, 'PAKISTAN ', 'PK', NULL, 'Y'),
(180, 'POLAND ', 'PL', NULL, 'Y'),
(181, 'ST. PIERRE AND MIQUELON ', 'PM', NULL, 'Y'),
(182, 'PITCAIRN ', 'PN', NULL, 'Y'),
(183, 'PUERTO RICO ', 'PR', NULL, 'Y'),
(184, 'PALESTINIAN TERRITORY, OCCUPIED ', 'PS', NULL, 'Y'),
(185, 'PORTUGAL ', 'PT', NULL, 'Y'),
(186, 'PALAU ', 'PW', NULL, 'Y'),
(187, 'PARAGUAY ', 'PY', NULL, 'Y'),
(188, 'QATAR ', 'QA', NULL, 'Y'),
(189, 'REUNION ', 'RE', NULL, 'Y'),
(190, 'ROMANIA ', 'RO', NULL, 'Y'),
(191, 'SERBIA ', 'RS', NULL, 'Y'),
(192, 'RUSSIAN FEDERATION ', 'RU', NULL, 'Y'),
(193, 'RWANDA ', 'RW', NULL, 'Y'),
(194, 'SAUDI ARABIA ', 'SA', NULL, 'Y'),
(195, 'SOLOMON ISLANDS ', 'SB', NULL, 'Y'),
(196, 'SEYCHELLES ', 'SC', NULL, 'Y'),
(197, 'SUDAN ', 'SD', NULL, 'Y'),
(198, 'SWEDEN ', 'SE', NULL, 'Y'),
(199, 'SINGAPORE ', 'SG', NULL, 'Y'),
(200, 'ST. HELENA ', 'SH', NULL, 'Y'),
(201, 'SLOVENIA ', 'SI', NULL, 'Y'),
(202, 'SVALBARD & JAN MAYEN ISLANDS ', 'SJ', NULL, 'Y'),
(203, 'SLOVAK REPUBLIC ', 'SK', NULL, 'Y'),
(204, 'SIERRA LEONE ', 'SL', NULL, 'Y'),
(205, 'SAN MARINO ', 'SM', NULL, 'Y'),
(206, 'SENEGAL ', 'SN', NULL, 'Y'),
(207, 'SOMALIA ', 'SO', NULL, 'Y'),
(208, 'SURINAME ', 'SR', NULL, 'Y'),
(209, 'SAO TOME AND PRINCIPE ', 'ST', NULL, 'Y'),
(210, 'USSR (FORMER) ', 'SU', NULL, 'Y'),
(211, 'EL SALVADOR ', 'SV', NULL, 'Y'),
(212, 'SYRIA ', 'SY', NULL, 'Y'),
(213, 'SWAZILAND ', 'SZ', NULL, 'Y'),
(214, 'TURKS AND CAICOS ISLANDS ', 'TC', NULL, 'Y'),
(215, 'CHAD ', 'TD', NULL, 'Y'),
(216, 'FRENCH SOUTHERN TERRITORIES ', 'TF', NULL, 'Y'),
(217, 'TOGO ', 'TG', NULL, 'Y'),
(218, 'THAILAND ', 'TH', NULL, 'Y'),
(219, 'TAJIKISTAN ', 'TJ', NULL, 'Y'),
(220, 'TOKELAU ', 'TK', NULL, 'Y'),
(221, 'TURKMENISTAN ', 'TM', NULL, 'Y'),
(222, 'TUNISIA ', 'TN', NULL, 'Y'),
(223, 'TONGA ', 'TO', NULL, 'Y'),
(224, 'EAST TIMOR ', 'TP', NULL, 'Y'),
(225, 'TURKEY ', 'TR', NULL, 'Y'),
(226, 'TRINIDAD AND TOBAGO ', 'TT', NULL, 'Y'),
(227, 'TUVALU ', 'TV', NULL, 'Y'),
(228, 'TAIWAN ', 'TW', NULL, 'Y'),
(229, 'TANZANIA ', 'TZ', NULL, 'Y'),
(230, 'UKRAINE ', 'UA', NULL, 'Y'),
(231, 'UGANDA ', 'UG', NULL, 'Y'),
(232, 'UNITED KINGDOM ', 'UK', NULL, 'Y'),
(233, 'US MINOR OUTLYING ISLANDS ', 'UM', NULL, 'Y'),
(234, 'UNITED STATES ', 'US', NULL, 'Y'),
(235, 'URUGUAY ', 'UY', NULL, 'Y'),
(236, 'UZBEKISTAN ', 'UZ', NULL, 'Y'),
(237, 'VATICAN CITY STATE (HOLY SEE) ', 'VA', NULL, 'Y'),
(238, 'SAINT VINCENT & THE GRENADINES ', 'VC', NULL, 'Y'),
(239, 'VENEZUELA ', 'VE', NULL, 'Y'),
(240, 'BRITISH VIRGIN ISLANDS ', 'VG', NULL, 'Y'),
(241, 'VIRGIN ISLANDS (U.S.) ', 'VI', NULL, 'Y'),
(242, 'VIET NAM ', 'VN', NULL, 'Y'),
(243, 'VANUATU ', 'VU', NULL, 'Y'),
(244, 'WALLIS AND FUTUNA ISLANDS ', 'WF', NULL, 'Y'),
(245, 'SAMOA ', 'WS', NULL, 'Y'),
(246, 'YEMEN ', 'YE', NULL, 'Y'),
(247, 'MAYOTTE ', 'YT', NULL, 'Y'),
(248, 'SERBIA AND MONTENEGRO (FORMER) ', 'YU', NULL, 'Y'),
(249, 'SOUTH AFRICA ', 'ZA', NULL, 'Y'),
(250, 'ZAMBIA ', 'ZM', NULL, 'Y'),
(251, '(ZAIRE) SEE CD CONGO, DEMOCRATIC REPUBLIC ', 'ZR', NULL, 'Y'),
(252, 'ZIMBABWE', 'ZW', NULL, 'Y');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `countrycodes`
--
ALTER TABLE `countrycodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=253;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
