PPWAczRH

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.6.16-1~exp1
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 `account_versions`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `account_versions` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `member_id` int(11) DEFAULT NULL,
28  `account_id` int(11) DEFAULT NULL,
29  `reason` int(11) DEFAULT NULL,
30  `balance` decimal(32,16) DEFAULT NULL,
31  `locked` decimal(32,16) DEFAULT NULL,
32  `fee` decimal(32,16) DEFAULT NULL,
33  `amount` decimal(32,16) DEFAULT NULL,
34  `modifiable_id` int(11) DEFAULT NULL,
35  `modifiable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
36  `created_at` datetime DEFAULT NULL,
37  `updated_at` datetime DEFAULT NULL,
38  `currency` int(11) DEFAULT NULL,
39  `fun` int(11) DEFAULT NULL,
40  PRIMARY KEY (`id`),
41  KEY `index_account_versions_on_account_id_and_reason` (`account_id`,`reason`) USING BTREE,
42  KEY `index_account_versions_on_account_id` (`account_id`) USING BTREE,
43  KEY `index_account_versions_on_member_id_and_reason` (`member_id`,`reason`) USING BTREE,
44  KEY `index_account_versions_on_modifiable_id_and_modifiable_type` (`modifiable_id`,`modifiable_type`) USING BTREE
45) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
46/*!40101 SET character_set_client = @saved_cs_client */;
47
48--
49-- Dumping data for table `account_versions`
50--
51
52LOCK TABLES `account_versions` WRITE;
53/*!40000 ALTER TABLE `account_versions` DISABLE KEYS */;
54/*!40000 ALTER TABLE `account_versions` ENABLE KEYS */;
55UNLOCK TABLES;
56
57--
58-- Table structure for table `accounts`
59--
60
61DROP TABLE IF EXISTS `accounts`;
62/*!40101 SET @saved_cs_client     = @@character_set_client */;
63/*!40101 SET character_set_client = utf8 */;
64CREATE TABLE `accounts` (
65  `id` int(11) NOT NULL AUTO_INCREMENT,
66  `member_id` int(11) DEFAULT NULL,
67  `currency` int(11) DEFAULT NULL,
68  `balance` decimal(32,16) DEFAULT NULL,
69  `locked` decimal(32,16) DEFAULT NULL,
70  `created_at` datetime DEFAULT NULL,
71  `updated_at` datetime DEFAULT NULL,
72  `in` decimal(32,16) DEFAULT NULL,
73  `out` decimal(32,16) DEFAULT NULL,
74  `default_withdraw_fund_source_id` int(11) DEFAULT NULL,
75  PRIMARY KEY (`id`),
76  KEY `index_accounts_on_member_id_and_currency` (`member_id`,`currency`) USING BTREE,
77  KEY `index_accounts_on_member_id` (`member_id`) USING BTREE
78) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
79/*!40101 SET character_set_client = @saved_cs_client */;
80
81--
82-- Dumping data for table `accounts`
83--
84
85LOCK TABLES `accounts` WRITE;
86/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
87INSERT INTO `accounts` VALUES (1,1,1,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:41:38','2018-02-16 01:41:38',NULL,NULL,NULL),(2,1,2,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:41:38','2018-02-16 01:41:38',NULL,NULL,NULL),(3,1,3,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:41:38','2018-02-16 01:41:38',NULL,NULL,NULL),(4,1,4,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:41:38','2018-02-16 01:41:38',NULL,NULL,NULL),(5,1,5,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:41:38','2018-02-16 01:41:38',NULL,NULL,NULL),(6,1,6,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:41:38','2018-02-16 01:41:38',NULL,NULL,NULL),(7,1,7,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:41:38','2018-02-16 01:41:38',NULL,NULL,NULL),(8,1,8,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:41:38','2018-02-16 01:41:38',NULL,NULL,NULL),(9,2,1,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:43:28','2018-02-16 01:43:28',NULL,NULL,NULL),(10,2,2,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:43:28','2018-02-16 01:43:28',NULL,NULL,NULL),(11,2,3,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:43:28','2018-02-16 01:43:28',NULL,NULL,NULL),(12,2,4,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:43:28','2018-02-16 01:43:28',NULL,NULL,NULL),(13,2,5,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:43:28','2018-02-16 01:43:28',NULL,NULL,NULL),(14,2,6,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:43:28','2018-02-16 01:43:28',NULL,NULL,NULL),(15,2,7,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:43:28','2018-02-16 01:43:28',NULL,NULL,NULL),(16,2,8,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:43:28','2018-02-16 01:43:28',NULL,NULL,NULL),(17,3,1,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:44:38','2018-02-16 01:44:38',NULL,NULL,NULL),(18,3,2,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:44:38','2018-02-16 01:44:38',NULL,NULL,NULL),(19,3,3,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:44:38','2018-02-16 01:44:38',NULL,NULL,NULL),(20,3,4,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:44:38','2018-02-16 01:44:38',NULL,NULL,NULL),(21,3,5,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:44:38','2018-02-16 01:44:38',NULL,NULL,NULL),(22,3,6,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:44:38','2018-02-16 01:44:38',NULL,NULL,NULL),(23,3,7,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:44:38','2018-02-16 01:44:38',NULL,NULL,NULL),(24,3,8,10000000.0000000000000000,0.0000000000000000,'2018-02-16 01:44:38','2018-02-16 01:44:38',NULL,NULL,NULL);
88/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
89UNLOCK TABLES;
90
91--
92-- Table structure for table `api_tokens`
93--
94
95DROP TABLE IF EXISTS `api_tokens`;
96/*!40101 SET @saved_cs_client     = @@character_set_client */;
97/*!40101 SET character_set_client = utf8 */;
98CREATE TABLE `api_tokens` (
99  `id` int(11) NOT NULL AUTO_INCREMENT,
100  `member_id` int(11) NOT NULL,
101  `access_key` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
102  `secret_key` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
103  `created_at` datetime DEFAULT NULL,
104  `updated_at` datetime DEFAULT NULL,
105  `trusted_ip_list` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
106  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
107  `oauth_access_token_id` int(11) DEFAULT NULL,
108  `expire_at` datetime DEFAULT NULL,
109  `scopes` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
110  `deleted_at` datetime DEFAULT NULL,
111  PRIMARY KEY (`id`),
112  UNIQUE KEY `index_api_tokens_on_access_key` (`access_key`) USING BTREE,
113  UNIQUE KEY `index_api_tokens_on_secret_key` (`secret_key`) USING BTREE
114) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
115/*!40101 SET character_set_client = @saved_cs_client */;
116
117--
118-- Dumping data for table `api_tokens`
119--
120
121LOCK TABLES `api_tokens` WRITE;
122/*!40000 ALTER TABLE `api_tokens` DISABLE KEYS */;
123INSERT INTO `api_tokens` VALUES (1,1,'HNVwaNI5svMDCxHWLNuKYoGeRxERTLJOyJx3IRqw','OoDBxi0SHXLq70jZsdn64XMGX1PJvtuYwsg0fM1i','2018-02-16 01:46:43','2018-02-16 01:46:43',NULL,'',NULL,NULL,'all',NULL),(2,2,'3xeaGwWCIKEcPFIrwbjsgDzrxxZk8nesAtBziCWf','USk6ovzA5AfFRRjwRIyatnBxa8yOqHa0bxDPpmrD','2018-02-16 01:47:38','2018-02-16 01:47:38',NULL,'',NULL,NULL,'all',NULL),(3,3,'Jp3Qbjjne8TfOUOMOwbUiHKZlgDljGEj1iQupeKx','tUp7CgA9NpW7DIOhHeiZbxIA5SxUBork64O50UxM','2018-02-16 01:48:10','2018-02-16 01:48:10',NULL,'',NULL,NULL,'all',NULL);
124/*!40000 ALTER TABLE `api_tokens` ENABLE KEYS */;
125UNLOCK TABLES;
126
127--
128-- Table structure for table `assets`
129--
130
131DROP TABLE IF EXISTS `assets`;
132/*!40101 SET @saved_cs_client     = @@character_set_client */;
133/*!40101 SET character_set_client = utf8 */;
134CREATE TABLE `assets` (
135  `id` int(11) NOT NULL AUTO_INCREMENT,
136  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
137  `attachable_id` int(11) DEFAULT NULL,
138  `attachable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
139  `file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
140  PRIMARY KEY (`id`)
141) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
142/*!40101 SET character_set_client = @saved_cs_client */;
143
144--
145-- Dumping data for table `assets`
146--
147
148LOCK TABLES `assets` WRITE;
149/*!40000 ALTER TABLE `assets` DISABLE KEYS */;
150/*!40000 ALTER TABLE `assets` ENABLE KEYS */;
151UNLOCK TABLES;
152
153--
154-- Table structure for table `audit_logs`
155--
156
157DROP TABLE IF EXISTS `audit_logs`;
158/*!40101 SET @saved_cs_client     = @@character_set_client */;
159/*!40101 SET character_set_client = utf8 */;
160CREATE TABLE `audit_logs` (
161  `id` int(11) NOT NULL AUTO_INCREMENT,
162  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
163  `operator_id` int(11) DEFAULT NULL,
164  `created_at` datetime DEFAULT NULL,
165  `updated_at` datetime DEFAULT NULL,
166  `auditable_id` int(11) DEFAULT NULL,
167  `auditable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
168  `source_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
169  `target_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
170  PRIMARY KEY (`id`),
171  KEY `index_audit_logs_on_auditable_id_and_auditable_type` (`auditable_id`,`auditable_type`) USING BTREE,
172  KEY `index_audit_logs_on_operator_id` (`operator_id`) USING BTREE
173) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
174/*!40101 SET character_set_client = @saved_cs_client */;
175
176--
177-- Dumping data for table `audit_logs`
178--
179
180LOCK TABLES `audit_logs` WRITE;
181/*!40000 ALTER TABLE `audit_logs` DISABLE KEYS */;
182/*!40000 ALTER TABLE `audit_logs` ENABLE KEYS */;
183UNLOCK TABLES;
184
185--
186-- Table structure for table `authentications`
187--
188
189DROP TABLE IF EXISTS `authentications`;
190/*!40101 SET @saved_cs_client     = @@character_set_client */;
191/*!40101 SET character_set_client = utf8 */;
192CREATE TABLE `authentications` (
193  `id` int(11) NOT NULL AUTO_INCREMENT,
194  `provider` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
195  `uid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
196  `token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
197  `secret` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
198  `member_id` int(11) DEFAULT NULL,
199  `created_at` datetime DEFAULT NULL,
200  `updated_at` datetime DEFAULT NULL,
201  `nickname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
202  PRIMARY KEY (`id`),
203  KEY `index_authentications_on_member_id` (`member_id`) USING BTREE,
204  KEY `index_authentications_on_provider_and_uid` (`provider`,`uid`) USING BTREE
205) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
206/*!40101 SET character_set_client = @saved_cs_client */;
207
208--
209-- Dumping data for table `authentications`
210--
211
212LOCK TABLES `authentications` WRITE;
213/*!40000 ALTER TABLE `authentications` DISABLE KEYS */;
214INSERT INTO `authentications` VALUES (1,'identity','1',NULL,NULL,1,'2018-02-16 01:41:39','2018-02-16 01:41:39',NULL),(2,'identity','2',NULL,NULL,2,'2018-02-16 01:43:28','2018-02-16 01:43:28',NULL),(3,'identity','3',NULL,NULL,3,'2018-02-16 01:44:38','2018-02-16 01:44:38',NULL);
215/*!40000 ALTER TABLE `authentications` ENABLE KEYS */;
216UNLOCK TABLES;
217
218--
219-- Table structure for table `comments`
220--
221
222DROP TABLE IF EXISTS `comments`;
223/*!40101 SET @saved_cs_client     = @@character_set_client */;
224/*!40101 SET character_set_client = utf8 */;
225CREATE TABLE `comments` (
226  `id` int(11) NOT NULL AUTO_INCREMENT,
227  `content` text COLLATE utf8_unicode_ci,
228  `author_id` int(11) DEFAULT NULL,
229  `ticket_id` int(11) DEFAULT NULL,
230  `created_at` datetime DEFAULT NULL,
231  `updated_at` datetime DEFAULT NULL,
232  PRIMARY KEY (`id`)
233) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
234/*!40101 SET character_set_client = @saved_cs_client */;
235
236--
237-- Dumping data for table `comments`
238--
239
240LOCK TABLES `comments` WRITE;
241/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
242/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
243UNLOCK TABLES;
244
245--
246-- Table structure for table `deposits`
247--
248
249DROP TABLE IF EXISTS `deposits`;
250/*!40101 SET @saved_cs_client     = @@character_set_client */;
251/*!40101 SET character_set_client = utf8 */;
252CREATE TABLE `deposits` (
253  `id` int(11) NOT NULL AUTO_INCREMENT,
254  `account_id` int(11) DEFAULT NULL,
255  `member_id` int(11) DEFAULT NULL,
256  `currency` int(11) DEFAULT NULL,
257  `amount` decimal(32,16) DEFAULT NULL,
258  `fee` decimal(32,16) DEFAULT NULL,
259  `fund_uid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
260  `fund_extra` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
261  `txid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
262  `state` int(11) DEFAULT NULL,
263  `aasm_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
264  `created_at` datetime DEFAULT NULL,
265  `updated_at` datetime DEFAULT NULL,
266  `done_at` datetime DEFAULT NULL,
267  `confirmations` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
268  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
269  `payment_transaction_id` int(11) DEFAULT NULL,
270  `txout` int(11) DEFAULT NULL,
271  PRIMARY KEY (`id`),
272  KEY `index_deposits_on_txid_and_txout` (`txid`,`txout`) USING BTREE
273) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
274/*!40101 SET character_set_client = @saved_cs_client */;
275
276--
277-- Dumping data for table `deposits`
278--
279
280LOCK TABLES `deposits` WRITE;
281/*!40000 ALTER TABLE `deposits` DISABLE KEYS */;
282/*!40000 ALTER TABLE `deposits` ENABLE KEYS */;
283UNLOCK TABLES;
284
285--
286-- Table structure for table `document_translations`
287--
288
289DROP TABLE IF EXISTS `document_translations`;
290/*!40101 SET @saved_cs_client     = @@character_set_client */;
291/*!40101 SET character_set_client = utf8 */;
292CREATE TABLE `document_translations` (
293  `id` int(11) NOT NULL AUTO_INCREMENT,
294  `document_id` int(11) NOT NULL,
295  `locale` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
296  `created_at` datetime DEFAULT NULL,
297  `updated_at` datetime DEFAULT NULL,
298  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
299  `body` text COLLATE utf8_unicode_ci,
300  `desc` text COLLATE utf8_unicode_ci,
301  `keywords` text COLLATE utf8_unicode_ci,
302  PRIMARY KEY (`id`),
303  KEY `index_document_translations_on_document_id` (`document_id`) USING BTREE,
304  KEY `index_document_translations_on_locale` (`locale`) USING BTREE
305) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
306/*!40101 SET character_set_client = @saved_cs_client */;
307
308--
309-- Dumping data for table `document_translations`
310--
311
312LOCK TABLES `document_translations` WRITE;
313/*!40000 ALTER TABLE `document_translations` DISABLE KEYS */;
314/*!40000 ALTER TABLE `document_translations` ENABLE KEYS */;
315UNLOCK TABLES;
316
317--
318-- Table structure for table `documents`
319--
320
321DROP TABLE IF EXISTS `documents`;
322/*!40101 SET @saved_cs_client     = @@character_set_client */;
323/*!40101 SET character_set_client = utf8 */;
324CREATE TABLE `documents` (
325  `id` int(11) NOT NULL AUTO_INCREMENT,
326  `key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
327  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
328  `body` text COLLATE utf8_unicode_ci,
329  `is_auth` tinyint(1) DEFAULT NULL,
330  `created_at` datetime DEFAULT NULL,
331  `updated_at` datetime DEFAULT NULL,
332  `desc` text COLLATE utf8_unicode_ci,
333  `keywords` text COLLATE utf8_unicode_ci,
334  PRIMARY KEY (`id`)
335) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
336/*!40101 SET character_set_client = @saved_cs_client */;
337
338--
339-- Dumping data for table `documents`
340--
341
342LOCK TABLES `documents` WRITE;
343/*!40000 ALTER TABLE `documents` DISABLE KEYS */;
344/*!40000 ALTER TABLE `documents` ENABLE KEYS */;
345UNLOCK TABLES;
346
347--
348-- Table structure for table `fund_sources`
349--
350
351DROP TABLE IF EXISTS `fund_sources`;
352/*!40101 SET @saved_cs_client     = @@character_set_client */;
353/*!40101 SET character_set_client = utf8 */;
354CREATE TABLE `fund_sources` (
355  `id` int(11) NOT NULL AUTO_INCREMENT,
356  `member_id` int(11) DEFAULT NULL,
357  `currency` int(11) DEFAULT NULL,
358  `extra` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
359  `uid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
360  `is_locked` tinyint(1) DEFAULT '0',
361  `created_at` datetime DEFAULT NULL,
362  `updated_at` datetime DEFAULT NULL,
363  `deleted_at` datetime DEFAULT NULL,
364  PRIMARY KEY (`id`)
365) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
366/*!40101 SET character_set_client = @saved_cs_client */;
367
368--
369-- Dumping data for table `fund_sources`
370--
371
372LOCK TABLES `fund_sources` WRITE;
373/*!40000 ALTER TABLE `fund_sources` DISABLE KEYS */;
374/*!40000 ALTER TABLE `fund_sources` ENABLE KEYS */;
375UNLOCK TABLES;
376
377--
378-- Table structure for table `id_documents`
379--
380
381DROP TABLE IF EXISTS `id_documents`;
382/*!40101 SET @saved_cs_client     = @@character_set_client */;
383/*!40101 SET character_set_client = utf8 */;
384CREATE TABLE `id_documents` (
385  `id` int(11) NOT NULL AUTO_INCREMENT,
386  `id_document_type` int(11) DEFAULT NULL,
387  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
388  `id_document_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
389  `member_id` int(11) DEFAULT NULL,
390  `created_at` datetime DEFAULT NULL,
391  `updated_at` datetime DEFAULT NULL,
392  `birth_date` date DEFAULT NULL,
393  `address` text COLLATE utf8_unicode_ci,
394  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
395  `country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
396  `zipcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
397  `id_bill_type` int(11) DEFAULT NULL,
398  `aasm_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
399  PRIMARY KEY (`id`)
400) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
401/*!40101 SET character_set_client = @saved_cs_client */;
402
403--
404-- Dumping data for table `id_documents`
405--
406
407LOCK TABLES `id_documents` WRITE;
408/*!40000 ALTER TABLE `id_documents` DISABLE KEYS */;
409INSERT INTO `id_documents` VALUES (1,NULL,NULL,NULL,1,'2018-02-16 01:41:38','2018-02-16 01:41:38',NULL,NULL,NULL,NULL,NULL,NULL,'verified'),(2,NULL,NULL,NULL,2,'2018-02-16 01:43:28','2018-02-16 01:43:28',NULL,NULL,NULL,NULL,NULL,NULL,'verified'),(3,NULL,NULL,NULL,3,'2018-02-16 01:44:38','2018-02-16 01:44:38',NULL,NULL,NULL,NULL,NULL,NULL,'verified');
410/*!40000 ALTER TABLE `id_documents` ENABLE KEYS */;
411UNLOCK TABLES;
412
413--
414-- Table structure for table `identities`
415--
416
417DROP TABLE IF EXISTS `identities`;
418/*!40101 SET @saved_cs_client     = @@character_set_client */;
419/*!40101 SET character_set_client = utf8 */;
420CREATE TABLE `identities` (
421  `id` int(11) NOT NULL AUTO_INCREMENT,
422  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
423  `password_digest` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
424  `is_active` tinyint(1) DEFAULT NULL,
425  `retry_count` int(11) DEFAULT NULL,
426  `is_locked` tinyint(1) DEFAULT NULL,
427  `locked_at` datetime DEFAULT NULL,
428  `last_verify_at` datetime DEFAULT NULL,
429  `created_at` datetime DEFAULT NULL,
430  `updated_at` datetime DEFAULT NULL,
431  PRIMARY KEY (`id`)
432) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
433/*!40101 SET character_set_client = @saved_cs_client */;
434
435--
436-- Dumping data for table `identities`
437--
438
439LOCK TABLES `identities` WRITE;
440/*!40000 ALTER TABLE `identities` DISABLE KEYS */;
441INSERT INTO `identities` VALUES (1,'pkdcryptos@gmail.com','$2a$10$WjCjeQlXzPLmKLT.hoY/rOkOsQTHVnBv4tVqvgKLgmAG6PIA.iquG',NULL,NULL,NULL,NULL,NULL,'2018-02-16 01:41:38','2018-02-16 01:41:38'),(2,'kumarbets@gmail.com','$2a$10$6IwLaXk1yO5fevzw5MNbU.Yg9mPd9aCJOXYE2ZvGwLCiG7SMHdBxy',NULL,NULL,NULL,NULL,NULL,'2018-02-16 01:43:28','2018-02-16 01:43:28'),(3,'rkpers2009@gmail.com','$2a$10$PAcofi5rD7mAa3xPmu5jUOwfomaENPlYyuo2SfGfxn16RNnAp94nC',NULL,NULL,NULL,NULL,NULL,'2018-02-16 01:44:38','2018-02-16 01:44:38');
442/*!40000 ALTER TABLE `identities` ENABLE KEYS */;
443UNLOCK TABLES;
444
445--
446-- Table structure for table `members`
447--
448
449DROP TABLE IF EXISTS `members`;
450/*!40101 SET @saved_cs_client     = @@character_set_client */;
451/*!40101 SET character_set_client = utf8 */;
452CREATE TABLE `members` (
453  `id` int(11) NOT NULL AUTO_INCREMENT,
454  `sn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
455  `display_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
456  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
457  `identity_id` int(11) DEFAULT NULL,
458  `created_at` datetime DEFAULT NULL,
459  `updated_at` datetime DEFAULT NULL,
460  `state` int(11) DEFAULT NULL,
461  `activated` tinyint(1) DEFAULT NULL,
462  `country_code` int(11) DEFAULT NULL,
463  `phone_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
464  `disabled` tinyint(1) DEFAULT '0',
465  `api_disabled` tinyint(1) DEFAULT '0',
466  `nickname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
467  PRIMARY KEY (`id`)
468) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
469/*!40101 SET character_set_client = @saved_cs_client */;
470
471--
472-- Dumping data for table `members`
473--
474
475LOCK TABLES `members` WRITE;
476/*!40000 ALTER TABLE `members` DISABLE KEYS */;
477INSERT INTO `members` VALUES (1,'PEAR5MIYDHKTIO',NULL,'pkdcryptos@gmail.com',NULL,'2018-02-16 01:41:38','2018-02-16 01:41:55',NULL,1,NULL,NULL,0,0,NULL),(2,'PEAUY56DLRKTIO',NULL,'kumarbets@gmail.com',NULL,'2018-02-16 01:43:28','2018-02-16 01:43:38',NULL,1,NULL,NULL,0,0,NULL),(3,'PEALGPUYVQ5TIO',NULL,'rkpers2009@gmail.com',NULL,'2018-02-16 01:44:38','2018-02-16 01:44:57',NULL,1,NULL,NULL,0,0,NULL);
478/*!40000 ALTER TABLE `members` ENABLE KEYS */;
479UNLOCK TABLES;
480
481--
482-- Table structure for table `oauth_access_grants`
483--
484
485DROP TABLE IF EXISTS `oauth_access_grants`;
486/*!40101 SET @saved_cs_client     = @@character_set_client */;
487/*!40101 SET character_set_client = utf8 */;
488CREATE TABLE `oauth_access_grants` (
489  `id` int(11) NOT NULL AUTO_INCREMENT,
490  `resource_owner_id` int(11) NOT NULL,
491  `application_id` int(11) NOT NULL,
492  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
493  `expires_in` int(11) NOT NULL,
494  `redirect_uri` text COLLATE utf8_unicode_ci NOT NULL,
495  `created_at` datetime NOT NULL,
496  `revoked_at` datetime DEFAULT NULL,
497  `scopes` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
498  PRIMARY KEY (`id`),
499  UNIQUE KEY `index_oauth_access_grants_on_token` (`token`) USING BTREE
500) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
501/*!40101 SET character_set_client = @saved_cs_client */;
502
503--
504-- Dumping data for table `oauth_access_grants`
505--
506
507LOCK TABLES `oauth_access_grants` WRITE;
508/*!40000 ALTER TABLE `oauth_access_grants` DISABLE KEYS */;
509/*!40000 ALTER TABLE `oauth_access_grants` ENABLE KEYS */;
510UNLOCK TABLES;
511
512--
513-- Table structure for table `oauth_access_tokens`
514--
515
516DROP TABLE IF EXISTS `oauth_access_tokens`;
517/*!40101 SET @saved_cs_client     = @@character_set_client */;
518/*!40101 SET character_set_client = utf8 */;
519CREATE TABLE `oauth_access_tokens` (
520  `id` int(11) NOT NULL AUTO_INCREMENT,
521  `resource_owner_id` int(11) DEFAULT NULL,
522  `application_id` int(11) DEFAULT NULL,
523  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
524  `refresh_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
525  `expires_in` int(11) DEFAULT NULL,
526  `revoked_at` datetime DEFAULT NULL,
527  `created_at` datetime NOT NULL,
528  `scopes` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
529  `deleted_at` datetime DEFAULT NULL,
530  PRIMARY KEY (`id`),
531  UNIQUE KEY `index_oauth_access_tokens_on_token` (`token`) USING BTREE,
532  UNIQUE KEY `index_oauth_access_tokens_on_refresh_token` (`refresh_token`) USING BTREE,
533  KEY `index_oauth_access_tokens_on_resource_owner_id` (`resource_owner_id`) USING BTREE
534) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
535/*!40101 SET character_set_client = @saved_cs_client */;
536
537--
538-- Dumping data for table `oauth_access_tokens`
539--
540
541LOCK TABLES `oauth_access_tokens` WRITE;
542/*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */;
543/*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */;
544UNLOCK TABLES;
545
546--
547-- Table structure for table `oauth_applications`
548--
549
550DROP TABLE IF EXISTS `oauth_applications`;
551/*!40101 SET @saved_cs_client     = @@character_set_client */;
552/*!40101 SET character_set_client = utf8 */;
553CREATE TABLE `oauth_applications` (
554  `id` int(11) NOT NULL AUTO_INCREMENT,
555  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
556  `uid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
557  `secret` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
558  `redirect_uri` text COLLATE utf8_unicode_ci NOT NULL,
559  `created_at` datetime DEFAULT NULL,
560  `updated_at` datetime DEFAULT NULL,
561  PRIMARY KEY (`id`),
562  UNIQUE KEY `index_oauth_applications_on_uid` (`uid`) USING BTREE
563) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
564/*!40101 SET character_set_client = @saved_cs_client */;
565
566--
567-- Dumping data for table `oauth_applications`
568--
569
570LOCK TABLES `oauth_applications` WRITE;
571/*!40000 ALTER TABLE `oauth_applications` DISABLE KEYS */;
572/*!40000 ALTER TABLE `oauth_applications` ENABLE KEYS */;
573UNLOCK TABLES;
574
575--
576-- Table structure for table `orders`
577--
578
579DROP TABLE IF EXISTS `orders`;
580/*!40101 SET @saved_cs_client     = @@character_set_client */;
581/*!40101 SET character_set_client = utf8 */;
582CREATE TABLE `orders` (
583  `id` int(11) NOT NULL AUTO_INCREMENT,
584  `bid` int(11) DEFAULT NULL,
585  `ask` int(11) DEFAULT NULL,
586  `currency` int(11) DEFAULT NULL,
587  `price` decimal(32,16) DEFAULT NULL,
588  `volume` decimal(32,16) DEFAULT NULL,
589  `origin_volume` decimal(32,16) DEFAULT NULL,
590  `state` int(11) DEFAULT NULL,
591  `done_at` datetime DEFAULT NULL,
592  `type` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
593  `member_id` int(11) DEFAULT NULL,
594  `created_at` datetime DEFAULT NULL,
595  `updated_at` datetime DEFAULT NULL,
596  `sn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
597  `source` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
598  `ord_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
599  `locked` decimal(32,16) DEFAULT NULL,
600  `origin_locked` decimal(32,16) DEFAULT NULL,
601  `funds_received` decimal(32,16) DEFAULT '0.0000000000000000',
602  `trades_count` int(11) DEFAULT '0',
603  PRIMARY KEY (`id`),
604  KEY `index_orders_on_currency_and_state` (`currency`,`state`) USING BTREE,
605  KEY `index_orders_on_member_id_and_state` (`member_id`,`state`) USING BTREE,
606  KEY `index_orders_on_member_id` (`member_id`) USING BTREE,
607  KEY `index_orders_on_state` (`state`) USING BTREE
608) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
609/*!40101 SET character_set_client = @saved_cs_client */;
610
611--
612-- Dumping data for table `orders`
613--
614
615LOCK TABLES `orders` WRITE;
616/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
617/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
618UNLOCK TABLES;
619
620--
621-- Table structure for table `partial_trees`
622--
623
624DROP TABLE IF EXISTS `partial_trees`;
625/*!40101 SET @saved_cs_client     = @@character_set_client */;
626/*!40101 SET character_set_client = utf8 */;
627CREATE TABLE `partial_trees` (
628  `id` int(11) NOT NULL AUTO_INCREMENT,
629  `proof_id` int(11) NOT NULL,
630  `account_id` int(11) NOT NULL,
631  `json` text COLLATE utf8_unicode_ci NOT NULL,
632  `created_at` datetime DEFAULT NULL,
633  `updated_at` datetime DEFAULT NULL,
634  `sum` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
635  PRIMARY KEY (`id`)
636) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
637/*!40101 SET character_set_client = @saved_cs_client */;
638
639--
640-- Dumping data for table `partial_trees`
641--
642
643LOCK TABLES `partial_trees` WRITE;
644/*!40000 ALTER TABLE `partial_trees` DISABLE KEYS */;
645/*!40000 ALTER TABLE `partial_trees` ENABLE KEYS */;
646UNLOCK TABLES;
647
648--
649-- Table structure for table `payment_addresses`
650--
651
652DROP TABLE IF EXISTS `payment_addresses`;
653/*!40101 SET @saved_cs_client     = @@character_set_client */;
654/*!40101 SET character_set_client = utf8 */;
655CREATE TABLE `payment_addresses` (
656  `id` int(11) NOT NULL AUTO_INCREMENT,
657  `account_id` int(11) DEFAULT NULL,
658  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
659  `created_at` datetime DEFAULT NULL,
660  `updated_at` datetime DEFAULT NULL,
661  `currency` int(11) DEFAULT NULL,
662  PRIMARY KEY (`id`)
663) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
664/*!40101 SET character_set_client = @saved_cs_client */;
665
666--
667-- Dumping data for table `payment_addresses`
668--
669
670LOCK TABLES `payment_addresses` WRITE;
671/*!40000 ALTER TABLE `payment_addresses` DISABLE KEYS */;
672/*!40000 ALTER TABLE `payment_addresses` ENABLE KEYS */;
673UNLOCK TABLES;
674
675--
676-- Table structure for table `payment_transactions`
677--
678
679DROP TABLE IF EXISTS `payment_transactions`;
680/*!40101 SET @saved_cs_client     = @@character_set_client */;
681/*!40101 SET character_set_client = utf8 */;
682CREATE TABLE `payment_transactions` (
683  `id` int(11) NOT NULL AUTO_INCREMENT,
684  `txid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
685  `amount` decimal(32,16) DEFAULT NULL,
686  `confirmations` int(11) DEFAULT NULL,
687  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
688  `state` int(11) DEFAULT NULL,
689  `aasm_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
690  `created_at` datetime DEFAULT NULL,
691  `updated_at` datetime DEFAULT NULL,
692  `receive_at` datetime DEFAULT NULL,
693  `dont_at` datetime DEFAULT NULL,
694  `currency` int(11) DEFAULT NULL,
695  `type` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
696  `txout` int(11) DEFAULT NULL,
697  PRIMARY KEY (`id`),
698  KEY `index_payment_transactions_on_txid_and_txout` (`txid`,`txout`) USING BTREE,
699  KEY `index_payment_transactions_on_type` (`type`) USING BTREE
700) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
701/*!40101 SET character_set_client = @saved_cs_client */;
702
703--
704-- Dumping data for table `payment_transactions`
705--
706
707LOCK TABLES `payment_transactions` WRITE;
708/*!40000 ALTER TABLE `payment_transactions` DISABLE KEYS */;
709/*!40000 ALTER TABLE `payment_transactions` ENABLE KEYS */;
710UNLOCK TABLES;
711
712--
713-- Table structure for table `proofs`
714--
715
716DROP TABLE IF EXISTS `proofs`;
717/*!40101 SET @saved_cs_client     = @@character_set_client */;
718/*!40101 SET character_set_client = utf8 */;
719CREATE TABLE `proofs` (
720  `id` int(11) NOT NULL AUTO_INCREMENT,
721  `root` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
722  `currency` int(11) DEFAULT NULL,
723  `ready` tinyint(1) DEFAULT '0',
724  `created_at` datetime DEFAULT NULL,
725  `updated_at` datetime DEFAULT NULL,
726  `sum` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
727  `addresses` text COLLATE utf8_unicode_ci,
728  `balance` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
729  PRIMARY KEY (`id`)
730) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
731/*!40101 SET character_set_client = @saved_cs_client */;
732
733--
734-- Dumping data for table `proofs`
735--
736
737LOCK TABLES `proofs` WRITE;
738/*!40000 ALTER TABLE `proofs` DISABLE KEYS */;
739/*!40000 ALTER TABLE `proofs` ENABLE KEYS */;
740UNLOCK TABLES;
741
742--
743-- Table structure for table `read_marks`
744--
745
746DROP TABLE IF EXISTS `read_marks`;
747/*!40101 SET @saved_cs_client     = @@character_set_client */;
748/*!40101 SET character_set_client = utf8 */;
749CREATE TABLE `read_marks` (
750  `id` int(11) NOT NULL AUTO_INCREMENT,
751  `readable_id` int(11) DEFAULT NULL,
752  `member_id` int(11) NOT NULL,
753  `readable_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
754  `timestamp` datetime DEFAULT NULL,
755  PRIMARY KEY (`id`),
756  KEY `index_read_marks_on_member_id` (`member_id`) USING BTREE,
757  KEY `index_read_marks_on_readable_type_and_readable_id` (`readable_type`,`readable_id`) USING BTREE
758) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
759/*!40101 SET character_set_client = @saved_cs_client */;
760
761--
762-- Dumping data for table `read_marks`
763--
764
765LOCK TABLES `read_marks` WRITE;
766/*!40000 ALTER TABLE `read_marks` DISABLE KEYS */;
767INSERT INTO `read_marks` VALUES (1,NULL,1,'Comment','2018-02-16 01:41:38'),(2,NULL,1,'Ticket','2018-02-16 01:41:38'),(3,NULL,2,'Comment','2018-02-16 01:43:28'),(4,NULL,2,'Ticket','2018-02-16 01:43:28'),(5,NULL,3,'Comment','2018-02-16 01:44:38'),(6,NULL,3,'Ticket','2018-02-16 01:44:38');
768/*!40000 ALTER TABLE `read_marks` ENABLE KEYS */;
769UNLOCK TABLES;
770
771--
772-- Table structure for table `running_accounts`
773--
774
775DROP TABLE IF EXISTS `running_accounts`;
776/*!40101 SET @saved_cs_client     = @@character_set_client */;
777/*!40101 SET character_set_client = utf8 */;
778CREATE TABLE `running_accounts` (
779  `id` int(11) NOT NULL AUTO_INCREMENT,
780  `category` int(11) DEFAULT NULL,
781  `income` decimal(32,16) NOT NULL DEFAULT '0.0000000000000000',
782  `expenses` decimal(32,16) NOT NULL DEFAULT '0.0000000000000000',
783  `currency` int(11) DEFAULT NULL,
784  `member_id` int(11) DEFAULT NULL,
785  `source_id` int(11) DEFAULT NULL,
786  `source_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
787  `note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
788  `created_at` datetime DEFAULT NULL,
789  `updated_at` datetime DEFAULT NULL,
790  PRIMARY KEY (`id`),
791  KEY `index_running_accounts_on_member_id` (`member_id`) USING BTREE,
792  KEY `index_running_accounts_on_source_id_and_source_type` (`source_id`,`source_type`) USING BTREE
793) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
794/*!40101 SET character_set_client = @saved_cs_client */;
795
796--
797-- Dumping data for table `running_accounts`
798--
799
800LOCK TABLES `running_accounts` WRITE;
801/*!40000 ALTER TABLE `running_accounts` DISABLE KEYS */;
802/*!40000 ALTER TABLE `running_accounts` ENABLE KEYS */;
803UNLOCK TABLES;
804
805--
806-- Table structure for table `schema_migrations`
807--
808
809DROP TABLE IF EXISTS `schema_migrations`;
810/*!40101 SET @saved_cs_client     = @@character_set_client */;
811/*!40101 SET character_set_client = utf8 */;
812CREATE TABLE `schema_migrations` (
813  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
814  UNIQUE KEY `unique_schema_migrations` (`version`)
815) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
816/*!40101 SET character_set_client = @saved_cs_client */;
817
818--
819-- Dumping data for table `schema_migrations`
820--
821
822LOCK TABLES `schema_migrations` WRITE;
823/*!40000 ALTER TABLE `schema_migrations` DISABLE KEYS */;
824INSERT INTO `schema_migrations` VALUES ('20130624011823'),('20130629015414'),('20130810162023'),('20130901010953'),('20130901154530'),('20130903080937'),('20130904215802'),('20130905025823'),('20130905132250'),('20130906073020'),('20130906073931'),('20130907110146'),('20130907124647'),('20130912144526'),('20130915150504'),('20130918143551'),('20130919091853'),('20130925154257'),('20130925165804'),('20130925171856'),('20130925175113'),('20130926011813'),('20130926014845'),('20130926075355'),('20130926170008'),('20130928080757'),('20130928113620'),('20130928122042'),('20130928165236'),('20130928190156'),('20130928194048'),('20130929012418'),('20130930172651'),('20130930183833'),('20131001103847'),('20131002012809'),('20131002190141'),('20131003003357'),('20131003021225'),('20131006183340'),('20131009132505'),('20131022035138'),('20131027012836'),('20131110214254'),('20131130190923'),('20131201011127'),('20131204020953'),('20131208012814'),('20131224162832'),('20140101175408'),('20140102024125'),('20140102172835'),('20140102172836'),('20140105034746'),('20140302094520'),('20140302094729'),('20140302161905'),('20140303060739'),('20140303080054'),('20140304015055'),('20140306020939'),('20140306021833'),('20140312061206'),('20140312071704'),('20140319022202'),('20140319022302'),('20140320142701'),('20140324060148'),('20140324062812'),('20140326170234'),('20140326191837'),('20140327044440'),('20140327062025'),('20140327065708'),('20140327105217'),('20140328101707'),('20140329070543'),('20140331084541'),('20140402043033'),('20140403031847'),('20140403070840'),('20140404074816'),('20140404101823'),('20140405053744'),('20140407011310'),('20140416143239'),('20140416143352'),('20140416151403'),('20140416194209'),('20140416194300'),('20140418082715'),('20140421061712'),('20140421080408'),('20140428203350'),('20140507120249'),('20140524014413'),('20140530133210'),('20140531054739'),('20140618004355'),('20140702035833'),('20140703065321'),('20140703070953'),('20140707115022'),('20140709084906'),('20140709085158'),('20140712030803'),('20140714143823'),('20140715002401'),('20140715040545'),('20140715083857'),('20140717033231'),('20140718134132'),('20140718141345'),('20140721125900'),('20140724033014'),('20140803202610'),('20140804002557'),('20140804151249'),('20140806141035'),('20140806141419'),('20140819085359'),('20140819090417'),('20140826083906'),('20140826093508'),('20140902112641'),('20140920062130'),('20141002075102'),('20141003040822'),('20141003061259'),('20141010083930'),('20141012124243'),('20141014085101'),('20141015034040'),('20141105023306'),('20141105090746'),('20141107031140'),('20141119155043'),('20141203042029'),('20141216120736'),('20150117151634'),('20150205011423'),('20150405053726');
825/*!40000 ALTER TABLE `schema_migrations` ENABLE KEYS */;
826UNLOCK TABLES;
827
828--
829-- Table structure for table `signup_histories`
830--
831
832DROP TABLE IF EXISTS `signup_histories`;
833/*!40101 SET @saved_cs_client     = @@character_set_client */;
834/*!40101 SET character_set_client = utf8 */;
835CREATE TABLE `signup_histories` (
836  `id` int(11) NOT NULL AUTO_INCREMENT,
837  `member_id` int(11) DEFAULT NULL,
838  `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
839  `accept_language` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
840  `ua` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
841  `created_at` datetime DEFAULT NULL,
842  PRIMARY KEY (`id`),
843  KEY `index_signup_histories_on_member_id` (`member_id`) USING BTREE
844) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
845/*!40101 SET character_set_client = @saved_cs_client */;
846
847--
848-- Dumping data for table `signup_histories`
849--
850
851LOCK TABLES `signup_histories` WRITE;
852/*!40000 ALTER TABLE `signup_histories` DISABLE KEYS */;
853INSERT INTO `signup_histories` VALUES (1,1,'76.126.212.29','en-US,en;q=0.9','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36','2018-02-16 01:41:39'),(2,2,'76.126.212.29','en-US,en;q=0.9','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36','2018-02-16 01:43:28'),(3,3,'76.126.212.29','en-US,en;q=0.9','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36','2018-02-16 01:44:38'),(4,1,'76.126.212.29','en-US,en;q=0.9','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36','2018-02-16 01:46:07'),(5,2,'76.126.212.29','en-US,en;q=0.9','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36','2018-02-16 01:47:20'),(6,3,'76.126.212.29','en-US,en;q=0.9','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36','2018-02-16 01:47:57');
854/*!40000 ALTER TABLE `signup_histories` ENABLE KEYS */;
855UNLOCK TABLES;
856
857--
858-- Table structure for table `simple_captcha_data`
859--
860
861DROP TABLE IF EXISTS `simple_captcha_data`;
862/*!40101 SET @saved_cs_client     = @@character_set_client */;
863/*!40101 SET character_set_client = utf8 */;
864CREATE TABLE `simple_captcha_data` (
865  `id` int(11) NOT NULL AUTO_INCREMENT,
866  `key` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
867  `value` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL,
868  `created_at` datetime DEFAULT NULL,
869  `updated_at` datetime DEFAULT NULL,
870  PRIMARY KEY (`id`),
871  KEY `idx_key` (`key`) USING BTREE
872) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
873/*!40101 SET character_set_client = @saved_cs_client */;
874
875--
876-- Dumping data for table `simple_captcha_data`
877--
878
879LOCK TABLES `simple_captcha_data` WRITE;
880/*!40000 ALTER TABLE `simple_captcha_data` DISABLE KEYS */;
881/*!40000 ALTER TABLE `simple_captcha_data` ENABLE KEYS */;
882UNLOCK TABLES;
883
884--
885-- Table structure for table `taggings`
886--
887
888DROP TABLE IF EXISTS `taggings`;
889/*!40101 SET @saved_cs_client     = @@character_set_client */;
890/*!40101 SET character_set_client = utf8 */;
891CREATE TABLE `taggings` (
892  `id` int(11) NOT NULL AUTO_INCREMENT,
893  `tag_id` int(11) DEFAULT NULL,
894  `taggable_id` int(11) DEFAULT NULL,
895  `taggable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
896  `tagger_id` int(11) DEFAULT NULL,
897  `tagger_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
898  `context` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
899  `created_at` datetime DEFAULT NULL,
900  PRIMARY KEY (`id`),
901  UNIQUE KEY `taggings_idx` (`tag_id`,`taggable_id`,`taggable_type`,`context`,`tagger_id`,`tagger_type`) USING BTREE
902) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
903/*!40101 SET character_set_client = @saved_cs_client */;
904
905--
906-- Dumping data for table `taggings`
907--
908
909LOCK TABLES `taggings` WRITE;
910/*!40000 ALTER TABLE `taggings` DISABLE KEYS */;
911/*!40000 ALTER TABLE `taggings` ENABLE KEYS */;
912UNLOCK TABLES;
913
914--
915-- Table structure for table `tags`
916--
917
918DROP TABLE IF EXISTS `tags`;
919/*!40101 SET @saved_cs_client     = @@character_set_client */;
920/*!40101 SET character_set_client = utf8 */;
921CREATE TABLE `tags` (
922  `id` int(11) NOT NULL AUTO_INCREMENT,
923  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
924  PRIMARY KEY (`id`),
925  UNIQUE KEY `index_tags_on_name` (`name`) USING BTREE
926) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
927/*!40101 SET character_set_client = @saved_cs_client */;
928
929--
930-- Dumping data for table `tags`
931--
932
933LOCK TABLES `tags` WRITE;
934/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
935/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
936UNLOCK TABLES;
937
938--
939-- Table structure for table `tickets`
940--
941
942DROP TABLE IF EXISTS `tickets`;
943/*!40101 SET @saved_cs_client     = @@character_set_client */;
944/*!40101 SET character_set_client = utf8 */;
945CREATE TABLE `tickets` (
946  `id` int(11) NOT NULL AUTO_INCREMENT,
947  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
948  `content` text COLLATE utf8_unicode_ci,
949  `aasm_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
950  `author_id` int(11) DEFAULT NULL,
951  `created_at` datetime DEFAULT NULL,
952  `updated_at` datetime DEFAULT NULL,
953  PRIMARY KEY (`id`)
954) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
955/*!40101 SET character_set_client = @saved_cs_client */;
956
957--
958-- Dumping data for table `tickets`
959--
960
961LOCK TABLES `tickets` WRITE;
962/*!40000 ALTER TABLE `tickets` DISABLE KEYS */;
963/*!40000 ALTER TABLE `tickets` ENABLE KEYS */;
964UNLOCK TABLES;
965
966--
967-- Table structure for table `tokens`
968--
969
970DROP TABLE IF EXISTS `tokens`;
971/*!40101 SET @saved_cs_client     = @@character_set_client */;
972/*!40101 SET character_set_client = utf8 */;
973CREATE TABLE `tokens` (
974  `id` int(11) NOT NULL AUTO_INCREMENT,
975  `token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
976  `expire_at` datetime DEFAULT NULL,
977  `member_id` int(11) DEFAULT NULL,
978  `is_used` tinyint(1) DEFAULT '0',
979  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
980  `created_at` datetime DEFAULT NULL,
981  `updated_at` datetime DEFAULT NULL,
982  PRIMARY KEY (`id`),
983  KEY `index_tokens_on_type_and_token_and_expire_at_and_is_used` (`type`,`token`,`expire_at`,`is_used`) USING BTREE
984) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
985/*!40101 SET character_set_client = @saved_cs_client */;
986
987--
988-- Dumping data for table `tokens`
989--
990
991LOCK TABLES `tokens` WRITE;
992/*!40000 ALTER TABLE `tokens` DISABLE KEYS */;
993INSERT INTO `tokens` VALUES (1,'d8c10e7e51619fda4f1499fbc4554979','2018-02-16 02:11:39',1,1,'Token::Activation','2018-02-16 01:41:39','2018-02-16 01:41:55'),(2,'d00b2b42ed3f0316445bfcc74e3c3fdb','2018-02-16 02:13:28',2,1,'Token::Activation','2018-02-16 01:43:28','2018-02-16 01:43:38'),(3,'6c43c934ef9d9de5ad32706585a9e1e2','2018-02-16 02:14:38',3,1,'Token::Activation','2018-02-16 01:44:38','2018-02-16 01:44:57');
994/*!40000 ALTER TABLE `tokens` ENABLE KEYS */;
995UNLOCK TABLES;
996
997--
998-- Table structure for table `trades`
999--
1000
1001DROP TABLE IF EXISTS `trades`;
1002/*!40101 SET @saved_cs_client     = @@character_set_client */;
1003/*!40101 SET character_set_client = utf8 */;
1004CREATE TABLE `trades` (
1005  `id` int(11) NOT NULL AUTO_INCREMENT,
1006  `price` decimal(32,16) DEFAULT NULL,
1007  `volume` decimal(32,16) DEFAULT NULL,
1008  `ask_id` int(11) DEFAULT NULL,
1009  `bid_id` int(11) DEFAULT NULL,
1010  `trend` int(11) DEFAULT NULL,
1011  `currency` int(11) DEFAULT NULL,
1012  `created_at` datetime DEFAULT NULL,
1013  `updated_at` datetime DEFAULT NULL,
1014  `ask_member_id` int(11) DEFAULT NULL,
1015  `bid_member_id` int(11) DEFAULT NULL,
1016  `funds` decimal(32,16) DEFAULT NULL,
1017  PRIMARY KEY (`id`),
1018  KEY `index_trades_on_ask_id` (`ask_id`) USING BTREE,
1019  KEY `index_trades_on_ask_member_id` (`ask_member_id`) USING BTREE,
1020  KEY `index_trades_on_bid_id` (`bid_id`) USING BTREE,
1021  KEY `index_trades_on_bid_member_id` (`bid_member_id`) USING BTREE,
1022  KEY `index_trades_on_created_at` (`created_at`) USING BTREE,
1023  KEY `index_trades_on_currency` (`currency`) USING BTREE
1024) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1025/*!40101 SET character_set_client = @saved_cs_client */;
1026
1027--
1028-- Dumping data for table `trades`
1029--
1030
1031LOCK TABLES `trades` WRITE;
1032/*!40000 ALTER TABLE `trades` DISABLE KEYS */;
1033/*!40000 ALTER TABLE `trades` ENABLE KEYS */;
1034UNLOCK TABLES;
1035
1036--
1037-- Table structure for table `two_factors`
1038--
1039
1040DROP TABLE IF EXISTS `two_factors`;
1041/*!40101 SET @saved_cs_client     = @@character_set_client */;
1042/*!40101 SET character_set_client = utf8 */;
1043CREATE TABLE `two_factors` (
1044  `id` int(11) NOT NULL AUTO_INCREMENT,
1045  `member_id` int(11) DEFAULT NULL,
1046  `otp_secret` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1047  `last_verify_at` datetime DEFAULT NULL,
1048  `activated` tinyint(1) DEFAULT NULL,
1049  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1050  `refreshed_at` datetime DEFAULT NULL,
1051  PRIMARY KEY (`id`)
1052) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1053/*!40101 SET character_set_client = @saved_cs_client */;
1054
1055--
1056-- Dumping data for table `two_factors`
1057--
1058
1059LOCK TABLES `two_factors` WRITE;
1060/*!40000 ALTER TABLE `two_factors` DISABLE KEYS */;
1061INSERT INTO `two_factors` VALUES (1,1,'jbazydcn53vyvscj','2018-02-16 01:46:43',1,'TwoFactor::App','2018-02-16 01:41:39'),(2,1,'550384',NULL,NULL,'TwoFactor::Sms','2018-02-16 01:41:55'),(3,2,'vd7zfejsw4rh6rab','2018-02-16 01:47:38',1,'TwoFactor::App','2018-02-16 01:43:28'),(4,2,'824734',NULL,NULL,'TwoFactor::Sms','2018-02-16 01:43:38'),(5,3,'m6osqajiqns6u7lo','2018-02-16 01:48:10',1,'TwoFactor::App','2018-02-16 01:44:38'),(6,3,'726444',NULL,NULL,'TwoFactor::Sms','2018-02-16 01:44:57');
1062/*!40000 ALTER TABLE `two_factors` ENABLE KEYS */;
1063UNLOCK TABLES;
1064
1065--
1066-- Table structure for table `versions`
1067--
1068
1069DROP TABLE IF EXISTS `versions`;
1070/*!40101 SET @saved_cs_client     = @@character_set_client */;
1071/*!40101 SET character_set_client = utf8 */;
1072CREATE TABLE `versions` (
1073  `id` int(11) NOT NULL AUTO_INCREMENT,
1074  `item_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1075  `item_id` int(11) NOT NULL,
1076  `event` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
1077  `whodunnit` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1078  `object` text COLLATE utf8_unicode_ci,
1079  `created_at` datetime DEFAULT NULL,
1080  PRIMARY KEY (`id`),
1081  KEY `index_versions_on_item_type_and_item_id` (`item_type`,`item_id`) USING BTREE
1082) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1083/*!40101 SET character_set_client = @saved_cs_client */;
1084
1085--
1086-- Dumping data for table `versions`
1087--
1088
1089LOCK TABLES `versions` WRITE;
1090/*!40000 ALTER TABLE `versions` DISABLE KEYS */;
1091/*!40000 ALTER TABLE `versions` ENABLE KEYS */;
1092UNLOCK TABLES;
1093
1094--
1095-- Table structure for table `withdraws`
1096--
1097
1098DROP TABLE IF EXISTS `withdraws`;
1099/*!40101 SET @saved_cs_client     = @@character_set_client */;
1100/*!40101 SET character_set_client = utf8 */;
1101CREATE TABLE `withdraws` (
1102  `id` int(11) NOT NULL AUTO_INCREMENT,
1103  `sn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1104  `account_id` int(11) DEFAULT NULL,
1105  `member_id` int(11) DEFAULT NULL,
1106  `currency` int(11) DEFAULT NULL,
1107  `amount` decimal(32,16) DEFAULT NULL,
1108  `fee` decimal(32,16) DEFAULT NULL,
1109  `fund_uid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1110  `fund_extra` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1111  `created_at` datetime DEFAULT NULL,
1112  `updated_at` datetime DEFAULT NULL,
1113  `done_at` datetime DEFAULT NULL,
1114  `txid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1115  `aasm_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1116  `sum` decimal(32,16) NOT NULL DEFAULT '0.0000000000000000',
1117  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1118  PRIMARY KEY (`id`)
1119) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1120/*!40101 SET character_set_client = @saved_cs_client */;
1121
1122--
1123-- Dumping data for table `withdraws`
1124--
1125
1126LOCK TABLES `withdraws` WRITE;
1127/*!40000 ALTER TABLE `withdraws` DISABLE KEYS */;
1128/*!40000 ALTER TABLE `withdraws` ENABLE KEYS */;
1129UNLOCK TABLES;
1130/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1131
1132/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1133/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1134/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1135/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1136/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1137/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1138/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1139
1140-- Dump completed on 2018-02-15 16:50:32