CZkL62nE

1-- MySQL dump 10.13  Distrib 5.7.18, for Linux (x86_64)
2--
3-- Host: localhost    Database: viacoin
4-- ------------------------------------------------------
5-- Server version	5.7.18-0ubuntu0.16.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Current Database: `viacoin`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `viacoin` /*!40100 DEFAULT CHARACTER SET utf8 */;
23
24USE `viacoin`;
25
26--
27-- Table structure for table `admin_types`
28--
29
30DROP TABLE IF EXISTS `admin_types`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `admin_types` (
34  `id` int(255) NOT NULL AUTO_INCREMENT,
35  `name` varchar(166) NOT NULL,
36  `auth` text NOT NULL,
37  PRIMARY KEY (`id`)
38) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
39/*!40101 SET character_set_client = @saved_cs_client */;
40
41--
42-- Dumping data for table `admin_types`
43--
44
45LOCK TABLES `admin_types` WRITE;
46/*!40000 ALTER TABLE `admin_types` DISABLE KEYS */;
47INSERT INTO `admin_types` VALUES (1,'Admin','settings,faq,terms-of-service,privacy-policy,security,about-us,how-it-works,sliders,clients,transactions,payments,withdrawals,staff,manage,support,bank-accounts,logs'),(2,'Zkouška zaměstnanec','support,bank-accounts'),(3,'viacoin1','clients,transactions,payments,withdrawals,support');
48/*!40000 ALTER TABLE `admin_types` ENABLE KEYS */;
49UNLOCK TABLES;
50
51--
52-- Table structure for table `admins`
53--
54
55DROP TABLE IF EXISTS `admins`;
56/*!40101 SET @saved_cs_client     = @@character_set_client */;
57/*!40101 SET character_set_client = utf8 */;
58CREATE TABLE `admins` (
59  `id` int(255) NOT NULL AUTO_INCREMENT,
60  `username` varchar(66) NOT NULL,
61  `password` varchar(255) NOT NULL,
62  `email` varchar(166) NOT NULL,
63  `name` varchar(255) NOT NULL,
64  `auth` int(255) NOT NULL,
65  `google_auth` int(1) NOT NULL DEFAULT '0',
66  `google_opt` varchar(66) DEFAULT NULL,
67  `status` int(1) NOT NULL DEFAULT '1',
68  PRIMARY KEY (`id`),
69  KEY `auth` (`auth`)
70) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
71/*!40101 SET character_set_client = @saved_cs_client */;
72
73--
74-- Dumping data for table `admins`
75--
76
77LOCK TABLES `admins` WRITE;
78/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
79INSERT INTO `admins` VALUES (1,'admin','$2y$10$/58qJCCsLzsbIDRx/lwbb.JaWLUKlJ24v4wLFPsuK21Dusy8AsF5O','denizbirlik16@gmail.com','Deniz Birlik',1,2,'4AWRWNFURLFDNQLV',1),(2,'barbie','$2y$10$MH995zkU/X3ERRCZGXY4U.lX0iK0HXNazIU1CK5MBX1IeBhVcAf3.','rz8@email.cz','barbie',3,0,NULL,1);
80/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
81UNLOCK TABLES;
82
83--
84-- Table structure for table `bank_accounts`
85--
86
87DROP TABLE IF EXISTS `bank_accounts`;
88/*!40101 SET @saved_cs_client     = @@character_set_client */;
89/*!40101 SET character_set_client = utf8 */;
90CREATE TABLE `bank_accounts` (
91  `id` int(255) NOT NULL AUTO_INCREMENT,
92  `bank_name` varchar(255) NOT NULL,
93  `account_owner` varchar(255) NOT NULL,
94  `account_number` varchar(166) NOT NULL,
95  `iban` varchar(166) NOT NULL,
96  `logo` varchar(255) NOT NULL,
97  PRIMARY KEY (`id`)
98) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
99/*!40101 SET character_set_client = @saved_cs_client */;
100
101--
102-- Dumping data for table `bank_accounts`
103--
104
105LOCK TABLES `bank_accounts` WRITE;
106/*!40000 ALTER TABLE `bank_accounts` DISABLE KEYS */;
107INSERT INTO `bank_accounts` VALUES (1,'Garanti Bankası','Deniz Birlik','536-7774625','TR83 3823 8323 1239 8732 0000 0000 0233 01','4869a330ca41f4816aeed121ee42715e.jpg'),(2,'mBank','BreBank','670100-2205647536/6210','CZ37 6210 6701 0022 0564 7536','79714ed2cb3c0a0587888eca9bf93791.jpg'),(3,'Raiffeisen bank','Raiffeisen bank','78100909/5500','CZ37 6210 6701 0022 0564 7536 ','6b1c7f9fba55afdc4e43790181d0de53.jpg');
108/*!40000 ALTER TABLE `bank_accounts` ENABLE KEYS */;
109UNLOCK TABLES;
110
111--
112-- Table structure for table `content`
113--
114
115DROP TABLE IF EXISTS `content`;
116/*!40101 SET @saved_cs_client     = @@character_set_client */;
117/*!40101 SET character_set_client = utf8 */;
118CREATE TABLE `content` (
119  `id` int(255) NOT NULL AUTO_INCREMENT,
120  `feature` varchar(255) NOT NULL,
121  `value` text NOT NULL,
122  PRIMARY KEY (`id`)
123) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
124/*!40101 SET character_set_client = @saved_cs_client */;
125
126--
127-- Dumping data for table `content`
128--
129
130LOCK TABLES `content` WRITE;
131/*!40000 ALTER TABLE `content` DISABLE KEYS */;
132INSERT INTO `content` VALUES (1,'security','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut sed pellentesque sem, id placerat enim. Suspendisse pharetra hendrerit felis, ac scelerisque sem posuere et. Phasellus hendrerit est eu ligula posuere, non bibendum dui finibus. Nam odio urna, egestas id maximus in, tincidunt non odio. Nulla facilisi. Nullam cursus quis magna sit amet interdum. Donec iaculis bibendum accumsan.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Nullam vitae eros ex.&nbsp;</font></p>'),(2,'terms_of_service','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Suspendisse potenti. Duis vitae suscipit dui, non pulvinar mauris. Interdum et malesuada fames ac ante ipsum primis in faucibus. Suspendisse augue massa, convallis vitae scelerisque vitae, auctor eu erat. </font></span></p><p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Mauris venenatis dictum justo non ullamcorper. Quisque eu facilisis erat.</font></span></p>'),(3,'about_us','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Maecenas in felis mauris. Mauris dictum massa non pharetra lacinia. Vivamus ut libero orci. Maecenas vitae volutpat sem. Pellentesque ultrices tempus mi, id feugiat nunc interdum sit amet. </font></span></p><p><span style=\"font-family: Verdana; color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\">Vestibulum nec nulla et odio lacinia hendrerit nec nec ex. Praesent placerat nulla eget dolor lobortis commodo. Praesent laoreet felis ut purus dignissim mollis.</span><br></p>'),(4,'privacy_policy','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Mauris hendrerit, elit cursus auctor cursus, enim urna hendrerit eros, sit amet porta dui mauris posuere diam. Pellentesque tempor libero a est viverra faucibus. Vivamus laoreet vulputate nunc quis finibus. Nam dapibus, erat vel tincidunt vehicula, diam eros finibus dolor, quis ultricies massa neque sed purus. Nunc nec est erat. Praesent eget tincidunt eros. Sed gravida placerat ex, venenatis hendrerit tortor facilisis vitae. Mauris faucibus, sem id placerat condimentum, nisl velit sollicitudin urna, in ornare lectus purus in erat.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Sed euismod ultrices ex, et porttitor erat vulputate ac.</font></p>'),(5,'how_it_works','Put how it works content here.');
133/*!40000 ALTER TABLE `content` ENABLE KEYS */;
134UNLOCK TABLES;
135
136--
137-- Table structure for table `faq`
138--
139
140DROP TABLE IF EXISTS `faq`;
141/*!40101 SET @saved_cs_client     = @@character_set_client */;
142/*!40101 SET character_set_client = utf8 */;
143CREATE TABLE `faq` (
144  `id` int(255) NOT NULL AUTO_INCREMENT,
145  `question` text NOT NULL,
146  `answer` text NOT NULL,
147  PRIMARY KEY (`id`)
148) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
149/*!40101 SET character_set_client = @saved_cs_client */;
150
151--
152-- Dumping data for table `faq`
153--
154
155LOCK TABLES `faq` WRITE;
156/*!40000 ALTER TABLE `faq` DISABLE KEYS */;
157INSERT INTO `faq` VALUES (1,'Put your first question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(2,'Put your second question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(3,'Put your third question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(4,'Put your fourth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(5,'Put your fifth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. ');
158/*!40000 ALTER TABLE `faq` ENABLE KEYS */;
159UNLOCK TABLES;
160
161--
162-- Table structure for table `logs`
163--
164
165DROP TABLE IF EXISTS `logs`;
166/*!40101 SET @saved_cs_client     = @@character_set_client */;
167/*!40101 SET character_set_client = utf8 */;
168CREATE TABLE `logs` (
169  `id` int(255) NOT NULL AUTO_INCREMENT,
170  `user_id` int(255) NOT NULL,
171  `date` varchar(66) NOT NULL,
172  `ip_address` varchar(15) NOT NULL,
173  `action` varchar(255) NOT NULL,
174  PRIMARY KEY (`id`)
175) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
176/*!40101 SET character_set_client = @saved_cs_client */;
177
178--
179-- Dumping data for table `logs`
180--
181
182LOCK TABLES `logs` WRITE;
183/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
184INSERT INTO `logs` VALUES (1,1,'1487186560','46.1.26.253','Admin logged in. ID: 1'),(2,1,'1487186956','46.1.26.253','General settings updated.'),(3,1,'1487197554','178.41.76.146','Admin logged in. ID: 1'),(4,1,'1487197560','178.41.76.146','General settings updated.'),(5,1,'1487198805','178.41.76.146','Admin logged in. ID: 1'),(6,1,'1487198816','178.41.76.146','General settings updated.'),(7,1,'1487198862','178.41.76.146','General settings updated.'),(8,1,'1487275896','188.57.63.112','Admin logged in. ID: 1'),(9,1,'1487275901','188.57.63.112','General settings updated.'),(10,1,'1487276131','188.57.63.112','General settings updated.'),(11,1,'1492451242','178.41.71.127','Admin logged in. ID: 1'),(12,1,'1492451251','178.41.71.127','General settings updated.'),(13,1,'1492451263','178.41.71.127','General settings updated.');
185/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
186UNLOCK TABLES;
187
188--
189-- Table structure for table `payments`
190--
191
192DROP TABLE IF EXISTS `payments`;
193/*!40101 SET @saved_cs_client     = @@character_set_client */;
194/*!40101 SET character_set_client = utf8 */;
195CREATE TABLE `payments` (
196  `id` int(255) NOT NULL AUTO_INCREMENT,
197  `tx_id` varchar(255) DEFAULT NULL,
198  `order_id` varchar(66) NOT NULL,
199  `user_id` int(255) NOT NULL,
200  `type` int(1) DEFAULT NULL,
201  `amount` decimal(10,2) NOT NULL,
202  `bitcoin_amount` int(255) DEFAULT NULL,
203  `date` varchar(66) NOT NULL,
204  `complete_date` varchar(66) DEFAULT NULL,
205  `ip_address` varchar(15) NOT NULL,
206  `step` int(1) NOT NULL DEFAULT '2',
207  `email` varchar(255) DEFAULT NULL,
208  `bitcoin_address` varchar(255) DEFAULT NULL,
209  `paypal_address` varchar(255) DEFAULT NULL,
210  `lat` varchar(66) DEFAULT NULL,
211  `lon` varchar(66) DEFAULT NULL,
212  `city` varchar(166) DEFAULT NULL,
213  `feedback` text,
214  `bank_id` int(22) DEFAULT NULL,
215  `status` int(1) NOT NULL DEFAULT '0',
216  `released` int(1) NOT NULL DEFAULT '0',
217  PRIMARY KEY (`id`)
218) ENGINE=InnoDB DEFAULT CHARSET=utf8;
219/*!40101 SET character_set_client = @saved_cs_client */;
220
221--
222-- Dumping data for table `payments`
223--
224
225LOCK TABLES `payments` WRITE;
226/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
227/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
228UNLOCK TABLES;
229
230--
231-- Table structure for table `settings`
232--
233
234DROP TABLE IF EXISTS `settings`;
235/*!40101 SET @saved_cs_client     = @@character_set_client */;
236/*!40101 SET character_set_client = utf8 */;
237CREATE TABLE `settings` (
238  `id` int(255) NOT NULL AUTO_INCREMENT,
239  `feature` varchar(166) NOT NULL,
240  `value` text NOT NULL,
241  PRIMARY KEY (`id`)
242) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
243/*!40101 SET character_set_client = @saved_cs_client */;
244
245--
246-- Dumping data for table `settings`
247--
248
249LOCK TABLES `settings` WRITE;
250/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
251INSERT INTO `settings` VALUES (1,'mailgun_domain','denizb16.com'),(2,'mailgun_key','key-3fbf4e1254de126d68ad93f023c3c3bc'),(3,'website_title','Viacoin.com'),(4,'website_keywords','put,your,keywords,here'),(5,'website_description','Put your website description here.'),(6,'stripe_test_key','sk_test_lRaYYvpFpJDzgK23PI8o2vgE'),(7,'stripe_live_key','sk_live_sWGz3dXa4AU5rJGxoB392nBM'),(8,'stripe_status','0'),(9,'block_test_key','b674-3f84-8f5d-948e'),(10,'block_live_key','7d6b-8ed3-8f9b-8a20'),(11,'block_status','1'),(12,'facebook','https://www.facebook.com/viacoin.cz'),(13,'twitter','https://www.twitter.com'),(14,'youtube','https://www.youtube.com'),(15,'google','https://www.google.com'),(16,'instagram','https://www.facebook.com'),(17,'card_commission','0'),(18,'bitcoin_commission','0'),(19,'email','info@viacoin.cz'),(20,'phone','+420773232329'),(21,'paypal_address','paypal@viacoin.cz'),(22,'bitcoin_commission_user','0'),(23,'maintenance_mode','1');
252/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
253UNLOCK TABLES;
254
255--
256-- Table structure for table `sliders`
257--
258
259DROP TABLE IF EXISTS `sliders`;
260/*!40101 SET @saved_cs_client     = @@character_set_client */;
261/*!40101 SET character_set_client = utf8 */;
262CREATE TABLE `sliders` (
263  `id` int(255) NOT NULL AUTO_INCREMENT,
264  `title` varchar(255) NOT NULL,
265  `description` text NOT NULL,
266  `content` text NOT NULL,
267  `image` varchar(255) NOT NULL,
268  PRIMARY KEY (`id`)
269) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
270/*!40101 SET character_set_client = @saved_cs_client */;
271
272--
273-- Dumping data for table `sliders`
274--
275
276LOCK TABLES `sliders` WRITE;
277/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
278INSERT INTO `sliders` VALUES (4,'Secured Data','Your data is safe','In viacoin, all datas are stored with ultra encryptions.  It means your all transactions and data are always secured!','7ec7d3c64922a5d21a7bd78fbf1fa61f.png'),(5,'Easy Steps','Buy/Sell Easily','You can buy or sell Bitcoins in viacoin easily, in a few minutes!','ed28688546d44085c362b398b40478a2.png'),(6,'Fast Transactions','Time is Money','You can buy or sell Bitcoins in viacoin just in a few minutes!','d39a99992ee128221a19bc7bc92ab4b7.png'),(7,'7/24 Support','We\'re Here to Help!','Our experienced support team is working 7/24 for you!','6c965b712ed14d9c7e18690a26708b32.png'),(8,'Best Prices','Best in the Market','Viacoin\'s main target is always providing best prices for customers!','798eacbcdf89f0b2fa2f0d1fead0794f.png');
279/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
280UNLOCK TABLES;
281
282--
283-- Table structure for table `support`
284--
285
286DROP TABLE IF EXISTS `support`;
287/*!40101 SET @saved_cs_client     = @@character_set_client */;
288/*!40101 SET character_set_client = utf8 */;
289CREATE TABLE `support` (
290  `id` int(255) NOT NULL AUTO_INCREMENT,
291  `title` varchar(255) NOT NULL,
292  `user_id` int(255) NOT NULL,
293  `last_reply_type` int(1) NOT NULL,
294  `last_reply_user` int(255) NOT NULL,
295  `last_reply_date` varchar(66) NOT NULL,
296  `status` int(1) NOT NULL DEFAULT '0',
297  PRIMARY KEY (`id`)
298) ENGINE=InnoDB DEFAULT CHARSET=utf8;
299/*!40101 SET character_set_client = @saved_cs_client */;
300
301--
302-- Dumping data for table `support`
303--
304
305LOCK TABLES `support` WRITE;
306/*!40000 ALTER TABLE `support` DISABLE KEYS */;
307/*!40000 ALTER TABLE `support` ENABLE KEYS */;
308UNLOCK TABLES;
309
310--
311-- Table structure for table `support_files`
312--
313
314DROP TABLE IF EXISTS `support_files`;
315/*!40101 SET @saved_cs_client     = @@character_set_client */;
316/*!40101 SET character_set_client = utf8 */;
317CREATE TABLE `support_files` (
318  `id` int(255) NOT NULL AUTO_INCREMENT,
319  `message_id` int(255) NOT NULL,
320  `file` varchar(255) NOT NULL,
321  PRIMARY KEY (`id`)
322) ENGINE=InnoDB DEFAULT CHARSET=utf8;
323/*!40101 SET character_set_client = @saved_cs_client */;
324
325--
326-- Dumping data for table `support_files`
327--
328
329LOCK TABLES `support_files` WRITE;
330/*!40000 ALTER TABLE `support_files` DISABLE KEYS */;
331/*!40000 ALTER TABLE `support_files` ENABLE KEYS */;
332UNLOCK TABLES;
333
334--
335-- Table structure for table `support_messages`
336--
337
338DROP TABLE IF EXISTS `support_messages`;
339/*!40101 SET @saved_cs_client     = @@character_set_client */;
340/*!40101 SET character_set_client = utf8 */;
341CREATE TABLE `support_messages` (
342  `id` int(255) NOT NULL AUTO_INCREMENT,
343  `ticket_id` int(255) NOT NULL,
344  `sender_type` int(1) NOT NULL,
345  `sender_id` int(255) NOT NULL,
346  `message` text NOT NULL,
347  `date` varchar(66) NOT NULL,
348  `files` int(1) NOT NULL DEFAULT '0',
349  PRIMARY KEY (`id`)
350) ENGINE=InnoDB DEFAULT CHARSET=utf8;
351/*!40101 SET character_set_client = @saved_cs_client */;
352
353--
354-- Dumping data for table `support_messages`
355--
356
357LOCK TABLES `support_messages` WRITE;
358/*!40000 ALTER TABLE `support_messages` DISABLE KEYS */;
359/*!40000 ALTER TABLE `support_messages` ENABLE KEYS */;
360UNLOCK TABLES;
361
362--
363-- Table structure for table `transactions`
364--
365
366DROP TABLE IF EXISTS `transactions`;
367/*!40101 SET @saved_cs_client     = @@character_set_client */;
368/*!40101 SET character_set_client = utf8 */;
369CREATE TABLE `transactions` (
370  `id` int(255) NOT NULL AUTO_INCREMENT,
371  `order_id` varchar(66) NOT NULL,
372  `user_id` int(255) NOT NULL,
373  `amount` decimal(10,2) NOT NULL,
374  `bitcoin_amount` int(255) DEFAULT NULL,
375  `date` varchar(66) NOT NULL,
376  `email` varchar(255) DEFAULT NULL,
377  `bitcoin_address` varchar(255) DEFAULT NULL,
378  `ip_address` varchar(15) DEFAULT NULL,
379  `feedback` text,
380  `status` int(1) NOT NULL DEFAULT '0',
381  `released` int(1) NOT NULL DEFAULT '0',
382  PRIMARY KEY (`id`)
383) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
384/*!40101 SET character_set_client = @saved_cs_client */;
385
386--
387-- Dumping data for table `transactions`
388--
389
390LOCK TABLES `transactions` WRITE;
391/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
392/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
393UNLOCK TABLES;
394
395--
396-- Table structure for table `users`
397--
398
399DROP TABLE IF EXISTS `users`;
400/*!40101 SET @saved_cs_client     = @@character_set_client */;
401/*!40101 SET character_set_client = utf8 */;
402CREATE TABLE `users` (
403  `id` int(255) NOT NULL AUTO_INCREMENT,
404  `username` varchar(166) NOT NULL,
405  `email` varchar(255) NOT NULL,
406  `password` varchar(166) NOT NULL,
407  `balance` decimal(10,2) NOT NULL,
408  `bitcoin` int(255) NOT NULL,
409  `register_date` varchar(66) NOT NULL,
410  `register_ip` varchar(15) NOT NULL,
411  `status` int(1) NOT NULL DEFAULT '1',
412  PRIMARY KEY (`id`)
413) ENGINE=InnoDB DEFAULT CHARSET=utf8;
414/*!40101 SET character_set_client = @saved_cs_client */;
415
416--
417-- Dumping data for table `users`
418--
419
420LOCK TABLES `users` WRITE;
421/*!40000 ALTER TABLE `users` DISABLE KEYS */;
422/*!40000 ALTER TABLE `users` ENABLE KEYS */;
423UNLOCK TABLES;
424
425--
426-- Table structure for table `withdrawals`
427--
428
429DROP TABLE IF EXISTS `withdrawals`;
430/*!40101 SET @saved_cs_client     = @@character_set_client */;
431/*!40101 SET character_set_client = utf8 */;
432CREATE TABLE `withdrawals` (
433  `id` int(255) NOT NULL AUTO_INCREMENT,
434  `user_id` int(255) NOT NULL,
435  `amount` decimal(10,2) NOT NULL,
436  `bitcoin_amount` int(255) NOT NULL,
437  `bitcoin_address` varchar(255) NOT NULL,
438  `date` varchar(66) NOT NULL,
439  `ip_address` varchar(15) NOT NULL,
440  `bank_name` varchar(255) NOT NULL,
441  `account_owner` varchar(255) NOT NULL,
442  `account_number` varchar(255) NOT NULL,
443  `iban` varchar(255) NOT NULL,
444  `lat` varchar(66) DEFAULT NULL,
445  `lon` varchar(66) DEFAULT NULL,
446  `city` varchar(255) DEFAULT NULL,
447  `paid` int(1) NOT NULL DEFAULT '0',
448  `status` int(1) NOT NULL DEFAULT '0',
449  PRIMARY KEY (`id`)
450) ENGINE=InnoDB DEFAULT CHARSET=utf8;
451/*!40101 SET character_set_client = @saved_cs_client */;
452
453--
454-- Dumping data for table `withdrawals`
455--
456
457LOCK TABLES `withdrawals` WRITE;
458/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
459/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
460UNLOCK TABLES;
461
462--
463-- Current Database: `viacoin_at`
464--
465
466CREATE DATABASE /*!32312 IF NOT EXISTS*/ `viacoin_at` /*!40100 DEFAULT CHARACTER SET utf8 */;
467
468USE `viacoin_at`;
469
470--
471-- Table structure for table `admin_types`
472--
473
474DROP TABLE IF EXISTS `admin_types`;
475/*!40101 SET @saved_cs_client     = @@character_set_client */;
476/*!40101 SET character_set_client = utf8 */;
477CREATE TABLE `admin_types` (
478  `id` int(255) NOT NULL AUTO_INCREMENT,
479  `name` varchar(166) NOT NULL,
480  `auth` text NOT NULL,
481  PRIMARY KEY (`id`)
482) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
483/*!40101 SET character_set_client = @saved_cs_client */;
484
485--
486-- Dumping data for table `admin_types`
487--
488
489LOCK TABLES `admin_types` WRITE;
490/*!40000 ALTER TABLE `admin_types` DISABLE KEYS */;
491INSERT INTO `admin_types` VALUES (1,'Admin','settings,faq,terms-of-service,privacy-policy,security,about-us,how-it-works,sliders,clients,transactions,payments,withdrawals,staff,manage,support,bank-accounts,logs'),(2,'Zkouška zaměstnanec','support,bank-accounts'),(3,'viacoin1','clients,transactions,payments,withdrawals,support');
492/*!40000 ALTER TABLE `admin_types` ENABLE KEYS */;
493UNLOCK TABLES;
494
495--
496-- Table structure for table `admins`
497--
498
499DROP TABLE IF EXISTS `admins`;
500/*!40101 SET @saved_cs_client     = @@character_set_client */;
501/*!40101 SET character_set_client = utf8 */;
502CREATE TABLE `admins` (
503  `id` int(255) NOT NULL AUTO_INCREMENT,
504  `username` varchar(66) NOT NULL,
505  `password` varchar(255) NOT NULL,
506  `email` varchar(166) NOT NULL,
507  `name` varchar(255) NOT NULL,
508  `auth` int(255) NOT NULL,
509  `google_auth` int(1) NOT NULL DEFAULT '0',
510  `google_opt` varchar(66) DEFAULT NULL,
511  `status` int(1) NOT NULL DEFAULT '1',
512  PRIMARY KEY (`id`),
513  KEY `auth` (`auth`)
514) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
515/*!40101 SET character_set_client = @saved_cs_client */;
516
517--
518-- Dumping data for table `admins`
519--
520
521LOCK TABLES `admins` WRITE;
522/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
523INSERT INTO `admins` VALUES (1,'admin','$2y$10$/58qJCCsLzsbIDRx/lwbb.JaWLUKlJ24v4wLFPsuK21Dusy8AsF5O','denizbirlik16@gmail.com','Deniz Birlik',1,2,'4AWRWNFURLFDNQLV',1),(2,'barbie','$2y$10$MH995zkU/X3ERRCZGXY4U.lX0iK0HXNazIU1CK5MBX1IeBhVcAf3.','rz8@email.cz','barbie',3,0,NULL,1);
524/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
525UNLOCK TABLES;
526
527--
528-- Table structure for table `bank_accounts`
529--
530
531DROP TABLE IF EXISTS `bank_accounts`;
532/*!40101 SET @saved_cs_client     = @@character_set_client */;
533/*!40101 SET character_set_client = utf8 */;
534CREATE TABLE `bank_accounts` (
535  `id` int(255) NOT NULL AUTO_INCREMENT,
536  `bank_name` varchar(255) NOT NULL,
537  `account_owner` varchar(255) NOT NULL,
538  `account_number` varchar(166) NOT NULL,
539  `iban` varchar(166) NOT NULL,
540  `logo` varchar(255) NOT NULL,
541  PRIMARY KEY (`id`)
542) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
543/*!40101 SET character_set_client = @saved_cs_client */;
544
545--
546-- Dumping data for table `bank_accounts`
547--
548
549LOCK TABLES `bank_accounts` WRITE;
550/*!40000 ALTER TABLE `bank_accounts` DISABLE KEYS */;
551INSERT INTO `bank_accounts` VALUES (1,'Garanti Bankası','Deniz Birlik','536-7774625','TR83 3823 8323 1239 8732 0000 0000 0233 01','4869a330ca41f4816aeed121ee42715e.jpg'),(2,'mBank','BreBank','670100-2205647536/6210','CZ37 6210 6701 0022 0564 7536','79714ed2cb3c0a0587888eca9bf93791.jpg'),(3,'Raiffeisen bank','Raiffeisen bank','78100909/5500','CZ37 6210 6701 0022 0564 7536 ','6b1c7f9fba55afdc4e43790181d0de53.jpg');
552/*!40000 ALTER TABLE `bank_accounts` ENABLE KEYS */;
553UNLOCK TABLES;
554
555--
556-- Table structure for table `content`
557--
558
559DROP TABLE IF EXISTS `content`;
560/*!40101 SET @saved_cs_client     = @@character_set_client */;
561/*!40101 SET character_set_client = utf8 */;
562CREATE TABLE `content` (
563  `id` int(255) NOT NULL AUTO_INCREMENT,
564  `feature` varchar(255) NOT NULL,
565  `value` text NOT NULL,
566  PRIMARY KEY (`id`)
567) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
568/*!40101 SET character_set_client = @saved_cs_client */;
569
570--
571-- Dumping data for table `content`
572--
573
574LOCK TABLES `content` WRITE;
575/*!40000 ALTER TABLE `content` DISABLE KEYS */;
576INSERT INTO `content` VALUES (1,'security','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut sed pellentesque sem, id placerat enim. Suspendisse pharetra hendrerit felis, ac scelerisque sem posuere et. Phasellus hendrerit est eu ligula posuere, non bibendum dui finibus. Nam odio urna, egestas id maximus in, tincidunt non odio. Nulla facilisi. Nullam cursus quis magna sit amet interdum. Donec iaculis bibendum accumsan.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Nullam vitae eros ex.&nbsp;</font></p>'),(2,'terms_of_service','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Suspendisse potenti. Duis vitae suscipit dui, non pulvinar mauris. Interdum et malesuada fames ac ante ipsum primis in faucibus. Suspendisse augue massa, convallis vitae scelerisque vitae, auctor eu erat. </font></span></p><p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Mauris venenatis dictum justo non ullamcorper. Quisque eu facilisis erat.</font></span></p>'),(3,'about_us','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Maecenas in felis mauris. Mauris dictum massa non pharetra lacinia. Vivamus ut libero orci. Maecenas vitae volutpat sem. Pellentesque ultrices tempus mi, id feugiat nunc interdum sit amet. </font></span></p><p><span style=\"font-family: Verdana; color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\">Vestibulum nec nulla et odio lacinia hendrerit nec nec ex. Praesent placerat nulla eget dolor lobortis commodo. Praesent laoreet felis ut purus dignissim mollis.</span><br></p>'),(4,'privacy_policy','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Mauris hendrerit, elit cursus auctor cursus, enim urna hendrerit eros, sit amet porta dui mauris posuere diam. Pellentesque tempor libero a est viverra faucibus. Vivamus laoreet vulputate nunc quis finibus. Nam dapibus, erat vel tincidunt vehicula, diam eros finibus dolor, quis ultricies massa neque sed purus. Nunc nec est erat. Praesent eget tincidunt eros. Sed gravida placerat ex, venenatis hendrerit tortor facilisis vitae. Mauris faucibus, sem id placerat condimentum, nisl velit sollicitudin urna, in ornare lectus purus in erat.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Sed euismod ultrices ex, et porttitor erat vulputate ac.</font></p>'),(5,'how_it_works','Put how it works content here.');
577/*!40000 ALTER TABLE `content` ENABLE KEYS */;
578UNLOCK TABLES;
579
580--
581-- Table structure for table `faq`
582--
583
584DROP TABLE IF EXISTS `faq`;
585/*!40101 SET @saved_cs_client     = @@character_set_client */;
586/*!40101 SET character_set_client = utf8 */;
587CREATE TABLE `faq` (
588  `id` int(255) NOT NULL AUTO_INCREMENT,
589  `question` text NOT NULL,
590  `answer` text NOT NULL,
591  PRIMARY KEY (`id`)
592) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
593/*!40101 SET character_set_client = @saved_cs_client */;
594
595--
596-- Dumping data for table `faq`
597--
598
599LOCK TABLES `faq` WRITE;
600/*!40000 ALTER TABLE `faq` DISABLE KEYS */;
601INSERT INTO `faq` VALUES (1,'Put your first question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(2,'Put your second question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(3,'Put your third question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(4,'Put your fourth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(5,'Put your fifth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. ');
602/*!40000 ALTER TABLE `faq` ENABLE KEYS */;
603UNLOCK TABLES;
604
605--
606-- Table structure for table `logs`
607--
608
609DROP TABLE IF EXISTS `logs`;
610/*!40101 SET @saved_cs_client     = @@character_set_client */;
611/*!40101 SET character_set_client = utf8 */;
612CREATE TABLE `logs` (
613  `id` int(255) NOT NULL AUTO_INCREMENT,
614  `user_id` int(255) NOT NULL,
615  `date` varchar(66) NOT NULL,
616  `ip_address` varchar(15) NOT NULL,
617  `action` varchar(255) NOT NULL,
618  PRIMARY KEY (`id`)
619) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
620/*!40101 SET character_set_client = @saved_cs_client */;
621
622--
623-- Dumping data for table `logs`
624--
625
626LOCK TABLES `logs` WRITE;
627/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
628INSERT INTO `logs` VALUES (1,1,'1487093245','178.41.76.146','Admin logged in. ID: 1'),(2,1,'1487093640','178.41.76.146','General settings updated.'),(3,1,'1487093754','178.41.76.146','General settings updated.'),(4,1,'1487185234','178.41.76.146','Admin logged in. ID: 1'),(5,1,'1487185251','178.41.76.146','General settings updated.'),(6,1,'1487185582','178.41.76.146','General settings updated.'),(7,1,'1487185785','178.41.76.146','General settings updated.'),(8,1,'1487186131','178.41.76.146','General settings updated.'),(9,1,'1487187245','178.41.76.146','General settings updated.'),(10,1,'1487187270','178.41.76.146','General settings updated.'),(11,1,'1491406916','212.20.72.202','Admin logged in. ID: 1'),(12,1,'1491406932','212.20.72.202','General settings updated.'),(13,1,'1491406987','212.20.72.202','General settings updated.'),(14,1,'1491407010','192.155.107.114','Admin logged in. ID: 1');
629/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
630UNLOCK TABLES;
631
632--
633-- Table structure for table `payments`
634--
635
636DROP TABLE IF EXISTS `payments`;
637/*!40101 SET @saved_cs_client     = @@character_set_client */;
638/*!40101 SET character_set_client = utf8 */;
639CREATE TABLE `payments` (
640  `id` int(255) NOT NULL AUTO_INCREMENT,
641  `tx_id` varchar(255) DEFAULT NULL,
642  `order_id` varchar(66) NOT NULL,
643  `user_id` int(255) NOT NULL,
644  `type` int(1) DEFAULT NULL,
645  `amount` decimal(10,2) NOT NULL,
646  `bitcoin_amount` int(255) DEFAULT NULL,
647  `date` varchar(66) NOT NULL,
648  `complete_date` varchar(66) DEFAULT NULL,
649  `ip_address` varchar(15) NOT NULL,
650  `step` int(1) NOT NULL DEFAULT '2',
651  `email` varchar(255) DEFAULT NULL,
652  `bitcoin_address` varchar(255) DEFAULT NULL,
653  `paypal_address` varchar(255) DEFAULT NULL,
654  `lat` varchar(66) DEFAULT NULL,
655  `lon` varchar(66) DEFAULT NULL,
656  `city` varchar(166) DEFAULT NULL,
657  `feedback` text,
658  `bank_id` int(22) DEFAULT NULL,
659  `status` int(1) NOT NULL DEFAULT '0',
660  `released` int(1) NOT NULL DEFAULT '0',
661  PRIMARY KEY (`id`)
662) ENGINE=InnoDB DEFAULT CHARSET=utf8;
663/*!40101 SET character_set_client = @saved_cs_client */;
664
665--
666-- Dumping data for table `payments`
667--
668
669LOCK TABLES `payments` WRITE;
670/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
671/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
672UNLOCK TABLES;
673
674--
675-- Table structure for table `settings`
676--
677
678DROP TABLE IF EXISTS `settings`;
679/*!40101 SET @saved_cs_client     = @@character_set_client */;
680/*!40101 SET character_set_client = utf8 */;
681CREATE TABLE `settings` (
682  `id` int(255) NOT NULL AUTO_INCREMENT,
683  `feature` varchar(166) NOT NULL,
684  `value` text NOT NULL,
685  PRIMARY KEY (`id`)
686) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
687/*!40101 SET character_set_client = @saved_cs_client */;
688
689--
690-- Dumping data for table `settings`
691--
692
693LOCK TABLES `settings` WRITE;
694/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
695INSERT INTO `settings` VALUES (1,'mailgun_domain','denizb16.com'),(2,'mailgun_key','key-3fbf4e1254de126d68ad93f023c3c3bc'),(3,'website_title','Viacoin.com'),(4,'website_keywords','put,your,keywords,here'),(5,'website_description','Put your website description here.'),(6,'stripe_test_key','sk_test_lRaYYvpFpJDzgK23PI8o2vgE'),(7,'stripe_live_key','sk_live_sWGz3dXa4AU5rJGxoB392nBM'),(8,'stripe_status','0'),(9,'block_test_key','b674-3f84-8f5d-948e'),(10,'block_live_key','7d6b-8ed3-8f9b-8a20'),(11,'block_status','1'),(12,'facebook','https://www.facebook.com/viacoin.cz'),(13,'twitter','https://www.twitter.com'),(14,'youtube','https://www.youtube.com'),(15,'google','https://www.google.com'),(16,'instagram','https://www.facebook.com'),(17,'card_commission','0'),(18,'bitcoin_commission','0'),(19,'email','info@viacoin.cz'),(20,'phone','+420773232329'),(21,'paypal_address','paypal@viacoin.cz'),(22,'bitcoin_commission_user','0'),(23,'maintenance_mode','1');
696/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
697UNLOCK TABLES;
698
699--
700-- Table structure for table `sliders`
701--
702
703DROP TABLE IF EXISTS `sliders`;
704/*!40101 SET @saved_cs_client     = @@character_set_client */;
705/*!40101 SET character_set_client = utf8 */;
706CREATE TABLE `sliders` (
707  `id` int(255) NOT NULL AUTO_INCREMENT,
708  `title` varchar(255) NOT NULL,
709  `description` text NOT NULL,
710  `content` text NOT NULL,
711  `image` varchar(255) NOT NULL,
712  PRIMARY KEY (`id`)
713) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
714/*!40101 SET character_set_client = @saved_cs_client */;
715
716--
717-- Dumping data for table `sliders`
718--
719
720LOCK TABLES `sliders` WRITE;
721/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
722INSERT INTO `sliders` VALUES (4,'Secured Data','Your data is safe','In viacoin, all datas are stored with ultra encryptions.  It means your all transactions and data are always secured!','7ec7d3c64922a5d21a7bd78fbf1fa61f.png'),(5,'Easy Steps','Buy/Sell Easily','You can buy or sell Bitcoins in viacoin easily, in a few minutes!','ed28688546d44085c362b398b40478a2.png'),(6,'Fast Transactions','Time is Money','You can buy or sell Bitcoins in viacoin just in a few minutes!','d39a99992ee128221a19bc7bc92ab4b7.png'),(7,'7/24 Support','We\'re Here to Help!','Our experienced support team is working 7/24 for you!','6c965b712ed14d9c7e18690a26708b32.png'),(8,'Best Prices','Best in the Market','Viacoin\'s main target is always providing best prices for customers!','798eacbcdf89f0b2fa2f0d1fead0794f.png');
723/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
724UNLOCK TABLES;
725
726--
727-- Table structure for table `support`
728--
729
730DROP TABLE IF EXISTS `support`;
731/*!40101 SET @saved_cs_client     = @@character_set_client */;
732/*!40101 SET character_set_client = utf8 */;
733CREATE TABLE `support` (
734  `id` int(255) NOT NULL AUTO_INCREMENT,
735  `title` varchar(255) NOT NULL,
736  `user_id` int(255) NOT NULL,
737  `last_reply_type` int(1) NOT NULL,
738  `last_reply_user` int(255) NOT NULL,
739  `last_reply_date` varchar(66) NOT NULL,
740  `status` int(1) NOT NULL DEFAULT '0',
741  PRIMARY KEY (`id`)
742) ENGINE=InnoDB DEFAULT CHARSET=utf8;
743/*!40101 SET character_set_client = @saved_cs_client */;
744
745--
746-- Dumping data for table `support`
747--
748
749LOCK TABLES `support` WRITE;
750/*!40000 ALTER TABLE `support` DISABLE KEYS */;
751/*!40000 ALTER TABLE `support` ENABLE KEYS */;
752UNLOCK TABLES;
753
754--
755-- Table structure for table `support_files`
756--
757
758DROP TABLE IF EXISTS `support_files`;
759/*!40101 SET @saved_cs_client     = @@character_set_client */;
760/*!40101 SET character_set_client = utf8 */;
761CREATE TABLE `support_files` (
762  `id` int(255) NOT NULL AUTO_INCREMENT,
763  `message_id` int(255) NOT NULL,
764  `file` varchar(255) NOT NULL,
765  PRIMARY KEY (`id`)
766) ENGINE=InnoDB DEFAULT CHARSET=utf8;
767/*!40101 SET character_set_client = @saved_cs_client */;
768
769--
770-- Dumping data for table `support_files`
771--
772
773LOCK TABLES `support_files` WRITE;
774/*!40000 ALTER TABLE `support_files` DISABLE KEYS */;
775/*!40000 ALTER TABLE `support_files` ENABLE KEYS */;
776UNLOCK TABLES;
777
778--
779-- Table structure for table `support_messages`
780--
781
782DROP TABLE IF EXISTS `support_messages`;
783/*!40101 SET @saved_cs_client     = @@character_set_client */;
784/*!40101 SET character_set_client = utf8 */;
785CREATE TABLE `support_messages` (
786  `id` int(255) NOT NULL AUTO_INCREMENT,
787  `ticket_id` int(255) NOT NULL,
788  `sender_type` int(1) NOT NULL,
789  `sender_id` int(255) NOT NULL,
790  `message` text NOT NULL,
791  `date` varchar(66) NOT NULL,
792  `files` int(1) NOT NULL DEFAULT '0',
793  PRIMARY KEY (`id`)
794) ENGINE=InnoDB DEFAULT CHARSET=utf8;
795/*!40101 SET character_set_client = @saved_cs_client */;
796
797--
798-- Dumping data for table `support_messages`
799--
800
801LOCK TABLES `support_messages` WRITE;
802/*!40000 ALTER TABLE `support_messages` DISABLE KEYS */;
803/*!40000 ALTER TABLE `support_messages` ENABLE KEYS */;
804UNLOCK TABLES;
805
806--
807-- Table structure for table `transactions`
808--
809
810DROP TABLE IF EXISTS `transactions`;
811/*!40101 SET @saved_cs_client     = @@character_set_client */;
812/*!40101 SET character_set_client = utf8 */;
813CREATE TABLE `transactions` (
814  `id` int(255) NOT NULL AUTO_INCREMENT,
815  `order_id` varchar(66) NOT NULL,
816  `user_id` int(255) NOT NULL,
817  `amount` decimal(10,2) NOT NULL,
818  `bitcoin_amount` int(255) DEFAULT NULL,
819  `date` varchar(66) NOT NULL,
820  `email` varchar(255) DEFAULT NULL,
821  `bitcoin_address` varchar(255) DEFAULT NULL,
822  `ip_address` varchar(15) DEFAULT NULL,
823  `feedback` text,
824  `status` int(1) NOT NULL DEFAULT '0',
825  `released` int(1) NOT NULL DEFAULT '0',
826  PRIMARY KEY (`id`)
827) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
828/*!40101 SET character_set_client = @saved_cs_client */;
829
830--
831-- Dumping data for table `transactions`
832--
833
834LOCK TABLES `transactions` WRITE;
835/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
836/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
837UNLOCK TABLES;
838
839--
840-- Table structure for table `users`
841--
842
843DROP TABLE IF EXISTS `users`;
844/*!40101 SET @saved_cs_client     = @@character_set_client */;
845/*!40101 SET character_set_client = utf8 */;
846CREATE TABLE `users` (
847  `id` int(255) NOT NULL AUTO_INCREMENT,
848  `username` varchar(166) NOT NULL,
849  `email` varchar(255) NOT NULL,
850  `password` varchar(166) NOT NULL,
851  `balance` decimal(10,2) NOT NULL,
852  `bitcoin` int(255) NOT NULL,
853  `register_date` varchar(66) NOT NULL,
854  `register_ip` varchar(15) NOT NULL,
855  `status` int(1) NOT NULL DEFAULT '1',
856  PRIMARY KEY (`id`)
857) ENGINE=InnoDB DEFAULT CHARSET=utf8;
858/*!40101 SET character_set_client = @saved_cs_client */;
859
860--
861-- Dumping data for table `users`
862--
863
864LOCK TABLES `users` WRITE;
865/*!40000 ALTER TABLE `users` DISABLE KEYS */;
866/*!40000 ALTER TABLE `users` ENABLE KEYS */;
867UNLOCK TABLES;
868
869--
870-- Table structure for table `withdrawals`
871--
872
873DROP TABLE IF EXISTS `withdrawals`;
874/*!40101 SET @saved_cs_client     = @@character_set_client */;
875/*!40101 SET character_set_client = utf8 */;
876CREATE TABLE `withdrawals` (
877  `id` int(255) NOT NULL AUTO_INCREMENT,
878  `user_id` int(255) NOT NULL,
879  `amount` decimal(10,2) NOT NULL,
880  `bitcoin_amount` int(255) NOT NULL,
881  `bitcoin_address` varchar(255) NOT NULL,
882  `date` varchar(66) NOT NULL,
883  `ip_address` varchar(15) NOT NULL,
884  `bank_name` varchar(255) NOT NULL,
885  `account_owner` varchar(255) NOT NULL,
886  `account_number` varchar(255) NOT NULL,
887  `iban` varchar(255) NOT NULL,
888  `lat` varchar(66) DEFAULT NULL,
889  `lon` varchar(66) DEFAULT NULL,
890  `city` varchar(255) DEFAULT NULL,
891  `paid` int(1) NOT NULL DEFAULT '0',
892  `status` int(1) NOT NULL DEFAULT '0',
893  PRIMARY KEY (`id`)
894) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
895/*!40101 SET character_set_client = @saved_cs_client */;
896
897--
898-- Dumping data for table `withdrawals`
899--
900
901LOCK TABLES `withdrawals` WRITE;
902/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
903INSERT INTO `withdrawals` VALUES (1,0,1000.00,104740558,'32fjy2PWaWCqaZbz2B1sgvF27qPmsBgKbh','1487093695','178.41.76.146','koloradois','afafaf','','sk8011000000002931053302',NULL,NULL,NULL,0,0);
904/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
905UNLOCK TABLES;
906
907--
908-- Current Database: `viacoin_cloud`
909--
910
911CREATE DATABASE /*!32312 IF NOT EXISTS*/ `viacoin_cloud` /*!40100 DEFAULT CHARACTER SET utf8 */;
912
913USE `viacoin_cloud`;
914
915--
916-- Table structure for table `admin_types`
917--
918
919DROP TABLE IF EXISTS `admin_types`;
920/*!40101 SET @saved_cs_client     = @@character_set_client */;
921/*!40101 SET character_set_client = utf8 */;
922CREATE TABLE `admin_types` (
923  `id` int(255) NOT NULL AUTO_INCREMENT,
924  `name` varchar(166) NOT NULL,
925  `auth` text NOT NULL,
926  PRIMARY KEY (`id`)
927) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
928/*!40101 SET character_set_client = @saved_cs_client */;
929
930--
931-- Dumping data for table `admin_types`
932--
933
934LOCK TABLES `admin_types` WRITE;
935/*!40000 ALTER TABLE `admin_types` DISABLE KEYS */;
936INSERT INTO `admin_types` VALUES (1,'Admin','settings,faq,terms-of-service,privacy-policy,security,about-us,how-it-works,sliders,clients,transactions,payments,withdrawals,staff,manage,support,bank-accounts,logs'),(2,'Zkouška zaměstnanec','support,bank-accounts'),(3,'viacoin1','clients,transactions,payments,withdrawals,support');
937/*!40000 ALTER TABLE `admin_types` ENABLE KEYS */;
938UNLOCK TABLES;
939
940--
941-- Table structure for table `admins`
942--
943
944DROP TABLE IF EXISTS `admins`;
945/*!40101 SET @saved_cs_client     = @@character_set_client */;
946/*!40101 SET character_set_client = utf8 */;
947CREATE TABLE `admins` (
948  `id` int(255) NOT NULL AUTO_INCREMENT,
949  `username` varchar(66) NOT NULL,
950  `password` varchar(255) NOT NULL,
951  `email` varchar(166) NOT NULL,
952  `name` varchar(255) NOT NULL,
953  `auth` int(255) NOT NULL,
954  `google_auth` int(1) NOT NULL DEFAULT '0',
955  `google_opt` varchar(66) DEFAULT NULL,
956  `status` int(1) NOT NULL DEFAULT '1',
957  PRIMARY KEY (`id`),
958  KEY `auth` (`auth`)
959) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
960/*!40101 SET character_set_client = @saved_cs_client */;
961
962--
963-- Dumping data for table `admins`
964--
965
966LOCK TABLES `admins` WRITE;
967/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
968INSERT INTO `admins` VALUES (1,'admin','$2y$10$/58qJCCsLzsbIDRx/lwbb.JaWLUKlJ24v4wLFPsuK21Dusy8AsF5O','denizbirlik16@gmail.com','Deniz Birlik',1,2,'4AWRWNFURLFDNQLV',1),(2,'barbie','$2y$10$MH995zkU/X3ERRCZGXY4U.lX0iK0HXNazIU1CK5MBX1IeBhVcAf3.','rz8@email.cz','barbie',3,0,NULL,1);
969/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
970UNLOCK TABLES;
971
972--
973-- Table structure for table `bank_accounts`
974--
975
976DROP TABLE IF EXISTS `bank_accounts`;
977/*!40101 SET @saved_cs_client     = @@character_set_client */;
978/*!40101 SET character_set_client = utf8 */;
979CREATE TABLE `bank_accounts` (
980  `id` int(255) NOT NULL AUTO_INCREMENT,
981  `bank_name` varchar(255) NOT NULL,
982  `account_owner` varchar(255) NOT NULL,
983  `account_number` varchar(166) NOT NULL,
984  `iban` varchar(166) NOT NULL,
985  `logo` varchar(255) NOT NULL,
986  PRIMARY KEY (`id`)
987) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
988/*!40101 SET character_set_client = @saved_cs_client */;
989
990--
991-- Dumping data for table `bank_accounts`
992--
993
994LOCK TABLES `bank_accounts` WRITE;
995/*!40000 ALTER TABLE `bank_accounts` DISABLE KEYS */;
996INSERT INTO `bank_accounts` VALUES (1,'Garanti Bankası','Deniz Birlik','536-7774625','TR83 3823 8323 1239 8732 0000 0000 0233 01','4869a330ca41f4816aeed121ee42715e.jpg'),(2,'mBank','BreBank','670100-2205647536/6210','CZ37 6210 6701 0022 0564 7536','79714ed2cb3c0a0587888eca9bf93791.jpg'),(3,'Raiffeisen bank','Raiffeisen bank','78100909/5500','CZ37 6210 6701 0022 0564 7536 ','6b1c7f9fba55afdc4e43790181d0de53.jpg');
997/*!40000 ALTER TABLE `bank_accounts` ENABLE KEYS */;
998UNLOCK TABLES;
999
1000--
1001-- Table structure for table `content`
1002--
1003
1004DROP TABLE IF EXISTS `content`;
1005/*!40101 SET @saved_cs_client     = @@character_set_client */;
1006/*!40101 SET character_set_client = utf8 */;
1007CREATE TABLE `content` (
1008  `id` int(255) NOT NULL AUTO_INCREMENT,
1009  `feature` varchar(255) NOT NULL,
1010  `value` text NOT NULL,
1011  PRIMARY KEY (`id`)
1012) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
1013/*!40101 SET character_set_client = @saved_cs_client */;
1014
1015--
1016-- Dumping data for table `content`
1017--
1018
1019LOCK TABLES `content` WRITE;
1020/*!40000 ALTER TABLE `content` DISABLE KEYS */;
1021INSERT INTO `content` VALUES (1,'security','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut sed pellentesque sem, id placerat enim. Suspendisse pharetra hendrerit felis, ac scelerisque sem posuere et. Phasellus hendrerit est eu ligula posuere, non bibendum dui finibus. Nam odio urna, egestas id maximus in, tincidunt non odio. Nulla facilisi. Nullam cursus quis magna sit amet interdum. Donec iaculis bibendum accumsan.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Nullam vitae eros ex.&nbsp;</font></p>'),(2,'terms_of_service','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Suspendisse potenti. Duis vitae suscipit dui, non pulvinar mauris. Interdum et malesuada fames ac ante ipsum primis in faucibus. Suspendisse augue massa, convallis vitae scelerisque vitae, auctor eu erat. </font></span></p><p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Mauris venenatis dictum justo non ullamcorper. Quisque eu facilisis erat.</font></span></p>'),(3,'about_us','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Maecenas in felis mauris. Mauris dictum massa non pharetra lacinia. Vivamus ut libero orci. Maecenas vitae volutpat sem. Pellentesque ultrices tempus mi, id feugiat nunc interdum sit amet. </font></span></p><p><span style=\"font-family: Verdana; color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\">Vestibulum nec nulla et odio lacinia hendrerit nec nec ex. Praesent placerat nulla eget dolor lobortis commodo. Praesent laoreet felis ut purus dignissim mollis.</span><br></p>'),(4,'privacy_policy','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Mauris hendrerit, elit cursus auctor cursus, enim urna hendrerit eros, sit amet porta dui mauris posuere diam. Pellentesque tempor libero a est viverra faucibus. Vivamus laoreet vulputate nunc quis finibus. Nam dapibus, erat vel tincidunt vehicula, diam eros finibus dolor, quis ultricies massa neque sed purus. Nunc nec est erat. Praesent eget tincidunt eros. Sed gravida placerat ex, venenatis hendrerit tortor facilisis vitae. Mauris faucibus, sem id placerat condimentum, nisl velit sollicitudin urna, in ornare lectus purus in erat.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Sed euismod ultrices ex, et porttitor erat vulputate ac.</font></p>'),(5,'how_it_works','Put how it works content here.');
1022/*!40000 ALTER TABLE `content` ENABLE KEYS */;
1023UNLOCK TABLES;
1024
1025--
1026-- Table structure for table `faq`
1027--
1028
1029DROP TABLE IF EXISTS `faq`;
1030/*!40101 SET @saved_cs_client     = @@character_set_client */;
1031/*!40101 SET character_set_client = utf8 */;
1032CREATE TABLE `faq` (
1033  `id` int(255) NOT NULL AUTO_INCREMENT,
1034  `question` text NOT NULL,
1035  `answer` text NOT NULL,
1036  PRIMARY KEY (`id`)
1037) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
1038/*!40101 SET character_set_client = @saved_cs_client */;
1039
1040--
1041-- Dumping data for table `faq`
1042--
1043
1044LOCK TABLES `faq` WRITE;
1045/*!40000 ALTER TABLE `faq` DISABLE KEYS */;
1046INSERT INTO `faq` VALUES (1,'Put your first question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(2,'Put your second question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(3,'Put your third question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(4,'Put your fourth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(5,'Put your fifth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. ');
1047/*!40000 ALTER TABLE `faq` ENABLE KEYS */;
1048UNLOCK TABLES;
1049
1050--
1051-- Table structure for table `logs`
1052--
1053
1054DROP TABLE IF EXISTS `logs`;
1055/*!40101 SET @saved_cs_client     = @@character_set_client */;
1056/*!40101 SET character_set_client = utf8 */;
1057CREATE TABLE `logs` (
1058  `id` int(255) NOT NULL AUTO_INCREMENT,
1059  `user_id` int(255) NOT NULL,
1060  `date` varchar(66) NOT NULL,
1061  `ip_address` varchar(15) NOT NULL,
1062  `action` varchar(255) NOT NULL,
1063  PRIMARY KEY (`id`)
1064) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1065/*!40101 SET character_set_client = @saved_cs_client */;
1066
1067--
1068-- Dumping data for table `logs`
1069--
1070
1071LOCK TABLES `logs` WRITE;
1072/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
1073/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
1074UNLOCK TABLES;
1075
1076--
1077-- Table structure for table `payments`
1078--
1079
1080DROP TABLE IF EXISTS `payments`;
1081/*!40101 SET @saved_cs_client     = @@character_set_client */;
1082/*!40101 SET character_set_client = utf8 */;
1083CREATE TABLE `payments` (
1084  `id` int(255) NOT NULL AUTO_INCREMENT,
1085  `tx_id` varchar(255) DEFAULT NULL,
1086  `order_id` varchar(66) NOT NULL,
1087  `user_id` int(255) NOT NULL,
1088  `type` int(1) DEFAULT NULL,
1089  `amount` decimal(10,2) NOT NULL,
1090  `bitcoin_amount` int(255) DEFAULT NULL,
1091  `date` varchar(66) NOT NULL,
1092  `complete_date` varchar(66) DEFAULT NULL,
1093  `ip_address` varchar(15) NOT NULL,
1094  `step` int(1) NOT NULL DEFAULT '2',
1095  `email` varchar(255) DEFAULT NULL,
1096  `bitcoin_address` varchar(255) DEFAULT NULL,
1097  `paypal_address` varchar(255) DEFAULT NULL,
1098  `lat` varchar(66) DEFAULT NULL,
1099  `lon` varchar(66) DEFAULT NULL,
1100  `city` varchar(166) DEFAULT NULL,
1101  `feedback` text,
1102  `bank_id` int(22) DEFAULT NULL,
1103  `status` int(1) NOT NULL DEFAULT '0',
1104  `released` int(1) NOT NULL DEFAULT '0',
1105  PRIMARY KEY (`id`)
1106) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1107/*!40101 SET character_set_client = @saved_cs_client */;
1108
1109--
1110-- Dumping data for table `payments`
1111--
1112
1113LOCK TABLES `payments` WRITE;
1114/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
1115/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
1116UNLOCK TABLES;
1117
1118--
1119-- Table structure for table `settings`
1120--
1121
1122DROP TABLE IF EXISTS `settings`;
1123/*!40101 SET @saved_cs_client     = @@character_set_client */;
1124/*!40101 SET character_set_client = utf8 */;
1125CREATE TABLE `settings` (
1126  `id` int(255) NOT NULL AUTO_INCREMENT,
1127  `feature` varchar(166) NOT NULL,
1128  `value` text NOT NULL,
1129  PRIMARY KEY (`id`)
1130) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
1131/*!40101 SET character_set_client = @saved_cs_client */;
1132
1133--
1134-- Dumping data for table `settings`
1135--
1136
1137LOCK TABLES `settings` WRITE;
1138/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
1139INSERT INTO `settings` VALUES (1,'mailgun_domain','denizb16.com'),(2,'mailgun_key','key-3fbf4e1254de126d68ad93f023c3c3bc'),(3,'website_title','Viacoin.com'),(4,'website_keywords','put,your,keywords,here'),(5,'website_description','Put your website description here.'),(6,'stripe_test_key','sk_test_lRaYYvpFpJDzgK23PI8o2vgE'),(7,'stripe_live_key','sk_live_sWGz3dXa4AU5rJGxoB392nBM'),(8,'stripe_status','0'),(9,'block_test_key','b674-3f84-8f5d-948e'),(10,'block_live_key','7d6b-8ed3-8f9b-8a20'),(11,'block_status','1'),(12,'facebook','https://www.facebook.com/viacoin.cz'),(13,'twitter','https://www.twitter.com'),(14,'youtube','https://www.youtube.com'),(15,'google','https://www.google.com'),(16,'instagram','https://www.facebook.com'),(17,'card_commission','0'),(18,'bitcoin_commission','0'),(19,'email','info@viacoin.cz'),(20,'phone','+420773232329'),(21,'paypal_address','paypal@viacoin.cz'),(22,'bitcoin_commission_user','0'),(23,'maintenance_mode','1');
1140/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
1141UNLOCK TABLES;
1142
1143--
1144-- Table structure for table `sliders`
1145--
1146
1147DROP TABLE IF EXISTS `sliders`;
1148/*!40101 SET @saved_cs_client     = @@character_set_client */;
1149/*!40101 SET character_set_client = utf8 */;
1150CREATE TABLE `sliders` (
1151  `id` int(255) NOT NULL AUTO_INCREMENT,
1152  `title` varchar(255) NOT NULL,
1153  `description` text NOT NULL,
1154  `content` text NOT NULL,
1155  `image` varchar(255) NOT NULL,
1156  PRIMARY KEY (`id`)
1157) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
1158/*!40101 SET character_set_client = @saved_cs_client */;
1159
1160--
1161-- Dumping data for table `sliders`
1162--
1163
1164LOCK TABLES `sliders` WRITE;
1165/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
1166INSERT INTO `sliders` VALUES (4,'Secured Data','Your data is safe','In viacoin, all datas are stored with ultra encryptions.  It means your all transactions and data are always secured!','7ec7d3c64922a5d21a7bd78fbf1fa61f.png'),(5,'Easy Steps','Buy/Sell Easily','You can buy or sell Bitcoins in viacoin easily, in a few minutes!','ed28688546d44085c362b398b40478a2.png'),(6,'Fast Transactions','Time is Money','You can buy or sell Bitcoins in viacoin just in a few minutes!','d39a99992ee128221a19bc7bc92ab4b7.png'),(7,'7/24 Support','We\'re Here to Help!','Our experienced support team is working 7/24 for you!','6c965b712ed14d9c7e18690a26708b32.png'),(8,'Best Prices','Best in the Market','Viacoin\'s main target is always providing best prices for customers!','798eacbcdf89f0b2fa2f0d1fead0794f.png');
1167/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
1168UNLOCK TABLES;
1169
1170--
1171-- Table structure for table `support`
1172--
1173
1174DROP TABLE IF EXISTS `support`;
1175/*!40101 SET @saved_cs_client     = @@character_set_client */;
1176/*!40101 SET character_set_client = utf8 */;
1177CREATE TABLE `support` (
1178  `id` int(255) NOT NULL AUTO_INCREMENT,
1179  `title` varchar(255) NOT NULL,
1180  `user_id` int(255) NOT NULL,
1181  `last_reply_type` int(1) NOT NULL,
1182  `last_reply_user` int(255) NOT NULL,
1183  `last_reply_date` varchar(66) NOT NULL,
1184  `status` int(1) NOT NULL DEFAULT '0',
1185  PRIMARY KEY (`id`)
1186) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1187/*!40101 SET character_set_client = @saved_cs_client */;
1188
1189--
1190-- Dumping data for table `support`
1191--
1192
1193LOCK TABLES `support` WRITE;
1194/*!40000 ALTER TABLE `support` DISABLE KEYS */;
1195/*!40000 ALTER TABLE `support` ENABLE KEYS */;
1196UNLOCK TABLES;
1197
1198--
1199-- Table structure for table `support_files`
1200--
1201
1202DROP TABLE IF EXISTS `support_files`;
1203/*!40101 SET @saved_cs_client     = @@character_set_client */;
1204/*!40101 SET character_set_client = utf8 */;
1205CREATE TABLE `support_files` (
1206  `id` int(255) NOT NULL AUTO_INCREMENT,
1207  `message_id` int(255) NOT NULL,
1208  `file` varchar(255) NOT NULL,
1209  PRIMARY KEY (`id`)
1210) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1211/*!40101 SET character_set_client = @saved_cs_client */;
1212
1213--
1214-- Dumping data for table `support_files`
1215--
1216
1217LOCK TABLES `support_files` WRITE;
1218/*!40000 ALTER TABLE `support_files` DISABLE KEYS */;
1219/*!40000 ALTER TABLE `support_files` ENABLE KEYS */;
1220UNLOCK TABLES;
1221
1222--
1223-- Table structure for table `support_messages`
1224--
1225
1226DROP TABLE IF EXISTS `support_messages`;
1227/*!40101 SET @saved_cs_client     = @@character_set_client */;
1228/*!40101 SET character_set_client = utf8 */;
1229CREATE TABLE `support_messages` (
1230  `id` int(255) NOT NULL AUTO_INCREMENT,
1231  `ticket_id` int(255) NOT NULL,
1232  `sender_type` int(1) NOT NULL,
1233  `sender_id` int(255) NOT NULL,
1234  `message` text NOT NULL,
1235  `date` varchar(66) NOT NULL,
1236  `files` int(1) NOT NULL DEFAULT '0',
1237  PRIMARY KEY (`id`)
1238) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1239/*!40101 SET character_set_client = @saved_cs_client */;
1240
1241--
1242-- Dumping data for table `support_messages`
1243--
1244
1245LOCK TABLES `support_messages` WRITE;
1246/*!40000 ALTER TABLE `support_messages` DISABLE KEYS */;
1247/*!40000 ALTER TABLE `support_messages` ENABLE KEYS */;
1248UNLOCK TABLES;
1249
1250--
1251-- Table structure for table `transactions`
1252--
1253
1254DROP TABLE IF EXISTS `transactions`;
1255/*!40101 SET @saved_cs_client     = @@character_set_client */;
1256/*!40101 SET character_set_client = utf8 */;
1257CREATE TABLE `transactions` (
1258  `id` int(255) NOT NULL AUTO_INCREMENT,
1259  `order_id` varchar(66) NOT NULL,
1260  `user_id` int(255) NOT NULL,
1261  `amount` decimal(10,2) NOT NULL,
1262  `bitcoin_amount` int(255) DEFAULT NULL,
1263  `date` varchar(66) NOT NULL,
1264  `email` varchar(255) DEFAULT NULL,
1265  `bitcoin_address` varchar(255) DEFAULT NULL,
1266  `ip_address` varchar(15) DEFAULT NULL,
1267  `feedback` text,
1268  `status` int(1) NOT NULL DEFAULT '0',
1269  `released` int(1) NOT NULL DEFAULT '0',
1270  PRIMARY KEY (`id`)
1271) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1272/*!40101 SET character_set_client = @saved_cs_client */;
1273
1274--
1275-- Dumping data for table `transactions`
1276--
1277
1278LOCK TABLES `transactions` WRITE;
1279/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
1280/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
1281UNLOCK TABLES;
1282
1283--
1284-- Table structure for table `users`
1285--
1286
1287DROP TABLE IF EXISTS `users`;
1288/*!40101 SET @saved_cs_client     = @@character_set_client */;
1289/*!40101 SET character_set_client = utf8 */;
1290CREATE TABLE `users` (
1291  `id` int(255) NOT NULL AUTO_INCREMENT,
1292  `username` varchar(166) NOT NULL,
1293  `email` varchar(255) NOT NULL,
1294  `password` varchar(166) NOT NULL,
1295  `balance` decimal(10,2) NOT NULL,
1296  `bitcoin` int(255) NOT NULL,
1297  `register_date` varchar(66) NOT NULL,
1298  `register_ip` varchar(15) NOT NULL,
1299  `status` int(1) NOT NULL DEFAULT '1',
1300  PRIMARY KEY (`id`)
1301) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1302/*!40101 SET character_set_client = @saved_cs_client */;
1303
1304--
1305-- Dumping data for table `users`
1306--
1307
1308LOCK TABLES `users` WRITE;
1309/*!40000 ALTER TABLE `users` DISABLE KEYS */;
1310/*!40000 ALTER TABLE `users` ENABLE KEYS */;
1311UNLOCK TABLES;
1312
1313--
1314-- Table structure for table `withdrawals`
1315--
1316
1317DROP TABLE IF EXISTS `withdrawals`;
1318/*!40101 SET @saved_cs_client     = @@character_set_client */;
1319/*!40101 SET character_set_client = utf8 */;
1320CREATE TABLE `withdrawals` (
1321  `id` int(255) NOT NULL AUTO_INCREMENT,
1322  `user_id` int(255) NOT NULL,
1323  `amount` decimal(10,2) NOT NULL,
1324  `bitcoin_amount` int(255) NOT NULL,
1325  `bitcoin_address` varchar(255) NOT NULL,
1326  `date` varchar(66) NOT NULL,
1327  `ip_address` varchar(15) NOT NULL,
1328  `bank_name` varchar(255) NOT NULL,
1329  `account_owner` varchar(255) NOT NULL,
1330  `account_number` varchar(255) NOT NULL,
1331  `iban` varchar(255) NOT NULL,
1332  `lat` varchar(66) DEFAULT NULL,
1333  `lon` varchar(66) DEFAULT NULL,
1334  `city` varchar(255) DEFAULT NULL,
1335  `paid` int(1) NOT NULL DEFAULT '0',
1336  `status` int(1) NOT NULL DEFAULT '0',
1337  PRIMARY KEY (`id`)
1338) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1339/*!40101 SET character_set_client = @saved_cs_client */;
1340
1341--
1342-- Dumping data for table `withdrawals`
1343--
1344
1345LOCK TABLES `withdrawals` WRITE;
1346/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
1347/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
1348UNLOCK TABLES;
1349
1350--
1351-- Current Database: `viacoin_czk`
1352--
1353
1354CREATE DATABASE /*!32312 IF NOT EXISTS*/ `viacoin_czk` /*!40100 DEFAULT CHARACTER SET utf8 */;
1355
1356USE `viacoin_czk`;
1357
1358--
1359-- Table structure for table `admin_types`
1360--
1361
1362DROP TABLE IF EXISTS `admin_types`;
1363/*!40101 SET @saved_cs_client     = @@character_set_client */;
1364/*!40101 SET character_set_client = utf8 */;
1365CREATE TABLE `admin_types` (
1366  `id` int(255) NOT NULL AUTO_INCREMENT,
1367  `name` varchar(166) NOT NULL,
1368  `auth` text NOT NULL,
1369  PRIMARY KEY (`id`)
1370) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1371/*!40101 SET character_set_client = @saved_cs_client */;
1372
1373--
1374-- Dumping data for table `admin_types`
1375--
1376
1377LOCK TABLES `admin_types` WRITE;
1378/*!40000 ALTER TABLE `admin_types` DISABLE KEYS */;
1379INSERT INTO `admin_types` VALUES (1,'Admin','settings,faq,terms-of-service,privacy-policy,security,about-us,how-it-works,sliders,clients,transactions,payments,withdrawals,staff,manage,support,bank-accounts,logs'),(2,'Zamestnanec','clients,transactions,payments,withdrawals,support');
1380/*!40000 ALTER TABLE `admin_types` ENABLE KEYS */;
1381UNLOCK TABLES;
1382
1383--
1384-- Table structure for table `admins`
1385--
1386
1387DROP TABLE IF EXISTS `admins`;
1388/*!40101 SET @saved_cs_client     = @@character_set_client */;
1389/*!40101 SET character_set_client = utf8 */;
1390CREATE TABLE `admins` (
1391  `id` int(255) NOT NULL AUTO_INCREMENT,
1392  `username` varchar(66) NOT NULL,
1393  `password` varchar(255) NOT NULL,
1394  `email` varchar(166) NOT NULL,
1395  `name` varchar(255) NOT NULL,
1396  `auth` int(255) NOT NULL,
1397  `google_auth` int(1) NOT NULL DEFAULT '0',
1398  `google_opt` varchar(66) DEFAULT NULL,
1399  `status` int(1) NOT NULL DEFAULT '1',
1400  PRIMARY KEY (`id`),
1401  KEY `auth` (`auth`)
1402) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
1403/*!40101 SET character_set_client = @saved_cs_client */;
1404
1405--
1406-- Dumping data for table `admins`
1407--
1408
1409LOCK TABLES `admins` WRITE;
1410/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
1411INSERT INTO `admins` VALUES (1,'admin','$2y$10$./AtyPyQWDc.3/ndQEaVg.sGhxjflqvxsaeL6iNZ5jEKFWY2GGwmW','info@viacoin.cz','Deniz Birlik',1,2,'4AWRWNFURLFDNQLV',1),(6,'test_staff','$2y$10$nYa..DLCXkQPUW40IYpJOOSNAxY7sc3kmehg2nwxV8C3Jz1vExBLq','17kirill71@mail.ru','test_staff',1,0,NULL,1),(7,'donnsiegel','','jan.pecina@centrum.cz','Bufi',1,0,NULL,1),(8,'viacoincz','$2y$10$7Dh2eiw7.kbtpvEJtL6k2OplgZ7fs26p56d0CXCjHt.KdUF8fTAAS','rz8@email.cz','Slovakia ',2,0,NULL,1);
1412/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
1413UNLOCK TABLES;
1414
1415--
1416-- Table structure for table `bank_accounts`
1417--
1418
1419DROP TABLE IF EXISTS `bank_accounts`;
1420/*!40101 SET @saved_cs_client     = @@character_set_client */;
1421/*!40101 SET character_set_client = utf8 */;
1422CREATE TABLE `bank_accounts` (
1423  `id` int(255) NOT NULL AUTO_INCREMENT,
1424  `bank_name` varchar(255) NOT NULL,
1425  `account_owner` varchar(255) NOT NULL,
1426  `account_number` varchar(166) NOT NULL,
1427  `iban` varchar(166) NOT NULL,
1428  `logo` varchar(255) NOT NULL,
1429  PRIMARY KEY (`id`)
1430) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
1431/*!40101 SET character_set_client = @saved_cs_client */;
1432
1433--
1434-- Dumping data for table `bank_accounts`
1435--
1436
1437LOCK TABLES `bank_accounts` WRITE;
1438/*!40000 ALTER TABLE `bank_accounts` DISABLE KEYS */;
1439INSERT INTO `bank_accounts` VALUES (1,'Garanti Bankası','Deniz Birlik','536-7774625','TR83 3823 8323 1239 8732 0000 0000 0233 01','4869a330ca41f4816aeed121ee42715e.jpg'),(2,'mBank','BreBank','670100-2205647536/6210','CZ37 6210 6701 0022 0564 7536','79714ed2cb3c0a0587888eca9bf93791.jpg'),(3,'Raiffeisen bank','Raiffeisen bank','78100909/5500','CZ37 6210 6701 0022 0564 7536 ','6b1c7f9fba55afdc4e43790181d0de53.jpg'),(4,'test','test owner','2323123141234/1100','SKLB299992002020020200202020','16c93add237dc386897082bdf9b0aab6.jpg');
1440/*!40000 ALTER TABLE `bank_accounts` ENABLE KEYS */;
1441UNLOCK TABLES;
1442
1443--
1444-- Table structure for table `content`
1445--
1446
1447DROP TABLE IF EXISTS `content`;
1448/*!40101 SET @saved_cs_client     = @@character_set_client */;
1449/*!40101 SET character_set_client = utf8 */;
1450CREATE TABLE `content` (
1451  `id` int(255) NOT NULL AUTO_INCREMENT,
1452  `feature` varchar(255) NOT NULL,
1453  `value` text NOT NULL,
1454  PRIMARY KEY (`id`)
1455) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
1456/*!40101 SET character_set_client = @saved_cs_client */;
1457
1458--
1459-- Dumping data for table `content`
1460--
1461
1462LOCK TABLES `content` WRITE;
1463/*!40000 ALTER TABLE `content` DISABLE KEYS */;
1464INSERT INTO `content` VALUES (1,'security','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut sed pellentesque sem, id placerat enim. Suspendisse pharetra hendrerit felis, ac scelerisque sem posuere et. Phasellus hendrerit est eu ligula posuere, non bibendum dui finibus. Nam odio urna, egestas id maximus in, tincidunt non odio. Nulla facilisi. Nullam cursus quis magna sit amet interdum. Donec iaculis bibendum accumsan.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Nullam vitae eros ex.&nbsp;</font></p>'),(2,'terms_of_service','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Suspendisse potenti. Duis vitae suscipit dui, non pulvinar mauris. Interdum et malesuada fames ac ante ipsum primis in faucibus. Suspendisse augue massa, convallis vitae scelerisque vitae, auctor eu erat. </font></span></p><p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Mauris venenatis dictum justo non ullamcorper. Quisque eu facilisis erat.</font></span></p>'),(3,'about_us','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Maecenas in felis mauris. Mauris dictum massa non pharetra lacinia. Vivamus ut libero orci. Maecenas vitae volutpat sem. Pellentesque ultrices tempus mi, id feugiat nunc interdum sit amet. </font></span></p><p><span style=\"font-family: Verdana; color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\">Vestibulum nec nulla et odio lacinia hendrerit nec nec ex. Praesent placerat nulla eget dolor lobortis commodo. Praesent laoreet felis ut purus dignissim mollis.</span><br></p>'),(4,'privacy_policy','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Mauris hendrerit, elit cursus auctor cursus, enim urna hendrerit eros, sit amet porta dui mauris posuere diam. Pellentesque tempor libero a est viverra faucibus. Vivamus laoreet vulputate nunc quis finibus. Nam dapibus, erat vel tincidunt vehicula, diam eros finibus dolor, quis ultricies massa neque sed purus. Nunc nec est erat. Praesent eget tincidunt eros. Sed gravida placerat ex, venenatis hendrerit tortor facilisis vitae. Mauris faucibus, sem id placerat condimentum, nisl velit sollicitudin urna, in ornare lectus purus in erat.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Sed euismod ultrices ex, et porttitor erat vulputate ac.</font></p>'),(5,'how_it_works','Put how it works content here.');
1465/*!40000 ALTER TABLE `content` ENABLE KEYS */;
1466UNLOCK TABLES;
1467
1468--
1469-- Table structure for table `faq`
1470--
1471
1472DROP TABLE IF EXISTS `faq`;
1473/*!40101 SET @saved_cs_client     = @@character_set_client */;
1474/*!40101 SET character_set_client = utf8 */;
1475CREATE TABLE `faq` (
1476  `id` int(255) NOT NULL AUTO_INCREMENT,
1477  `question` text NOT NULL,
1478  `answer` text NOT NULL,
1479  PRIMARY KEY (`id`)
1480) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
1481/*!40101 SET character_set_client = @saved_cs_client */;
1482
1483--
1484-- Dumping data for table `faq`
1485--
1486
1487LOCK TABLES `faq` WRITE;
1488/*!40000 ALTER TABLE `faq` DISABLE KEYS */;
1489INSERT INTO `faq` VALUES (1,'Put your first question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(2,'Put your second question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(3,'Put your third question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(4,'Put your fourth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(5,'Put your fifth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. ');
1490/*!40000 ALTER TABLE `faq` ENABLE KEYS */;
1491UNLOCK TABLES;
1492
1493--
1494-- Table structure for table `feedbacks`
1495--
1496
1497DROP TABLE IF EXISTS `feedbacks`;
1498/*!40101 SET @saved_cs_client     = @@character_set_client */;
1499/*!40101 SET character_set_client = utf8 */;
1500CREATE TABLE `feedbacks` (
1501  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1502  `feedback` text,
1503  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1504  PRIMARY KEY (`id`)
1505) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
1506/*!40101 SET character_set_client = @saved_cs_client */;
1507
1508--
1509-- Dumping data for table `feedbacks`
1510--
1511
1512LOCK TABLES `feedbacks` WRITE;
1513/*!40000 ALTER TABLE `feedbacks` DISABLE KEYS */;
1514/*!40000 ALTER TABLE `feedbacks` ENABLE KEYS */;
1515UNLOCK TABLES;
1516
1517--
1518-- Table structure for table `logs`
1519--
1520
1521DROP TABLE IF EXISTS `logs`;
1522/*!40101 SET @saved_cs_client     = @@character_set_client */;
1523/*!40101 SET character_set_client = utf8 */;
1524CREATE TABLE `logs` (
1525  `id` int(255) NOT NULL AUTO_INCREMENT,
1526  `user_id` int(255) NOT NULL,
1527  `date` varchar(66) NOT NULL,
1528  `ip_address` varchar(15) NOT NULL,
1529  `action` varchar(255) NOT NULL,
1530  PRIMARY KEY (`id`)
1531) ENGINE=InnoDB AUTO_INCREMENT=537 DEFAULT CHARSET=utf8;
1532/*!40101 SET character_set_client = @saved_cs_client */;
1533
1534--
1535-- Dumping data for table `logs`
1536--
1537
1538LOCK TABLES `logs` WRITE;
1539/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
1540/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
1541UNLOCK TABLES;
1542
1543--
1544-- Table structure for table `payments`
1545--
1546
1547DROP TABLE IF EXISTS `payments`;
1548/*!40101 SET @saved_cs_client     = @@character_set_client */;
1549/*!40101 SET character_set_client = utf8 */;
1550CREATE TABLE `payments` (
1551  `id` int(255) NOT NULL AUTO_INCREMENT,
1552  `tx_id` varchar(255) DEFAULT NULL,
1553  `order_id` varchar(66) NOT NULL,
1554  `user_id` int(255) NOT NULL,
1555  `type` int(1) DEFAULT NULL,
1556  `text_note` text,
1557  `amount` decimal(10,2) NOT NULL,
1558  `bitcoin_amount` int(255) DEFAULT NULL,
1559  `date` varchar(66) NOT NULL,
1560  `complete_date` varchar(66) DEFAULT NULL,
1561  `ip_address` varchar(15) NOT NULL,
1562  `step` int(1) NOT NULL DEFAULT '2',
1563  `email` varchar(255) DEFAULT NULL,
1564  `bitcoin_address` varchar(255) DEFAULT NULL,
1565  `paypal_address` varchar(255) DEFAULT NULL,
1566  `lat` varchar(66) DEFAULT NULL,
1567  `lon` varchar(66) DEFAULT NULL,
1568  `city` varchar(166) DEFAULT NULL,
1569  `feedback` text,
1570  `bank_id` int(22) DEFAULT NULL,
1571  `status` int(1) NOT NULL DEFAULT '0',
1572  `released` int(1) NOT NULL DEFAULT '0',
1573  PRIMARY KEY (`id`)
1574) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
1575/*!40101 SET character_set_client = @saved_cs_client */;
1576
1577--
1578-- Dumping data for table `payments`
1579--
1580
1581LOCK TABLES `payments` WRITE;
1582/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
1583/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
1584UNLOCK TABLES;
1585
1586--
1587-- Table structure for table `settings`
1588--
1589
1590DROP TABLE IF EXISTS `settings`;
1591/*!40101 SET @saved_cs_client     = @@character_set_client */;
1592/*!40101 SET character_set_client = utf8 */;
1593CREATE TABLE `settings` (
1594  `id` int(255) NOT NULL AUTO_INCREMENT,
1595  `feature` varchar(166) NOT NULL,
1596  `value` text NOT NULL,
1597  PRIMARY KEY (`id`)
1598) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
1599/*!40101 SET character_set_client = @saved_cs_client */;
1600
1601--
1602-- Dumping data for table `settings`
1603--
1604
1605LOCK TABLES `settings` WRITE;
1606/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
1607INSERT INTO `settings` VALUES (1,'mailgun_domain','denizb16.com'),(2,'mailgun_key','key-3fbf4e1254de126d68ad93f023c3c3bc'),(3,'website_title','Viacoin.com'),(4,'website_keywords','bitcoin, smenarna, nejlevnejši, bitcoiny'),(5,'website_description','Put your website description here.'),(6,'stripe_test_key','sk_test_lRaYYvpFpJDzgK23PI8o2vgE'),(7,'stripe_live_key','sk_live_sWGz3dXa4AU5rJGxoB392nBM'),(8,'stripe_status','0'),(9,'block_test_key','b674-3f84-8f5d-948e'),(10,'block_live_key','7d6b-8ed3-8f9b-8a20'),(11,'block_status','1'),(12,'facebook','https://www.facebook.com/viacoin.cz'),(13,'twitter','https://www.twitter.com'),(14,'youtube','https://www.youtube.com'),(15,'google','https://www.google.com'),(16,'instagram','https://www.facebook.com'),(17,'card_commission','0'),(18,'bitcoin_commission','0.1'),(19,'email','admin'),(20,'phone','+420773232329'),(21,'paypal_address','paypal@viacoin.cz'),(22,'bitcoin_commission_user','0'),(23,'maintenance_mode','1'),(24,'bitcoin_address',''),(25,'blocktrail_key','73fcc9bec9482e79e300619133b59c6c156815c2'),(26,'blocktrail_secret','1ff849a1ec405565edfcfe9b76ecc723d6768c65'),(27,'blocktrail_wallet','Wallet2'),(28,'blocktrail_wpass','Dvader1881');
1608/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
1609UNLOCK TABLES;
1610
1611--
1612-- Table structure for table `sliders`
1613--
1614
1615DROP TABLE IF EXISTS `sliders`;
1616/*!40101 SET @saved_cs_client     = @@character_set_client */;
1617/*!40101 SET character_set_client = utf8 */;
1618CREATE TABLE `sliders` (
1619  `id` int(255) NOT NULL AUTO_INCREMENT,
1620  `title` varchar(255) NOT NULL,
1621  `description` text NOT NULL,
1622  `content` text NOT NULL,
1623  `image` varchar(255) NOT NULL,
1624  PRIMARY KEY (`id`)
1625) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
1626/*!40101 SET character_set_client = @saved_cs_client */;
1627
1628--
1629-- Dumping data for table `sliders`
1630--
1631
1632LOCK TABLES `sliders` WRITE;
1633/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
1634INSERT INTO `sliders` VALUES (4,'Secured Data','Your data is safe','In viacoin, all datas are stored with ultra encryptions.  It means your all transactions and data are always secured!','7ec7d3c64922a5d21a7bd78fbf1fa61f.png'),(5,'Easy Steps','Buy/Sell Easily','You can buy or sell Bitcoins in viacoin easily, in a few minutes!','ed28688546d44085c362b398b40478a2.png'),(6,'Fast Transactions','Time is Money','You can buy or sell Bitcoins in viacoin just in a few minutes!','d39a99992ee128221a19bc7bc92ab4b7.png'),(7,'7/24 Support','We\'re Here to Help!','Our experienced support team is working 7/24 for you!','6c965b712ed14d9c7e18690a26708b32.png'),(8,'Best Prices','Best in the Market','Viacoin\'s main target is always providing best prices for customers!','798eacbcdf89f0b2fa2f0d1fead0794f.png');
1635/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
1636UNLOCK TABLES;
1637
1638--
1639-- Table structure for table `support`
1640--
1641
1642DROP TABLE IF EXISTS `support`;
1643/*!40101 SET @saved_cs_client     = @@character_set_client */;
1644/*!40101 SET character_set_client = utf8 */;
1645CREATE TABLE `support` (
1646  `id` int(255) NOT NULL AUTO_INCREMENT,
1647  `title` varchar(255) NOT NULL,
1648  `user_id` int(255) NOT NULL,
1649  `last_reply_type` int(1) NOT NULL,
1650  `last_reply_user` int(255) NOT NULL,
1651  `last_reply_date` varchar(66) NOT NULL,
1652  `status` int(1) NOT NULL DEFAULT '0',
1653  PRIMARY KEY (`id`)
1654) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
1655/*!40101 SET character_set_client = @saved_cs_client */;
1656
1657--
1658-- Dumping data for table `support`
1659--
1660
1661LOCK TABLES `support` WRITE;
1662/*!40000 ALTER TABLE `support` DISABLE KEYS */;
1663/*!40000 ALTER TABLE `support` ENABLE KEYS */;
1664UNLOCK TABLES;
1665
1666--
1667-- Table structure for table `support_files`
1668--
1669
1670DROP TABLE IF EXISTS `support_files`;
1671/*!40101 SET @saved_cs_client     = @@character_set_client */;
1672/*!40101 SET character_set_client = utf8 */;
1673CREATE TABLE `support_files` (
1674  `id` int(255) NOT NULL AUTO_INCREMENT,
1675  `message_id` int(255) NOT NULL,
1676  `file` varchar(255) NOT NULL,
1677  PRIMARY KEY (`id`)
1678) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1679/*!40101 SET character_set_client = @saved_cs_client */;
1680
1681--
1682-- Dumping data for table `support_files`
1683--
1684
1685LOCK TABLES `support_files` WRITE;
1686/*!40000 ALTER TABLE `support_files` DISABLE KEYS */;
1687/*!40000 ALTER TABLE `support_files` ENABLE KEYS */;
1688UNLOCK TABLES;
1689
1690--
1691-- Table structure for table `support_messages`
1692--
1693
1694DROP TABLE IF EXISTS `support_messages`;
1695/*!40101 SET @saved_cs_client     = @@character_set_client */;
1696/*!40101 SET character_set_client = utf8 */;
1697CREATE TABLE `support_messages` (
1698  `id` int(255) NOT NULL AUTO_INCREMENT,
1699  `ticket_id` int(255) NOT NULL,
1700  `sender_type` int(1) NOT NULL,
1701  `sender_id` int(255) NOT NULL,
1702  `message` text NOT NULL,
1703  `date` varchar(66) NOT NULL,
1704  `files` int(1) NOT NULL DEFAULT '0',
1705  PRIMARY KEY (`id`)
1706) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
1707/*!40101 SET character_set_client = @saved_cs_client */;
1708
1709--
1710-- Dumping data for table `support_messages`
1711--
1712
1713LOCK TABLES `support_messages` WRITE;
1714/*!40000 ALTER TABLE `support_messages` DISABLE KEYS */;
1715/*!40000 ALTER TABLE `support_messages` ENABLE KEYS */;
1716UNLOCK TABLES;
1717
1718--
1719-- Table structure for table `transactions`
1720--
1721
1722DROP TABLE IF EXISTS `transactions`;
1723/*!40101 SET @saved_cs_client     = @@character_set_client */;
1724/*!40101 SET character_set_client = utf8 */;
1725CREATE TABLE `transactions` (
1726  `id` int(255) NOT NULL AUTO_INCREMENT,
1727  `order_id` varchar(66) NOT NULL,
1728  `user_id` int(255) NOT NULL,
1729  `amount` decimal(10,2) NOT NULL,
1730  `bitcoin_amount` int(255) DEFAULT NULL,
1731  `date` varchar(66) NOT NULL,
1732  `email` varchar(255) DEFAULT NULL,
1733  `bitcoin_address` varchar(255) DEFAULT NULL,
1734  `ip_address` varchar(15) DEFAULT NULL,
1735  `feedback` text,
1736  `status` int(1) NOT NULL DEFAULT '0',
1737  `released` int(1) NOT NULL DEFAULT '0',
1738  PRIMARY KEY (`id`)
1739) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1740/*!40101 SET character_set_client = @saved_cs_client */;
1741
1742--
1743-- Dumping data for table `transactions`
1744--
1745
1746LOCK TABLES `transactions` WRITE;
1747/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
1748/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
1749UNLOCK TABLES;
1750
1751--
1752-- Table structure for table `users`
1753--
1754
1755DROP TABLE IF EXISTS `users`;
1756/*!40101 SET @saved_cs_client     = @@character_set_client */;
1757/*!40101 SET character_set_client = utf8 */;
1758CREATE TABLE `users` (
1759  `id` int(255) NOT NULL AUTO_INCREMENT,
1760  `username` varchar(166) NOT NULL,
1761  `email` varchar(255) NOT NULL,
1762  `password` varchar(166) NOT NULL,
1763  `balance` decimal(10,2) NOT NULL,
1764  `bitcoin` int(255) NOT NULL,
1765  `register_date` varchar(66) NOT NULL,
1766  `register_ip` varchar(15) NOT NULL,
1767  `status` int(1) NOT NULL DEFAULT '1',
1768  PRIMARY KEY (`id`)
1769) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
1770/*!40101 SET character_set_client = @saved_cs_client */;
1771
1772--
1773-- Dumping data for table `users`
1774--
1775
1776LOCK TABLES `users` WRITE;
1777/*!40000 ALTER TABLE `users` DISABLE KEYS */;
1778INSERT INTO `users` VALUES (5,'testuser','17kirill71@mail.ru','$2y$10$tVMsIqGdRQ4UWIEN1nUKfezgY3zbWmWc2iQN.ZZ8Tfy1ac0Uxqi9m',510.00,0,'1492583242','31.135.76.13',1),(6,'Daemon','vacek.lukas@seznam.cz','$2y$10$RxeJC8LcWZRmvUm80dmcxe9kuRgKJ9HHN8wGI0SDBFJZS5ZLf7OaC',0.00,0,'1492875500','37.48.37.19',1);
1779/*!40000 ALTER TABLE `users` ENABLE KEYS */;
1780UNLOCK TABLES;
1781
1782--
1783-- Table structure for table `withdrawals`
1784--
1785
1786DROP TABLE IF EXISTS `withdrawals`;
1787/*!40101 SET @saved_cs_client     = @@character_set_client */;
1788/*!40101 SET character_set_client = utf8 */;
1789CREATE TABLE `withdrawals` (
1790  `id` int(255) NOT NULL AUTO_INCREMENT,
1791  `user_id` int(255) NOT NULL,
1792  `amount` decimal(10,2) NOT NULL,
1793  `bitcoin_amount` int(255) NOT NULL,
1794  `bitcoin_address` varchar(255) NOT NULL,
1795  `btc_transaction_id` varchar(255) DEFAULT NULL,
1796  `date` varchar(66) NOT NULL,
1797  `ip_address` varchar(15) NOT NULL,
1798  `bank_name` varchar(255) NOT NULL,
1799  `account_owner` varchar(255) NOT NULL,
1800  `account_number` varchar(255) NOT NULL,
1801  `iban` varchar(255) NOT NULL,
1802  `lat` varchar(66) DEFAULT NULL,
1803  `lon` varchar(66) DEFAULT NULL,
1804  `city` varchar(255) DEFAULT NULL,
1805  `paid` int(1) NOT NULL DEFAULT '0',
1806  `status` int(1) NOT NULL DEFAULT '0',
1807  PRIMARY KEY (`id`)
1808) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
1809/*!40101 SET character_set_client = @saved_cs_client */;
1810
1811--
1812-- Dumping data for table `withdrawals`
1813--
1814
1815LOCK TABLES `withdrawals` WRITE;
1816/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
1817/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
1818UNLOCK TABLES;
1819
1820--
1821-- Current Database: `viacoin_es`
1822--
1823
1824CREATE DATABASE /*!32312 IF NOT EXISTS*/ `viacoin_es` /*!40100 DEFAULT CHARACTER SET utf8 */;
1825
1826USE `viacoin_es`;
1827
1828--
1829-- Table structure for table `admin_types`
1830--
1831
1832DROP TABLE IF EXISTS `admin_types`;
1833/*!40101 SET @saved_cs_client     = @@character_set_client */;
1834/*!40101 SET character_set_client = utf8 */;
1835CREATE TABLE `admin_types` (
1836  `id` int(255) NOT NULL AUTO_INCREMENT,
1837  `name` varchar(166) NOT NULL,
1838  `auth` text NOT NULL,
1839  PRIMARY KEY (`id`)
1840) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
1841/*!40101 SET character_set_client = @saved_cs_client */;
1842
1843--
1844-- Dumping data for table `admin_types`
1845--
1846
1847LOCK TABLES `admin_types` WRITE;
1848/*!40000 ALTER TABLE `admin_types` DISABLE KEYS */;
1849INSERT INTO `admin_types` VALUES (1,'Admin','settings,faq,terms-of-service,privacy-policy,security,about-us,how-it-works,sliders,clients,transactions,payments,withdrawals,staff,manage,support,bank-accounts,logs'),(2,'Zkouška zaměstnanec','support,bank-accounts'),(3,'viacoin1','clients,transactions,payments,withdrawals,support');
1850/*!40000 ALTER TABLE `admin_types` ENABLE KEYS */;
1851UNLOCK TABLES;
1852
1853--
1854-- Table structure for table `admins`
1855--
1856
1857DROP TABLE IF EXISTS `admins`;
1858/*!40101 SET @saved_cs_client     = @@character_set_client */;
1859/*!40101 SET character_set_client = utf8 */;
1860CREATE TABLE `admins` (
1861  `id` int(255) NOT NULL AUTO_INCREMENT,
1862  `username` varchar(66) NOT NULL,
1863  `password` varchar(255) NOT NULL,
1864  `email` varchar(166) NOT NULL,
1865  `name` varchar(255) NOT NULL,
1866  `auth` int(255) NOT NULL,
1867  `google_auth` int(1) NOT NULL DEFAULT '0',
1868  `google_opt` varchar(66) DEFAULT NULL,
1869  `status` int(1) NOT NULL DEFAULT '1',
1870  PRIMARY KEY (`id`),
1871  KEY `auth` (`auth`)
1872) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1873/*!40101 SET character_set_client = @saved_cs_client */;
1874
1875--
1876-- Dumping data for table `admins`
1877--
1878
1879LOCK TABLES `admins` WRITE;
1880/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
1881INSERT INTO `admins` VALUES (1,'admin','$2y$10$/58qJCCsLzsbIDRx/lwbb.JaWLUKlJ24v4wLFPsuK21Dusy8AsF5O','denizbirlik16@gmail.com','Deniz Birlik',1,2,'4AWRWNFURLFDNQLV',1),(2,'barbie','$2y$10$MH995zkU/X3ERRCZGXY4U.lX0iK0HXNazIU1CK5MBX1IeBhVcAf3.','rz8@email.cz','barbie',3,0,NULL,1);
1882/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
1883UNLOCK TABLES;
1884
1885--
1886-- Table structure for table `bank_accounts`
1887--
1888
1889DROP TABLE IF EXISTS `bank_accounts`;
1890/*!40101 SET @saved_cs_client     = @@character_set_client */;
1891/*!40101 SET character_set_client = utf8 */;
1892CREATE TABLE `bank_accounts` (
1893  `id` int(255) NOT NULL AUTO_INCREMENT,
1894  `bank_name` varchar(255) NOT NULL,
1895  `account_owner` varchar(255) NOT NULL,
1896  `account_number` varchar(166) NOT NULL,
1897  `iban` varchar(166) NOT NULL,
1898  `logo` varchar(255) NOT NULL,
1899  PRIMARY KEY (`id`)
1900) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
1901/*!40101 SET character_set_client = @saved_cs_client */;
1902
1903--
1904-- Dumping data for table `bank_accounts`
1905--
1906
1907LOCK TABLES `bank_accounts` WRITE;
1908/*!40000 ALTER TABLE `bank_accounts` DISABLE KEYS */;
1909INSERT INTO `bank_accounts` VALUES (1,'Garanti Bankası','Deniz Birlik','536-7774625','TR83 3823 8323 1239 8732 0000 0000 0233 01','4869a330ca41f4816aeed121ee42715e.jpg'),(2,'mBank','BreBank','670100-2205647536/6210','CZ37 6210 6701 0022 0564 7536','79714ed2cb3c0a0587888eca9bf93791.jpg'),(3,'Raiffeisen bank','Raiffeisen bank','78100909/5500','CZ37 6210 6701 0022 0564 7536 ','6b1c7f9fba55afdc4e43790181d0de53.jpg');
1910/*!40000 ALTER TABLE `bank_accounts` ENABLE KEYS */;
1911UNLOCK TABLES;
1912
1913--
1914-- Table structure for table `content`
1915--
1916
1917DROP TABLE IF EXISTS `content`;
1918/*!40101 SET @saved_cs_client     = @@character_set_client */;
1919/*!40101 SET character_set_client = utf8 */;
1920CREATE TABLE `content` (
1921  `id` int(255) NOT NULL AUTO_INCREMENT,
1922  `feature` varchar(255) NOT NULL,
1923  `value` text NOT NULL,
1924  PRIMARY KEY (`id`)
1925) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
1926/*!40101 SET character_set_client = @saved_cs_client */;
1927
1928--
1929-- Dumping data for table `content`
1930--
1931
1932LOCK TABLES `content` WRITE;
1933/*!40000 ALTER TABLE `content` DISABLE KEYS */;
1934INSERT INTO `content` VALUES (1,'security','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut sed pellentesque sem, id placerat enim. Suspendisse pharetra hendrerit felis, ac scelerisque sem posuere et. Phasellus hendrerit est eu ligula posuere, non bibendum dui finibus. Nam odio urna, egestas id maximus in, tincidunt non odio. Nulla facilisi. Nullam cursus quis magna sit amet interdum. Donec iaculis bibendum accumsan.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Nullam vitae eros ex.&nbsp;</font></p>'),(2,'terms_of_service','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Suspendisse potenti. Duis vitae suscipit dui, non pulvinar mauris. Interdum et malesuada fames ac ante ipsum primis in faucibus. Suspendisse augue massa, convallis vitae scelerisque vitae, auctor eu erat. </font></span></p><p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Mauris venenatis dictum justo non ullamcorper. Quisque eu facilisis erat.</font></span></p>'),(3,'about_us','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Maecenas in felis mauris. Mauris dictum massa non pharetra lacinia. Vivamus ut libero orci. Maecenas vitae volutpat sem. Pellentesque ultrices tempus mi, id feugiat nunc interdum sit amet. </font></span></p><p><span style=\"font-family: Verdana; color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\">Vestibulum nec nulla et odio lacinia hendrerit nec nec ex. Praesent placerat nulla eget dolor lobortis commodo. Praesent laoreet felis ut purus dignissim mollis.</span><br></p>'),(4,'privacy_policy','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Mauris hendrerit, elit cursus auctor cursus, enim urna hendrerit eros, sit amet porta dui mauris posuere diam. Pellentesque tempor libero a est viverra faucibus. Vivamus laoreet vulputate nunc quis finibus. Nam dapibus, erat vel tincidunt vehicula, diam eros finibus dolor, quis ultricies massa neque sed purus. Nunc nec est erat. Praesent eget tincidunt eros. Sed gravida placerat ex, venenatis hendrerit tortor facilisis vitae. Mauris faucibus, sem id placerat condimentum, nisl velit sollicitudin urna, in ornare lectus purus in erat.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Sed euismod ultrices ex, et porttitor erat vulputate ac.</font></p>'),(5,'how_it_works','Put how it works content here.');
1935/*!40000 ALTER TABLE `content` ENABLE KEYS */;
1936UNLOCK TABLES;
1937
1938--
1939-- Table structure for table `faq`
1940--
1941
1942DROP TABLE IF EXISTS `faq`;
1943/*!40101 SET @saved_cs_client     = @@character_set_client */;
1944/*!40101 SET character_set_client = utf8 */;
1945CREATE TABLE `faq` (
1946  `id` int(255) NOT NULL AUTO_INCREMENT,
1947  `question` text NOT NULL,
1948  `answer` text NOT NULL,
1949  PRIMARY KEY (`id`)
1950) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
1951/*!40101 SET character_set_client = @saved_cs_client */;
1952
1953--
1954-- Dumping data for table `faq`
1955--
1956
1957LOCK TABLES `faq` WRITE;
1958/*!40000 ALTER TABLE `faq` DISABLE KEYS */;
1959INSERT INTO `faq` VALUES (1,'Put your first question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(2,'Put your second question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(3,'Put your third question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(4,'Put your fourth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(5,'Put your fifth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. ');
1960/*!40000 ALTER TABLE `faq` ENABLE KEYS */;
1961UNLOCK TABLES;
1962
1963--
1964-- Table structure for table `logs`
1965--
1966
1967DROP TABLE IF EXISTS `logs`;
1968/*!40101 SET @saved_cs_client     = @@character_set_client */;
1969/*!40101 SET character_set_client = utf8 */;
1970CREATE TABLE `logs` (
1971  `id` int(255) NOT NULL AUTO_INCREMENT,
1972  `user_id` int(255) NOT NULL,
1973  `date` varchar(66) NOT NULL,
1974  `ip_address` varchar(15) NOT NULL,
1975  `action` varchar(255) NOT NULL,
1976  PRIMARY KEY (`id`)
1977) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1978/*!40101 SET character_set_client = @saved_cs_client */;
1979
1980--
1981-- Dumping data for table `logs`
1982--
1983
1984LOCK TABLES `logs` WRITE;
1985/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
1986/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
1987UNLOCK TABLES;
1988
1989--
1990-- Table structure for table `payments`
1991--
1992
1993DROP TABLE IF EXISTS `payments`;
1994/*!40101 SET @saved_cs_client     = @@character_set_client */;
1995/*!40101 SET character_set_client = utf8 */;
1996CREATE TABLE `payments` (
1997  `id` int(255) NOT NULL AUTO_INCREMENT,
1998  `tx_id` varchar(255) DEFAULT NULL,
1999  `order_id` varchar(66) NOT NULL,
2000  `user_id` int(255) NOT NULL,
2001  `type` int(1) DEFAULT NULL,
2002  `amount` decimal(10,2) NOT NULL,
2003  `bitcoin_amount` int(255) DEFAULT NULL,
2004  `date` varchar(66) NOT NULL,
2005  `complete_date` varchar(66) DEFAULT NULL,
2006  `ip_address` varchar(15) NOT NULL,
2007  `step` int(1) NOT NULL DEFAULT '2',
2008  `email` varchar(255) DEFAULT NULL,
2009  `bitcoin_address` varchar(255) DEFAULT NULL,
2010  `paypal_address` varchar(255) DEFAULT NULL,
2011  `lat` varchar(66) DEFAULT NULL,
2012  `lon` varchar(66) DEFAULT NULL,
2013  `city` varchar(166) DEFAULT NULL,
2014  `feedback` text,
2015  `bank_id` int(22) DEFAULT NULL,
2016  `status` int(1) NOT NULL DEFAULT '0',
2017  `released` int(1) NOT NULL DEFAULT '0',
2018  PRIMARY KEY (`id`)
2019) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2020/*!40101 SET character_set_client = @saved_cs_client */;
2021
2022--
2023-- Dumping data for table `payments`
2024--
2025
2026LOCK TABLES `payments` WRITE;
2027/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
2028/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
2029UNLOCK TABLES;
2030
2031--
2032-- Table structure for table `settings`
2033--
2034
2035DROP TABLE IF EXISTS `settings`;
2036/*!40101 SET @saved_cs_client     = @@character_set_client */;
2037/*!40101 SET character_set_client = utf8 */;
2038CREATE TABLE `settings` (
2039  `id` int(255) NOT NULL AUTO_INCREMENT,
2040  `feature` varchar(166) NOT NULL,
2041  `value` text NOT NULL,
2042  PRIMARY KEY (`id`)
2043) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
2044/*!40101 SET character_set_client = @saved_cs_client */;
2045
2046--
2047-- Dumping data for table `settings`
2048--
2049
2050LOCK TABLES `settings` WRITE;
2051/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
2052INSERT INTO `settings` VALUES (1,'mailgun_domain','denizb16.com'),(2,'mailgun_key','key-3fbf4e1254de126d68ad93f023c3c3bc'),(3,'website_title','Viacoin.com'),(4,'website_keywords','put,your,keywords,here'),(5,'website_description','Put your website description here.'),(6,'stripe_test_key','sk_test_lRaYYvpFpJDzgK23PI8o2vgE'),(7,'stripe_live_key','sk_live_sWGz3dXa4AU5rJGxoB392nBM'),(8,'stripe_status','0'),(9,'block_test_key','b674-3f84-8f5d-948e'),(10,'block_live_key','7d6b-8ed3-8f9b-8a20'),(11,'block_status','1'),(12,'facebook','https://www.facebook.com/viacoin.cz'),(13,'twitter','https://www.twitter.com'),(14,'youtube','https://www.youtube.com'),(15,'google','https://www.google.com'),(16,'instagram','https://www.facebook.com'),(17,'card_commission','0'),(18,'bitcoin_commission','0'),(19,'email','info@viacoin.cz'),(20,'phone','+420773232329'),(21,'paypal_address','paypal@viacoin.cz'),(22,'bitcoin_commission_user','0'),(23,'maintenance_mode','1');
2053/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
2054UNLOCK TABLES;
2055
2056--
2057-- Table structure for table `sliders`
2058--
2059
2060DROP TABLE IF EXISTS `sliders`;
2061/*!40101 SET @saved_cs_client     = @@character_set_client */;
2062/*!40101 SET character_set_client = utf8 */;
2063CREATE TABLE `sliders` (
2064  `id` int(255) NOT NULL AUTO_INCREMENT,
2065  `title` varchar(255) NOT NULL,
2066  `description` text NOT NULL,
2067  `content` text NOT NULL,
2068  `image` varchar(255) NOT NULL,
2069  PRIMARY KEY (`id`)
2070) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
2071/*!40101 SET character_set_client = @saved_cs_client */;
2072
2073--
2074-- Dumping data for table `sliders`
2075--
2076
2077LOCK TABLES `sliders` WRITE;
2078/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
2079INSERT INTO `sliders` VALUES (4,'Secured Data','Your data is safe','In viacoin, all datas are stored with ultra encryptions.  It means your all transactions and data are always secured!','7ec7d3c64922a5d21a7bd78fbf1fa61f.png'),(5,'Easy Steps','Buy/Sell Easily','You can buy or sell Bitcoins in viacoin easily, in a few minutes!','ed28688546d44085c362b398b40478a2.png'),(6,'Fast Transactions','Time is Money','You can buy or sell Bitcoins in viacoin just in a few minutes!','d39a99992ee128221a19bc7bc92ab4b7.png'),(7,'7/24 Support','We\'re Here to Help!','Our experienced support team is working 7/24 for you!','6c965b712ed14d9c7e18690a26708b32.png'),(8,'Best Prices','Best in the Market','Viacoin\'s main target is always providing best prices for customers!','798eacbcdf89f0b2fa2f0d1fead0794f.png');
2080/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
2081UNLOCK TABLES;
2082
2083--
2084-- Table structure for table `support`
2085--
2086
2087DROP TABLE IF EXISTS `support`;
2088/*!40101 SET @saved_cs_client     = @@character_set_client */;
2089/*!40101 SET character_set_client = utf8 */;
2090CREATE TABLE `support` (
2091  `id` int(255) NOT NULL AUTO_INCREMENT,
2092  `title` varchar(255) NOT NULL,
2093  `user_id` int(255) NOT NULL,
2094  `last_reply_type` int(1) NOT NULL,
2095  `last_reply_user` int(255) NOT NULL,
2096  `last_reply_date` varchar(66) NOT NULL,
2097  `status` int(1) NOT NULL DEFAULT '0',
2098  PRIMARY KEY (`id`)
2099) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2100/*!40101 SET character_set_client = @saved_cs_client */;
2101
2102--
2103-- Dumping data for table `support`
2104--
2105
2106LOCK TABLES `support` WRITE;
2107/*!40000 ALTER TABLE `support` DISABLE KEYS */;
2108/*!40000 ALTER TABLE `support` ENABLE KEYS */;
2109UNLOCK TABLES;
2110
2111--
2112-- Table structure for table `support_files`
2113--
2114
2115DROP TABLE IF EXISTS `support_files`;
2116/*!40101 SET @saved_cs_client     = @@character_set_client */;
2117/*!40101 SET character_set_client = utf8 */;
2118CREATE TABLE `support_files` (
2119  `id` int(255) NOT NULL AUTO_INCREMENT,
2120  `message_id` int(255) NOT NULL,
2121  `file` varchar(255) NOT NULL,
2122  PRIMARY KEY (`id`)
2123) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2124/*!40101 SET character_set_client = @saved_cs_client */;
2125
2126--
2127-- Dumping data for table `support_files`
2128--
2129
2130LOCK TABLES `support_files` WRITE;
2131/*!40000 ALTER TABLE `support_files` DISABLE KEYS */;
2132/*!40000 ALTER TABLE `support_files` ENABLE KEYS */;
2133UNLOCK TABLES;
2134
2135--
2136-- Table structure for table `support_messages`
2137--
2138
2139DROP TABLE IF EXISTS `support_messages`;
2140/*!40101 SET @saved_cs_client     = @@character_set_client */;
2141/*!40101 SET character_set_client = utf8 */;
2142CREATE TABLE `support_messages` (
2143  `id` int(255) NOT NULL AUTO_INCREMENT,
2144  `ticket_id` int(255) NOT NULL,
2145  `sender_type` int(1) NOT NULL,
2146  `sender_id` int(255) NOT NULL,
2147  `message` text NOT NULL,
2148  `date` varchar(66) NOT NULL,
2149  `files` int(1) NOT NULL DEFAULT '0',
2150  PRIMARY KEY (`id`)
2151) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2152/*!40101 SET character_set_client = @saved_cs_client */;
2153
2154--
2155-- Dumping data for table `support_messages`
2156--
2157
2158LOCK TABLES `support_messages` WRITE;
2159/*!40000 ALTER TABLE `support_messages` DISABLE KEYS */;
2160/*!40000 ALTER TABLE `support_messages` ENABLE KEYS */;
2161UNLOCK TABLES;
2162
2163--
2164-- Table structure for table `transactions`
2165--
2166
2167DROP TABLE IF EXISTS `transactions`;
2168/*!40101 SET @saved_cs_client     = @@character_set_client */;
2169/*!40101 SET character_set_client = utf8 */;
2170CREATE TABLE `transactions` (
2171  `id` int(255) NOT NULL AUTO_INCREMENT,
2172  `order_id` varchar(66) NOT NULL,
2173  `user_id` int(255) NOT NULL,
2174  `amount` decimal(10,2) NOT NULL,
2175  `bitcoin_amount` int(255) DEFAULT NULL,
2176  `date` varchar(66) NOT NULL,
2177  `email` varchar(255) DEFAULT NULL,
2178  `bitcoin_address` varchar(255) DEFAULT NULL,
2179  `ip_address` varchar(15) DEFAULT NULL,
2180  `feedback` text,
2181  `status` int(1) NOT NULL DEFAULT '0',
2182  `released` int(1) NOT NULL DEFAULT '0',
2183  PRIMARY KEY (`id`)
2184) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
2185/*!40101 SET character_set_client = @saved_cs_client */;
2186
2187--
2188-- Dumping data for table `transactions`
2189--
2190
2191LOCK TABLES `transactions` WRITE;
2192/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
2193/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
2194UNLOCK TABLES;
2195
2196--
2197-- Table structure for table `users`
2198--
2199
2200DROP TABLE IF EXISTS `users`;
2201/*!40101 SET @saved_cs_client     = @@character_set_client */;
2202/*!40101 SET character_set_client = utf8 */;
2203CREATE TABLE `users` (
2204  `id` int(255) NOT NULL AUTO_INCREMENT,
2205  `username` varchar(166) NOT NULL,
2206  `email` varchar(255) NOT NULL,
2207  `password` varchar(166) NOT NULL,
2208  `balance` decimal(10,2) NOT NULL,
2209  `bitcoin` int(255) NOT NULL,
2210  `register_date` varchar(66) NOT NULL,
2211  `register_ip` varchar(15) NOT NULL,
2212  `status` int(1) NOT NULL DEFAULT '1',
2213  PRIMARY KEY (`id`)
2214) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2215/*!40101 SET character_set_client = @saved_cs_client */;
2216
2217--
2218-- Dumping data for table `users`
2219--
2220
2221LOCK TABLES `users` WRITE;
2222/*!40000 ALTER TABLE `users` DISABLE KEYS */;
2223/*!40000 ALTER TABLE `users` ENABLE KEYS */;
2224UNLOCK TABLES;
2225
2226--
2227-- Table structure for table `withdrawals`
2228--
2229
2230DROP TABLE IF EXISTS `withdrawals`;
2231/*!40101 SET @saved_cs_client     = @@character_set_client */;
2232/*!40101 SET character_set_client = utf8 */;
2233CREATE TABLE `withdrawals` (
2234  `id` int(255) NOT NULL AUTO_INCREMENT,
2235  `user_id` int(255) NOT NULL,
2236  `amount` decimal(10,2) NOT NULL,
2237  `bitcoin_amount` int(255) NOT NULL,
2238  `bitcoin_address` varchar(255) NOT NULL,
2239  `date` varchar(66) NOT NULL,
2240  `ip_address` varchar(15) NOT NULL,
2241  `bank_name` varchar(255) NOT NULL,
2242  `account_owner` varchar(255) NOT NULL,
2243  `account_number` varchar(255) NOT NULL,
2244  `iban` varchar(255) NOT NULL,
2245  `lat` varchar(66) DEFAULT NULL,
2246  `lon` varchar(66) DEFAULT NULL,
2247  `city` varchar(255) DEFAULT NULL,
2248  `paid` int(1) NOT NULL DEFAULT '0',
2249  `status` int(1) NOT NULL DEFAULT '0',
2250  PRIMARY KEY (`id`)
2251) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2252/*!40101 SET character_set_client = @saved_cs_client */;
2253
2254--
2255-- Dumping data for table `withdrawals`
2256--
2257
2258LOCK TABLES `withdrawals` WRITE;
2259/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
2260/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
2261UNLOCK TABLES;
2262
2263--
2264-- Current Database: `viacoin_fr`
2265--
2266
2267CREATE DATABASE /*!32312 IF NOT EXISTS*/ `viacoin_fr` /*!40100 DEFAULT CHARACTER SET utf8 */;
2268
2269USE `viacoin_fr`;
2270
2271--
2272-- Table structure for table `admin_types`
2273--
2274
2275DROP TABLE IF EXISTS `admin_types`;
2276/*!40101 SET @saved_cs_client     = @@character_set_client */;
2277/*!40101 SET character_set_client = utf8 */;
2278CREATE TABLE `admin_types` (
2279  `id` int(255) NOT NULL AUTO_INCREMENT,
2280  `name` varchar(166) NOT NULL,
2281  `auth` text NOT NULL,
2282  PRIMARY KEY (`id`)
2283) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
2284/*!40101 SET character_set_client = @saved_cs_client */;
2285
2286--
2287-- Dumping data for table `admin_types`
2288--
2289
2290LOCK TABLES `admin_types` WRITE;
2291/*!40000 ALTER TABLE `admin_types` DISABLE KEYS */;
2292INSERT INTO `admin_types` VALUES (1,'Admin','settings,faq,terms-of-service,privacy-policy,security,about-us,how-it-works,sliders,clients,transactions,payments,withdrawals,staff,manage,support,bank-accounts,logs'),(2,'Zkouška zaměstnanec','support,bank-accounts'),(3,'viacoin1','clients,transactions,payments,withdrawals,support');
2293/*!40000 ALTER TABLE `admin_types` ENABLE KEYS */;
2294UNLOCK TABLES;
2295
2296--
2297-- Table structure for table `admins`
2298--
2299
2300DROP TABLE IF EXISTS `admins`;
2301/*!40101 SET @saved_cs_client     = @@character_set_client */;
2302/*!40101 SET character_set_client = utf8 */;
2303CREATE TABLE `admins` (
2304  `id` int(255) NOT NULL AUTO_INCREMENT,
2305  `username` varchar(66) NOT NULL,
2306  `password` varchar(255) NOT NULL,
2307  `email` varchar(166) NOT NULL,
2308  `name` varchar(255) NOT NULL,
2309  `auth` int(255) NOT NULL,
2310  `google_auth` int(1) NOT NULL DEFAULT '0',
2311  `google_opt` varchar(66) DEFAULT NULL,
2312  `status` int(1) NOT NULL DEFAULT '1',
2313  PRIMARY KEY (`id`),
2314  KEY `auth` (`auth`)
2315) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
2316/*!40101 SET character_set_client = @saved_cs_client */;
2317
2318--
2319-- Dumping data for table `admins`
2320--
2321
2322LOCK TABLES `admins` WRITE;
2323/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
2324INSERT INTO `admins` VALUES (1,'admin','$2y$10$/58qJCCsLzsbIDRx/lwbb.JaWLUKlJ24v4wLFPsuK21Dusy8AsF5O','denizbirlik16@gmail.com','Deniz Birlik',1,2,'4AWRWNFURLFDNQLV',1),(2,'barbie','$2y$10$MH995zkU/X3ERRCZGXY4U.lX0iK0HXNazIU1CK5MBX1IeBhVcAf3.','rz8@email.cz','barbie',3,2,'B2BPSIE5MADOKDUP',1);
2325/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
2326UNLOCK TABLES;
2327
2328--
2329-- Table structure for table `bank_accounts`
2330--
2331
2332DROP TABLE IF EXISTS `bank_accounts`;
2333/*!40101 SET @saved_cs_client     = @@character_set_client */;
2334/*!40101 SET character_set_client = utf8 */;
2335CREATE TABLE `bank_accounts` (
2336  `id` int(255) NOT NULL AUTO_INCREMENT,
2337  `bank_name` varchar(255) NOT NULL,
2338  `account_owner` varchar(255) NOT NULL,
2339  `account_number` varchar(166) NOT NULL,
2340  `iban` varchar(166) NOT NULL,
2341  `logo` varchar(255) NOT NULL,
2342  PRIMARY KEY (`id`)
2343) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
2344/*!40101 SET character_set_client = @saved_cs_client */;
2345
2346--
2347-- Dumping data for table `bank_accounts`
2348--
2349
2350LOCK TABLES `bank_accounts` WRITE;
2351/*!40000 ALTER TABLE `bank_accounts` DISABLE KEYS */;
2352INSERT INTO `bank_accounts` VALUES (1,'Garanti Bankası','Deniz Birlik','536-7774625','TR83 3823 8323 1239 8732 0000 0000 0233 01','4869a330ca41f4816aeed121ee42715e.jpg'),(2,'mBank','BreBank','670100-2205647536/6210','CZ37 6210 6701 0022 0564 7536','79714ed2cb3c0a0587888eca9bf93791.jpg'),(3,'Raiffeisen bank','Raiffeisen bank','78100909/5500','CZ37 6210 6701 0022 0564 7536 ','6b1c7f9fba55afdc4e43790181d0de53.jpg');
2353/*!40000 ALTER TABLE `bank_accounts` ENABLE KEYS */;
2354UNLOCK TABLES;
2355
2356--
2357-- Table structure for table `content`
2358--
2359
2360DROP TABLE IF EXISTS `content`;
2361/*!40101 SET @saved_cs_client     = @@character_set_client */;
2362/*!40101 SET character_set_client = utf8 */;
2363CREATE TABLE `content` (
2364  `id` int(255) NOT NULL AUTO_INCREMENT,
2365  `feature` varchar(255) NOT NULL,
2366  `value` text NOT NULL,
2367  PRIMARY KEY (`id`)
2368) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
2369/*!40101 SET character_set_client = @saved_cs_client */;
2370
2371--
2372-- Dumping data for table `content`
2373--
2374
2375LOCK TABLES `content` WRITE;
2376/*!40000 ALTER TABLE `content` DISABLE KEYS */;
2377INSERT INTO `content` VALUES (1,'security','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut sed pellentesque sem, id placerat enim. Suspendisse pharetra hendrerit felis, ac scelerisque sem posuere et. Phasellus hendrerit est eu ligula posuere, non bibendum dui finibus. Nam odio urna, egestas id maximus in, tincidunt non odio. Nulla facilisi. Nullam cursus quis magna sit amet interdum. Donec iaculis bibendum accumsan.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Nullam vitae eros ex.&nbsp;</font></p>'),(2,'terms_of_service','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Suspendisse potenti. Duis vitae suscipit dui, non pulvinar mauris. Interdum et malesuada fames ac ante ipsum primis in faucibus. Suspendisse augue massa, convallis vitae scelerisque vitae, auctor eu erat. </font></span></p><p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Mauris venenatis dictum justo non ullamcorper. Quisque eu facilisis erat.</font></span></p>'),(3,'about_us','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Maecenas in felis mauris. Mauris dictum massa non pharetra lacinia. Vivamus ut libero orci. Maecenas vitae volutpat sem. Pellentesque ultrices tempus mi, id feugiat nunc interdum sit amet. </font></span></p><p><span style=\"font-family: Verdana; color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\">Vestibulum nec nulla et odio lacinia hendrerit nec nec ex. Praesent placerat nulla eget dolor lobortis commodo. Praesent laoreet felis ut purus dignissim mollis.</span><br></p>'),(4,'privacy_policy','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Mauris hendrerit, elit cursus auctor cursus, enim urna hendrerit eros, sit amet porta dui mauris posuere diam. Pellentesque tempor libero a est viverra faucibus. Vivamus laoreet vulputate nunc quis finibus. Nam dapibus, erat vel tincidunt vehicula, diam eros finibus dolor, quis ultricies massa neque sed purus. Nunc nec est erat. Praesent eget tincidunt eros. Sed gravida placerat ex, venenatis hendrerit tortor facilisis vitae. Mauris faucibus, sem id placerat condimentum, nisl velit sollicitudin urna, in ornare lectus purus in erat.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Sed euismod ultrices ex, et porttitor erat vulputate ac.</font></p>'),(5,'how_it_works','Put how it works content here.');
2378/*!40000 ALTER TABLE `content` ENABLE KEYS */;
2379UNLOCK TABLES;
2380
2381--
2382-- Table structure for table `faq`
2383--
2384
2385DROP TABLE IF EXISTS `faq`;
2386/*!40101 SET @saved_cs_client     = @@character_set_client */;
2387/*!40101 SET character_set_client = utf8 */;
2388CREATE TABLE `faq` (
2389  `id` int(255) NOT NULL AUTO_INCREMENT,
2390  `question` text NOT NULL,
2391  `answer` text NOT NULL,
2392  PRIMARY KEY (`id`)
2393) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
2394/*!40101 SET character_set_client = @saved_cs_client */;
2395
2396--
2397-- Dumping data for table `faq`
2398--
2399
2400LOCK TABLES `faq` WRITE;
2401/*!40000 ALTER TABLE `faq` DISABLE KEYS */;
2402INSERT INTO `faq` VALUES (1,'Put your first question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(2,'Put your second question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(3,'Put your third question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(4,'Put your fourth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(5,'Put your fifth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. ');
2403/*!40000 ALTER TABLE `faq` ENABLE KEYS */;
2404UNLOCK TABLES;
2405
2406--
2407-- Table structure for table `logs`
2408--
2409
2410DROP TABLE IF EXISTS `logs`;
2411/*!40101 SET @saved_cs_client     = @@character_set_client */;
2412/*!40101 SET character_set_client = utf8 */;
2413CREATE TABLE `logs` (
2414  `id` int(255) NOT NULL AUTO_INCREMENT,
2415  `user_id` int(255) NOT NULL,
2416  `date` varchar(66) NOT NULL,
2417  `ip_address` varchar(15) NOT NULL,
2418  `action` varchar(255) NOT NULL,
2419  PRIMARY KEY (`id`)
2420) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
2421/*!40101 SET character_set_client = @saved_cs_client */;
2422
2423--
2424-- Dumping data for table `logs`
2425--
2426
2427LOCK TABLES `logs` WRITE;
2428/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
2429INSERT INTO `logs` VALUES (1,1,'1486407619','212.20.72.202','Admin logged in. ID: 1'),(2,1,'1486407668','212.20.72.202','General settings updated.'),(3,1,'1486827042','78.99.177.146','Admin logged in. ID: 1'),(4,2,'1487339930','94.228.82.112','Admin logged in. ID: 2'),(5,1,'1488136170','178.41.76.146','Admin logged in. ID: 1'),(6,1,'1488136180','178.41.76.146','General settings updated.'),(7,1,'1488136198','178.41.76.146','General settings updated.'),(8,1,'1490752607','217.30.74.169','Admin logged in. ID: 1'),(9,1,'1490752614','217.30.74.169','General settings updated.'),(10,1,'1490752633','217.30.74.169','General settings updated.');
2430/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
2431UNLOCK TABLES;
2432
2433--
2434-- Table structure for table `payments`
2435--
2436
2437DROP TABLE IF EXISTS `payments`;
2438/*!40101 SET @saved_cs_client     = @@character_set_client */;
2439/*!40101 SET character_set_client = utf8 */;
2440CREATE TABLE `payments` (
2441  `id` int(255) NOT NULL AUTO_INCREMENT,
2442  `tx_id` varchar(255) DEFAULT NULL,
2443  `order_id` varchar(66) NOT NULL,
2444  `user_id` int(255) NOT NULL,
2445  `type` int(1) DEFAULT NULL,
2446  `amount` decimal(10,2) NOT NULL,
2447  `bitcoin_amount` int(255) DEFAULT NULL,
2448  `date` varchar(66) NOT NULL,
2449  `complete_date` varchar(66) DEFAULT NULL,
2450  `ip_address` varchar(15) NOT NULL,
2451  `step` int(1) NOT NULL DEFAULT '2',
2452  `email` varchar(255) DEFAULT NULL,
2453  `bitcoin_address` varchar(255) DEFAULT NULL,
2454  `paypal_address` varchar(255) DEFAULT NULL,
2455  `lat` varchar(66) DEFAULT NULL,
2456  `lon` varchar(66) DEFAULT NULL,
2457  `city` varchar(166) DEFAULT NULL,
2458  `feedback` text,
2459  `bank_id` int(22) DEFAULT NULL,
2460  `status` int(1) NOT NULL DEFAULT '0',
2461  `released` int(1) NOT NULL DEFAULT '0',
2462  PRIMARY KEY (`id`)
2463) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2464/*!40101 SET character_set_client = @saved_cs_client */;
2465
2466--
2467-- Dumping data for table `payments`
2468--
2469
2470LOCK TABLES `payments` WRITE;
2471/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
2472/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
2473UNLOCK TABLES;
2474
2475--
2476-- Table structure for table `settings`
2477--
2478
2479DROP TABLE IF EXISTS `settings`;
2480/*!40101 SET @saved_cs_client     = @@character_set_client */;
2481/*!40101 SET character_set_client = utf8 */;
2482CREATE TABLE `settings` (
2483  `id` int(255) NOT NULL AUTO_INCREMENT,
2484  `feature` varchar(166) NOT NULL,
2485  `value` text NOT NULL,
2486  PRIMARY KEY (`id`)
2487) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
2488/*!40101 SET character_set_client = @saved_cs_client */;
2489
2490--
2491-- Dumping data for table `settings`
2492--
2493
2494LOCK TABLES `settings` WRITE;
2495/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
2496INSERT INTO `settings` VALUES (1,'mailgun_domain','denizb16.com'),(2,'mailgun_key','key-3fbf4e1254de126d68ad93f023c3c3bc'),(3,'website_title','ViaCoin'),(4,'website_keywords','put,your,keywords,here'),(5,'website_description','Put your website description here.'),(6,'stripe_test_key','sk_test_lRaYYvpFpJDzgK23PI8o2vgE'),(7,'stripe_live_key','sk_live_sWGz3dXa4AU5rJGxoB392nBM'),(8,'stripe_status','0'),(9,'block_test_key','b674-3f84-8f5d-948e'),(10,'block_live_key','7d6b-8ed3-8f9b-8a20'),(11,'block_status','1'),(12,'facebook','https://www.facebook.com/viacoin.cz'),(13,'twitter','https://www.twitter.com'),(14,'youtube','https://www.youtube.com'),(15,'google','https://www.google.com'),(16,'instagram','https://www.facebook.com'),(17,'card_commission','0'),(18,'bitcoin_commission','0'),(19,'email','info@viacoin.cz'),(20,'phone','+420773232329'),(21,'paypal_address','paypal@viacoin.cz'),(22,'bitcoin_commission_user','0'),(23,'maintenance_mode','1');
2497/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
2498UNLOCK TABLES;
2499
2500--
2501-- Table structure for table `sliders`
2502--
2503
2504DROP TABLE IF EXISTS `sliders`;
2505/*!40101 SET @saved_cs_client     = @@character_set_client */;
2506/*!40101 SET character_set_client = utf8 */;
2507CREATE TABLE `sliders` (
2508  `id` int(255) NOT NULL AUTO_INCREMENT,
2509  `title` varchar(255) NOT NULL,
2510  `description` text NOT NULL,
2511  `content` text NOT NULL,
2512  `image` varchar(255) NOT NULL,
2513  PRIMARY KEY (`id`)
2514) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
2515/*!40101 SET character_set_client = @saved_cs_client */;
2516
2517--
2518-- Dumping data for table `sliders`
2519--
2520
2521LOCK TABLES `sliders` WRITE;
2522/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
2523INSERT INTO `sliders` VALUES (4,'Secured Data','Your data is safe','In viacoin, all datas are stored with ultra encryptions.  It means your all transactions and data are always secured!','7ec7d3c64922a5d21a7bd78fbf1fa61f.png'),(5,'Easy Steps','Buy/Sell Easily','You can buy or sell Bitcoins in viacoin easily, in a few minutes!','ed28688546d44085c362b398b40478a2.png'),(6,'Fast Transactions','Time is Money','You can buy or sell Bitcoins in viacoin just in a few minutes!','d39a99992ee128221a19bc7bc92ab4b7.png'),(7,'7/24 Support','We\'re Here to Help!','Our experienced support team is working 7/24 for you!','6c965b712ed14d9c7e18690a26708b32.png'),(8,'Best Prices','Best in the Market','Viacoin\'s main target is always providing best prices for customers!','798eacbcdf89f0b2fa2f0d1fead0794f.png');
2524/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
2525UNLOCK TABLES;
2526
2527--
2528-- Table structure for table `support`
2529--
2530
2531DROP TABLE IF EXISTS `support`;
2532/*!40101 SET @saved_cs_client     = @@character_set_client */;
2533/*!40101 SET character_set_client = utf8 */;
2534CREATE TABLE `support` (
2535  `id` int(255) NOT NULL AUTO_INCREMENT,
2536  `title` varchar(255) NOT NULL,
2537  `user_id` int(255) NOT NULL,
2538  `last_reply_type` int(1) NOT NULL,
2539  `last_reply_user` int(255) NOT NULL,
2540  `last_reply_date` varchar(66) NOT NULL,
2541  `status` int(1) NOT NULL DEFAULT '0',
2542  PRIMARY KEY (`id`)
2543) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2544/*!40101 SET character_set_client = @saved_cs_client */;
2545
2546--
2547-- Dumping data for table `support`
2548--
2549
2550LOCK TABLES `support` WRITE;
2551/*!40000 ALTER TABLE `support` DISABLE KEYS */;
2552/*!40000 ALTER TABLE `support` ENABLE KEYS */;
2553UNLOCK TABLES;
2554
2555--
2556-- Table structure for table `support_files`
2557--
2558
2559DROP TABLE IF EXISTS `support_files`;
2560/*!40101 SET @saved_cs_client     = @@character_set_client */;
2561/*!40101 SET character_set_client = utf8 */;
2562CREATE TABLE `support_files` (
2563  `id` int(255) NOT NULL AUTO_INCREMENT,
2564  `message_id` int(255) NOT NULL,
2565  `file` varchar(255) NOT NULL,
2566  PRIMARY KEY (`id`)
2567) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2568/*!40101 SET character_set_client = @saved_cs_client */;
2569
2570--
2571-- Dumping data for table `support_files`
2572--
2573
2574LOCK TABLES `support_files` WRITE;
2575/*!40000 ALTER TABLE `support_files` DISABLE KEYS */;
2576/*!40000 ALTER TABLE `support_files` ENABLE KEYS */;
2577UNLOCK TABLES;
2578
2579--
2580-- Table structure for table `support_messages`
2581--
2582
2583DROP TABLE IF EXISTS `support_messages`;
2584/*!40101 SET @saved_cs_client     = @@character_set_client */;
2585/*!40101 SET character_set_client = utf8 */;
2586CREATE TABLE `support_messages` (
2587  `id` int(255) NOT NULL AUTO_INCREMENT,
2588  `ticket_id` int(255) NOT NULL,
2589  `sender_type` int(1) NOT NULL,
2590  `sender_id` int(255) NOT NULL,
2591  `message` text NOT NULL,
2592  `date` varchar(66) NOT NULL,
2593  `files` int(1) NOT NULL DEFAULT '0',
2594  PRIMARY KEY (`id`)
2595) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2596/*!40101 SET character_set_client = @saved_cs_client */;
2597
2598--
2599-- Dumping data for table `support_messages`
2600--
2601
2602LOCK TABLES `support_messages` WRITE;
2603/*!40000 ALTER TABLE `support_messages` DISABLE KEYS */;
2604/*!40000 ALTER TABLE `support_messages` ENABLE KEYS */;
2605UNLOCK TABLES;
2606
2607--
2608-- Table structure for table `transactions`
2609--
2610
2611DROP TABLE IF EXISTS `transactions`;
2612/*!40101 SET @saved_cs_client     = @@character_set_client */;
2613/*!40101 SET character_set_client = utf8 */;
2614CREATE TABLE `transactions` (
2615  `id` int(255) NOT NULL AUTO_INCREMENT,
2616  `order_id` varchar(66) NOT NULL,
2617  `user_id` int(255) NOT NULL,
2618  `amount` decimal(10,2) NOT NULL,
2619  `bitcoin_amount` int(255) DEFAULT NULL,
2620  `date` varchar(66) NOT NULL,
2621  `email` varchar(255) DEFAULT NULL,
2622  `bitcoin_address` varchar(255) DEFAULT NULL,
2623  `ip_address` varchar(15) DEFAULT NULL,
2624  `feedback` text,
2625  `status` int(1) NOT NULL DEFAULT '0',
2626  `released` int(1) NOT NULL DEFAULT '0',
2627  PRIMARY KEY (`id`)
2628) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
2629/*!40101 SET character_set_client = @saved_cs_client */;
2630
2631--
2632-- Dumping data for table `transactions`
2633--
2634
2635LOCK TABLES `transactions` WRITE;
2636/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
2637/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
2638UNLOCK TABLES;
2639
2640--
2641-- Table structure for table `users`
2642--
2643
2644DROP TABLE IF EXISTS `users`;
2645/*!40101 SET @saved_cs_client     = @@character_set_client */;
2646/*!40101 SET character_set_client = utf8 */;
2647CREATE TABLE `users` (
2648  `id` int(255) NOT NULL AUTO_INCREMENT,
2649  `username` varchar(166) NOT NULL,
2650  `email` varchar(255) NOT NULL,
2651  `password` varchar(166) NOT NULL,
2652  `balance` decimal(10,2) NOT NULL,
2653  `bitcoin` int(255) NOT NULL,
2654  `register_date` varchar(66) NOT NULL,
2655  `register_ip` varchar(15) NOT NULL,
2656  `status` int(1) NOT NULL DEFAULT '1',
2657  PRIMARY KEY (`id`)
2658) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2659/*!40101 SET character_set_client = @saved_cs_client */;
2660
2661--
2662-- Dumping data for table `users`
2663--
2664
2665LOCK TABLES `users` WRITE;
2666/*!40000 ALTER TABLE `users` DISABLE KEYS */;
2667/*!40000 ALTER TABLE `users` ENABLE KEYS */;
2668UNLOCK TABLES;
2669
2670--
2671-- Table structure for table `withdrawals`
2672--
2673
2674DROP TABLE IF EXISTS `withdrawals`;
2675/*!40101 SET @saved_cs_client     = @@character_set_client */;
2676/*!40101 SET character_set_client = utf8 */;
2677CREATE TABLE `withdrawals` (
2678  `id` int(255) NOT NULL AUTO_INCREMENT,
2679  `user_id` int(255) NOT NULL,
2680  `amount` decimal(10,2) NOT NULL,
2681  `bitcoin_amount` int(255) NOT NULL,
2682  `bitcoin_address` varchar(255) NOT NULL,
2683  `date` varchar(66) NOT NULL,
2684  `ip_address` varchar(15) NOT NULL,
2685  `bank_name` varchar(255) NOT NULL,
2686  `account_owner` varchar(255) NOT NULL,
2687  `account_number` varchar(255) NOT NULL,
2688  `iban` varchar(255) NOT NULL,
2689  `lat` varchar(66) DEFAULT NULL,
2690  `lon` varchar(66) DEFAULT NULL,
2691  `city` varchar(255) DEFAULT NULL,
2692  `paid` int(1) NOT NULL DEFAULT '0',
2693  `status` int(1) NOT NULL DEFAULT '0',
2694  PRIMARY KEY (`id`)
2695) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2696/*!40101 SET character_set_client = @saved_cs_client */;
2697
2698--
2699-- Dumping data for table `withdrawals`
2700--
2701
2702LOCK TABLES `withdrawals` WRITE;
2703/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
2704/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
2705UNLOCK TABLES;
2706
2707--
2708-- Current Database: `viacoin_gr`
2709--
2710
2711CREATE DATABASE /*!32312 IF NOT EXISTS*/ `viacoin_gr` /*!40100 DEFAULT CHARACTER SET utf8 */;
2712
2713USE `viacoin_gr`;
2714
2715--
2716-- Table structure for table `admin_types`
2717--
2718
2719DROP TABLE IF EXISTS `admin_types`;
2720/*!40101 SET @saved_cs_client     = @@character_set_client */;
2721/*!40101 SET character_set_client = utf8 */;
2722CREATE TABLE `admin_types` (
2723  `id` int(255) NOT NULL AUTO_INCREMENT,
2724  `name` varchar(166) NOT NULL,
2725  `auth` text NOT NULL,
2726  PRIMARY KEY (`id`)
2727) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
2728/*!40101 SET character_set_client = @saved_cs_client */;
2729
2730--
2731-- Dumping data for table `admin_types`
2732--
2733
2734LOCK TABLES `admin_types` WRITE;
2735/*!40000 ALTER TABLE `admin_types` DISABLE KEYS */;
2736INSERT INTO `admin_types` VALUES (1,'Admin','settings,faq,terms-of-service,privacy-policy,security,about-us,how-it-works,sliders,clients,transactions,payments,withdrawals,staff,manage,support,bank-accounts,logs'),(2,'Zkouška zaměstnanec','support,bank-accounts'),(3,'viacoin1','clients,transactions,payments,withdrawals,support');
2737/*!40000 ALTER TABLE `admin_types` ENABLE KEYS */;
2738UNLOCK TABLES;
2739
2740--
2741-- Table structure for table `admins`
2742--
2743
2744DROP TABLE IF EXISTS `admins`;
2745/*!40101 SET @saved_cs_client     = @@character_set_client */;
2746/*!40101 SET character_set_client = utf8 */;
2747CREATE TABLE `admins` (
2748  `id` int(255) NOT NULL AUTO_INCREMENT,
2749  `username` varchar(66) NOT NULL,
2750  `password` varchar(255) NOT NULL,
2751  `email` varchar(166) NOT NULL,
2752  `name` varchar(255) NOT NULL,
2753  `auth` int(255) NOT NULL,
2754  `google_auth` int(1) NOT NULL DEFAULT '0',
2755  `google_opt` varchar(66) DEFAULT NULL,
2756  `status` int(1) NOT NULL DEFAULT '1',
2757  PRIMARY KEY (`id`),
2758  KEY `auth` (`auth`)
2759) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
2760/*!40101 SET character_set_client = @saved_cs_client */;
2761
2762--
2763-- Dumping data for table `admins`
2764--
2765
2766LOCK TABLES `admins` WRITE;
2767/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
2768INSERT INTO `admins` VALUES (1,'admin','$2y$10$/58qJCCsLzsbIDRx/lwbb.JaWLUKlJ24v4wLFPsuK21Dusy8AsF5O','denizbirlik16@gmail.com','Deniz Birlik',1,2,'4AWRWNFURLFDNQLV',1),(2,'barbie','$2y$10$MH995zkU/X3ERRCZGXY4U.lX0iK0HXNazIU1CK5MBX1IeBhVcAf3.','rz8@email.cz','barbie',3,0,NULL,1);
2769/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
2770UNLOCK TABLES;
2771
2772--
2773-- Table structure for table `bank_accounts`
2774--
2775
2776DROP TABLE IF EXISTS `bank_accounts`;
2777/*!40101 SET @saved_cs_client     = @@character_set_client */;
2778/*!40101 SET character_set_client = utf8 */;
2779CREATE TABLE `bank_accounts` (
2780  `id` int(255) NOT NULL AUTO_INCREMENT,
2781  `bank_name` varchar(255) NOT NULL,
2782  `account_owner` varchar(255) NOT NULL,
2783  `account_number` varchar(166) NOT NULL,
2784  `iban` varchar(166) NOT NULL,
2785  `logo` varchar(255) NOT NULL,
2786  PRIMARY KEY (`id`)
2787) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
2788/*!40101 SET character_set_client = @saved_cs_client */;
2789
2790--
2791-- Dumping data for table `bank_accounts`
2792--
2793
2794LOCK TABLES `bank_accounts` WRITE;
2795/*!40000 ALTER TABLE `bank_accounts` DISABLE KEYS */;
2796INSERT INTO `bank_accounts` VALUES (1,'Garanti Bankası','Deniz Birlik','536-7774625','TR83 3823 8323 1239 8732 0000 0000 0233 01','4869a330ca41f4816aeed121ee42715e.jpg'),(2,'mBank','BreBank','670100-2205647536/6210','CZ37 6210 6701 0022 0564 7536','79714ed2cb3c0a0587888eca9bf93791.jpg'),(3,'Raiffeisen bank','Raiffeisen bank','78100909/5500','CZ37 6210 6701 0022 0564 7536 ','6b1c7f9fba55afdc4e43790181d0de53.jpg');
2797/*!40000 ALTER TABLE `bank_accounts` ENABLE KEYS */;
2798UNLOCK TABLES;
2799
2800--
2801-- Table structure for table `content`
2802--
2803
2804DROP TABLE IF EXISTS `content`;
2805/*!40101 SET @saved_cs_client     = @@character_set_client */;
2806/*!40101 SET character_set_client = utf8 */;
2807CREATE TABLE `content` (
2808  `id` int(255) NOT NULL AUTO_INCREMENT,
2809  `feature` varchar(255) NOT NULL,
2810  `value` text NOT NULL,
2811  PRIMARY KEY (`id`)
2812) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
2813/*!40101 SET character_set_client = @saved_cs_client */;
2814
2815--
2816-- Dumping data for table `content`
2817--
2818
2819LOCK TABLES `content` WRITE;
2820/*!40000 ALTER TABLE `content` DISABLE KEYS */;
2821INSERT INTO `content` VALUES (1,'security','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut sed pellentesque sem, id placerat enim. Suspendisse pharetra hendrerit felis, ac scelerisque sem posuere et. Phasellus hendrerit est eu ligula posuere, non bibendum dui finibus. Nam odio urna, egestas id maximus in, tincidunt non odio. Nulla facilisi. Nullam cursus quis magna sit amet interdum. Donec iaculis bibendum accumsan.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Nullam vitae eros ex.&nbsp;</font></p>'),(2,'terms_of_service','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Suspendisse potenti. Duis vitae suscipit dui, non pulvinar mauris. Interdum et malesuada fames ac ante ipsum primis in faucibus. Suspendisse augue massa, convallis vitae scelerisque vitae, auctor eu erat. </font></span></p><p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Mauris venenatis dictum justo non ullamcorper. Quisque eu facilisis erat.</font></span></p>'),(3,'about_us','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Maecenas in felis mauris. Mauris dictum massa non pharetra lacinia. Vivamus ut libero orci. Maecenas vitae volutpat sem. Pellentesque ultrices tempus mi, id feugiat nunc interdum sit amet. </font></span></p><p><span style=\"font-family: Verdana; color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\">Vestibulum nec nulla et odio lacinia hendrerit nec nec ex. Praesent placerat nulla eget dolor lobortis commodo. Praesent laoreet felis ut purus dignissim mollis.</span><br></p>'),(4,'privacy_policy','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Mauris hendrerit, elit cursus auctor cursus, enim urna hendrerit eros, sit amet porta dui mauris posuere diam. Pellentesque tempor libero a est viverra faucibus. Vivamus laoreet vulputate nunc quis finibus. Nam dapibus, erat vel tincidunt vehicula, diam eros finibus dolor, quis ultricies massa neque sed purus. Nunc nec est erat. Praesent eget tincidunt eros. Sed gravida placerat ex, venenatis hendrerit tortor facilisis vitae. Mauris faucibus, sem id placerat condimentum, nisl velit sollicitudin urna, in ornare lectus purus in erat.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Sed euismod ultrices ex, et porttitor erat vulputate ac.</font></p>'),(5,'how_it_works','Put how it works content here.');
2822/*!40000 ALTER TABLE `content` ENABLE KEYS */;
2823UNLOCK TABLES;
2824
2825--
2826-- Table structure for table `faq`
2827--
2828
2829DROP TABLE IF EXISTS `faq`;
2830/*!40101 SET @saved_cs_client     = @@character_set_client */;
2831/*!40101 SET character_set_client = utf8 */;
2832CREATE TABLE `faq` (
2833  `id` int(255) NOT NULL AUTO_INCREMENT,
2834  `question` text NOT NULL,
2835  `answer` text NOT NULL,
2836  PRIMARY KEY (`id`)
2837) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
2838/*!40101 SET character_set_client = @saved_cs_client */;
2839
2840--
2841-- Dumping data for table `faq`
2842--
2843
2844LOCK TABLES `faq` WRITE;
2845/*!40000 ALTER TABLE `faq` DISABLE KEYS */;
2846INSERT INTO `faq` VALUES (1,'Put your first question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(2,'Put your second question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(3,'Put your third question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(4,'Put your fourth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(5,'Put your fifth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. ');
2847/*!40000 ALTER TABLE `faq` ENABLE KEYS */;
2848UNLOCK TABLES;
2849
2850--
2851-- Table structure for table `logs`
2852--
2853
2854DROP TABLE IF EXISTS `logs`;
2855/*!40101 SET @saved_cs_client     = @@character_set_client */;
2856/*!40101 SET character_set_client = utf8 */;
2857CREATE TABLE `logs` (
2858  `id` int(255) NOT NULL AUTO_INCREMENT,
2859  `user_id` int(255) NOT NULL,
2860  `date` varchar(66) NOT NULL,
2861  `ip_address` varchar(15) NOT NULL,
2862  `action` varchar(255) NOT NULL,
2863  PRIMARY KEY (`id`)
2864) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
2865/*!40101 SET character_set_client = @saved_cs_client */;
2866
2867--
2868-- Dumping data for table `logs`
2869--
2870
2871LOCK TABLES `logs` WRITE;
2872/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
2873INSERT INTO `logs` VALUES (1,1,'1486491289','128.0.176.198','Admin logged in. ID: 1'),(2,1,'1486491333','128.0.176.198','General settings updated.'),(3,1,'1486501773','212.20.72.202','Admin logged in. ID: 1'),(4,1,'1486501795','212.20.72.202','General settings updated.');
2874/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
2875UNLOCK TABLES;
2876
2877--
2878-- Table structure for table `payments`
2879--
2880
2881DROP TABLE IF EXISTS `payments`;
2882/*!40101 SET @saved_cs_client     = @@character_set_client */;
2883/*!40101 SET character_set_client = utf8 */;
2884CREATE TABLE `payments` (
2885  `id` int(255) NOT NULL AUTO_INCREMENT,
2886  `tx_id` varchar(255) DEFAULT NULL,
2887  `order_id` varchar(66) NOT NULL,
2888  `user_id` int(255) NOT NULL,
2889  `type` int(1) DEFAULT NULL,
2890  `amount` decimal(10,2) NOT NULL,
2891  `bitcoin_amount` int(255) DEFAULT NULL,
2892  `date` varchar(66) NOT NULL,
2893  `complete_date` varchar(66) DEFAULT NULL,
2894  `ip_address` varchar(15) NOT NULL,
2895  `step` int(1) NOT NULL DEFAULT '2',
2896  `email` varchar(255) DEFAULT NULL,
2897  `bitcoin_address` varchar(255) DEFAULT NULL,
2898  `paypal_address` varchar(255) DEFAULT NULL,
2899  `lat` varchar(66) DEFAULT NULL,
2900  `lon` varchar(66) DEFAULT NULL,
2901  `city` varchar(166) DEFAULT NULL,
2902  `feedback` text,
2903  `bank_id` int(22) DEFAULT NULL,
2904  `status` int(1) NOT NULL DEFAULT '0',
2905  `released` int(1) NOT NULL DEFAULT '0',
2906  PRIMARY KEY (`id`)
2907) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2908/*!40101 SET character_set_client = @saved_cs_client */;
2909
2910--
2911-- Dumping data for table `payments`
2912--
2913
2914LOCK TABLES `payments` WRITE;
2915/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
2916/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
2917UNLOCK TABLES;
2918
2919--
2920-- Table structure for table `settings`
2921--
2922
2923DROP TABLE IF EXISTS `settings`;
2924/*!40101 SET @saved_cs_client     = @@character_set_client */;
2925/*!40101 SET character_set_client = utf8 */;
2926CREATE TABLE `settings` (
2927  `id` int(255) NOT NULL AUTO_INCREMENT,
2928  `feature` varchar(166) NOT NULL,
2929  `value` text NOT NULL,
2930  PRIMARY KEY (`id`)
2931) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
2932/*!40101 SET character_set_client = @saved_cs_client */;
2933
2934--
2935-- Dumping data for table `settings`
2936--
2937
2938LOCK TABLES `settings` WRITE;
2939/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
2940INSERT INTO `settings` VALUES (1,'mailgun_domain','denizb16.com'),(2,'mailgun_key','key-3fbf4e1254de126d68ad93f023c3c3bc'),(3,'website_title','Viacoin.com'),(4,'website_keywords','put,your,keywords,here'),(5,'website_description','Put your website description here.'),(6,'stripe_test_key','sk_test_lRaYYvpFpJDzgK23PI8o2vgE'),(7,'stripe_live_key','sk_live_sWGz3dXa4AU5rJGxoB392nBM'),(8,'stripe_status','0'),(9,'block_test_key','b674-3f84-8f5d-948e'),(10,'block_live_key','7d6b-8ed3-8f9b-8a20'),(11,'block_status','1'),(12,'facebook','https://www.facebook.com/viacoin.cz'),(13,'twitter','https://www.twitter.com'),(14,'youtube','https://www.youtube.com'),(15,'google','https://www.google.com'),(16,'instagram','https://www.facebook.com'),(17,'card_commission','0'),(18,'bitcoin_commission','0'),(19,'email','info@viacoin.cz'),(20,'phone','+420773232329'),(21,'paypal_address','paypal@viacoin.cz'),(22,'bitcoin_commission_user','0'),(23,'maintenance_mode','1');
2941/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
2942UNLOCK TABLES;
2943
2944--
2945-- Table structure for table `sliders`
2946--
2947
2948DROP TABLE IF EXISTS `sliders`;
2949/*!40101 SET @saved_cs_client     = @@character_set_client */;
2950/*!40101 SET character_set_client = utf8 */;
2951CREATE TABLE `sliders` (
2952  `id` int(255) NOT NULL AUTO_INCREMENT,
2953  `title` varchar(255) NOT NULL,
2954  `description` text NOT NULL,
2955  `content` text NOT NULL,
2956  `image` varchar(255) NOT NULL,
2957  PRIMARY KEY (`id`)
2958) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
2959/*!40101 SET character_set_client = @saved_cs_client */;
2960
2961--
2962-- Dumping data for table `sliders`
2963--
2964
2965LOCK TABLES `sliders` WRITE;
2966/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
2967INSERT INTO `sliders` VALUES (4,'Secured Data','Your data is safe','In viacoin, all datas are stored with ultra encryptions.  It means your all transactions and data are always secured!','7ec7d3c64922a5d21a7bd78fbf1fa61f.png'),(5,'Easy Steps','Buy/Sell Easily','You can buy or sell Bitcoins in viacoin easily, in a few minutes!','ed28688546d44085c362b398b40478a2.png'),(6,'Fast Transactions','Time is Money','You can buy or sell Bitcoins in viacoin just in a few minutes!','d39a99992ee128221a19bc7bc92ab4b7.png'),(7,'7/24 Support','We\'re Here to Help!','Our experienced support team is working 7/24 for you!','6c965b712ed14d9c7e18690a26708b32.png'),(8,'Best Prices','Best in the Market','Viacoin\'s main target is always providing best prices for customers!','798eacbcdf89f0b2fa2f0d1fead0794f.png');
2968/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
2969UNLOCK TABLES;
2970
2971--
2972-- Table structure for table `support`
2973--
2974
2975DROP TABLE IF EXISTS `support`;
2976/*!40101 SET @saved_cs_client     = @@character_set_client */;
2977/*!40101 SET character_set_client = utf8 */;
2978CREATE TABLE `support` (
2979  `id` int(255) NOT NULL AUTO_INCREMENT,
2980  `title` varchar(255) NOT NULL,
2981  `user_id` int(255) NOT NULL,
2982  `last_reply_type` int(1) NOT NULL,
2983  `last_reply_user` int(255) NOT NULL,
2984  `last_reply_date` varchar(66) NOT NULL,
2985  `status` int(1) NOT NULL DEFAULT '0',
2986  PRIMARY KEY (`id`)
2987) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2988/*!40101 SET character_set_client = @saved_cs_client */;
2989
2990--
2991-- Dumping data for table `support`
2992--
2993
2994LOCK TABLES `support` WRITE;
2995/*!40000 ALTER TABLE `support` DISABLE KEYS */;
2996/*!40000 ALTER TABLE `support` ENABLE KEYS */;
2997UNLOCK TABLES;
2998
2999--
3000-- Table structure for table `support_files`
3001--
3002
3003DROP TABLE IF EXISTS `support_files`;
3004/*!40101 SET @saved_cs_client     = @@character_set_client */;
3005/*!40101 SET character_set_client = utf8 */;
3006CREATE TABLE `support_files` (
3007  `id` int(255) NOT NULL AUTO_INCREMENT,
3008  `message_id` int(255) NOT NULL,
3009  `file` varchar(255) NOT NULL,
3010  PRIMARY KEY (`id`)
3011) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3012/*!40101 SET character_set_client = @saved_cs_client */;
3013
3014--
3015-- Dumping data for table `support_files`
3016--
3017
3018LOCK TABLES `support_files` WRITE;
3019/*!40000 ALTER TABLE `support_files` DISABLE KEYS */;
3020/*!40000 ALTER TABLE `support_files` ENABLE KEYS */;
3021UNLOCK TABLES;
3022
3023--
3024-- Table structure for table `support_messages`
3025--
3026
3027DROP TABLE IF EXISTS `support_messages`;
3028/*!40101 SET @saved_cs_client     = @@character_set_client */;
3029/*!40101 SET character_set_client = utf8 */;
3030CREATE TABLE `support_messages` (
3031  `id` int(255) NOT NULL AUTO_INCREMENT,
3032  `ticket_id` int(255) NOT NULL,
3033  `sender_type` int(1) NOT NULL,
3034  `sender_id` int(255) NOT NULL,
3035  `message` text NOT NULL,
3036  `date` varchar(66) NOT NULL,
3037  `files` int(1) NOT NULL DEFAULT '0',
3038  PRIMARY KEY (`id`)
3039) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3040/*!40101 SET character_set_client = @saved_cs_client */;
3041
3042--
3043-- Dumping data for table `support_messages`
3044--
3045
3046LOCK TABLES `support_messages` WRITE;
3047/*!40000 ALTER TABLE `support_messages` DISABLE KEYS */;
3048/*!40000 ALTER TABLE `support_messages` ENABLE KEYS */;
3049UNLOCK TABLES;
3050
3051--
3052-- Table structure for table `transactions`
3053--
3054
3055DROP TABLE IF EXISTS `transactions`;
3056/*!40101 SET @saved_cs_client     = @@character_set_client */;
3057/*!40101 SET character_set_client = utf8 */;
3058CREATE TABLE `transactions` (
3059  `id` int(255) NOT NULL AUTO_INCREMENT,
3060  `order_id` varchar(66) NOT NULL,
3061  `user_id` int(255) NOT NULL,
3062  `amount` decimal(10,2) NOT NULL,
3063  `bitcoin_amount` int(255) DEFAULT NULL,
3064  `date` varchar(66) NOT NULL,
3065  `email` varchar(255) DEFAULT NULL,
3066  `bitcoin_address` varchar(255) DEFAULT NULL,
3067  `ip_address` varchar(15) DEFAULT NULL,
3068  `feedback` text,
3069  `status` int(1) NOT NULL DEFAULT '0',
3070  `released` int(1) NOT NULL DEFAULT '0',
3071  PRIMARY KEY (`id`)
3072) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
3073/*!40101 SET character_set_client = @saved_cs_client */;
3074
3075--
3076-- Dumping data for table `transactions`
3077--
3078
3079LOCK TABLES `transactions` WRITE;
3080/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
3081/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
3082UNLOCK TABLES;
3083
3084--
3085-- Table structure for table `users`
3086--
3087
3088DROP TABLE IF EXISTS `users`;
3089/*!40101 SET @saved_cs_client     = @@character_set_client */;
3090/*!40101 SET character_set_client = utf8 */;
3091CREATE TABLE `users` (
3092  `id` int(255) NOT NULL AUTO_INCREMENT,
3093  `username` varchar(166) NOT NULL,
3094  `email` varchar(255) NOT NULL,
3095  `password` varchar(166) NOT NULL,
3096  `balance` decimal(10,2) NOT NULL,
3097  `bitcoin` int(255) NOT NULL,
3098  `register_date` varchar(66) NOT NULL,
3099  `register_ip` varchar(15) NOT NULL,
3100  `status` int(1) NOT NULL DEFAULT '1',
3101  PRIMARY KEY (`id`)
3102) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3103/*!40101 SET character_set_client = @saved_cs_client */;
3104
3105--
3106-- Dumping data for table `users`
3107--
3108
3109LOCK TABLES `users` WRITE;
3110/*!40000 ALTER TABLE `users` DISABLE KEYS */;
3111/*!40000 ALTER TABLE `users` ENABLE KEYS */;
3112UNLOCK TABLES;
3113
3114--
3115-- Table structure for table `withdrawals`
3116--
3117
3118DROP TABLE IF EXISTS `withdrawals`;
3119/*!40101 SET @saved_cs_client     = @@character_set_client */;
3120/*!40101 SET character_set_client = utf8 */;
3121CREATE TABLE `withdrawals` (
3122  `id` int(255) NOT NULL AUTO_INCREMENT,
3123  `user_id` int(255) NOT NULL,
3124  `amount` decimal(10,2) NOT NULL,
3125  `bitcoin_amount` int(255) NOT NULL,
3126  `bitcoin_address` varchar(255) NOT NULL,
3127  `date` varchar(66) NOT NULL,
3128  `ip_address` varchar(15) NOT NULL,
3129  `bank_name` varchar(255) NOT NULL,
3130  `account_owner` varchar(255) NOT NULL,
3131  `account_number` varchar(255) NOT NULL,
3132  `iban` varchar(255) NOT NULL,
3133  `lat` varchar(66) DEFAULT NULL,
3134  `lon` varchar(66) DEFAULT NULL,
3135  `city` varchar(255) DEFAULT NULL,
3136  `paid` int(1) NOT NULL DEFAULT '0',
3137  `status` int(1) NOT NULL DEFAULT '0',
3138  PRIMARY KEY (`id`)
3139) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3140/*!40101 SET character_set_client = @saved_cs_client */;
3141
3142--
3143-- Dumping data for table `withdrawals`
3144--
3145
3146LOCK TABLES `withdrawals` WRITE;
3147/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
3148/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
3149UNLOCK TABLES;
3150
3151--
3152-- Current Database: `viacoin_hu`
3153--
3154
3155CREATE DATABASE /*!32312 IF NOT EXISTS*/ `viacoin_hu` /*!40100 DEFAULT CHARACTER SET utf8 */;
3156
3157USE `viacoin_hu`;
3158
3159--
3160-- Table structure for table `admin_types`
3161--
3162
3163DROP TABLE IF EXISTS `admin_types`;
3164/*!40101 SET @saved_cs_client     = @@character_set_client */;
3165/*!40101 SET character_set_client = utf8 */;
3166CREATE TABLE `admin_types` (
3167  `id` int(255) NOT NULL AUTO_INCREMENT,
3168  `name` varchar(166) NOT NULL,
3169  `auth` text NOT NULL,
3170  PRIMARY KEY (`id`)
3171) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
3172/*!40101 SET character_set_client = @saved_cs_client */;
3173
3174--
3175-- Dumping data for table `admin_types`
3176--
3177
3178LOCK TABLES `admin_types` WRITE;
3179/*!40000 ALTER TABLE `admin_types` DISABLE KEYS */;
3180INSERT INTO `admin_types` VALUES (1,'Admin','settings,faq,terms-of-service,privacy-policy,security,about-us,how-it-works,sliders,clients,transactions,payments,withdrawals,staff,manage,support,bank-accounts,logs'),(2,'Zkouška zaměstnanec','support,bank-accounts'),(3,'viacoin1','clients,transactions,payments,withdrawals,support');
3181/*!40000 ALTER TABLE `admin_types` ENABLE KEYS */;
3182UNLOCK TABLES;
3183
3184--
3185-- Table structure for table `admins`
3186--
3187
3188DROP TABLE IF EXISTS `admins`;
3189/*!40101 SET @saved_cs_client     = @@character_set_client */;
3190/*!40101 SET character_set_client = utf8 */;
3191CREATE TABLE `admins` (
3192  `id` int(255) NOT NULL AUTO_INCREMENT,
3193  `username` varchar(66) NOT NULL,
3194  `password` varchar(255) NOT NULL,
3195  `email` varchar(166) NOT NULL,
3196  `name` varchar(255) NOT NULL,
3197  `auth` int(255) NOT NULL,
3198  `google_auth` int(1) NOT NULL DEFAULT '0',
3199  `google_opt` varchar(66) DEFAULT NULL,
3200  `status` int(1) NOT NULL DEFAULT '1',
3201  PRIMARY KEY (`id`),
3202  KEY `auth` (`auth`)
3203) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
3204/*!40101 SET character_set_client = @saved_cs_client */;
3205
3206--
3207-- Dumping data for table `admins`
3208--
3209
3210LOCK TABLES `admins` WRITE;
3211/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
3212INSERT INTO `admins` VALUES (1,'admin','$2y$10$/58qJCCsLzsbIDRx/lwbb.JaWLUKlJ24v4wLFPsuK21Dusy8AsF5O','denizbirlik16@gmail.com','Deniz Birlik',1,2,'4AWRWNFURLFDNQLV',1),(2,'barbie','$2y$10$MH995zkU/X3ERRCZGXY4U.lX0iK0HXNazIU1CK5MBX1IeBhVcAf3.','rz8@email.cz','barbie',3,0,NULL,1);
3213/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
3214UNLOCK TABLES;
3215
3216--
3217-- Table structure for table `bank_accounts`
3218--
3219
3220DROP TABLE IF EXISTS `bank_accounts`;
3221/*!40101 SET @saved_cs_client     = @@character_set_client */;
3222/*!40101 SET character_set_client = utf8 */;
3223CREATE TABLE `bank_accounts` (
3224  `id` int(255) NOT NULL AUTO_INCREMENT,
3225  `bank_name` varchar(255) NOT NULL,
3226  `account_owner` varchar(255) NOT NULL,
3227  `account_number` varchar(166) NOT NULL,
3228  `iban` varchar(166) NOT NULL,
3229  `logo` varchar(255) NOT NULL,
3230  PRIMARY KEY (`id`)
3231) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
3232/*!40101 SET character_set_client = @saved_cs_client */;
3233
3234--
3235-- Dumping data for table `bank_accounts`
3236--
3237
3238LOCK TABLES `bank_accounts` WRITE;
3239/*!40000 ALTER TABLE `bank_accounts` DISABLE KEYS */;
3240INSERT INTO `bank_accounts` VALUES (1,'Garanti Bankası','Deniz Birlik','536-7774625','TR83 3823 8323 1239 8732 0000 0000 0233 01','4869a330ca41f4816aeed121ee42715e.jpg'),(2,'mBank','BreBank','670100-2205647536/6210','CZ37 6210 6701 0022 0564 7536','79714ed2cb3c0a0587888eca9bf93791.jpg'),(3,'Raiffeisen bank','Raiffeisen bank','78100909/5500','CZ37 6210 6701 0022 0564 7536 ','6b1c7f9fba55afdc4e43790181d0de53.jpg');
3241/*!40000 ALTER TABLE `bank_accounts` ENABLE KEYS */;
3242UNLOCK TABLES;
3243
3244--
3245-- Table structure for table `content`
3246--
3247
3248DROP TABLE IF EXISTS `content`;
3249/*!40101 SET @saved_cs_client     = @@character_set_client */;
3250/*!40101 SET character_set_client = utf8 */;
3251CREATE TABLE `content` (
3252  `id` int(255) NOT NULL AUTO_INCREMENT,
3253  `feature` varchar(255) NOT NULL,
3254  `value` text NOT NULL,
3255  PRIMARY KEY (`id`)
3256) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
3257/*!40101 SET character_set_client = @saved_cs_client */;
3258
3259--
3260-- Dumping data for table `content`
3261--
3262
3263LOCK TABLES `content` WRITE;
3264/*!40000 ALTER TABLE `content` DISABLE KEYS */;
3265INSERT INTO `content` VALUES (1,'security','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut sed pellentesque sem, id placerat enim. Suspendisse pharetra hendrerit felis, ac scelerisque sem posuere et. Phasellus hendrerit est eu ligula posuere, non bibendum dui finibus. Nam odio urna, egestas id maximus in, tincidunt non odio. Nulla facilisi. Nullam cursus quis magna sit amet interdum. Donec iaculis bibendum accumsan.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Nullam vitae eros ex.&nbsp;</font></p>'),(2,'terms_of_service','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Suspendisse potenti. Duis vitae suscipit dui, non pulvinar mauris. Interdum et malesuada fames ac ante ipsum primis in faucibus. Suspendisse augue massa, convallis vitae scelerisque vitae, auctor eu erat. </font></span></p><p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Mauris venenatis dictum justo non ullamcorper. Quisque eu facilisis erat.</font></span></p>'),(3,'about_us','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Maecenas in felis mauris. Mauris dictum massa non pharetra lacinia. Vivamus ut libero orci. Maecenas vitae volutpat sem. Pellentesque ultrices tempus mi, id feugiat nunc interdum sit amet. </font></span></p><p><span style=\"font-family: Verdana; color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\">Vestibulum nec nulla et odio lacinia hendrerit nec nec ex. Praesent placerat nulla eget dolor lobortis commodo. Praesent laoreet felis ut purus dignissim mollis.</span><br></p>'),(4,'privacy_policy','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Mauris hendrerit, elit cursus auctor cursus, enim urna hendrerit eros, sit amet porta dui mauris posuere diam. Pellentesque tempor libero a est viverra faucibus. Vivamus laoreet vulputate nunc quis finibus. Nam dapibus, erat vel tincidunt vehicula, diam eros finibus dolor, quis ultricies massa neque sed purus. Nunc nec est erat. Praesent eget tincidunt eros. Sed gravida placerat ex, venenatis hendrerit tortor facilisis vitae. Mauris faucibus, sem id placerat condimentum, nisl velit sollicitudin urna, in ornare lectus purus in erat.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Sed euismod ultrices ex, et porttitor erat vulputate ac.</font></p>'),(5,'how_it_works','Put how it works content here.');
3266/*!40000 ALTER TABLE `content` ENABLE KEYS */;
3267UNLOCK TABLES;
3268
3269--
3270-- Table structure for table `faq`
3271--
3272
3273DROP TABLE IF EXISTS `faq`;
3274/*!40101 SET @saved_cs_client     = @@character_set_client */;
3275/*!40101 SET character_set_client = utf8 */;
3276CREATE TABLE `faq` (
3277  `id` int(255) NOT NULL AUTO_INCREMENT,
3278  `question` text NOT NULL,
3279  `answer` text NOT NULL,
3280  PRIMARY KEY (`id`)
3281) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
3282/*!40101 SET character_set_client = @saved_cs_client */;
3283
3284--
3285-- Dumping data for table `faq`
3286--
3287
3288LOCK TABLES `faq` WRITE;
3289/*!40000 ALTER TABLE `faq` DISABLE KEYS */;
3290INSERT INTO `faq` VALUES (1,'Put your first question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(2,'Put your second question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(3,'Put your third question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(4,'Put your fourth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(5,'Put your fifth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. ');
3291/*!40000 ALTER TABLE `faq` ENABLE KEYS */;
3292UNLOCK TABLES;
3293
3294--
3295-- Table structure for table `logs`
3296--
3297
3298DROP TABLE IF EXISTS `logs`;
3299/*!40101 SET @saved_cs_client     = @@character_set_client */;
3300/*!40101 SET character_set_client = utf8 */;
3301CREATE TABLE `logs` (
3302  `id` int(255) NOT NULL AUTO_INCREMENT,
3303  `user_id` int(255) NOT NULL,
3304  `date` varchar(66) NOT NULL,
3305  `ip_address` varchar(15) NOT NULL,
3306  `action` varchar(255) NOT NULL,
3307  PRIMARY KEY (`id`)
3308) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
3309/*!40101 SET character_set_client = @saved_cs_client */;
3310
3311--
3312-- Dumping data for table `logs`
3313--
3314
3315LOCK TABLES `logs` WRITE;
3316/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
3317INSERT INTO `logs` VALUES (1,1,'1487187282','178.41.76.146','Admin logged in. ID: 1'),(2,1,'1487187296','178.41.76.146','General settings updated.'),(3,1,'1487187313','178.41.76.146','General settings updated.');
3318/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
3319UNLOCK TABLES;
3320
3321--
3322-- Table structure for table `payments`
3323--
3324
3325DROP TABLE IF EXISTS `payments`;
3326/*!40101 SET @saved_cs_client     = @@character_set_client */;
3327/*!40101 SET character_set_client = utf8 */;
3328CREATE TABLE `payments` (
3329  `id` int(255) NOT NULL AUTO_INCREMENT,
3330  `tx_id` varchar(255) DEFAULT NULL,
3331  `order_id` varchar(66) NOT NULL,
3332  `user_id` int(255) NOT NULL,
3333  `type` int(1) DEFAULT NULL,
3334  `amount` decimal(10,2) NOT NULL,
3335  `bitcoin_amount` int(255) DEFAULT NULL,
3336  `date` varchar(66) NOT NULL,
3337  `complete_date` varchar(66) DEFAULT NULL,
3338  `ip_address` varchar(15) NOT NULL,
3339  `step` int(1) NOT NULL DEFAULT '2',
3340  `email` varchar(255) DEFAULT NULL,
3341  `bitcoin_address` varchar(255) DEFAULT NULL,
3342  `paypal_address` varchar(255) DEFAULT NULL,
3343  `lat` varchar(66) DEFAULT NULL,
3344  `lon` varchar(66) DEFAULT NULL,
3345  `city` varchar(166) DEFAULT NULL,
3346  `feedback` text,
3347  `bank_id` int(22) DEFAULT NULL,
3348  `status` int(1) NOT NULL DEFAULT '0',
3349  `released` int(1) NOT NULL DEFAULT '0',
3350  PRIMARY KEY (`id`)
3351) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3352/*!40101 SET character_set_client = @saved_cs_client */;
3353
3354--
3355-- Dumping data for table `payments`
3356--
3357
3358LOCK TABLES `payments` WRITE;
3359/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
3360/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
3361UNLOCK TABLES;
3362
3363--
3364-- Table structure for table `settings`
3365--
3366
3367DROP TABLE IF EXISTS `settings`;
3368/*!40101 SET @saved_cs_client     = @@character_set_client */;
3369/*!40101 SET character_set_client = utf8 */;
3370CREATE TABLE `settings` (
3371  `id` int(255) NOT NULL AUTO_INCREMENT,
3372  `feature` varchar(166) NOT NULL,
3373  `value` text NOT NULL,
3374  PRIMARY KEY (`id`)
3375) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
3376/*!40101 SET character_set_client = @saved_cs_client */;
3377
3378--
3379-- Dumping data for table `settings`
3380--
3381
3382LOCK TABLES `settings` WRITE;
3383/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
3384INSERT INTO `settings` VALUES (1,'mailgun_domain','denizb16.com'),(2,'mailgun_key','key-3fbf4e1254de126d68ad93f023c3c3bc'),(3,'website_title','Viacoin.com'),(4,'website_keywords','put,your,keywords,here'),(5,'website_description','Put your website description here.'),(6,'stripe_test_key','sk_test_lRaYYvpFpJDzgK23PI8o2vgE'),(7,'stripe_live_key','sk_live_sWGz3dXa4AU5rJGxoB392nBM'),(8,'stripe_status','0'),(9,'block_test_key','b674-3f84-8f5d-948e'),(10,'block_live_key','7d6b-8ed3-8f9b-8a20'),(11,'block_status','1'),(12,'facebook','https://www.facebook.com/viacoin.cz'),(13,'twitter','https://www.twitter.com'),(14,'youtube','https://www.youtube.com'),(15,'google','https://www.google.com'),(16,'instagram','https://www.facebook.com'),(17,'card_commission','0'),(18,'bitcoin_commission','0'),(19,'email','info@viacoin.cz'),(20,'phone','+420773232329'),(21,'paypal_address','paypal@viacoin.cz'),(22,'bitcoin_commission_user','0'),(23,'maintenance_mode','1');
3385/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
3386UNLOCK TABLES;
3387
3388--
3389-- Table structure for table `sliders`
3390--
3391
3392DROP TABLE IF EXISTS `sliders`;
3393/*!40101 SET @saved_cs_client     = @@character_set_client */;
3394/*!40101 SET character_set_client = utf8 */;
3395CREATE TABLE `sliders` (
3396  `id` int(255) NOT NULL AUTO_INCREMENT,
3397  `title` varchar(255) NOT NULL,
3398  `description` text NOT NULL,
3399  `content` text NOT NULL,
3400  `image` varchar(255) NOT NULL,
3401  PRIMARY KEY (`id`)
3402) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
3403/*!40101 SET character_set_client = @saved_cs_client */;
3404
3405--
3406-- Dumping data for table `sliders`
3407--
3408
3409LOCK TABLES `sliders` WRITE;
3410/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
3411INSERT INTO `sliders` VALUES (4,'Secured Data','Your data is safe','In viacoin, all datas are stored with ultra encryptions.  It means your all transactions and data are always secured!','7ec7d3c64922a5d21a7bd78fbf1fa61f.png'),(5,'Easy Steps','Buy/Sell Easily','You can buy or sell Bitcoins in viacoin easily, in a few minutes!','ed28688546d44085c362b398b40478a2.png'),(6,'Fast Transactions','Time is Money','You can buy or sell Bitcoins in viacoin just in a few minutes!','d39a99992ee128221a19bc7bc92ab4b7.png'),(7,'7/24 Support','We\'re Here to Help!','Our experienced support team is working 7/24 for you!','6c965b712ed14d9c7e18690a26708b32.png'),(8,'Best Prices','Best in the Market','Viacoin\'s main target is always providing best prices for customers!','798eacbcdf89f0b2fa2f0d1fead0794f.png');
3412/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
3413UNLOCK TABLES;
3414
3415--
3416-- Table structure for table `support`
3417--
3418
3419DROP TABLE IF EXISTS `support`;
3420/*!40101 SET @saved_cs_client     = @@character_set_client */;
3421/*!40101 SET character_set_client = utf8 */;
3422CREATE TABLE `support` (
3423  `id` int(255) NOT NULL AUTO_INCREMENT,
3424  `title` varchar(255) NOT NULL,
3425  `user_id` int(255) NOT NULL,
3426  `last_reply_type` int(1) NOT NULL,
3427  `last_reply_user` int(255) NOT NULL,
3428  `last_reply_date` varchar(66) NOT NULL,
3429  `status` int(1) NOT NULL DEFAULT '0',
3430  PRIMARY KEY (`id`)
3431) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3432/*!40101 SET character_set_client = @saved_cs_client */;
3433
3434--
3435-- Dumping data for table `support`
3436--
3437
3438LOCK TABLES `support` WRITE;
3439/*!40000 ALTER TABLE `support` DISABLE KEYS */;
3440/*!40000 ALTER TABLE `support` ENABLE KEYS */;
3441UNLOCK TABLES;
3442
3443--
3444-- Table structure for table `support_files`
3445--
3446
3447DROP TABLE IF EXISTS `support_files`;
3448/*!40101 SET @saved_cs_client     = @@character_set_client */;
3449/*!40101 SET character_set_client = utf8 */;
3450CREATE TABLE `support_files` (
3451  `id` int(255) NOT NULL AUTO_INCREMENT,
3452  `message_id` int(255) NOT NULL,
3453  `file` varchar(255) NOT NULL,
3454  PRIMARY KEY (`id`)
3455) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3456/*!40101 SET character_set_client = @saved_cs_client */;
3457
3458--
3459-- Dumping data for table `support_files`
3460--
3461
3462LOCK TABLES `support_files` WRITE;
3463/*!40000 ALTER TABLE `support_files` DISABLE KEYS */;
3464/*!40000 ALTER TABLE `support_files` ENABLE KEYS */;
3465UNLOCK TABLES;
3466
3467--
3468-- Table structure for table `support_messages`
3469--
3470
3471DROP TABLE IF EXISTS `support_messages`;
3472/*!40101 SET @saved_cs_client     = @@character_set_client */;
3473/*!40101 SET character_set_client = utf8 */;
3474CREATE TABLE `support_messages` (
3475  `id` int(255) NOT NULL AUTO_INCREMENT,
3476  `ticket_id` int(255) NOT NULL,
3477  `sender_type` int(1) NOT NULL,
3478  `sender_id` int(255) NOT NULL,
3479  `message` text NOT NULL,
3480  `date` varchar(66) NOT NULL,
3481  `files` int(1) NOT NULL DEFAULT '0',
3482  PRIMARY KEY (`id`)
3483) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3484/*!40101 SET character_set_client = @saved_cs_client */;
3485
3486--
3487-- Dumping data for table `support_messages`
3488--
3489
3490LOCK TABLES `support_messages` WRITE;
3491/*!40000 ALTER TABLE `support_messages` DISABLE KEYS */;
3492/*!40000 ALTER TABLE `support_messages` ENABLE KEYS */;
3493UNLOCK TABLES;
3494
3495--
3496-- Table structure for table `transactions`
3497--
3498
3499DROP TABLE IF EXISTS `transactions`;
3500/*!40101 SET @saved_cs_client     = @@character_set_client */;
3501/*!40101 SET character_set_client = utf8 */;
3502CREATE TABLE `transactions` (
3503  `id` int(255) NOT NULL AUTO_INCREMENT,
3504  `order_id` varchar(66) NOT NULL,
3505  `user_id` int(255) NOT NULL,
3506  `amount` decimal(10,2) NOT NULL,
3507  `bitcoin_amount` int(255) DEFAULT NULL,
3508  `date` varchar(66) NOT NULL,
3509  `email` varchar(255) DEFAULT NULL,
3510  `bitcoin_address` varchar(255) DEFAULT NULL,
3511  `ip_address` varchar(15) DEFAULT NULL,
3512  `feedback` text,
3513  `status` int(1) NOT NULL DEFAULT '0',
3514  `released` int(1) NOT NULL DEFAULT '0',
3515  PRIMARY KEY (`id`)
3516) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
3517/*!40101 SET character_set_client = @saved_cs_client */;
3518
3519--
3520-- Dumping data for table `transactions`
3521--
3522
3523LOCK TABLES `transactions` WRITE;
3524/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
3525/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
3526UNLOCK TABLES;
3527
3528--
3529-- Table structure for table `users`
3530--
3531
3532DROP TABLE IF EXISTS `users`;
3533/*!40101 SET @saved_cs_client     = @@character_set_client */;
3534/*!40101 SET character_set_client = utf8 */;
3535CREATE TABLE `users` (
3536  `id` int(255) NOT NULL AUTO_INCREMENT,
3537  `username` varchar(166) NOT NULL,
3538  `email` varchar(255) NOT NULL,
3539  `password` varchar(166) NOT NULL,
3540  `balance` decimal(10,2) NOT NULL,
3541  `bitcoin` int(255) NOT NULL,
3542  `register_date` varchar(66) NOT NULL,
3543  `register_ip` varchar(15) NOT NULL,
3544  `status` int(1) NOT NULL DEFAULT '1',
3545  PRIMARY KEY (`id`)
3546) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3547/*!40101 SET character_set_client = @saved_cs_client */;
3548
3549--
3550-- Dumping data for table `users`
3551--
3552
3553LOCK TABLES `users` WRITE;
3554/*!40000 ALTER TABLE `users` DISABLE KEYS */;
3555/*!40000 ALTER TABLE `users` ENABLE KEYS */;
3556UNLOCK TABLES;
3557
3558--
3559-- Table structure for table `withdrawals`
3560--
3561
3562DROP TABLE IF EXISTS `withdrawals`;
3563/*!40101 SET @saved_cs_client     = @@character_set_client */;
3564/*!40101 SET character_set_client = utf8 */;
3565CREATE TABLE `withdrawals` (
3566  `id` int(255) NOT NULL AUTO_INCREMENT,
3567  `user_id` int(255) NOT NULL,
3568  `amount` decimal(10,2) NOT NULL,
3569  `bitcoin_amount` int(255) NOT NULL,
3570  `bitcoin_address` varchar(255) NOT NULL,
3571  `date` varchar(66) NOT NULL,
3572  `ip_address` varchar(15) NOT NULL,
3573  `bank_name` varchar(255) NOT NULL,
3574  `account_owner` varchar(255) NOT NULL,
3575  `account_number` varchar(255) NOT NULL,
3576  `iban` varchar(255) NOT NULL,
3577  `lat` varchar(66) DEFAULT NULL,
3578  `lon` varchar(66) DEFAULT NULL,
3579  `city` varchar(255) DEFAULT NULL,
3580  `paid` int(1) NOT NULL DEFAULT '0',
3581  `status` int(1) NOT NULL DEFAULT '0',
3582  PRIMARY KEY (`id`)
3583) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3584/*!40101 SET character_set_client = @saved_cs_client */;
3585
3586--
3587-- Dumping data for table `withdrawals`
3588--
3589
3590LOCK TABLES `withdrawals` WRITE;
3591/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
3592/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
3593UNLOCK TABLES;
3594
3595--
3596-- Current Database: `viacoin_info`
3597--
3598
3599CREATE DATABASE /*!32312 IF NOT EXISTS*/ `viacoin_info` /*!40100 DEFAULT CHARACTER SET utf8 */;
3600
3601USE `viacoin_info`;
3602
3603--
3604-- Table structure for table `admin_types`
3605--
3606
3607DROP TABLE IF EXISTS `admin_types`;
3608/*!40101 SET @saved_cs_client     = @@character_set_client */;
3609/*!40101 SET character_set_client = utf8 */;
3610CREATE TABLE `admin_types` (
3611  `id` int(255) NOT NULL AUTO_INCREMENT,
3612  `name` varchar(166) NOT NULL,
3613  `auth` text NOT NULL,
3614  PRIMARY KEY (`id`)
3615) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
3616/*!40101 SET character_set_client = @saved_cs_client */;
3617
3618--
3619-- Dumping data for table `admin_types`
3620--
3621
3622LOCK TABLES `admin_types` WRITE;
3623/*!40000 ALTER TABLE `admin_types` DISABLE KEYS */;
3624INSERT INTO `admin_types` VALUES (1,'Admin','settings,faq,terms-of-service,privacy-policy,security,about-us,how-it-works,sliders,clients,transactions,payments,withdrawals,staff,manage,support,bank-accounts,logs'),(2,'Zkouška zaměstnanec','support,bank-accounts'),(3,'viacoin1','clients,transactions,payments,withdrawals,support');
3625/*!40000 ALTER TABLE `admin_types` ENABLE KEYS */;
3626UNLOCK TABLES;
3627
3628--
3629-- Table structure for table `admins`
3630--
3631
3632DROP TABLE IF EXISTS `admins`;
3633/*!40101 SET @saved_cs_client     = @@character_set_client */;
3634/*!40101 SET character_set_client = utf8 */;
3635CREATE TABLE `admins` (
3636  `id` int(255) NOT NULL AUTO_INCREMENT,
3637  `username` varchar(66) NOT NULL,
3638  `password` varchar(255) NOT NULL,
3639  `email` varchar(166) NOT NULL,
3640  `name` varchar(255) NOT NULL,
3641  `auth` int(255) NOT NULL,
3642  `google_auth` int(1) NOT NULL DEFAULT '0',
3643  `google_opt` varchar(66) DEFAULT NULL,
3644  `status` int(1) NOT NULL DEFAULT '1',
3645  PRIMARY KEY (`id`),
3646  KEY `auth` (`auth`)
3647) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
3648/*!40101 SET character_set_client = @saved_cs_client */;
3649
3650--
3651-- Dumping data for table `admins`
3652--
3653
3654LOCK TABLES `admins` WRITE;
3655/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
3656INSERT INTO `admins` VALUES (1,'admin','$2y$10$/58qJCCsLzsbIDRx/lwbb.JaWLUKlJ24v4wLFPsuK21Dusy8AsF5O','denizbirlik16@gmail.com','Deniz Birlik',1,2,'4AWRWNFURLFDNQLV',1),(2,'barbie','$2y$10$MH995zkU/X3ERRCZGXY4U.lX0iK0HXNazIU1CK5MBX1IeBhVcAf3.','rz8@email.cz','barbie',3,0,NULL,1);
3657/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
3658UNLOCK TABLES;
3659
3660--
3661-- Table structure for table `bank_accounts`
3662--
3663
3664DROP TABLE IF EXISTS `bank_accounts`;
3665/*!40101 SET @saved_cs_client     = @@character_set_client */;
3666/*!40101 SET character_set_client = utf8 */;
3667CREATE TABLE `bank_accounts` (
3668  `id` int(255) NOT NULL AUTO_INCREMENT,
3669  `bank_name` varchar(255) NOT NULL,
3670  `account_owner` varchar(255) NOT NULL,
3671  `account_number` varchar(166) NOT NULL,
3672  `iban` varchar(166) NOT NULL,
3673  `logo` varchar(255) NOT NULL,
3674  PRIMARY KEY (`id`)
3675) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
3676/*!40101 SET character_set_client = @saved_cs_client */;
3677
3678--
3679-- Dumping data for table `bank_accounts`
3680--
3681
3682LOCK TABLES `bank_accounts` WRITE;
3683/*!40000 ALTER TABLE `bank_accounts` DISABLE KEYS */;
3684INSERT INTO `bank_accounts` VALUES (1,'Garanti Bankası','Deniz Birlik','536-7774625','TR83 3823 8323 1239 8732 0000 0000 0233 01','4869a330ca41f4816aeed121ee42715e.jpg'),(2,'mBank','BreBank','670100-2205647536/6210','CZ37 6210 6701 0022 0564 7536','79714ed2cb3c0a0587888eca9bf93791.jpg'),(3,'Raiffeisen bank','Raiffeisen bank','78100909/5500','CZ37 6210 6701 0022 0564 7536 ','6b1c7f9fba55afdc4e43790181d0de53.jpg');
3685/*!40000 ALTER TABLE `bank_accounts` ENABLE KEYS */;
3686UNLOCK TABLES;
3687
3688--
3689-- Table structure for table `content`
3690--
3691
3692DROP TABLE IF EXISTS `content`;
3693/*!40101 SET @saved_cs_client     = @@character_set_client */;
3694/*!40101 SET character_set_client = utf8 */;
3695CREATE TABLE `content` (
3696  `id` int(255) NOT NULL AUTO_INCREMENT,
3697  `feature` varchar(255) NOT NULL,
3698  `value` text NOT NULL,
3699  PRIMARY KEY (`id`)
3700) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
3701/*!40101 SET character_set_client = @saved_cs_client */;
3702
3703--
3704-- Dumping data for table `content`
3705--
3706
3707LOCK TABLES `content` WRITE;
3708/*!40000 ALTER TABLE `content` DISABLE KEYS */;
3709INSERT INTO `content` VALUES (1,'security','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut sed pellentesque sem, id placerat enim. Suspendisse pharetra hendrerit felis, ac scelerisque sem posuere et. Phasellus hendrerit est eu ligula posuere, non bibendum dui finibus. Nam odio urna, egestas id maximus in, tincidunt non odio. Nulla facilisi. Nullam cursus quis magna sit amet interdum. Donec iaculis bibendum accumsan.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Nullam vitae eros ex.&nbsp;</font></p>'),(2,'terms_of_service','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Suspendisse potenti. Duis vitae suscipit dui, non pulvinar mauris. Interdum et malesuada fames ac ante ipsum primis in faucibus. Suspendisse augue massa, convallis vitae scelerisque vitae, auctor eu erat. </font></span></p><p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Mauris venenatis dictum justo non ullamcorper. Quisque eu facilisis erat.</font></span></p>'),(3,'about_us','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Maecenas in felis mauris. Mauris dictum massa non pharetra lacinia. Vivamus ut libero orci. Maecenas vitae volutpat sem. Pellentesque ultrices tempus mi, id feugiat nunc interdum sit amet. </font></span></p><p><span style=\"font-family: Verdana; color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\">Vestibulum nec nulla et odio lacinia hendrerit nec nec ex. Praesent placerat nulla eget dolor lobortis commodo. Praesent laoreet felis ut purus dignissim mollis.</span><br></p>'),(4,'privacy_policy','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Mauris hendrerit, elit cursus auctor cursus, enim urna hendrerit eros, sit amet porta dui mauris posuere diam. Pellentesque tempor libero a est viverra faucibus. Vivamus laoreet vulputate nunc quis finibus. Nam dapibus, erat vel tincidunt vehicula, diam eros finibus dolor, quis ultricies massa neque sed purus. Nunc nec est erat. Praesent eget tincidunt eros. Sed gravida placerat ex, venenatis hendrerit tortor facilisis vitae. Mauris faucibus, sem id placerat condimentum, nisl velit sollicitudin urna, in ornare lectus purus in erat.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Sed euismod ultrices ex, et porttitor erat vulputate ac.</font></p>'),(5,'how_it_works','Put how it works content here.');
3710/*!40000 ALTER TABLE `content` ENABLE KEYS */;
3711UNLOCK TABLES;
3712
3713--
3714-- Table structure for table `faq`
3715--
3716
3717DROP TABLE IF EXISTS `faq`;
3718/*!40101 SET @saved_cs_client     = @@character_set_client */;
3719/*!40101 SET character_set_client = utf8 */;
3720CREATE TABLE `faq` (
3721  `id` int(255) NOT NULL AUTO_INCREMENT,
3722  `question` text NOT NULL,
3723  `answer` text NOT NULL,
3724  PRIMARY KEY (`id`)
3725) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
3726/*!40101 SET character_set_client = @saved_cs_client */;
3727
3728--
3729-- Dumping data for table `faq`
3730--
3731
3732LOCK TABLES `faq` WRITE;
3733/*!40000 ALTER TABLE `faq` DISABLE KEYS */;
3734INSERT INTO `faq` VALUES (1,'Put your first question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(2,'Put your second question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(3,'Put your third question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(4,'Put your fourth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(5,'Put your fifth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. ');
3735/*!40000 ALTER TABLE `faq` ENABLE KEYS */;
3736UNLOCK TABLES;
3737
3738--
3739-- Table structure for table `logs`
3740--
3741
3742DROP TABLE IF EXISTS `logs`;
3743/*!40101 SET @saved_cs_client     = @@character_set_client */;
3744/*!40101 SET character_set_client = utf8 */;
3745CREATE TABLE `logs` (
3746  `id` int(255) NOT NULL AUTO_INCREMENT,
3747  `user_id` int(255) NOT NULL,
3748  `date` varchar(66) NOT NULL,
3749  `ip_address` varchar(15) NOT NULL,
3750  `action` varchar(255) NOT NULL,
3751  PRIMARY KEY (`id`)
3752) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
3753/*!40101 SET character_set_client = @saved_cs_client */;
3754
3755--
3756-- Dumping data for table `logs`
3757--
3758
3759LOCK TABLES `logs` WRITE;
3760/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
3761INSERT INTO `logs` VALUES (1,1,'1487263288','178.41.76.146','Admin logged in. ID: 1'),(2,1,'1487263485','128.0.176.198','Admin logged in. ID: 1'),(3,1,'1487263832','178.41.76.146','General settings updated.'),(4,1,'1487264067','178.41.76.146','Withdrawal deleted. ID: 1'),(5,1,'1487264259','178.41.76.146','Withdrawal completed. ID: 2'),(6,1,'1487264556','178.41.76.146','Payment deleted. ID: 1'),(7,1,'1487265116','178.41.76.146','General settings updated.'),(8,1,'1487265259','178.41.76.146','General settings updated.'),(9,1,'1487265268','178.41.76.146','General settings updated.'),(10,1,'1487265278','178.41.76.146','General settings updated.'),(11,1,'1487265297','178.41.76.146','General settings updated.'),(12,1,'1487265316','178.41.76.146','General settings updated.'),(13,1,'1487266276','178.41.76.146','General settings updated.'),(14,1,'1487266431','178.41.76.146','General settings updated.');
3762/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
3763UNLOCK TABLES;
3764
3765--
3766-- Table structure for table `payments`
3767--
3768
3769DROP TABLE IF EXISTS `payments`;
3770/*!40101 SET @saved_cs_client     = @@character_set_client */;
3771/*!40101 SET character_set_client = utf8 */;
3772CREATE TABLE `payments` (
3773  `id` int(255) NOT NULL AUTO_INCREMENT,
3774  `tx_id` varchar(255) DEFAULT NULL,
3775  `order_id` varchar(66) NOT NULL,
3776  `user_id` int(255) NOT NULL,
3777  `type` int(1) DEFAULT NULL,
3778  `amount` decimal(10,2) NOT NULL,
3779  `bitcoin_amount` int(255) DEFAULT NULL,
3780  `date` varchar(66) NOT NULL,
3781  `complete_date` varchar(66) DEFAULT NULL,
3782  `ip_address` varchar(15) NOT NULL,
3783  `step` int(1) NOT NULL DEFAULT '2',
3784  `email` varchar(255) DEFAULT NULL,
3785  `bitcoin_address` varchar(255) DEFAULT NULL,
3786  `paypal_address` varchar(255) DEFAULT NULL,
3787  `lat` varchar(66) DEFAULT NULL,
3788  `lon` varchar(66) DEFAULT NULL,
3789  `city` varchar(166) DEFAULT NULL,
3790  `feedback` text,
3791  `bank_id` int(22) DEFAULT NULL,
3792  `status` int(1) NOT NULL DEFAULT '0',
3793  `released` int(1) NOT NULL DEFAULT '0',
3794  PRIMARY KEY (`id`)
3795) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
3796/*!40101 SET character_set_client = @saved_cs_client */;
3797
3798--
3799-- Dumping data for table `payments`
3800--
3801
3802LOCK TABLES `payments` WRITE;
3803/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
3804INSERT INTO `payments` VALUES (3,NULL,'zD689JPdYtKBA1sIXRFq5kjUSvn0cVwmT47OfEpZ',0,2,0.27,29967,'1487265348',NULL,'128.0.176.198',4,'jan.pecina@centrum.cz','1DXgkv4UNa8xUYfsD4HqxX4jKzmbpakibk','jan.pecina@centrum.cz','49.8119','18.2553','Ostrava',NULL,NULL,0,0);
3805/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
3806UNLOCK TABLES;
3807
3808--
3809-- Table structure for table `settings`
3810--
3811
3812DROP TABLE IF EXISTS `settings`;
3813/*!40101 SET @saved_cs_client     = @@character_set_client */;
3814/*!40101 SET character_set_client = utf8 */;
3815CREATE TABLE `settings` (
3816  `id` int(255) NOT NULL AUTO_INCREMENT,
3817  `feature` varchar(166) NOT NULL,
3818  `value` text NOT NULL,
3819  PRIMARY KEY (`id`)
3820) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
3821/*!40101 SET character_set_client = @saved_cs_client */;
3822
3823--
3824-- Dumping data for table `settings`
3825--
3826
3827LOCK TABLES `settings` WRITE;
3828/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
3829INSERT INTO `settings` VALUES (1,'mailgun_domain','denizb16.com'),(2,'mailgun_key','key-3fbf4e1254de126d68ad93f023c3c3bc'),(3,'website_title','Viacoin.com'),(4,'website_keywords','put,your,keywords,here'),(5,'website_description','Put your website description here.'),(6,'stripe_test_key','sk_test_lRaYYvpFpJDzgK23PI8o2vgE'),(7,'stripe_live_key','sk_live_sWGz3dXa4AU5rJGxoB392nBM'),(8,'stripe_status','0'),(9,'block_test_key','b674-3f84-8f5d-948e'),(10,'block_live_key','7d6b-8ed3-8f9b-8a20'),(11,'block_status','1'),(12,'facebook','https://www.facebook.com/viacoin.cz'),(13,'twitter','https://www.twitter.com'),(14,'youtube','https://www.youtube.com'),(15,'google','https://www.google.com'),(16,'instagram','https://www.facebook.com'),(17,'card_commission','0'),(18,'bitcoin_commission','0'),(19,'email','info@viacoin.cz'),(20,'phone','+420773232329'),(21,'paypal_address','paypal@viacoin.cz'),(22,'bitcoin_commission_user','0'),(23,'maintenance_mode','1');
3830/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
3831UNLOCK TABLES;
3832
3833--
3834-- Table structure for table `sliders`
3835--
3836
3837DROP TABLE IF EXISTS `sliders`;
3838/*!40101 SET @saved_cs_client     = @@character_set_client */;
3839/*!40101 SET character_set_client = utf8 */;
3840CREATE TABLE `sliders` (
3841  `id` int(255) NOT NULL AUTO_INCREMENT,
3842  `title` varchar(255) NOT NULL,
3843  `description` text NOT NULL,
3844  `content` text NOT NULL,
3845  `image` varchar(255) NOT NULL,
3846  PRIMARY KEY (`id`)
3847) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
3848/*!40101 SET character_set_client = @saved_cs_client */;
3849
3850--
3851-- Dumping data for table `sliders`
3852--
3853
3854LOCK TABLES `sliders` WRITE;
3855/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
3856INSERT INTO `sliders` VALUES (4,'Secured Data','Your data is safe','In viacoin, all datas are stored with ultra encryptions.  It means your all transactions and data are always secured!','7ec7d3c64922a5d21a7bd78fbf1fa61f.png'),(5,'Easy Steps','Buy/Sell Easily','You can buy or sell Bitcoins in viacoin easily, in a few minutes!','ed28688546d44085c362b398b40478a2.png'),(6,'Fast Transactions','Time is Money','You can buy or sell Bitcoins in viacoin just in a few minutes!','d39a99992ee128221a19bc7bc92ab4b7.png'),(7,'7/24 Support','We\'re Here to Help!','Our experienced support team is working 7/24 for you!','6c965b712ed14d9c7e18690a26708b32.png'),(8,'Best Prices','Best in the Market','Viacoin\'s main target is always providing best prices for customers!','798eacbcdf89f0b2fa2f0d1fead0794f.png');
3857/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
3858UNLOCK TABLES;
3859
3860--
3861-- Table structure for table `support`
3862--
3863
3864DROP TABLE IF EXISTS `support`;
3865/*!40101 SET @saved_cs_client     = @@character_set_client */;
3866/*!40101 SET character_set_client = utf8 */;
3867CREATE TABLE `support` (
3868  `id` int(255) NOT NULL AUTO_INCREMENT,
3869  `title` varchar(255) NOT NULL,
3870  `user_id` int(255) NOT NULL,
3871  `last_reply_type` int(1) NOT NULL,
3872  `last_reply_user` int(255) NOT NULL,
3873  `last_reply_date` varchar(66) NOT NULL,
3874  `status` int(1) NOT NULL DEFAULT '0',
3875  PRIMARY KEY (`id`)
3876) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3877/*!40101 SET character_set_client = @saved_cs_client */;
3878
3879--
3880-- Dumping data for table `support`
3881--
3882
3883LOCK TABLES `support` WRITE;
3884/*!40000 ALTER TABLE `support` DISABLE KEYS */;
3885/*!40000 ALTER TABLE `support` ENABLE KEYS */;
3886UNLOCK TABLES;
3887
3888--
3889-- Table structure for table `support_files`
3890--
3891
3892DROP TABLE IF EXISTS `support_files`;
3893/*!40101 SET @saved_cs_client     = @@character_set_client */;
3894/*!40101 SET character_set_client = utf8 */;
3895CREATE TABLE `support_files` (
3896  `id` int(255) NOT NULL AUTO_INCREMENT,
3897  `message_id` int(255) NOT NULL,
3898  `file` varchar(255) NOT NULL,
3899  PRIMARY KEY (`id`)
3900) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3901/*!40101 SET character_set_client = @saved_cs_client */;
3902
3903--
3904-- Dumping data for table `support_files`
3905--
3906
3907LOCK TABLES `support_files` WRITE;
3908/*!40000 ALTER TABLE `support_files` DISABLE KEYS */;
3909/*!40000 ALTER TABLE `support_files` ENABLE KEYS */;
3910UNLOCK TABLES;
3911
3912--
3913-- Table structure for table `support_messages`
3914--
3915
3916DROP TABLE IF EXISTS `support_messages`;
3917/*!40101 SET @saved_cs_client     = @@character_set_client */;
3918/*!40101 SET character_set_client = utf8 */;
3919CREATE TABLE `support_messages` (
3920  `id` int(255) NOT NULL AUTO_INCREMENT,
3921  `ticket_id` int(255) NOT NULL,
3922  `sender_type` int(1) NOT NULL,
3923  `sender_id` int(255) NOT NULL,
3924  `message` text NOT NULL,
3925  `date` varchar(66) NOT NULL,
3926  `files` int(1) NOT NULL DEFAULT '0',
3927  PRIMARY KEY (`id`)
3928) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3929/*!40101 SET character_set_client = @saved_cs_client */;
3930
3931--
3932-- Dumping data for table `support_messages`
3933--
3934
3935LOCK TABLES `support_messages` WRITE;
3936/*!40000 ALTER TABLE `support_messages` DISABLE KEYS */;
3937/*!40000 ALTER TABLE `support_messages` ENABLE KEYS */;
3938UNLOCK TABLES;
3939
3940--
3941-- Table structure for table `transactions`
3942--
3943
3944DROP TABLE IF EXISTS `transactions`;
3945/*!40101 SET @saved_cs_client     = @@character_set_client */;
3946/*!40101 SET character_set_client = utf8 */;
3947CREATE TABLE `transactions` (
3948  `id` int(255) NOT NULL AUTO_INCREMENT,
3949  `order_id` varchar(66) NOT NULL,
3950  `user_id` int(255) NOT NULL,
3951  `amount` decimal(10,2) NOT NULL,
3952  `bitcoin_amount` int(255) DEFAULT NULL,
3953  `date` varchar(66) NOT NULL,
3954  `email` varchar(255) DEFAULT NULL,
3955  `bitcoin_address` varchar(255) DEFAULT NULL,
3956  `ip_address` varchar(15) DEFAULT NULL,
3957  `feedback` text,
3958  `status` int(1) NOT NULL DEFAULT '0',
3959  `released` int(1) NOT NULL DEFAULT '0',
3960  PRIMARY KEY (`id`)
3961) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
3962/*!40101 SET character_set_client = @saved_cs_client */;
3963
3964--
3965-- Dumping data for table `transactions`
3966--
3967
3968LOCK TABLES `transactions` WRITE;
3969/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
3970/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
3971UNLOCK TABLES;
3972
3973--
3974-- Table structure for table `users`
3975--
3976
3977DROP TABLE IF EXISTS `users`;
3978/*!40101 SET @saved_cs_client     = @@character_set_client */;
3979/*!40101 SET character_set_client = utf8 */;
3980CREATE TABLE `users` (
3981  `id` int(255) NOT NULL AUTO_INCREMENT,
3982  `username` varchar(166) NOT NULL,
3983  `email` varchar(255) NOT NULL,
3984  `password` varchar(166) NOT NULL,
3985  `balance` decimal(10,2) NOT NULL,
3986  `bitcoin` int(255) NOT NULL,
3987  `register_date` varchar(66) NOT NULL,
3988  `register_ip` varchar(15) NOT NULL,
3989  `status` int(1) NOT NULL DEFAULT '1',
3990  PRIMARY KEY (`id`)
3991) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3992/*!40101 SET character_set_client = @saved_cs_client */;
3993
3994--
3995-- Dumping data for table `users`
3996--
3997
3998LOCK TABLES `users` WRITE;
3999/*!40000 ALTER TABLE `users` DISABLE KEYS */;
4000/*!40000 ALTER TABLE `users` ENABLE KEYS */;
4001UNLOCK TABLES;
4002
4003--
4004-- Table structure for table `withdrawals`
4005--
4006
4007DROP TABLE IF EXISTS `withdrawals`;
4008/*!40101 SET @saved_cs_client     = @@character_set_client */;
4009/*!40101 SET character_set_client = utf8 */;
4010CREATE TABLE `withdrawals` (
4011  `id` int(255) NOT NULL AUTO_INCREMENT,
4012  `user_id` int(255) NOT NULL,
4013  `amount` decimal(10,2) NOT NULL,
4014  `bitcoin_amount` int(255) NOT NULL,
4015  `bitcoin_address` varchar(255) NOT NULL,
4016  `date` varchar(66) NOT NULL,
4017  `ip_address` varchar(15) NOT NULL,
4018  `bank_name` varchar(255) NOT NULL,
4019  `account_owner` varchar(255) NOT NULL,
4020  `account_number` varchar(255) NOT NULL,
4021  `iban` varchar(255) NOT NULL,
4022  `lat` varchar(66) DEFAULT NULL,
4023  `lon` varchar(66) DEFAULT NULL,
4024  `city` varchar(255) DEFAULT NULL,
4025  `paid` int(1) NOT NULL DEFAULT '0',
4026  `status` int(1) NOT NULL DEFAULT '0',
4027  PRIMARY KEY (`id`)
4028) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
4029/*!40101 SET character_set_client = @saved_cs_client */;
4030
4031--
4032-- Dumping data for table `withdrawals`
4033--
4034
4035LOCK TABLES `withdrawals` WRITE;
4036/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
4037INSERT INTO `withdrawals` VALUES (2,0,0.29,30000,'37yQxL67Q3d8a4bajpaM37qwUBX6LwJ8cQ','1487264116','128.0.176.198','','','jan.pecina@centrum.cz','','49.8119','18.2553','Ostrava',0,1);
4038/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
4039UNLOCK TABLES;
4040
4041--
4042-- Current Database: `viacoin_pln`
4043--
4044
4045CREATE DATABASE /*!32312 IF NOT EXISTS*/ `viacoin_pln` /*!40100 DEFAULT CHARACTER SET utf8 */;
4046
4047USE `viacoin_pln`;
4048
4049--
4050-- Table structure for table `admin_types`
4051--
4052
4053DROP TABLE IF EXISTS `admin_types`;
4054/*!40101 SET @saved_cs_client     = @@character_set_client */;
4055/*!40101 SET character_set_client = utf8 */;
4056CREATE TABLE `admin_types` (
4057  `id` int(255) NOT NULL AUTO_INCREMENT,
4058  `name` varchar(166) NOT NULL,
4059  `auth` text NOT NULL,
4060  PRIMARY KEY (`id`)
4061) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
4062/*!40101 SET character_set_client = @saved_cs_client */;
4063
4064--
4065-- Dumping data for table `admin_types`
4066--
4067
4068LOCK TABLES `admin_types` WRITE;
4069/*!40000 ALTER TABLE `admin_types` DISABLE KEYS */;
4070INSERT INTO `admin_types` VALUES (1,'Admin','settings,faq,terms-of-service,privacy-policy,security,about-us,how-it-works,sliders,clients,transactions,payments,withdrawals,staff,manage,support,bank-accounts,logs'),(2,'Zkouška zaměstnanec','support,bank-accounts'),(3,'viacoin1','clients,transactions,payments,withdrawals,support');
4071/*!40000 ALTER TABLE `admin_types` ENABLE KEYS */;
4072UNLOCK TABLES;
4073
4074--
4075-- Table structure for table `admins`
4076--
4077
4078DROP TABLE IF EXISTS `admins`;
4079/*!40101 SET @saved_cs_client     = @@character_set_client */;
4080/*!40101 SET character_set_client = utf8 */;
4081CREATE TABLE `admins` (
4082  `id` int(255) NOT NULL AUTO_INCREMENT,
4083  `username` varchar(66) NOT NULL,
4084  `password` varchar(255) NOT NULL,
4085  `email` varchar(166) NOT NULL,
4086  `name` varchar(255) NOT NULL,
4087  `auth` int(255) NOT NULL,
4088  `google_auth` int(1) NOT NULL DEFAULT '0',
4089  `google_opt` varchar(66) DEFAULT NULL,
4090  `status` int(1) NOT NULL DEFAULT '1',
4091  PRIMARY KEY (`id`),
4092  KEY `auth` (`auth`)
4093) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
4094/*!40101 SET character_set_client = @saved_cs_client */;
4095
4096--
4097-- Dumping data for table `admins`
4098--
4099
4100LOCK TABLES `admins` WRITE;
4101/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
4102INSERT INTO `admins` VALUES (1,'admin','$2y$10$/58qJCCsLzsbIDRx/lwbb.JaWLUKlJ24v4wLFPsuK21Dusy8AsF5O','denizbirlik16@gmail.com','Deniz Birlik',1,2,'4AWRWNFURLFDNQLV',1),(2,'barbie','$2y$10$MH995zkU/X3ERRCZGXY4U.lX0iK0HXNazIU1CK5MBX1IeBhVcAf3.','rz8@email.cz','barbie',3,0,NULL,1);
4103/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
4104UNLOCK TABLES;
4105
4106--
4107-- Table structure for table `bank_accounts`
4108--
4109
4110DROP TABLE IF EXISTS `bank_accounts`;
4111/*!40101 SET @saved_cs_client     = @@character_set_client */;
4112/*!40101 SET character_set_client = utf8 */;
4113CREATE TABLE `bank_accounts` (
4114  `id` int(255) NOT NULL AUTO_INCREMENT,
4115  `bank_name` varchar(255) NOT NULL,
4116  `account_owner` varchar(255) NOT NULL,
4117  `account_number` varchar(166) NOT NULL,
4118  `iban` varchar(166) NOT NULL,
4119  `logo` varchar(255) NOT NULL,
4120  PRIMARY KEY (`id`)
4121) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
4122/*!40101 SET character_set_client = @saved_cs_client */;
4123
4124--
4125-- Dumping data for table `bank_accounts`
4126--
4127
4128LOCK TABLES `bank_accounts` WRITE;
4129/*!40000 ALTER TABLE `bank_accounts` DISABLE KEYS */;
4130INSERT INTO `bank_accounts` VALUES (1,'Garanti Bankası','Deniz Birlik','536-7774625','TR83 3823 8323 1239 8732 0000 0000 0233 01','4869a330ca41f4816aeed121ee42715e.jpg'),(2,'mBank','BreBank','670100-2205647536/6210','CZ37 6210 6701 0022 0564 7536','79714ed2cb3c0a0587888eca9bf93791.jpg'),(3,'Raiffeisen bank','Raiffeisen bank','78100909/5500','CZ37 6210 6701 0022 0564 7536 ','6b1c7f9fba55afdc4e43790181d0de53.jpg');
4131/*!40000 ALTER TABLE `bank_accounts` ENABLE KEYS */;
4132UNLOCK TABLES;
4133
4134--
4135-- Table structure for table `content`
4136--
4137
4138DROP TABLE IF EXISTS `content`;
4139/*!40101 SET @saved_cs_client     = @@character_set_client */;
4140/*!40101 SET character_set_client = utf8 */;
4141CREATE TABLE `content` (
4142  `id` int(255) NOT NULL AUTO_INCREMENT,
4143  `feature` varchar(255) NOT NULL,
4144  `value` text NOT NULL,
4145  PRIMARY KEY (`id`)
4146) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
4147/*!40101 SET character_set_client = @saved_cs_client */;
4148
4149--
4150-- Dumping data for table `content`
4151--
4152
4153LOCK TABLES `content` WRITE;
4154/*!40000 ALTER TABLE `content` DISABLE KEYS */;
4155INSERT INTO `content` VALUES (1,'security','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut sed pellentesque sem, id placerat enim. Suspendisse pharetra hendrerit felis, ac scelerisque sem posuere et. Phasellus hendrerit est eu ligula posuere, non bibendum dui finibus. Nam odio urna, egestas id maximus in, tincidunt non odio. Nulla facilisi. Nullam cursus quis magna sit amet interdum. Donec iaculis bibendum accumsan.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Nullam vitae eros ex.&nbsp;</font></p>'),(2,'terms_of_service','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Suspendisse potenti. Duis vitae suscipit dui, non pulvinar mauris. Interdum et malesuada fames ac ante ipsum primis in faucibus. Suspendisse augue massa, convallis vitae scelerisque vitae, auctor eu erat. </font></span></p><p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Mauris venenatis dictum justo non ullamcorper. Quisque eu facilisis erat.</font></span></p>'),(3,'about_us','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Maecenas in felis mauris. Mauris dictum massa non pharetra lacinia. Vivamus ut libero orci. Maecenas vitae volutpat sem. Pellentesque ultrices tempus mi, id feugiat nunc interdum sit amet. </font></span></p><p><span style=\"font-family: Verdana; color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\">Vestibulum nec nulla et odio lacinia hendrerit nec nec ex. Praesent placerat nulla eget dolor lobortis commodo. Praesent laoreet felis ut purus dignissim mollis.</span><br></p>'),(4,'privacy_policy','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Mauris hendrerit, elit cursus auctor cursus, enim urna hendrerit eros, sit amet porta dui mauris posuere diam. Pellentesque tempor libero a est viverra faucibus. Vivamus laoreet vulputate nunc quis finibus. Nam dapibus, erat vel tincidunt vehicula, diam eros finibus dolor, quis ultricies massa neque sed purus. Nunc nec est erat. Praesent eget tincidunt eros. Sed gravida placerat ex, venenatis hendrerit tortor facilisis vitae. Mauris faucibus, sem id placerat condimentum, nisl velit sollicitudin urna, in ornare lectus purus in erat.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Sed euismod ultrices ex, et porttitor erat vulputate ac.</font></p>'),(5,'how_it_works','Put how it works content here.');
4156/*!40000 ALTER TABLE `content` ENABLE KEYS */;
4157UNLOCK TABLES;
4158
4159--
4160-- Table structure for table `faq`
4161--
4162
4163DROP TABLE IF EXISTS `faq`;
4164/*!40101 SET @saved_cs_client     = @@character_set_client */;
4165/*!40101 SET character_set_client = utf8 */;
4166CREATE TABLE `faq` (
4167  `id` int(255) NOT NULL AUTO_INCREMENT,
4168  `question` text NOT NULL,
4169  `answer` text NOT NULL,
4170  PRIMARY KEY (`id`)
4171) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
4172/*!40101 SET character_set_client = @saved_cs_client */;
4173
4174--
4175-- Dumping data for table `faq`
4176--
4177
4178LOCK TABLES `faq` WRITE;
4179/*!40000 ALTER TABLE `faq` DISABLE KEYS */;
4180INSERT INTO `faq` VALUES (1,'Put your first question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(2,'Put your second question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(3,'Put your third question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(4,'Put your fourth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(5,'Put your fifth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. ');
4181/*!40000 ALTER TABLE `faq` ENABLE KEYS */;
4182UNLOCK TABLES;
4183
4184--
4185-- Table structure for table `logs`
4186--
4187
4188DROP TABLE IF EXISTS `logs`;
4189/*!40101 SET @saved_cs_client     = @@character_set_client */;
4190/*!40101 SET character_set_client = utf8 */;
4191CREATE TABLE `logs` (
4192  `id` int(255) NOT NULL AUTO_INCREMENT,
4193  `user_id` int(255) NOT NULL,
4194  `date` varchar(66) NOT NULL,
4195  `ip_address` varchar(15) NOT NULL,
4196  `action` varchar(255) NOT NULL,
4197  PRIMARY KEY (`id`)
4198) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
4199/*!40101 SET character_set_client = @saved_cs_client */;
4200
4201--
4202-- Dumping data for table `logs`
4203--
4204
4205LOCK TABLES `logs` WRITE;
4206/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
4207INSERT INTO `logs` VALUES (1,1,'1486542801','212.20.72.202','Admin logged in. ID: 1'),(2,1,'1486542813','212.20.72.202','General settings updated.'),(3,1,'1486543020','212.20.72.202','General settings updated.'),(4,1,'1486547191','217.30.74.169','Admin logged in. ID: 1'),(5,1,'1486547236','217.30.74.169','General settings updated.'),(6,1,'1486739200','46.135.20.29','Admin logged in. ID: 1'),(7,1,'1486739257','46.135.20.29','General settings updated.'),(8,1,'1486739413','46.135.20.29','General settings updated.'),(9,1,'1487082486','193.86.86.253','Admin logged in. ID: 1'),(10,1,'1487082519','193.86.86.253','General settings updated.'),(11,1,'1487082577','193.86.86.253','General settings updated.');
4208/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
4209UNLOCK TABLES;
4210
4211--
4212-- Table structure for table `payments`
4213--
4214
4215DROP TABLE IF EXISTS `payments`;
4216/*!40101 SET @saved_cs_client     = @@character_set_client */;
4217/*!40101 SET character_set_client = utf8 */;
4218CREATE TABLE `payments` (
4219  `id` int(255) NOT NULL AUTO_INCREMENT,
4220  `tx_id` varchar(255) DEFAULT NULL,
4221  `order_id` varchar(66) NOT NULL,
4222  `user_id` int(255) NOT NULL,
4223  `type` int(1) DEFAULT NULL,
4224  `amount` decimal(10,2) NOT NULL,
4225  `bitcoin_amount` int(255) DEFAULT NULL,
4226  `date` varchar(66) NOT NULL,
4227  `complete_date` varchar(66) DEFAULT NULL,
4228  `ip_address` varchar(15) NOT NULL,
4229  `step` int(1) NOT NULL DEFAULT '2',
4230  `email` varchar(255) DEFAULT NULL,
4231  `bitcoin_address` varchar(255) DEFAULT NULL,
4232  `paypal_address` varchar(255) DEFAULT NULL,
4233  `lat` varchar(66) DEFAULT NULL,
4234  `lon` varchar(66) DEFAULT NULL,
4235  `city` varchar(166) DEFAULT NULL,
4236  `feedback` text,
4237  `bank_id` int(22) DEFAULT NULL,
4238  `status` int(1) NOT NULL DEFAULT '0',
4239  `released` int(1) NOT NULL DEFAULT '0',
4240  PRIMARY KEY (`id`)
4241) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
4242/*!40101 SET character_set_client = @saved_cs_client */;
4243
4244--
4245-- Dumping data for table `payments`
4246--
4247
4248LOCK TABLES `payments` WRITE;
4249/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
4250INSERT INTO `payments` VALUES (1,NULL,'oVNUALltmIpK591B3jb60Y8cxdOaC2vDWuyESihn',0,1,389976.00,2147483647,'1486739309',NULL,'46.135.20.29',3,NULL,NULL,NULL,'50.0833','14.4667','Prague',NULL,NULL,0,0),(2,NULL,'yjZzwg85Ym6KdO3qhB4MDt1cl9vRNAafrIneG70H',0,1,100.00,2447339,'1487082556',NULL,'193.86.86.253',3,NULL,NULL,NULL,'50.1019','14.4001','Prague',NULL,NULL,0,0);
4251/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
4252UNLOCK TABLES;
4253
4254--
4255-- Table structure for table `settings`
4256--
4257
4258DROP TABLE IF EXISTS `settings`;
4259/*!40101 SET @saved_cs_client     = @@character_set_client */;
4260/*!40101 SET character_set_client = utf8 */;
4261CREATE TABLE `settings` (
4262  `id` int(255) NOT NULL AUTO_INCREMENT,
4263  `feature` varchar(166) NOT NULL,
4264  `value` text NOT NULL,
4265  PRIMARY KEY (`id`)
4266) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
4267/*!40101 SET character_set_client = @saved_cs_client */;
4268
4269--
4270-- Dumping data for table `settings`
4271--
4272
4273LOCK TABLES `settings` WRITE;
4274/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
4275INSERT INTO `settings` VALUES (1,'mailgun_domain','denizb16.com'),(2,'mailgun_key','key-3fbf4e1254de126d68ad93f023c3c3bc'),(3,'website_title','Viacoin.pl'),(4,'website_keywords','put,your,keywords,here'),(5,'website_description','Put your website description here.'),(6,'stripe_test_key','sk_test_lRaYYvpFpJDzgK23PI8o2vgE'),(7,'stripe_live_key','sk_live_sWGz3dXa4AU5rJGxoB392nBM'),(8,'stripe_status','0'),(9,'block_test_key','b674-3f84-8f5d-948e'),(10,'block_live_key','7d6b-8ed3-8f9b-8a20'),(11,'block_status','1'),(12,'facebook','https://www.facebook.com/viacoin.cz'),(13,'twitter','https://www.twitter.com'),(14,'youtube','https://www.youtube.com'),(15,'google','https://www.google.com'),(16,'instagram','https://www.facebook.com'),(17,'card_commission','0'),(18,'bitcoin_commission','0'),(19,'email','info@viacoin.cz'),(20,'phone','+420773232329'),(21,'paypal_address','paypal@viacoin.cz'),(22,'bitcoin_commission_user','0'),(23,'maintenance_mode','1');
4276/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
4277UNLOCK TABLES;
4278
4279--
4280-- Table structure for table `sliders`
4281--
4282
4283DROP TABLE IF EXISTS `sliders`;
4284/*!40101 SET @saved_cs_client     = @@character_set_client */;
4285/*!40101 SET character_set_client = utf8 */;
4286CREATE TABLE `sliders` (
4287  `id` int(255) NOT NULL AUTO_INCREMENT,
4288  `title` varchar(255) NOT NULL,
4289  `description` text NOT NULL,
4290  `content` text NOT NULL,
4291  `image` varchar(255) NOT NULL,
4292  PRIMARY KEY (`id`)
4293) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
4294/*!40101 SET character_set_client = @saved_cs_client */;
4295
4296--
4297-- Dumping data for table `sliders`
4298--
4299
4300LOCK TABLES `sliders` WRITE;
4301/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
4302INSERT INTO `sliders` VALUES (4,'Secured Data','Your data is safe','In viacoin, all datas are stored with ultra encryptions.  It means your all transactions and data are always secured!','7ec7d3c64922a5d21a7bd78fbf1fa61f.png'),(5,'Easy Steps','Buy/Sell Easily','You can buy or sell Bitcoins in viacoin easily, in a few minutes!','ed28688546d44085c362b398b40478a2.png'),(6,'Fast Transactions','Time is Money','You can buy or sell Bitcoins in viacoin just in a few minutes!','d39a99992ee128221a19bc7bc92ab4b7.png'),(7,'7/24 Support','We\'re Here to Help!','Our experienced support team is working 7/24 for you!','6c965b712ed14d9c7e18690a26708b32.png'),(8,'Best Prices','Best in the Market','Viacoin\'s main target is always providing best prices for customers!','798eacbcdf89f0b2fa2f0d1fead0794f.png');
4303/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
4304UNLOCK TABLES;
4305
4306--
4307-- Table structure for table `support`
4308--
4309
4310DROP TABLE IF EXISTS `support`;
4311/*!40101 SET @saved_cs_client     = @@character_set_client */;
4312/*!40101 SET character_set_client = utf8 */;
4313CREATE TABLE `support` (
4314  `id` int(255) NOT NULL AUTO_INCREMENT,
4315  `title` varchar(255) NOT NULL,
4316  `user_id` int(255) NOT NULL,
4317  `last_reply_type` int(1) NOT NULL,
4318  `last_reply_user` int(255) NOT NULL,
4319  `last_reply_date` varchar(66) NOT NULL,
4320  `status` int(1) NOT NULL DEFAULT '0',
4321  PRIMARY KEY (`id`)
4322) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4323/*!40101 SET character_set_client = @saved_cs_client */;
4324
4325--
4326-- Dumping data for table `support`
4327--
4328
4329LOCK TABLES `support` WRITE;
4330/*!40000 ALTER TABLE `support` DISABLE KEYS */;
4331/*!40000 ALTER TABLE `support` ENABLE KEYS */;
4332UNLOCK TABLES;
4333
4334--
4335-- Table structure for table `support_files`
4336--
4337
4338DROP TABLE IF EXISTS `support_files`;
4339/*!40101 SET @saved_cs_client     = @@character_set_client */;
4340/*!40101 SET character_set_client = utf8 */;
4341CREATE TABLE `support_files` (
4342  `id` int(255) NOT NULL AUTO_INCREMENT,
4343  `message_id` int(255) NOT NULL,
4344  `file` varchar(255) NOT NULL,
4345  PRIMARY KEY (`id`)
4346) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4347/*!40101 SET character_set_client = @saved_cs_client */;
4348
4349--
4350-- Dumping data for table `support_files`
4351--
4352
4353LOCK TABLES `support_files` WRITE;
4354/*!40000 ALTER TABLE `support_files` DISABLE KEYS */;
4355/*!40000 ALTER TABLE `support_files` ENABLE KEYS */;
4356UNLOCK TABLES;
4357
4358--
4359-- Table structure for table `support_messages`
4360--
4361
4362DROP TABLE IF EXISTS `support_messages`;
4363/*!40101 SET @saved_cs_client     = @@character_set_client */;
4364/*!40101 SET character_set_client = utf8 */;
4365CREATE TABLE `support_messages` (
4366  `id` int(255) NOT NULL AUTO_INCREMENT,
4367  `ticket_id` int(255) NOT NULL,
4368  `sender_type` int(1) NOT NULL,
4369  `sender_id` int(255) NOT NULL,
4370  `message` text NOT NULL,
4371  `date` varchar(66) NOT NULL,
4372  `files` int(1) NOT NULL DEFAULT '0',
4373  PRIMARY KEY (`id`)
4374) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4375/*!40101 SET character_set_client = @saved_cs_client */;
4376
4377--
4378-- Dumping data for table `support_messages`
4379--
4380
4381LOCK TABLES `support_messages` WRITE;
4382/*!40000 ALTER TABLE `support_messages` DISABLE KEYS */;
4383/*!40000 ALTER TABLE `support_messages` ENABLE KEYS */;
4384UNLOCK TABLES;
4385
4386--
4387-- Table structure for table `transactions`
4388--
4389
4390DROP TABLE IF EXISTS `transactions`;
4391/*!40101 SET @saved_cs_client     = @@character_set_client */;
4392/*!40101 SET character_set_client = utf8 */;
4393CREATE TABLE `transactions` (
4394  `id` int(255) NOT NULL AUTO_INCREMENT,
4395  `order_id` varchar(66) NOT NULL,
4396  `user_id` int(255) NOT NULL,
4397  `amount` decimal(10,2) NOT NULL,
4398  `bitcoin_amount` int(255) DEFAULT NULL,
4399  `date` varchar(66) NOT NULL,
4400  `email` varchar(255) DEFAULT NULL,
4401  `bitcoin_address` varchar(255) DEFAULT NULL,
4402  `ip_address` varchar(15) DEFAULT NULL,
4403  `feedback` text,
4404  `status` int(1) NOT NULL DEFAULT '0',
4405  `released` int(1) NOT NULL DEFAULT '0',
4406  PRIMARY KEY (`id`)
4407) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
4408/*!40101 SET character_set_client = @saved_cs_client */;
4409
4410--
4411-- Dumping data for table `transactions`
4412--
4413
4414LOCK TABLES `transactions` WRITE;
4415/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
4416/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
4417UNLOCK TABLES;
4418
4419--
4420-- Table structure for table `users`
4421--
4422
4423DROP TABLE IF EXISTS `users`;
4424/*!40101 SET @saved_cs_client     = @@character_set_client */;
4425/*!40101 SET character_set_client = utf8 */;
4426CREATE TABLE `users` (
4427  `id` int(255) NOT NULL AUTO_INCREMENT,
4428  `username` varchar(166) NOT NULL,
4429  `email` varchar(255) NOT NULL,
4430  `password` varchar(166) NOT NULL,
4431  `balance` decimal(10,2) NOT NULL,
4432  `bitcoin` int(255) NOT NULL,
4433  `register_date` varchar(66) NOT NULL,
4434  `register_ip` varchar(15) NOT NULL,
4435  `status` int(1) NOT NULL DEFAULT '1',
4436  PRIMARY KEY (`id`)
4437) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4438/*!40101 SET character_set_client = @saved_cs_client */;
4439
4440--
4441-- Dumping data for table `users`
4442--
4443
4444LOCK TABLES `users` WRITE;
4445/*!40000 ALTER TABLE `users` DISABLE KEYS */;
4446/*!40000 ALTER TABLE `users` ENABLE KEYS */;
4447UNLOCK TABLES;
4448
4449--
4450-- Table structure for table `withdrawals`
4451--
4452
4453DROP TABLE IF EXISTS `withdrawals`;
4454/*!40101 SET @saved_cs_client     = @@character_set_client */;
4455/*!40101 SET character_set_client = utf8 */;
4456CREATE TABLE `withdrawals` (
4457  `id` int(255) NOT NULL AUTO_INCREMENT,
4458  `user_id` int(255) NOT NULL,
4459  `amount` decimal(10,2) NOT NULL,
4460  `bitcoin_amount` int(255) NOT NULL,
4461  `bitcoin_address` varchar(255) NOT NULL,
4462  `date` varchar(66) NOT NULL,
4463  `ip_address` varchar(15) NOT NULL,
4464  `bank_name` varchar(255) NOT NULL,
4465  `account_owner` varchar(255) NOT NULL,
4466  `account_number` varchar(255) NOT NULL,
4467  `iban` varchar(255) NOT NULL,
4468  `lat` varchar(66) DEFAULT NULL,
4469  `lon` varchar(66) DEFAULT NULL,
4470  `city` varchar(255) DEFAULT NULL,
4471  `paid` int(1) NOT NULL DEFAULT '0',
4472  `status` int(1) NOT NULL DEFAULT '0',
4473  PRIMARY KEY (`id`)
4474) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4475/*!40101 SET character_set_client = @saved_cs_client */;
4476
4477--
4478-- Dumping data for table `withdrawals`
4479--
4480
4481LOCK TABLES `withdrawals` WRITE;
4482/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
4483/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
4484UNLOCK TABLES;
4485
4486--
4487-- Current Database: `viacoin_sk`
4488--
4489
4490CREATE DATABASE /*!32312 IF NOT EXISTS*/ `viacoin_sk` /*!40100 DEFAULT CHARACTER SET utf8 */;
4491
4492USE `viacoin_sk`;
4493
4494--
4495-- Table structure for table `admin_types`
4496--
4497
4498DROP TABLE IF EXISTS `admin_types`;
4499/*!40101 SET @saved_cs_client     = @@character_set_client */;
4500/*!40101 SET character_set_client = utf8 */;
4501CREATE TABLE `admin_types` (
4502  `id` int(255) NOT NULL AUTO_INCREMENT,
4503  `name` varchar(166) NOT NULL,
4504  `auth` text NOT NULL,
4505  PRIMARY KEY (`id`)
4506) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
4507/*!40101 SET character_set_client = @saved_cs_client */;
4508
4509--
4510-- Dumping data for table `admin_types`
4511--
4512
4513LOCK TABLES `admin_types` WRITE;
4514/*!40000 ALTER TABLE `admin_types` DISABLE KEYS */;
4515INSERT INTO `admin_types` VALUES (1,'Admin','settings,faq,terms-of-service,privacy-policy,security,about-us,how-it-works,sliders,clients,transactions,payments,withdrawals,staff,manage,support,bank-accounts,logs'),(4,'FULOPOVE','clients,transactions,payments,withdrawals,support'),(5,'viacoin','clients,transactions,payments,withdrawals,support');
4516/*!40000 ALTER TABLE `admin_types` ENABLE KEYS */;
4517UNLOCK TABLES;
4518
4519--
4520-- Table structure for table `admins`
4521--
4522
4523DROP TABLE IF EXISTS `admins`;
4524/*!40101 SET @saved_cs_client     = @@character_set_client */;
4525/*!40101 SET character_set_client = utf8 */;
4526CREATE TABLE `admins` (
4527  `id` int(255) NOT NULL AUTO_INCREMENT,
4528  `username` varchar(66) NOT NULL,
4529  `password` varchar(255) NOT NULL,
4530  `email` varchar(166) NOT NULL,
4531  `name` varchar(255) NOT NULL,
4532  `auth` int(255) NOT NULL,
4533  `google_auth` int(1) NOT NULL DEFAULT '0',
4534  `google_opt` varchar(66) DEFAULT NULL,
4535  `status` int(1) NOT NULL DEFAULT '1',
4536  PRIMARY KEY (`id`),
4537  KEY `auth` (`auth`)
4538) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
4539/*!40101 SET character_set_client = @saved_cs_client */;
4540
4541--
4542-- Dumping data for table `admins`
4543--
4544
4545LOCK TABLES `admins` WRITE;
4546/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
4547INSERT INTO `admins` VALUES (1,'admin','$2y$10$/58qJCCsLzsbIDRx/lwbb.JaWLUKlJ24v4wLFPsuK21Dusy8AsF5O','denizbirlik16@gmail.com','Deniz Birlik',1,2,'4AWRWNFURLFDNQLV',1),(5,'viacoin','$2y$10$1kYxo//aLexqIdOsT7uqVeuYZu8wai9W8u/5EftkQtQlQks6yRtuy','rz8@email.cz','Slečny Nebezpečne',5,0,NULL,1);
4548/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
4549UNLOCK TABLES;
4550
4551--
4552-- Table structure for table `bank_accounts`
4553--
4554
4555DROP TABLE IF EXISTS `bank_accounts`;
4556/*!40101 SET @saved_cs_client     = @@character_set_client */;
4557/*!40101 SET character_set_client = utf8 */;
4558CREATE TABLE `bank_accounts` (
4559  `id` int(255) NOT NULL AUTO_INCREMENT,
4560  `bank_name` varchar(255) NOT NULL,
4561  `account_owner` varchar(255) NOT NULL,
4562  `account_number` varchar(166) NOT NULL,
4563  `iban` varchar(166) NOT NULL,
4564  `logo` varchar(255) NOT NULL,
4565  PRIMARY KEY (`id`)
4566) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
4567/*!40101 SET character_set_client = @saved_cs_client */;
4568
4569--
4570-- Dumping data for table `bank_accounts`
4571--
4572
4573LOCK TABLES `bank_accounts` WRITE;
4574/*!40000 ALTER TABLE `bank_accounts` DISABLE KEYS */;
4575INSERT INTO `bank_accounts` VALUES (1,'Garanti Bankası','Deniz Birlik','536-7774625','TR83 3823 8323 1239 8732 0000 0000 0233 01','4869a330ca41f4816aeed121ee42715e.jpg'),(2,'mBank','BreBank','670100-2205647536/6210','CZ37 6210 6701 0022 0564 7536','79714ed2cb3c0a0587888eca9bf93791.jpg'),(3,'Raiffeisen bank','Raiffeisen bank','78100909/5500','CZ37 6210 6701 0022 0564 7536 ','6b1c7f9fba55afdc4e43790181d0de53.jpg');
4576/*!40000 ALTER TABLE `bank_accounts` ENABLE KEYS */;
4577UNLOCK TABLES;
4578
4579--
4580-- Table structure for table `content`
4581--
4582
4583DROP TABLE IF EXISTS `content`;
4584/*!40101 SET @saved_cs_client     = @@character_set_client */;
4585/*!40101 SET character_set_client = utf8 */;
4586CREATE TABLE `content` (
4587  `id` int(255) NOT NULL AUTO_INCREMENT,
4588  `feature` varchar(255) NOT NULL,
4589  `value` text NOT NULL,
4590  PRIMARY KEY (`id`)
4591) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
4592/*!40101 SET character_set_client = @saved_cs_client */;
4593
4594--
4595-- Dumping data for table `content`
4596--
4597
4598LOCK TABLES `content` WRITE;
4599/*!40000 ALTER TABLE `content` DISABLE KEYS */;
4600INSERT INTO `content` VALUES (1,'security','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut sed pellentesque sem, id placerat enim. Suspendisse pharetra hendrerit felis, ac scelerisque sem posuere et. Phasellus hendrerit est eu ligula posuere, non bibendum dui finibus. Nam odio urna, egestas id maximus in, tincidunt non odio. Nulla facilisi. Nullam cursus quis magna sit amet interdum. Donec iaculis bibendum accumsan.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Nullam vitae eros ex.&nbsp;</font></p>'),(2,'terms_of_service','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Suspendisse potenti. Duis vitae suscipit dui, non pulvinar mauris. Interdum et malesuada fames ac ante ipsum primis in faucibus. Suspendisse augue massa, convallis vitae scelerisque vitae, auctor eu erat. </font></span></p><p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Mauris venenatis dictum justo non ullamcorper. Quisque eu facilisis erat.</font></span></p>'),(3,'about_us','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Maecenas in felis mauris. Mauris dictum massa non pharetra lacinia. Vivamus ut libero orci. Maecenas vitae volutpat sem. Pellentesque ultrices tempus mi, id feugiat nunc interdum sit amet. </font></span></p><p><span style=\"font-family: Verdana; color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\">Vestibulum nec nulla et odio lacinia hendrerit nec nec ex. Praesent placerat nulla eget dolor lobortis commodo. Praesent laoreet felis ut purus dignissim mollis.</span><br></p>'),(4,'privacy_policy','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Mauris hendrerit, elit cursus auctor cursus, enim urna hendrerit eros, sit amet porta dui mauris posuere diam. Pellentesque tempor libero a est viverra faucibus. Vivamus laoreet vulputate nunc quis finibus. Nam dapibus, erat vel tincidunt vehicula, diam eros finibus dolor, quis ultricies massa neque sed purus. Nunc nec est erat. Praesent eget tincidunt eros. Sed gravida placerat ex, venenatis hendrerit tortor facilisis vitae. Mauris faucibus, sem id placerat condimentum, nisl velit sollicitudin urna, in ornare lectus purus in erat.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Sed euismod ultrices ex, et porttitor erat vulputate ac.</font></p>'),(5,'how_it_works','Put how it works content here.');
4601/*!40000 ALTER TABLE `content` ENABLE KEYS */;
4602UNLOCK TABLES;
4603
4604--
4605-- Table structure for table `faq`
4606--
4607
4608DROP TABLE IF EXISTS `faq`;
4609/*!40101 SET @saved_cs_client     = @@character_set_client */;
4610/*!40101 SET character_set_client = utf8 */;
4611CREATE TABLE `faq` (
4612  `id` int(255) NOT NULL AUTO_INCREMENT,
4613  `question` text NOT NULL,
4614  `answer` text NOT NULL,
4615  PRIMARY KEY (`id`)
4616) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
4617/*!40101 SET character_set_client = @saved_cs_client */;
4618
4619--
4620-- Dumping data for table `faq`
4621--
4622
4623LOCK TABLES `faq` WRITE;
4624/*!40000 ALTER TABLE `faq` DISABLE KEYS */;
4625INSERT INTO `faq` VALUES (1,'Put your first question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(2,'Put your second question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(3,'Put your third question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(4,'Put your fourth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(5,'Put your fifth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. ');
4626/*!40000 ALTER TABLE `faq` ENABLE KEYS */;
4627UNLOCK TABLES;
4628
4629--
4630-- Table structure for table `logs`
4631--
4632
4633DROP TABLE IF EXISTS `logs`;
4634/*!40101 SET @saved_cs_client     = @@character_set_client */;
4635/*!40101 SET character_set_client = utf8 */;
4636CREATE TABLE `logs` (
4637  `id` int(255) NOT NULL AUTO_INCREMENT,
4638  `user_id` int(255) NOT NULL,
4639  `date` varchar(66) NOT NULL,
4640  `ip_address` varchar(15) NOT NULL,
4641  `action` varchar(255) NOT NULL,
4642  PRIMARY KEY (`id`)
4643) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8;
4644/*!40101 SET character_set_client = @saved_cs_client */;
4645
4646--
4647-- Dumping data for table `logs`
4648--
4649
4650LOCK TABLES `logs` WRITE;
4651/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
4652INSERT INTO `logs` VALUES (1,1,'1486407331','128.0.176.198','Admin logged in. ID: 1'),(2,1,'1486407457','128.0.176.198','General settings updated.'),(3,1,'1487087916','178.41.76.146','Admin logged in. ID: 1'),(4,1,'1487091523','178.41.76.146','Admin logged in. ID: 1'),(5,1,'1487093092','46.1.26.253','Admin logged in. ID: 1'),(6,1,'1487094627','178.41.76.146','General settings updated.'),(7,1,'1487094674','178.41.76.146','General settings updated.'),(8,1,'1487094689','178.41.76.146','Withdrawal completed. ID: 1'),(9,1,'1487094891','178.41.76.146','General settings updated.'),(10,1,'1487094971','178.41.76.146','General settings updated.'),(11,1,'1487094980','178.41.76.146','Withdrawal completed. ID: 2'),(12,1,'1487112630','178.41.76.146','Admin logged in. ID: 1'),(13,1,'1487112830','178.41.76.146','Admin logged in. ID: 1'),(14,1,'1487144367','46.1.26.253','Admin logged in. ID: 1'),(15,1,'1487184067','178.41.76.146','Admin logged in. ID: 1'),(16,1,'1487184118','178.41.76.146','General settings updated.'),(17,1,'1487184683','178.41.76.146','General settings updated.'),(18,1,'1487185030','178.41.76.146','General settings updated.'),(19,1,'1487187335','178.41.76.146','General settings updated.'),(20,1,'1487198881','178.41.76.146','Admin logged in. ID: 1'),(21,1,'1487198888','178.41.76.146','General settings updated.'),(22,1,'1487198902','178.41.76.146','General settings updated.'),(23,1,'1487272505','178.41.76.146','Admin logged in. ID: 1'),(24,1,'1487280575','178.41.76.146','General settings updated.'),(25,1,'1487280712','178.41.76.146','General settings updated.'),(26,1,'1487280814','178.41.76.146','General settings updated.'),(27,1,'1487280855','178.41.76.146','General settings updated.'),(28,1,'1487340730','178.41.76.146','Admin logged in. ID: 1'),(29,1,'1487340736','178.41.76.146','Payment deleted. ID: 1'),(30,1,'1487340807','178.41.76.146','Admin type added. ID: 4'),(31,1,'1487340869','178.41.76.146','Staff added. ID: 3'),(32,3,'1487340982','178.41.76.146','Admin logged in. ID: 3'),(33,1,'1487341020','178.41.76.146','Admin logged in. ID: 1'),(34,1,'1487341029','178.41.76.146','Staff deleted. ID: 2'),(35,3,'1487341359','178.41.76.146','Admin reset password. ID: 3'),(36,1,'1487341370','178.41.76.146','Admin logged in. ID: 1'),(37,1,'1487341389','178.41.76.146','Staff updated. ID: 3'),(38,1,'1487341471','178.41.76.146','Admin logged in. ID: 1'),(39,1,'1487341495','178.41.76.146','Admin type deleted. ID: 3'),(40,1,'1487341497','178.41.76.146','Admin type deleted. ID: 2'),(41,1,'1487341519','178.41.76.146','Admin type added. ID: 5'),(42,1,'1487341611','178.41.76.146','Staff deleted. ID: 3'),(43,1,'1487341640','178.41.76.146','Staff added. ID: 4'),(44,1,'1487341657','178.41.76.146','Staff updated. ID: 4'),(45,1,'1487342015','178.41.76.146','Admin logged in. ID: 1'),(46,1,'1487342044','178.41.76.146','Staff updated. ID: 4'),(47,1,'1487342069','178.41.76.146','Admin logged in. ID: 1'),(48,1,'1487342096','178.41.76.146','Staff added. ID: 5'),(49,1,'1487342119','178.41.76.146','Admin type updated. ID: 5'),(50,5,'1487342140','178.41.76.146','Admin logged in. ID: 5'),(51,5,'1487342191','178.41.76.146','Admin updated profile. ID: 5'),(52,5,'1487342249','178.41.76.146','Admin logged in. ID: 5'),(53,1,'1487342268','178.41.76.146','Admin logged in. ID: 1'),(54,5,'1487342271','94.228.82.112','Admin logged in. ID: 5'),(55,1,'1487342280','178.41.76.146','Staff deleted. ID: 4'),(56,5,'1487342298','178.41.76.146','Admin logged in. ID: 5'),(57,1,'1487342973','178.41.76.146','Admin logged in. ID: 1'),(58,1,'1487342978','178.41.76.146','General settings updated.'),(59,1,'1487343046','178.41.76.146','General settings updated.'),(60,1,'1487343049','178.41.76.146','General settings updated.'),(61,1,'1487343061','178.41.76.146','General settings updated.'),(62,1,'1487343074','178.41.76.146','General settings updated.'),(63,1,'1487343095','178.41.76.146','General settings updated.'),(64,1,'1487344472','178.41.76.146','General settings updated.'),(65,1,'1487344548','178.41.76.146','General settings updated.'),(66,1,'1487350661','178.41.76.146','General settings updated.'),(67,1,'1487350671','178.41.76.146','General settings updated.'),(68,1,'1488548845','78.98.22.83','Admin logged in. ID: 1'),(69,1,'1489591514','178.41.101.158','Admin logged in. ID: 1'),(70,1,'1490752657','217.30.74.169','Admin logged in. ID: 1'),(71,1,'1490752663','217.30.74.169','General settings updated.'),(72,1,'1490752677','217.30.74.169','General settings updated.');
4653/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
4654UNLOCK TABLES;
4655
4656--
4657-- Table structure for table `payments`
4658--
4659
4660DROP TABLE IF EXISTS `payments`;
4661/*!40101 SET @saved_cs_client     = @@character_set_client */;
4662/*!40101 SET character_set_client = utf8 */;
4663CREATE TABLE `payments` (
4664  `id` int(255) NOT NULL AUTO_INCREMENT,
4665  `tx_id` varchar(255) DEFAULT NULL,
4666  `order_id` varchar(66) NOT NULL,
4667  `user_id` int(255) NOT NULL,
4668  `type` int(1) DEFAULT NULL,
4669  `amount` decimal(10,2) NOT NULL,
4670  `bitcoin_amount` int(255) DEFAULT NULL,
4671  `date` varchar(66) NOT NULL,
4672  `complete_date` varchar(66) DEFAULT NULL,
4673  `ip_address` varchar(15) NOT NULL,
4674  `step` int(1) NOT NULL DEFAULT '2',
4675  `email` varchar(255) DEFAULT NULL,
4676  `bitcoin_address` varchar(255) DEFAULT NULL,
4677  `paypal_address` varchar(255) DEFAULT NULL,
4678  `lat` varchar(66) DEFAULT NULL,
4679  `lon` varchar(66) DEFAULT NULL,
4680  `city` varchar(166) DEFAULT NULL,
4681  `feedback` text,
4682  `bank_id` int(22) DEFAULT NULL,
4683  `status` int(1) NOT NULL DEFAULT '0',
4684  `released` int(1) NOT NULL DEFAULT '0',
4685  PRIMARY KEY (`id`)
4686) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4687/*!40101 SET character_set_client = @saved_cs_client */;
4688
4689--
4690-- Dumping data for table `payments`
4691--
4692
4693LOCK TABLES `payments` WRITE;
4694/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
4695/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
4696UNLOCK TABLES;
4697
4698--
4699-- Table structure for table `settings`
4700--
4701
4702DROP TABLE IF EXISTS `settings`;
4703/*!40101 SET @saved_cs_client     = @@character_set_client */;
4704/*!40101 SET character_set_client = utf8 */;
4705CREATE TABLE `settings` (
4706  `id` int(255) NOT NULL AUTO_INCREMENT,
4707  `feature` varchar(166) NOT NULL,
4708  `value` text NOT NULL,
4709  PRIMARY KEY (`id`)
4710) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
4711/*!40101 SET character_set_client = @saved_cs_client */;
4712
4713--
4714-- Dumping data for table `settings`
4715--
4716
4717LOCK TABLES `settings` WRITE;
4718/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
4719INSERT INTO `settings` VALUES (1,'mailgun_domain','denizb16.com'),(2,'mailgun_key','key-3fbf4e1254de126d68ad93f023c3c3bc'),(3,'website_title','Viacoin.com'),(4,'website_keywords','put,your,keywords,here'),(5,'website_description','Put your website description here.'),(6,'stripe_test_key','sk_test_lRaYYvpFpJDzgK23PI8o2vgE'),(7,'stripe_live_key','sk_live_sWGz3dXa4AU5rJGxoB392nBM'),(8,'stripe_status','0'),(9,'block_test_key','b674-3f84-8f5d-948e'),(10,'block_live_key','7d6b-8ed3-8f9b-8a20'),(11,'block_status','1'),(12,'facebook','https://www.facebook.com/viacoin.cz'),(13,'twitter','https://www.twitter.com'),(14,'youtube','https://www.youtube.com'),(15,'google','https://www.google.com'),(16,'instagram','https://www.facebook.com'),(17,'card_commission','0'),(18,'bitcoin_commission','0'),(19,'email','info@viacoin.cz'),(20,'phone','+420773232329'),(21,'paypal_address','paypal@viacoin.cz'),(22,'bitcoin_commission_user','0'),(23,'maintenance_mode','1');
4720/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
4721UNLOCK TABLES;
4722
4723--
4724-- Table structure for table `sliders`
4725--
4726
4727DROP TABLE IF EXISTS `sliders`;
4728/*!40101 SET @saved_cs_client     = @@character_set_client */;
4729/*!40101 SET character_set_client = utf8 */;
4730CREATE TABLE `sliders` (
4731  `id` int(255) NOT NULL AUTO_INCREMENT,
4732  `title` varchar(255) NOT NULL,
4733  `description` text NOT NULL,
4734  `content` text NOT NULL,
4735  `image` varchar(255) NOT NULL,
4736  PRIMARY KEY (`id`)
4737) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
4738/*!40101 SET character_set_client = @saved_cs_client */;
4739
4740--
4741-- Dumping data for table `sliders`
4742--
4743
4744LOCK TABLES `sliders` WRITE;
4745/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
4746INSERT INTO `sliders` VALUES (4,'Secured Data','Your data is safe','In viacoin, all datas are stored with ultra encryptions.  It means your all transactions and data are always secured!','7ec7d3c64922a5d21a7bd78fbf1fa61f.png'),(5,'Easy Steps','Buy/Sell Easily','You can buy or sell Bitcoins in viacoin easily, in a few minutes!','ed28688546d44085c362b398b40478a2.png'),(6,'Fast Transactions','Time is Money','You can buy or sell Bitcoins in viacoin just in a few minutes!','d39a99992ee128221a19bc7bc92ab4b7.png'),(7,'7/24 Support','We\'re Here to Help!','Our experienced support team is working 7/24 for you!','6c965b712ed14d9c7e18690a26708b32.png'),(8,'Best Prices','Best in the Market','Viacoin\'s main target is always providing best prices for customers!','798eacbcdf89f0b2fa2f0d1fead0794f.png');
4747/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
4748UNLOCK TABLES;
4749
4750--
4751-- Table structure for table `support`
4752--
4753
4754DROP TABLE IF EXISTS `support`;
4755/*!40101 SET @saved_cs_client     = @@character_set_client */;
4756/*!40101 SET character_set_client = utf8 */;
4757CREATE TABLE `support` (
4758  `id` int(255) NOT NULL AUTO_INCREMENT,
4759  `title` varchar(255) NOT NULL,
4760  `user_id` int(255) NOT NULL,
4761  `last_reply_type` int(1) NOT NULL,
4762  `last_reply_user` int(255) NOT NULL,
4763  `last_reply_date` varchar(66) NOT NULL,
4764  `status` int(1) NOT NULL DEFAULT '0',
4765  PRIMARY KEY (`id`)
4766) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4767/*!40101 SET character_set_client = @saved_cs_client */;
4768
4769--
4770-- Dumping data for table `support`
4771--
4772
4773LOCK TABLES `support` WRITE;
4774/*!40000 ALTER TABLE `support` DISABLE KEYS */;
4775/*!40000 ALTER TABLE `support` ENABLE KEYS */;
4776UNLOCK TABLES;
4777
4778--
4779-- Table structure for table `support_files`
4780--
4781
4782DROP TABLE IF EXISTS `support_files`;
4783/*!40101 SET @saved_cs_client     = @@character_set_client */;
4784/*!40101 SET character_set_client = utf8 */;
4785CREATE TABLE `support_files` (
4786  `id` int(255) NOT NULL AUTO_INCREMENT,
4787  `message_id` int(255) NOT NULL,
4788  `file` varchar(255) NOT NULL,
4789  PRIMARY KEY (`id`)
4790) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4791/*!40101 SET character_set_client = @saved_cs_client */;
4792
4793--
4794-- Dumping data for table `support_files`
4795--
4796
4797LOCK TABLES `support_files` WRITE;
4798/*!40000 ALTER TABLE `support_files` DISABLE KEYS */;
4799/*!40000 ALTER TABLE `support_files` ENABLE KEYS */;
4800UNLOCK TABLES;
4801
4802--
4803-- Table structure for table `support_messages`
4804--
4805
4806DROP TABLE IF EXISTS `support_messages`;
4807/*!40101 SET @saved_cs_client     = @@character_set_client */;
4808/*!40101 SET character_set_client = utf8 */;
4809CREATE TABLE `support_messages` (
4810  `id` int(255) NOT NULL AUTO_INCREMENT,
4811  `ticket_id` int(255) NOT NULL,
4812  `sender_type` int(1) NOT NULL,
4813  `sender_id` int(255) NOT NULL,
4814  `message` text NOT NULL,
4815  `date` varchar(66) NOT NULL,
4816  `files` int(1) NOT NULL DEFAULT '0',
4817  PRIMARY KEY (`id`)
4818) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4819/*!40101 SET character_set_client = @saved_cs_client */;
4820
4821--
4822-- Dumping data for table `support_messages`
4823--
4824
4825LOCK TABLES `support_messages` WRITE;
4826/*!40000 ALTER TABLE `support_messages` DISABLE KEYS */;
4827/*!40000 ALTER TABLE `support_messages` ENABLE KEYS */;
4828UNLOCK TABLES;
4829
4830--
4831-- Table structure for table `transactions`
4832--
4833
4834DROP TABLE IF EXISTS `transactions`;
4835/*!40101 SET @saved_cs_client     = @@character_set_client */;
4836/*!40101 SET character_set_client = utf8 */;
4837CREATE TABLE `transactions` (
4838  `id` int(255) NOT NULL AUTO_INCREMENT,
4839  `order_id` varchar(66) NOT NULL,
4840  `user_id` int(255) NOT NULL,
4841  `amount` decimal(10,2) NOT NULL,
4842  `bitcoin_amount` int(255) DEFAULT NULL,
4843  `date` varchar(66) NOT NULL,
4844  `email` varchar(255) DEFAULT NULL,
4845  `bitcoin_address` varchar(255) DEFAULT NULL,
4846  `ip_address` varchar(15) DEFAULT NULL,
4847  `feedback` text,
4848  `status` int(1) NOT NULL DEFAULT '0',
4849  `released` int(1) NOT NULL DEFAULT '0',
4850  PRIMARY KEY (`id`)
4851) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
4852/*!40101 SET character_set_client = @saved_cs_client */;
4853
4854--
4855-- Dumping data for table `transactions`
4856--
4857
4858LOCK TABLES `transactions` WRITE;
4859/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
4860/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
4861UNLOCK TABLES;
4862
4863--
4864-- Table structure for table `users`
4865--
4866
4867DROP TABLE IF EXISTS `users`;
4868/*!40101 SET @saved_cs_client     = @@character_set_client */;
4869/*!40101 SET character_set_client = utf8 */;
4870CREATE TABLE `users` (
4871  `id` int(255) NOT NULL AUTO_INCREMENT,
4872  `username` varchar(166) NOT NULL,
4873  `email` varchar(255) NOT NULL,
4874  `password` varchar(166) NOT NULL,
4875  `balance` decimal(10,2) NOT NULL,
4876  `bitcoin` int(255) NOT NULL,
4877  `register_date` varchar(66) NOT NULL,
4878  `register_ip` varchar(15) NOT NULL,
4879  `status` int(1) NOT NULL DEFAULT '1',
4880  PRIMARY KEY (`id`)
4881) ENGINE=InnoDB DEFAULT CHARSET=utf8;
4882/*!40101 SET character_set_client = @saved_cs_client */;
4883
4884--
4885-- Dumping data for table `users`
4886--
4887
4888LOCK TABLES `users` WRITE;
4889/*!40000 ALTER TABLE `users` DISABLE KEYS */;
4890/*!40000 ALTER TABLE `users` ENABLE KEYS */;
4891UNLOCK TABLES;
4892
4893--
4894-- Table structure for table `withdrawals`
4895--
4896
4897DROP TABLE IF EXISTS `withdrawals`;
4898/*!40101 SET @saved_cs_client     = @@character_set_client */;
4899/*!40101 SET character_set_client = utf8 */;
4900CREATE TABLE `withdrawals` (
4901  `id` int(255) NOT NULL AUTO_INCREMENT,
4902  `user_id` int(255) NOT NULL,
4903  `amount` decimal(10,2) NOT NULL,
4904  `bitcoin_amount` int(255) NOT NULL,
4905  `bitcoin_address` varchar(255) NOT NULL,
4906  `date` varchar(66) NOT NULL,
4907  `ip_address` varchar(15) NOT NULL,
4908  `bank_name` varchar(255) NOT NULL,
4909  `account_owner` varchar(255) NOT NULL,
4910  `account_number` varchar(255) NOT NULL,
4911  `iban` varchar(255) NOT NULL,
4912  `lat` varchar(66) DEFAULT NULL,
4913  `lon` varchar(66) DEFAULT NULL,
4914  `city` varchar(255) DEFAULT NULL,
4915  `paid` int(1) NOT NULL DEFAULT '0',
4916  `status` int(1) NOT NULL DEFAULT '0',
4917  PRIMARY KEY (`id`)
4918) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
4919/*!40101 SET character_set_client = @saved_cs_client */;
4920
4921--
4922-- Dumping data for table `withdrawals`
4923--
4924
4925LOCK TABLES `withdrawals` WRITE;
4926/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
4927INSERT INTO `withdrawals` VALUES (1,0,1000.00,104124366,'32xCWZMvqcHrXMm7wVVwaV3gjx4af8vfWQ','1487094651','178.41.76.146','','','rz8@email.cz','','48.309','18.0873','Nitra',0,1),(2,0,1000.00,104144970,'3JGV8LsKuUiNdK6fcCGBB2sYWKUWSodftv','1487094922','178.41.76.146','','','rz8@email.cz','','48.309','18.0873','Nitra',0,1);
4928/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
4929UNLOCK TABLES;
4930
4931--
4932-- Current Database: `viacoin_uk`
4933--
4934
4935CREATE DATABASE /*!32312 IF NOT EXISTS*/ `viacoin_uk` /*!40100 DEFAULT CHARACTER SET utf8 */;
4936
4937USE `viacoin_uk`;
4938
4939--
4940-- Table structure for table `admin_types`
4941--
4942
4943DROP TABLE IF EXISTS `admin_types`;
4944/*!40101 SET @saved_cs_client     = @@character_set_client */;
4945/*!40101 SET character_set_client = utf8 */;
4946CREATE TABLE `admin_types` (
4947  `id` int(255) NOT NULL AUTO_INCREMENT,
4948  `name` varchar(166) NOT NULL,
4949  `auth` text NOT NULL,
4950  PRIMARY KEY (`id`)
4951) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
4952/*!40101 SET character_set_client = @saved_cs_client */;
4953
4954--
4955-- Dumping data for table `admin_types`
4956--
4957
4958LOCK TABLES `admin_types` WRITE;
4959/*!40000 ALTER TABLE `admin_types` DISABLE KEYS */;
4960INSERT INTO `admin_types` VALUES (1,'Admin','settings,faq,terms-of-service,privacy-policy,security,about-us,how-it-works,sliders,clients,transactions,payments,withdrawals,staff,manage,support,bank-accounts,logs'),(2,'Zkouška zaměstnanec','support,bank-accounts'),(3,'viacoin1','clients,transactions,payments,withdrawals,support');
4961/*!40000 ALTER TABLE `admin_types` ENABLE KEYS */;
4962UNLOCK TABLES;
4963
4964--
4965-- Table structure for table `admins`
4966--
4967
4968DROP TABLE IF EXISTS `admins`;
4969/*!40101 SET @saved_cs_client     = @@character_set_client */;
4970/*!40101 SET character_set_client = utf8 */;
4971CREATE TABLE `admins` (
4972  `id` int(255) NOT NULL AUTO_INCREMENT,
4973  `username` varchar(66) NOT NULL,
4974  `password` varchar(255) NOT NULL,
4975  `email` varchar(166) NOT NULL,
4976  `name` varchar(255) NOT NULL,
4977  `auth` int(255) NOT NULL,
4978  `google_auth` int(1) NOT NULL DEFAULT '0',
4979  `google_opt` varchar(66) DEFAULT NULL,
4980  `status` int(1) NOT NULL DEFAULT '1',
4981  PRIMARY KEY (`id`),
4982  KEY `auth` (`auth`)
4983) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
4984/*!40101 SET character_set_client = @saved_cs_client */;
4985
4986--
4987-- Dumping data for table `admins`
4988--
4989
4990LOCK TABLES `admins` WRITE;
4991/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
4992INSERT INTO `admins` VALUES (1,'admin','$2y$10$/58qJCCsLzsbIDRx/lwbb.JaWLUKlJ24v4wLFPsuK21Dusy8AsF5O','denizbirlik16@gmail.com','Deniz Birlik',1,2,'4AWRWNFURLFDNQLV',1),(2,'barbie','$2y$10$MH995zkU/X3ERRCZGXY4U.lX0iK0HXNazIU1CK5MBX1IeBhVcAf3.','rz8@email.cz','barbie',3,0,NULL,1);
4993/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
4994UNLOCK TABLES;
4995
4996--
4997-- Table structure for table `bank_accounts`
4998--
4999
5000DROP TABLE IF EXISTS `bank_accounts`;
5001/*!40101 SET @saved_cs_client     = @@character_set_client */;
5002/*!40101 SET character_set_client = utf8 */;
5003CREATE TABLE `bank_accounts` (
5004  `id` int(255) NOT NULL AUTO_INCREMENT,
5005  `bank_name` varchar(255) NOT NULL,
5006  `account_owner` varchar(255) NOT NULL,
5007  `account_number` varchar(166) NOT NULL,
5008  `iban` varchar(166) NOT NULL,
5009  `logo` varchar(255) NOT NULL,
5010  PRIMARY KEY (`id`)
5011) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
5012/*!40101 SET character_set_client = @saved_cs_client */;
5013
5014--
5015-- Dumping data for table `bank_accounts`
5016--
5017
5018LOCK TABLES `bank_accounts` WRITE;
5019/*!40000 ALTER TABLE `bank_accounts` DISABLE KEYS */;
5020INSERT INTO `bank_accounts` VALUES (1,'Garanti Bankası','Deniz Birlik','536-7774625','TR83 3823 8323 1239 8732 0000 0000 0233 01','4869a330ca41f4816aeed121ee42715e.jpg'),(2,'mBank','BreBank','670100-2205647536/6210','CZ37 6210 6701 0022 0564 7536','79714ed2cb3c0a0587888eca9bf93791.jpg'),(3,'Raiffeisen bank','Raiffeisen bank','78100909/5500','CZ37 6210 6701 0022 0564 7536 ','6b1c7f9fba55afdc4e43790181d0de53.jpg');
5021/*!40000 ALTER TABLE `bank_accounts` ENABLE KEYS */;
5022UNLOCK TABLES;
5023
5024--
5025-- Table structure for table `content`
5026--
5027
5028DROP TABLE IF EXISTS `content`;
5029/*!40101 SET @saved_cs_client     = @@character_set_client */;
5030/*!40101 SET character_set_client = utf8 */;
5031CREATE TABLE `content` (
5032  `id` int(255) NOT NULL AUTO_INCREMENT,
5033  `feature` varchar(255) NOT NULL,
5034  `value` text NOT NULL,
5035  PRIMARY KEY (`id`)
5036) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
5037/*!40101 SET character_set_client = @saved_cs_client */;
5038
5039--
5040-- Dumping data for table `content`
5041--
5042
5043LOCK TABLES `content` WRITE;
5044/*!40000 ALTER TABLE `content` DISABLE KEYS */;
5045INSERT INTO `content` VALUES (1,'security','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut sed pellentesque sem, id placerat enim. Suspendisse pharetra hendrerit felis, ac scelerisque sem posuere et. Phasellus hendrerit est eu ligula posuere, non bibendum dui finibus. Nam odio urna, egestas id maximus in, tincidunt non odio. Nulla facilisi. Nullam cursus quis magna sit amet interdum. Donec iaculis bibendum accumsan.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Nullam vitae eros ex.&nbsp;</font></p>'),(2,'terms_of_service','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Suspendisse potenti. Duis vitae suscipit dui, non pulvinar mauris. Interdum et malesuada fames ac ante ipsum primis in faucibus. Suspendisse augue massa, convallis vitae scelerisque vitae, auctor eu erat. </font></span></p><p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Mauris venenatis dictum justo non ullamcorper. Quisque eu facilisis erat.</font></span></p>'),(3,'about_us','<p><span style=\"color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\"><font face=\"Verdana\">Maecenas in felis mauris. Mauris dictum massa non pharetra lacinia. Vivamus ut libero orci. Maecenas vitae volutpat sem. Pellentesque ultrices tempus mi, id feugiat nunc interdum sit amet. </font></span></p><p><span style=\"font-family: Verdana; color: rgb(0, 0, 0); font-size: 14px; text-align: justify;\">Vestibulum nec nulla et odio lacinia hendrerit nec nec ex. Praesent placerat nulla eget dolor lobortis commodo. Praesent laoreet felis ut purus dignissim mollis.</span><br></p>'),(4,'privacy_policy','<p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Mauris hendrerit, elit cursus auctor cursus, enim urna hendrerit eros, sit amet porta dui mauris posuere diam. Pellentesque tempor libero a est viverra faucibus. Vivamus laoreet vulputate nunc quis finibus. Nam dapibus, erat vel tincidunt vehicula, diam eros finibus dolor, quis ultricies massa neque sed purus. Nunc nec est erat. Praesent eget tincidunt eros. Sed gravida placerat ex, venenatis hendrerit tortor facilisis vitae. Mauris faucibus, sem id placerat condimentum, nisl velit sollicitudin urna, in ornare lectus purus in erat.</font></p><p style=\"margin-bottom: 15px; padding: 0px; text-align: justify; color: rgb(0, 0, 0); font-size: 14px;\"><font face=\"Verdana\">Sed euismod ultrices ex, et porttitor erat vulputate ac.</font></p>'),(5,'how_it_works','Put how it works content here.');
5046/*!40000 ALTER TABLE `content` ENABLE KEYS */;
5047UNLOCK TABLES;
5048
5049--
5050-- Table structure for table `faq`
5051--
5052
5053DROP TABLE IF EXISTS `faq`;
5054/*!40101 SET @saved_cs_client     = @@character_set_client */;
5055/*!40101 SET character_set_client = utf8 */;
5056CREATE TABLE `faq` (
5057  `id` int(255) NOT NULL AUTO_INCREMENT,
5058  `question` text NOT NULL,
5059  `answer` text NOT NULL,
5060  PRIMARY KEY (`id`)
5061) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
5062/*!40101 SET character_set_client = @saved_cs_client */;
5063
5064--
5065-- Dumping data for table `faq`
5066--
5067
5068LOCK TABLES `faq` WRITE;
5069/*!40000 ALTER TABLE `faq` DISABLE KEYS */;
5070INSERT INTO `faq` VALUES (1,'Put your first question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(2,'Put your second question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(3,'Put your third question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(4,'Put your fourth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. '),(5,'Put your fifth question here.','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi ut nisl molestie enim egestas pharetra. Sed tincidunt tellus eu enim varius vehicula. Sed sit amet semper augue, bibendum egestas felis. Mauris vestibulum ut lectus sed auctor. ');
5071/*!40000 ALTER TABLE `faq` ENABLE KEYS */;
5072UNLOCK TABLES;
5073
5074--
5075-- Table structure for table `logs`
5076--
5077
5078DROP TABLE IF EXISTS `logs`;
5079/*!40101 SET @saved_cs_client     = @@character_set_client */;
5080/*!40101 SET character_set_client = utf8 */;
5081CREATE TABLE `logs` (
5082  `id` int(255) NOT NULL AUTO_INCREMENT,
5083  `user_id` int(255) NOT NULL,
5084  `date` varchar(66) NOT NULL,
5085  `ip_address` varchar(15) NOT NULL,
5086  `action` varchar(255) NOT NULL,
5087  PRIMARY KEY (`id`)
5088) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5089/*!40101 SET character_set_client = @saved_cs_client */;
5090
5091--
5092-- Dumping data for table `logs`
5093--
5094
5095LOCK TABLES `logs` WRITE;
5096/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
5097/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
5098UNLOCK TABLES;
5099
5100--
5101-- Table structure for table `payments`
5102--
5103
5104DROP TABLE IF EXISTS `payments`;
5105/*!40101 SET @saved_cs_client     = @@character_set_client */;
5106/*!40101 SET character_set_client = utf8 */;
5107CREATE TABLE `payments` (
5108  `id` int(255) NOT NULL AUTO_INCREMENT,
5109  `tx_id` varchar(255) DEFAULT NULL,
5110  `order_id` varchar(66) NOT NULL,
5111  `user_id` int(255) NOT NULL,
5112  `type` int(1) DEFAULT NULL,
5113  `amount` decimal(10,2) NOT NULL,
5114  `bitcoin_amount` int(255) DEFAULT NULL,
5115  `date` varchar(66) NOT NULL,
5116  `complete_date` varchar(66) DEFAULT NULL,
5117  `ip_address` varchar(15) NOT NULL,
5118  `step` int(1) NOT NULL DEFAULT '2',
5119  `email` varchar(255) DEFAULT NULL,
5120  `bitcoin_address` varchar(255) DEFAULT NULL,
5121  `paypal_address` varchar(255) DEFAULT NULL,
5122  `lat` varchar(66) DEFAULT NULL,
5123  `lon` varchar(66) DEFAULT NULL,
5124  `city` varchar(166) DEFAULT NULL,
5125  `feedback` text,
5126  `bank_id` int(22) DEFAULT NULL,
5127  `status` int(1) NOT NULL DEFAULT '0',
5128  `released` int(1) NOT NULL DEFAULT '0',
5129  PRIMARY KEY (`id`)
5130) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5131/*!40101 SET character_set_client = @saved_cs_client */;
5132
5133--
5134-- Dumping data for table `payments`
5135--
5136
5137LOCK TABLES `payments` WRITE;
5138/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
5139/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
5140UNLOCK TABLES;
5141
5142--
5143-- Table structure for table `settings`
5144--
5145
5146DROP TABLE IF EXISTS `settings`;
5147/*!40101 SET @saved_cs_client     = @@character_set_client */;
5148/*!40101 SET character_set_client = utf8 */;
5149CREATE TABLE `settings` (
5150  `id` int(255) NOT NULL AUTO_INCREMENT,
5151  `feature` varchar(166) NOT NULL,
5152  `value` text NOT NULL,
5153  PRIMARY KEY (`id`)
5154) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
5155/*!40101 SET character_set_client = @saved_cs_client */;
5156
5157--
5158-- Dumping data for table `settings`
5159--
5160
5161LOCK TABLES `settings` WRITE;
5162/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
5163INSERT INTO `settings` VALUES (1,'mailgun_domain','denizb16.com'),(2,'mailgun_key','key-3fbf4e1254de126d68ad93f023c3c3bc'),(3,'website_title','Viacoin.com'),(4,'website_keywords','put,your,keywords,here'),(5,'website_description','Put your website description here.'),(6,'stripe_test_key','sk_test_lRaYYvpFpJDzgK23PI8o2vgE'),(7,'stripe_live_key','sk_live_sWGz3dXa4AU5rJGxoB392nBM'),(8,'stripe_status','0'),(9,'block_test_key','b674-3f84-8f5d-948e'),(10,'block_live_key','7d6b-8ed3-8f9b-8a20'),(11,'block_status','1'),(12,'facebook','https://www.facebook.com/viacoin.cz'),(13,'twitter','https://www.twitter.com'),(14,'youtube','https://www.youtube.com'),(15,'google','https://www.google.com'),(16,'instagram','https://www.facebook.com'),(17,'card_commission','0'),(18,'bitcoin_commission','0'),(19,'email','info@viacoin.cz'),(20,'phone','+420773232329'),(21,'paypal_address','paypal@viacoin.cz'),(22,'bitcoin_commission_user','0'),(23,'maintenance_mode','1');
5164/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
5165UNLOCK TABLES;
5166
5167--
5168-- Table structure for table `sliders`
5169--
5170
5171DROP TABLE IF EXISTS `sliders`;
5172/*!40101 SET @saved_cs_client     = @@character_set_client */;
5173/*!40101 SET character_set_client = utf8 */;
5174CREATE TABLE `sliders` (
5175  `id` int(255) NOT NULL AUTO_INCREMENT,
5176  `title` varchar(255) NOT NULL,
5177  `description` text NOT NULL,
5178  `content` text NOT NULL,
5179  `image` varchar(255) NOT NULL,
5180  PRIMARY KEY (`id`)
5181) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
5182/*!40101 SET character_set_client = @saved_cs_client */;
5183
5184--
5185-- Dumping data for table `sliders`
5186--
5187
5188LOCK TABLES `sliders` WRITE;
5189/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
5190INSERT INTO `sliders` VALUES (4,'Secured Data','Your data is safe','In viacoin, all datas are stored with ultra encryptions.  It means your all transactions and data are always secured!','7ec7d3c64922a5d21a7bd78fbf1fa61f.png'),(5,'Easy Steps','Buy/Sell Easily','You can buy or sell Bitcoins in viacoin easily, in a few minutes!','ed28688546d44085c362b398b40478a2.png'),(6,'Fast Transactions','Time is Money','You can buy or sell Bitcoins in viacoin just in a few minutes!','d39a99992ee128221a19bc7bc92ab4b7.png'),(7,'7/24 Support','We\'re Here to Help!','Our experienced support team is working 7/24 for you!','6c965b712ed14d9c7e18690a26708b32.png'),(8,'Best Prices','Best in the Market','Viacoin\'s main target is always providing best prices for customers!','798eacbcdf89f0b2fa2f0d1fead0794f.png');
5191/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
5192UNLOCK TABLES;
5193
5194--
5195-- Table structure for table `support`
5196--
5197
5198DROP TABLE IF EXISTS `support`;
5199/*!40101 SET @saved_cs_client     = @@character_set_client */;
5200/*!40101 SET character_set_client = utf8 */;
5201CREATE TABLE `support` (
5202  `id` int(255) NOT NULL AUTO_INCREMENT,
5203  `title` varchar(255) NOT NULL,
5204  `user_id` int(255) NOT NULL,
5205  `last_reply_type` int(1) NOT NULL,
5206  `last_reply_user` int(255) NOT NULL,
5207  `last_reply_date` varchar(66) NOT NULL,
5208  `status` int(1) NOT NULL DEFAULT '0',
5209  PRIMARY KEY (`id`)
5210) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5211/*!40101 SET character_set_client = @saved_cs_client */;
5212
5213--
5214-- Dumping data for table `support`
5215--
5216
5217LOCK TABLES `support` WRITE;
5218/*!40000 ALTER TABLE `support` DISABLE KEYS */;
5219/*!40000 ALTER TABLE `support` ENABLE KEYS */;
5220UNLOCK TABLES;
5221
5222--
5223-- Table structure for table `support_files`
5224--
5225
5226DROP TABLE IF EXISTS `support_files`;
5227/*!40101 SET @saved_cs_client     = @@character_set_client */;
5228/*!40101 SET character_set_client = utf8 */;
5229CREATE TABLE `support_files` (
5230  `id` int(255) NOT NULL AUTO_INCREMENT,
5231  `message_id` int(255) NOT NULL,
5232  `file` varchar(255) NOT NULL,
5233  PRIMARY KEY (`id`)
5234) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5235/*!40101 SET character_set_client = @saved_cs_client */;
5236
5237--
5238-- Dumping data for table `support_files`
5239--
5240
5241LOCK TABLES `support_files` WRITE;
5242/*!40000 ALTER TABLE `support_files` DISABLE KEYS */;
5243/*!40000 ALTER TABLE `support_files` ENABLE KEYS */;
5244UNLOCK TABLES;
5245
5246--
5247-- Table structure for table `support_messages`
5248--
5249
5250DROP TABLE IF EXISTS `support_messages`;
5251/*!40101 SET @saved_cs_client     = @@character_set_client */;
5252/*!40101 SET character_set_client = utf8 */;
5253CREATE TABLE `support_messages` (
5254  `id` int(255) NOT NULL AUTO_INCREMENT,
5255  `ticket_id` int(255) NOT NULL,
5256  `sender_type` int(1) NOT NULL,
5257  `sender_id` int(255) NOT NULL,
5258  `message` text NOT NULL,
5259  `date` varchar(66) NOT NULL,
5260  `files` int(1) NOT NULL DEFAULT '0',
5261  PRIMARY KEY (`id`)
5262) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5263/*!40101 SET character_set_client = @saved_cs_client */;
5264
5265--
5266-- Dumping data for table `support_messages`
5267--
5268
5269LOCK TABLES `support_messages` WRITE;
5270/*!40000 ALTER TABLE `support_messages` DISABLE KEYS */;
5271/*!40000 ALTER TABLE `support_messages` ENABLE KEYS */;
5272UNLOCK TABLES;
5273
5274--
5275-- Table structure for table `transactions`
5276--
5277
5278DROP TABLE IF EXISTS `transactions`;
5279/*!40101 SET @saved_cs_client     = @@character_set_client */;
5280/*!40101 SET character_set_client = utf8 */;
5281CREATE TABLE `transactions` (
5282  `id` int(255) NOT NULL AUTO_INCREMENT,
5283  `order_id` varchar(66) NOT NULL,
5284  `user_id` int(255) NOT NULL,
5285  `amount` decimal(10,2) NOT NULL,
5286  `bitcoin_amount` int(255) DEFAULT NULL,
5287  `date` varchar(66) NOT NULL,
5288  `email` varchar(255) DEFAULT NULL,
5289  `bitcoin_address` varchar(255) DEFAULT NULL,
5290  `ip_address` varchar(15) DEFAULT NULL,
5291  `feedback` text,
5292  `status` int(1) NOT NULL DEFAULT '0',
5293  `released` int(1) NOT NULL DEFAULT '0',
5294  PRIMARY KEY (`id`)
5295) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
5296/*!40101 SET character_set_client = @saved_cs_client */;
5297
5298--
5299-- Dumping data for table `transactions`
5300--
5301
5302LOCK TABLES `transactions` WRITE;
5303/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
5304/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
5305UNLOCK TABLES;
5306
5307--
5308-- Table structure for table `users`
5309--
5310
5311DROP TABLE IF EXISTS `users`;
5312/*!40101 SET @saved_cs_client     = @@character_set_client */;
5313/*!40101 SET character_set_client = utf8 */;
5314CREATE TABLE `users` (
5315  `id` int(255) NOT NULL AUTO_INCREMENT,
5316  `username` varchar(166) NOT NULL,
5317  `email` varchar(255) NOT NULL,
5318  `password` varchar(166) NOT NULL,
5319  `balance` decimal(10,2) NOT NULL,
5320  `bitcoin` int(255) NOT NULL,
5321  `register_date` varchar(66) NOT NULL,
5322  `register_ip` varchar(15) NOT NULL,
5323  `status` int(1) NOT NULL DEFAULT '1',
5324  PRIMARY KEY (`id`)
5325) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5326/*!40101 SET character_set_client = @saved_cs_client */;
5327
5328--
5329-- Dumping data for table `users`
5330--
5331
5332LOCK TABLES `users` WRITE;
5333/*!40000 ALTER TABLE `users` DISABLE KEYS */;
5334/*!40000 ALTER TABLE `users` ENABLE KEYS */;
5335UNLOCK TABLES;
5336
5337--
5338-- Table structure for table `withdrawals`
5339--
5340
5341DROP TABLE IF EXISTS `withdrawals`;
5342/*!40101 SET @saved_cs_client     = @@character_set_client */;
5343/*!40101 SET character_set_client = utf8 */;
5344CREATE TABLE `withdrawals` (
5345  `id` int(255) NOT NULL AUTO_INCREMENT,
5346  `user_id` int(255) NOT NULL,
5347  `amount` decimal(10,2) NOT NULL,
5348  `bitcoin_amount` int(255) NOT NULL,
5349  `bitcoin_address` varchar(255) NOT NULL,
5350  `date` varchar(66) NOT NULL,
5351  `ip_address` varchar(15) NOT NULL,
5352  `bank_name` varchar(255) NOT NULL,
5353  `account_owner` varchar(255) NOT NULL,
5354  `account_number` varchar(255) NOT NULL,
5355  `iban` varchar(255) NOT NULL,
5356  `lat` varchar(66) DEFAULT NULL,
5357  `lon` varchar(66) DEFAULT NULL,
5358  `city` varchar(255) DEFAULT NULL,
5359  `paid` int(1) NOT NULL DEFAULT '0',
5360  `status` int(1) NOT NULL DEFAULT '0',
5361  PRIMARY KEY (`id`)
5362) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5363/*!40101 SET character_set_client = @saved_cs_client */;
5364
5365--
5366-- Dumping data for table `withdrawals`
5367--
5368
5369LOCK TABLES `withdrawals` WRITE;
5370/*!40000 ALTER TABLE `withdrawals` DISABLE KEYS */;
5371/*!40000 ALTER TABLE `withdrawals` ENABLE KEYS */;
5372UNLOCK TABLES;
5373/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
5374
5375/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
5376/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
5377/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
5378/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
5379/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
5380/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5381/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5382
5383-- Dump completed on 2017-05-01  9:51:37