-- phpMyAdmin SQL Dump
-- version 4.4.0
-- http://www.phpmyadmin.net
--
-- Hostiteľ: localhost
-- Čas generovania: Út 02.Jún 2015, 11:34
-- Verzia serveru: 5.5.38-0+wheezy1
-- Verzia PHP: 5.4.39-0+deb7u2

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 utf8 */;

--
-- Databáza: `tests`
--

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

--
-- Štruktúra tabuľky pre tabuľku `Accounts_Classic_Advertisers`
--

CREATE TABLE IF NOT EXISTS `Accounts_Classic_Advertisers` (
  `id` int(11) NOT NULL,
  `username` varchar(40) NOT NULL,
  `password` varchar(200) NOT NULL,
  `email` varchar(50) NOT NULL,
  `paypalemail` varchar(80) NOT NULL,
  `payzaemail` varchar(80) NOT NULL,
  `skrillemail` varchar(80) NOT NULL,
  `2checkoutemail` varchar(80) NOT NULL,
  `g2aemail` varchar(80) NOT NULL,
  `refid` varchar(40) NOT NULL,
  `uplineearnings` varchar(10) NOT NULL,
  `balance` varchar(12) NOT NULL,
  `tickets` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `zipcode` varchar(100) NOT NULL,
  `telephone` varchar(100) NOT NULL,
  `country` varchar(100) NOT NULL,
  `datereg` varchar(100) NOT NULL,
  `regip` varchar(100) NOT NULL,
  `last1ip` varchar(100) NOT NULL,
  `last2ip` varchar(100) NOT NULL,
  `last3ip` varchar(100) NOT NULL,
  `last4ip` varchar(100) NOT NULL,
  `last5ip` varchar(100) NOT NULL,
  `last6ip` varchar(100) NOT NULL,
  `last7ip` varchar(100) NOT NULL,
  `date1` int(11) NOT NULL,
  `date2` int(11) NOT NULL,
  `date3` int(11) NOT NULL,
  `date4` int(11) NOT NULL,
  `date5` int(11) NOT NULL,
  `date6` int(11) NOT NULL,
  `date7` int(11) NOT NULL,
  `hash` text NOT NULL,
  `api` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Accounts_Classic_Advertisers`
--

INSERT INTO `Accounts_Classic_Advertisers` (`id`, `username`, `password`, `email`, `paypalemail`, `payzaemail`, `skrillemail`, `2checkoutemail`, `g2aemail`, `refid`, `uplineearnings`, `balance`, `tickets`, `name`, `address`, `city`, `zipcode`, `telephone`, `country`, `datereg`, `regip`, `last1ip`, `last2ip`, `last3ip`, `last4ip`, `last5ip`, `last6ip`, `last7ip`, `date1`, `date2`, `date3`, `date4`, `date5`, `date6`, `date7`, `hash`, `api`) VALUES
(7, 'admin', '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', '', '', '', '', 0, 'a', 's', '', '', '', '', '', '', '95.170.241.220', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, '', '476be9702872987b11508359a031794d');

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

--
-- Štruktúra tabuľky pre tabuľku `Accounts_Classic_Publishers`
--

CREATE TABLE IF NOT EXISTS `Accounts_Classic_Publishers` (
  `id` int(11) NOT NULL,
  `username` varchar(40) NOT NULL,
  `password` varchar(200) NOT NULL,
  `email` varchar(50) NOT NULL,
  `paypalemail` text NOT NULL,
  `payzaemail` text NOT NULL,
  `skrillemail` text NOT NULL,
  `2checkoutemail` text NOT NULL,
  `g2aemail` text NOT NULL,
  `refid` varchar(40) NOT NULL,
  `totalrefs` int(11) NOT NULL,
  `refearnings` varchar(15) NOT NULL,
  `uplineearnings` varchar(15) NOT NULL,
  `balance` varchar(12) NOT NULL,
  `tickets` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `city` varchar(60) NOT NULL,
  `zipcode` varchar(30) NOT NULL,
  `telephone` varchar(50) NOT NULL,
  `country` varchar(60) NOT NULL,
  `datereg` varchar(100) NOT NULL,
  `regip` varchar(100) NOT NULL,
  `last1ip` varchar(100) NOT NULL,
  `last2ip` varchar(100) NOT NULL,
  `last3ip` varchar(100) NOT NULL,
  `last4ip` varchar(100) NOT NULL,
  `last5ip` varchar(100) NOT NULL,
  `last6ip` varchar(100) NOT NULL,
  `last7ip` varchar(100) NOT NULL,
  `date1` int(11) NOT NULL,
  `date2` int(11) NOT NULL,
  `date3` int(11) NOT NULL,
  `date4` int(11) NOT NULL,
  `date5` int(11) NOT NULL,
  `date6` int(11) NOT NULL,
  `date7` int(11) NOT NULL,
  `rdate1` int(11) NOT NULL,
  `rdate2` int(11) NOT NULL,
  `rdate3` int(11) NOT NULL,
  `rdate4` int(11) NOT NULL,
  `rdate5` int(11) NOT NULL,
  `rdate6` int(11) NOT NULL,
  `rdate7` int(11) NOT NULL,
  `hash` text NOT NULL,
  `api` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Accounts_Classic_Publishers`
--

INSERT INTO `Accounts_Classic_Publishers` (`id`, `username`, `password`, `email`, `paypalemail`, `payzaemail`, `skrillemail`, `2checkoutemail`, `g2aemail`, `refid`, `totalrefs`, `refearnings`, `uplineearnings`, `balance`, `tickets`, `name`, `address`, `city`, `zipcode`, `telephone`, `country`, `datereg`, `regip`, `last1ip`, `last2ip`, `last3ip`, `last4ip`, `last5ip`, `last6ip`, `last7ip`, `date1`, `date2`, `date3`, `date4`, `date5`, `date6`, `date7`, `rdate1`, `rdate2`, `rdate3`, `rdate4`, `rdate5`, `rdate6`, `rdate7`, `hash`, `api`) VALUES
(9, 'admin', '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', '', '', 0, '', '', '', 0, 'a', 's', '', '', '', '', '', '', '95.170.241.220', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '476be9702872987b11508359a031794d');

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

--
-- Štruktúra tabuľky pre tabuľku `Accounts_Premium_Admin`
--

CREATE TABLE IF NOT EXISTS `Accounts_Premium_Admin` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(200) NOT NULL,
  `pincode` int(4) NOT NULL,
  `ip` text NOT NULL,
  `major` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Accounts_Premium_Admin`
--

INSERT INTO `Accounts_Premium_Admin` (`id`, `username`, `password`, `pincode`, `ip`, `major`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 1234, '', 0);

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

--
-- Štruktúra tabuľky pre tabuľku `Accounts_Premium_Payments`
--

CREATE TABLE IF NOT EXISTS `Accounts_Premium_Payments` (
  `id` int(11) NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `balance` text NOT NULL,
  `email` text NOT NULL,
  `pincode` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `ppemail` text NOT NULL,
  `pzemail` text NOT NULL,
  `skrillemail` text NOT NULL,
  `2checkoutemail` text NOT NULL,
  `g2aemail` text NOT NULL,
  `ip` text NOT NULL,
  `got` text NOT NULL,
  `paid` text NOT NULL,
  `paypal_cashback` text NOT NULL,
  `paypal_cashbackverified` text NOT NULL,
  `payza_cashback` text NOT NULL,
  `payza_cashbackverified` text NOT NULL,
  `skrill_cashback` text NOT NULL,
  `skrill_cashbackverified` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `Accounts_Premium_Support`
--

CREATE TABLE IF NOT EXISTS `Accounts_Premium_Support` (
  `id` int(11) NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `balance` text NOT NULL,
  `pincode` int(4) NOT NULL,
  `ppemail` text NOT NULL,
  `pzemail` text NOT NULL,
  `skrillemail` text NOT NULL,
  `status` int(1) NOT NULL,
  `fullname` text NOT NULL,
  `language` text NOT NULL,
  `language2` text NOT NULL,
  `language3` text NOT NULL,
  `ip` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `Ads_All`
--

CREATE TABLE IF NOT EXISTS `Ads_All` (
  `id` int(11) NOT NULL,
  `title` text NOT NULL,
  `owner` varchar(50) NOT NULL,
  `adtype` varchar(50) NOT NULL,
  `url` varchar(100) NOT NULL,
  `imageurl` varchar(200) NOT NULL,
  `credits` int(6) NOT NULL,
  `countries` varchar(250) NOT NULL,
  `urlVT` text NOT NULL,
  `mediaurlVT` text NOT NULL,
  `active` int(3) NOT NULL,
  `approved` int(3) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `Links_All`
--

CREATE TABLE IF NOT EXISTS `Links_All` (
  `id` int(11) NOT NULL,
  `url` text NOT NULL,
  `code` varchar(20) NOT NULL,
  `username` varchar(50) NOT NULL,
  `advtype` varchar(20) NOT NULL,
  `views` int(20) NOT NULL,
  `mearned` varchar(10) NOT NULL,
  `title` varchar(25) NOT NULL,
  `password` text NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `System_Data`
--

CREATE TABLE IF NOT EXISTS `System_Data` (
  `id` int(11) NOT NULL,
  `username` text NOT NULL,
  `purchasecode` text NOT NULL,
  `version` text NOT NULL,
  `versioncheckurl` text NOT NULL,
  `lastversion` text NOT NULL,
  `lastchecked` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `System_Data`
--

INSERT INTO `System_Data` (`id`, `username`, `purchasecode`, `version`, `versioncheckurl`, `lastversion`, `lastchecked`) VALUES
(1, 'envatousername', 'purchasecode', '10000', 'https://www.googledrive.com/host/0B0V9bcP9cv1qfmNjMlhlYXBLUXYyYm9Hbm1ua1hfVTZaeUZJSmJLWElRV19lY2F3WUZETlk/', '10000', '2015-06-02 09:12:00');

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

--
-- Štruktúra tabuľky pre tabuľku `Tickets_All`
--

CREATE TABLE IF NOT EXISTS `Tickets_All` (
  `id` int(11) NOT NULL,
  `title` text NOT NULL,
  `client_username` varchar(100) NOT NULL,
  `client_type` text NOT NULL,
  `support_username` varchar(100) NOT NULL,
  `support_type` text NOT NULL,
  `date` text NOT NULL,
  `createdbyip` text NOT NULL,
  `posts` int(11) NOT NULL,
  `client_readed` int(11) NOT NULL,
  `client_answered` int(11) NOT NULL,
  `support_readed` int(11) NOT NULL,
  `support_answered` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `Tickets_Entries`
--

CREATE TABLE IF NOT EXISTS `Tickets_Entries` (
  `id` int(11) NOT NULL,
  `ticketid` int(11) NOT NULL,
  `writerusername` varchar(10) NOT NULL,
  `writertype` text NOT NULL,
  `client_readed` int(11) NOT NULL,
  `client_answered` int(11) NOT NULL,
  `support_readed` int(11) NOT NULL,
  `support_answered` int(11) NOT NULL,
  `date` text NOT NULL,
  `ip` text NOT NULL,
  `message` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Banners`
--

CREATE TABLE IF NOT EXISTS `Web_Banners` (
  `id` int(11) NOT NULL,
  `filename` text NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Contests`
--

CREATE TABLE IF NOT EXISTS `Web_Contests` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` varchar(5000) NOT NULL,
  `startdate` varchar(100) NOT NULL,
  `enddate` varchar(100) NOT NULL,
  `price` text NOT NULL,
  `winner` varchar(100) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Contests`
--

INSERT INTO `Web_Contests` (`id`, `title`, `description`, `startdate`, `enddate`, `price`, `winner`) VALUES
(1, 'How fast you are?', 'Earn biggest amount from now until 19.06 2015 and grab this great price ;)<br><br>Winner will be announced 20.06 2015', '2015-06-01', '2015-06-07', '500', '--NOT YET--'),
(2, 'Titleaaaaaa', 'Description Loooong<br>', '2017-06-18 23:15:00', '2017-06-19 23:15:00', '500', '--NOT YET--'),
(3, 'How fast you are?', 'Earn biggest amount from now until 19.06 2015 and grab this great price ;)<br><br>Winner will be announced 20.06 2015', '2015-05-18', '2015-06-19', '500', '--NOT YET--');

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Countries`
--

CREATE TABLE IF NOT EXISTS `Web_Countries` (
  `id` int(11) NOT NULL,
  `country` varchar(150) NOT NULL,
  `ppv` varchar(20) NOT NULL,
  `ppvb` varchar(20) NOT NULL,
  `ppvadv` varchar(20) NOT NULL,
  `ppvbadv` varchar(20) NOT NULL,
  `ppvvideo` varchar(20) NOT NULL,
  `cpvvideo` varchar(20) NOT NULL,
  `lang` text NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=245 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Countries`
--

INSERT INTO `Web_Countries` (`id`, `country`, `ppv`, `ppvb`, `ppvadv`, `ppvbadv`, `ppvvideo`, `cpvvideo`, `lang`) VALUES
(0, 'ALL', '1', '0.5', '5', '4.5', '3.15', '6', 'english'),
(1, 'United Kingdom', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(2, 'Canada', '1', '0.5', '5', '4.5', '2', '6', 'french'),
(3, 'India', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(4, 'United States', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(5, 'China', '1', '0.5', '5', '4.5', '2', '6', 'chinese'),
(6, 'Afghanistan', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(7, 'Aland Islands', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(8, 'Albania', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(9, 'Algeria', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(10, 'American Samoa', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(11, 'Andorra', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(12, 'Angola', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(13, 'Antigua and Barbuda', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(14, 'Argentina', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(15, 'Armenia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(16, 'Aruba', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(17, 'Asia/Pacific Region', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(18, 'Australia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(19, 'Austria', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(20, 'Azerbaijan', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(21, 'Bahamas', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(22, 'Bahrain', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(23, 'Bangladesh', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(24, 'Barbados', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(25, 'Belarus', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(26, 'Belgium', '1', '0.5', '5', '4.5', '2', '6', 'german'),
(27, 'Belize', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(28, 'Benin', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(29, 'Bermuda', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(30, 'Bhutan', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(31, 'Bolivia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(32, 'Bosnia and Herzegovina', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(33, 'Botswana', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(34, 'Bouvet Island', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(35, 'Brazil', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(36, 'British Indian Ocean Territory', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(37, 'Brunei Darussalam', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(38, 'Bulgaria', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(39, 'Burkina Faso', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(40, 'Burundi', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(41, 'Cambodia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(42, 'Cameroon', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(43, 'Canada', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(44, 'Cape Verde', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(45, 'Cayman Islands', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(46, 'Central African Republic', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(47, 'Chad', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(48, 'Chile', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(49, 'China', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(50, 'Colombia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(51, 'Comoros', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(52, 'Congo', '1', '0.5', '5', '4.5', '2', '6', 'french'),
(53, 'Congo, The Democratic Republic of the', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(54, 'Cook Islands', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(55, 'Costa Rica', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(56, 'Cote DIvoire', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(57, 'Croatia', '1', '0.5', '5', '4.5', '2', '6', 'croatian'),
(58, 'Cuba', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(59, 'Cyprus', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(60, 'Czech Republic', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(61, 'Denmark', '1', '0.5', '5', '4.5', '2', '6', 'danish'),
(62, 'Djibouti', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(63, 'Dominica', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(64, 'Dominican Republic', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(65, 'Ecuador', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(66, 'Egypt', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(67, 'El Salvador', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(68, 'Equatorial Guinea', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(69, 'Eritrea', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(70, 'Estonia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(71, 'Ethiopia', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(72, 'Europe', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(73, 'Falkland Islands (Malvinas)', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(74, 'Faroe Islands', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(75, 'Fiji', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(76, 'Finland', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(77, 'France', '1', '0.5', '5', '4.5', '2', '6', 'french'),
(78, 'French Guiana', '1', '0.5', '5', '4.5', '2', '6', 'french'),
(79, 'French Polynesia', '1', '0.5', '5', '4.5', '2', '6', 'french'),
(80, 'Gabon', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(81, 'Gambia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(82, 'Georgia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(83, 'Germany', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(84, 'Ghana', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(85, 'Gibraltar', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(86, 'Greece', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(87, 'Greenland', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(88, 'Grenada', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(89, 'Guadeloupe', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(90, 'Guam', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(91, 'Guatemala', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(92, 'Guernsey', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(93, 'Guinea', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(94, 'Guinea-Bissau', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(95, 'Guyana', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(96, 'Haiti', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(97, 'Holy See (Vatican City State)', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(98, 'Honduras', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(99, 'Hong Kong', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(100, 'Hungary', '1', '0.5', '5', '4.5', '2', '6', 'hungarian'),
(101, 'Iceland', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(102, 'India', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(103, 'Indonesia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(104, 'Iran, Islamic Republic of', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(105, 'Iraq', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(106, 'Ireland', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(107, 'Isle of Man', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(108, 'Israel', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(109, 'Italy', '1', '0.5', '5', '4.5', '2', '6', 'italian'),
(110, 'Jamaica', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(111, 'Japan', '1', '0.5', '5', '4.5', '2', '6', 'japanese'),
(112, 'Jersey', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(113, 'Jordan', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(114, 'Kazakhstan', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(115, 'Kenya', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(116, 'Kiribati', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(117, 'Korea, Democratic Peoples Republic of', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(118, 'Korea, Republic of', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(119, 'Kuwait', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(120, 'Kyrgyzstan', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(121, 'Lao Peoples Democratic Republic', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(122, 'Latvia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(123, 'Lebanon', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(124, 'Lesotho', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(125, 'Liberia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(126, 'Libyan Arab Jamahiriya', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(127, 'Liechtenstein', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(128, 'Lithuania', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(129, 'Luxembourg', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(130, 'Macau', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(131, 'Macedonia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(132, 'Madagascar', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(133, 'Malawi', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(134, 'Malaysia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(135, 'Maldives', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(136, 'Mali', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(137, 'Malta', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(138, 'Marshall Islands', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(139, 'Martinique', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(140, 'Mauritania', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(141, 'Mauritius', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(142, 'Mayotte', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(143, 'Mexico', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(144, 'Micronesia, Federated States of', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(145, 'Moldova, Republic of', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(146, 'Monaco', '1', '0.5', '5', '4.5', '2', '6', 'french'),
(147, 'Mongolia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(148, 'Montenegro', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(149, 'Montserrat', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(150, 'Morocco', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(151, 'Mozambique', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(152, 'Myanmar', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(153, 'Namibia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(154, 'Nauru', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(155, 'Nepal', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(156, 'Netherlands', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(157, 'Netherlands Antilles', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(158, 'New Caledonia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(159, 'New Zealand', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(160, 'Nicaragua', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(161, 'Niger', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(162, 'Nigeria', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(163, 'Niue', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(164, 'Norfolk Island', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(165, 'Northern Mariana Islands', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(166, 'Norway', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(167, 'Oman', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(168, 'Pakistan', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(169, 'Palau', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(170, 'Palestinian Territory, Occupied', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(171, 'Panama', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(172, 'Papua New Guinea', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(173, 'Paraguay', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(174, 'Peru', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(175, 'Philippines', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(176, 'Poland', '1', '0.5', '5', '4.5', '2', '6', 'polish'),
(177, 'Portugal', '1', '0.5', '5', '4.5', '2', '6', 'portuguese'),
(178, 'Puerto Rico', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(179, 'Qatar', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(180, 'Reunion', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(181, 'Romania', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(182, 'Russian Federation', '1', '0.5', '5', '4.5', '2', '6', 'russian'),
(183, 'Rwanda', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(184, 'Saint Kitts and Nevis', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(185, 'Saint Lucia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(186, 'Saint Martin', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(187, 'Saint Pierre and Miquelon', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(188, 'Saint Vincent and the Grenadines', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(189, 'Samoa', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(190, 'San Marino', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(191, 'Sao Tome and Principe', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(192, 'Satellite Provider', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(193, 'Saudi Arabia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(194, 'Senegal', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(195, 'Serbia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(196, 'Seychelles', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(197, 'Sierra Leone', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(198, 'Singapore', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(199, 'Slovakia', '1', '0.5', '5', '4.5', '2', '6', 'slovak'),
(200, 'Slovenia', '1', '0.5', '5', '4.5', '2', '6', 'slovenian'),
(201, 'Solomon Islands', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(202, 'Somalia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(203, 'South Africa', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(204, 'Spain', '1', '0.5', '5', '4.5', '2', '6', 'spanish'),
(205, 'Sri Lanka', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(206, 'Sudan', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(207, 'Suriname', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(208, 'Swaziland', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(209, 'Sweden', '1', '0.5', '5', '4.5', '2', '6', 'swedish'),
(210, 'Switzerland', '1', '0.5', '5', '4.5', '2', '6', 'german'),
(211, 'Syrian Arab Republic', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(212, 'Taiwan', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(213, 'Tajikistan', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(214, 'Tanzania, United Republic of', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(215, 'Thailand', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(216, 'Togo', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(217, 'Tokelau', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(218, 'Tonga', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(219, 'Trinidad and Tobago', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(220, 'Tunisia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(221, 'Turkey', '1', '0.5', '5', '4.5', '2', '6', 'arabic'),
(222, 'Turkmenistan', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(223, 'Turks and Caicos Islands', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(224, 'Tuvalu', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(225, 'Uganda', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(226, 'Ukraine', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(227, 'United Arab Emirates', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(228, 'United Kingdom', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(229, 'United States', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(230, 'United States Minor Outlying Islands', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(231, 'Uruguay', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(232, 'Uzbekistan', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(233, 'Vanuatu', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(234, 'Venezuela', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(235, 'Vietnam', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(236, 'Virgin Islands, British', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(237, 'Virgin Islands, U.S.', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(238, 'Wallis and Futuna', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(239, 'Yemen', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(240, 'Zambia', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(241, 'Zimbabwe', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(244, 'Antarctica', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(242, 'Anonymous Proxy', '1', '0.5', '5', '4.5', '2', '6', 'english'),
(243, 'Anguilla', '1', '0.5', '5', '4.5', '2', '6', 'english');

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Currency`
--

CREATE TABLE IF NOT EXISTS `Web_Currency` (
  `id` int(11) NOT NULL,
  `ISO` text NOT NULL,
  `name` text NOT NULL,
  `active` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=160 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Currency`
--

INSERT INTO `Web_Currency` (`id`, `ISO`, `name`, `active`) VALUES
(1, 'AED', 'United Arab Emirates Dirham', 0),
(2, 'AFN', 'Afghanistan Afghani', 0),
(3, 'ALL', 'Albania Lek', 0),
(4, 'AMD', 'Armenia Dram', 0),
(5, 'ANG', 'Netherlands Antilles Guilder', 0),
(6, 'AOA', 'Angola Kwanza', 0),
(7, 'ARS', 'Argentina Peso', 0),
(8, 'AUD', 'Australia Dollar', 0),
(9, 'AWG', 'Aruba Guilder', 0),
(10, 'AZN', 'Azerbaijan New Manat', 0),
(11, 'BAM', 'Bosnia and Herzegovina Convertible Marka', 0),
(12, 'BBD', 'Barbados Dollar', 0),
(13, 'BDT', 'Bangladesh Taka', 0),
(14, 'BGN', 'Bulgaria Lev', 0),
(15, 'BHD', 'Bahrain Dinar', 0),
(16, 'BIF', 'Burundi Franc', 0),
(17, 'BMD', 'Bermuda Dollar', 0),
(18, 'BND', 'Brunei Darussalam Dollar', 0),
(19, 'BOB', 'Bolivia Boliviano', 0),
(20, 'BRL', 'Brazil Real', 0),
(21, 'BSD', 'Bahamas Dollar', 0),
(22, 'BTN', 'Bhutan Ngultrum', 0),
(23, 'BWP', 'Botswana Pula', 0),
(24, 'BYR', 'Belarus Ruble', 0),
(25, 'BZD', 'Belize Dollar', 0),
(26, 'CAD', 'Canada Dollar', 0),
(27, 'CDF', 'Congo/Kinshasa Franc', 0),
(28, 'CHF', 'Switzerland Franc', 0),
(29, 'CLP', 'Chile Peso', 0),
(30, 'CNY', 'China Yuan Renminbi', 0),
(31, 'COP', 'Colombia Peso', 0),
(32, 'CRC', 'Costa Rica Colon', 0),
(33, 'CUC', 'Cuba Convertible Peso', 0),
(34, 'CUP', 'Cuba Peso', 0),
(35, 'CVE', 'Cape Verde Escudo', 0),
(36, 'CZK', 'Czech Republic Koruna', 0),
(37, 'DJF', 'Djibouti Franc', 0),
(38, 'DKK', 'Denmark Krone', 0),
(39, 'DOP', 'Dominican Republic Peso', 0),
(40, 'DZD', 'Algeria Dinar', 0),
(41, 'EGP', 'Egypt Pound', 0),
(42, 'ERN', 'Eritrea Nakfa', 0),
(43, 'ETB', 'Ethiopia Birr', 0),
(44, 'EUR', 'Euro', 1),
(45, 'FJD', 'Fiji Dollar', 0),
(46, 'FKP', 'Falkland Islands (Malvinas) Pound', 0),
(47, 'GBP', 'United Kingdom Pound', 0),
(48, 'GEL', 'Georgia Lari', 0),
(49, 'GGP', 'Guernsey Pound', 0),
(50, 'GHS', 'Ghana Cedi', 0),
(51, 'GIP', 'Gibraltar Pound', 0),
(52, 'GMD', 'Gambia Dalasi', 0),
(53, 'GNF', 'Guinea Franc', 0),
(54, 'GTQ', 'Guatemala Quetzal', 0),
(55, 'GYD', 'Guyana Dollar', 0),
(56, 'HKD', 'Hong Kong Dollar', 0),
(57, 'HNL', 'Honduras Lempira', 0),
(58, 'HRK', 'Croatia Kuna', 0),
(59, 'HTG', 'Haiti Gourde', 0),
(60, 'HUF', 'Hungary Forint', 0),
(61, 'IDR', 'Indonesia Rupiah', 0),
(62, 'ILS', 'Israel Shekel', 0),
(63, 'IMP', 'Isle of Man Pound', 0),
(64, 'INR', 'India Rupee', 0),
(65, 'IQD', 'Iraq Dinar', 0),
(66, 'IRR', 'Iran Rial', 0),
(67, 'ISK', 'Iceland Krona', 0),
(68, 'JEP', 'Jersey Pound', 0),
(69, 'JMD', 'Jamaica Dollar', 0),
(70, 'JOD', 'Jordan Dinar', 0),
(71, 'JPY', 'Japan Yen', 0),
(72, 'KES', 'Kenya Shilling', 0),
(73, 'KGS', 'Kyrgyzstan Som', 0),
(74, 'KHR', 'Cambodia Riel', 0),
(75, 'KMF', 'Comoros Franc', 0),
(76, 'KPW', 'Korea (North) Won', 0),
(77, 'KRW', 'Korea (South) Won', 0),
(78, 'KWD', 'Kuwait Dinar', 0),
(79, 'KYD', 'Cayman Islands Dollar', 0),
(80, 'KZD', 'Kazakhstan Tenge', 0),
(81, 'LAK', 'Laos Kip', 0),
(82, 'LBP', 'Lebanon Pound', 0),
(83, 'LKR', 'Sri Lanka Rupee', 0),
(84, 'LRD', 'Liberia Dollar', 0),
(85, 'LSL', 'Lesotho Loti', 0),
(86, 'LYD', 'Libya Dinar', 0),
(87, 'MAD', 'Morocco Dirham', 0),
(88, 'MDL', 'Moldova Leu', 0),
(89, 'MGA', 'Madagascar Ariary', 0),
(90, 'MKD', 'Macedonia Denar', 0),
(91, 'MMK', 'Myanmar (Burma) Kyat', 0),
(92, 'MNT', 'Mongolia Tughrik', 0),
(93, 'MOP', 'Macau Pataca', 0),
(94, 'MRO', 'Mauritania Ouguiya', 0),
(95, 'MUR', 'Mauritius Rupee', 0),
(96, 'MVR', 'Maldives (Maldive Islands) Rufiyaa', 0),
(97, 'MWK', 'Malawi Kwacha', 0),
(98, 'MXN', 'Mexico Peso', 0),
(99, 'MYR', 'Malaysia Ringgit', 0),
(100, 'MZN', 'Mozambique Metical', 0),
(101, 'NAD', 'Namibia Dollar', 0),
(102, 'NGN', 'Nigeria Naira', 0),
(103, 'NIO', 'Nicaragua Cordoba', 0),
(104, 'NOK', 'Norway Krone', 0),
(105, 'NPR', 'Nepal Rupee', 0),
(106, 'NZD', 'New Zealand Dollar', 0),
(107, 'OMR', 'Oman Rial', 0),
(108, 'PAB', 'Panama Balboa', 0),
(109, 'PEN', 'Peru Nuevo Sol', 0),
(110, 'PGK', 'Papua New Guinea Kina', 0),
(111, 'PHP', 'Philippines Peso', 0),
(112, 'PKR', 'Pakistan Rupee', 0),
(113, 'PLN', 'Poland Zloty', 0),
(114, 'PYG', 'Paraguay Guarani', 0),
(115, 'QAR', 'Qatar Riyal', 0),
(116, 'RON', 'Romania New Leu', 0),
(117, 'RSD', 'Serbia Dinar', 0),
(118, 'RUB', 'Russia Ruble', 0),
(119, 'RWF', 'Rwanda Franc', 0),
(120, 'SAR', 'Saudi Arabia Riyal', 0),
(121, 'SBD', 'Solomon Islands Dollar', 0),
(122, 'SCR', 'Seychelles Rupee', 0),
(123, 'SDG', 'Sudan Pound', 0),
(124, 'SEK', 'Sweden Krona', 0),
(125, 'SGD', 'Singapore Dollar', 0),
(126, 'SHP', 'Saint Helena Pound', 0),
(127, 'SLL', 'Sierra Leone Leone', 0),
(128, 'SOS', 'Somalia Shilling', 0),
(129, 'SRD', 'Suriname Dollar', 0),
(130, 'STD', 'São Tomé and Príncipe Dobra', 0),
(131, 'SVC', 'El Salvador Colon', 0),
(132, 'SYP', 'Syria Pound', 0),
(133, 'SZL', 'Swaziland Lilangeni', 0),
(134, 'THB', 'Thailand Baht', 0),
(135, 'TJS', 'Tajikistan Somoni', 0),
(136, 'TMT', 'Turkmenistan Manat', 0),
(137, 'TND', 'Tunisia Dinar', 0),
(138, 'TOP', 'Tonga Pa''anga', 0),
(139, 'TRY', 'Turkey Lira', 0),
(140, 'TTD', 'Trinidad and Tobago Dollar', 0),
(141, 'TVD', 'Tuvalu Dollar', 0),
(142, 'TWD', 'Taiwan New Dollar', 0),
(143, 'TZS', 'Tanzania Shilling', 0),
(144, 'UAH', 'Ukraine Hryvnia', 0),
(145, 'UGX', 'Uganda Shilling', 0),
(146, 'USD', 'United States Dollar', 0),
(147, 'UYU', 'Uruguay Peso', 0),
(148, 'UZS', 'Uzbekistan Som', 0),
(149, 'VEF', 'Venezuela Bolivar', 0),
(150, 'VND', 'Viet Nam Dong', 0),
(151, 'VUV', 'Vanuatu Vatu', 0),
(152, 'WST', 'Samoa Tala', 0),
(153, 'XAF', 'Communauté Financière Africaine', 0),
(154, 'XCD', 'East Caribbean Dollar', 0),
(155, 'XDR', 'International Monetary Fund', 0),
(156, 'YER', 'Yemen Rial', 0),
(157, 'ZAR', 'South Africa Rand', 0),
(158, 'ZMW', 'Zambia Kwacha', 0),
(159, 'ZWD', 'Zimbabwe Dollar', 0);

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Deposits`
--

CREATE TABLE IF NOT EXISTS `Web_Deposits` (
  `id` int(11) NOT NULL,
  `date` text NOT NULL,
  `gateway` text NOT NULL,
  `username` text NOT NULL,
  `accounttype` text NOT NULL,
  `amount` int(11) NOT NULL,
  `currency` text NOT NULL,
  `email` text NOT NULL,
  `status` int(11) NOT NULL,
  `message` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Footer_Menu`
--

CREATE TABLE IF NOT EXISTS `Web_Footer_Menu` (
  `id` int(11) NOT NULL,
  `ordernum` int(11) NOT NULL,
  `modal` int(11) NOT NULL,
  `name` text NOT NULL,
  `local` int(11) NOT NULL,
  `link` text NOT NULL,
  `up` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Footer_Menu`
--

INSERT INTO `Web_Footer_Menu` (`id`, `ordernum`, `modal`, `name`, `local`, `link`, `up`) VALUES
(1, 1, 0, '[25]', 1, 'f.home', 0),
(2, 2, 1, '[113]', 1, '#forgotpass', 0),
(3, 3, 0, '[192]', 1, 'f.publisher_rates', 0),
(4, 4, 0, '[191]', 1, 'f.advertiser_rates_int', 0),
(5, 5, 0, '[12]', 1, 'f.signin', 0),
(6, 6, 0, '[32]', 1, 'f.signin', 0);

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Gateways`
--

CREATE TABLE IF NOT EXISTS `Web_Gateways` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `phpname` text NOT NULL,
  `status` int(11) NOT NULL,
  `active_deposit` int(11) NOT NULL,
  `active_withdraw` int(11) NOT NULL,
  `data1` text NOT NULL,
  `data2` text NOT NULL,
  `data3` text NOT NULL,
  `data4` text NOT NULL,
  `data5` text NOT NULL,
  `data6` text NOT NULL,
  `taxpercentage` text NOT NULL,
  `taxdollars` text NOT NULL,
  `fee_withdraw` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Gateways`
--

INSERT INTO `Web_Gateways` (`id`, `name`, `phpname`, `status`, `active_deposit`, `active_withdraw`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `taxpercentage`, `taxdollars`, `fee_withdraw`) VALUES
(1, 'PayPal', 'paypal', 1, 1, 1, 'email@email.com', '0', 'something', 'something', 'Thank your for using our services. We sending you your earned money. Good luck with another earnings.', 'something', '3.9', '0.35', '0.5'),
(2, 'Payza', 'payza', 1, 1, 1, 'email@email.com', '0', 'something', 'something', 'Thank your for using our services. We sending you your earned money. Good luck with another earnings.', 'something', '2.5', '0.25', '0.5'),
(3, 'G2A Pay', 'g2apay', 1, 1, 0, 'email@email.com', 'APIHASH', 'SECRETHASH', 'something', 'Thank your for using our services. We sending you your earned money. Good luck with another earnings.', 'something', '8.99', '0', '0.5'),
(4, '2Checkout', 'twocheckout', 0, 1, 0, 'email@email.com', 'SID', 'something', 'something', 'Thank your for using our services. We sending you your earned money. Good luck with another earnings.', 'something', '5.5', '0.45', ''),
(5, 'Skrill', 'skrill', 1, 1, 1, 'email@email.com', 'skrillword', 'something', 'something', 'Thank your for using our services. We sending you your earned money. Good luck with another earnings.', 'something', '3.9', '0.35', '0.5');

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Header_Menu`
--

CREATE TABLE IF NOT EXISTS `Web_Header_Menu` (
  `id` int(11) NOT NULL,
  `ordernum` int(11) NOT NULL,
  `modal` int(11) NOT NULL,
  `name` text NOT NULL,
  `local` int(11) NOT NULL,
  `link` text NOT NULL,
  `up` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Header_Menu`
--

INSERT INTO `Web_Header_Menu` (`id`, `ordernum`, `modal`, `name`, `local`, `link`, `up`) VALUES
(1, 1, 0, '[25]', 1, 'f.home', 0),
(2, 2, 0, '[9]', 1, '#', 0),
(3, 3, 0, '[192]', 1, 'f.publisher_rates', 2),
(4, 4, 0, '[191]', 1, 'f.advertiser_rates_int', 2),
(5, 5, 0, '[32]', 1, 'f.signin', 0);

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Home_Blocks`
--

CREATE TABLE IF NOT EXISTS `Web_Home_Blocks` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `ordernum` int(11) NOT NULL,
  `html` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Home_Blocks`
--

INSERT INTO `Web_Home_Blocks` (`id`, `name`, `ordernum`, `html`) VALUES
(4, 'About us', 2, 'We are URL shortening service, which offer belong shortening URLs, to earn money for people worldwide.<br>');

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Images`
--

CREATE TABLE IF NOT EXISTS `Web_Images` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `url` text NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Images`
--

INSERT INTO `Web_Images` (`id`, `name`, `url`, `width`, `height`) VALUES
(1, 'Testa', 'http://www.zoneme.ga/Projects/Shortify/data/uploads/files/images/VT.png', 1308, 1805);

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

--
-- Štruktúra tabuľky pre tabuľku `Web_IPcheck`
--

CREATE TABLE IF NOT EXISTS `Web_IPcheck` (
  `id` int(11) NOT NULL,
  `url` varchar(150) NOT NULL,
  `ip` varchar(30) NOT NULL,
  `hash1` text NOT NULL,
  `hash2` text NOT NULL,
  `hash3` text NOT NULL,
  `hash4` text NOT NULL,
  `hash5` text NOT NULL,
  `hash6` text NOT NULL,
  `hash7` text NOT NULL,
  `hash8` text NOT NULL,
  `hash9` text NOT NULL,
  `adid` text NOT NULL,
  `uses` text NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Multipage`
--

CREATE TABLE IF NOT EXISTS `Web_Multipage` (
  `id` int(11) NOT NULL,
  `url` text NOT NULL,
  `name` text NOT NULL,
  `hash` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `Web_News`
--

CREATE TABLE IF NOT EXISTS `Web_News` (
  `id` int(11) NOT NULL,
  `date` varchar(100) NOT NULL,
  `title` varchar(100) NOT NULL,
  `message` text NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_News`
--

INSERT INTO `Web_News` (`id`, `date`, `title`, `message`) VALUES
(1, '-Blank-', 'Title', 'Hello there! This is first self-system generated news for your customers.');

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

--
-- Štruktúra tabuľky pre tabuľku `Web_New_data`
--

CREATE TABLE IF NOT EXISTS `Web_New_data` (
  `id` int(11) NOT NULL,
  `data1` text NOT NULL,
  `data2` text NOT NULL,
  `data3` text NOT NULL,
  `data4` int(11) NOT NULL,
  `data5` int(11) NOT NULL,
  `data6` int(11) NOT NULL,
  `data7` int(11) NOT NULL,
  `data8` int(11) NOT NULL,
  `data9` int(11) NOT NULL,
  `data10` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Pages`
--

CREATE TABLE IF NOT EXISTS `Web_Pages` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `url` text NOT NULL,
  `filename` text NOT NULL,
  `html` text NOT NULL,
  `custom` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Pages`
--

INSERT INTO `Web_Pages` (`id`, `name`, `url`, `filename`, `html`, `custom`) VALUES
(1, 'About', '', 'about', '<p><span style="font-family: Impact;"><span style="font-size: 24px;">About us</span></span><br></p><p><br></p><p style="text-align: left;"><span style="font-size: 12px;">Hi. </span></p><p style="text-align: left;"><span style="font-size: 12px;">:)</span></p><p style="text-align: left;"><span style="font-size: 12px;">jozef<br></span><br></p>', 1),
(2, 'home', 'home', 'Home', '', 0),
(3, 'publisher_rates', 'publisher_rates', 'AboutPRates', '', 0),
(4, 'advertiser_rates_int', 'advertiser_rates_int', 'AboutARatesINT', '', 0),
(5, 'advertiser_rates_banner', 'advertiser_rates_banner', 'AboutARatesBANNER', '', 0),
(6, 'advertiser_rates_video', 'advertiser_rates_video', 'AboutARatesVIDEO', '', 0),
(7, 'abuse', 'abuse', 'Abuse', '', 0),
(8, 'contact', 'contact', 'Contact', '', 0),
(12, 'Please sign in', '', 'signin', 'Please sign in to continue.<br>', 1);

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Plugins`
--

CREATE TABLE IF NOT EXISTS `Web_Plugins` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `activated` int(11) NOT NULL,
  `turnable` int(11) NOT NULL,
  `directory` text NOT NULL,
  `version` int(11) NOT NULL,
  `masterfile` text NOT NULL,
  `headername` text NOT NULL,
  `backfile` text NOT NULL,
  `data1` text NOT NULL,
  `data2` text NOT NULL,
  `data3` text NOT NULL,
  `data4` text NOT NULL,
  `data5` text NOT NULL,
  `data6` text NOT NULL,
  `data7` text NOT NULL,
  `data8` text NOT NULL,
  `data9` text NOT NULL,
  `data10` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Plugins`
--

INSERT INTO `Web_Plugins` (`id`, `name`, `activated`, `turnable`, `directory`, `version`, `masterfile`, `headername`, `backfile`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`) VALUES
(1, 'PHP Mailer', 1, 0, 'phpmailer', 1000, 'PluginLoad.php', 'PHP Mailer', 'PHPMailer', 'System built', '', '', '', '', '', '', '', '', ''),
(2, 'WYSIWYG', 1, 0, 'wysiwyg', 1000, 'PluginLoad.php', 'WYSIWYG', 'WYSIWYG', 'System built', '', '', '', '', '', '', '', '', '');

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Premium_Login`
--

CREATE TABLE IF NOT EXISTS `Web_Premium_Login` (
  `id` int(11) NOT NULL,
  `admin` text NOT NULL,
  `payments` text NOT NULL,
  `support` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Premium_Login`
--

INSERT INTO `Web_Premium_Login` (`id`, `admin`, `payments`, `support`) VALUES
(1, 'adminsecret', 'paymentssecren', 'supportsecret');

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Revenue`
--

CREATE TABLE IF NOT EXISTS `Web_Revenue` (
  `id` int(11) NOT NULL,
  `revenue` text NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Sťahujem dáta pre tabuľku `Web_Revenue`
--

INSERT INTO `Web_Revenue` (`id`, `revenue`) VALUES
(1, '0');

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Settings`
--

CREATE TABLE IF NOT EXISTS `Web_Settings` (
  `id` int(11) NOT NULL,
  `mainurl` text NOT NULL,
  `wpay` varchar(11) NOT NULL,
  `paid` varchar(11) NOT NULL,
  `mincashout` varchar(11) NOT NULL,
  `mindeposit` int(11) NOT NULL,
  `jsonrates` text NOT NULL,
  `virustotal` text NOT NULL,
  `homeblocks` int(11) NOT NULL,
  `paymentproof` int(11) NOT NULL,
  `hwmchproofs` int(11) NOT NULL,
  `ppvr` varchar(11) NOT NULL,
  `contactem` varchar(50) NOT NULL,
  `ppemail` varchar(80) NOT NULL,
  `apemail` varchar(80) NOT NULL,
  `title` varchar(50) NOT NULL,
  `keywords` varchar(150) NOT NULL,
  `nologintitle` text NOT NULL,
  `description` varchar(200) NOT NULL,
  `interstitialactive` int(11) NOT NULL,
  `banneractive` int(3) NOT NULL,
  `videoactive` int(3) NOT NULL,
  `autocontinue` int(3) NOT NULL,
  `smtphost` text NOT NULL,
  `smtpport` text NOT NULL,
  `smtpauth` text NOT NULL,
  `smtpusername` text NOT NULL,
  `smtppass` text NOT NULL,
  `replytoemail` text NOT NULL,
  `frommail` text NOT NULL,
  `ftphash` text NOT NULL,
  `viddur` int(10) NOT NULL,
  `intdur` int(11) NOT NULL,
  `bandur` int(11) NOT NULL,
  `smactive` int(3) NOT NULL,
  `smckey` text NOT NULL,
  `smvkey` text NOT NULL,
  `smhkey` text NOT NULL,
  `rcactive` int(3) NOT NULL,
  `rcsitekey` text NOT NULL,
  `rcsecretkey` text NOT NULL,
  `firstrun` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Settings`
--

INSERT INTO `Web_Settings` (`id`, `mainurl`, `wpay`, `paid`, `mincashout`, `mindeposit`, `jsonrates`, `virustotal`, `homeblocks`, `paymentproof`, `hwmchproofs`, `ppvr`, `contactem`, `ppemail`, `apemail`, `title`, `keywords`, `nologintitle`, `description`, `interstitialactive`, `banneractive`, `videoactive`, `autocontinue`, `smtphost`, `smtpport`, `smtpauth`, `smtpusername`, `smtppass`, `replytoemail`, `frommail`, `ftphash`, `viddur`, `intdur`, `bandur`, `smactive`, `smckey`, `smvkey`, `smhkey`, `rcactive`, `rcsitekey`, `rcsecretkey`, `firstrun`) VALUES
(1, '', '0', '0', '10', 5, '', '', 1, 1, 25, '0.2', 'contactemail@mail.com', 'email@email.com', 'email@email.com', 'Title', 'website, keywords, shortify', 'No456Title', 'Website description', 1, 1, 1, 1, '', '587', 'true', '', '', 'no-reply@domain.com', 'no-reply@domain.com', 'd6paAFKhov0lryHPEgxJiQL85ZwTGUO7R2eCmBDcjSs9n', 30, 15, 30, 0, '', '', '', 0, '', '', 1);

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Set_Templates`
--

CREATE TABLE IF NOT EXISTS `Web_Set_Templates` (
  `id` int(11) NOT NULL,
  `device` text NOT NULL,
  `frontend` text NOT NULL,
  `backend` text NOT NULL,
  `shortend` text NOT NULL,
  `panelend` text NOT NULL,
  `supportend` text NOT NULL,
  `paymentsend` text NOT NULL,
  `widgetend` text NOT NULL,
  `premiumlogin` text NOT NULL,
  `emailend` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Set_Templates`
--

INSERT INTO `Web_Set_Templates` (`id`, `device`, `frontend`, `backend`, `shortend`, `panelend`, `supportend`, `paymentsend`, `widgetend`, `premiumlogin`, `emailend`) VALUES
(1, 'computer', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero'),
(2, 'tablet', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero'),
(3, 'phone', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero', 'superhero');

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Stats`
--

CREATE TABLE IF NOT EXISTS `Web_Stats` (
  `id` int(11) NOT NULL,
  `reg1` int(11) NOT NULL,
  `reg2` int(11) NOT NULL,
  `reg3` int(11) NOT NULL,
  `reg4` int(11) NOT NULL,
  `reg5` int(11) NOT NULL,
  `reg6` int(11) NOT NULL,
  `reg7` int(11) NOT NULL,
  `areg1` int(11) NOT NULL,
  `areg2` int(11) NOT NULL,
  `areg3` int(11) NOT NULL,
  `areg4` int(11) NOT NULL,
  `areg5` int(11) NOT NULL,
  `areg6` int(11) NOT NULL,
  `areg7` int(11) NOT NULL,
  `tcash` varchar(15) NOT NULL,
  `tadvcash` int(15) NOT NULL,
  `sclinks1` int(11) NOT NULL,
  `sclinks2` int(11) NOT NULL,
  `sclinks3` int(11) NOT NULL,
  `sclinks4` int(11) NOT NULL,
  `sclinks5` int(11) NOT NULL,
  `sclinks6` int(11) NOT NULL,
  `sclinks7` int(11) NOT NULL,
  `svlinks1` int(11) NOT NULL,
  `svlinks2` int(11) NOT NULL,
  `svlinks3` int(11) NOT NULL,
  `svlinks4` int(11) NOT NULL,
  `svlinks5` int(11) NOT NULL,
  `svlinks6` int(11) NOT NULL,
  `svlinks7` int(11) NOT NULL,
  `tsvlinks` int(11) NOT NULL,
  `membcash1` varchar(15) NOT NULL,
  `membcash2` varchar(15) NOT NULL,
  `membcash3` varchar(15) NOT NULL,
  `membcash4` varchar(15) NOT NULL,
  `membcash5` varchar(15) NOT NULL,
  `membcash6` varchar(15) NOT NULL,
  `membcash7` varchar(15) NOT NULL,
  `advcash1` varchar(15) NOT NULL,
  `advcash2` varchar(15) NOT NULL,
  `advcash3` varchar(15) NOT NULL,
  `advcash4` varchar(15) NOT NULL,
  `advcash5` varchar(15) NOT NULL,
  `advcash6` varchar(15) NOT NULL,
  `advcash7` varchar(15) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Sťahujem dáta pre tabuľku `Web_Stats`
--

INSERT INTO `Web_Stats` (`id`, `reg1`, `reg2`, `reg3`, `reg4`, `reg5`, `reg6`, `reg7`, `areg1`, `areg2`, `areg3`, `areg4`, `areg5`, `areg6`, `areg7`, `tcash`, `tadvcash`, `sclinks1`, `sclinks2`, `sclinks3`, `sclinks4`, `sclinks5`, `sclinks6`, `sclinks7`, `svlinks1`, `svlinks2`, `svlinks3`, `svlinks4`, `svlinks5`, `svlinks6`, `svlinks7`, `tsvlinks`, `membcash1`, `membcash2`, `membcash3`, `membcash4`, `membcash5`, `membcash6`, `membcash7`, `advcash1`, `advcash2`, `advcash3`, `advcash4`, `advcash5`, `advcash6`, `advcash7`) VALUES
(1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Supports`
--

CREATE TABLE IF NOT EXISTS `Web_Supports` (
  `id` int(11) NOT NULL,
  `username` varchar(35) NOT NULL,
  `email` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `ip` varchar(50) NOT NULL,
  `title` varchar(50) NOT NULL,
  `readed` varchar(15) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Themes_All`
--

CREATE TABLE IF NOT EXISTS `Web_Themes_All` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `directory` text NOT NULL,
  `frontend` text NOT NULL,
  `backend` text NOT NULL,
  `shortend` text NOT NULL,
  `panelend` text NOT NULL,
  `supportend` text NOT NULL,
  `paymentsend` text NOT NULL,
  `widgetend` text NOT NULL,
  `premiumlogin` text NOT NULL,
  `emailend` text NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Sťahujem dáta pre tabuľku `Web_Themes_All`
--

INSERT INTO `Web_Themes_All` (`id`, `name`, `directory`, `frontend`, `backend`, `shortend`, `panelend`, `supportend`, `paymentsend`, `widgetend`, `premiumlogin`, `emailend`) VALUES
(11, 'SuperHero', 'superhero', '1', '1', '1', '1', '1', '1', '1', '1', '1');

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

--
-- Štruktúra tabuľky pre tabuľku `Web_TotalIP`
--

CREATE TABLE IF NOT EXISTS `Web_TotalIP` (
  `id` int(11) NOT NULL,
  `url` varchar(150) NOT NULL,
  `ip` varchar(150) NOT NULL,
  `username` varchar(150) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Wages`
--

CREATE TABLE IF NOT EXISTS `Web_Wages` (
  `id` int(11) NOT NULL,
  `username` text NOT NULL,
  `acctype` text NOT NULL,
  `gateway` int(11) NOT NULL,
  `paymail` text NOT NULL,
  `status` int(11) NOT NULL,
  `amount` text NOT NULL,
  `message` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

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

--
-- Štruktúra tabuľky pre tabuľku `Web_Withdraws`
--

CREATE TABLE IF NOT EXISTS `Web_Withdraws` (
  `id` int(11) NOT NULL,
  `client_username` text NOT NULL,
  `client_acctype` text NOT NULL,
  `client_paymail` text NOT NULL,
  `manager_username` text NOT NULL,
  `amount` text NOT NULL,
  `gateway` text NOT NULL,
  `date` text NOT NULL,
  `status` int(11) NOT NULL,
  `message` text CHARACTER SET utf8 NOT NULL,
  `adminstatus` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Kľúče pre exportované tabuľky
--

--
-- Indexy pre tabuľku `Accounts_Classic_Advertisers`
--
ALTER TABLE `Accounts_Classic_Advertisers`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Accounts_Classic_Publishers`
--
ALTER TABLE `Accounts_Classic_Publishers`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Accounts_Premium_Admin`
--
ALTER TABLE `Accounts_Premium_Admin`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Accounts_Premium_Payments`
--
ALTER TABLE `Accounts_Premium_Payments`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Accounts_Premium_Support`
--
ALTER TABLE `Accounts_Premium_Support`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Ads_All`
--
ALTER TABLE `Ads_All`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Links_All`
--
ALTER TABLE `Links_All`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `System_Data`
--
ALTER TABLE `System_Data`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Tickets_All`
--
ALTER TABLE `Tickets_All`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Tickets_Entries`
--
ALTER TABLE `Tickets_Entries`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Banners`
--
ALTER TABLE `Web_Banners`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Contests`
--
ALTER TABLE `Web_Contests`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Countries`
--
ALTER TABLE `Web_Countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Currency`
--
ALTER TABLE `Web_Currency`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Deposits`
--
ALTER TABLE `Web_Deposits`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Footer_Menu`
--
ALTER TABLE `Web_Footer_Menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Gateways`
--
ALTER TABLE `Web_Gateways`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Header_Menu`
--
ALTER TABLE `Web_Header_Menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Home_Blocks`
--
ALTER TABLE `Web_Home_Blocks`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Images`
--
ALTER TABLE `Web_Images`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_IPcheck`
--
ALTER TABLE `Web_IPcheck`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Multipage`
--
ALTER TABLE `Web_Multipage`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_News`
--
ALTER TABLE `Web_News`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_New_data`
--
ALTER TABLE `Web_New_data`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Pages`
--
ALTER TABLE `Web_Pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Plugins`
--
ALTER TABLE `Web_Plugins`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Premium_Login`
--
ALTER TABLE `Web_Premium_Login`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Revenue`
--
ALTER TABLE `Web_Revenue`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Settings`
--
ALTER TABLE `Web_Settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Set_Templates`
--
ALTER TABLE `Web_Set_Templates`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Stats`
--
ALTER TABLE `Web_Stats`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Supports`
--
ALTER TABLE `Web_Supports`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Themes_All`
--
ALTER TABLE `Web_Themes_All`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_TotalIP`
--
ALTER TABLE `Web_TotalIP`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Wages`
--
ALTER TABLE `Web_Wages`
  ADD PRIMARY KEY (`id`);

--
-- Indexy pre tabuľku `Web_Withdraws`
--
ALTER TABLE `Web_Withdraws`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pre exportované tabuľky
--

--
-- AUTO_INCREMENT pre tabuľku `Accounts_Classic_Advertisers`
--
ALTER TABLE `Accounts_Classic_Advertisers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT pre tabuľku `Accounts_Classic_Publishers`
--
ALTER TABLE `Accounts_Classic_Publishers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT pre tabuľku `Accounts_Premium_Admin`
--
ALTER TABLE `Accounts_Premium_Admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT pre tabuľku `Accounts_Premium_Payments`
--
ALTER TABLE `Accounts_Premium_Payments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT pre tabuľku `Accounts_Premium_Support`
--
ALTER TABLE `Accounts_Premium_Support`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT pre tabuľku `Ads_All`
--
ALTER TABLE `Ads_All`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT pre tabuľku `Links_All`
--
ALTER TABLE `Links_All`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=74;
--
-- AUTO_INCREMENT pre tabuľku `System_Data`
--
ALTER TABLE `System_Data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pre tabuľku `Tickets_All`
--
ALTER TABLE `Tickets_All`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pre tabuľku `Tickets_Entries`
--
ALTER TABLE `Tickets_Entries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pre tabuľku `Web_Banners`
--
ALTER TABLE `Web_Banners`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pre tabuľku `Web_Contests`
--
ALTER TABLE `Web_Contests`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT pre tabuľku `Web_Countries`
--
ALTER TABLE `Web_Countries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=245;
--
-- AUTO_INCREMENT pre tabuľku `Web_Currency`
--
ALTER TABLE `Web_Currency`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=160;
--
-- AUTO_INCREMENT pre tabuľku `Web_Deposits`
--
ALTER TABLE `Web_Deposits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pre tabuľku `Web_Footer_Menu`
--
ALTER TABLE `Web_Footer_Menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT pre tabuľku `Web_Gateways`
--
ALTER TABLE `Web_Gateways`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT pre tabuľku `Web_Header_Menu`
--
ALTER TABLE `Web_Header_Menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT pre tabuľku `Web_Home_Blocks`
--
ALTER TABLE `Web_Home_Blocks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT pre tabuľku `Web_Images`
--
ALTER TABLE `Web_Images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pre tabuľku `Web_IPcheck`
--
ALTER TABLE `Web_IPcheck`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=32;
--
-- AUTO_INCREMENT pre tabuľku `Web_Multipage`
--
ALTER TABLE `Web_Multipage`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pre tabuľku `Web_News`
--
ALTER TABLE `Web_News`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT pre tabuľku `Web_New_data`
--
ALTER TABLE `Web_New_data`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pre tabuľku `Web_Pages`
--
ALTER TABLE `Web_Pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT pre tabuľku `Web_Plugins`
--
ALTER TABLE `Web_Plugins`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pre tabuľku `Web_Premium_Login`
--
ALTER TABLE `Web_Premium_Login`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pre tabuľku `Web_Revenue`
--
ALTER TABLE `Web_Revenue`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pre tabuľku `Web_Settings`
--
ALTER TABLE `Web_Settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pre tabuľku `Web_Set_Templates`
--
ALTER TABLE `Web_Set_Templates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT pre tabuľku `Web_Stats`
--
ALTER TABLE `Web_Stats`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pre tabuľku `Web_Supports`
--
ALTER TABLE `Web_Supports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pre tabuľku `Web_Themes_All`
--
ALTER TABLE `Web_Themes_All`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT pre tabuľku `Web_TotalIP`
--
ALTER TABLE `Web_TotalIP`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT pre tabuľku `Web_Wages`
--
ALTER TABLE `Web_Wages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT pre tabuľku `Web_Withdraws`
--
ALTER TABLE `Web_Withdraws`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=25;
/*!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 */;
