Home Explore Help
Sign In
wr
/
tickserver
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
tickserver
/
kline
/
fzmnewdb.sql

fzmnewdb.sql 11 KB
Permalink History Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182 
  1. -- MySQL dump 10.13  Distrib 5.5.53, for debian-linux-gnu (x86_64)
    2. 

  2. --
    3. 

  3. -- Host: localhost    Database: fzmnewdb
    4. 

  4. -- ------------------------------------------------------
    5. 

  5. -- Server version	5.5.53-0ubuntu0.14.04.1
    6. 

  6. 

  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    8. 

  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    9. 

  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    10. 

  10. /*!40101 SET NAMES utf8 */;
    11. 

  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    12. 

  12. /*!40103 SET TIME_ZONE='+00:00' */;
    13. 

  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    14. 

  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    15. 

  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    16. 

  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    17. 

  17. 

  18. --
    19. 

  19. -- Table structure for table `Lmax_inss`
    20. 

  20. --
    21. 

  21. 

  22. DROP TABLE IF EXISTS `Lmax_inss`;
    23. 

  23. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    24. 

  24. /*!40101 SET character_set_client = utf8 */;
    25. 

  25. CREATE TABLE `Lmax_inss` (
    26. 

  26.   `Id` varchar(32) NOT NULL DEFAULT '',
    27. 

  27.   `Name` text,
    28. 

  28.   `Typ` text,
    29. 

  29.   `Exid` text,
    30. 

  30.   `PriceInc` double DEFAULT NULL,
    31. 

  31.   `Margin` double DEFAULT NULL,
    32. 

  32.   `TickStartTime` bigint(20) DEFAULT NULL,
    33. 

  33.   `M1StartTime` bigint(20) DEFAULT NULL,
    34. 

  34.   `D1StartTime` bigint(20) DEFAULT NULL,
    35. 

  35.   PRIMARY KEY (`Id`)
    36. 

  36. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    37. 

  37. /*!40101 SET character_set_client = @saved_cs_client */;
    38. 

  38. 

  39. --
    40. 

  40. -- Dumping data for table `Lmax_inss`
    41. 

  41. --
    42. 

  42. 

  43. LOCK TABLES `Lmax_inss` WRITE;
    44. 

  44. /*!40000 ALTER TABLE `Lmax_inss` DISABLE KEYS */;
    45. 

  45. 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);
    46. 

  46. /*!40000 ALTER TABLE `Lmax_inss` ENABLE KEYS */;
    47. 

  47. UNLOCK TABLES;
    48. 

  48. 

  49. --
    50. 

  50. -- Table structure for table `history`
    51. 

  51. --
    52. 

  52. 

  53. DROP TABLE IF EXISTS `history`;
    54. 

  54. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    55. 

  55. /*!40101 SET character_set_client = utf8 */;
    56. 

  56. CREATE TABLE `history` (
    57. 

  57.   `Id` varchar(32) NOT NULL DEFAULT '',
    58. 

  58.   `LastTime` bigint(20) DEFAULT NULL,
    59. 

  59.   PRIMARY KEY (`Id`)
    60. 

  60. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    61. 

  61. /*!40101 SET character_set_client = @saved_cs_client */;
    62. 

  62. 

  63. --
    64. 

  64. -- Dumping data for table `history`
    65. 

  65. --
    66. 

  66. 

  67. LOCK TABLES `history` WRITE;
    68. 

  68. /*!40000 ALTER TABLE `history` DISABLE KEYS */;
    69. 

  69. INSERT INTO `history` VALUES ('btc',0),('bty',0),('huobi',0),('lmax',0),('polo',0),('yunbi',0);
    70. 

  70. /*!40000 ALTER TABLE `history` ENABLE KEYS */;
    71. 

  71. UNLOCK TABLES;
    72. 

  72. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    73. 

  73. 

  74. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    75. 

  75. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    76. 

  76. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    77. 

  77. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    78. 

  78. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    79. 

  79. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    80. 

  80. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    81. 

  81. 

  82. -- Dump completed on 2017-04-02 15:20:56
    83.