Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL dump 10.15 Distrib 10.0.36-MariaDB, for debian-linux-gnu (x86_64)
- --
- -- Host: localhost Database: blockchain
- -- ------------------------------------------------------
- -- Server version 10.0.34-MariaDB-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 utf8mb4 */;
- /*!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 `activate_user`
- --
- DROP TABLE IF EXISTS `activate_user`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `activate_user` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `active` bit(1) DEFAULT NULL,
- `date_time` varchar(255) DEFAULT NULL,
- `user_id` varchar(255) DEFAULT NULL,
- `uuid` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `activate_user`
- --
- LOCK TABLES `activate_user` WRITE;
- /*!40000 ALTER TABLE `activate_user` DISABLE KEYS */;
- INSERT INTO `activate_user` VALUES (1,'','2018-08-31T08:38:48.852Z','dhaval@gmail.com','be554ced-5db5-4f73-959e-8bf5e2827220'),(2,'\0','2018-08-31T09:01:45.441Z','bhavishyagoya.l@gmail.com','ab352d3d-4571-4b6d-b14e-cb6501ca5b45'),(3,'\0','2018-08-31T09:05:01.115Z','dhavalmanjaria@gmail.com','d9731648-6a27-47c6-9ec6-8a590ccb0d95'),(4,'','2018-08-31T09:13:16.115Z','dhv2712@gmail.com','66ca558d-3bcc-4080-a437-1eb28c8a4fad'),(5,'\0','2018-08-31T09:25:11.115Z','dhv2712@gmail.com','cb5117f3-6063-4b2b-b57d-40f034eb8015'),(6,'\0','2018-08-31T09:31:31.115Z','dhv2712@gmail.com','e0755801-cff7-45fa-b3ea-f330ee006c02'),(7,'\0','2018-08-31T09:39:41.115Z','b.h.avishyagoyal@gmail.com','fddc9730-6a60-40fe-967a-f2c2090f5d27'),(8,'\0','2018-08-31T10:09:36.891Z','dhv2712@gmail.com','3c4aaa30-e747-4fdc-be7c-9bca8f560c4d'),(9,'\0','2018-08-31T10:24:26.891Z','dhv2712@gmail.com','0edcdb32-4409-4fcd-b29b-5b80ce8c333d'),(10,'','2018-08-31T10:34:11.891Z','dhv2712@gmail.com','a2c3c150-1ab7-4df6-bd29-6a0d0ca77bfb'),(11,'\0','2018-08-31T10:42:31.891Z','dhv2712@gmail.com','541aeab0-0f70-447b-b81b-0b02a05bf574'),(12,'\0','2018-08-31T11:06:16.891Z','dhv2712@gmail.com','5d72edea-da4d-4049-a6e9-0f67eb080a96'),(16,'','2018-08-31T19:58:27.859Z','paddyrank@panddtool.com','b161ea3d-063b-4f6c-9e93-4f5ca292b178'),(17,'','2018-09-01T06:52:10.627Z','bhavishyagoy.a.l@gmail.com','a0b3ff1e-d283-465d-ba77-2bc1e263cbae'),(18,'\0','2018-09-01T07:44:52.701Z','dhv.2712@gmail.com','7272f28f-139c-46f1-9a93-ef96d4d5e71c'),(19,'\0','2018-09-01T09:47:42.701Z','paddyrank@gmx.com','860876e4-df4f-49d1-bcbb-23e862041e34'),(20,'\0','2018-09-03T09:23:49.539Z','d.hv2712@gmail.com','4b5db3f3-0174-421e-8435-93face23f05e'),(21,'\0','2018-09-03T22:38:29.658Z','paddyrank1@gmx.com','db15f521-13ef-41a4-be92-65791923a0fc');
- /*!40000 ALTER TABLE `activate_user` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `address_pool`
- --
- DROP TABLE IF EXISTS `address_pool`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `address_pool` (
- `public_key` varchar(255) NOT NULL,
- `is_available` bit(1) DEFAULT NULL,
- `private_key` varchar(255) DEFAULT NULL,
- `symbol` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`public_key`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `address_pool`
- --
- LOCK TABLES `address_pool` WRITE;
- /*!40000 ALTER TABLE `address_pool` DISABLE KEYS */;
- INSERT INTO `address_pool` VALUES ('0x0484E365DCDE3481D15beb9E4d416Ca9F5f20b0f','\0','e1002b705c4c84c5c0d081fbd3885fe20d32185ee483a021c6dc5a4824b9c013','ETH'),('0x072b750A4D0b06a721B1e77bC7b2a4e5496eE588','','5d613d624c55d2ad8ecf953bcba01ff72eeac68150cb5b3e602ee9df573f966a','ETH'),('0x0a0db68442abef4Bb2C2C2a2EE9Fc1f4ea536AB0','','82ff08be45f7574556ca30c84c86a047d188d2fd16428c856e68246fd2fd5a87','ETH'),('0x0AEbbD94D22d8bE2864417d4373c64eBAE6f7602','','9127208ab8f8e090a2a0586da2ac47f5188b0b0f1a4a1affd3dc99faf8cfd890','ETH'),('0x0C6BDD1F7CCCc77f189696092714FE5D0Cc0d854','\0','9ecccd7552816442b174c628b9393cc39f17fe9795c22a707a7f8a3e99433e1c','ETH'),('0x0D22d8E72C9474D0378442535de3df83e8D8CC34','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','ETH'),('0x13dd86De82a1E6a92B251b219278b7BD02a237d1','','a8addc8e7b82c7479f15f6055af2f653d05ceb0f8d29d6e3b7502e0d89d80ec6','ETH'),('0x157716eC7A1C0AD319e61c3bC891e72278A61D86','','91d11f9b93965b77b3518b5fad0f2e0d2e8a2eeb31ebc341ff38b8f244da9a20','ETH'),('0x172a65bDeE85f81df78970437f82b473b19cDaD0','','9b0ca5f45f1896b9efd1ec6540612f7ae1babcce3eefd7c8d8408c467644d851','ETH'),('0x1fB0055674Edb4e0859F7e30c9d44600AC5213b4','','d5cd7375ae3905447a6af87acccc0fa0544d111f8b715ba37ab334de0a15396f','ETH'),('0x20b8e6D21830093eF339495a96773bE09A5aB65b','','7fd6bad8cc4b694df59ee0a4d20ebca8ace168902e9a9136b0bc185d9e22530f','ETH'),('0x26068d32C477A74B13b17e2D2873376da9F24310','\0',' d3b788342914dbaf4d737575e4ea8c9c71329db4396ef8a2b160be22e816a7d0','ETH'),('0x2B5e1EB149a9BA8ae88e31db30a05aFEDE76EE34','','65167bdb46b3fd05b78921f94d3b41a2d36790eedd47f6ee94b4808765788d01','ETH'),('0x40f20a0dFaDCd25bcA339f37594a9aa43Cfc8289','','d48a871e2f6f78c2c4a74bd0eb99fa92e677194523b27d0f503311d5c7bf28d8','ETH'),('0x439942D34fd408128eBbaa7115dc84b876df1706','','4fb0980b7f9d7a8a0a313f1fa86c860e9562076348a5a910fc0498a3004b7dda','ETH'),('0x43A509DE6efA32bc16aC934E60780A003A413f82','','088dd51e15a5ff24577349c76c0abc0d48a788dcbf20f6e14c707293c166426e','ETH'),('0x45D6C1430c75d1Ef14EDbC4FB874e1a6e31f9Af8','\0','913d882ff1ff81d72e43030f14f8763a8973c7c79a8b4116bf98026aec44bb72','ETH'),('0x48C73ACD8533AED20AAFC357f778c50dd09E28f0','','42488f537ddf6b4c49a2a01447af71eaf78c898f51ce74b87c1ceaade0d78c80','ETH'),('0x4a311EbBd994a490F850bA1132653cD763531090','','05cfa983ad60fb43b784bb56b71280e330c847f868e93140db029aabb1fb0d79','ETH'),('0x4Ac2B100367dC639D19c9F93ae7dB52C0C0AB301','','cdeb99b962f0d7dafdcf5294549cfae48344e07abe2031920124746ccfd130c4','ETH'),('0x4CFae359BCBB0AFB16044E6650671456FDF066DC','','11187243142bdc90e2a8586fd7fe7881d1ef612ce4419843a713d07bb465b62d','ETH'),('0x4F5D4519D2d6707Dcd7B53838b9F0684598587EE','','b2a0cd95534341f7018ad9bb2dfa899a9a698502bd0dee1ea721c99585c718cc','ETH'),('0x509148bBf5E2B46E47aEE12003D8c9f3cD1b3Ef4','','586be615ebecc351a28da90e5e9cb66a8c14b5591fa05307bb0c9dab23a85615','ETH'),('0x51f4c78596ff225135d25Cfd88AcA2Bd9781bea7','','8a7d4456b8f13ecd378bead308c09a23f7f37041e226b700f241bc5ede3329e2','ETH'),('0x5397a5394041400C6de697EdE6Ab7015614d2e39','','4622f41c7e10a690e0542fe451b26f1dcfc806d46a9fc6dfb851ee7b2fef725b','ETH'),('0x5D7FB04A93145F0153D4734ab3c824806841Ad56','\0','e9669e9cbe61107ea44499ec9c7848046ed87a6eb5cde792f0dbd215567b2655','ETH'),('0x6423BA32aF49352Ff0748B97eD311Ef0033a5C98','','90f4c07e4a79d214176776eb13a9265251bdf61df3955b8caeed728f801986d3','ETH'),('0x6647182144cC5D82C8c5D114D36D7023B341e182','','8d27ad8fa104d00edca629850c927829eea2b8df15e7714950c010a069d5cb46','ETH'),('0x69a45b2a4F368a451341955FBdFF4DcB80CEB318','\0','e6fb01d65f875ea315f61dbda8363c8f99891073f38cdc2c2aa9f8d710ef1f03','ETH'),('0x69Fc9a788538F8449947a400a1d9B73d9F7F4d96','','cb8f7c05031f5c2f7448dc0c6e25548ccd95db9a4ef837124b9b46876d51c03a','ETH'),('0x714744D71644292f8291c9FA2f059A9F27f6827a','','9647d39a71d3d7f739e2f5ebf20df73f2a232c96c270cfd87c4abfa03c6933d4','ETH'),('0x7FD29C9ED511b3DebfD1F1F7f94fAd6662d85888','\0','ff8d40b530500f9cf4aae2c7b0222cb98bb04fe68537fdca1119555bea47c534','ETH'),('0x829C346E4cCe8E719D3D795E66f9FD612CaaeaE2','','ac5e4aeb78ca8a5cb51ea762bf1ac87d64c60a42f25dcfd2a82a4adff4d1a72a','ETH'),('0x8b2d982692446Dc025b7d1551d706d78DF98c17a','\0','575b1382b41abb62b2e1ff3c6d8d79119e6780fecdc321a7fdfcce5264081c7c','ETH'),('0xA273535a113B88BEA81e4a0e5CA6405dCcCEC301','\0','13f016f590d803487dff44d1753cdaa5fce6f121acc4cc66395d5ca9d153589d','ETH'),('0xaF5557CD07E1EED589a6a5632A4a182086333BD3','','efecf2997d6294796b24178e4389142128a8c7f166e71680e2d79d6c8502e728','ETH'),('0xAFBd22Dfd8D892EA47Eda1d7a9aeb8375e741b92','','60937e44e1287c90103bc3edacd0e1e7fe464036c1c59c17b5acb1435a3f73a5','ETH'),('0xb264dB68Ff1C996Dd4B5371Fa32f4676623C7aAf','\0',' 2d8011ed9e165ca49557453bb84bcdffa90ddb1996c7b83a990957543a505ffd','ETH'),('0xb8291e1b06293213f28450C08fA4345b13BDa366','','72977d27399bd1cae7e469a1cc18501aa25d90081fc2534e8b98324d8a1e6144','ETH'),('0xB93dF5f4965356Cd40b335830ba14c7CC443085D','','33bdf4817661294be9fda92113c39aa66188264987c2abf668c6105818d74022','ETH'),('0xbc301af332B2Ce698EEc90B1732F968A34e3ea72','\0','dfe832aa7f9824432816048232ad7b852070a5ed67e277a4957c2263d82f831a','ETH'),('0xbD7a50669C8025b2A28ef07d2056945fB5bA9b36','','7032bbb42dcc9f22e4c89f393247bcfcf974953befa5500cfca712dc6e08a0a4','ETH'),('0xBDDecA3410069219c2EB3234a65489540Fa5Ddf0','','f07c2d9609e2b2e41d09c5b5089fe49152c2ff385fc2d5e90797b296d42e951a','ETH'),('0xc56cA6cB5c5A78163Bbb215Cfc833b343BecF645','','121dbfd32c2fcc651101c038bf54f5a26d327aed86e032d60f10ad466abf9fb6','ETH'),('0xc8D7360D3F1045cd18E72CC89CE64232f35Db2FB','','e6c8244153c1adde739dc4f7c8fe78a22c8079f4931b693709bf088a221be12b','ETH'),('0xC8e4596B867f45D4b13f81522507C1328f325219','','0da944d665553f961a8fe7a4e5f5be59ae73ba7263fb36533bd8b5d24aa65724','ETH'),('0xc9141BA90F8E8bA1174bBf0baB11d9b4f9c9c8F2','','849566a60d8f48e8fa30ceed8a716710b6057a743b90374108a88addd500b3a8','ETH'),('0xC98a18606aF4A2Fe3565466c38d56defF18d40EE','','30c6745ea8481f4892ccf38a3522fd11d98102dd7cbceb76856393faf66543b5','ETH'),('0xc9daF25c8F5Db85b58eaDF4ad5eBcBd079E92df3','','e590418f43cf61e446f0957ad293a383181883fd25576b280dbfc7b398a60c11','ETH'),('0xCc53d211e66C91E86E72393111Aa72af54825987','','6372c952b40419dcc33b4eb9f378e1d15353cc18c62fa1360e3999af29276165','ETH'),('0xCC78B45a16BcBe6eD1c8128938aFF8aD6827AcEe','','7ea777b4437ae67e2694714c4c26be2755839ba7c1d039806328cec84ef9cbba','ETH'),('0xCc98fcAF2B24ED0F91560140DF6F404b99CAb41D','','dc34ae5fd926895ae32b0b488714609032ee693eb505e3d0b033ab521de29b7a','ETH'),('0xcD502bdC9115B37ECebb0Da7FC31B72af51910f8','','8e7f10c1878ae677abeb9a6fda2f155fc02f832bd517d822107d8b0d2e2d8b87','ETH'),('0xCe5b1Aa578bCC2433490C120a299E9b3CCb4E5EC','','b276f0f4b3ae06586736830b0f086fed7fc3ece5546c7123e721d7688ec92703','ETH'),('0xd5D7B370D9D5F05f5235e9E241AE742dd3D7DcAD','\0','1af7074528605acb8e98ad4bfe52cd1a45eaba7766dcfb2856ca5a59c1471f75','ETH'),('0xD8548CF36411a40471790d1f5be4B88a1B21Df33','','1dfd347fad537233659b98c0a3b5ccede0df0edb33128b878c44ae6e89c1f417','ETH'),('0xDdc0634408f327C22935b77580A0f54b115C72eF','','624f5f9c8620e0ac3358fcd150b0be071602c7de4e1ba50e2dbf0e4be901f35e','ETH'),('0xe1608eD867cc51f1aCA1034647324AbefD4cC97d','','075734e2ae5d30096aa7aacae55d5be18baf80f67515a34e74869836605c71d5','ETH'),('0xe236531DD08299477C646b3fC5Ac93014eF3324F','','82baf7f87c2a049864f53accda9810ddf96d68c2e8feb51e0512552e5fe25c71','ETH'),('0xE7768de417Ab99ED917E923aE11Dfc840e0E52E9','','0adaab2c199621a5b14dbf95edd6c33e110e7641c5c8d1683f57dbef5fa5dc4b','ETH'),('0xeF2427A9D0e99373F94dA1daC50bCE8583891C05','','3ca5a75cc87b77965531adae08e49fef64296cb9551d2fec55b7d560f241f933','ETH'),('0xf0AB9caA580b33d8ab64a07b533fdBf8A1682076','','5414cfe692722631c604885b45083243ae2777649ede71d7a5b9f83d7d9d08c5','ETH'),('0xf1e30eC3F0F4B4aD2736A20BFB108559e05Dd6b8','','82fcd1c40017ec71b18f28b163c584a46ab9f97d95c3f68e3675af4efde17428','ETH'),('0xfAAd164810a12b076ed52a3F4DFfea5350779E9C','',' 9d43d36e9faeb08b33397f16a402151de82a5e1ad4dbfc5c121e6c4da02cf75d','ETH'),('0xFB40a0Ac61fe3845Ffd62d2e76A949e25C2418EC','','d1c5e9de201d5e690be0f4f00b1503e3378998412d9277b739a7264d0de0e4f4','ETH'),('1153oVoCx2QDxV3HvJwfvyxdDzCw9xyzyzN','\0','L1CUUo12k8Pn1mdRY43sVEXqdxphFDSkdTpXPEe7XSUdj8znKaVa','BTC'),('12j4rHKvNb5fM14jE7KiDAdaFso1z6BSC5','\0','L46knsHFLsmKiVVh9EZGmpQL6E81yNsN7UqmAYHaZaaEZbH69njd','BTC'),('12jP1k69FgX1KqNtpJtBi4oxdmiseFvTwA','','L5E3gQWY8F4dbg7UMTYiRAv2rUXi5TDQadHVvajtvvDUBH7ocgEP','BTC'),('12KaGnKn7jvRZwvLNx6Egp52ssSCKbpXt8','','L4qNmy2v1DYtsTzWomqttqvFdYfzVgw2Gzk6vcxzZNByTrkwWtsG','BTC'),('13ao2LwvaeDdAWa5f2etcd5w34qsWZzY8S','','L5YDCtVY6uuJG3bpx2nBQUYqzcMLtj8XHNbVGRtS5TTdzqvS1Apq','BTC'),('13EDg43NftXkrK1G5TSyS1Kbzknp8qW7j8','','KwfjcEvHZFzoCUbUf21ZkgEz7u3XR3UtxZHU4FkdVnt429K9v32a','BTC'),('13ULUqoSbJQwc5WyFpWksQ5JaVyP8bLhDc','','KxpvmHsnq4rx4suGSdg4fhGs9GtY437FrDEmjUtRA2Th5sCP6rtV','BTC'),('157w8tiBtfjh32SZctLhvD1zYPurQdNDMa','','KwVicGbsdjX4fV7iNCx1e9NharW1vatparMURdUAFKVFUHrAoFoR','BTC'),('15CR4H61pTDAkxEvVPoYMm8KDSViwsC9fn','','Kxehx7zwHbxNCQ61byWXoq8sxb5oiYURwDh7htwk9H5QupsVe7Bi','BTC'),('15E8aPAM3qQ6HxasGhNo9VstMuQMdDB1sS','','KzW84Cz7RsXeJb6h2sJ1RoKLHbiLbsJqsQLpTC8ZvHW8YzpXDQtw','BTC'),('15UnDgNdifrxpVp2Tn6vB7er1GVk2Xha8q','','KzL8DMfwWEFBndtfRT8X213Hgwb3LCHsjzRw1PwKtdNC69bfDo5o','BTC'),('15vHgVCGDukGYc9uaC5Z2eAZDtZpcXVbw9','','L1aQ7dZx7r2czEyzgzsSaK45gbwj6Gw9xxi65tQt9EY4fUmV7YRx','BTC'),('16jyGJBVHvKJDucpcwYL7iK1Nr7Ldw6v6y','\0','L3itDMYHi262GnZjT66LdmU35xx2czW9SPAbKncrBb9GEC641ExA','BTC'),('16LZ5m6xDqPg2WXxRkz5HykbFBgeRXbQYn','\0','L42fZH9RzdtrvUKk4n4vXyoxi9szjw51qcTBbNswq9JxMDMBymYp','BTC'),('16XGaeb2Jv5rCsBk2pAXNSYZcARWiNuEAo','\0','KxYsuKsRGqbUbgBw73yQXxxK5cyJkN9gLUF5PtxMg89jS6sWfiZ5','BTC'),('16yL4sw7S7SRtkTLh9sHD1FRH9p9YXBZE1','','KwWaCMvPBEpKY5ctU26ZRcRwR1yzGGtc84ovYW9g3ZSBPv5QxJZj','BTC'),('17guebe2RFmHntPTpVk4aQdR7n9WtbLP9f','','L5mHibcafUCt5CdngH8nHSwuSNjQVLJUQSQi497PN1Xsxy4dVLyC','BTC'),('17i1Mu5WaF7x8afNiGcHaDJSxk622gM1Gd','','KyREGFpkWjjvNzdLM8Th3asTXwtMQkfMfuvhaHvtkYQ5W6JskueE','BTC'),('17ZdtvidhAgZKnTAfoCXESe2u5Mf7bJL3E','','L2hXmrMBfQDAM1SF8a6a53FFBzArvs9s2nnRYyDfwSws3kSoh7VH','BTC'),('18CY3AfzY6dvRCAF9zvRxxzUbt2WJqms9T','','L1MDkr2U6j4H6UKhcC53Ff2JrPoXJq3mB6qAKgqRPu2GkShUPnnM','BTC'),('18ExEW6HH6j2vaFncV6Ro3GBi1tPhTWZZ4','','L3jXF7zodQUVUi1fiLxwSwihSvY6q8siAtBfa6wa3cxxqTsv83ce','BTC'),('18eXxGQpLA2kg6ga5PzMX97RBvQPW2rzqR','','KyxcKmvVU46eqPjvU62n811qfkaq6QW5KrCpUS8ZafrNtYvTkTFk','BTC'),('19DV3s5M764FrMmN5xNw4A4iAQ6Ng7Uaf2','\0','L3AHxdomdMJmF2o3ik4kmdCYdURodryfZQLocem2NBN6Xj1nstoN','BTC'),('19eYbiUdQhBrfmM1KEpVHyJA9Vm5vKrBxf','','L2jt1rUWyozYmhd1B49fhrQNCBjmrQYbuJcr6WSRSngAiyUzzH2u','BTC'),('1ACLENPaWgrwai9WgqV4R58kZMg2QLQ2ZT','\0','KwJm5Lqtm7LYV2ukAMmH9DApFV5Jx4MSG1csvjkZ7d1YxsiinmLz','BTC'),('1ACvN6H4LpwRRCtbtZqi9DWeVK7VPwstVw','','L1SHDjCqxMrTwULVoCE2vXCtMmj9k8NiWkoJe5ySgsUUXorLikNc','BTC'),('1ApzXAckPHERYW5LAHFtvCHS1bPdXiTd2Q','','KxrTDGPdSDtWpD1cGbPzKupPQcFYoeRRjkd6cShKp61KutyArgue','BTC'),('1ASExpW3WGQQnhvAkoVEJipFHWK2n2RJM3','\0','L3HASzKQALa2GNRQ7AbyWoUjh8uWDbpu6YquLKXpN9TVZmKh4LBH','BTC'),('1AtpxhgvT8dZd33mU1e2cnPhem2hQpj2P4','','L1SLE7Vf68Ju3jnsnkJnYXu82epYy91D8PgqBTAUEWRvsv4vtTdN','BTC'),('1AurRzso7xmKyjXhfF2x4BKgt3j3cw7rxP','','L2NkYv2qJLHQenUnAvtfNhJkoJTcLDpmxvEyftj11D2n82d3Bdhx','BTC'),('1AXXq3Q8DNRQDNMhM5NLpD7CW3gpd4r4tX','','L4QDR4Vk3nhEy52ggYDQPMbmwdxW5sTfieUxehqEW32VZSMugAQU','BTC'),('1Bs8NKPr712vQbSWtNRSRFLsBHAE1EeJSz','','KxuahR9ThW83s1dQTnCBDa7WDgSjYr64h4rHen5GfnrJYMGRxEEJ','BTC'),('1CDw8Z5pg5DW8vdScz6cpxdoXLkW6CZ4S4','\0','KzuKZqDB2LTuTowBE2VqJtdfKmgh5Yr4gUPThRQP1bdPbu6vtMWV','BTC'),('1DHRNX1d5vtLvmKebZ9Kee8ztGLkxn4BHb','\0','L4viMvB43zsyzA46HgJ4G1bB6CXatxtHQCSXcXi6R1hTNbHyD57u','BTC'),('1DswbMZyFoVfSZ7NoGhFvm6qJdWb32U5Bw','','L2HEaTcMwNdSfX5rjd4XqteCRo7EfZZULzwRPUTvzJ2KDRLixTEy','BTC'),('1DwAStrDeFCp8NZDriQc2yDRZaAauHszfE','','KzzksKzovso3ShpCcEb8r66Xd1ZGkXeRjPZCVLgL8ZraRAmh2XWK','BTC'),('1DY9JMb63jcWkdjDPFqzCHkcVDoMZK4ApK','','L3fkBcTYaeFzWZK9uQrHyQWJEFb7gY2kUB9EFVcTPqwe7Lh6yoMw','BTC'),('1Fajd1Ar77RMYsyaatYkXGWNNJUENjU36H','','L2gJC4V1g7fpa5XJv7xxDju6N8j4MavggfjwVQ2vfMgjaN1HjrJV','BTC'),('1FPXKk54XbL8fehyR2NBRsd6woXAuLzfzK','','KzTfoTD4swwDvCVjL6LK51muEWG5skXihT2nHhXwdgJ5JEDzw4Qv','BTC'),('1FRaEFSjw2GRQ6p1QcXM1VYuDMr9rCKj6b','','KypfrAKZGvUH26dAPTjKdaxgTar7TYeNMQYYydRqbXKhTi9jKtuY','BTC'),('1Ftts4oYyFLLCGVkHGNf6skzX4dq5tM3LD','','Kwpp1QEya4itJ3zCpf8XFZcR9BrcjAn5AGk44RBUbDJwqPwqgNhW','BTC'),('1FxEks5FjpUncQRoEX2xeS72Ff3KuVK8Vu','\0','L3o9MGk3MjrmcxDLe9bkjQqNbVatd9TFbfCWBeG1c3xBHnUvCMti','BTC'),('1G3eTGuGQTpAuVwrgDhEv4CpAy3EdY4PFc','','L4AuxX6DnjoUhUV5EJkbq3N8tABjVh5NhaV9RtbZXVeF8Mu7nH4j','BTC'),('1G7HcHLFD47irgLLhA7ga1JKaFWA99DRM8','','Kwjf5AEpJuGsuXLBfc5CDrTJ88VJ3g8PvU6jVWTSeyeppMDNf5Ac','BTC'),('1GkixkUxpYjWEHsWjvTwzHC9wVhq26J6UY','','L1szAUtCVi37DccfPQGqB1rXz7GnKgSYZmJ1UGQYzEixKwfdTb5o','BTC'),('1GSAuk25qmZxkyDQ8RWyywzg1vBmYJNDBT','\0','L3nURPiZhTRaFMwyv7UfSCjnt89FBTDy5Hw1gEAZHWg9Ew1zvne4','BTC'),('1H1qtm7uRbdx52GFFCq2KkFpvLdZ9tvrYg','','L1SAEpBnDbupTqWK2EKbpFuCtkFKmPfC3g8LPvASxberWMxX8EBq','BTC'),('1H93hCANrTkn5bJbJahVdigkvUP13o8XMM','','KzZhu4mPYWXTW1U8QX3EUgtejBx9aqDT9QCaJP3tGQtSHfxyj1Kw','BTC'),('1HNPyAn8ErmvFLceSYdYeBE7NjM6HuBak2','','L285LPQ6TbnUt2fN5aMCn8WauYCMeCwNsik5tA9WMVyqYEC26Bbi','BTC'),('1J5iSfHcEKc1vMxnxfUDxynjtsk282cVZC','','Kysh9MZUj6uezUnbEdYTkqum7QQWSmy5DZ6STmKsZgnMGv9pPuR2','BTC'),('1JUy7WrERWC9AFNS8USQqvdu3Fnn9pJEAV','','KxkzRKL2MCCzBxpzQx3JMh66kbeccx17y5ynzXo8N8fu7z9j69Xs','BTC'),('1KGGNJhn2mNT3orp9BhcgEwpRAm4J49MgF','\0','L2zoS4BcJcXXpKf3tH1QHEXHpXCKHqNFHfcts25CqBxMvbqF9U5D','BTC'),('1KwUE3N7J8cXsTzeqsy6bpn3WnjBTQbabS','','L5L295skbFbDEjyKt2xYngG9ntAfgzew6iNEP1Spzh63v6gLqd5Q','BTC'),('1L3KQVskXAMKy6KmEoRJviyv3j3t8M9ecj','','KzZB1uiRBebNdJKAgpCEv9AabMRsL8Gc19UvmXezynnhY8JhgXgv','BTC'),('1M35TdRFwJKmhb26groAeMdG1H4Vds5pq5','','KyctuN93p36L63rsByZBcjGi2VKQXwdbfpR9DVVzJWnqsiVm2Qwn','BTC'),('1M8HLUA2Nfq7ssXX9AJ8iYe5t9DJa4RQtU','','L3s6zUUFR12K9CXHiEeBFTxN4MdJymFjbhF1JiCQPE9JEmKd2pk9','BTC'),('1MtENWLjtM3dso6tnfhvXh4iiBKkGEzc3q','','L1stnUF82YBryC9Asq1qMigdtxhv63PbWqVrapN4dq8JpjM7zp8y','BTC'),('1Nr2NpNx797YZhCBnALQNTMjbqY3uWR1Wz','','L367mbSPwX6ULnXtJR38mmMCdxxwcK9Mkt8xNkNo9vJ93JqWwVB4','BTC'),('1NTCRADZzaE4f1UAzkddjdqeAaogCACNjQ','','L4qc6UiBtvzyDYNoEosx6ScT3utCAKyybfd4zsZucChwyFLr8L1E','BTC'),('1P3jDvmqaEzvou2S5zwEaCq79tm23zHgNn','','L2QQ8e85iH5AUUCHCFBXy7JD6yBS6ecY5hfnsGP6x8gFdWaZ1WvN','BTC'),('1P44kiynHAfEAvqHLRBCjU5nSpeRhrqcrT','','L2d1xdCqxf1bJSyFbEkSkP7EUCK477FM4dzHxRSj39vDzz3Jz843','BTC'),('1PL9THxXQCRdEPjXmcXqbKtW65sWj9BAxo','','L5EVC6Le4kYdn27JwBBUpWRmSNLpgXdbgrAiv268xayGQby5GKe8','BTC'),('1PZZX9RjipX6VKJWVmPBhWLgpFYCNfZLxa','','KwurwQMihnKbaFnKg8nQReYSMxFmZGcaeU4YfFM7jPhu6U73CDy5','BTC'),('1Q3dtRU95wXizsvyMVob5DAxmMT5cNcfwy','','L5HHceqeouQh8UK39D87PCfTUSTP81qzBxpWgZCVQJxFnxaK47oA','BTC'),('1QA76J6i9yLg3jSCvKRAcxZtVVBDUVjcfo','','L1Pkh5yqbKWTFnApRcUoDkk3R4fN4sarKXxeYQcwojcqLMLWHHrf','BTC'),('1R43fGKVaedNwqMg4X8WjmfXes2PuN6oE','','KxK9EvF6YuJN9HNaLUgyddmekEtFvhz64iKYVCUTVENZhQpXdMhc','BTC'),('1RXDEAYGc5paSP1WaKfTwGXnivDSahus4','','KyCJ7vxRx8hh7Nm1jyqhrUCbzHJrnnq5UmbZFeByJLWTz6ZvSysi','BTC'),('21ERh4gGiStxituxEbi4Fxi7KQfbS8JiWFw','','KyEBTqH1GPxnvNZsyC35UkNHrzXff9MH3szbhCxRqViscZHP9VGZ','BTC'),('317JKKeTJ4vjWWaR8zdpy6aM1rp6nQzHb8s','','L17k8wUcjbWgc6F1euUg139CmYKwd4FLvTM65n3uP9aZBcGajXk5','BTC'),('LaRgQZtnFMUWbnuCwRD2J7HTVZH7axpvTi','\0','6utVi6Jxgeh5gudpKRBFRkWRWiw3YjSYKzjG7yVeTZg7NLaSQvQ','LTC'),('Lb7bdv1Hi3SH9EsaRSasrTftMondmakkBR','\0','6uCe8fwNUj7JdQbanoGM6F2dQRgGYv3CLqyuzfpABVUC5CAefev','LTC'),('LbAF4AjK52QafJHprbAtkYuRWxVmscgZmx','\0','6uGYi2jVD9VjrPBhu2amTD62HscCc2P1n2vTP5rbu2zFEqiKQEn','LTC'),('LbkHWF6KSeUzmmbp8rg1ASshCgw8x2qYZd','','6unuGfwUbyinJHK3WFunFuPjzoPi2SMst6erMRpbEpemFCAsk7Q','LTC'),('LcXqKmj6UEqHy7jnh1fAsfeqFYa2Jt3WGt','','6upsT3dCkPxE1Uj3EB7u7fikvoQ9tJpCZngux9dtQuCPNoaVo8V','LTC'),('Ld2BnmjZpjWVHfaTVWTX6JVEXtRkTCaQAz','','6vncnZNzgWFNDduKnZ6ZgjRz151dFMUhMGiA9YJnYbPDZNaPhLw','LTC'),('Lddju8Qsi28seutQUtMkpQfn8xHXuJQuSm','','6uTHJSDtKipAF4C9SqccgRX4ojR4gXzCxrRjCtFCVPPgV3jpdS6','LTC'),('Ldfqf3V1G1FtdnmzoPKbPHjJ7zNjY5HJwh','','6uvgaGdGPMDhSzCVg6BMQK5azaqi5ovPwKsdvK3HmFzYY3DznQs','LTC'),('LdoQX89CSadSbNwpKHcMaM93EeuWTJpGEu','\0','6vcaQeqJJ5E6jkd3kRjANj98X14gsgKes4y5qg4XTVdm1nq1ZaB','LTC'),('Leg75RHa8S7cVEPAMvmB9K1Us2UnfqnS2D','\0','6vTdjwvxjStHFiDFAFmW2A7is9zd9iz2RfAgYiXtPxEciuaoDbF','LTC'),('LeHmTq9nUTQDuVq9E3K41QVgbfFs8nnxZq','','6vHUeRkX4dFxG5J4eRxq9ihuUFH44d25LR9vk9s8surKzK3X6Ux','LTC'),('LfTQp5zxYaRXCixoyAkodUgW8AyrbaDipJ','\0','6vGG94414FmoisxMGWkd4bCAEwkAgFALR7ygnjMCxrLPN7Yyot2','LTC'),('LfTVYPM94u9kAZzPve9RfAh3os2KrRqogt','','6urkBNxnqcfckifvgwyHDeRth4cJSpgqqtWRTbfmeZvLC6vZ7fY','LTC'),('Lgb3DBKPxuv6KMru2MiVKaqwJJRtVfNZFj','','6uKpskNnxKDrpTApHZCNBbjhZLWXqng1nuRgxJ34B9yGMqVcXxK','LTC'),('LghY9tCJBPPq8JB1UkiemL9AdtyawUXopL','','6vHW116jAZtkbwbLfkecHvHe1zdLYDn5Mtv2mYK8vCkng5wdUt8','LTC'),('LgLno9qbTTHkvdYvcs2S6XEPAcrVG4b6o1','','6uXTMdLQMT1vc41ct6eSZXjfKZVzxvy6V4KNTDbtFMRViqgoFr5','LTC'),('Lh2J8bjJPKNvTuj2qrucadYuowij2AJ9Ga','\0','6uTxJnV4tt5iPjdYVpeMncpXFUtgRyN58uJhQAanF4V5EFR2kLU','LTC'),('Lh4LhA1tLvuDqTxLq1N8Uqt4VcfgeA1TWm','','6ureTZd4QWX35NN28RbzGUNq6SwC728U7J6TCQwMdyuR7uz4MNy','LTC'),('Lhe3LEAsN3gZNQai1qEwLJjTy9TvjELLAU','','6uhf8B5pY9WrGdXG5iqPMiddv3ToAUT9NqzRqDH64cHbe8gU6DS','LTC'),('LhNgcQ2JiLYcR4reTsFqVYnuSBq7PQ3kmy','','6v4cXnUmyAtyRFWu5HGMHwgzRGo3YbYEuyCVbA72yUqUC1oSJeu','LTC'),('Lhxvbzirq6Qc38DCYxRTK6KRktYrtXntfB','','6uDKLx4bRV1A4MhygfCygoH3VojpDLxBh9YGucN8dDZrGVC9sU6','LTC'),('Li1qpyoXgq5mMUTH2i6Ro2w1PLAa3EXy1u','','6vWVEsmS1rhBrade66m7zitoPp21tD8Yxpv7XThZVnH2otYumZo','LTC'),('Li2nTfnceVwQrSAHVcMkmbWUbYXtoQ77DG','','6vGVy3A5LKijn4qvYgRPrdzFvzMYYN3UwsetYNVzQHRMtgqH8Mp','LTC'),('Li5rGGuTYXrpAhcNc9j8RtZjHjq9d6GNmy','','6v1q7y8PLQTNnYzyLoW3nPAEa7szZq4mUcvjct6ySExprzr5Ev5','LTC'),('LKbCMzdJ9GqBeM9RgEASUHC8ASV6R4UxvL','','6vettpT9RhRLcji7FSmG6RgkhmMnBhGzi798Pr4H1npQbxxoKiS','LTC'),('LKho6JyHVyHFBzMz1cGvUdmA2v42djmSNb','','6uRvi3YG1iZXBpatUdgmSkb4UTov9qMjyesr6htsBJLRrKDbvNo','LTC'),('LKnGQrfwHwXcZ7sQuDUUKUGgzSKTyjus3C','','6uFs8WtPbL73v1UruALg4Zv7mkrKpKcSjZsp2ixKYXpkJ3rLUGp','LTC'),('LKTJxMFiVDHJjaic9wvrMWqDgyuj7ycb4T','\0','6usofGLEeJ6sjQ4M9ayQUSw9h6AuGfkHk1NGY6gybkhT3L1WAU4','LTC'),('LKvaotaYB9k1sEarwQ1Ax6Kxmo7x64Bimq','','6uKGLnuMHinabLDsuWUBAxsbXr88zCKU3bwKErc4gMQWhTE7b3h','LTC'),('LLBPwGRjumUnx1jDXk7Jb95xEbp1nXoPYA','','6v8DfzSy9Um89mg917owhiyKvFaHQyRR6hEqHxuJcMQnF9jv5dg','LTC'),('LLD33rjdN9MLrV4ZgZptgg4TosncAHyKKe','','6upyeTUgY9SiFveYU18N9fPUS9HZjJpmr8YW4cp25UC8ALE6rWS','LTC'),('LLDfppMWR9tDpNkowbFSdfLSTdRt5jZyah','','6vspFA2w7BZpGVdm6kYdbrWjjfqDK7haJ6veParddNZEZsMoaCs','LTC'),('LLkh9JHaUDi9aAmaujjDANpCEcPmhRX3GK','','6vDGx46ojnrRBEL995qnNnSdW4wPR36F33SAN2nWuTzf4oiHCpp','LTC'),('LM6iHAuFJ3v9Th6EpLeF6KCHcVYLFWeDN2','','6v1Lh8gsAapn9f1MwLZqvTi659pjohkhY36ceF8MmLt6vaAYMHJ','LTC'),('LM9ZuSy4NJ2abmLxKjKkMBoEcLgA8v6VTg','','6uJ6C4YkhFpVhgDcq8PTfzsRpQkGS5EJVGNRVDRiYEkiN3DpPLc','LTC'),('LMjfph2PtPqE11FWhXKdBsSkdKK3jNTfxx','\0','6uBGau5cM4m6GWabHtyHJMqESfQyJKo6FqccAuShjRCFcA5kjcR','LTC'),('LMSmPVRm6eeffwVBjmxUqUZiGPoBzcjm8t','','6vsxBhstXuCLjNoq7nRds1KA4pbHS8GVuybdLRjQo3K8GLm7NSm','LTC'),('LMW54AxkqgydEieZscFLi35tTYBDeMiE8P','','6vBZSGmNTz6C57CN4jYQ5maRVb9HxNwHkqnPsGouxnHUxgx2bsL','LTC'),('LNT2TtiEESMLMW71uxs76G6FXSwmYzmQRo','','6unM9rBYDLqtj1ZbNpEsgdQfzSN5focLY6tq32tL8zZfwVeTdgC','LTC'),('LPcrv4NNKJf2gFg6ueKRUormWNmrc5nr7Q','','6uQ6BmBdMBsFZUDijSBCzYTRBdXbQwbsfDbivmGeZNoEM6ohCnV','LTC'),('LPLj5xqV3ZzC38Eh8C87xPwKG9NeLVomvB','\0','6uaBfwgoTsjcMRHQudrSap9CQ23mz2njLH7oUoE7PXeGnd4rXEH','LTC'),('LQkmdvS2TWHygdRgbLV3UBfkRXyJmCh2jY','\0','6v2ymtqNcQjzgcz9YnMmfGUFnXGbtDRSrEu8GwxtVwdxArfFZ9J','LTC'),('LR3pU97dutAPyu9SXqVoA77nzZKCcCR2DV','\0','6vDQwzRD4FEP2KQEk3oeNmL7hpau6UshBzD9XwA2L9HHiXna5Zd','LTC'),('LRfhr4KXFtZDQCSTUjt62gRESjx8NoW5Aw','','6vi6k2CmzCw69RpMJkpLz1r33EZHHNW7jfa9Lz2U16mdXW9jRFt','LTC'),('LRjJb1fCvZPfiPyhVcpynTd7Whi64EMMkt','','6uUPfWBygzPLPbYKHe5dEBqGCAW9ct82QTP7sYXoS5zVBiYi83K','LTC'),('LRPX7in4qdcBxKvXuc4Lwoy1YUhkmWCTDY','','6vA51BveNqfSt929GmBDiv2MHQLUb2czB7ytvuB7QGeAr69YYDz','LTC'),('LRr29airwcPK7PYVqkVkkm6Z2dBUaxXLQv','','6vZVv7aP1WYt8dsEis25KTkHV9DbFX4YgXXzqkTUQaZuENjdnqj','LTC'),('LS6sKmBRpjTh4EcVzHQXaExAvsYzJP6g5y','','6ucXK1AbvPTErbUNoxx2vi3mKNaVnVW43cP4DEnBBHFAsPc7sx8','LTC'),('LSwSLbHfDFiNNMa7uoqHXpRwQEE4TXaejb','','6vvJYdaqnfYF2f2LYj1vqbsjkLaY3uH45fFz7FpMCqEKaXuiyud','LTC'),('LTBwPdB8mmdCrPx4W4SQpZ5TNMn6uBdSP1','\0','6uM2QQVpyFBdca93xDyHBrHmDwpMwBex2MPeQZVVDg9oRbF1E8F','LTC'),('LUwxPpxxovuSHNrWhKVJLFt7CBmG69Qk7H','','6v8GL6Ha9tieBAjCe26fVxakZripzWEf9PvnWwpGKUzvLdDqjY8','LTC'),('LV33B1avdYpFjHQWJUN4PuhCeFB4AXaMKm','','6uXr8zJEfh7kP4nxgtHptuHszRgBipEbFMqAvE6CNSHqEC6jbxR','LTC'),('LVbQRGnXPFJfD2WCHGKA45kD2LybJNKmM8','','6vkDsZowCeuoTYcgVNWR6ccWPzgDSqci9xAjRhWs7ab64HwQ4FU','LTC'),('LVh4XQUFWume8wesLP42dd7cpxXeewNLLd','','6uMDg8SW2ngA81cCgkmzavF9zP1KwhDcbZUtkoXyghJaPNmN8mh','LTC'),('LW2uhscUdPZoATZsrf2QjUsKihHgXALHJp','','6v8LpRyRe2uWhW8FAG5McGY7oMguaorm5LBH6mPvFbLXaoxdb2z','LTC'),('LWJigia3Td2qUvyUKPfN2EzZHND8duEDvQ','','6uQvb2e1xcEXr6MiyNLWAAGaojoDJV7Qtq8MENRqFDWCBMAu3g7','LTC'),('LWyut8CMj6Bh3K6qtyqsf9fKkkvdzfyTip','','6uujQckzQwaL1Tu9XeEvTMRHGe5RLu16WL8Y43TUorKHompucRZ','LTC'),('LX36rhYmW2WSgwyhXJ2wCxekXicfA2TNJu','','6vsKDUf83bQs5NfJfhh9YqtpgpfmUnA1CeYJMBXYFDrkLz5cbZG','LTC'),('LXdT2CyH1Dco4NhkPjcHQrKYfbvP427sfS','','6u8MaBks6Uuza71DmP6MzfZSvRGbftnVEf8jUh9fyTE7wQdbvu4','LTC'),('LXJaTvqoTH7UTyWJQK9U4BdaspbZZLLNrg','','6vCLEV3GTo2p8C7dJ9nJNczhrY4VZvqsKE4RpCtt1bEsyv9VXad','LTC'),('LXMbfeZ3rb5iYV5gjuFR52RvY1P6MgPRoD','','6uoEKiv2y9evWXBpb9bfVxbpouDPMFEGSi9HUh6dTU9ErZt8d4t','LTC'),('LXNMonBr1a3w752gCy2jie3ZHsRoAje8LM','','6uVRuFriHPH91491RL7VcRNNchawnRajNWwF9YsP5zSarSUG9bv','LTC'),('LXPe9P5m5zxuSTwUoMC872EDY5RDp7tSsV','','6um5Pd9UoxmUeimW2PuWzWrGHmKPEgaU4UaUEXhpjTJs1KQbgSC','LTC'),('LXWXZ9MytUWMSMtNQTWfksP7NGR94rq4Yv','','6uY4EiuHzXuJm8StuvUPmb8iLZkNtBidjvesfsPYPY8fpmcUZGy','LTC'),('LYBUSXzLfgbHuuiE1FCeqgdfwWXaMy1vio','','6vHP8yXFo2w26Ra9U5XwkiiBeoJbohZZbAzmDzPcx2CBh9SgrN4','LTC'),('LZNbCzs9BTtvh4PSxN8QPeR71SZMpwKA4a','','6vweZUJL3oRW1BGQG97WUNDrdTUYY6WnYAnKbPdAfjFX29su38C','LTC'),('LZZcsG6ZCvDc3PnFi3sZpP6iVaFm8KKBHT','','6uxYgxgUjNKrYc5BKLH1J4MoLWhYajQcVsQKMiPFKxb1vBEWo7J','LTC');
- /*!40000 ALTER TABLE `address_pool` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `bankdetail`
- --
- DROP TABLE IF EXISTS `bankdetail`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `bankdetail` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `account_no` varchar(255) DEFAULT NULL,
- `bank_holder_name` varchar(255) DEFAULT NULL,
- `bank_name` varchar(255) DEFAULT NULL,
- `id_proof` varchar(255) DEFAULT NULL,
- `ifsc_code` varchar(255) DEFAULT NULL,
- `user_id` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `bankdetail`
- --
- LOCK TABLES `bankdetail` WRITE;
- /*!40000 ALTER TABLE `bankdetail` DISABLE KEYS */;
- /*!40000 ALTER TABLE `bankdetail` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `coin_depositnwithdrawal_request`
- --
- DROP TABLE IF EXISTS `coin_depositnwithdrawal_request`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `coin_depositnwithdrawal_request` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `amount` double DEFAULT NULL,
- `direction` varchar(255) DEFAULT NULL,
- `is_approved` bit(1) DEFAULT NULL,
- `private_key` varchar(255) DEFAULT NULL,
- `public_key` varchar(255) DEFAULT NULL,
- `symbol` varchar(255) DEFAULT NULL,
- `withdrawal_key` varchar(255) DEFAULT NULL,
- `user_id` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `FK_mxa1kpbkkb6nnoixiekfex6t6` (`user_id`),
- CONSTRAINT `FK_mxa1kpbkkb6nnoixiekfex6t6` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `coin_depositnwithdrawal_request`
- --
- LOCK TABLES `coin_depositnwithdrawal_request` WRITE;
- /*!40000 ALTER TABLE `coin_depositnwithdrawal_request` DISABLE KEYS */;
- INSERT INTO `coin_depositnwithdrawal_request` VALUES (2,100,'deposit','','KzuKZqDB2LTuTowBE2VqJtdfKmgh5Yr4gUPThRQP1bdPbu6vtMWV','1CDw8Z5pg5DW8vdScz6cpxdoXLkW6CZ4S4 ','BTC',NULL,7),(3,125.01,'deposit','','L2zoS4BcJcXXpKf3tH1QHEXHpXCKHqNFHfcts25CqBxMvbqF9U5D','1KGGNJhn2mNT3orp9BhcgEwpRAm4J49MgF ','BTC',NULL,12),(4,151.23,'withdrawal','\0',NULL,'0x6F46CF5569AEfA1acC1009290c8E043747172d89','ETH','withdrawalKey',12),(5,5000,'withdrawal','\0',NULL,'LRLbPyr8peAPRXoA3BCJuNubmQVXXmsqQA ','LTC','withdrawalKey',12),(6,5000,'withdrawal','\0',NULL,'LRLbPyr8peAPRXoA3BCJuNubmQVXXmsqQA ','LTC','withdrawalKey',12),(7,5000,'withdrawal','',NULL,'LRLbPyr8peAPRXoA3BCJuNubmQVXXmsqQA ','LTC','withdrawalKey',12),(8,500,'withdrawal','\0',NULL,'LRLbPyr8peAPRXoA3BCJuNubmQVXXmsqQA ','LTC','withdrawalKey',12),(9,2000,'withdrawal','\0',NULL,'LRLbPyr8peAPRXoA3BCJuNubmQVXXmsqQA ','LTC','withdrawalKey',12),(10,200,'withdrawal','',NULL,'LRLbPyr8peAPRXoA3BCJuNubmQVXXmsqQA ','LTC','withdrawalKey',12),(11,100.2,'deposit','','KxYsuKsRGqbUbgBw73yQXxxK5cyJkN9gLUF5PtxMg89jS6sWfiZ5','16XGaeb2Jv5rCsBk2pAXNSYZcARWiNuEAo ','BTC',NULL,17),(12,122,'deposit','','KxYsuKsRGqbUbgBw73yQXxxK5cyJkN9gLUF5PtxMg89jS6sWfiZ5','16XGaeb2Jv5rCsBk2pAXNSYZcARWiNuEAo ','BTC',NULL,17),(13,10,'deposit','','6uTxJnV4tt5iPjdYVpeMncpXFUtgRyN58uJhQAanF4V5EFR2kLU','Lh2J8bjJPKNvTuj2qrucadYuowij2AJ9Ga ','LTC',NULL,17),(14,10,'deposit','','KxYsuKsRGqbUbgBw73yQXxxK5cyJkN9gLUF5PtxMg89jS6sWfiZ5','16XGaeb2Jv5rCsBk2pAXNSYZcARWiNuEAo ','BTC',NULL,17),(15,1234,'deposit','','KxYsuKsRGqbUbgBw73yQXxxK5cyJkN9gLUF5PtxMg89jS6sWfiZ5','16XGaeb2Jv5rCsBk2pAXNSYZcARWiNuEAo ','BTC',NULL,17),(16,3214,'deposit','','6uTxJnV4tt5iPjdYVpeMncpXFUtgRyN58uJhQAanF4V5EFR2kLU','Lh2J8bjJPKNvTuj2qrucadYuowij2AJ9Ga ','LTC',NULL,17),(17,3214,'deposit','','6uTxJnV4tt5iPjdYVpeMncpXFUtgRyN58uJhQAanF4V5EFR2kLU','Lh2J8bjJPKNvTuj2qrucadYuowij2AJ9Ga ','LTC',NULL,17),(18,100,'deposit','\0','KxYsuKsRGqbUbgBw73yQXxxK5cyJkN9gLUF5PtxMg89jS6sWfiZ5','16XGaeb2Jv5rCsBk2pAXNSYZcARWiNuEAo ','BTC',NULL,17),(19,200,'deposit','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH',NULL,17),(20,300,'deposit','','6uTxJnV4tt5iPjdYVpeMncpXFUtgRyN58uJhQAanF4V5EFR2kLU','Lh2J8bjJPKNvTuj2qrucadYuowij2AJ9Ga ','LTC',NULL,17),(21,0.00896626,'withdrawal','','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',17),(22,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x4AFC18911d804d946e4DDdbe2dc95a0CD35a2FFb',17),(23,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x4AFC18911d804d946e4DDdbe2dc95a0CD35a2FFb',17),(24,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x4AFC18911d804d946e4DDdbe2dc95a0CD35a2FFb',17),(25,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x4AFC18911d804d946e4DDdbe2dc95a0CD35a2FFb',17),(26,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(27,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(28,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(29,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(30,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(31,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(32,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(33,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(34,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(35,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(36,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(37,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(38,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(39,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(40,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','0x9E13aA22CF2B7CD2C7feb5a8553346319F91f61F',NULL),(41,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','fdddf',17),(42,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','fdddf',17),(43,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','fdddf',17),(44,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','fdddf',17),(45,0.00896626,'withdrawal','\0','7dc8f4f2c35daf53cef8b4011c4b8417f994a9c940215582f35d691b6422f8c1','0x0D22d8E72C9474D0378442535de3df83e8D8CC34','ETH','fdddf',17);
- /*!40000 ALTER TABLE `coin_depositnwithdrawal_request` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `country`
- --
- DROP TABLE IF EXISTS `country`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `country` (
- `country_id` int(11) NOT NULL AUTO_INCREMENT,
- `country_name` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`country_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `country`
- --
- LOCK TABLES `country` WRITE;
- /*!40000 ALTER TABLE `country` DISABLE KEYS */;
- /*!40000 ALTER TABLE `country` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `currency`
- --
- DROP TABLE IF EXISTS `currency`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `currency` (
- `currency_id` bigint(20) NOT NULL AUTO_INCREMENT,
- `currency` varchar(255) DEFAULT NULL,
- `is_digital` bit(1) DEFAULT NULL,
- PRIMARY KEY (`currency_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `currency`
- --
- LOCK TABLES `currency` WRITE;
- /*!40000 ALTER TABLE `currency` DISABLE KEYS */;
- /*!40000 ALTER TABLE `currency` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `currency_public_key`
- --
- DROP TABLE IF EXISTS `currency_public_key`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `currency_public_key` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `availability` bit(1) DEFAULT NULL,
- `public_key` varchar(255) DEFAULT NULL,
- `symbol` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `currency_public_key`
- --
- LOCK TABLES `currency_public_key` WRITE;
- /*!40000 ALTER TABLE `currency_public_key` DISABLE KEYS */;
- /*!40000 ALTER TABLE `currency_public_key` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `depositnwithdrawl`
- --
- DROP TABLE IF EXISTS `depositnwithdrawl`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `depositnwithdrawl` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `admin` varchar(255) DEFAULT NULL,
- `amount` double DEFAULT NULL,
- `currency` varchar(255) DEFAULT NULL,
- `datetime` varchar(255) DEFAULT NULL,
- `is_approved` bit(1) DEFAULT NULL,
- `is_digital` bit(1) DEFAULT NULL,
- `public_key` varchar(255) DEFAULT NULL,
- `status` varchar(255) DEFAULT NULL,
- `type` varchar(255) DEFAULT NULL,
- `unique_id` varchar(255) DEFAULT NULL,
- `user_id` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `depositnwithdrawl`
- --
- LOCK TABLES `depositnwithdrawl` WRITE;
- /*!40000 ALTER TABLE `depositnwithdrawl` DISABLE KEYS */;
- /*!40000 ALTER TABLE `depositnwithdrawl` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `forgot_password`
- --
- DROP TABLE IF EXISTS `forgot_password`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `forgot_password` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `active` bit(1) DEFAULT NULL,
- `date_time` varchar(255) DEFAULT NULL,
- `user_id` varchar(255) DEFAULT NULL,
- `uuid` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `forgot_password`
- --
- LOCK TABLES `forgot_password` WRITE;
- /*!40000 ALTER TABLE `forgot_password` DISABLE KEYS */;
- /*!40000 ALTER TABLE `forgot_password` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `key_pair`
- --
- DROP TABLE IF EXISTS `key_pair`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `key_pair` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `private_key` varchar(255) DEFAULT NULL,
- `public_key` varchar(255) DEFAULT NULL,
- `symbol` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `key_pair`
- --
- LOCK TABLES `key_pair` WRITE;
- /*!40000 ALTER TABLE `key_pair` DISABLE KEYS */;
- /*!40000 ALTER TABLE `key_pair` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `login`
- --
- DROP TABLE IF EXISTS `login`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `login` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `last_login_time` varchar(255) DEFAULT NULL,
- `login_ip` varchar(255) DEFAULT NULL,
- `user_id` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `login`
- --
- LOCK TABLES `login` WRITE;
- /*!40000 ALTER TABLE `login` DISABLE KEYS */;
- /*!40000 ALTER TABLE `login` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `messages`
- --
- DROP TABLE IF EXISTS `messages`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `messages` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `message` varchar(255) DEFAULT NULL,
- `name` varchar(255) DEFAULT NULL,
- `start_time` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `messages`
- --
- LOCK TABLES `messages` WRITE;
- /*!40000 ALTER TABLE `messages` DISABLE KEYS */;
- /*!40000 ALTER TABLE `messages` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `pair`
- --
- DROP TABLE IF EXISTS `pair`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `pair` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `ask_price` double DEFAULT NULL,
- `base_currency` varchar(255) DEFAULT NULL,
- `base_max_size` double DEFAULT NULL,
- `base_min_size` double DEFAULT NULL,
- `bid_price` double DEFAULT NULL,
- `price_change` double DEFAULT NULL,
- `display_name` varchar(255) DEFAULT NULL,
- `fee_account` varchar(255) DEFAULT NULL,
- `gdax_pair` varchar(255) DEFAULT NULL,
- `margin_enabled` bit(1) DEFAULT NULL,
- `max_threshold` int(11) DEFAULT NULL,
- `max_tolerance` int(11) DEFAULT NULL,
- `min_limits` double DEFAULT NULL,
- `min_threshold` int(11) DEFAULT NULL,
- `min_tolerance` int(11) DEFAULT NULL,
- `min_with_drawal` double DEFAULT NULL,
- `name` varchar(255) DEFAULT NULL,
- `net_work_fees` double DEFAULT NULL,
- `polonix_pair` varchar(255) DEFAULT NULL,
- `price` double DEFAULT NULL,
- `quantity` double DEFAULT NULL,
- `quote_currency` varchar(255) DEFAULT NULL,
- `quote_increment` double DEFAULT NULL,
- `wanted_confermation` bit(1) DEFAULT NULL,
- `with_drawal_limits` double DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `pair`
- --
- LOCK TABLES `pair` WRITE;
- /*!40000 ALTER TABLE `pair` DISABLE KEYS */;
- /*!40000 ALTER TABLE `pair` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `role`
- --
- DROP TABLE IF EXISTS `role`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `role` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `role`
- --
- LOCK TABLES `role` WRITE;
- /*!40000 ALTER TABLE `role` DISABLE KEYS */;
- INSERT INTO `role` VALUES (1,'admin'),(2,'admin'),(3,'admin'),(4,'admin'),(5,'admin'),(6,'admin'),(7,'admin'),(8,'admin'),(9,'admin'),(10,'admin'),(11,'admin'),(12,'admin'),(13,'admin'),(14,'admin'),(15,'admin'),(16,'admin'),(17,'user'),(18,'admin'),(19,'admin');
- /*!40000 ALTER TABLE `role` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `role_users`
- --
- DROP TABLE IF EXISTS `role_users`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `role_users` (
- `role_id` bigint(20) NOT NULL,
- `users_id` bigint(20) NOT NULL,
- UNIQUE KEY `UK_ljs8l2207x0igrfp8dw2edxql` (`users_id`),
- KEY `FK_sw7bxjnck8kj55yij22ar1705` (`role_id`),
- CONSTRAINT `FK_ljs8l2207x0igrfp8dw2edxql` FOREIGN KEY (`users_id`) REFERENCES `user` (`id`),
- CONSTRAINT `FK_sw7bxjnck8kj55yij22ar1705` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `role_users`
- --
- LOCK TABLES `role_users` WRITE;
- /*!40000 ALTER TABLE `role_users` DISABLE KEYS */;
- /*!40000 ALTER TABLE `role_users` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `transaction`
- --
- DROP TABLE IF EXISTS `transaction`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `transaction` (
- `public_key` varchar(255) NOT NULL,
- `date_time` tinyblob,
- `symbol` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`public_key`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `transaction`
- --
- LOCK TABLES `transaction` WRITE;
- /*!40000 ALTER TABLE `transaction` DISABLE KEYS */;
- /*!40000 ALTER TABLE `transaction` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `user`
- --
- DROP TABLE IF EXISTS `user`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `user` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `active` bit(1) DEFAULT NULL,
- `address1` varchar(255) DEFAULT NULL,
- `address2` varchar(255) DEFAULT NULL,
- `city` varchar(255) DEFAULT NULL,
- `country` varchar(255) DEFAULT NULL,
- `created_date` varchar(255) DEFAULT NULL,
- `firstname` varchar(255) DEFAULT NULL,
- `land_mark` varchar(255) DEFAULT NULL,
- `last_login` varchar(255) DEFAULT NULL,
- `last_name` varchar(255) DEFAULT NULL,
- `middle_name` varchar(255) DEFAULT NULL,
- `mobile_no` varchar(255) DEFAULT NULL,
- `password` varchar(255) DEFAULT NULL,
- `photo_id` varchar(255) DEFAULT NULL,
- `postal_code` varchar(255) DEFAULT NULL,
- `proof_id` varchar(255) DEFAULT NULL,
- `secret` varchar(255) DEFAULT NULL,
- `state` varchar(255) DEFAULT NULL,
- `telephone` varchar(255) DEFAULT NULL,
- `username` varchar(255) DEFAULT NULL,
- `uses_authenticator` bit(1) DEFAULT NULL,
- `varified_by` varchar(255) DEFAULT NULL,
- `varify` bit(1) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `user`
- --
- LOCK TABLES `user` WRITE;
- /*!40000 ALTER TABLE `user` DISABLE KEYS */;
- INSERT INTO `user` VALUES (1,'',NULL,NULL,NULL,NULL,'2018-08-31T08:38:44.352Z',NULL,NULL,NULL,NULL,NULL,NULL,'$2a$10$VAK8qv6hTL4fBa/nbHQsrOqJnEKAvGy0JnXK.d73C17IVXKwEbPrO',NULL,NULL,NULL,NULL,NULL,NULL,'dhaval@gmail.com','\0',NULL,NULL),(2,'',NULL,NULL,NULL,NULL,'2018-08-31T09:01:43.632Z',NULL,NULL,NULL,NULL,NULL,NULL,'$2a$10$VaS7aZ8Aa9ndATV6aKacIOByRTYmbq5IMVOmMDGBpvjauLWeyXwM2',NULL,NULL,NULL,NULL,NULL,NULL,'bhavishyagoya.l@gmail.com','\0',NULL,NULL),(3,'',NULL,NULL,NULL,NULL,'2018-08-31T09:04:57.559Z',NULL,NULL,NULL,NULL,NULL,NULL,'$2a$10$0DP.Kdune39NSLewuhA1Hu8SLlDnHbnUIdhBYidpMsotJyWhpvjGy',NULL,NULL,NULL,NULL,NULL,NULL,'dhavalmanjaria@gmail.com','\0',NULL,NULL),(7,'',NULL,NULL,NULL,NULL,'2018-08-31T09:39:35.107Z',NULL,NULL,NULL,NULL,NULL,NULL,'$2a$10$aFprw8c9I5x0IKnWrksxnOpHuNOxtHBMPcItcsL2YOmorlrVqGOq2',NULL,NULL,NULL,'QQIAYJP4BPWTT74I',NULL,NULL,'b.h.avishyagoyal@gmail.com','',NULL,NULL),(12,'',NULL,NULL,NULL,NULL,'2018-08-31T11:06:15.053Z',NULL,NULL,NULL,NULL,NULL,NULL,'$2a$10$VRHDoW0bSj1DXyEM.mS0RuibEpArjn6rQ.CenoUmEXHTYqQhuY/BC',NULL,NULL,NULL,'VZ2H6XSTJCS5OP35',NULL,NULL,'dhv2712@gmail.com','',NULL,NULL),(16,'',NULL,NULL,NULL,NULL,'2018-09-01T07:44:49.576Z',NULL,NULL,NULL,NULL,NULL,NULL,'$2a$10$hQ3t.4QjwBcKk0m/mFInY.6pWQNR1YaRO6rnhNndAFNBomnYSfzT2',NULL,NULL,NULL,NULL,NULL,NULL,'dhv.2712@gmail.com','\0',NULL,NULL),(17,'',NULL,NULL,NULL,NULL,'2018-09-01T09:47:39.318Z',NULL,NULL,NULL,NULL,NULL,NULL,'$2a$10$UUO7p/RJ/siOz6t.2.ZzlOQbvhua2yOvBkG.JcBcoXVskhKkLfC8a',NULL,NULL,NULL,'SZJISYIRHZKMDWYB',NULL,NULL,'paddyrank@gmx.com','\0',NULL,NULL),(18,'',NULL,NULL,NULL,NULL,'2018-09-03T09:23:45.029Z',NULL,NULL,NULL,NULL,NULL,NULL,'$2a$10$qRXns/4iWTn4dCdFCGWfFOMitxN7URfsUc3L.s/6gwHVDRK18QrtO',NULL,NULL,NULL,NULL,NULL,NULL,'d.hv2712@gmail.com','\0',NULL,NULL),(19,'',NULL,NULL,NULL,NULL,'2018-09-03T22:38:25.550Z',NULL,NULL,NULL,NULL,NULL,NULL,'$2a$10$k4vBRLXisUXFBjFvxRvhPuvFb7nKemfoGFguA5ZhozD1nd0IjGJ1.',NULL,NULL,NULL,NULL,NULL,NULL,'paddyrank1@gmx.com','\0',NULL,NULL);
- /*!40000 ALTER TABLE `user` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `user_address`
- --
- DROP TABLE IF EXISTS `user_address`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `user_address` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `address` varchar(255) DEFAULT NULL,
- `balance` double DEFAULT NULL,
- `symbol` varchar(255) DEFAULT NULL,
- `user_id` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `FK_kfu0161nvirkey6fwd6orucv7` (`user_id`),
- CONSTRAINT `FK_kfu0161nvirkey6fwd6orucv7` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `user_address`
- --
- LOCK TABLES `user_address` WRITE;
- /*!40000 ALTER TABLE `user_address` DISABLE KEYS */;
- INSERT INTO `user_address` VALUES (1,'16LZ5m6xDqPg2WXxRkz5HykbFBgeRXbQYn',0,'BTC',2),(2,'Lb7bdv1Hi3SH9EsaRSasrTftMondmakkBR',0,'LTC',2),(3,'0x0C6BDD1F7CCCc77f189696092714FE5D0Cc0d854',0,'ETH',2),(4,'19DV3s5M764FrMmN5xNw4A4iAQ6Ng7Uaf2',0,'BTC',3),(5,'LbAF4AjK52QafJHprbAtkYuRWxVmscgZmx',0,'LTC',3),(6,'0x26068d32C477A74B13b17e2D2873376da9F24310',0,'ETH',3),(13,'1CDw8Z5pg5DW8vdScz6cpxdoXLkW6CZ4S4',0,'BTC',7),(14,'LMjfph2PtPqE11FWhXKdBsSkdKK3jNTfxx',0,'LTC',7),(15,'0x8b2d982692446Dc025b7d1551d706d78DF98c17a',0,'ETH',7),(25,'3R1hBCHURkquAjFUv1eH5u2gXqooJkjg4B',49899.37587348,'BTC',12),(26,'LRLbPyr8peAPRXoA3BCJuNubmQVXXmsqQA',6076.65415016,'LTC',12),(27,'0x6F46CF5569AEfA1acC1009290c8E043747172d89',1510065.6421301414,'ETH',12),(28,'16XGaeb2Jv5rCsBk2pAXNSYZcARWiNuEAo',0.00045209,'BTC',17),(29,'Lh2J8bjJPKNvTuj2qrucadYuowij2AJ9Ga',0.00000097,'LTC',17),(30,'0x0D22d8E72C9474D0378442535de3df83e8D8CC34',0.00896626,'ETH',17),(31,'16jyGJBVHvKJDucpcwYL7iK1Nr7Ldw6v6y',0,'BTC',16),(32,'LdoQX89CSadSbNwpKHcMaM93EeuWTJpGEu',0,'LTC',16),(33,'0x7FD29C9ED511b3DebfD1F1F7f94fAd6662d85888',0,'ETH',16),(34,'1153oVoCx2QDxV3HvJwfvyxdDzCw9xyzyzN',0,'BTC',18),(35,'Leg75RHa8S7cVEPAMvmB9K1Us2UnfqnS2D',0,'LTC',18),(36,'0x45D6C1430c75d1Ef14EDbC4FB874e1a6e31f9Af8',0,'ETH',18),(37,'12j4rHKvNb5fM14jE7KiDAdaFso1z6BSC5',0,'BTC',19),(38,'LaRgQZtnFMUWbnuCwRD2J7HTVZH7axpvTi',0,'LTC',19),(39,'0x0484E365DCDE3481D15beb9E4d416Ca9F5f20b0f',0,'ETH',19);
- /*!40000 ALTER TABLE `user_address` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `user_public_key`
- --
- DROP TABLE IF EXISTS `user_public_key`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `user_public_key` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `public_key` varchar(255) DEFAULT NULL,
- `symbol` varchar(255) DEFAULT NULL,
- `user_id` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `user_public_key`
- --
- LOCK TABLES `user_public_key` WRITE;
- /*!40000 ALTER TABLE `user_public_key` DISABLE KEYS */;
- /*!40000 ALTER TABLE `user_public_key` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `user_role`
- --
- DROP TABLE IF EXISTS `user_role`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `user_role` (
- `user_id` bigint(20) NOT NULL,
- `role_id` bigint(20) NOT NULL,
- UNIQUE KEY `UK_it77eq964jhfqtu54081ebtio` (`role_id`),
- KEY `FK_apcc8lxk2xnug8377fatvbn04` (`user_id`),
- CONSTRAINT `FK_apcc8lxk2xnug8377fatvbn04` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
- CONSTRAINT `FK_it77eq964jhfqtu54081ebtio` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `user_role`
- --
- LOCK TABLES `user_role` WRITE;
- /*!40000 ALTER TABLE `user_role` DISABLE KEYS */;
- INSERT INTO `user_role` VALUES (1,1),(2,2),(3,3),(7,7),(12,12),(16,16),(17,17),(18,18),(19,19);
- /*!40000 ALTER TABLE `user_role` 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 2018-09-05 12:35:44
Add Comment
Please, Sign In to add comment