· 8 years ago · Jul 12, 2018, 03:30 PM
1-- Adminer 4.3.1 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `tracking`;
9CREATE TABLE `tracking` (
10 `Lng` float NOT NULL,
11 `Lat` float NOT NULL,
12 `Date` datetime NOT NULL,
13 `armed` varchar(10) COLLATE utf8_bin NOT NULL,
14 `Id` int(11) NOT NULL AUTO_INCREMENT,
15 PRIMARY KEY (`Id`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
17
18INSERT INTO `tracking` (`Lng`, `Lat`, `Date`, `armed`, `Id`) VALUES
19(82.9662, 54.8625, '2018-03-02 10:12:22', 'false', 2723),
20(82.9661, 54.8625, '2018-03-02 10:15:00', 'false', 2724),
21(82.9661, 54.8625, '2018-03-02 10:15:14', 'false', 2725),
22(82.9661, 54.8625, '2018-03-02 10:15:29', 'false', 2726),
23(82.9661, 54.8625, '2018-03-02 10:15:45', 'false', 2727),
24(82.9661, 54.8625, '2018-03-02 10:15:59', 'false', 2728),
25(82.9661, 54.8625, '2018-03-02 10:16:14', 'false', 2729),
26(82.9661, 54.8625, '2018-03-02 10:16:29', 'false', 2730),
27(82.9661, 54.8625, '2018-03-02 10:16:44', 'false', 2731),
28(82.9661, 54.8625, '2018-03-02 10:16:59', 'false', 2732),
29(82.9661, 54.8625, '2018-03-02 10:17:15', 'false', 2733),
30(82.9661, 54.8625, '2018-03-02 10:17:29', 'false', 2734),
31(82.9661, 54.8625, '2018-03-02 10:17:44', 'false', 2735),
32(82.9661, 54.8625, '2018-03-02 10:18:09', 'false', 2736),
33(82.9661, 54.8625, '2018-03-02 10:18:15', 'false', 2737),
34(82.9661, 54.8625, '2018-03-02 10:18:30', 'false', 2738),
35(82.9661, 54.8625, '2018-03-02 10:18:45', 'false', 2739),
36(82.9661, 54.8625, '2018-03-02 10:18:59', 'false', 2740),
37(82.9661, 54.8625, '2018-03-02 10:19:15', 'false', 2741),
38(82.9661, 54.8625, '2018-03-02 10:19:29', 'false', 2742),
39(82.9661, 54.8625, '2018-03-02 10:19:45', 'false', 2743),
40(82.9661, 54.8625, '2018-03-02 10:20:00', 'false', 2744),
41(82.9661, 54.8625, '2018-03-02 10:20:15', 'false', 2745),
42(82.9661, 54.8625, '2018-03-02 10:20:30', 'false', 2746),
43(82.9661, 54.8625, '2018-03-02 10:20:45', 'false', 2747),
44(82.9661, 54.8625, '2018-03-02 10:21:00', 'false', 2748),
45(82.9661, 54.8625, '2018-03-02 10:21:15', 'false', 2749),
46(82.9661, 54.8625, '2018-03-02 10:21:30', 'false', 2750),
47(82.9661, 54.8625, '2018-03-02 10:22:21', 'false', 2751),
48(82.9661, 54.8625, '2018-03-02 10:22:35', 'false', 2752),
49(82.9661, 54.8625, '2018-03-02 10:22:50', 'false', 2753),
50(82.9661, 54.8625, '2018-03-02 10:23:05', 'false', 2754),
51(82.9661, 54.8625, '2018-03-02 10:23:20', 'false', 2755),
52(82.9661, 54.8625, '2018-03-02 10:23:35', 'false', 2756),
53(82.9661, 54.8625, '2018-03-02 10:23:50', 'false', 2757),
54(82.9661, 54.8625, '2018-03-02 10:24:05', 'false', 2758),
55(82.9661, 54.8625, '2018-03-02 10:24:20', 'false', 2759),
56(82.9661, 54.8625, '2018-03-02 10:24:35', 'false', 2760),
57(82.9661, 54.8625, '2018-03-02 10:24:50', 'false', 2761),
58(82.9661, 54.8625, '2018-03-02 10:25:05', 'false', 2762),
59(82.9661, 54.8625, '2018-03-02 10:25:20', 'false', 2763),
60(82.9661, 54.8625, '2018-03-02 10:25:35', 'false', 2764),
61(82.9661, 54.8625, '2018-03-02 10:25:50', 'false', 2765),
62(82.9661, 54.8625, '2018-03-02 10:26:05', 'false', 2766),
63(82.9661, 54.8625, '2018-03-02 10:26:21', 'false', 2767),
64(82.9661, 54.8625, '2018-03-02 10:26:36', 'false', 2768),
65(82.9661, 54.8625, '2018-03-02 10:26:52', 'false', 2769),
66(82.9809, 54.8553, '2018-03-02 12:02:07', 'false', 2770),
67(82.9812, 54.8549, '2018-03-02 12:02:22', 'false', 2771),
68(82.9812, 54.8531, '2018-03-02 12:02:38', 'false', 2772),
69(82.9834, 54.8518, '2018-03-02 12:02:52', 'false', 2773),
70(82.9866, 54.851, '2018-03-02 12:03:07', 'false', 2774),
71(82.9888, 54.8496, '2018-03-02 12:03:23', 'false', 2775),
72(82.9912, 54.8482, '2018-03-02 12:03:36', 'false', 2776),
73(82.9935, 54.8469, '2018-03-02 12:03:53', 'false', 2777),
74(82.9959, 54.8457, '2018-03-02 12:04:07', 'false', 2778),
75(82.9984, 54.8445, '2018-03-02 12:04:22', 'false', 2779),
76(83.0012, 54.8433, '2018-03-02 12:04:37', 'false', 2780),
77(83.004, 54.8424, '2018-03-02 12:04:52', 'false', 2781),
78(83.0071, 54.8416, '2018-03-02 12:05:07', 'false', 2782),
79(83.0105, 54.8412, '2018-03-02 12:05:22', 'false', 2783),
80(83.0137, 54.841, '2018-03-02 12:05:37', 'false', 2784),
81(83.0167, 54.8411, '2018-03-02 12:05:53', 'false', 2785),
82(83.0199, 54.8414, '2018-03-02 12:06:07', 'false', 2786),
83(83.0229, 54.8415, '2018-03-02 12:06:22', 'false', 2787),
84(83.026, 54.8417, '2018-03-02 12:06:40', 'false', 2788),
85(83.0323, 54.8421, '2018-03-02 12:07:07', 'false', 2789),
86(83.0351, 54.8424, '2018-03-02 12:07:25', 'false', 2790),
87(83.0362, 54.8436, '2018-03-02 12:07:37', 'false', 2791),
88(83.0359, 54.8446, '2018-03-02 12:07:52', 'false', 2792),
89(83.0367, 54.8451, '2018-03-02 12:08:07', 'false', 2793),
90(83.0363, 54.8466, '2018-03-02 12:08:22', 'false', 2794),
91(83.036, 54.8479, '2018-03-02 12:08:37', 'false', 2795),
92(83.0376, 54.8485, '2018-03-02 12:08:55', 'false', 2796),
93(83.0393, 54.8489, '2018-03-02 12:09:08', 'false', 2797),
94(83.0403, 54.8486, '2018-03-02 12:09:22', 'false', 2798),
95(83.041, 54.8472, '2018-03-02 12:09:42', 'false', 2799),
96(83.0417, 54.8456, '2018-03-02 12:09:53', 'false', 2800),
97(54.1222, 80.1112, '2018-07-12 22:14:56', 'false', 2801),
98(54.1222, 54.1112, '2018-07-12 22:18:46', 'false', 2802);
99
100-- 2018-07-12 15:26:26