-- MySQL dump 10.13 Distrib 5.5.53, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: fzmnewdb -- ------------------------------------------------------ -- Server version 5.5.53-0ubuntu0.14.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 `Lmax_inss` -- DROP TABLE IF EXISTS `Lmax_inss`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Lmax_inss` ( `Id` varchar(32) NOT NULL DEFAULT '', `Name` text, `Typ` text, `Exid` text, `PriceInc` double DEFAULT NULL, `Margin` double DEFAULT NULL, `TickStartTime` bigint(20) DEFAULT NULL, `M1StartTime` bigint(20) DEFAULT NULL, `D1StartTime` bigint(20) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Lmax_inss` -- LOCK TABLES `Lmax_inss` WRITE; /*!40000 ALTER TABLE `Lmax_inss` DISABLE KEYS */; INSERT INTO `Lmax_inss` VALUES ('lmax_100089','UK 100','forex','lmax',0.1,0.03,1279497600000,1279497600000,1279497600000),('lmax_100091','Wall Street 30','forex','lmax',1,0.015,1279497600000,1279497600000,1279497600000),('lmax_100093','US SPX 500','forex','lmax',0.1,0.015,1279497600000,1279497600000,1279497600000),('lmax_100095','US Tech 100','forex','lmax',0.1,0.02,1279497600000,1279497600000,1279497600000),('lmax_100097','Germany 30','forex','lmax',0.1,0.03,1279497600000,1279497600000,1279497600000),('lmax_100099','France 40','forex','lmax',0.1,0.03,1279497600000,1279497600000,1279497600000),('lmax_100101','Europe 50','forex','lmax',0.1,0.03,1279497600000,1279497600000,1279497600000),('lmax_100105','Japan 225','forex','lmax',1,0.02,1365739200000,1365739200000,1365739200000),('lmax_100479','EUR/CZK','forex','lmax',0.0001,0.1,1309899600000,1309899600000,1309899600000),('lmax_100481','GBP/CZK','forex','lmax',0.0001,0.1,1309899600000,1309899600000,1309899600000),('lmax_100483','USD/CZK','forex','lmax',0.0001,0.1,1309899600000,1309899600000,1309899600000),('lmax_100485','EUR/DKK','forex','lmax',0.00001,0.1,1309899600000,1309899600000,1309899600000),('lmax_100487','GBP/DKK','forex','lmax',0.00001,0.1,1309899600000,1309899600000,1309899600000),('lmax_100489','USD/DKK','forex','lmax',0.00001,0.1,1309899600000,1309899600000,1309899600000),('lmax_100491','EUR/HKD','forex','lmax',0.00001,0.1,1309899600000,1309899600000,1309899600000),('lmax_100493','GBP/HKD','forex','lmax',0.00001,0.1,1309899600000,1309899600000,1309899600000),('lmax_100495','USD/HKD','forex','lmax',0.00001,0.1,1309899600000,1309899600000,1309899600000),('lmax_100497','EUR/HUF','forex','lmax',0.001,0.03,1309899600000,1309899600000,1309899600000),('lmax_100499','GBP/HUF','forex','lmax',0.001,0.03,1309899600000,1309899600000,1309899600000),('lmax_100501','USD/HUF','forex','lmax',0.001,0.03,1309899600000,1309899600000,1309899600000),('lmax_100503','EUR/MXN','forex','lmax',0.00001,0.03,1309899600000,1309899600000,1309899600000),('lmax_100505','GBP/MXN','forex','lmax',0.00001,0.03,1309899600000,1309899600000,1309899600000),('lmax_100507','USD/MXN','forex','lmax',0.00001,0.03,1309899600000,1309899600000,1309899600000),('lmax_100509','EUR/NOK','forex','lmax',0.00001,0.015,1309899600000,1309899600000,1309899600000),('lmax_100511','GBP/NOK','forex','lmax',0.00001,0.015,1309899600000,1309899600000,1309899600000),('lmax_100513','USD/NOK','forex','lmax',0.00001,0.015,1309899600000,1309899600000,1309899600000),('lmax_100515','EUR/NZD','forex','lmax',0.00001,0.02,1309899600000,1309899600000,1309899600000),('lmax_100517','GBP/NZD','forex','lmax',0.00001,0.02,1309899600000,1309899600000,1309899600000),('lmax_100519','EUR/PLN','forex','lmax',0.00001,0.02,1309899600000,1309899600000,1309899600000),('lmax_100521','GBP/PLN','forex','lmax',0.00001,0.02,1309899600000,1309899600000,1309899600000),('lmax_100523','USD/PLN','forex','lmax',0.00001,0.02,1309899600000,1309899600000,1309899600000),('lmax_100525','EUR/SEK','forex','lmax',0.00001,0.015,1402433997072,1309899600000,1309899600000),('lmax_100527','GBP/SEK','forex','lmax',0.00001,0.015,1309899600000,1309899600000,1309899600000),('lmax_100529','USD/SEK','forex','lmax',0.00001,0.015,1309899600000,1309899600000,1309899600000),('lmax_100531','EUR/SGD','forex','lmax',0.00001,0.1,1309899600000,1309899600000,1309899600000),('lmax_100533','GBP/SGD','forex','lmax',0.00001,0.1,1309899600000,1309899600000,1309899600000),('lmax_100535','USD/SGD','forex','lmax',0.00001,0.1,1309899600000,1309899600000,1309899600000),('lmax_100537','EUR/TRY','forex','lmax',0.00001,0.015,1399694400000,1399694400000,1399694400000),('lmax_100539','GBP/TRY','forex','lmax',0.00001,0.015,1399694400000,1399694400000,1399694400000),('lmax_100541','USD/TRY','forex','lmax',0.00001,0.015,1309899600000,1309899600000,1309899600000),('lmax_100543','EUR/ZAR','forex','lmax',0.00001,0.02,1309899600000,1309899600000,1309899600000),('lmax_100545','GBP/ZAR','forex','lmax',0.00001,0.02,1309899600000,1309899600000,1309899600000),('lmax_100547','USD/ZAR','forex','lmax',0.00001,0.02,1309899600000,1309899600000,1309899600000),('lmax_100555','NOK/SEK','forex','lmax',0.00001,0.015,1394683200000,1394683200000,1394683200000),('lmax_100613','NZD/USD','forex','lmax',0.00001,0.015,1317268800000,1317268800000,1317268800000),('lmax_100615','AUD/NZD','forex','lmax',0.00001,0.015,1317268800000,1317268800000,1317268800000),('lmax_100617','NZD/JPY','forex','lmax',0.001,0.025,1317268800000,1317268800000,1317268800000),('lmax_100619','AUD/CHF','forex','lmax',0.00001,0.02,1317268800000,1317268800000,1317268800000),('lmax_100637','Gold (Spot)','forex','lmax',0.01,0.01,1323666000000,1323666000000,1323666000000),('lmax_100639','Silver (Spot)','forex','lmax',0.001,0.03,1323666000000,1323666000000,1323666000000),('lmax_100667','AUD/CAD','forex','lmax',0.00001,0.01,1331758800000,1331758800000,1331758800000),('lmax_100669','CAD/JPY','forex','lmax',0.001,0.015,1331758800000,1331758800000,1331758800000),('lmax_100671','CAD/CHF','forex','lmax',0.00001,0.02,1331758800000,1331758800000,1331758800000),('lmax_100673','NZD/CAD','forex','lmax',0.00001,0.02,1331758800000,1331758800000,1331758800000),('lmax_100675','NZD/CHF','forex','lmax',0.00001,0.02,1331758800000,1331758800000,1331758800000),('lmax_100677','NZD/SGD','forex','lmax',0.00001,0.1,1331758800000,1331758800000,1331758800000),('lmax_100679','EUR/RUB','forex','lmax',0.00001,0.05,1387490400000,1387490400000,1387490400000),('lmax_100681','USD/RUB','forex','lmax',0.0005,0.05,1387490400000,1387490400000,1387490400000),('lmax_100800','US Crude (Spot)','forex','lmax',0.01,0.02,1364850000000,1364850000000,1364850000000),('lmax_100803','XAU/AUD','forex','lmax',0.01,0.02,1369022400000,1369022400000,1369022400000),('lmax_100804','XAG/AUD','forex','lmax',0.001,0.03,1369022400000,1369022400000,1369022400000),('lmax_100805','UK Brent (Spot)','forex','lmax',0.01,0.02,1369688400000,1369688400000,1369688400000),('lmax_100806','XPT/USD','forex','lmax',0.01,0.05,1379304000000,1379304000000,1379304000000),('lmax_100807','XPD/USD','forex','lmax',0.01,0.05,1379304000000,1379304000000,1379304000000),('lmax_100888','Australia 200','forex','lmax',0.1,0.02,1384146000000,1384146000000,1384146000000),('lmax_100892','USD/CNH','forex','lmax',0.0001,0.1,1387490400000,1387490400000,1387490400000),('lmax_100925','XAU/EUR','forex','lmax',0.01,0.04,1404766800000,1404766800000,1404766800000),('lmax_100926','US Natural Gas (Spot)','forex','lmax',0.001,0.04,1424754000000,1424754000000,1424754000000),('lmax_100927','USD/ILS','forex','lmax',0.0005,0.03,1428379200000,1428379200000,1428379200000),('lmax_110091','Wall Street 30 (Mini)','forex','lmax',1,0.01,1429502400000,1429502400000,1429502400000),('lmax_110093','US SPX 500 (Mini)','forex','lmax',0.1,0.01,1417496400000,1417496400000,1417496400000),('lmax_110095','US Tech 100 (Mini)','forex','lmax',0.1,0.01,1429502400000,1429502400000,1429502400000),('lmax_110097','Germany 30 (Mini)','forex','lmax',0.1,0.03,1409094000000,1409094000000,1409094000000),('lmax_4001','EUR/USD','forex','lmax',0.00001,0.01,1440986821264,1440986760000,1440709500000),('lmax_4002','GBP/USD','forex','lmax',0.00001,0.01,1278648000000,1278648000000,1278648000000),('lmax_4003','EUR/GBP','forex','lmax',0.00001,0.01,1278648000000,1278648000000,1278648000000),('lmax_4004','USD/JPY','forex','lmax',0.001,0.01,1278648000000,1278648000000,1278648000000),('lmax_4005','GBP/JPY','forex','lmax',0.001,0.015,1278648000000,1278648000000,1278648000000),('lmax_4006','EUR/JPY','forex','lmax',0.001,0.01,1278648000000,1278648000000,1278648000000),('lmax_4007','AUD/USD','forex','lmax',0.00001,0.01,1278648000000,1278648000000,1278648000000),('lmax_4008','AUD/JPY','forex','lmax',0.001,0.015,1278648000000,1278648000000,1278648000000),('lmax_4009','CHF/JPY','forex','lmax',0.001,0.02,1278648000000,1278648000000,1278648000000),('lmax_4010','USD/CHF','forex','lmax',0.00001,0.02,1278648000000,1278648000000,1278648000000),('lmax_4011','EUR/CHF','forex','lmax',0.00001,0.02,1278648000000,1278648000000,1278648000000),('lmax_4012','GBP/CHF','forex','lmax',0.00001,0.02,1278648000000,1278648000000,1278648000000),('lmax_4013','USD/CAD','forex','lmax',0.00001,0.01,1278648000000,1278648000000,1278648000000),('lmax_4014','GBP/CAD','forex','lmax',0.00001,0.01,1278648000000,1278648000000,1278648000000),('lmax_4015','EUR/CAD','forex','lmax',0.00001,0.01,1278648000000,1278648000000,1278648000000),('lmax_4016','EUR/AUD','forex','lmax',0.00001,0.015,1278648000000,1278648000000,1278648000000),('lmax_4017','GBP/AUD','forex','lmax',0.00001,0.015,1278648000000,1278648000000,1278648000000); /*!40000 ALTER TABLE `Lmax_inss` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `history` -- DROP TABLE IF EXISTS `history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `history` ( `Id` varchar(32) NOT NULL DEFAULT '', `LastTime` bigint(20) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `history` -- LOCK TABLES `history` WRITE; /*!40000 ALTER TABLE `history` DISABLE KEYS */; INSERT INTO `history` VALUES ('btc',0),('bty',0),('huobi',0),('lmax',0),('polo',0),('yunbi',0); /*!40000 ALTER TABLE `history` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2017-04-02 15:20:56