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

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

--
-- Dumping data for table `currencycodes`
--

INSERT INTO `currencycodes` (`id`, `name`, `code`, `description`, `status`, `symbol`, `sort_order`) VALUES
(1, 'United Arab Emirates dirham', 'AED', NULL, 'Y', 'AED', '1'),
(2, 'Afghan afghani', 'AFN', NULL, 'Y', 'AFN', '2'),
(3, 'Albanian lek', 'ALL', NULL, 'Y', 'ALL', '3'),
(4, 'Armenian dram', 'AMD', NULL, 'Y', 'AMD', '4'),
(5, 'Netherlands Antillean guilder', 'ANG', NULL, 'Y', 'ANG', '5'),
(6, 'Angolan kwanza', 'AOA', NULL, 'Y', 'AOA', '6'),
(7, 'Argentine peso', 'ARS', NULL, 'Y', 'ARS', '7'),
(8, 'Australian dollar', 'AUD', NULL, 'Y', 'AUD', '8'),
(9, 'Aruban florin', 'AWG', NULL, 'Y', 'AWG', '9'),
(10, 'Azerbaijani manat', 'AZN', NULL, 'Y', 'AZN', '10'),
(11, 'Bosnia and Herzegovina convertible mark', 'BAM', NULL, 'Y', 'BAM', '11'),
(12, 'Barbados dollar', 'BBD', NULL, 'Y', 'BBD', '12'),
(13, 'Bangladeshi taka', 'BDT', NULL, 'Y', 'BDT', '13'),
(14, 'Bulgarian lev', 'BGN', NULL, 'Y', 'BGN', '14'),
(15, 'Bahraini dinar', 'BHD', NULL, 'Y', 'BHD', '15'),
(16, 'Burundian franc', 'BIF', NULL, 'Y', 'BIF', '16'),
(17, 'Bermudian dollar', 'BMD', NULL, 'Y', 'BMD', '17'),
(18, 'Brunei dollar', 'BND', NULL, 'Y', 'BND', '18'),
(19, 'Boliviano', 'BOB', NULL, 'Y', 'BOB', '19'),
(20, 'Bolivian Mvdol (funds code)', 'BOV', NULL, 'Y', 'BOV', '20'),
(21, 'Brazilian real', 'BRL', NULL, 'Y', 'BRL', '21'),
(22, 'Bahamian dollar', 'BSD', NULL, 'Y', 'BSD', '22'),
(23, 'Bhutanese ngultrum', 'BTN', NULL, 'Y', 'BTN', '23'),
(24, 'Botswana pula', 'BWP', NULL, 'Y', 'BWP', '24'),
(25, 'New Belarusian ruble', 'BYN', NULL, 'Y', 'BYN', '25'),
(26, 'Belarusian ruble', 'BYR', NULL, 'Y', 'BYR', '26'),
(27, 'Belize dollar', 'BZD', NULL, 'Y', 'BZD', '27'),
(28, 'Canadian dollar', 'CAD', NULL, 'Y', 'CAD', '28'),
(29, 'Congolese franc', 'CDF', NULL, 'Y', 'CDF', '29'),
(30, 'WIR Euro (complementary currency)', 'CHE', NULL, 'Y', 'CHE', '30'),
(31, 'Swiss franc', 'CHF', NULL, 'Y', 'CHF', '31'),
(32, 'WIR Franc (complementary currency)', 'CHW', NULL, 'Y', 'CHW', '32'),
(33, 'Unidad de Fomento (funds code)', 'CLF', NULL, 'Y', 'CLF', '33'),
(34, 'Chilean peso', 'CLP', NULL, 'Y', 'CLP', '34'),
(35, 'Chinese yuan', 'CNY', NULL, 'Y', 'CNY', '35'),
(36, 'Colombian peso', 'COP', NULL, 'Y', 'COP', '36'),
(37, 'Unidad de Valor Real (UVR) (funds code)', 'COU', NULL, 'Y', 'COU', '37'),
(38, 'Costa Rican colon', 'CRC', NULL, 'Y', 'CRC', '38'),
(39, 'Cuban convertible peso', 'CUC', NULL, 'Y', 'CUC', '39'),
(40, 'Cuban peso', 'CUP', NULL, 'Y', 'CUP', '40'),
(41, 'Cape Verde escudo', 'CVE', NULL, 'Y', 'CVE', '41'),
(42, 'Czech koruna', 'CZK', NULL, 'Y', 'CZK', '42'),
(43, 'Djiboutian franc', 'DJF', NULL, 'Y', 'DJF', '43'),
(44, 'Danish krone', 'DKK', NULL, 'Y', 'DKK', '44'),
(45, 'Dominican peso', 'DOP', NULL, 'Y', 'DOP', '45'),
(46, 'Algerian dinar', 'DZD', NULL, 'Y', 'DZD', '46'),
(47, 'Egyptian pound', 'EGP', NULL, 'Y', 'EGP', '47'),
(48, 'Eritrean nakfa', 'ERN', NULL, 'Y', 'ERN', '48'),
(49, 'Ethiopian birr', 'ETB', NULL, 'Y', 'ETB', '49'),
(50, 'Euro', 'EUR', NULL, 'Y', 'EUR', '50'),
(51, 'Fiji dollar', 'FJD', NULL, 'Y', 'FJD', '51'),
(52, 'Falkland Islands pound', 'FKP', NULL, 'Y', 'FKP', '52'),
(53, 'Pound sterling', 'GBP', NULL, 'Y', 'GBP', '53'),
(54, 'Georgian lari', 'GEL', NULL, 'Y', 'GEL', '54'),
(55, 'Ghanaian cedi', 'GHS', NULL, 'Y', 'GHS', '55'),
(56, 'Gibraltar pound', 'GIP', NULL, 'Y', 'GIP', '56'),
(57, 'Gambian dalasi', 'GMD', NULL, 'Y', 'GMD', '57'),
(58, 'Guinean franc', 'GNF', NULL, 'Y', 'GNF', '58'),
(59, 'Guatemalan quetzal', 'GTQ', NULL, 'Y', 'GTQ', '59'),
(60, 'Guyanese dollar', 'GYD', NULL, 'Y', 'GYD', '60'),
(61, 'Hong Kong dollar', 'HKD', NULL, 'Y', 'HKD', '61'),
(62, 'Honduran lempira', 'HNL', NULL, 'Y', 'HNL', '62'),
(63, 'Croatian kuna', 'HRK', NULL, 'Y', 'HRK', '63'),
(64, 'Haitian gourde', 'HTG', NULL, 'Y', 'HTG', '64'),
(65, 'Hungarian forint', 'HUF', NULL, 'Y', 'HUF', '65'),
(66, 'Indonesian rupiah', 'IDR', NULL, 'Y', 'IDR', '66'),
(67, 'Israeli new shekel', 'ILS', NULL, 'Y', 'ILS', '67'),
(68, 'Indian rupee', 'INR', NULL, 'Y', 'INR', '68'),
(69, 'Iraqi dinar', 'IQD', NULL, 'Y', 'IQD', '69'),
(70, 'Iranian rial', 'IRR', NULL, 'Y', 'IRR', '70'),
(71, 'Icelandic króna', 'ISK', NULL, 'Y', 'ISK', '71'),
(72, 'Jamaican dollar', 'JMD', NULL, 'Y', 'JMD', '72'),
(73, 'Jordanian dinar', 'JOD', NULL, 'Y', 'JOD', '73'),
(74, 'Japanese yen', 'JPY', NULL, 'Y', 'JPY', '74'),
(75, 'Kenyan shilling', 'KES', NULL, 'Y', 'KES', '75'),
(76, 'Kyrgyzstani som', 'KGS', NULL, 'Y', 'KGS', '76'),
(77, 'Cambodian riel', 'KHR', NULL, 'Y', 'KHR', '77'),
(78, 'Comoro franc', 'KMF', NULL, 'Y', 'KMF', '78'),
(79, 'North Korean won', 'KPW', NULL, 'Y', 'KPW', '79'),
(80, 'South Korean won', 'KRW', NULL, 'Y', 'KRW', '80'),
(81, 'Kuwaiti dinar', 'KWD', NULL, 'Y', 'KWD', '81'),
(82, 'Cayman Islands dollar', 'KYD', NULL, 'Y', 'KYD', '82'),
(83, 'Kazakhstani tenge', 'KZT', NULL, 'Y', 'KZT', '83'),
(84, 'Lao kip', 'LAK', NULL, 'Y', 'LAK', '84'),
(85, 'Lebanese pound', 'LBP', NULL, 'Y', 'LBP', '85'),
(86, 'Sri Lankan rupee', 'LKR', NULL, 'Y', 'LKR', '86'),
(87, 'Liberian dollar', 'LRD', NULL, 'Y', 'LRD', '87'),
(88, 'Lesotho loti', 'LSL', NULL, 'Y', 'LSL', '88'),
(89, 'Libyan dinar', 'LYD', NULL, 'Y', 'LYD', '89'),
(90, 'Moroccan dirham', 'MAD', NULL, 'Y', 'MAD', '90'),
(91, 'Moldovan leu', 'MDL', NULL, 'Y', 'MDL', '91'),
(92, 'Malagasy ariary', 'MGA', NULL, 'Y', 'MGA', '92'),
(93, 'Macedonian denar', 'MKD', NULL, 'Y', 'MKD', '93'),
(94, 'Myanmar kyat', 'MMK', NULL, 'Y', 'MMK', '94'),
(95, 'Mongolian tögrög', 'MNT', NULL, 'Y', 'MNT', '95'),
(96, 'Macanese pataca', 'MOP', NULL, 'Y', 'MOP', '96'),
(97, 'Mauritanian ouguiya', 'MRO', NULL, 'Y', 'MRO', '97'),
(98, 'Mauritian rupee', 'MUR', NULL, 'Y', 'MUR', '98'),
(99, 'Maldivian rufiyaa', 'MVR', NULL, 'Y', 'MVR', '99'),
(100, 'Malawian kwacha', 'MWK', NULL, 'Y', 'MWK', '100'),
(101, 'Mexican peso', 'MXN', NULL, 'Y', 'MXN', '101'),
(102, 'Mexican Unidad de Inversion (UDI) (funds code)', 'MXV', NULL, 'Y', 'MXV', '102'),
(103, 'Malaysian ringgit', 'MYR', NULL, 'Y', 'MYR', '103'),
(104, 'Mozambican metical', 'MZN', NULL, 'Y', 'MZN', '104'),
(105, 'Namibian dollar', 'NAD', NULL, 'Y', 'NAD', '105'),
(106, 'Nigerian naira', 'NGN', NULL, 'Y', 'NGN', '106'),
(107, 'Nicaraguan córdoba', 'NIO', NULL, 'Y', 'NIO', '107'),
(108, 'Norwegian krone', 'NOK', NULL, 'Y', 'NOK', '108'),
(109, 'Nepalese rupee', 'NPR', NULL, 'Y', 'NPR', '109'),
(110, 'New Zealand dollar', 'NZD', NULL, 'Y', 'NZD', '110'),
(111, 'Omani rial', 'OMR', NULL, 'Y', 'OMR', '111'),
(112, 'Panamanian balboa', 'PAB', NULL, 'Y', 'PAB', '112'),
(113, 'Peruvian Sol', 'PEN', NULL, 'Y', 'PEN', '113'),
(114, 'Papua New Guinean kina', 'PGK', NULL, 'Y', 'PGK', '114'),
(115, 'Philippine peso', 'PHP', NULL, 'Y', 'PHP', '115'),
(116, 'Pakistani rupee', 'PKR', NULL, 'Y', 'PKR', '116'),
(117, 'Polish zloty', 'PLN', NULL, 'Y', 'PLN', '117'),
(118, 'Paraguayan guaraní', 'PYG', NULL, 'Y', 'PYG', '118'),
(119, 'Qatari riyal', 'QAR', NULL, 'Y', 'QAR', '119'),
(120, 'Romanian leu', 'RON', NULL, 'Y', 'RON', '120'),
(121, 'Serbian dinar', 'RSD', NULL, 'Y', 'RSD', '121'),
(122, 'Russian ruble', 'RUB', NULL, 'Y', 'RUB', '122'),
(123, 'Rwandan franc', 'RWF', NULL, 'Y', 'RWF', '123'),
(124, 'Saudi riyal', 'SAR', NULL, 'Y', 'SAR', '124'),
(125, 'Solomon Islands dollar', 'SBD', NULL, 'Y', 'SBD', '125'),
(126, 'Seychelles rupee', 'SCR', NULL, 'Y', 'SCR', '126'),
(127, 'Sudanese pound', 'SDG', NULL, 'Y', 'SDG', '127'),
(128, 'Swedish krona/kronor', 'SEK', NULL, 'Y', 'SEK', '128'),
(129, 'Singapore dollar', 'SGD', NULL, 'Y', 'SGD', '129'),
(130, 'Saint Helena pound', 'SHP', NULL, 'Y', 'SHP', '130'),
(131, 'Sierra Leonean leone', 'SLL', NULL, 'Y', 'SLL', '131'),
(132, 'Somali shilling', 'SOS', NULL, 'Y', 'SOS', '132'),
(133, 'Surinamese dollar', 'SRD', NULL, 'Y', 'SRD', '133'),
(134, 'South Sudanese pound', 'SSP', NULL, 'Y', 'SSP', '134'),
(135, 'São Tomé and Príncipe dobra', 'STD', NULL, 'Y', 'STD', '135'),
(136, 'Salvadoran colón', 'SVC', NULL, 'Y', 'SVC', '136'),
(137, 'Syrian pound', 'SYP', NULL, 'Y', 'SYP', '137'),
(138, 'Swazi lilangeni', 'SZL', NULL, 'Y', 'SZL', '138'),
(139, 'Thai baht', 'THB', NULL, 'Y', 'THB', '139'),
(140, 'Tajikistani somoni', 'TJS', NULL, 'Y', 'TJS', '140'),
(141, 'Turkmenistani manat', 'TMT', NULL, 'Y', 'TMT', '141'),
(142, 'Tunisian dinar', 'TND', NULL, 'Y', 'TND', '142'),
(143, 'Tongan pa?anga', 'TOP', NULL, 'Y', 'TOP', '143'),
(144, 'Turkish lira', 'TRY', NULL, 'Y', 'TRY', '144'),
(145, 'Trinidad and Tobago dollar', 'TTD', NULL, 'Y', 'TTD', '145'),
(146, 'New Taiwan dollar', 'TWD', NULL, 'Y', 'TWD', '146'),
(147, 'Tanzanian shilling', 'TZS', NULL, 'Y', 'TZS', '147'),
(148, 'Ukrainian hryvnia', 'UAH', NULL, 'Y', 'UAH', '148'),
(149, 'Ugandan shilling', 'UGX', NULL, 'Y', 'UGX', '149'),
(150, 'United States dollar', 'USD', NULL, 'Y', 'USD', '150'),
(151, 'United States dollar (next day) (funds code)', 'USN', NULL, 'Y', 'USN', '151'),
(152, 'Uruguay Peso en Unidades Indexadas (URUIURUI) (funds code)', 'UYI', NULL, 'Y', 'UYI', '152'),
(153, 'Uruguayan peso', 'UYU', NULL, 'Y', 'UYU', '153'),
(154, 'Uzbekistan som', 'UZS', NULL, 'Y', 'UZS', '154'),
(155, 'Venezuelan bolívar', 'VEF', NULL, 'Y', 'VEF', '155'),
(156, 'Vietnamese dong', 'VND', NULL, 'Y', 'VND', '156'),
(157, 'Vanuatu vatu', 'VUV', NULL, 'Y', 'VUV', '157'),
(158, 'Samoan tala', 'WST', NULL, 'Y', 'WST', '158'),
(159, 'CFA franc BEAC', 'XAF', NULL, 'Y', 'XAF', '159'),
(160, 'Silver (one troy ounce)', 'XAG', NULL, 'Y', 'XAG', '160'),
(161, 'Gold (one troy ounce)', 'XAU', NULL, 'Y', 'XAU', '161'),
(162, 'European Composite Unit (EURCO) (bond market unit)', 'XBA', NULL, 'Y', 'XBA', '162'),
(163, 'European Monetary Unit (E.M.U.-6) (bond market unit)', 'XBB', NULL, 'Y', 'XBB', '163'),
(164, 'European Unit of Account 9 (E.U.A.-9) (bond market unit)', 'XBC', NULL, 'Y', 'XBC', '164'),
(165, 'European Unit of Account 17 (E.U.A.-17) (bond market unit)', 'XBD', NULL, 'Y', 'XBD', '165'),
(166, 'East Caribbean dollar', 'XCD', NULL, 'Y', 'XCD', '166'),
(167, 'Special drawing rights', 'XDR', NULL, 'Y', 'XDR', '167'),
(168, 'CFA franc BCEAO', 'XOF', NULL, 'Y', 'XOF', '168'),
(169, 'Palladium (one troy ounce)', 'XPD', NULL, 'Y', 'XPD', '169'),
(170, 'CFP franc (franc Pacifique)', 'XPF', NULL, 'Y', 'XPF', '170'),
(171, 'Platinum (one troy ounce)', 'XPT', NULL, 'Y', 'XPT', '171'),
(172, 'SUCRE', 'XSU', NULL, 'Y', 'XSU', '172'),
(173, 'Code reserved for testing purposes', 'XTS', NULL, 'Y', 'XTS', '173'),
(174, 'ADB Unit of Account', 'XUA', NULL, 'Y', 'XUA', '174'),
(175, 'No currency', 'XXX', NULL, 'Y', 'XXX', '175'),
(176, 'Yemeni rial', 'YER', NULL, 'Y', 'YER', '176'),
(177, 'South African rand', 'ZAR', NULL, 'Y', 'ZAR', '177'),
(178, 'Zambian kwacha', 'ZMW', NULL, 'Y', 'ZMW', '178'),
(179, 'Zimbabwean dollar A/10', 'ZWL', NULL, 'Y', 'ZWL', '179');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `currencycodes`
--
ALTER TABLE `currencycodes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=180;
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 */;
