· 6 years ago · Oct 15, 2019, 07:10 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.9
3-- https://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 15, 2019 at 07:04 AM
7-- Server version: 5.6.37
8-- PHP Version: 7.1.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `deposit`
21--
22
23CREATE TABLE IF NOT EXISTS `deposit` (
24 `deposit_id` int(11) NOT NULL,
25 `user_id` varchar(255) DEFAULT NULL,
26 `deposit_amount` decimal(22,10) DEFAULT '0.0000000000',
27 `deposit_method` varchar(255) DEFAULT NULL,
28 `txid` varchar(225) DEFAULT NULL,
29 `ec` int(22) NOT NULL DEFAULT '22',
30 `pkg` int(12) DEFAULT NULL,
31 `fees` float DEFAULT NULL,
32 `comments` text,
33 `deposit_date` timestamp NULL DEFAULT NULL,
34 `time` int(22) NOT NULL,
35 `batch` varchar(255) DEFAULT NULL,
36 `time_approved` int(22) DEFAULT NULL,
37 `deposit_ip` varchar(45) DEFAULT NULL,
38 `status` int(11) NOT NULL DEFAULT '0'
39) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1 COMMENT='Customer deposit information will store into this table.';
40
41--
42-- Dumping data for table `deposit`
43--
44
45INSERT INTO `deposit` (`deposit_id`, `user_id`, `deposit_amount`, `deposit_method`, `txid`, `ec`, `pkg`, `fees`, `comments`, `deposit_date`, `time`, `batch`, `time_approved`, `deposit_ip`, `status`) VALUES
46(7, '1', '5.0000000000', 'deposit', 'CPDI0HYGZXZCJXIZGFPIZLYMFR', 22, 1, NULL, NULL, '2019-09-30 05:52:28', 1569869548, NULL, NULL, '::1', 1),
47(8, '1', '10000.0000000000', 'deposit', '5d93910c63addiaj4s', 22, 1, NULL, NULL, '2019-10-01 04:46:55', 1569952015, NULL, NULL, '::1', 1),
48(9, '1', '100.0000000000', 'deposit', '5d939222bce9cfzxzj', 99, 1, NULL, NULL, '2019-10-01 04:51:33', 1569952293, NULL, NULL, '::1', 1),
49(10, '1', '100.0000000000', 'deposit', '5d93de9c2a530cnhtj', 55, 1, NULL, NULL, '2019-10-01 10:17:48', 1569971868, NULL, NULL, '::1', 1),
50(11, '1', '10.0000000000', 'deposit', 'CPDJ1JMFGEQZ2VZVHM18PLKC5E', 22, 1, NULL, NULL, '2019-10-01 10:30:00', 1569972600, NULL, NULL, '::1', 1),
51(12, '1', '100.0000000000', 'deposit', '5d93e493969b6rxytk', 55, 1, NULL, NULL, '2019-10-01 10:43:15', 1569973395, NULL, NULL, '::1', 1),
52(13, '1', '1000.0000000000', 'deposit', 'CPDJ5VFIBRAGGINGMWIKFJQEW0', 22, 1, NULL, NULL, '2019-10-01 10:43:40', 1569973420, NULL, NULL, '::1', 1),
53(14, '1', '100.0000000000', 'deposit', 'CPDJ6P8RJIQZG9NZ1A7RZCLYQU', 22, 1, NULL, NULL, '2019-10-02 11:37:58', 1569976678, NULL, NULL, '::1', 1),
54(15, '1', '500.0000000000', 'deposit', '5d93f17199268cuf3a', 55, 1, NULL, NULL, '2019-10-02 11:38:09', 1569976689, NULL, NULL, '::1', 1),
55(16, '1', '100.0000000000', 'deposit', '5d9400307b7fb8vtrp', 55, 1, NULL, NULL, '2019-10-02 00:41:04', 1569980464, NULL, NULL, '::1', 1),
56(17, '1', '100.0000000000', 'deposit', '5d94003d1b2bclz2d4', 55, 1, NULL, NULL, '2019-10-02 00:41:17', 1569980477, NULL, NULL, '::1', 1),
57(18, '1', '100.0000000000', 'deposit', '5d9400a9ad1acnvrzp', 55, 1, NULL, NULL, '2019-10-02 00:43:05', 1569980585, NULL, NULL, '::1', 1),
58(19, '1', '1000.0000000000', 'deposit', '5d9400fed507cfgtb5', 55, 1, NULL, NULL, '2019-10-02 00:44:30', 1569980670, NULL, NULL, '::1', 1),
59(20, '1', '10000.0000000000', 'deposit', '5d940108e80c0bifbg', 77, 1, NULL, NULL, '2019-10-02 00:44:40', 1569980680, NULL, NULL, '::1', 1),
60(21, '1', '10000.0000000000', 'deposit', '5d9401125f8dfa1m3f', 77, 1, NULL, NULL, '2019-10-02 00:44:50', 1569980690, NULL, NULL, '::1', 1),
61(22, '1', '100.0000000000', 'deposit', '5d94012a30d9amzrqi', 55, 1, NULL, NULL, '2019-10-02 00:45:14', 1569980714, NULL, NULL, '::1', 1),
62(23, '1', '100.0000000000', 'deposit', '5d940137d890flpwze', 77, 1, NULL, NULL, '2019-10-02 00:45:27', 1569980727, NULL, NULL, '::1', 1),
63(24, '1', '100.0000000000', 'deposit', '5d94013de87769vtxq', 77, 1, NULL, NULL, '2019-10-02 00:45:33', 1569980733, NULL, NULL, '::1', 1),
64(25, '1', '100.0000000000', 'deposit', '5d94040b159870nozs', 55, 1, NULL, NULL, '2019-10-02 00:57:31', 1569981451, NULL, NULL, '::1', 1),
65(26, '1', '100.0000000000', 'deposit', '5d9404138d8b0uwa7e', 77, 1, NULL, NULL, '2019-10-02 00:57:39', 1569981459, NULL, NULL, '::1', 1),
66(27, '1', '50000.0000000000', 'bonus', NULL, 22, NULL, 0, '', '2019-10-02 01:27:38', 1569983258, NULL, NULL, '::1', 1),
67(28, '1', '50000.0000000000', 'bonus', NULL, 55, NULL, 0, '', '2019-10-02 01:29:04', 1569983344, NULL, NULL, '::1', 1),
68(29, '1', '400.0000000000', 'deposit', NULL, 22, 1, 0, '', '2019-10-03 08:52:12', 1570139532, NULL, NULL, '::1', 1),
69(30, '1', '5000.0000000000', 'deposit', NULL, 55, 5, 0, '', '2019-10-03 09:24:36', 1570141476, NULL, NULL, '::1', 1),
70(31, '1', '5000.0000000000', 'deposit', NULL, 22, 1, 0, 'trg', '2019-10-04 09:42:41', 1570185761, NULL, NULL, '::1', 1),
71(32, '1', '5000.0000000000', 'deposit', NULL, 22, 1, 0, '', '2019-10-04 10:45:21', 1570189521, NULL, NULL, '::1', 1),
72(33, '1', '22.0000000000', 'deposit', NULL, 55, 5, 0, '', '2019-10-04 10:46:29', 1570189589, NULL, NULL, '::1', 1),
73(34, '1', '22.0000000000', 'deposit', NULL, 55, 5, 0, '', '2019-10-04 10:49:06', 1570189746, NULL, NULL, '::1', 1),
74(35, '2', '22.0000000000', 'deposit', NULL, 55, 5, 0, '', '2019-10-14 10:31:35', 1571095895, NULL, NULL, '::1', 1),
75(36, '2', '22.0000000000', 'deposit', NULL, 55, 5, 0, '', '2019-10-14 10:49:24', 1571096964, NULL, NULL, '::1', 1),
76(37, '1', '22.0000000000', 'deposit', NULL, 55, 5, 0, '', '2019-10-14 10:52:17', 1571097137, NULL, NULL, '::1', 1);
77
78-- --------------------------------------------------------
79
80--
81-- Table structure for table `earnings`
82--
83
84CREATE TABLE IF NOT EXISTS `earnings` (
85 `earning_id` int(11) NOT NULL,
86 `user_id` varchar(250) NOT NULL,
87 `Purchaser_id` varchar(250) DEFAULT NULL,
88 `earning_type` varchar(45) NOT NULL,
89 `ec` int(22) NOT NULL DEFAULT '22',
90 `package_id` varchar(250) DEFAULT NULL,
91 `order_id` int(11) DEFAULT NULL,
92 `date` datetime NOT NULL,
93 `time` int(22) NOT NULL,
94 `amount` decimal(22,10) NOT NULL DEFAULT '0.0000000000',
95 `comments` mediumtext
96) ENGINE=InnoDB AUTO_INCREMENT=440 DEFAULT CHARSET=latin1 COMMENT='Weekly ROI, Monthly ROI, team bonous, direct referal bonous';
97
98--
99-- Dumping data for table `earnings`
100--
101
102INSERT INTO `earnings` (`earning_id`, `user_id`, `Purchaser_id`, `earning_type`, `ec`, `package_id`, `order_id`, `date`, `time`, `amount`, `comments`) VALUES
103(1, '1', '1', 'type2', 55, '1', 15, '2019-10-03 00:00:00', 1570137779, '8.0000000000', NULL),
104(2, '1', '1', 'type4', 55, '1', 15, '2019-10-03 00:00:00', 1570137779, '100.0000000000', NULL),
105(3, '1', '1', 'type2', 77, '1', 14, '2019-10-03 00:00:00', 1570137779, '800.0000000000', NULL),
106(4, '1', '1', 'type4', 77, '1', 14, '2019-10-03 00:00:00', 1570137779, '10000.0000000000', NULL),
107(5, '1', '1', 'type2', 77, '1', 13, '2019-10-03 00:00:00', 1570137779, '800.0000000000', NULL),
108(6, '1', '1', 'type4', 77, '1', 13, '2019-10-03 00:00:00', 1570137779, '10000.0000000000', NULL),
109(7, '1', '1', 'type2', 55, '1', 12, '2019-10-03 00:00:00', 1570137779, '8.0000000000', NULL),
110(8, '1', '1', 'type4', 55, '1', 12, '2019-10-03 00:00:00', 1570137779, '100.0000000000', NULL),
111(9, '1', '1', 'type2', 55, '1', 11, '2019-10-03 00:00:00', 1570137779, '8.0000000000', NULL),
112(10, '1', '1', 'type4', 55, '1', 11, '2019-10-03 00:00:00', 1570137779, '100.0000000000', NULL),
113(11, '1', '1', 'type2', 55, '1', 10, '2019-10-03 00:00:00', 1570137779, '8.0000000000', NULL),
114(12, '1', '1', 'type4', 55, '1', 10, '2019-10-03 00:00:00', 1570137779, '100.0000000000', NULL),
115(13, '1', '1', 'type2', 22, '1', 9, '2019-10-03 00:00:00', 1570137779, '8.0000000000', NULL),
116(14, '1', '1', 'type4', 22, '1', 9, '2019-10-03 00:00:00', 1570137779, '100.0000000000', NULL),
117(15, '1', '1', 'type2', 55, '1', 8, '2019-10-03 00:00:00', 1570137779, '40.0000000000', NULL),
118(16, '1', '1', 'type4', 55, '1', 8, '2019-10-03 00:00:00', 1570137779, '500.0000000000', NULL),
119(17, '1', '1', 'type2', 55, '1', 7, '2019-10-03 00:00:00', 1570137779, '8.0000000000', NULL),
120(18, '1', '1', 'type4', 55, '1', 7, '2019-10-03 00:00:00', 1570137779, '100.0000000000', NULL),
121(19, '1', '1', 'type2', 22, '1', 6, '2019-10-03 00:00:00', 1570137779, '80.0000000000', NULL),
122(20, '1', '1', 'type4', 22, '1', 6, '2019-10-03 00:00:00', 1570137779, '1000.0000000000', NULL),
123(21, '1', '1', 'type2', 55, '1', 5, '2019-10-03 00:00:00', 1570137779, '8.0000000000', NULL),
124(22, '1', '1', 'type4', 55, '1', 5, '2019-10-03 00:00:00', 1570137779, '100.0000000000', NULL),
125(23, '1', '1', 'type2', 22, '1', 4, '2019-10-03 00:00:00', 1570137779, '0.8000000000', NULL),
126(24, '1', '1', 'type4', 22, '1', 4, '2019-10-03 00:00:00', 1570137779, '10.0000000000', NULL),
127(25, '1', '1', 'type2', 22, '1', 3, '2019-10-03 00:00:00', 1570137779, '0.4000000000', NULL),
128(26, '1', '1', 'type4', 22, '1', 3, '2019-10-03 00:00:00', 1570137779, '5.0000000000', NULL),
129(27, '1', '1', 'type2', 22, '1', 2, '2019-10-03 00:00:00', 1570137779, '800.0000000000', NULL),
130(28, '1', '1', 'type4', 22, '1', 2, '2019-10-03 00:00:00', 1570137779, '10000.0000000000', NULL),
131(29, '1', '1', 'type2', 99, '1', 1, '2019-10-03 00:00:00', 1570137779, '8.0000000000', NULL),
132(30, '1', '1', 'type4', 99, '1', 1, '2019-10-03 00:00:00', 1570137779, '100.0000000000', NULL),
133(31, '1', '1', 'type2', 55, '5', 19, '2019-10-04 00:00:00', 1570224136, '16.9400000000', NULL),
134(32, '1', '1', 'type2', 55, '5', 19, '2019-10-05 00:00:00', 1570313972, '16.9400000000', NULL),
135(33, '1', '1', 'type2', 22, '1', 18, '2019-10-05 00:00:00', 1570313972, '400.0000000000', NULL),
136(34, '1', '1', 'type2', 22, '1', 17, '2019-10-05 00:00:00', 1570313972, '400.0000000000', NULL),
137(35, '1', '1', 'type2', 22, '1', 16, '2019-10-05 00:00:00', 1570313972, '32.0000000000', NULL),
138(36, '1', '1', 'type2', 55, '5', 19, '2019-10-07 00:00:00', 1570453961, '16.9400000000', NULL),
139(37, '1', '1', 'type2', 22, '1', 18, '2019-10-07 00:00:00', 1570453961, '400.0000000000', NULL),
140(38, '1', '1', 'type2', 22, '1', 17, '2019-10-07 00:00:00', 1570453961, '400.0000000000', NULL),
141(39, '1', '1', 'type2', 22, '1', 16, '2019-10-07 00:00:00', 1570453961, '32.0000000000', NULL),
142(40, '1', '1', 'type2', 55, '5', 19, '2019-10-10 00:00:00', 1570701386, '16.9400000000', NULL),
143(41, '1', '1', 'type2', 22, '1', 18, '2019-10-10 00:00:00', 1570701386, '400.0000000000', NULL),
144(42, '1', '1', 'type2', 22, '1', 17, '2019-10-10 00:00:00', 1570701386, '400.0000000000', NULL),
145(43, '1', '1', 'type2', 22, '1', 16, '2019-10-10 00:00:00', 1570701386, '32.0000000000', NULL),
146(44, '1', '1', 'type2', 55, '5', 19, '2019-10-11 00:00:00', 1570785606, '16.9400000000', NULL),
147(45, '1', '1', 'type2', 22, '1', 18, '2019-10-11 00:00:00', 1570785606, '400.0000000000', NULL),
148(46, '1', '1', 'type2', 22, '1', 17, '2019-10-11 00:00:00', 1570785606, '400.0000000000', NULL),
149(47, '1', '1', 'type2', 22, '1', 16, '2019-10-11 00:00:00', 1570785606, '32.0000000000', NULL),
150(48, '1', '1', 'type2', 55, '5', 19, '2019-10-12 00:00:00', 1570917232, '16.9400000000', NULL),
151(49, '1', '1', 'type2', 22, '1', 18, '2019-10-12 00:00:00', 1570917232, '400.0000000000', NULL),
152(50, '1', '1', 'type2', 22, '1', 17, '2019-10-12 00:00:00', 1570917232, '400.0000000000', NULL),
153(51, '1', '1', 'type2', 22, '1', 16, '2019-10-12 00:00:00', 1570917232, '32.0000000000', NULL),
154(52, '1', '1', 'type2', 55, '5', 19, '2019-10-13 00:00:00', 1570924858, '16.9400000000', NULL),
155(53, '1', '1', 'type2', 22, '1', 18, '2019-10-13 00:00:00', 1570924858, '400.0000000000', NULL),
156(54, '1', '1', 'type2', 22, '1', 17, '2019-10-13 00:00:00', 1570924858, '400.0000000000', NULL),
157(55, '1', '1', 'type2', 22, '1', 16, '2019-10-13 00:00:00', 1570924858, '32.0000000000', NULL),
158(56, '1', '1', 'type2', 55, '5', 19, '2019-10-14 00:00:00', 1571048283, '16.9400000000', NULL),
159(57, '1', '1', 'type2', 22, '1', 18, '2019-10-14 00:00:00', 1571048283, '400.0000000000', NULL),
160(58, '1', '1', 'type2', 22, '1', 17, '2019-10-14 00:00:00', 1571048283, '400.0000000000', NULL),
161(59, '1', '1', 'type2', 22, '1', 16, '2019-10-14 00:00:00', 1571048283, '32.0000000000', NULL),
162(60, '1', '1', 'type2', 55, '5', 19, '2019-10-14 10:53:25', 1571093605, '16.9400000000', NULL),
163(61, '1', '1', 'type2', 22, '1', 18, '2019-10-14 10:53:25', 1571093605, '400.0000000000', NULL),
164(62, '1', '1', 'type2', 22, '1', 17, '2019-10-14 10:53:25', 1571093605, '400.0000000000', NULL),
165(63, '1', '1', 'type2', 22, '1', 16, '2019-10-14 10:53:25', 1571093605, '32.0000000000', NULL),
166(64, '1', '1', 'type2', 55, '5', 19, '2019-10-14 10:53:42', 1571093622, '16.9400000000', NULL),
167(65, '1', '1', 'type2', 22, '1', 18, '2019-10-14 10:53:42', 1571093622, '400.0000000000', NULL),
168(66, '1', '1', 'type2', 22, '1', 17, '2019-10-14 10:53:42', 1571093622, '400.0000000000', NULL),
169(67, '1', '1', 'type2', 22, '1', 16, '2019-10-14 10:53:42', 1571093622, '32.0000000000', NULL),
170(68, '1', '1', 'type2', 55, '5', 19, '2019-10-14 10:53:58', 1571093638, '16.9400000000', NULL),
171(69, '1', '1', 'type2', 22, '1', 18, '2019-10-14 10:53:58', 1571093638, '400.0000000000', NULL),
172(70, '1', '1', 'type2', 22, '1', 17, '2019-10-14 10:53:58', 1571093638, '400.0000000000', NULL),
173(71, '1', '1', 'type2', 22, '1', 16, '2019-10-14 10:53:58', 1571093638, '32.0000000000', NULL),
174(72, '1', '1', 'type2', 55, '5', 19, '2019-10-14 10:58:34', 1571093914, '16.9400000000', NULL),
175(73, '1', '1', 'type2', 22, '1', 18, '2019-10-14 10:58:34', 1571093914, '400.0000000000', NULL),
176(74, '1', '1', 'type2', 22, '1', 17, '2019-10-14 10:58:34', 1571093914, '400.0000000000', NULL),
177(75, '1', '1', 'type2', 22, '1', 16, '2019-10-14 10:58:34', 1571093914, '32.0000000000', NULL),
178(76, '1', '1', 'type2', 55, '5', 19, '2019-10-14 10:59:34', 1571093974, '16.9400000000', NULL),
179(77, '1', '1', 'type2', 22, '1', 18, '2019-10-14 10:59:34', 1571093974, '400.0000000000', NULL),
180(78, '1', '1', 'type2', 22, '1', 17, '2019-10-14 10:59:34', 1571093974, '400.0000000000', NULL),
181(79, '1', '1', 'type2', 22, '1', 16, '2019-10-14 10:59:34', 1571093974, '32.0000000000', NULL),
182(80, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:07:10', 1571094430, '16.9400000000', NULL),
183(81, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:07:10', 1571094430, '400.0000000000', NULL),
184(82, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:07:10', 1571094430, '400.0000000000', NULL),
185(83, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:07:10', 1571094430, '32.0000000000', NULL),
186(84, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:07:35', 1571094455, '16.9400000000', NULL),
187(85, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:07:35', 1571094455, '400.0000000000', NULL),
188(86, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:07:35', 1571094455, '400.0000000000', NULL),
189(87, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:07:35', 1571094455, '32.0000000000', NULL),
190(88, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:08:22', 1571094502, '16.9400000000', NULL),
191(89, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:08:22', 1571094502, '400.0000000000', NULL),
192(90, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:08:22', 1571094502, '400.0000000000', NULL),
193(91, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:08:22', 1571094502, '32.0000000000', NULL),
194(92, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:10:07', 1571094607, '16.9400000000', NULL),
195(93, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:10:07', 1571094607, '400.0000000000', NULL),
196(94, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:10:07', 1571094607, '400.0000000000', NULL),
197(95, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:10:07', 1571094607, '32.0000000000', NULL),
198(96, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:14:12', 1571094852, '16.9400000000', NULL),
199(97, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:14:12', 1571094852, '400.0000000000', NULL),
200(98, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:14:12', 1571094852, '400.0000000000', NULL),
201(99, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:14:12', 1571094852, '32.0000000000', NULL),
202(100, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:14:22', 1571094862, '16.9400000000', NULL),
203(101, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:14:22', 1571094862, '400.0000000000', NULL),
204(102, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:14:22', 1571094862, '400.0000000000', NULL),
205(103, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:14:22', 1571094862, '32.0000000000', NULL),
206(104, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:15:03', 1571094903, '16.9400000000', NULL),
207(105, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:15:03', 1571094903, '400.0000000000', NULL),
208(106, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:15:03', 1571094903, '400.0000000000', NULL),
209(107, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:15:03', 1571094903, '32.0000000000', NULL),
210(108, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:15:27', 1571094927, '16.9400000000', NULL),
211(109, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:15:27', 1571094927, '400.0000000000', NULL),
212(110, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:15:27', 1571094927, '400.0000000000', NULL),
213(111, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:15:27', 1571094927, '32.0000000000', NULL),
214(112, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:29:58', 1571095798, '16.9400000000', NULL),
215(113, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:29:58', 1571095798, '400.0000000000', NULL),
216(114, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:29:58', 1571095798, '400.0000000000', NULL),
217(115, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:29:58', 1571095798, '32.0000000000', NULL),
218(116, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:30:33', 1571095833, '16.9400000000', NULL),
219(117, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:30:33', 1571095833, '400.0000000000', NULL),
220(118, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:30:33', 1571095833, '400.0000000000', NULL),
221(119, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:30:33', 1571095833, '32.0000000000', NULL),
222(120, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:30:37', 1571095837, '16.9400000000', NULL),
223(121, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:30:37', 1571095837, '400.0000000000', NULL),
224(122, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:30:37', 1571095837, '400.0000000000', NULL),
225(123, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:30:37', 1571095837, '32.0000000000', NULL),
226(124, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:30:38', 1571095838, '16.9400000000', NULL),
227(125, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:30:38', 1571095838, '400.0000000000', NULL),
228(126, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:30:38', 1571095838, '400.0000000000', NULL),
229(127, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:30:38', 1571095838, '32.0000000000', NULL),
230(128, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:30:41', 1571095841, '16.9400000000', NULL),
231(129, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:30:41', 1571095841, '400.0000000000', NULL),
232(130, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:30:41', 1571095841, '400.0000000000', NULL),
233(131, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:30:41', 1571095841, '32.0000000000', NULL),
234(132, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:30:59', 1571095859, '16.9400000000', NULL),
235(133, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:30:59', 1571095859, '400.0000000000', NULL),
236(134, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:30:59', 1571095859, '400.0000000000', NULL),
237(135, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:30:59', 1571095859, '32.0000000000', NULL),
238(136, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:31:03', 1571095863, '16.9400000000', NULL),
239(137, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:31:03', 1571095863, '400.0000000000', NULL),
240(138, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:31:03', 1571095863, '400.0000000000', NULL),
241(139, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:31:03', 1571095863, '32.0000000000', NULL),
242(140, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:31:11', 1571095871, '16.9400000000', NULL),
243(141, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:31:11', 1571095871, '400.0000000000', NULL),
244(142, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:31:11', 1571095871, '400.0000000000', NULL),
245(143, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:31:11', 1571095871, '32.0000000000', NULL),
246(144, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:31:15', 1571095875, '16.9400000000', NULL),
247(145, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:31:15', 1571095875, '400.0000000000', NULL),
248(146, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:31:15', 1571095875, '400.0000000000', NULL),
249(147, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:31:15', 1571095875, '32.0000000000', NULL),
250(148, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:31:21', 1571095881, '16.9400000000', NULL),
251(149, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:31:21', 1571095881, '400.0000000000', NULL),
252(150, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:31:21', 1571095881, '400.0000000000', NULL),
253(151, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:31:21', 1571095881, '32.0000000000', NULL),
254(152, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:31:22', 1571095882, '16.9400000000', NULL),
255(153, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:31:22', 1571095882, '400.0000000000', NULL),
256(154, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:31:22', 1571095882, '400.0000000000', NULL),
257(155, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:31:22', 1571095882, '32.0000000000', NULL),
258(156, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:31:35', 1571095895, '16.9400000000', NULL),
259(157, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:31:35', 1571095895, '400.0000000000', NULL),
260(158, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:31:35', 1571095895, '400.0000000000', NULL),
261(159, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:31:35', 1571095895, '32.0000000000', NULL),
262(160, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:31:35', 1571095895, '16.9400000000', NULL),
263(161, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:31:39', 1571095899, '16.9400000000', NULL),
264(162, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:31:39', 1571095899, '16.9400000000', NULL),
265(163, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:31:39', 1571095899, '400.0000000000', NULL),
266(164, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:31:39', 1571095899, '400.0000000000', NULL),
267(165, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:31:39', 1571095899, '32.0000000000', NULL),
268(166, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:32:30', 1571095950, '16.9400000000', NULL),
269(167, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:32:30', 1571095950, '16.9400000000', NULL),
270(168, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:32:30', 1571095950, '400.0000000000', NULL),
271(169, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:32:30', 1571095950, '400.0000000000', NULL),
272(170, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:32:30', 1571095950, '32.0000000000', NULL),
273(171, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:33:09', 1571095989, '16.9400000000', NULL),
274(172, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:33:09', 1571095989, '16.9400000000', NULL),
275(173, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:33:09', 1571095989, '400.0000000000', NULL),
276(174, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:33:09', 1571095989, '400.0000000000', NULL),
277(175, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:33:09', 1571095989, '32.0000000000', NULL),
278(176, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:34:26', 1571096066, '16.9400000000', NULL),
279(177, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:34:26', 1571096066, '16.9400000000', NULL),
280(178, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:34:26', 1571096066, '400.0000000000', NULL),
281(179, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:34:26', 1571096066, '400.0000000000', NULL),
282(180, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:34:26', 1571096066, '32.0000000000', NULL),
283(181, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:35:24', 1571096124, '16.9400000000', NULL),
284(182, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:35:24', 1571096124, '16.9400000000', NULL),
285(183, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:35:24', 1571096124, '400.0000000000', NULL),
286(184, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:35:24', 1571096124, '400.0000000000', NULL),
287(185, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:35:24', 1571096124, '32.0000000000', NULL),
288(186, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:35:42', 1571096142, '16.9400000000', NULL),
289(187, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:35:42', 1571096142, '16.9400000000', NULL),
290(188, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:35:42', 1571096142, '400.0000000000', NULL),
291(189, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:35:42', 1571096142, '400.0000000000', NULL),
292(190, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:35:42', 1571096142, '32.0000000000', NULL),
293(191, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:36:05', 1571096165, '16.9400000000', NULL),
294(192, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:36:05', 1571096165, '16.9400000000', NULL),
295(193, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:36:05', 1571096165, '400.0000000000', NULL),
296(194, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:36:05', 1571096165, '400.0000000000', NULL),
297(195, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:36:05', 1571096165, '32.0000000000', NULL),
298(196, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:36:13', 1571096173, '16.9400000000', NULL),
299(197, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:36:13', 1571096173, '16.9400000000', NULL),
300(198, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:36:13', 1571096173, '400.0000000000', NULL),
301(199, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:36:13', 1571096173, '400.0000000000', NULL),
302(200, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:36:13', 1571096173, '32.0000000000', NULL),
303(201, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:37:16', 1571096236, '16.9400000000', NULL),
304(202, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:37:16', 1571096236, '16.9400000000', NULL),
305(203, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:37:16', 1571096236, '400.0000000000', NULL),
306(204, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:37:16', 1571096236, '400.0000000000', NULL),
307(205, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:37:16', 1571096236, '32.0000000000', NULL),
308(206, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:37:27', 1571096247, '16.9400000000', NULL),
309(207, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:37:27', 1571096247, '16.9400000000', NULL),
310(208, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:37:27', 1571096247, '400.0000000000', NULL),
311(209, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:37:27', 1571096247, '400.0000000000', NULL),
312(210, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:37:27', 1571096247, '32.0000000000', NULL),
313(211, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:38:35', 1571096315, '16.9400000000', NULL),
314(212, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:38:35', 1571096315, '16.9400000000', NULL),
315(213, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:38:35', 1571096315, '400.0000000000', NULL),
316(214, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:38:35', 1571096315, '400.0000000000', NULL),
317(215, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:38:35', 1571096315, '32.0000000000', NULL),
318(216, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:49:02', 1571096942, '16.9400000000', NULL),
319(217, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:49:02', 1571096942, '16.9400000000', NULL),
320(218, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:49:02', 1571096942, '400.0000000000', NULL),
321(219, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:49:02', 1571096942, '400.0000000000', NULL),
322(220, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:49:02', 1571096942, '32.0000000000', NULL),
323(221, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:49:04', 1571096944, '16.9400000000', NULL),
324(222, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:49:04', 1571096944, '16.9400000000', NULL),
325(223, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:49:04', 1571096944, '400.0000000000', NULL),
326(224, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:49:04', 1571096944, '400.0000000000', NULL),
327(225, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:49:04', 1571096944, '32.0000000000', NULL),
328(226, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:49:05', 1571096945, '16.9400000000', NULL),
329(227, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:49:05', 1571096945, '16.9400000000', NULL),
330(228, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:49:05', 1571096945, '400.0000000000', NULL),
331(229, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:49:05', 1571096945, '400.0000000000', NULL),
332(230, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:49:05', 1571096945, '32.0000000000', NULL),
333(231, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:49:06', 1571096946, '16.9400000000', NULL),
334(232, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:49:06', 1571096946, '16.9400000000', NULL),
335(233, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:49:06', 1571096946, '400.0000000000', NULL),
336(234, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:49:06', 1571096946, '400.0000000000', NULL),
337(235, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:49:06', 1571096946, '32.0000000000', NULL),
338(236, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:49:18', 1571096958, '16.9400000000', NULL),
339(237, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:49:18', 1571096958, '16.9400000000', NULL),
340(238, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:49:18', 1571096958, '400.0000000000', NULL),
341(239, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:49:18', 1571096958, '400.0000000000', NULL),
342(240, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:49:18', 1571096958, '32.0000000000', NULL),
343(241, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:49:24', 1571096964, '16.9400000000', NULL),
344(242, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:49:24', 1571096964, '16.9400000000', NULL),
345(243, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:49:24', 1571096964, '400.0000000000', NULL),
346(244, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:49:24', 1571096964, '400.0000000000', NULL),
347(245, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:49:24', 1571096964, '32.0000000000', NULL),
348(246, '2', '2', 'type2', 55, '5', 21, '2019-10-14 11:49:25', 1571096965, '16.9400000000', NULL),
349(247, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:49:25', 1571096965, '16.9400000000', NULL),
350(248, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:49:25', 1571096965, '16.9400000000', NULL),
351(249, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:49:25', 1571096965, '400.0000000000', NULL),
352(250, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:49:25', 1571096965, '400.0000000000', NULL),
353(251, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:49:25', 1571096965, '32.0000000000', NULL),
354(252, '2', '2', 'type2', 55, '5', 21, '2019-10-14 11:49:29', 1571096969, '16.9400000000', NULL),
355(253, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:49:29', 1571096969, '16.9400000000', NULL),
356(254, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:49:29', 1571096969, '16.9400000000', NULL),
357(255, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:49:29', 1571096969, '400.0000000000', NULL),
358(256, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:49:29', 1571096969, '400.0000000000', NULL),
359(257, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:49:29', 1571096969, '32.0000000000', NULL),
360(258, '2', '2', 'type2', 55, '5', 21, '2019-10-14 11:52:04', 1571097124, '16.9400000000', NULL),
361(259, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:52:04', 1571097124, '16.9400000000', NULL),
362(260, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:52:04', 1571097124, '16.9400000000', NULL),
363(261, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:52:04', 1571097124, '400.0000000000', NULL),
364(262, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:52:04', 1571097124, '400.0000000000', NULL),
365(263, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:52:04', 1571097124, '32.0000000000', NULL),
366(264, '2', '2', 'type2', 55, '5', 21, '2019-10-14 11:52:07', 1571097127, '16.9400000000', NULL),
367(265, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:52:07', 1571097127, '16.9400000000', NULL),
368(266, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:52:07', 1571097127, '16.9400000000', NULL),
369(267, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:52:07', 1571097127, '400.0000000000', NULL),
370(268, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:52:07', 1571097127, '400.0000000000', NULL),
371(269, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:52:07', 1571097127, '32.0000000000', NULL),
372(270, '2', '2', 'type2', 55, '5', 21, '2019-10-14 11:52:11', 1571097131, '16.9400000000', NULL),
373(271, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:52:11', 1571097131, '16.9400000000', NULL),
374(272, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:52:11', 1571097131, '16.9400000000', NULL),
375(273, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:52:11', 1571097131, '400.0000000000', NULL),
376(274, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:52:11', 1571097131, '400.0000000000', NULL),
377(275, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:52:11', 1571097131, '32.0000000000', NULL),
378(276, '2', '2', 'type2', 55, '5', 21, '2019-10-14 11:52:17', 1571097137, '16.9400000000', NULL),
379(277, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:52:17', 1571097137, '16.9400000000', NULL),
380(278, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:52:17', 1571097137, '16.9400000000', NULL),
381(279, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:52:17', 1571097137, '400.0000000000', NULL),
382(280, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:52:17', 1571097137, '400.0000000000', NULL),
383(281, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:52:17', 1571097137, '32.0000000000', NULL),
384(282, '1', '1', 'type2', 55, '5', 22, '2019-10-14 11:52:17', 1571097137, '16.9400000000', NULL),
385(283, '1', '1', 'type2', 55, '5', 22, '2019-10-14 11:52:20', 1571097140, '16.9400000000', NULL),
386(284, '2', '2', 'type2', 55, '5', 21, '2019-10-14 11:52:20', 1571097140, '16.9400000000', NULL),
387(285, '2', '2', 'type2', 55, '5', 20, '2019-10-14 11:52:20', 1571097140, '16.9400000000', NULL),
388(286, '1', '1', 'type2', 55, '5', 19, '2019-10-14 11:52:20', 1571097140, '16.9400000000', NULL),
389(287, '1', '1', 'type2', 22, '1', 18, '2019-10-14 11:52:20', 1571097140, '400.0000000000', NULL),
390(288, '1', '1', 'type2', 22, '1', 17, '2019-10-14 11:52:20', 1571097140, '400.0000000000', NULL),
391(289, '1', '1', 'type2', 22, '1', 16, '2019-10-14 11:52:20', 1571097140, '32.0000000000', NULL),
392(290, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:00:42', 1571097642, '16.9400000000', NULL),
393(291, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:00:42', 1571097642, '16.9400000000', NULL),
394(292, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:00:42', 1571097642, '16.9400000000', NULL),
395(293, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:00:42', 1571097642, '16.9400000000', NULL),
396(294, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:00:42', 1571097642, '400.0000000000', NULL),
397(295, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:00:42', 1571097642, '400.0000000000', NULL),
398(296, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:00:42', 1571097642, '32.0000000000', NULL),
399(297, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:01:01', 1571097661, '16.9400000000', NULL),
400(298, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:01:01', 1571097661, '16.9400000000', NULL),
401(299, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:01:01', 1571097661, '16.9400000000', NULL),
402(300, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:01:01', 1571097661, '16.9400000000', NULL),
403(301, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:01:01', 1571097661, '400.0000000000', NULL),
404(302, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:01:01', 1571097661, '400.0000000000', NULL),
405(303, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:01:01', 1571097661, '32.0000000000', NULL),
406(304, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:01:49', 1571097709, '16.9400000000', NULL),
407(305, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:01:50', 1571097710, '16.9400000000', NULL),
408(306, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:01:50', 1571097710, '16.9400000000', NULL),
409(307, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:01:50', 1571097710, '16.9400000000', NULL),
410(308, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:01:50', 1571097710, '400.0000000000', NULL),
411(309, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:01:50', 1571097710, '400.0000000000', NULL),
412(310, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:01:50', 1571097710, '32.0000000000', NULL),
413(311, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:02:00', 1571097720, '16.9400000000', NULL),
414(312, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:02:00', 1571097720, '16.9400000000', NULL),
415(313, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:02:00', 1571097720, '16.9400000000', NULL),
416(314, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:02:00', 1571097720, '16.9400000000', NULL),
417(315, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:02:00', 1571097720, '400.0000000000', NULL),
418(316, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:02:00', 1571097720, '400.0000000000', NULL),
419(317, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:02:00', 1571097720, '32.0000000000', NULL),
420(318, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:02:27', 1571097747, '16.9400000000', NULL),
421(319, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:02:27', 1571097747, '16.9400000000', NULL),
422(320, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:02:27', 1571097747, '16.9400000000', NULL),
423(321, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:02:27', 1571097747, '16.9400000000', NULL),
424(322, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:02:27', 1571097747, '400.0000000000', NULL),
425(323, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:02:27', 1571097747, '400.0000000000', NULL),
426(324, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:02:27', 1571097747, '32.0000000000', NULL),
427(325, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:02:28', 1571097748, '16.9400000000', NULL),
428(326, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:02:28', 1571097748, '16.9400000000', NULL),
429(327, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:02:28', 1571097748, '16.9400000000', NULL),
430(328, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:02:29', 1571097749, '16.9400000000', NULL),
431(329, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:02:29', 1571097749, '400.0000000000', NULL),
432(330, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:02:29', 1571097749, '400.0000000000', NULL),
433(331, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:02:29', 1571097749, '32.0000000000', NULL),
434(332, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:02:29', 1571097749, '16.9400000000', NULL),
435(333, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:02:29', 1571097749, '16.9400000000', NULL),
436(334, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:02:29', 1571097749, '16.9400000000', NULL),
437(335, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:02:57', 1571097777, '16.9400000000', NULL),
438(336, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:02:57', 1571097777, '16.9400000000', NULL),
439(337, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:02:57', 1571097777, '16.9400000000', NULL),
440(338, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:02:57', 1571097777, '16.9400000000', NULL),
441(339, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:02:57', 1571097777, '400.0000000000', NULL),
442(340, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:02:57', 1571097777, '400.0000000000', NULL),
443(341, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:02:57', 1571097777, '32.0000000000', NULL),
444(342, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:04:09', 1571097849, '16.9400000000', NULL),
445(343, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:04:09', 1571097849, '16.9400000000', NULL),
446(344, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:04:09', 1571097849, '16.9400000000', NULL),
447(345, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:04:09', 1571097849, '16.9400000000', NULL),
448(346, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:04:09', 1571097849, '400.0000000000', NULL),
449(347, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:04:09', 1571097849, '400.0000000000', NULL),
450(348, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:04:09', 1571097849, '32.0000000000', NULL),
451(349, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:04:27', 1571097867, '16.9400000000', NULL),
452(350, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:04:27', 1571097867, '16.9400000000', NULL),
453(351, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:04:27', 1571097867, '16.9400000000', NULL),
454(352, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:04:27', 1571097867, '16.9400000000', NULL),
455(353, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:04:27', 1571097867, '400.0000000000', NULL),
456(354, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:04:27', 1571097867, '400.0000000000', NULL),
457(355, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:04:27', 1571097867, '32.0000000000', NULL),
458(356, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:04:46', 1571097886, '16.9400000000', NULL),
459(357, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:04:46', 1571097886, '16.9400000000', NULL),
460(358, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:04:46', 1571097886, '16.9400000000', NULL),
461(359, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:04:46', 1571097886, '16.9400000000', NULL),
462(360, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:04:46', 1571097886, '400.0000000000', NULL),
463(361, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:04:46', 1571097886, '400.0000000000', NULL),
464(362, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:04:46', 1571097886, '32.0000000000', NULL),
465(363, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:04:53', 1571097893, '16.9400000000', NULL),
466(364, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:04:53', 1571097893, '16.9400000000', NULL),
467(365, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:04:53', 1571097893, '16.9400000000', NULL),
468(366, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:04:53', 1571097893, '16.9400000000', NULL),
469(367, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:04:53', 1571097893, '400.0000000000', NULL),
470(368, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:04:53', 1571097893, '400.0000000000', NULL),
471(369, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:04:53', 1571097893, '32.0000000000', NULL),
472(370, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:05:34', 1571097934, '16.9400000000', NULL),
473(371, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:05:34', 1571097934, '16.9400000000', NULL),
474(372, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:05:34', 1571097934, '16.9400000000', NULL),
475(373, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:05:34', 1571097934, '16.9400000000', NULL),
476(374, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:05:34', 1571097934, '400.0000000000', NULL),
477(375, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:05:34', 1571097934, '400.0000000000', NULL),
478(376, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:05:34', 1571097934, '32.0000000000', NULL),
479(377, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:05:47', 1571097947, '16.9400000000', NULL),
480(378, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:05:47', 1571097947, '16.9400000000', NULL),
481(379, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:05:47', 1571097947, '16.9400000000', NULL),
482(380, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:05:47', 1571097947, '16.9400000000', NULL),
483(381, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:05:47', 1571097947, '400.0000000000', NULL),
484(382, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:05:47', 1571097947, '400.0000000000', NULL),
485(383, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:05:47', 1571097947, '32.0000000000', NULL),
486(384, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:06:36', 1571097996, '16.9400000000', NULL),
487(385, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:06:36', 1571097996, '16.9400000000', NULL),
488(386, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:06:36', 1571097996, '16.9400000000', NULL),
489(387, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:06:36', 1571097996, '16.9400000000', NULL),
490(388, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:06:36', 1571097996, '400.0000000000', NULL),
491(389, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:06:36', 1571097996, '400.0000000000', NULL),
492(390, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:06:36', 1571097996, '32.0000000000', NULL),
493(391, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:06:52', 1571098012, '16.9400000000', NULL),
494(392, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:06:53', 1571098013, '16.9400000000', NULL),
495(393, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:06:53', 1571098013, '16.9400000000', NULL),
496(394, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:06:53', 1571098013, '16.9400000000', NULL),
497(395, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:06:53', 1571098013, '400.0000000000', NULL),
498(396, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:06:53', 1571098013, '400.0000000000', NULL),
499(397, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:06:53', 1571098013, '32.0000000000', NULL),
500(398, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:11:02', 1571098262, '16.9400000000', NULL),
501(399, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:11:02', 1571098262, '16.9400000000', NULL),
502(400, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:11:02', 1571098262, '16.9400000000', NULL),
503(401, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:11:02', 1571098262, '16.9400000000', NULL),
504(402, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:11:02', 1571098262, '400.0000000000', NULL),
505(403, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:11:02', 1571098262, '400.0000000000', NULL),
506(404, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:11:02', 1571098262, '32.0000000000', NULL),
507(405, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:11:19', 1571098279, '16.9400000000', NULL),
508(406, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:11:19', 1571098279, '16.9400000000', NULL),
509(407, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:11:19', 1571098279, '16.9400000000', NULL),
510(408, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:11:19', 1571098279, '16.9400000000', NULL),
511(409, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:11:19', 1571098279, '400.0000000000', NULL),
512(410, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:11:19', 1571098279, '400.0000000000', NULL),
513(411, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:11:19', 1571098279, '32.0000000000', NULL),
514(412, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:12:07', 1571098327, '16.9400000000', NULL),
515(413, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:12:07', 1571098327, '16.9400000000', NULL),
516(414, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:12:07', 1571098327, '16.9400000000', NULL),
517(415, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:12:07', 1571098327, '16.9400000000', NULL),
518(416, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:12:07', 1571098327, '400.0000000000', NULL),
519(417, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:12:07', 1571098327, '400.0000000000', NULL),
520(418, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:12:07', 1571098327, '32.0000000000', NULL),
521(419, '1', '1', 'type2', 55, '5', 22, '2019-10-15 12:12:35', 1571098355, '16.9400000000', NULL),
522(420, '2', '2', 'type2', 55, '5', 21, '2019-10-15 12:12:35', 1571098355, '16.9400000000', NULL),
523(421, '2', '2', 'type2', 55, '5', 20, '2019-10-15 12:12:35', 1571098355, '16.9400000000', NULL),
524(422, '1', '1', 'type2', 55, '5', 19, '2019-10-15 12:12:35', 1571098355, '16.9400000000', NULL),
525(423, '1', '1', 'type2', 22, '1', 18, '2019-10-15 12:12:35', 1571098355, '400.0000000000', NULL),
526(424, '1', '1', 'type2', 22, '1', 17, '2019-10-15 12:12:35', 1571098355, '400.0000000000', NULL),
527(425, '1', '1', 'type2', 22, '1', 16, '2019-10-15 12:12:35', 1571098355, '32.0000000000', NULL),
528(426, '1', '1', 'type2', 55, '5', 22, '2019-10-15 06:35:37', 1571121337, '16.9400000000', NULL),
529(427, '2', '2', 'type2', 55, '5', 21, '2019-10-15 06:35:37', 1571121337, '16.9400000000', NULL),
530(428, '2', '2', 'type2', 55, '5', 20, '2019-10-15 06:35:37', 1571121337, '16.9400000000', NULL),
531(429, '1', '1', 'type2', 55, '5', 19, '2019-10-15 06:35:37', 1571121337, '16.9400000000', NULL),
532(430, '1', '1', 'type2', 22, '1', 18, '2019-10-15 06:35:37', 1571121337, '400.0000000000', NULL),
533(431, '1', '1', 'type2', 22, '1', 17, '2019-10-15 06:35:37', 1571121337, '400.0000000000', NULL),
534(432, '1', '1', 'type2', 22, '1', 16, '2019-10-15 06:35:37', 1571121337, '32.0000000000', NULL),
535(433, '1', '1', 'type2', 55, '5', 22, '2019-10-15 06:36:04', 1571121364, '16.9400000000', NULL),
536(434, '2', '2', 'type2', 55, '5', 21, '2019-10-15 06:36:04', 1571121364, '16.9400000000', NULL),
537(435, '2', '2', 'type2', 55, '5', 20, '2019-10-15 06:36:04', 1571121364, '16.9400000000', NULL),
538(436, '1', '1', 'type2', 55, '5', 19, '2019-10-15 06:36:04', 1571121364, '16.9400000000', NULL),
539(437, '1', '1', 'type2', 22, '1', 18, '2019-10-15 06:36:04', 1571121364, '400.0000000000', NULL),
540(438, '1', '1', 'type2', 22, '1', 17, '2019-10-15 06:36:04', 1571121364, '400.0000000000', NULL),
541(439, '1', '1', 'type2', 22, '1', 16, '2019-10-15 06:36:04', 1571121364, '32.0000000000', NULL);
542
543-- --------------------------------------------------------
544
545--
546-- Table structure for table `investment`
547--
548
549CREATE TABLE IF NOT EXISTS `investment` (
550 `order_id` int(11) NOT NULL,
551 `user_id` varchar(255) NOT NULL,
552 `sponsor_id` varchar(255) NOT NULL,
553 `package_id` int(11) NOT NULL,
554 `ec` int(22) NOT NULL,
555 `amount` float(22,10) NOT NULL DEFAULT '0.0000000000',
556 `invest_date` datetime DEFAULT NULL,
557 `date` int(22) DEFAULT NULL,
558 `active` int(22) DEFAULT '1' COMMENT '1 = active; 2 = stopped',
559 `day` int(11) NOT NULL,
560 `next` datetime DEFAULT NULL,
561 `end` datetime DEFAULT NULL
562) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
563
564--
565-- Dumping data for table `investment`
566--
567
568INSERT INTO `investment` (`order_id`, `user_id`, `sponsor_id`, `package_id`, `ec`, `amount`, `invest_date`, `date`, `active`, `day`, `next`, `end`) VALUES
569(1, '1', '0', 1, 99, 100.0000000000, '2019-10-01 00:00:00', 1569971276, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
570(2, '1', '0', 1, 22, 10000.0000000000, '2019-10-01 00:00:00', 1489461258, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
571(3, '1', '0', 1, 22, 5.0000000000, '2019-10-01 00:00:00', 1569972294, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
572(4, '1', '0', 1, 22, 10.0000000000, '2019-10-01 00:00:00', 1569972618, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
573(5, '1', '0', 1, 55, 100.0000000000, '2019-10-01 00:00:00', 1569972622, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
574(6, '1', '0', 1, 22, 1000.0000000000, '2019-10-01 00:00:00', 1569973469, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
575(7, '1', '0', 1, 55, 100.0000000000, '2019-10-01 00:00:00', 1569973477, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
576(8, '1', '0', 1, 55, 500.0000000000, '2019-10-02 00:00:00', 1569979335, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
577(9, '1', '0', 1, 22, 100.0000000000, '2019-10-02 00:00:00', 1569979690, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
578(10, '1', '0', 1, 55, 100.0000000000, '2019-10-02 00:00:00', 1569980516, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
579(11, '1', '0', 1, 55, 100.0000000000, '2019-10-02 00:00:00', 1569980620, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
580(12, '1', '0', 1, 55, 100.0000000000, '2019-10-02 00:00:00', 1569980658, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
581(13, '1', '0', 1, 77, 10000.0000000000, '2019-10-02 00:00:00', 1569980773, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
582(14, '1', '0', 1, 77, 10000.0000000000, '2019-10-02 00:00:00', 1569980985, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
583(15, '1', '0', 1, 55, 100.0000000000, '2019-10-02 00:00:00', 1569981075, 2, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
584(16, '1', '', 1, 22, 400.0000000000, '2019-10-03 11:39:12', 1570139532, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
585(17, '1', '', 1, 22, 5000.0000000000, '2019-10-04 10:42:41', 1570185761, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
586(18, '1', '', 1, 22, 5000.0000000000, '2019-10-04 11:45:21', 1570108458, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
587(19, '1', '', 5, 55, 22.0000000000, '2019-10-14 17:24:06', 1570108458, 1, 5, '2019-10-14 12:24:06', '0000-00-00 00:00:00'),
588(20, '2', '', 5, 55, 22.0000000000, '2019-10-14 11:31:35', 1571095895, 1, 5, NULL, '0000-00-00 00:00:00'),
589(21, '2', '', 5, 55, 22.0000000000, '2019-10-14 11:49:24', 1571096964, 1, 5, NULL, '0000-00-00 00:00:00'),
590(22, '1', '', 5, 55, 22.0000000000, '2019-10-14 11:52:17', 1571097137, 1, 5, NULL, '2019-10-15 04:52:17');
591
592-- --------------------------------------------------------
593
594--
595-- Table structure for table `transactions`
596--
597
598CREATE TABLE IF NOT EXISTS `transactions` (
599 `transaction_id` int(11) NOT NULL,
600 `user_id` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
601 `transaction_category` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
602 `releted_id` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
603 `amount` decimal(22,10) DEFAULT '0.0000000000',
604 `ec` int(22) NOT NULL,
605 `transaction_date_timestamp` timestamp NULL DEFAULT NULL,
606 `comments` tinytext CHARACTER SET latin1,
607 `tx_desc` text NOT NULL,
608 `tx_time` int(22) NOT NULL,
609 `status` int(11) NOT NULL DEFAULT '1'
610) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8 COMMENT='earnings,wthdraw,transfer and investment data all togther wi';
611
612--
613-- Dumping data for table `transactions`
614--
615
616INSERT INTO `transactions` (`transaction_id`, `user_id`, `transaction_category`, `releted_id`, `amount`, `ec`, `transaction_date_timestamp`, `comments`, `tx_desc`, `tx_time`, `status`) VALUES
617(1, '1', 'deposit', '9', '100.0000000000', 99, '2019-10-01 10:07:56', NULL, 'Added funds to account from Bitcoin Cash & Transaction Reference = N/A', 1569971276, 1),
618(2, '1', 'investment', '1', '100.0000000000', 99, '2019-10-01 10:07:56', NULL, 'Purchased - BASIC PLAN - investment ', 1569971276, 1),
619(3, '1', 'deposit', '8', '10000.0000000000', 22, '2019-10-01 10:08:13', NULL, 'Added funds to account from Bitcoin & Transaction Reference = N/A', 1569971293, 1),
620(4, '1', 'investment', '2', '10000.0000000000', 22, '2019-10-01 10:08:13', NULL, 'Purchased - BASIC PLAN - investment ', 1569971293, 1),
621(5, '1', 'deposit', '7', '5.0000000000', 22, '2019-10-01 10:24:54', NULL, 'Added funds to account from Bitcoin & Transaction Reference = N/A', 1569972294, 1),
622(6, '1', 'investment', '3', '5.0000000000', 22, '2019-10-01 10:24:54', NULL, 'Purchased - BASIC PLAN - investment ', 1569972294, 1),
623(7, '1', 'deposit', '11', '10.0000000000', 22, '2019-10-01 10:30:18', NULL, 'Added funds to account from Bitcoin & Transaction Reference = N/A', 1569972618, 1),
624(8, '1', 'investment', '4', '10.0000000000', 22, '2019-10-01 10:30:18', NULL, 'Purchased - BASIC PLAN - investment ', 1569972618, 1),
625(9, '1', 'deposit', '10', '100.0000000000', 55, '2019-10-01 10:30:22', NULL, 'Added funds to account from Perfect Money & Transaction Reference = N/A', 1569972622, 1),
626(10, '1', 'investment', '5', '100.0000000000', 55, '2019-10-01 10:30:22', NULL, 'Purchased - BASIC PLAN - investment ', 1569972622, 1),
627(11, '1', 'deposit', '13', '1000.0000000000', 22, '2019-10-01 10:44:29', NULL, 'Added funds to account from Bitcoin & Transaction Reference = N/A', 1569973469, 1),
628(12, '1', 'investment', '6', '1000.0000000000', 22, '2019-10-01 10:44:29', NULL, 'Purchased - BASIC PLAN - investment ', 1569973469, 1),
629(13, '1', 'deposit', '12', '100.0000000000', 55, '2019-10-01 10:44:37', NULL, 'Added funds to account from Perfect Money & Transaction Reference = N/A', 1569973477, 1),
630(14, '1', 'investment', '7', '100.0000000000', 55, '2019-10-01 10:44:37', NULL, 'Purchased - BASIC PLAN - investment ', 1569973477, 1),
631(15, '1', 'deposit', '15', '500.0000000000', 55, '2019-10-02 00:22:15', NULL, 'Added funds to account from Perfect Money & Transaction Reference = N/A', 1569979335, 1),
632(16, '1', 'investment', '8', '500.0000000000', 55, '2019-10-02 00:22:15', NULL, 'Purchased - BASIC PLAN - investment ', 1569979335, 1),
633(17, '1', 'deposit', '14', '100.0000000000', 22, '2019-10-02 00:28:10', NULL, 'Added funds to account from Bitcoin & Transaction Reference = N/A', 1569979690, 1),
634(18, '1', 'investment', '9', '100.0000000000', 22, '2019-10-02 00:28:10', NULL, 'Purchased - BASIC PLAN - investment ', 1569979690, 1),
635(19, '1', 'deposit', '17', '100.0000000000', 55, '2019-10-02 00:41:56', NULL, 'Added funds to account from Perfect Money & Transaction Reference = N/A', 1569980516, 1),
636(20, '1', 'investment', '10', '100.0000000000', 55, '2019-10-02 00:41:56', NULL, 'Purchased - BASIC PLAN - investment ', 1569980516, 1),
637(21, '1', 'deposit', '18', '100.0000000000', 55, '2019-10-02 00:43:40', NULL, 'Added funds to account from Perfect Money & Transaction Reference = N/A', 1569980620, 1),
638(22, '1', 'investment', '11', '100.0000000000', 55, '2019-10-02 00:43:40', NULL, 'Purchased - BASIC PLAN - investment ', 1569980620, 1),
639(23, '1', 'deposit', '16', '100.0000000000', 55, '2019-10-02 00:44:18', NULL, 'Added funds to account from Perfect Money & Transaction Reference = N/A', 1569980658, 1),
640(24, '1', 'investment', '12', '100.0000000000', 55, '2019-10-02 00:44:18', NULL, 'Purchased - BASIC PLAN - investment ', 1569980658, 1),
641(25, '1', 'deposit', '20', '10000.0000000000', 77, '2019-10-02 00:46:13', NULL, 'Added funds to account from Payeer & Transaction Reference = N/A', 1569980773, 1),
642(26, '1', 'investment', '13', '10000.0000000000', 77, '2019-10-02 00:46:13', NULL, 'Purchased - BASIC PLAN - investment ', 1569980773, 1),
643(27, '1', 'deposit', '21', '10000.0000000000', 77, '2019-10-02 00:49:45', NULL, 'Added funds to account from Payeer & Transaction Reference = N/A', 1569980985, 1),
644(28, '1', 'investment', '14', '10000.0000000000', 77, '2019-10-02 00:49:45', NULL, 'Purchased - BASIC PLAN - investment ', 1569980985, 1),
645(29, '1', 'deposit', '22', '100.0000000000', 55, '2019-10-02 00:51:15', NULL, 'Added funds to account from Perfect Money & Transaction Reference = N/A', 1569981075, 1),
646(30, '1', 'investment', '15', '100.0000000000', 55, '2019-10-02 00:51:15', NULL, 'Purchased - BASIC PLAN - investment ', 1569981075, 1),
647(31, '1', 'deposit', '27', '50000.0000000000', 22, '2019-10-02 01:27:38', 'admin bonus', 'Admin added funds to account from Bitcoin & Transaction Reference = NULL', 1569983258, 1),
648(32, '1', 'deposit', '28', '50000.0000000000', 55, '2019-10-02 01:29:04', 'admin bonus', 'Admin added funds to account from Perfect Money & Transaction Reference = NULL', 1569983344, 1),
649(41, '1', 'withdraw', '12', '500.0000000000', 22, '2019-10-02 02:43:50', NULL, 'Funds Withdrawal Request - Amount: $500.00', 1569987830, 1),
650(42, '1', 'earnings', '15', '8.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $100 - 8 % 8', 1570137779, 1),
651(43, '1', 'return', '15', '100.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $100 returned to account', 1570137779, 1),
652(44, '1', 'earnings', '14', '800.0000000000', 77, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $10,000 - 8 % 800', 1570137779, 1),
653(45, '1', 'return', '14', '10000.0000000000', 77, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $10,000 returned to account', 1570137779, 1),
654(46, '1', 'earnings', '13', '800.0000000000', 77, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $10,000 - 8 % 800', 1570137779, 1),
655(47, '1', 'return', '13', '10000.0000000000', 77, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $10,000 returned to account', 1570137779, 1),
656(48, '1', 'earnings', '12', '8.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $100 - 8 % 8', 1570137779, 1),
657(49, '1', 'return', '12', '100.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $100 returned to account', 1570137779, 1),
658(50, '1', 'earnings', '11', '8.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $100 - 8 % 8', 1570137779, 1),
659(51, '1', 'return', '11', '100.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $100 returned to account', 1570137779, 1),
660(52, '1', 'earnings', '10', '8.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $100 - 8 % 8', 1570137779, 1),
661(53, '1', 'return', '10', '100.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $100 returned to account', 1570137779, 1),
662(54, '1', 'earnings', '9', '8.0000000000', 22, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $100 - 8 % 8', 1570137779, 1),
663(55, '1', 'return', '9', '100.0000000000', 22, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $100 returned to account', 1570137779, 1),
664(56, '1', 'earnings', '8', '40.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $500 - 8 % 40', 1570137779, 1),
665(57, '1', 'return', '8', '500.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $500 returned to account', 1570137779, 1),
666(58, '1', 'earnings', '7', '8.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $100 - 8 % 8', 1570137779, 1),
667(59, '1', 'return', '7', '100.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $100 returned to account', 1570137779, 1),
668(60, '1', 'earnings', '6', '80.0000000000', 22, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $1,000 - 8 % 80', 1570137779, 1),
669(61, '1', 'return', '6', '1000.0000000000', 22, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $1,000 returned to account', 1570137779, 1),
670(62, '1', 'earnings', '5', '8.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $100 - 8 % 8', 1570137779, 1),
671(63, '1', 'return', '5', '100.0000000000', 55, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $100 returned to account', 1570137779, 1),
672(64, '1', 'earnings', '4', '0.8000000000', 22, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $10 - 8 % 0.8', 1570137779, 1),
673(65, '1', 'return', '4', '10.0000000000', 22, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $10 returned to account', 1570137779, 1),
674(66, '1', 'earnings', '3', '0.4000000000', 22, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $5 - 8 % 0.4', 1570137779, 1),
675(67, '1', 'return', '3', '5.0000000000', 22, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $5 returned to account', 1570137779, 1),
676(68, '1', 'earnings', '2', '800.0000000000', 22, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $10,000 - 8 % 800', 1570137779, 1),
677(69, '1', 'return', '2', '10000.0000000000', 22, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $10,000 returned to account', 1570137779, 1),
678(70, '1', 'earnings', '1', '8.0000000000', 99, '2019-10-03 08:22:59', 'earnings', 'Earning from deposit $100 - 8 % 8', 1570137779, 1),
679(71, '1', 'return', '1', '100.0000000000', 99, '2019-10-03 08:22:59', 'earnings', 'Principal deposit $100 returned to account', 1570137779, 1),
680(72, '1', 'deposit', '29', '400.0000000000', 22, '2019-10-03 08:52:12', 'admin bonus', 'Admin added funds to account from Bitcoin & Transaction Reference = NULL', 1570139532, 1),
681(73, '1', 'investment', '16', '400.0000000000', 22, '2019-10-03 08:52:12', NULL, 'Admin created purchase - BASIC PLAN - investment ', 1570139532, 1),
682(74, '1', 'deposit', '30', '5000.0000000000', 55, '2019-10-03 09:24:36', 'admin bonus', 'Admin added funds to account from Perfect Money & Transaction Reference = NULL', 1570141476, 1),
683(75, '1', 'deposit', '31', '5000.0000000000', 22, '2019-10-04 09:42:41', 'admin bonus', 'Admin added funds to account from Bitcoin & Transaction Reference = NULL', 1570185761, 1),
684(76, '1', 'investment', '17', '5000.0000000000', 22, '2019-10-04 09:42:41', NULL, 'Admin created purchase - BASIC PLAN - investment ', 1570185761, 1),
685(77, '1', 'deposit', '32', '5000.0000000000', 22, '2019-10-04 10:45:21', 'admin bonus', 'Admin added funds to account from Bitcoin & Transaction Reference = NULL', 1570189521, 1),
686(78, '1', 'investment', '18', '5000.0000000000', 22, '2019-10-04 10:45:21', NULL, 'Admin created purchase - BASIC PLAN - investment ', 1570189521, 1),
687(79, '1', 'deposit', '33', '22.0000000000', 55, '2019-10-04 10:46:29', 'admin bonus', 'Admin added funds to account from Perfect Money & Transaction Reference = NULL', 1570189589, 1),
688(80, '1', 'deposit', '34', '22.0000000000', 55, '2019-10-04 10:49:06', 'admin bonus', 'Admin added funds to account from Perfect Money & Transaction Reference = NULL', 1570189746, 1),
689(81, '1', 'investment', '19', '22.0000000000', 55, '2019-10-04 10:49:06', NULL, 'Admin created purchase - Hourly Plans - investment ', 1570189746, 1),
690(82, '2', 'deposit', '35', '22.0000000000', 55, '2019-10-14 10:31:35', 'admin bonus', 'Admin added funds to account from Perfect Money & Transaction Reference = NULL', 1571095895, 1),
691(83, '2', 'investment', '20', '22.0000000000', 55, '2019-10-14 10:31:35', NULL, 'Admin created purchase - Hourly Plans - investment ', 1571095895, 1),
692(84, '2', 'deposit', '36', '22.0000000000', 55, '2019-10-14 10:49:24', 'admin bonus', 'Admin added funds to account from Perfect Money & Transaction Reference = NULL', 1571096964, 1),
693(85, '2', 'investment', '21', '22.0000000000', 55, '2019-10-14 10:49:24', NULL, 'Admin created purchase - Hourly Plans - investment ', 1571096964, 1),
694(86, '1', 'deposit', '37', '22.0000000000', 55, '2019-10-14 10:52:17', 'admin bonus', 'Admin added funds to account from Perfect Money & Transaction Reference = NULL', 1571097137, 1),
695(87, '1', 'investment', '22', '22.0000000000', 55, '2019-10-14 10:52:17', NULL, 'Admin created purchase - Hourly Plans - investment ', 1571097137, 1);
696
697--
698-- Indexes for dumped tables
699--
700
701--
702-- Indexes for table `deposit`
703--
704ALTER TABLE `deposit`
705 ADD PRIMARY KEY (`deposit_id`);
706
707--
708-- Indexes for table `earnings`
709--
710ALTER TABLE `earnings`
711 ADD PRIMARY KEY (`earning_id`);
712
713--
714-- Indexes for table `investment`
715--
716ALTER TABLE `investment`
717 ADD PRIMARY KEY (`order_id`),
718 ADD UNIQUE KEY `idinvestment_UNIQUE` (`order_id`);
719
720--
721-- Indexes for table `transactions`
722--
723ALTER TABLE `transactions`
724 ADD PRIMARY KEY (`transaction_id`);
725
726--
727-- AUTO_INCREMENT for dumped tables
728--
729
730--
731-- AUTO_INCREMENT for table `deposit`
732--
733ALTER TABLE `deposit`
734 MODIFY `deposit_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=38;
735--
736-- AUTO_INCREMENT for table `earnings`
737--
738ALTER TABLE `earnings`
739 MODIFY `earning_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=440;
740--
741-- AUTO_INCREMENT for table `investment`
742--
743ALTER TABLE `investment`
744 MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
745--
746-- AUTO_INCREMENT for table `transactions`
747--
748ALTER TABLE `transactions`
749 MODIFY `transaction_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=88;
750/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
751/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
752/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;