-- MySQL dump 10.13  Distrib 5.7.32, for Linux (x86_64)
--
-- Host: localhost    Database: trezor
-- ------------------------------------------------------
-- Server version	5.7.32-0ubuntu0.18.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 `blog_post`
--

DROP TABLE IF EXISTS `blog_post`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blog_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author` varchar(50) DEFAULT NULL,
  `tags` varchar(500) DEFAULT NULL,
  `img_small` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `blog_post`
--

LOCK TABLES `blog_post` WRITE;
/*!40000 ALTER TABLE `blog_post` DISABLE KEYS */;
/*!40000 ALTER TABLE `blog_post` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `blog_post_local`
--

DROP TABLE IF EXISTS `blog_post_local`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blog_post_local` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `language` varchar(5) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `description` text,
  `text` text,
  PRIMARY KEY (`id`),
  KEY `FK__blog` (`post_id`),
  CONSTRAINT `FK__blog` FOREIGN KEY (`post_id`) REFERENCES `blog_post` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `blog_post_local`
--

LOCK TABLES `blog_post_local` WRITE;
/*!40000 ALTER TABLE `blog_post_local` DISABLE KEYS */;
/*!40000 ALTER TABLE `blog_post_local` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `countries`
--

DROP TABLE IF EXISTS `countries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=251 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `countries`
--

LOCK TABLES `countries` WRITE;
/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
INSERT INTO `countries` VALUES (1,'Afghanistan'),(2,'Åland Islands'),(4,'Algeria'),(5,'American Samoa'),(6,'Andorra'),(7,'Angola'),(8,'Anguilla'),(9,'Antarctica'),(10,'Antigua and Barbuda'),(11,'Argentina'),(12,'Armenia'),(13,'Aruba'),(14,'Australia'),(15,'Austria'),(16,'Azerbaijan'),(17,'Bahamas'),(18,'Bahrain'),(19,'Bangladesh'),(20,'Barbados'),(21,'Belarus'),(22,'Belgium'),(23,'Belize'),(24,'Benin'),(25,'Bermuda'),(26,'Bhutan'),(27,'Bolivia, Plurinational State of'),(28,'Bonaire, Sint Eustatius and Saba'),(29,'Bosnia and Herzegovina'),(30,'Botswana'),(31,'Bouvet Island'),(32,'Brazil'),(33,'British Indian Ocean Territory'),(34,'Brunei Darussalam'),(35,'Bulgaria'),(36,'Burkina Faso'),(37,'Burundi'),(38,'Cambodia'),(39,'Cameroon'),(40,'Canada'),(41,'Cape Verde'),(42,'Cayman Islands'),(43,'Central African Republic'),(44,'Chad'),(45,'Chile'),(46,'China'),(47,'Christmas Island'),(48,'Cocos (Keeling) Islands'),(49,'Colombia'),(50,'Comoros'),(51,'Congo'),(52,'Congo, the Democratic Republic of the'),(53,'Cook Islands'),(54,'Costa Rica'),(55,'Côte d\'Ivoire'),(56,'Croatia'),(57,'Cuba'),(58,'Curaçao'),(59,'Cyprus'),(60,'Czech Republic'),(61,'Denmark'),(62,'Djibouti'),(63,'Dominica'),(64,'Dominican Republic'),(65,'Ecuador'),(66,'Egypt'),(67,'El Salvador'),(68,'Equatorial Guinea'),(69,'Eritrea'),(70,'Estonia'),(71,'Ethiopia'),(72,'Falkland Islands (Malvinas)'),(73,'Faroe Islands'),(74,'Fiji'),(75,'Finland'),(76,'France'),(77,'French Guiana'),(78,'French Polynesia'),(79,'French Southern Territories'),(80,'Gabon'),(81,'Gambia'),(82,'Georgia'),(83,'Germany'),(84,'Ghana'),(85,'Gibraltar'),(86,'Greece'),(87,'Greenland'),(88,'Grenada'),(89,'Guadeloupe'),(90,'Guam'),(91,'Guatemala'),(92,'Guernsey'),(93,'Guinea'),(94,'Guinea-Bissau'),(95,'Guyana'),(96,'Haiti'),(97,'Heard Island and McDonald Islands'),(98,'Holy See (Vatican City State)'),(99,'Honduras'),(100,'Hong Kong'),(101,'Hungary'),(102,'Iceland'),(103,'India'),(104,'Indonesia'),(105,'Iran, Islamic Republic of'),(106,'Iraq'),(107,'Ireland'),(108,'Isle of Man'),(109,'Israel'),(110,'Italy'),(111,'Jamaica'),(112,'Japan'),(113,'Jersey'),(114,'Jordan'),(115,'Kazakhstan'),(116,'Kenya'),(117,'Kiribati'),(118,'Korea, Democratic People\'s Republic of'),(119,'Korea, Republic of'),(120,'Kuwait'),(121,'Kyrgyzstan'),(122,'Lao People\'s Democratic Republic'),(123,'Latvia'),(124,'Lebanon'),(125,'Lesotho'),(126,'Liberia'),(127,'Libya'),(128,'Liechtenstein'),(129,'Lithuania'),(130,'Luxembourg'),(131,'Macao'),(132,'Macedonia, the former Yugoslav Republic of'),(133,'Madagascar'),(134,'Malawi'),(135,'Malaysia'),(136,'Maldives'),(137,'Mali'),(138,'Malta'),(139,'Marshall Islands'),(140,'Martinique'),(141,'Mauritania'),(142,'Mauritius'),(143,'Mayotte'),(144,'Mexico'),(145,'Micronesia, Federated States of'),(146,'Moldova, Republic of'),(147,'Monaco'),(148,'Mongolia'),(149,'Montenegro'),(150,'Montserrat'),(151,'Morocco'),(152,'Mozambique'),(153,'Myanmar'),(154,'Namibia'),(155,'Nauru'),(156,'Nepal'),(157,'Netherlands'),(158,'New Caledonia'),(159,'New Zealand'),(160,'Nicaragua'),(161,'Niger'),(162,'Nigeria'),(163,'Niue'),(164,'Norfolk Island'),(165,'Northern Mariana Islands'),(166,'Norway'),(167,'Oman'),(168,'Pakistan'),(169,'Palau'),(170,'Palestinian Territory, Occupied'),(171,'Panama'),(172,'Papua New Guinea'),(173,'Paraguay'),(174,'Peru'),(175,'Philippines'),(176,'Pitcairn'),(177,'Poland'),(178,'Portugal'),(179,'Puerto Rico'),(180,'Qatar'),(181,'Réunion'),(182,'Romania'),(183,'Russian Federation'),(184,'Rwanda'),(185,'Saint Barthélemy'),(186,'Saint Helena, Ascension and Tristan da Cunha'),(187,'Saint Kitts and Nevis'),(188,'Saint Lucia'),(189,'Saint Martin (French part)'),(190,'Saint Pierre and Miquelon'),(191,'Saint Vincent and the Grenadines'),(192,'Samoa'),(193,'San Marino'),(194,'Sao Tome and Principe'),(195,'Saudi Arabia'),(196,'Senegal'),(197,'Serbia'),(198,'Seychelles'),(199,'Sierra Leone'),(200,'Singapore'),(201,'Sint Maarten (Dutch part)'),(202,'Slovakia'),(203,'Slovenia'),(204,'Solomon Islands'),(205,'Somalia'),(206,'South Africa'),(207,'South Georgia and the South Sandwich Islands'),(208,'South Sudan'),(209,'Spain'),(210,'Sri Lanka'),(211,'Sudan'),(212,'Suriname'),(213,'Svalbard and Jan Mayen'),(214,'Swaziland'),(215,'Sweden'),(216,'Switzerland'),(217,'Syrian Arab Republic'),(218,'Taiwan, Province of China'),(219,'Tajikistan'),(220,'Tanzania, United Republic of'),(221,'Thailand'),(222,'Timor-Leste'),(223,'Togo'),(224,'Tokelau'),(225,'Tonga'),(226,'Trinidad and Tobago'),(227,'Tunisia'),(228,'Turkey'),(229,'Turkmenistan'),(230,'Turks and Caicos Islands'),(231,'Tuvalu'),(232,'Uganda'),(233,'Ukraine'),(234,'United Arab Emirates'),(235,'United Kingdom'),(236,'United States'),(237,'United States Minor Outlying Islands'),(238,'Uruguay'),(239,'Uzbekistan'),(240,'Vanuatu'),(241,'Venezuela, Bolivarian Republic of'),(242,'Viet Nam'),(243,'Virgin Islands, British'),(244,'Virgin Islands, U.S.'),(245,'Wallis and Futuna'),(246,'Western Sahara'),(247,'Yemen'),(248,'Zambia'),(249,'Zimbabwe'),(250,'Albania');
/*!40000 ALTER TABLE `countries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cp_payments`
--

DROP TABLE IF EXISTS `cp_payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cp_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `currency` varchar(10) NOT NULL DEFAULT '0',
  `amount` decimal(20,12) NOT NULL DEFAULT '0.000000000000',
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_edited` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cp_payments`
--

LOCK TABLES `cp_payments` WRITE;
/*!40000 ALTER TABLE `cp_payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `cp_payments` 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` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `symbol` varchar(50) NOT NULL,
  `cmc_id` int(11) NOT NULL DEFAULT '0',
  `type` varchar(50) NOT NULL,
  `value` decimal(25,15) NOT NULL,
  `decimals` int(11) NOT NULL DEFAULT '0',
  `is_active` int(11) NOT NULL DEFAULT '0',
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 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 */;
INSERT INTO `currency` VALUES (1,'EUR','EUR',0,'fiat',1.000000000000000,2,1,NULL,NULL),(2,'USD','USD',0,'fiat',0.900000000000000,2,1,NULL,NULL);
/*!40000 ALTER TABLE `currency` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `files`
--

DROP TABLE IF EXISTS `files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `files`
--

LOCK TABLES `files` WRITE;
/*!40000 ALTER TABLE `files` DISABLE KEYS */;
/*!40000 ALTER TABLE `files` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ico_crypto_rates`
--

DROP TABLE IF EXISTS `ico_crypto_rates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ico_crypto_rates` (
  `code` varchar(50) NOT NULL,
  `cost` decimal(12,2) DEFAULT NULL,
  `date_updated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ico_crypto_rates`
--

LOCK TABLES `ico_crypto_rates` WRITE;
/*!40000 ALTER TABLE `ico_crypto_rates` DISABLE KEYS */;
INSERT INTO `ico_crypto_rates` VALUES ('btc',7886.31,'2018-05-23 12:03:27'),('credit card',1.00,'2018-10-23 13:49:58'),('eth',624.86,'2018-05-23 12:03:27'),('eur',1.00,'2018-11-09 16:33:11'),('ltc',124.95,'2018-05-23 12:03:27'),('usd',1.00,'2018-01-22 16:51:16');
/*!40000 ALTER TABLE `ico_crypto_rates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ico_faq`
--

DROP TABLE IF EXISTS `ico_faq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ico_faq` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` longtext NOT NULL,
  `answer` longtext NOT NULL,
  `order` int(11) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ico_faq`
--

LOCK TABLES `ico_faq` WRITE;
/*!40000 ALTER TABLE `ico_faq` DISABLE KEYS */;
/*!40000 ALTER TABLE `ico_faq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ico_files`
--

DROP TABLE IF EXISTS `ico_files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ico_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(10) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `created_ar` datetime DEFAULT CURRENT_TIMESTAMP,
  `place` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ico_files`
--

LOCK TABLES `ico_files` WRITE;
/*!40000 ALTER TABLE `ico_files` DISABLE KEYS */;
/*!40000 ALTER TABLE `ico_files` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ico_incoming`
--

DROP TABLE IF EXISTS `ico_incoming`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ico_incoming` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `period_id` int(11) NOT NULL DEFAULT '0',
  `date_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `count` decimal(25,8) DEFAULT NULL,
  `token` decimal(25,18) DEFAULT NULL,
  `token_bonus` decimal(25,18) DEFAULT NULL,
  `currency` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ico_incoming`
--

LOCK TABLES `ico_incoming` WRITE;
/*!40000 ALTER TABLE `ico_incoming` DISABLE KEYS */;
/*!40000 ALTER TABLE `ico_incoming` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ico_know_your_customer`
--

DROP TABLE IF EXISTS `ico_know_your_customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ico_know_your_customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT '0',
  `first_name` varchar(128) DEFAULT '-',
  `last_name` varchar(128) DEFAULT '-',
  `avatar` varchar(128) DEFAULT NULL,
  `birth_date` varchar(50) DEFAULT NULL,
  `country` varchar(128) NOT NULL DEFAULT 'country',
  `region` varchar(128) DEFAULT NULL,
  `city` varchar(128) DEFAULT NULL,
  `zip` varchar(50) DEFAULT NULL,
  `street` varchar(128) DEFAULT NULL,
  `telephone` varchar(128) DEFAULT NULL,
  `scan_id` varchar(128) DEFAULT NULL,
  `status` enum('unchecked','succes','failed','moderation') NOT NULL DEFAULT 'unchecked',
  `error` text,
  `passport_id` varchar(256) DEFAULT NULL,
  `passport_type` varchar(256) DEFAULT NULL,
  `trulioo_txid` varchar(256) DEFAULT NULL,
  `trulioo_record_id` varchar(256) DEFAULT NULL,
  `trulioo_data` varchar(1024) DEFAULT NULL,
  `trulioo_status` int(11) DEFAULT '0',
  `service_status` int(11) DEFAULT '0',
  `email` varchar(128) DEFAULT NULL,
  `gender` enum('male','female') DEFAULT NULL,
  `house_number` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ico_know_your_customer`
--

LOCK TABLES `ico_know_your_customer` WRITE;
/*!40000 ALTER TABLE `ico_know_your_customer` DISABLE KEYS */;
/*!40000 ALTER TABLE `ico_know_your_customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ico_orders`
--

DROP TABLE IF EXISTS `ico_orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ico_orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `date_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_id` int(11) NOT NULL,
  `count` decimal(25,8) NOT NULL,
  `main_count` decimal(25,8) NOT NULL,
  `token` decimal(30,18) NOT NULL,
  `token_bonus` decimal(30,18) NOT NULL,
  `hint` varchar(50) DEFAULT NULL,
  `cb` varchar(50) DEFAULT NULL,
  `coin_gate_id` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `wallet` varchar(128) NOT NULL DEFAULT '0',
  `currency` varchar(10) NOT NULL DEFAULT '0',
  `period_id` int(11) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `server_time` int(11) DEFAULT NULL,
  `token_wallet` varchar(128) DEFAULT NULL,
  `invoice_id` varchar(128) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `date_cteated_idx` (`date_created`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ico_orders`
--

LOCK TABLES `ico_orders` WRITE;
/*!40000 ALTER TABLE `ico_orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `ico_orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ico_settings`
--

DROP TABLE IF EXISTS `ico_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ico_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `option` varchar(128) NOT NULL DEFAULT '0',
  `name` varchar(128) NOT NULL DEFAULT '0',
  `value` longtext NOT NULL,
  `field_info` longtext NOT NULL,
  `field_type` longtext,
  PRIMARY KEY (`id`),
  UNIQUE KEY `option` (`option`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ico_settings`
--

LOCK TABLES `ico_settings` WRITE;
/*!40000 ALTER TABLE `ico_settings` DISABLE KEYS */;
INSERT INTO `ico_settings` VALUES (1,'progress','Progress bar options','{\"mode\":\"0\",\"value\":\"0\",\"need_value\":\"369000000\",\"min_value\":\"0\", \"total_tokens\" : \"615000000\"}','{\"mode\":{\"label\" : \"Progress Mode\",\"info\":\"0 - standart mode, 1 - hidden, 2 - custom value\"},\"value\":{\"label\" : \"Custom value\",\"info\" : \"Works only on 2-nd progress bar mode\"}, \"need_value\":{\"label\":\"ICO needed sum\", \"info\":\"This value mean sum, that ico must collect\"},\"min_value\":{\"label\":\"Minimum value\",\"info\":\"needed minimum value\"}, \"total_tokens\":{\"label\":\"Total tokens\", \"info\" : \"Total tokens supply\"}}','{\"mode\":\"integer\",\"value\":\"integer\",\"need_value\":\"integer\",\"min_value\":\"integer\", \"total_tokens\":\"integer\"}'),(2,'token','Token options','{\"name\":\"Tr3zor Token\",\"code\":\"TR3\",\"s_curr\":\"EUR\",\"price\":\"0.1\"}','{\"name\":{\"label\":\"Currency name\"},\"code\":{\"label\":\"Currency Code\"},\"s_curr\":{\"label\":\"Start currency\",\"info\":\"Tokens cost will calculate by this currency\"},\"price\":{\"label\":\"Price\"}}','{\"name\":\"string\",\"code\":\"string\",\"s_curr\":\"string\",\"price\":\"double\"}'),(3,'currencies_data','Currencies data','{\"btcmin\":\"0.02\",\"ltcmin\":\"0.001\",\"ethmin\":\"0.001\",\"usdmin\":\"0.02\",\"btcmax\":\"1000\",\"ltcmax\":\"1\",\"ethmax\":\"1000\",\"usdmax\":\"1000\"}','{\r\n	\"btcmin\": {\r\n		\"label\": \"Bitcoin minimum input\",\r\n		\"info\": \"\"\r\n	},\r\n	\"ltcmin\": {\r\n		\"label\": \"Litecoin  minimum input\",\r\n		\"info\": \"\"\r\n	},\r\n	\"ethmin\": {\r\n		\"label\": \"Ethereum  minimum input\",\r\n		\"info\": \"\"\r\n	},\r\n	\"btcmax\": {\r\n		\"label\": \"Bitcoin maximum input\",\r\n		\"info\": \"\"\r\n	},\r\n	\"usdmin\": {\r\n		\"label\": \"USD maximum input\",\r\n		\"info\": \"\"\r\n	},\r\n\r\n	\"usdmax\": {\r\n		\"label\": \"USD maximum input\",\r\n		\"info\": \"\"\r\n	},\r\n	\"ltcmax\": {\r\n		\"label\": \"Litecoin  maximum input\",\r\n		\"info\": \"\"\r\n	},\r\n	\"ethmax\": {\r\n		\"label\": \"Ethereum  maximum input\",\r\n		\"info\": \"\"\r\n	}\r\n}','{\r\n	\"btcmin\": \"double\",\r\n	\"ltcmin\": \"double\",\r\n	\"ethmin\": \"double\",\r\n	\"btcmax\": \"double\",\r\n	\"ltcmax\": \"double\",\r\n	\"ethmax\": \"double\",\r\n	\"usdmax\": \"double\",\r\n	\"usdmin\": \"double\"\r\n}'),(6,'currencies','Using currencies','{\"btc\":\"1\",\"ltc\":\"0\",\"eth\":\"1\",\"usd\":\"1\",\"eth_img\":\"\\/img\\/ETH.png\",\"btc_img\":\"\\/img\\/BTC.png\",\"ltc_img\":\"\\/img\\/1523024066ltc_img.png\",\"usd_img\":\"\\/img\\/paypal.png\"}','{\r\n	\"btc\": {\r\n		\"label\": \"Enable BTC input ( 1 - yes )\",\r\n		\"info\": \"if != 1 - btc deposits off\"\r\n	},\r\n	\"usd\": {\r\n		\"label\": \"usd lable\",\r\n		\"info\": \"usd info\"\r\n	},\r\n	\"ltc\": {\r\n		\"label\": \"Enable LTC input ( 1 - yes )\",\r\n		\"info\": \"if != 1- ltc deposits off\"\r\n	},\r\n	\"eth\": {\r\n		\"label\": \"Enable ETH input ( 1 - yes )\",\r\n		\"info\": \"if != 1 - eth deposits off\"\r\n	},\r\n	\"btc_img\": {\r\n		\"label\": \"Btc Icon\"\r\n	},\r\n	\"ltc_img\": {\r\n		\"label\": \"Ltc Icon\"\r\n	},\r\n	\"eth_img\": {\r\n		\"label\": \"Eth Icon\"\r\n	},\r\n	\"usd_img\": {\r\n		\"label\": \"Usd Icon\"\r\n	}\r\n}','{\r\n	\"btc\": \"boolean\",\r\n	\"ltc\": \"boolean\",\r\n	\"eth\": \"boolean\",\r\n	\"usd\": \"boolean\",\r\n	\"btc_img\": \"file\",\r\n	\"ltc_img\": \"file\",\r\n	\"eth_img\": \"file\",\r\n	\"usd_img\": \"file\"\r\n}'),(7,'ethereum_service','Ether Service','{\"last_block\":\"0\"}','{\"last_block\":{\"label\" : \"Last checked chain block\",\"info\":\"If something goes wrong - set this to \'0\'\"}}','{\"last_block\":\"integer\"}'),(8,'vest','Vest','{\"from\":\"2018-02-14 17:41\",\"to\":\"2018-05-13 17:42\",\"iterations\":\"12\"}','{\"from\" : {\"label\" : \"Vaste start\",\"info\":\"Date when vaste starts\"}, \"to\" : {\"label\" : \"Vaste end\",\"info\":\"Date when vaste ends\"}, \"iterations\" : {\"label\" : \"Periods count\",\"info\":\"Count of vaste periods\"}}','{\"from\" : \"datetime\", \"to\" : \"datetime\", \"iterations\" : \"integer\"}'),(9,'wallets','Ico Wallets Settings','{\"main\":\"0x979e8a2dc2dcef0f6d7195e57399ebb2235465be\",\"sc\":\"0x63e3ef06e9378613b808fc6fc83292093f4f4b9b\", \"btc\": \"17cAZ7oet7thw5CpswbS9wAtH5g9FV1prj\"}','{\"main\" : {\"label\" : \"Main wallet\",\"info\" : \"Head ETH wallet, where smart contract published\"}, \"sc\" : {\"label\" : \"SmartContract Wallet\", \"info\" : \"Smart contract wallet\"}, \"btc\" : {\"label\" : \"BTC Wallet\", \"info\" : \"BTC wallet\"}}','{\"main\" : \"string\", \"sc\" : \"string\", \"btc\" : \"string\"}'),(10,'bonuses','Bonuses using','{\"use\":\"2\"}','{\"use\" : {\"label\" : \"0 - use both, 1 - use value, 2 - use date\"}} ','{\"use\" : \"integer\"}'),(11,'ref_program','Referral Program','{\"use\":\"1\"}','{\"use\" : {\"label\" : \"0 - disable, 1 - enable\"}} ','{\"use\" : \"integer\"}'),(12,'frontend_settings','Frontend Settings','{\"ico_name\":\"Tr3zor\",\"color\":\"#DE0245\",\"use_kyc\":\"1\",\"logo\":\"\"}','{\"logo\" : {\"label\" : \"Logo for cabinet\"}, \"color\": {\"label\": \"Color for site\"}, \"ico_name\": {\"label\": \"ICO name\"}, \"use_kyc\": {\"label\": \"Use Kyc\"}}','{\"logo\": \"file\", \"color\": \"color\", \"ico_name\": \"string\", \"use_kyc\": \"string\"}');
/*!40000 ALTER TABLE `ico_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ico_social`
--

DROP TABLE IF EXISTS `ico_social`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ico_social` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `date_created` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ico_social`
--

LOCK TABLES `ico_social` WRITE;
/*!40000 ALTER TABLE `ico_social` DISABLE KEYS */;
/*!40000 ALTER TABLE `ico_social` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ico_transactions`
--

DROP TABLE IF EXISTS `ico_transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ico_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('deposit','withdraw','referal') NOT NULL DEFAULT 'deposit',
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` int(2) NOT NULL DEFAULT '0',
  `process_status` int(2) NOT NULL DEFAULT '0',
  `total_main` decimal(25,8) DEFAULT '0.00000000',
  `amount_main` decimal(25,8) DEFAULT '0.00000000',
  `bonus_main` decimal(25,8) DEFAULT '0.00000000',
  `total_token` decimal(25,8) DEFAULT '0.00000000',
  `amount_token` decimal(25,8) DEFAULT '0.00000000',
  `bonus_token` decimal(25,8) DEFAULT '0.00000000',
  `test_field` varchar(128) DEFAULT '0.00000000',
  `server_time` int(11) DEFAULT '0',
  `count` decimal(25,8) DEFAULT '0.00000000',
  `period_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL,
  `currency` varchar(10) DEFAULT NULL,
  `user_wallet` varchar(100) DEFAULT NULL,
  `txn_id` varchar(255) DEFAULT NULL,
  `memo` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ico_transactions`
--

LOCK TABLES `ico_transactions` WRITE;
/*!40000 ALTER TABLE `ico_transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `ico_transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ico_user_wallets`
--

DROP TABLE IF EXISTS `ico_user_wallets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ico_user_wallets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `wallet` varchar(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ico_user_wallets`
--

LOCK TABLES `ico_user_wallets` WRITE;
/*!40000 ALTER TABLE `ico_user_wallets` DISABLE KEYS */;
/*!40000 ALTER TABLE `ico_user_wallets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log`
--

DROP TABLE IF EXISTS `log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `text` varchar(512) DEFAULT NULL,
  `data` varchar(1024) DEFAULT NULL,
  `type` varchar(64) DEFAULT NULL,
  `date_created` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log`
--

LOCK TABLES `log` WRITE;
/*!40000 ALTER TABLE `log` DISABLE KEYS */;
/*!40000 ALTER TABLE `log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migration`
--

DROP TABLE IF EXISTS `migration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migration` (
  `version` varchar(180) NOT NULL,
  `apply_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migration`
--

LOCK TABLES `migration` WRITE;
/*!40000 ALTER TABLE `migration` DISABLE KEYS */;
INSERT INTO `migration` VALUES ('m000000_000000_base',1505138336),('m130524_201442_init',1505138339),('m140209_132017_init',1505462158),('m140403_174025_create_account_table',1505462159),('m140504_113157_update_tables',1505462161),('m140504_130429_create_token_table',1505462161),('m140830_171933_fix_ip_field',1505462161),('m140830_172703_change_account_table_name',1505462161),('m141222_110026_update_ip_field',1505462162),('m141222_135246_alter_username_length',1505462162),('m150614_103145_update_social_account_table',1505462163),('m150623_212711_fix_username_notnull',1505462163),('m151218_234654_add_timezone_to_profile',1505462163),('m160929_103127_add_last_login_at_to_user_table',1505462164),('m181119_101117_create_blog',1603404225),('m181119_101140_create_blog_local',1603404225),('m181121_163333_subscribes_update',1603404291),('m181122_133512_create_currency',1603404291),('m181127_133518_update_periods',1603404291),('m181128_092232_create_support',1603404291),('m181129_213338_cryptoworker',1603404291),('m181207_150541_update_ico_know_your_customer',1603404291),('m181217_152725_update_periods',1603404291),('m190110_103145_update_ico_orders',1603404291),('m190111_164614_update_ico_orders',1603404291),('m190115_111218_alter_ico_know_your_customer_table',1603404291),('m190115_113558_alter_periods_table',1603404291),('m190130_130828_adding',1603404291),('m190206_102740_extend_kyc_via_trulioo',1603404291),('m190212_112146_add_ref_amount_field_to_user_table',1603404291),('m190212_140746_add_email_field_to_kyc_table',1603404291),('m190213_162900_create_log_table',1603404291),('m190214_192322_altering_kyc_table_fields',1603404291),('m190215_134955_add_column_to_ico_order_table',1603404291),('m190216_170248_add_hash_column_to_kyc_file',1603404291),('m190225_133855_alter_log_table',1603404291),('m190225_140507_alter_log_table_drop_created_at_column',1603404291),('m190226_141035_alter_kyc_table_add_full_columns',1603404291),('m201103_185144_add_currency_data',1604429900);
/*!40000 ALTER TABLE `migration` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `period_conditions`
--

DROP TABLE IF EXISTS `period_conditions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `period_conditions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `period_id` int(11) NOT NULL,
  `value_1` varchar(50) NOT NULL,
  `value_2` varchar(50) NOT NULL,
  `bonus_multiplier` decimal(10,2) NOT NULL,
  `type` enum('sum','datetime') NOT NULL,
  PRIMARY KEY (`id`),
  KEY `period_id` (`period_id`),
  CONSTRAINT `FK_period_conditions_periods` FOREIGN KEY (`period_id`) REFERENCES `periods` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `period_conditions`
--

LOCK TABLES `period_conditions` WRITE;
/*!40000 ALTER TABLE `period_conditions` DISABLE KEYS */;
/*!40000 ALTER TABLE `period_conditions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `periods`
--

DROP TABLE IF EXISTS `periods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `periods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `period_name` varchar(128) NOT NULL,
  `from` timestamp NULL DEFAULT NULL,
  `to` timestamp NULL DEFAULT NULL,
  `type` enum('work','reserve','wait') DEFAULT NULL,
  `bonus` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `from_volume` double DEFAULT NULL,
  `to_volume` double DEFAULT NULL,
  `bonus_type` varchar(50) DEFAULT NULL,
  `token_price` double DEFAULT NULL,
  `hard_cap` double DEFAULT NULL,
  `min_invest` double DEFAULT '0',
  `is_complete` smallint(6) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `periods`
--

LOCK TABLES `periods` WRITE;
/*!40000 ALTER TABLE `periods` DISABLE KEYS */;
INSERT INTO `periods` VALUES (13,'2018-10-22 11:15:54','Private sale','2020-12-01 12:00:00','2021-03-31 11:59:00','work',75,1,500,'date',0.1,27000000,0,0),(14,'2018-11-15 15:39:05','Pre-sale','2021-04-01 12:00:00','2021-07-31 12:00:00','work',50,NULL,NULL,'date',0.1,100000000,0,0),(15,'2020-11-05 14:38:46','Main sale','2021-08-01 12:00:00','2021-10-31 12:00:00','work',0,NULL,NULL,'date',0.1,29875000,0,0);
/*!40000 ALTER TABLE `periods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profile`
--

DROP TABLE IF EXISTS `profile`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profile` (
  `user_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `public_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gravatar_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `gravatar_id` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bio` text COLLATE utf8_unicode_ci,
  `timezone` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  CONSTRAINT `fk_user_profile` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profile`
--

LOCK TABLES `profile` WRITE;
/*!40000 ALTER TABLE `profile` DISABLE KEYS */;
/*!40000 ALTER TABLE `profile` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `social_account`
--

DROP TABLE IF EXISTS `social_account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `social_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `provider` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `client_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `data` text COLLATE utf8_unicode_ci,
  `code` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` int(11) DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account_unique` (`provider`,`client_id`),
  UNIQUE KEY `account_unique_code` (`code`),
  KEY `fk_user_account` (`user_id`),
  CONSTRAINT `fk_user_account` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `social_account`
--

LOCK TABLES `social_account` WRITE;
/*!40000 ALTER TABLE `social_account` DISABLE KEYS */;
/*!40000 ALTER TABLE `social_account` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subscribes`
--

DROP TABLE IF EXISTS `subscribes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscribes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `email` varchar(128) DEFAULT NULL,
  `token` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subscribes`
--

LOCK TABLES `subscribes` WRITE;
/*!40000 ALTER TABLE `subscribes` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscribes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `support`
--

DROP TABLE IF EXISTS `support`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `support` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `message` text,
  `status` tinyint(4) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `support`
--

LOCK TABLES `support` WRITE;
/*!40000 ALTER TABLE `support` DISABLE KEYS */;
/*!40000 ALTER TABLE `support` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `token`
--

DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
  `user_id` int(11) NOT NULL,
  `code` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` int(11) NOT NULL,
  `type` smallint(6) NOT NULL,
  UNIQUE KEY `token_unique` (`user_id`,`code`,`type`),
  CONSTRAINT `fk_user_token` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `token`
--

LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transactions`
--

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address` varchar(128) NOT NULL DEFAULT '0',
  `amount` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_sended` timestamp NULL DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `hash` varchar(128) NOT NULL DEFAULT '0',
  `order_id` int(11) DEFAULT NULL,
  `currency` varchar(15) DEFAULT NULL,
  `token_address` varchar(128) DEFAULT NULL,
  `token_amount` decimal(20,6) DEFAULT NULL,
  `from_address` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transactions`
--

LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
/*!40000 ALTER TABLE `transactions` 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` int(11) NOT NULL AUTO_INCREMENT,
  `referer_id` int(11) NOT NULL DEFAULT '0',
  `referal_link` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vest_step` int(11) NOT NULL DEFAULT '0',
  `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `eth_wallet` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password_hash` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `auth_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `confirmed_at` int(11) DEFAULT NULL,
  `unconfirmed_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `blocked_at` int(11) DEFAULT NULL,
  `registration_ip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  `flags` int(11) NOT NULL DEFAULT '0',
  `last_login_at` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `is_admin` tinyint(4) DEFAULT '0',
  `google_se` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `google_tfa` tinyint(1) DEFAULT '0',
  `token` decimal(25,18) DEFAULT '0.000000000000000000',
  `token_bonus` decimal(25,18) DEFAULT '0.000000000000000000',
  `password_reset_token` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `referer_profit` decimal(25,8) DEFAULT '0.00000000',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_unique_email` (`email`),
  UNIQUE KEY `referal_link` (`referal_link`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_kyc_files`
--

DROP TABLE IF EXISTS `user_kyc_files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_kyc_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `file_type` varchar(255) DEFAULT NULL,
  `path` text,
  `is_downl` tinyint(4) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `hash` varchar(64) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_kyc_files`
--

LOCK TABLES `user_kyc_files` WRITE;
/*!40000 ALTER TABLE `user_kyc_files` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_kyc_files` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wallet`
--

DROP TABLE IF EXISTS `wallet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wallet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wallet` varchar(128) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `currency` varchar(25) DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `FK1_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wallet`
--

LOCK TABLES `wallet` WRITE;
/*!40000 ALTER TABLE `wallet` DISABLE KEYS */;
/*!40000 ALTER TABLE `wallet` 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 2020-11-05 14:49:21
