-- phpMyAdmin SQL Dump
-- version 4.4.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 19, 2023 at 02:53 PM
-- Server version: 5.6.26
-- PHP Version: 5.6.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 `allcurrencies`
--

CREATE TABLE IF NOT EXISTS `allcurrencies` (
  `id` int(10) NOT NULL,
  `country` varchar(100) NOT NULL,
  `currency` varchar(20) NOT NULL,
  `code` varchar(20) NOT NULL,
  `symbol` varchar(10) NOT NULL,
  `companyid` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `allcurrencies`
--

INSERT INTO `allcurrencies` (`id`, `country`, `currency`, `code`, `symbol`, `companyid`) VALUES
(1, 'Albania', 'Albanian lek', 'ALL', 'L', 1),
(2, 'Argentina', 'Argentine peso', 'ARS', '$', 1),
(3, 'Armenia', 'Armenian dram', 'AMD', '?', 1),
(4, 'Australia', 'Australian dollar', 'AUD', '$', 1),
(5, 'Azerbaijan', 'Azerbaijani manat', 'AZN', '?', 1),
(6, 'Belarus', 'Belarusian rubel', 'BYN', 'Rbl', 1),
(7, 'Bolivia', 'Boliviano', 'BOB', 'Bs.', 1),
(8, 'Botswana', 'Botswana pula', 'BWP', 'P', 1),
(9, 'Bulgaria', 'Bulgarian lev', 'BGN', '??.', 1),
(10, 'Brazil', 'Brazilian real', 'BRL', 'R$', 1),
(11, 'Cambodia', 'Cambodian riel', 'KHR', '?', 1),
(12, 'Canada', 'Canadian dollar', 'CAD', '$', 1),
(13, 'China', 'Chinese yuan (Renmin', 'CNY', '?', 1),
(14, 'Colombia', 'Colombian peso', 'COP', '$', 1),
(15, 'Costa Rica', 'Costa Rican col?n', 'CRC', '?', 1),
(16, 'Croatia', 'Croatian kuna', 'HRK', 'kn', 1),
(17, 'Cuba', 'Cuban peso', 'CUP', '$', 1),
(18, 'Czech Republic', 'Czech koruna', 'CZK', 'K?', 1),
(19, 'Denmark', 'Danish krone', 'DKK', 'kr.', 1),
(20, 'Dominican Republic', 'Dominican peso', 'DOP', '$', 1),
(21, 'Egypt', 'Egyptian pound', 'EGP', 'E?', 1),
(22, 'El Salvador', 'El Salvador col?n', 'SVC', '?', 1),
(23, 'European Union', 'Euro', 'EUR', '?', 1),
(24, 'Fiji', 'Fijian dollar', 'FJD', 'FJ$', 1),
(25, 'Ghana', 'Ghanaian cedi', 'GHS', 'GH?', 1),
(26, 'Guatemala', 'Guatemalan quetzal', 'GTQ', 'Q', 1),
(27, 'Guinea', 'Guinean franc', 'GNF', 'FG', 1),
(28, 'Guyana', 'Guyanese dollar', 'GYD', '$', 1),
(29, 'Hong Kong', 'Hong Kong dollar', 'HKD', '$', 1),
(30, 'Honduras', 'Honduran lempira', 'HNL', 'L', 1),
(31, 'Hungary', 'Hungarian forint', 'HUF', 'Ft', 1),
(32, 'India', 'Indian rupee', 'INR', '?', 1),
(33, 'Iceland', 'Icelandic kr?na', 'ISK', 'kr', 1),
(34, 'Iran', 'Iranian rial', 'IRR', '?', 1),
(35, 'Israel', 'Israeli shekel', 'ILS', '?', 1),
(36, 'Japan', 'Japanese yen', 'JPY', '?', 1),
(37, 'Kazakhstan', 'Kazakhstani tenge', 'KZT', '?', 1),
(38, 'Kenya', 'Kenyan shilling', 'KES', 'Ksh', 1),
(39, 'Kuwait', 'Kuwaiti dinar', 'KWD', '?.?', 1),
(40, 'Malawi', 'Malawian kwacha', 'MWK', 'MK', 1),
(41, 'Malaysia', 'Malaysian ringgit', 'MYR', 'RM', 1),
(42, 'Mexico', 'Mexican peso', 'MXN', '$', 1),
(43, 'Morocco', 'Moroccan dirham', 'MAD', 'MAD', 1),
(44, 'Namibia', 'Namibian dollar', 'NAD', 'N$', 1),
(45, 'Nepal', 'Nepalese rupee', 'NPR', 'Rs.', 1),
(46, 'New Zealand', 'New Zealand dollar', 'NZD', '$', 1),
(47, 'Norway', 'Norwegian krone', 'NOK', 'kr', 1),
(48, 'Oman', 'Omani rial', 'OMR', '?.?.', 1),
(49, 'Pakistan', 'Pakistani rupee', 'PKR', 'Rs', 1),
(50, 'Peru', 'Sol', 'PEN', 'S/', 1),
(51, 'Philippines', 'Philippine peso', 'PHP', '?', 1),
(52, 'Poland', 'Polish z?oty', 'PLN', 'z?', 1),
(53, 'Qatar', 'Qatari riyal', 'QAR', 'QR', 1),
(54, 'Romania', 'Romanian leu', 'RON', 'L', 1),
(55, 'Russia', 'Russian ruble', 'RUB', '?', 1),
(56, 'Saudi Arabia', 'Saudi riyal', 'SAR', '?.?', 1),
(57, 'Serbia', 'Serbian dinar', 'RSD', 'din', 1),
(58, 'Seychelles', 'Seychellois rupee', 'SCR', '?', 1),
(59, 'Singapore', 'Singapore dollar', 'SGD', '$', 1),
(60, 'Solomon Islands', 'Solomon Islands doll', 'SBD', 'Si$', 1),
(61, 'Somalia', 'Somali shilling', 'SOS', 'Sh.so', 1),
(62, 'South Africa', 'South African rand', 'ZAR', 'R', 1),
(63, 'Sri Lanka', 'Sri Lankan rupee', 'LKR', 'Re', 1),
(64, 'Sweden', 'Swedish krona', 'SEK', 'kr', 1),
(65, 'Switzerland', 'Swiss franc', 'CHF', 'CHf.', 1),
(66, 'Syria', 'Syrian pound', 'SYP', '?S', 1),
(67, 'Taiwan', 'New Taiwan dollar', 'TWD', 'NT$', 1),
(68, 'Thailand', 'Thai baht', 'THB', '?', 1),
(69, 'Trinidad and Tobago', 'Trinidad and Tobago ', 'TTD', 'TT$', 1),
(70, 'Turkey', 'Turkish lira', 'TRY', '?', 1),
(71, 'Ukraine', 'Ukrainian hryvnia', 'UAH', '?', 1),
(72, 'United Kingdom', 'Pound sterling', 'GBP', '?', 1),
(73, 'United States', 'United States dollar', 'USD', '$', 1),
(74, 'Uruguay', 'Uruguayan Peso', 'UYU', '$', 1),
(75, 'Uzbekistan', 'Uzbekistani sum', 'UZS', 'so?m', 1),
(76, 'Venezuela', 'Venezuelan bol?var', 'VED', 'Bs.', 1),
(77, 'Vietnam', 'Vietnamese dong', 'VND', '?', 1),
(78, 'Yemen', 'Yemeni rial', 'YER', '?', 1),
(79, 'Zimbabwe', 'Zimbabwean dollar', 'ZWL', '$', 1);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `allcurrencies`
--
ALTER TABLE `allcurrencies`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=80;
/*!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 */;
