This repository has been archived by the owner on Jul 13, 2024. It is now read-only.
forked from rayfarias56/minrva-estimote-server
-
Notifications
You must be signed in to change notification settings - Fork 0
/
initialize_data.sql
65 lines (60 loc) · 4.47 KB
/
initialize_data.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
INSERT INTO users (username, password) VALUES
("minrva-wayfinder", "sha1:64000:18:LMfnyTpCd2vIY8FiS6zUuDjB6Rv92x+2:tt1svxJ00ABf78l81iFLbceF");
SET @uuid = "b9407f30-f5f8-466e-aff9-25556b57fe6d", @color = "blueberry";
INSERT INTO beacons (uuid, major, minor, x, y, z, description) VALUES
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 7702, 3760, 6, 9, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 11050, 38665, 5, 3, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 13010, 39738, 2, 2, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 13796, 61719, 1, 4, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 25108, 62750, 2, 3, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 26610, 9252, 7, 1, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 27474, 11444, 3, 2, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 28382, 9286, 4, 7, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 29403, 39034, 6, 8, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 32367, 12044, 6, 3, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 32380, 48923, 2, 7, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 40056, 28904, 7, 2, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 43286, 22687, 5, 7, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 47997, 21952, 1, 1, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 48337, 56555, 5, 6, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 63544, 26162, 5, 9, 0, @color);
SET @uuid = "b9407f30-f5f8-466e-aff9-25556b57fe6d", @color = "ice";
INSERT INTO beacons (uuid, major, minor, x, y, z, description) VALUES
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 6137, 18047, 5, 1, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 7639, 41966, 1, 3, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 12829, 8803, 2, 1, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 14481, 65459, 1, 7, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 14774, 31826, 1, 5, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 20796, 53124, 6, 6, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 24416, 18745, 3, 8, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 29472, 24136, 6, 2, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 30361, 13334, 0, 5, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 34959, 19644, 6, 4, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 38495, 57964, 1, 8, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 39247, 61002, 7, 3, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 47448, 7663, 6, 7, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 49702, 24264, 4, 2, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 54514, 7644, 5, 2, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 55809, 65302, 5, 8, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 58253, 1071, 3, 9, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 63145, 5680, 3, 7, 0, @color);
SET @uuid = "b9407f30-f5f8-466e-aff9-25556b57fe6d", @color = "mint";
INSERT INTO beacons (uuid, major, minor, x, y, z, description) VALUES
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 1417, 33903, 3, 3, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 2876, 53837, 5, 5, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 5017, 48174, 1, 9, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 11224, 10643, 4, 3, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 21733, 54978, 2, 8, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 22900, 32356, 7, 9, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 24494, 32441, 6, 5, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 28904, 56891, 6, 1, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 29021, 25571, 3, 1, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 30816, 41832, 7, 8, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 35677, 36394, 4, 9, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 37946, 36488, 4, 1, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 46896, 52218, 2, 9, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 54206, 19453, 1, 6, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 58691, 24320, 7, 7, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 58808, 20974, 5, 4, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 60183, 20478, 1, 2, 0, @color),
("b9407f30-f5f8-466e-aff9-25556b57fe6d", 60547, 13362, 4, 8, 0, @color);