Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
- --
- -- Host: localhost Database: peatio_production
- -- ------------------------------------------------------
- -- Server version 5.7.20-0ubuntu0.16.04.1
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Table structure for table `account_versions`
- --
- DROP TABLE IF EXISTS `rabbit`;
- CREATE TABLE `rabbit` (
- `state` int(11) DEFAULT 0
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- LOCK TABLES `rabbit` WRITE;
- /*!40000 ALTER TABLE `rabbit` DISABLE KEYS */;
- INSERT INTO `rabbit` VALUES (0);
- /*!40000 ALTER TABLE `rabbit` ENABLE KEYS */;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `account_versions`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `account_versions` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `member_id` int(11) DEFAULT NULL,
- `account_id` int(11) DEFAULT NULL,
- `reason` int(11) DEFAULT NULL,
- `balance` decimal(32,16) DEFAULT NULL,
- `locked` decimal(32,16) DEFAULT NULL,
- `fee` decimal(32,16) DEFAULT NULL,
- `amount` decimal(32,16) DEFAULT NULL,
- `modifiable_id` int(11) DEFAULT NULL,
- `modifiable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `created_at` datetime DEFAULT NULL,
- `updated_at` datetime DEFAULT NULL,
- `currency` int(11) DEFAULT NULL,
- `fun` int(11) DEFAULT NULL,
- `teststr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `index_account_versions_on_account_id_and_reason` (`account_id`,`reason`) USING BTREE,
- KEY `index_account_versions_on_account_id` (`account_id`) USING BTREE,
- KEY `index_account_versions_on_member_id_and_reason` (`member_id`,`reason`) USING BTREE,
- KEY `index_account_versions_on_modifiable_id_and_modifiable_type` (`modifiable_id`,`modifiable_type`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `account_versions`
- --
- LOCK TABLES `account_versions` WRITE;
- /*!40000 ALTER TABLE `account_versions` DISABLE KEYS */;
- /*!40000 ALTER TABLE `account_versions` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `accounts`
- --
- DROP TABLE IF EXISTS `accounts`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `accounts` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `member_id` int(11) DEFAULT NULL,
- `currency` int(11) DEFAULT NULL,
- `balance` decimal(32,16) DEFAULT NULL,
- `locked` decimal(32,16) DEFAULT NULL,
- `created_at` datetime DEFAULT NULL,
- `updated_at` datetime DEFAULT NULL,
- `in` decimal(32,16) DEFAULT NULL,
- `out` decimal(32,16) DEFAULT NULL,
- `default_withdraw_fund_source_id` int(11) DEFAULT NULL,
- `teststr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `index_accounts_on_member_id_and_currency` (`member_id`,`currency`) USING BTREE,
- KEY `index_accounts_on_member_id` (`member_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `accounts`
- --
- LOCK TABLES `accounts` WRITE;
- /*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
- UNLOCK TABLES;
- DROP TABLE IF EXISTS `accounts1`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `accounts1` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `member_id` int(11) DEFAULT NULL,
- `currency` int(11) DEFAULT NULL,
- `balance` decimal(32,16) DEFAULT NULL,
- `locked` decimal(32,16) DEFAULT NULL,
- `created_at` datetime DEFAULT NULL,
- `updated_at` datetime DEFAULT NULL,
- `in` decimal(32,16) DEFAULT NULL,
- `out` decimal(32,16) DEFAULT NULL,
- `default_withdraw_fund_source_id` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `index_accounts1_on_member_id_and_currency` (`member_id`,`currency`) USING BTREE,
- KEY `index_accounts1_on_member_id` (`member_id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `accounts`
- --
- LOCK TABLES `accounts1` WRITE;
- /*!40000 ALTER TABLE `accounts1` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `accounts1` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `members`
- --
- DROP TABLE IF EXISTS `members`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `members` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `sn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `display_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `identity_id` int(11) DEFAULT NULL,
- `created_at` datetime DEFAULT NULL,
- `updated_at` datetime DEFAULT NULL,
- `state` int(11) DEFAULT NULL,
- `activated` tinyint(1) DEFAULT NULL,
- `country_code` int(11) DEFAULT NULL,
- `phone_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `disabled` tinyint(1) DEFAULT '0',
- `api_disabled` tinyint(1) DEFAULT '0',
- `nickname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `members`
- --
- LOCK TABLES `members` WRITE;
- /*!40000 ALTER TABLE `members` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `members` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `orders`
- --
- DROP TABLE IF EXISTS `orders`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `orders` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `bid` int(11) DEFAULT NULL,
- `ask` int(11) DEFAULT NULL,
- `holdaaccount_id` int(11) DEFAULT NULL,
- `plusaaccount_id` int(11) DEFAULT NULL,
- `currency` int(11) DEFAULT NULL,
- `price` decimal(32,16) DEFAULT NULL,
- `volume` decimal(32,16) DEFAULT NULL,
- `origin_volume` decimal(32,16) DEFAULT NULL,
- `state` int(11) DEFAULT NULL,
- `done_at` datetime DEFAULT NULL,
- `type` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
- `member_id` int(11) DEFAULT NULL,
- `created_at` datetime DEFAULT NULL,
- `updated_at` datetime DEFAULT NULL,
- `sn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `source` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `ord_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
- `locked` decimal(32,16) DEFAULT NULL,
- `origin_locked` decimal(32,16) DEFAULT NULL,
- `funds_received` decimal(32,16) DEFAULT '0.0000000000000000',
- `trades_count` int(11) DEFAULT '0',
- `modifiable_id` int(11) DEFAULT NULL,
- `ob_currency` int(11) DEFAULT NULL,
- `cancel_order_volume` decimal(32,16) DEFAULT NULL,
- `side` int(11) DEFAULT NULL,
- `market` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL,
- `buysell` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `index_orders_on_currency_and_state` (`currency`,`state`) USING BTREE,
- KEY `index_orders_on_member_id_and_state` (`member_id`,`state`) USING BTREE,
- KEY `index_orders_on_member_id` (`member_id`) USING BTREE,
- KEY `index_orders_on_state` (`state`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `orders`
- --
- LOCK TABLES `orders` WRITE;
- /*!40000 ALTER TABLE `orders` DISABLE KEYS */;
- /*!40000 ALTER TABLE `orders` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `trades`
- --
- DROP TABLE IF EXISTS `trades`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `trades` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `price` decimal(32,16) DEFAULT NULL,
- `unusedfunds_account_id` int(11) DEFAULT NULL,
- `volume` decimal(32,16) DEFAULT NULL,
- `ask_id` int(11) DEFAULT NULL,
- `bid_id` int(11) DEFAULT NULL,
- `trend` int(11) DEFAULT NULL,
- `currency` int(11) DEFAULT NULL,
- `created_at` datetime DEFAULT NULL,
- `updated_at` datetime DEFAULT NULL,
- `ask_member_id` int(11) DEFAULT NULL,
- `bid_member_id` int(11) DEFAULT NULL,
- `funds` decimal(32,16) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `index_trades_on_ask_id` (`ask_id`) USING BTREE,
- KEY `index_trades_on_ask_member_id` (`ask_member_id`) USING BTREE,
- KEY `index_trades_on_bid_id` (`bid_id`) USING BTREE,
- KEY `index_trades_on_bid_member_id` (`bid_member_id`) USING BTREE,
- KEY `index_trades_on_created_at` (`created_at`) USING BTREE,
- KEY `index_trades_on_currency` (`currency`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `trades`
- --
- LOCK TABLES `trades` WRITE;
- /*!40000 ALTER TABLE `trades` DISABLE KEYS */;
- /*!40000 ALTER TABLE `trades` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- -- Dump completed on 2017-12-12 21:51:08
Add Comment
Please, Sign In to add comment