0N5iNvuw

1-- MySQL dump 10.13  Distrib 5.7.17, for Win64 (x86_64)
2--
3-- Host: localhost    Database: peatio_production
4-- ------------------------------------------------------
5-- Server version	5.7.20-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-- Table structure for table `account_versions`
20--
21
22DROP TABLE IF EXISTS `rabbit`;
23CREATE TABLE `rabbit` (
24  `state` int(11) DEFAULT 0
25) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
26LOCK TABLES `rabbit` WRITE;
27/*!40000 ALTER TABLE `rabbit` DISABLE KEYS */;
28INSERT INTO `rabbit` VALUES (0);
29/*!40000 ALTER TABLE `rabbit` ENABLE KEYS */;
30UNLOCK TABLES;
31
32DROP TABLE IF EXISTS `account_versions`;
33/*!40101 SET @saved_cs_client     = @@character_set_client */;
34/*!40101 SET character_set_client = utf8 */;
35CREATE TABLE `account_versions` (
36  `id` int(11) NOT NULL AUTO_INCREMENT,
37  `member_id` int(11) DEFAULT NULL,
38  `account_id` int(11) DEFAULT NULL,
39  `reason` int(11) DEFAULT NULL,
40  `balance` decimal(32,16) DEFAULT NULL,
41  `locked` decimal(32,16) DEFAULT NULL,
42  `fee` decimal(32,16) DEFAULT NULL,
43  `amount` decimal(32,16) DEFAULT NULL,
44  `modifiable_id` int(11) DEFAULT NULL,
45  `modifiable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
46  `created_at` datetime DEFAULT NULL,
47  `updated_at` datetime DEFAULT NULL,
48  `currency` int(11) DEFAULT NULL,
49  `fun` int(11) DEFAULT NULL,
50  `teststr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
51  PRIMARY KEY (`id`),
52  KEY `index_account_versions_on_account_id_and_reason` (`account_id`,`reason`) USING BTREE,
53  KEY `index_account_versions_on_account_id` (`account_id`) USING BTREE,
54  KEY `index_account_versions_on_member_id_and_reason` (`member_id`,`reason`) USING BTREE,
55  KEY `index_account_versions_on_modifiable_id_and_modifiable_type` (`modifiable_id`,`modifiable_type`) USING BTREE
56) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
57/*!40101 SET character_set_client = @saved_cs_client */;
58
59--
60-- Dumping data for table `account_versions`
61--
62
63LOCK TABLES `account_versions` WRITE;
64/*!40000 ALTER TABLE `account_versions` DISABLE KEYS */;
65/*!40000 ALTER TABLE `account_versions` ENABLE KEYS */;
66UNLOCK TABLES;
67
68--
69-- Table structure for table `accounts`
70--
71
72DROP TABLE IF EXISTS `accounts`;
73/*!40101 SET @saved_cs_client     = @@character_set_client */;
74/*!40101 SET character_set_client = utf8 */;
75CREATE TABLE `accounts` (
76  `id` int(11) NOT NULL AUTO_INCREMENT,
77  `member_id` int(11) DEFAULT NULL,
78  `currency` int(11) DEFAULT NULL,
79  `balance` decimal(32,16) DEFAULT NULL,
80  `locked` decimal(32,16) DEFAULT NULL,
81  `created_at` datetime DEFAULT NULL,
82  `updated_at` datetime DEFAULT NULL,
83  `in` decimal(32,16) DEFAULT NULL,
84  `out` decimal(32,16) DEFAULT NULL,
85  `default_withdraw_fund_source_id` int(11) DEFAULT NULL,
86  `teststr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
87  PRIMARY KEY (`id`),
88  KEY `index_accounts_on_member_id_and_currency` (`member_id`,`currency`) USING BTREE,
89  KEY `index_accounts_on_member_id` (`member_id`) USING BTREE
90) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
91/*!40101 SET character_set_client = @saved_cs_client */;
92
93
94
95--
96-- Dumping data for table `accounts`
97--
98
99LOCK TABLES `accounts` WRITE;
100/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
101INSERT INTO `accounts` VALUES (1,1,1,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL,NULL),(2,1,2,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL,NULL),(3,1,3,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL,NULL),(4,1,4,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL,NULL),(5,1,5,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL,NULL),(6,1,6,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL,NULL),(7,1,7,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL,NULL),(8,1,8,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL,NULL),(9,2,1,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL,NULL),(10,2,2,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL,NULL),(11,2,3,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL,NULL),(12,2,4,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL,NULL),(13,2,5,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL,NULL),(14,2,6,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL,NULL),(15,2,7,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL,NULL),(16,2,8,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL,NULL),(17,3,1,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL,NULL),(18,3,2,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL,NULL),(19,3,3,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL,NULL),(20,3,4,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL,NULL),(21,3,5,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL,NULL),(22,3,6,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL,NULL),(23,3,7,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL,NULL),(24,3,8,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL,NULL);
102/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
103UNLOCK TABLES;
104
105
106DROP TABLE IF EXISTS `accounts1`;
107/*!40101 SET @saved_cs_client     = @@character_set_client */;
108/*!40101 SET character_set_client = utf8 */;
109CREATE TABLE `accounts1` (
110  `id` int(11) NOT NULL AUTO_INCREMENT,
111  `member_id` int(11) DEFAULT NULL,
112  `currency` int(11) DEFAULT NULL,
113  `balance` decimal(32,16) DEFAULT NULL,
114  `locked` decimal(32,16) DEFAULT NULL,
115  `created_at` datetime DEFAULT NULL,
116  `updated_at` datetime DEFAULT NULL,
117  `in` decimal(32,16) DEFAULT NULL,
118  `out` decimal(32,16) DEFAULT NULL,
119  `default_withdraw_fund_source_id` int(11) DEFAULT NULL,
120  PRIMARY KEY (`id`),
121  KEY `index_accounts1_on_member_id_and_currency` (`member_id`,`currency`) USING BTREE,
122  KEY `index_accounts1_on_member_id` (`member_id`) USING BTREE
123) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
124/*!40101 SET character_set_client = @saved_cs_client */;
125--
126-- Dumping data for table `accounts`
127--
128
129LOCK TABLES `accounts1` WRITE;
130/*!40000 ALTER TABLE `accounts1` DISABLE KEYS */;
131INSERT INTO `accounts1` VALUES (1,1,1,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL),(2,1,2,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL),(3,1,3,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL),(4,1,4,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL),(5,1,5,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL),(6,1,6,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL),(7,1,7,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL),(8,1,8,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:17:12','2017-12-09 12:17:12',NULL,NULL,NULL),(9,2,1,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL),(10,2,2,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL),(11,2,3,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL),(12,2,4,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL),(13,2,5,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL),(14,2,6,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL),(15,2,7,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL),(16,2,8,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:22:15','2017-12-09 12:22:15',NULL,NULL,NULL),(17,3,1,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL),(18,3,2,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL),(19,3,3,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL),(20,3,4,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL),(21,3,5,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL),(22,3,6,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL),(23,3,7,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL),(24,3,8,10000000.0000000000000000,0.0000000000000000,'2017-12-09 12:24:01','2017-12-09 12:24:01',NULL,NULL,NULL);
132/*!40000 ALTER TABLE `accounts1` ENABLE KEYS */;
133UNLOCK TABLES;
134
135--
136-- Table structure for table `members`
137--
138
139DROP TABLE IF EXISTS `members`;
140/*!40101 SET @saved_cs_client     = @@character_set_client */;
141/*!40101 SET character_set_client = utf8 */;
142CREATE TABLE `members` (
143  `id` int(11) NOT NULL AUTO_INCREMENT,
144  `sn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
145  `display_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
146  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
147  `identity_id` int(11) DEFAULT NULL,
148  `created_at` datetime DEFAULT NULL,
149  `updated_at` datetime DEFAULT NULL,
150  `state` int(11) DEFAULT NULL,
151  `activated` tinyint(1) DEFAULT NULL,
152  `country_code` int(11) DEFAULT NULL,
153  `phone_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
154  `disabled` tinyint(1) DEFAULT '0',
155  `api_disabled` tinyint(1) DEFAULT '0',
156  `nickname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
157  PRIMARY KEY (`id`)
158) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
159/*!40101 SET character_set_client = @saved_cs_client */;
160
161--
162-- Dumping data for table `members`
163--
164
165LOCK TABLES `members` WRITE;
166/*!40000 ALTER TABLE `members` DISABLE KEYS */;
167INSERT INTO `members` VALUES (1,'PEAJDTNLXUGTIO',NULL,'pkdcryptos@gmail.com',NULL,'2017-12-09 12:17:12','2017-12-09 12:17:50',NULL,1,NULL,NULL,0,0,NULL),(2,'PEA4NCNAUSCTIO',NULL,'kumarbets@gmail.com',NULL,'2017-12-09 12:22:15','2017-12-09 12:22:27',NULL,1,NULL,NULL,0,0,NULL),(3,'PEACE5SQJ4OTIO',NULL,'rkpers2009@gmail.com',NULL,'2017-12-09 12:24:01','2017-12-09 12:24:26',NULL,1,NULL,NULL,0,0,NULL);
168/*!40000 ALTER TABLE `members` ENABLE KEYS */;
169UNLOCK TABLES;
170
171--
172-- Table structure for table `orders`
173--
174
175DROP TABLE IF EXISTS `orders`;
176/*!40101 SET @saved_cs_client     = @@character_set_client */;
177/*!40101 SET character_set_client = utf8 */;
178CREATE TABLE `orders` (
179  `id` int(11) NOT NULL AUTO_INCREMENT,
180  `bid` int(11) DEFAULT NULL,
181  `ask` int(11) DEFAULT NULL,
182  `holdaaccount_id` int(11) DEFAULT NULL,
183  `plusaaccount_id` int(11) DEFAULT NULL,
184  `currency` int(11) DEFAULT NULL,
185  `price` decimal(32,16) DEFAULT NULL,
186  `volume` decimal(32,16) DEFAULT NULL,
187  `origin_volume` decimal(32,16) DEFAULT NULL,
188  `state` int(11) DEFAULT NULL,
189  `done_at` datetime DEFAULT NULL,
190  `type` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
191  `member_id` int(11) DEFAULT NULL,
192  `created_at` datetime DEFAULT NULL,
193  `updated_at` datetime DEFAULT NULL,
194  `sn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
195  `source` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
196  `ord_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
197  `locked` decimal(32,16) DEFAULT NULL,
198  `origin_locked` decimal(32,16) DEFAULT NULL,
199  `funds_received` decimal(32,16) DEFAULT '0.0000000000000000',
200  `trades_count` int(11) DEFAULT '0',
201  `modifiable_id` int(11) DEFAULT NULL,
202  `ob_currency` int(11) DEFAULT NULL,
203  `cancel_order_volume` decimal(32,16) DEFAULT NULL,
204  `side` int(11) DEFAULT NULL,
205  `market` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
206  `buysell` int(11) DEFAULT NULL,
207  
208
209  PRIMARY KEY (`id`),
210  KEY `index_orders_on_currency_and_state` (`currency`,`state`) USING BTREE,
211  KEY `index_orders_on_member_id_and_state` (`member_id`,`state`) USING BTREE,
212  KEY `index_orders_on_member_id` (`member_id`) USING BTREE,
213  KEY `index_orders_on_state` (`state`) USING BTREE
214) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
215/*!40101 SET character_set_client = @saved_cs_client */;
216
217--
218-- Dumping data for table `orders`
219--
220
221LOCK TABLES `orders` WRITE;
222/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
223/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
224UNLOCK TABLES;
225
226--
227-- Table structure for table `trades`
228--
229
230DROP TABLE IF EXISTS `trades`;
231/*!40101 SET @saved_cs_client     = @@character_set_client */;
232/*!40101 SET character_set_client = utf8 */;
233CREATE TABLE `trades` (
234  `id` int(11) NOT NULL AUTO_INCREMENT,
235  `price` decimal(32,16) DEFAULT NULL,
236  `unusedfunds_account_id` int(11) DEFAULT NULL,
237  `volume` decimal(32,16) DEFAULT NULL,
238  `ask_id` int(11) DEFAULT NULL,
239  `bid_id` int(11) DEFAULT NULL,
240  `trend` int(11) DEFAULT NULL,
241  `currency` int(11) DEFAULT NULL,
242  `created_at` datetime DEFAULT NULL,
243  `updated_at` datetime DEFAULT NULL,
244  `ask_member_id` int(11) DEFAULT NULL,
245  `bid_member_id` int(11) DEFAULT NULL,
246  `funds` decimal(32,16) DEFAULT NULL,
247  PRIMARY KEY (`id`),
248  KEY `index_trades_on_ask_id` (`ask_id`) USING BTREE,
249  KEY `index_trades_on_ask_member_id` (`ask_member_id`) USING BTREE,
250  KEY `index_trades_on_bid_id` (`bid_id`) USING BTREE,
251  KEY `index_trades_on_bid_member_id` (`bid_member_id`) USING BTREE,
252  KEY `index_trades_on_created_at` (`created_at`) USING BTREE,
253  KEY `index_trades_on_currency` (`currency`) USING BTREE
254) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
255/*!40101 SET character_set_client = @saved_cs_client */;
256
257--
258-- Dumping data for table `trades`
259--
260
261LOCK TABLES `trades` WRITE;
262/*!40000 ALTER TABLE `trades` DISABLE KEYS */;
263/*!40000 ALTER TABLE `trades` ENABLE KEYS */;
264UNLOCK TABLES;
265/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
266
267/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
268/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
269/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
270/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
271/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
272/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
273/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
274
275-- Dump completed on 2017-12-12 21:51:08