LtJGLpB8

· 8 years ago · Feb 09, 2018, 08:08 AM
1bank-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
2--
3-- Host: localhost    Database: bank
4-- ------------------------------------------------------
5-- Server version	5.7.20-log
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-- Table structure for table `accounts`
20--
21
22DROP TABLE IF EXISTS `accounts`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `accounts` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `client_id` int(11) NOT NULL,
28  `account` varchar(14) NOT NULL,
29  `balance` decimal(13,5) NOT NULL DEFAULT '0.00000',
30  `r030` int(11) NOT NULL DEFAULT '980',
31  PRIMARY KEY (`id`),
32  UNIQUE KEY `id_UNIQUE` (`id`),
33  UNIQUE KEY `acc_r030` (`account`,`r030`)
34) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Dumping data for table `accounts`
39--
40
41LOCK TABLES `accounts` WRITE;
42/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
43INSERT INTO `accounts` VALUES (133,150,'26000111150',0.00000,840),(134,150,'26000222150',0.00000,980),(135,150,'26000333150',0.00000,978),(136,151,'26000111151',-100.00000,840),(137,151,'26000222151',-1000.00000,980),(138,151,'26000333151',28.04695,978),(139,152,'26000111152',0.00000,840),(140,152,'26000222152',0.00000,980),(141,152,'26000333152',80.95855,978);
44/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
45UNLOCK TABLES;
46/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
47
48/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
49/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
50/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
51/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
52/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
53/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
54/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
55
56-- Dump completed on 2018-01-25 13:11:14
57
58-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
59--
60-- Host: localhost    Database: bank
61-- ------------------------------------------------------
62-- Server version	5.7.20-log
63
64/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
65/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
66/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
67/*!40101 SET NAMES utf8 */;
68/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
69/*!40103 SET TIME_ZONE='+00:00' */;
70/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
71/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
72/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
73/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
74
75--
76-- Table structure for table `clients`
77--
78
79DROP TABLE IF EXISTS `clients`;
80/*!40101 SET @saved_cs_client     = @@character_set_client */;
81/*!40101 SET character_set_client = utf8 */;
82CREATE TABLE `clients` (
83  `id` int(11) NOT NULL AUTO_INCREMENT,
84  `name` varchar(45) NOT NULL,
85  PRIMARY KEY (`id`)
86) ENGINE=InnoDB AUTO_INCREMENT=153 DEFAULT CHARSET=utf8;
87/*!40101 SET character_set_client = @saved_cs_client */;
88
89--
90-- Dumping data for table `clients`
91--
92
93LOCK TABLES `clients` WRITE;
94/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
95INSERT INTO `clients` VALUES (150,'Client 1'),(151,'Client 2'),(152,'Client 3');
96/*!40000 ALTER TABLE `clients` ENABLE KEYS */;
97UNLOCK TABLES;
98/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
99
100/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
101/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
102/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
103/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
104/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
105/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
106/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
107
108-- Dump completed on 2018-01-25 13:11:14
109
110-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
111--
112-- Host: localhost    Database: bank
113-- ------------------------------------------------------
114-- Server version	5.7.20-log
115
116/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
117/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
118/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
119/*!40101 SET NAMES utf8 */;
120/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
121/*!40103 SET TIME_ZONE='+00:00' */;
122/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
123/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
124/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
125/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
126
127--
128-- Table structure for table `currencies`
129--
130
131DROP TABLE IF EXISTS `currencies`;
132/*!40101 SET @saved_cs_client     = @@character_set_client */;
133/*!40101 SET character_set_client = utf8 */;
134CREATE TABLE `currencies` (
135  `id` int(11) NOT NULL AUTO_INCREMENT,
136  `r030` int(11) NOT NULL,
137  `txt` varchar(45) NOT NULL,
138  `cc` varchar(3) NOT NULL,
139  PRIMARY KEY (`id`),
140  UNIQUE KEY `id_UNIQUE` (`id`),
141  UNIQUE KEY `r030_UNIQUE` (`r030`),
142  UNIQUE KEY `cc_UNIQUE` (`cc`),
143  UNIQUE KEY `txt_UNIQUE` (`txt`)
144) ENGINE=InnoDB AUTO_INCREMENT=1028 DEFAULT CHARSET=utf8;
145/*!40101 SET character_set_client = @saved_cs_client */;
146
147--
148-- Dumping data for table `currencies`
149--
150
151LOCK TABLES `currencies` WRITE;
152/*!40000 ALTER TABLE `currencies` DISABLE KEYS */;
153INSERT INTO `currencies` VALUES (967,682,'Ð¡Ð°ÑƒÐ´Ñ–Ð²ÑÑŒÐºÐ¸Ð¹ Ñ€iÑÐ»','SAR'),(968,702,'Ð¡Ð¸Ð³Ð°Ð¿ÑƒÑ€ÑÑŒÐºÐ¸Ð¹ Ð´Ð¾Ð»Ð°Ñ€','SGD'),(969,704,'Ð”Ð¾Ð½Ð³','VND'),(970,710,'Ð ÐµÐ½Ð´','ZAR'),(971,752,'Ð¨Ð²ÐµÐ´ÑÑŒÐºÐ° ÐºÑ€Ð¾Ð½Ð°','SEK'),(972,756,'Ð¨Ð²ÐµÐ¹Ñ†Ð°Ñ€ÑÑŒÐºÐ¸Ð¹ Ñ„Ñ€Ð°Ð½Ðº','CHF'),(973,764,'Ð‘Ð°Ñ‚','THB'),(974,784,'Ð”Ð¸Ñ€Ñ…Ð°Ð¼ ÐžÐÐ•','AED'),(975,788,'Ð¢ÑƒÐ½Ñ–ÑÑŒÐºÐ¸Ð¹ Ð´Ð¸Ð½Ð°Ñ€','TND'),(976,949,'Ð¢ÑƒÑ€ÐµÑ†ÑŒÐºÐ° Ð»Ñ–Ñ€Ð°','TRY'),(977,934,'Ð¢ÑƒÑ€ÐºÐ¼ÐµÐ½ÑÑŒÐºÐ¸Ð¹ Ð½Ð¾Ð²Ð¸Ð¹ Ð¼Ð°Ð½Ð°Ñ‚','TMT'),(978,818,'Ð„Ð³Ð¸Ð¿ÐµÑ‚ÑÑŒÐºÐ¸Ð¹ Ñ„ÑƒÐ½Ñ‚','EGP'),(979,826,'Ð¤ÑƒÐ½Ñ‚ ÑÑ‚ÐµÑ€Ð»Ñ–Ð½Ð³Ñ–Ð²','GBP'),(980,840,'Ð”Ð¾Ð»Ð°Ñ€ Ð¡Ð¨Ð','USD'),(981,860,'Ð£Ð·Ð±ÐµÑ†ÑŒÐºÐ¸Ð¹ ÑÑƒÐ¼','UZS'),(982,901,'ÐÐ¾Ð²Ð¸Ð¹ Ñ‚Ð°Ð¹Ð²Ð°Ð½ÑÑŒÐºÐ¸Ð¹ Ð´Ð¾Ð»Ð°Ñ€','TWD'),(983,959,'Ð—Ð¾Ð»Ð¾Ñ‚Ð¾','XAU'),(984,960,'Ð¡ÐŸÐ—(ÑÐ¿ÐµÑ†.Ð¿Ñ€Ð°Ð²Ð° Ð·Ð°Ð¿Ð¾Ð·Ð¸Ñ‡ÐµÐ½Ð½Ñ)','XDR'),(985,961,'Ð¡Ñ€iÐ±Ð»Ð¾','XAG'),(986,962,'ÐŸÐ»Ð°Ñ‚Ð¸Ð½Ð°','XPT'),(987,964,'ÐŸÐ°Ð»Ð°Ð´iÐ¹','XPD'),(988,978,'Ð„Ð²Ñ€Ð¾','EUR'),(989,985,'Ð—Ð»Ð¾Ñ‚Ð¸Ð¹','PLN'),(990,986,'Ð‘Ñ€Ð°Ð·Ð¸Ð»ÑŒÑÑŒÐºÐ¸Ð¹ Ñ€ÐµÐ°Ð»','BRL'),(991,972,'Ð¡Ð¾Ð¼Ð¾Ð½i','TJS'),(992,643,'Ð Ð¾ÑÑ–Ð¹ÑÑŒÐºÐ¸Ð¹ Ñ€ÑƒÐ±Ð»ÑŒ','RUB'),(993,941,'Ð¡ÐµÑ€Ð±ÑÑŒÐºÐ¸Ð¹ Ð´Ð¸Ð½Ð°Ñ€','RSD'),(994,933,'Ð‘Ñ–Ð»Ð¾Ñ€ÑƒÑÑŒÐºÐ¸Ð¹ Ñ€ÑƒÐ±Ð»ÑŒ','BYN'),(995,12,'ÐÐ»Ð¶Ð¸Ñ€ÑÑŒÐºÐ¸Ð¹ Ð´Ð¸Ð½Ð°Ñ€','DZD'),(996,944,'ÐÐ·ÐµÑ€Ð±Ð°Ð¹Ð´Ð¶Ð°Ð½ÑÑŒÐºÐ¸Ð¹ Ð¼Ð°Ð½Ð°Ñ‚','AZN'),(997,36,'ÐÐ²ÑÑ‚Ñ€Ð°Ð»Ñ–Ð¹ÑÑŒÐºÐ¸Ð¹ Ð´Ð¾Ð»Ð°Ñ€','AUD'),(998,50,'Ð¢Ð°ÐºÐ°','BDT'),(999,51,'Ð’iÑ€Ð¼ÐµÐ½ÑÑŒÐºÐ¸Ð¹ Ð´Ñ€Ð°Ð¼','AMD'),(1000,975,'Ð‘Ð¾Ð»Ð³Ð°Ñ€ÑÑŒÐºÐ¸Ð¹ Ð»ÐµÐ²','BGN'),(1001,124,'ÐšÐ°Ð½Ð°Ð´ÑÑŒÐºÐ¸Ð¹ Ð´Ð¾Ð»Ð°Ñ€','CAD'),(1002,156,'Ð®Ð°Ð½ÑŒ Ð–ÐµÐ½ÑŒÐ¼iÐ½ÑŒÐ±i','CNY'),(1003,191,'ÐšÑƒÐ½Ð°','HRK'),(1004,203,'Ð§ÐµÑÑŒÐºÐ° ÐºÑ€Ð¾Ð½Ð°','CZK'),(1005,208,'Ð”Ð°Ð½ÑÑŒÐºÐ° ÐºÑ€Ð¾Ð½Ð°','DKK'),(1006,344,'Ð“Ð¾Ð½ÐºÐ¾Ð½Ð³Ñ–Ð²ÑÑŒÐºÐ¸Ð¹ Ð´Ð¾Ð»Ð°Ñ€','HKD'),(1007,348,'Ð¤Ð¾Ñ€Ð¸Ð½Ñ‚','HUF'),(1008,356,'Ð†Ð½Ð´Ñ–Ð¹ÑÑŒÐºÐ° Ñ€ÑƒÐ¿Ñ–Ñ','INR'),(1009,360,'Ð ÑƒÐ¿Ñ–Ñ','IDR'),(1010,364,'Ð†Ñ€Ð°Ð½ÑÑŒÐºÐ¸Ð¹ Ñ€Ñ–Ð°Ð»','IRR'),(1011,368,'Ð†Ñ€Ð°ÐºÑÑŒÐºÐ¸Ð¹ Ð´Ð¸Ð½Ð°Ñ€','IQD'),(1012,376,'ÐÐ¾Ð²Ð¸Ð¹ Ñ–Ð·Ñ€Ð°Ñ—Ð»ÑŒÑÑŒÐºÐ¸Ð¹ ÑˆÐµÐºÐµÐ»ÑŒ','ILS'),(1013,981,'Ð›Ð°Ñ€i','GEL'),(1014,392,'Ð„Ð½Ð°','JPY'),(1015,398,'Ð¢ÐµÐ½ÑŒÐ³Ðµ','KZT'),(1016,410,'Ð’Ð¾Ð½Ð°','KRW'),(1017,417,'Ð¡Ð¾Ð¼','KGS'),(1018,422,'Ð›Ñ–Ð²Ð°Ð½ÑÑŒÐºÐ¸Ð¹ Ñ„ÑƒÐ½Ñ‚','LBP'),(1019,458,'ÐœÐ°Ð»Ð°Ð¹Ð·Ñ–Ð¹ÑÑŒÐºÐ¸Ð¹ Ñ€Ñ–Ð½Ð³Ð³Ñ–Ñ‚','MYR'),(1020,484,'ÐœÐµÐºÑÑ–ÐºÐ°Ð½ÑÑŒÐºÐµ Ð¿ÐµÑÐ¾','MXN'),(1021,498,'ÐœÐ¾Ð»Ð´Ð¾Ð²ÑÑŒÐºÐ¸Ð¹ Ð»ÐµÐ¹','MDL'),(1022,504,'ÐœÐ°Ñ€Ð¾ÐºÐºÐ°Ð½ÑÑŒÐºÐ¸Ð¹ Ð´Ð¸Ñ€Ñ…Ð°Ð¼','MAD'),(1023,554,'ÐÐ¾Ð²Ð¾Ð·ÐµÐ»Ð°Ð½Ð´ÑÑŒÐºÐ¸Ð¹ Ð´Ð¾Ð»Ð°Ñ€','NZD'),(1024,578,'ÐÐ¾Ñ€Ð²ÐµÐ·ÑŒÐºÐ° ÐºÑ€Ð¾Ð½Ð°','NOK'),(1025,586,'ÐŸÐ°ÐºÐ¸ÑÑ‚Ð°Ð½ÑÑŒÐºÐ° Ñ€ÑƒÐ¿Ñ–Ñ','PKR'),(1026,946,'Ð ÑƒÐ¼ÑƒÐ½ÑÑŒÐºÐ¸Ð¹ Ð»ÐµÐ¹','RON'),(1027,980,'Ð£ÐºÑ€Ð°Ñ—Ð½ÑÑŒÐºÐ° Ð³Ñ€Ð¸Ð²Ð½Ñ','UAH');
154/*!40000 ALTER TABLE `currencies` ENABLE KEYS */;
155UNLOCK TABLES;
156/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
157
158/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
159/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
160/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
161/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
162/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
163/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
164/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
165
166-- Dump completed on 2018-01-25 13:11:14
167
168-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
169--
170-- Host: localhost    Database: bank
171-- ------------------------------------------------------
172-- Server version	5.7.20-log
173
174/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
175/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
176/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
177/*!40101 SET NAMES utf8 */;
178/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
179/*!40103 SET TIME_ZONE='+00:00' */;
180/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
181/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
182/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
183/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
184
185--
186-- Table structure for table `currencyexchangerates`
187--
188
189DROP TABLE IF EXISTS `currencyexchangerates`;
190/*!40101 SET @saved_cs_client     = @@character_set_client */;
191/*!40101 SET character_set_client = utf8 */;
192CREATE TABLE `currencyexchangerates` (
193  `id` int(11) NOT NULL AUTO_INCREMENT,
194  `r030` int(11) NOT NULL,
195  `txt` varchar(45) NOT NULL,
196  `rate` decimal(20,10) NOT NULL,
197  `cc` varchar(3) NOT NULL,
198  `exchangedate` datetime NOT NULL,
199  PRIMARY KEY (`id`)
200) ENGINE=InnoDB AUTO_INCREMENT=3089 DEFAULT CHARSET=utf8;
201/*!40101 SET character_set_client = @saved_cs_client */;
202
203--
204-- Dumping data for table `currencyexchangerates`
205--
206
207LOCK TABLES `currencyexchangerates` WRITE;
208/*!40000 ALTER TABLE `currencyexchangerates` DISABLE KEYS */;
209INSERT INTO `currencyexchangerates` VALUES (3028,682,'Ð¡Ð°ÑƒÐ´Ñ–Ð²ÑÑŒÐºÐ¸Ð¹ Ñ€iÑÐ»',7.4841940000,'SAR','2018-01-25 00:00:00'),(3029,702,'Ð¡Ð¸Ð³Ð°Ð¿ÑƒÑ€ÑÑŒÐºÐ¸Ð¹ Ð´Ð¾Ð»Ð°Ñ€',22.0347950000,'SGD','2018-01-25 00:00:00'),(3030,704,'Ð”Ð¾Ð½Ð³',0.0012359000,'VND','2018-01-25 00:00:00'),(3031,710,'Ð ÐµÐ½Ð´',2.2735740000,'ZAR','2018-01-25 00:00:00'),(3032,752,'Ð¨Ð²ÐµÐ´ÑÑŒÐºÐ° ÐºÑ€Ð¾Ð½Ð°',3.6262630000,'SEK','2018-01-25 00:00:00'),(3033,756,'Ð¨Ð²ÐµÐ¹Ñ†Ð°Ñ€ÑÑŒÐºÐ¸Ð¹ Ñ„Ñ€Ð°Ð½Ðº',30.3830430000,'CHF','2018-01-25 00:00:00'),(3034,764,'Ð‘Ð°Ñ‚',0.9134680000,'THB','2018-01-25 00:00:00'),(3035,784,'Ð”Ð¸Ñ€Ñ…Ð°Ð¼ ÐžÐÐ•',7.6417060000,'AED','2018-01-25 00:00:00'),(3036,788,'Ð¢ÑƒÐ½Ñ–ÑÑŒÐºÐ¸Ð¹ Ð´Ð¸Ð½Ð°Ñ€',11.2615750000,'TND','2018-01-25 00:00:00'),(3037,949,'Ð¢ÑƒÑ€ÐµÑ†ÑŒÐºÐ° Ð»Ñ–Ñ€Ð°',7.7069150000,'TRY','2018-01-25 00:00:00'),(3038,934,'Ð¢ÑƒÑ€ÐºÐ¼ÐµÐ½ÑÑŒÐºÐ¸Ð¹ Ð½Ð¾Ð²Ð¸Ð¹ Ð¼Ð°Ð½Ð°Ñ‚',8.0192070000,'TMT','2018-01-25 00:00:00'),(3039,818,'Ð„Ð³Ð¸Ð¿ÐµÑ‚ÑÑŒÐºÐ¸Ð¹ Ñ„ÑƒÐ½Ñ‚',1.6359230000,'EGP','2018-01-25 00:00:00'),(3040,826,'Ð¤ÑƒÐ½Ñ‚ ÑÑ‚ÐµÑ€Ð»Ñ–Ð½Ð³Ñ–Ð²',40.8961620000,'GBP','2018-01-25 00:00:00'),(3041,840,'Ð”Ð¾Ð»Ð°Ñ€ Ð¡Ð¨Ð',28.8653670000,'USD','2018-01-25 00:00:00'),(3042,860,'Ð£Ð·Ð±ÐµÑ†ÑŒÐºÐ¸Ð¹ ÑÑƒÐ¼',0.0034570000,'UZS','2018-01-25 00:00:00'),(3043,901,'ÐÐ¾Ð²Ð¸Ð¹ Ñ‚Ð°Ð¹Ð²Ð°Ð½ÑÑŒÐºÐ¸Ð¹ Ð´Ð¾Ð»Ð°Ñ€',0.9380130000,'TWD','2018-01-25 00:00:00'),(3044,959,'Ð—Ð¾Ð»Ð¾Ñ‚Ð¾',39075.0470000000,'XAU','2018-01-25 00:00:00'),(3045,960,'Ð¡ÐŸÐ—(ÑÐ¿ÐµÑ†.Ð¿Ñ€Ð°Ð²Ð° Ð·Ð°Ð¿Ð¾Ð·Ð¸Ñ‡ÐµÐ½Ð½Ñ)',41.8392620000,'XDR','2018-01-25 00:00:00'),(3046,961,'Ð¡Ñ€iÐ±Ð»Ð¾',496.1960000000,'XAG','2018-01-25 00:00:00'),(3047,962,'ÐŸÐ»Ð°Ñ‚Ð¸Ð½Ð°',28807.6360000000,'XPT','2018-01-25 00:00:00'),(3048,964,'ÐŸÐ°Ð»Ð°Ð´iÐ¹',31376.6540000000,'XPD','2018-01-25 00:00:00'),(3049,978,'Ð„Ð²Ñ€Ð¾',35.6545010000,'EUR','2018-01-25 00:00:00'),(3050,985,'Ð—Ð»Ð¾Ñ‚Ð¸Ð¹',8.5784230000,'PLN','2018-01-25 00:00:00'),(3051,986,'Ð‘Ñ€Ð°Ð·Ð¸Ð»ÑŒÑÑŒÐºÐ¸Ð¹ Ñ€ÐµÐ°Ð»',8.4807130000,'BRL','2018-01-25 00:00:00'),(3052,972,'Ð¡Ð¾Ð¼Ð¾Ð½i',3.1804940000,'TJS','2018-01-25 00:00:00'),(3053,643,'Ð Ð¾ÑÑ–Ð¹ÑÑŒÐºÐ¸Ð¹ Ñ€ÑƒÐ±Ð»ÑŒ',0.5119000000,'RUB','2018-01-25 00:00:00'),(3054,941,'Ð¡ÐµÑ€Ð±ÑÑŒÐºÐ¸Ð¹ Ð´Ð¸Ð½Ð°Ñ€',0.2825090000,'RSD','2018-01-25 00:00:00'),(3055,933,'Ð‘Ñ–Ð»Ð¾Ñ€ÑƒÑÑŒÐºÐ¸Ð¹ Ñ€ÑƒÐ±Ð»ÑŒ',14.5770000000,'BYN','2018-01-25 00:00:00'),(3056,12,'ÐÐ»Ð¶Ð¸Ñ€ÑÑŒÐºÐ¸Ð¹ Ð´Ð¸Ð½Ð°Ñ€',0.2442520000,'DZD','2018-01-25 00:00:00'),(3057,944,'ÐÐ·ÐµÑ€Ð±Ð°Ð¹Ð´Ð¶Ð°Ð½ÑÑŒÐºÐ¸Ð¹ Ð¼Ð°Ð½Ð°Ñ‚',16.5091600000,'AZN','2018-01-25 00:00:00'),(3058,36,'ÐÐ²ÑÑ‚Ñ€Ð°Ð»Ñ–Ð¹ÑÑŒÐºÐ¸Ð¹ Ð´Ð¾Ð»Ð°Ñ€',23.2883740000,'AUD','2018-01-25 00:00:00'),(3059,50,'Ð¢Ð°ÐºÐ°',0.3395090000,'BDT','2018-01-25 00:00:00'),(3060,51,'Ð’iÑ€Ð¼ÐµÐ½ÑÑŒÐºÐ¸Ð¹ Ð´Ñ€Ð°Ð¼',0.0580897500,'AMD','2018-01-25 00:00:00'),(3061,975,'Ð‘Ð¾Ð»Ð³Ð°Ñ€ÑÑŒÐºÐ¸Ð¹ Ð»ÐµÐ²',18.2301370000,'BGN','2018-01-25 00:00:00'),(3062,124,'ÐšÐ°Ð½Ð°Ð´ÑÑŒÐºÐ¸Ð¹ Ð´Ð¾Ð»Ð°Ñ€',23.4122410000,'CAD','2018-01-25 00:00:00'),(3063,156,'Ð®Ð°Ð½ÑŒ Ð–ÐµÐ½ÑŒÐ¼iÐ½ÑŒÐ±i',4.5293390000,'CNY','2018-01-25 00:00:00'),(3064,191,'ÐšÑƒÐ½Ð°',4.7971070000,'HRK','2018-01-25 00:00:00'),(3065,203,'Ð§ÐµÑÑŒÐºÐ° ÐºÑ€Ð¾Ð½Ð°',1.4051590000,'CZK','2018-01-25 00:00:00'),(3066,208,'Ð”Ð°Ð½ÑÑŒÐºÐ° ÐºÑ€Ð¾Ð½Ð°',4.7889890000,'DKK','2018-01-25 00:00:00'),(3067,344,'Ð“Ð¾Ð½ÐºÐ¾Ð½Ð³Ñ–Ð²ÑÑŒÐºÐ¸Ð¹ Ð´Ð¾Ð»Ð°Ñ€',3.6926240000,'HKD','2018-01-25 00:00:00'),(3068,348,'Ð¤Ð¾Ñ€Ð¸Ð½Ñ‚',0.1153830000,'HUF','2018-01-25 00:00:00'),(3069,356,'Ð†Ð½Ð´Ñ–Ð¹ÑÑŒÐºÐ° Ñ€ÑƒÐ¿Ñ–Ñ',0.4531987000,'INR','2018-01-25 00:00:00'),(3070,360,'Ð ÑƒÐ¿Ñ–Ñ',0.0021674000,'IDR','2018-01-25 00:00:00'),(3071,364,'Ð†Ñ€Ð°Ð½ÑÑŒÐºÐ¸Ð¹ Ñ€Ñ–Ð°Ð»',0.0007861000,'IRR','2018-01-25 00:00:00'),(3072,368,'Ð†Ñ€Ð°ÐºÑÑŒÐºÐ¸Ð¹ Ð´Ð¸Ð½Ð°Ñ€',0.0237050000,'IQD','2018-01-25 00:00:00'),(3073,376,'ÐÐ¾Ð²Ð¸Ð¹ Ñ–Ð·Ñ€Ð°Ñ—Ð»ÑŒÑÑŒÐºÐ¸Ð¹ ÑˆÐµÐºÐµÐ»ÑŒ',8.4655840000,'ILS','2018-01-25 00:00:00'),(3074,981,'Ð›Ð°Ñ€i',10.7409680000,'GEL','2018-01-25 00:00:00'),(3075,392,'Ð„Ð½Ð°',0.2638533000,'JPY','2018-01-25 00:00:00'),(3076,398,'Ð¢ÐµÐ½ÑŒÐ³Ðµ',0.0899040000,'KZT','2018-01-25 00:00:00'),(3077,410,'Ð’Ð¾Ð½Ð°',0.0271069000,'KRW','2018-01-25 00:00:00'),(3078,417,'Ð¡Ð¾Ð¼',0.4059480000,'KGS','2018-01-25 00:00:00'),(3079,422,'Ð›Ñ–Ð²Ð°Ð½ÑÑŒÐºÐ¸Ð¹ Ñ„ÑƒÐ½Ñ‚',0.0186419000,'LBP','2018-01-25 00:00:00'),(3080,458,'ÐœÐ°Ð»Ð°Ð¹Ð·Ñ–Ð¹ÑÑŒÐºÐ¸Ð¹ Ñ€Ñ–Ð½Ð³Ð³Ñ–Ñ‚',6.9020040000,'MYR','2018-01-25 00:00:00'),(3081,484,'ÐœÐµÐºÑÑ–ÐºÐ°Ð½ÑÑŒÐºÐµ Ð¿ÐµÑÐ¾',1.5566590000,'MXN','2018-01-25 00:00:00'),(3082,498,'ÐœÐ¾Ð»Ð´Ð¾Ð²ÑÑŒÐºÐ¸Ð¹ Ð»ÐµÐ¹',1.7158790000,'MDL','2018-01-25 00:00:00'),(3083,504,'ÐœÐ°Ñ€Ð¾ÐºÐºÐ°Ð½ÑÑŒÐºÐ¸Ð¹ Ð´Ð¸Ñ€Ñ…Ð°Ð¼',2.9834310000,'MAD','2018-01-25 00:00:00'),(3084,554,'ÐÐ¾Ð²Ð¾Ð·ÐµÐ»Ð°Ð½Ð´ÑÑŒÐºÐ¸Ð¹ Ð´Ð¾Ð»Ð°Ñ€',21.3794460000,'NZD','2018-01-25 00:00:00'),(3085,578,'ÐÐ¾Ñ€Ð²ÐµÐ·ÑŒÐºÐ° ÐºÑ€Ð¾Ð½Ð°',3.7034020000,'NOK','2018-01-25 00:00:00'),(3086,586,'ÐŸÐ°ÐºÐ¸ÑÑ‚Ð°Ð½ÑÑŒÐºÐ° Ñ€ÑƒÐ¿Ñ–Ñ',0.2542320000,'PKR','2018-01-25 00:00:00'),(3087,946,'Ð ÑƒÐ¼ÑƒÐ½ÑÑŒÐºÐ¸Ð¹ Ð»ÐµÐ¹',7.6433080000,'RON','2018-01-25 00:00:00'),(3088,980,'Ð£ÐºÑ€Ð°Ñ—Ð½ÑÑŒÐºÐ° Ð³Ñ€Ð¸Ð²Ð½Ñ',1.0000000000,'UAH','2018-01-25 00:00:00');
210/*!40000 ALTER TABLE `currencyexchangerates` ENABLE KEYS */;
211UNLOCK TABLES;
212/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
213
214/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
215/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
216/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
217/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
218/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
219/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
220/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
221
222-- Dump completed on 2018-01-25 13:11:14
223
224-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
225--
226-- Host: localhost    Database: bank
227-- ------------------------------------------------------
228-- Server version	5.7.20-log
229
230/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
231/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
232/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
233/*!40101 SET NAMES utf8 */;
234/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
235/*!40103 SET TIME_ZONE='+00:00' */;
236/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
237/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
238/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
239/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
240
241--
242-- Table structure for table `transactions`
243--
244
245DROP TABLE IF EXISTS `transactions`;
246/*!40101 SET @saved_cs_client     = @@character_set_client */;
247/*!40101 SET character_set_client = utf8 */;
248CREATE TABLE `transactions` (
249  `id` int(11) NOT NULL AUTO_INCREMENT,
250  `date` datetime NOT NULL,
251  `debetacc` varchar(14) DEFAULT NULL,
252  `creditacc` varchar(14) DEFAULT NULL,
253  `debetr030` int(11) DEFAULT NULL,
254  `creditr030` int(11) DEFAULT NULL,
255  `sum` decimal(13,5) NOT NULL,
256  PRIMARY KEY (`id`),
257  UNIQUE KEY `id_UNIQUE` (`id`)
258) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8;
259/*!40101 SET character_set_client = @saved_cs_client */;
260
261--
262-- Dumping data for table `transactions`
263--
264
265LOCK TABLES `transactions` WRITE;
266/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
267INSERT INTO `transactions` VALUES (71,'2018-01-25 13:10:00','26000111151','26000333152',840,978,100.00000),(72,'2018-01-25 13:10:01','26000222151','26000333151',980,978,1000.00000);
268/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
269UNLOCK TABLES;
270/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
271
272/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
273/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
274/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
275/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
276/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
277/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
278/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
279
280-- Dump completed on 2018-01-25 13:11:15