-
Notifications
You must be signed in to change notification settings - Fork 0
/
localizacaoindoor.sql
219 lines (191 loc) · 46.7 KB
/
localizacaoindoor.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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Aug 15, 2013 at 02:42 PM
-- Server version: 5.5.27
-- PHP Version: 5.4.7
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 */;
--
-- Database: `localizacaoindoor`
--
-- --------------------------------------------------------
--
-- Table structure for table `coordenadas`
--
CREATE TABLE IF NOT EXISTS `coordenadas` (
`id_coordenadas` int(11) NOT NULL AUTO_INCREMENT,
`coordX` int(11) NOT NULL,
`coordY` int(11) NOT NULL,
PRIMARY KEY (`id_coordenadas`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=289 ;
--
-- Dumping data for table `coordenadas`
--
INSERT INTO `coordenadas` (`id_coordenadas`, `coordX`, `coordY`) VALUES
(210, 254, 98),
(211, 218, 154),
(212, 377, 105),
(213, -1, -1),
(214, 319, 122),
(215, 72, 478),
(216, 326, 449),
(217, 325, 447),
(218, 145, 116),
(219, 153, 123),
(220, 141, 119),
(221, 140, 124),
(222, 143, 121),
(223, 147, 117),
(224, 142, 126),
(225, 140, 116),
(226, 145, 121),
(227, 138, 123),
(228, 138, 125),
(229, 328, 449),
(230, 137, 125),
(231, 140, 109),
(232, 206, 332),
(233, 83, 83),
(234, 249, 83),
(235, 415, 83),
(236, 83, 249),
(237, 249, 249),
(238, 415, 249),
(239, 83, 415),
(240, 249, 415),
(241, 415, 415),
(242, 83, 581),
(243, 249, 581),
(244, 415, 581),
(245, 79, 83),
(246, 79, 249),
(247, 581, 83),
(248, -3, 83),
(249, 3, 83),
(250, 501, 83),
(251, 83, 540),
(252, 415, 540),
(253, 501, 540),
(254, 249, 540),
(255, 211, 186),
(256, 268, 225),
(257, 372, 303),
(258, 266, 251),
(259, 139, 285),
(260, 149, 287),
(261, 156, 293),
(262, 262, 227),
(263, 260, 252),
(264, 279, 303),
(265, 261, 256),
(266, 260, 245),
(267, 261, 247),
(268, 259, 249),
(269, 260, 247),
(270, 258, 244),
(271, 258, 245),
(272, 263, 248),
(273, 262, 247),
(275, 364, 299),
(276, 368, 299),
(277, 260, 246),
(278, 261, 246),
(279, 262, 250),
(280, 374, 183),
(281, 314, 121),
(282, 70, 485),
(283, 141, 123),
(284, 140, 123),
(285, 141, 126),
(286, 143, 123),
(287, 142, 122),
(288, 477, 554);
-- --------------------------------------------------------
--
-- Table structure for table `planta`
--
CREATE TABLE IF NOT EXISTS `planta` (
`id_planta` int(11) NOT NULL AUTO_INCREMENT,
`nome` varchar(50) NOT NULL,
`altura` int(11) NOT NULL,
`largura` int(11) NOT NULL,
`alturaReal` double NOT NULL,
`larguraReal` double NOT NULL,
`imagemPlanta` longblob NOT NULL,
PRIMARY KEY (`id_planta`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `planta`
--
INSERT INTO `planta` (`id_planta`, `nome`, `altura`, `largura`, `alturaReal`, `larguraReal`, `imagemPlanta`) VALUES
(1, 'Quarto', 583, 505, 3.85, 3.34, 0x89504e470d0a1a0a0000000d49484452000001f90000024708020000001cfcb82b000000017352474200aece1ce90000000467414d410000b18f0bfc6105000000097048597300000ec300000ec301c76fa8640000520d49444154785eeddd4f682dc9793f7c639c44c364e62a363677e006e4383087700927300ec2d870bc190b6faca5bc79513c8b689101118cd166b80b63b41464a385095acabbbbf871918dffc8f6606b29864094ac34ab57590404ef466495f75bb7bed3bf6ea9ab547a54dda7ea9cef6731a3a7baefa3e774553f6ab58e5a9f7be79d773e2722f299d5d5557ed4329d4eff57b2c221e5c1edea3dfe8ff4ecd933f7bf3ffce10fff4744e435f40476a396de41798cd021c5386722938f3ffef84ffff44f91d6e555bb1711afb707851a9398850ea9efc9b9a0d1bf7af50a399d66c87f2022cb0c3d815da7a577501e2374489b9efc78bffded6fd1e8f101723a7e1443bffffdeffdc722b2b4d013d8755a7a07e5314287b4e9c98ff49bdffce6e4e4c47f8c9c8e0f40ed5e44d013d8755a7a07e5314287b4dd93cdda8d1e90d361f41adafde9e9290311593ee809ec3a2dbd83f218a1437aab271bfcea57bf6a377a404e87d1677efef39fabdd8b2c2df404769d96de41798cd021bddb931f048dfe97bffc2583cf20a7c3a845ed5e6469a127b0ebb47ce52b5ff1ed426fb47fa4e66df538a41ceac226cec4c3f5367af09fb13fef2f7ef18bde7f23228b0d3d815da74f7cabdcebde0318eac9f7c235faaf7ffd6b065dc8e930ba23f425424416187a02bb4e9ff856b9d7bd0730d29323e2376390d361d447ed5e64d9a027b0ebf4896f957bdd7b00e33db9d7bd77dd91d3611470ebbd3b22b2d8d013d875fac4b7cabdee3d80f7f6e45b5ebd7af5bbdffd8e4100723a8cc2d4ee4596077a02bb4e9ff856b9d7bd0730a52737127f290a391d46516af7224b023d815da74f7cabdcebde0398d89321fdb75f91d361741fff0c1d0622b2a0d013d8755afeeaaffecab78bd5d5550e8949f3c8621c520e75611367e23ee9cfacf49ff101df2fa8dd8b2c3cf404769d96de41798cd0214decc90f7a3831723a8cd2e87198228b0d3d815da7a577501e237448537af2439f428f9c0ea3647ad8bdc802434f60d769e91d94c7081dd27b7bf21ffff8477e940c391d460fa1762fb2a8d013d8755a7a07e531428734de930d8d1e90d361f4406af7220b093d815da7a577501e237448233dd9d6e801391d460f67fec422522cf404769d96de41798cd0210df5e4c75c5e23a7c3c844ed5e64c1a027b0ebb4f40eca63840e696f4f7ee47d14e4741859bdfbeebb4c2422f5fbfce73fcf8f5ade78e38d972f5fb21bc943acafaff32076bdfdf6dbfca8ebeef15f5b5b63b7b562224656c8c0d724220beac56b0ce421d0a92f2f2f19b4a477ce2c5dda6164850cac484416947abd997abd8854e3e8e8687b7b9b813c847abd885443bdde4cbd5e44aaf1f2e5cbcdcd4d06f210eaf522528dd3d3d3d96cc6401e42bd5e44aaa15e6fa65e2f22d5b8b8b8984c260ce421d4eb25683a9dfaa911498765c3053400742bf42c06f210eaf512b44887f4e6e606dffec3fefebe7f8f366c6e6eceeeb3bbbbcbbd5fbc78f9f22532f49e30d21874d95c5d5d3d7dfa94813c847abd04d57b48d1d9b75f43b3f6df9dacacacf8debdb7b7c7cefd59ef8e3b3838e0de9f7d6dc0398384ababab3ee1d6d696ba7fdbd0cb4667ba8d7abd04557d4851fcd1d1119af5f9f93987b2babebef65f0cf089d4ebdb865e36f82a8b83cf4092a9d74b50d58774b4e2b5f06e19fa80acafaf9f9d9d319064eaf51254f5211dad782dbc5b863e203b3b3b8787870c24d96432b9b8b860d0923e5fd893ddd60a191c4656c8c08a24932a0e69e4cd42dc6360fc647d72bd2325ef1ba2067d9f0ce053f0a3611c1c1ceceeee329064b3d9ecf4f494414bfa7c614f765b2bb7feb2646145924915873454e468c5473e51ae1af2be96a18fccd0f9f598041bf57a09aae290868a1cadf8c827ca5543ded732f491193abf7e9dca46bd5e82aa38a4a122472b3ef28972d590f7b50c7d644638f22b2b2b3737370c248d7abd0455714843458e567ce413e5aa21ef6b19fac88c70e4a7d3e9406fa55d60eaf51254c5210d15395af1914f94ab86bcaf65e82333c291dfdcdcd45f9d7d28f57a09aae290868a1cadf8c827ca5543ded732f49119e1c8efedededefef339034eaf51254c5210d15395af1914ff4f81a9a775b32cec127fcd297bec438b7bcd5f63a3e3ededada622069d4eb25a88a431a2a72b4e2239fe8f135f80c795fcb1039db86cbdc383f3f1ffab704168f7abd0455714843458e567ce4133dbe069f21ef6b192267db7099dbf4549c8752af97a02a0e69a8c8d18a8f7ca2c7d7e033e47d2d43e46c1b2e739b7e3cfb50eaf51254c5210d15395af1914ff4f81a7c86bcaf65889c6dc3656e3b3c3cdcd9d9612009d4eb25a88a431a2a72b4e2239fe8f135f80c795fcb1039db86cbdc76a93f50f540eaf51254c5210d15395af1914ff4f81a56575791e4f179da7cc23ff9933f619c5bde6a23420fe9955eeaf51254c5210d15395af1914f94ab86bcaf65e82333da91dfdede3e3a3a6220f7091daef4f9c29eecb656c8e030b2420656249954714843458e567ce413e5aa21ef6b19fac88c76e4d1b9d0bf18c87dd4eb25a88a431a2a72b4e2239f28570d795fcbd04766b423af5bf60fa25e2f41551cd25091a3151ff944b96ac8fb5a863e32a31d79d02dfb74eaf51254c5210d15395af1914f94ab86bcaf65e82333da918750ff92bbd4eb25a88a431a2a72b4e2239f28570d795fcbd04766b4230ffa1b55e9d4eb25a88a431a2ad22da9b184fe6e0636f1a3c7c995c7cb9bedaea1f3b7e1c8afadad5d5d5d319630f57a09aae290f616797a7a3a9bcd180c6c6b6bebf8f8984157ae03987722869ed69197cdcececee1e121030953af97a02a0e696f91639eff91e7ebe63a80792762e8691d79d99c9d9dadafaf339030f57a09aae290f616f9f4e9d3d1beafbfb9b9595d5dedbd8d93eb00e69d88a1a775fc6533994c2e2e2e1848807abd04557148ef1639e60d1c2f741b27d701cc3b11434febf8cb667f7f7f6f6f8f8104a8d74b501587f46e91e3dfc00dddc6c97500f34ec4d0d33afeb2d12f55a550af97a02a0ee9dd22c7bc81e3856ee3e43a80792762e8699dcbb2093dd84b1aeaf51254c521bd55e4f83770bcdedb38b90e60de89187a5ae7b26cd0c5d0cb18481ff57a09aae290de2a725eefc0ebbd8d93eb00e69d88a1a7752ecb26f21372f15ebcc6a0257dbeb027bbad1532388cac9081154926551cd25b458e7f03c7ebed35b90e60de89187a5ae7b56c423f21174fbd5e82aa38a4ed22e77503c7bbdb6b721dc0bc1331f4b4ce6bd99c9f9f4fa7530672877abd04557148db45cef75728efdec6c97500f34ec4d0d33ac765a33f381ea15e2f41551cd27691f3ba81e3ddbd8d93eb00e69d88a1a7758ecb4697f611eaf51254c5216d8a9cef0d1cefd66d9c5c0730ef440c3dadf35d36bab40f51af97a02a0e6953e4cececefefebeff785ed0e83736369a4bfb5c0730ef440c3dadf35d36272727980206d2a25e2f41551cd2a6c8959595b5b535b7925e7bfaf4292ef33d5cebf985de0b0d1adf13dcc5cd7d767777997a365b5f5fe7a7fc0cda8d2f091ffb0f1e29571e2f6fb6bb86ce7fafe9747a7e7ece403ee3972e8396f4f9c29eecb656c8e030b242065624995471489b226f557b7575c59e7d7a8a6feafd42efb5b5b5c5b6ddc5cd7d0e0e0e98faf4f4ecec8c9ff2b57619b90e60de89c89bedaea1f3df4b7fc0a4975fba0c5ad2e70b7bb2db5a2183c3c80a1958916452c5216d8a2ca4da7619b94acafbd2863e50254c842eedef52af97a02a0e69536421d5b6cbc85552de9736f4812a612274697f977abd045571489b220ba9b65d46ae92f2beb4a10f542113a14bfb5bd4eb25a88a43da145948b5ed32729594f7a50d7da00a9908fdbdaa5bd4eb25a88a43da145948b5ed32729594f7a50d7da00a9908083dd97139a9d74b501587b429b2906adb65e42a29ef4b1bfa40153211707575359d4ee7f8abd445393c3cdcd9d961d0923e5fd893ddd60a191c4656c8c08a24932a0e69536421d5b6cbc85552de9736f4812a64223c3dd7be113a14e9f3853dd96dad90c16164850cac4832a9e290364516526dbb8c5c25e57d69431fa84226a2b1bebe7eeb772096937abd045571489b2257565666b3d9d6d696bf2f8995ed7fd7e9fafadaef90ddf9f9b9ff14fbfbfbf88c7b7b7b2800f5e8f766f95119304d68f7b7feb4c01252af97a02a0e6953e4c5c505daeef1f1b1eff558d6af7ffb75b6babaea96d7e73e8713de8f34b08fdf3982bbb63c7dfad4279c4ea77e045d1e7ba2e3fbd6afe7e1f0a3626082e6feaca4b953af97a02a0e697a91f846def7e20656bf6fe811dcb525fd677d8f3f80f87282248fcfd3e6132233e3dcf2569b05befaaeadad2df90f69d5eb25a88a435a72918fafcd67c8fb1a87c8d9365ce6c7d0f32fd5eb25a88a43dadca229106a63955648d2fc37972172b60d97f9917677770f0e0e182c1ff57a09d2219d3b3f05792762889c6dc52e9b9b9b9bd96cb6b4efc951af97201dd2b9f35390772286c8d956f2b2b9bcbc9c4ea7c3bd35ab64eaf512a4433a777e0af24ec41039db0a5f36a196b7f0d4eb25488774ee9a9f4630cec1277cfccf1242f2563b04b43c343e064b43bd5e820a3fa4cdfb114b96e5ad8dc8c38f72c89bedaea1f33fdecdcd0de6e5e2e282f17250af97a0c20fa92fefbffffbbffff33fff13fffd9ffff99fffef33f8f856d8ecd986113f88ff6287f63ff15ea77142ff1ce371598e61de89187a5a0b5f361e1a3ddafd52fd32ad7abd04157e487d79e8b9987dfc17adf9fffd8cefd40c5e87cd9e6dae617ff6cfb143fb9f78afd338a17f8ef1b82cc730ef440c3dad852f9b46a8f72daad06f18a4cf17f6e4d2b7420687911532b022c9a4f043eacb6b2ecc71f5cdc6bc70d7f5797f8760b83bf51e3e053f2adecececee1e1218345777a7a3a9bcd18b4a4cf17f664b7b572eb2f4b16562499147e48ab98f1255c9675bde4adadade3e363060b4dbd5e820a3fa4be3c5c74f322bcc55f8c33f84cefa0d7bb0923cdb53c3e683e6e3483cd075e13e2bf4bb82ceb7ac93737379b9b9bcda34917987abd04157e487d7968cabcb9dee29b3583cff40e7abd9b30827eed57d7eb1e1ebbddef3ff09a10ff5dc26559dd4bbebebe46135cf83f44ae5e2f41851f525fdeddeb71787d99aeebfaf9a8f125a3dd4fa7d3cbcb4bc68b48bd5e820a3fa4be3cdf55e1bffeebbfd8a447ecf5fe5fbdfed7fff79fe363bf33febb84cbb2d2978c468f56b8c0ed5ebd5e820a3fa4be3cb454bf00feeddffe8d375f46bc87e3ffd5eb7ffd7fff393ef63be3bf4bb82ceb7dc9e7e7e7e8868bfab41cf57a092afc90faf29a163c74afefbdaef7ffeaf5bf56afa7aa5ff2d9d9191ae242fe8e957abd04157e487d79beabc2d0bdde7fd25bfcbf7afdafd5eba9f6977c7272b29057f7eaf51254f821f5e50dd1eb2f2f2f91eddffffddffff8c73ffae44daf6f6ec4fbd0ffab5bff1c1fabd757cd5fdd2fd8df2c54af97a0c20fa92f6f885e8f543e67a3e9f54d13f7a1ff57b7fe393e6e765bc265b9182ff9fcfc7c7d7d7d917e54ab5e2f41851f525f5e731b3de3fb7090cae76c3417f2b7aeebfdbfbaf5cff131f6c19ac47f9770592ecc4b46a39f4ea70bf3be7bf57a092afc90faf29a5edf86c176f3bd1776be9b0723cd60fbe306467a3f8b7a3d3faa9fff35abc5f8ad5af57a092afc90faf27c57bd0583e8b9bca592003bdfcd839166b0fd710323bd9fa5c986ff2ee1b25cb0978c76bfb9b9b900cfccc13728bd7f4d217dbeb0a75ff966c8e030b24206562499147e487d79772fb72174c51d92fdbadeef8cff2ee1b25cbc977c7373b3b5b555fb9fb2babcbc5c5b5b63d0923e5fd893ddd60a191c4656c8c08a2493c20f691533be84cb72515ff2f6f6f6cece4ebd6fbd57af97a0c20f691533be84cb72815ff2e1e1e1fafa7aa57fbc50bd5e820a3fa479ff82c74086fec32005c2abe6478bc8bf17b3c6dbf7eaf512a4432a060bbf6caeafafb7b6b6aabb9fa35e2f413aa462b024cba6bafb39eaf512a4432a06cbb36ceaba9fa35e2f413aa462b054cbc6dfcfd9dede2eff5969eaf512a4432a064bb86c8e8e8ed0460f0f0f191749bd5e827448c56039970daeeb777676d6d7d78b7d7e8e7abd04e9908ac1322f9bb3b3b3e974babbbb5be02d1df57a09d22115032d9b838383c96452da3315d4eb254887540cb46ce0eaea6a7b7bbba85b3aeaf512a4432a065a360d7f4b074d1f7d9643f3737d7dddfb5bdce9f395a54b3b8cac90811549263aa462a065738b7f97cee6e6e6dcaff17ba7267dbeb027bbad1532388cac90811549263aa462a065d3ebe5cb97b8c69f6fc7ef9d9af4f9c29eecb656c8e030b24206562499e8908a81964d84eff8b3d9ecf4f4944323ea9d9af4f9c29eecb656c8e030b24206562499e8908a8196cdbdfc9f038491ffba61efd4a4cf17f664b7b5420687911532b022c94487540cb46c12a1e36f6c6cacadadededed8df30cb5dea9499f2fecc96e6b850c0e232b64604592890ea91868d93cc8e5e5e5fefefe6432994ea787878783fe1256efd4a4cf17f664b7b5420687911532b022c9a48a3f0622a559c23fcf92c5f9f9f9cece0e8eded6d6d640cfcec4ecf0a396dec15ed893ddd6caad8f2c595891d4e0def95aa4095daa172b8f84468f768fa68fd69ff747b8bdcb2c7ded614f765b2b6470185921032b921adc3b5f8b34a14bf562258bebebebc3c3c3d96c86b581ffbe78f1e2f17dbf7799a5af3decc96e6b850c0e232b64604552837be76b912674a95eac64872e8f5edff4fdfdfdfdb3b3336e7b88de6596bef6b027bbad1532388cac908115490dee9daf459ad0a57ab13228f4fdbdbdbdf5f5f59595958d8d0d7c0d383a3ac260ca1fbfed5d66e96b0f7bb2db5a2183c3c80a195891d4e0def95aa4095daa172be340733f393941afdfdedec6c53e5affd3a74ff1c1eeee2e2efcd1fdef3e84a77799a5af3decc96e6b850c0e232b64604552837be76b912674a95eaccccbd5d5155afcc1c1012efcd1f4d7d6d6b0aef041a37799a5af3decc96e6b850c0e232b64604552837be76b912674a95eac1405ddbff1d65b6f61a5dd826f0852eeff007666b7b5f29f51bd7eb9dc3b5f8b34a14bf56265516195b2db5a2183c3c80a195891d4e0def95aa4095daa172b8b0aab94ddd60a191c4656c8c08aa406f7ced7224de852bd58595458a5ecb656c8e030b24206562435b877be16694297eac5caa2c22a65b7b5420687911532b022a9c1bdf3b54813ba542f5616155629bbad1532388cac908115490dee9daf459ad0a57ab1b2a8b04ad96dad90c16164850cac486a70ef7c2dd2842ed58b95458555ca6e6b850c0e232b64604552837be76b912674a95eac2c2aac52765b2b6470185921032b921adc3b5f8b34a14bf56265516195b2db5a2183c3c80a1958519fe974ea3f4b515015eb5b3e78f9fc28e0de1d2ab2542f5616155629bbad1532388cac908115f5896f1d53bb9272aa1adfbdaf7d910ece52bd58595458a5ecb656c8e030b2420656d427be754ced4acaa96a7cf7be76ec30d05f621bd9cb972f535e2c3f1229155629bbad1532388cac908115f5896f1d53bb9272aa1adfbdaf1d3bacadad253e95a958a8df3f6e9071c032af04a9055629bbad1532388cac908115f5696f7df11a831143af5d49bce6c576ef6bc70efbfbfb7b7b7b8cebe4d740ca8be54722a5c22a65b7b5420687911532b0a23ef1ad636a57524e55e3bbf7b563075c144fa7d38b8b0b0ed5e6eaeaca7f6b92f262f99148a9b04ad96dad90c16164850caca84f7cebd0da57f7ed4ae65bd57cddfbdafd0e2f5fbedcdcdcf423d541e5a81f1f24be5891926195b2db5a2183c3c80a1958519ff8d6a1a9d7df75ef6b6f76683a665d4e4f4f67b399ff38fdc58a140bab94ddd60a191c4656c8c08afab4b7b63beff8da95c46b5e6cf7bef66687ebebebe9747af78f67960cd5aeafaf5f5d5df930fdc58a140bab94ddd60a191c4656c8c08afab4b7aad797e0ded7dedee1e2e202ad134d9f71d96e6e6e50edf9f939e307be5891326195b2db5a2183c3c80a1958519ff8d631b52b29a7aaf1ddfbda6fed707272b2b1b1c1a06c776f3a3df4c58a1408ab94ddd60a191c4656c8c08afac4b70e4df7eb6f393d3d5d5d5d65d00797c62b2b2b0c3e53c55b305121ea64f019bc96e67e4e2f1c0d7c31632052a42c5dda6164850caca84f7cebd0d4eb6fb9bebe8ef7faf3f3f3de87056d6d6d1d1d1d31280f6adbdede66d072ef8f97d7d6d6eafa8184dc55e643b752243e980b7bb2db5af94f375eafd7fdfa126079b5ef68df12ba84c7f53e9ae9eeee2ee392a0e0de460f070707919a2f2e2e26930903a956bda77362e5d88dddd60a191c4656c8c08afab4b7aad797000d0eed1ebd9b714b649387d6892be5c80e234325f886e3eead9bb6f5f5f5b3b333065d914d52917a4fe7c4cab11bbbad1532388cac908115f5896f1d53bb9272aa9a8ba3a323b4b95bbf167b7272828bdcc825bff7f2e54bfcdb12ee7b5c5f5fcf66b37b1fd3e62fde6fdd80c2205e45c977a524ddadd3195700b7d6760970cafcfef7bf67f099c44684ddd86dad90c16164850caca84f7cebd074bf3e04d7b3e880b88adfdededed8d878faf429fe1bff3166035f0fd0284f4f4f19cf03ea47f18957e5f8aa8097b9b2b282af0d80178bd7ae2bfa85b1baba8a33ba46f11f9e35b027bbad95ff74eaf5cb0b5d1bd7b6b8a28f77f9bb17fbd81f4d736b6b2bf1cb434668dc3b3b3bbddf5b6024727f099bf0f509c6af59868655818b157c452fea8a1e8b0d571587878728cf8f6011e23b635ca63ce87bca2c5dda6164850caca84f7babeed7d7c55fbfe3586169e25a787373133388e5db2cdce3e3632ce58383031f8e009f6b6d6d0d278f0f7dfbdedfdfc7571d8c032ede71ce17f82dbc0caac0f7896111e2c4e9bdb0c0bac52a4d7fb32fce41765b2b6470185921032bead3deaa5e5f1134faf64d122c595c8f600671398f6f3cd1557deb47bbc76eed3d07e26fda802f03e736beccf8db327b7b7b28a3b9ccc72984ddf4aef9e581d9c77a60500c5c27454e0a9c5058c0cd65535c962eed30b2420656d427be754ced4acaa9aa4c58826897911fc06293efb9b83cf177c071481b58c418bc65777717df6233684106e4017cf1e0501793bee647b0334eefc8c53b4e247c358adccf914582b57af736e37ca1cba3d73308c01991f83d31563ebbad953f7d16b9d7a329f023f5fa87386d3d2a321d3a2cfea1876fa85f37f0c7dadfdf4736c3370db8d0c3d70306b2b8f0151ddf6896f6753dfe8b1d1ece91d0ef85dc92a54b3b8cac908115f5896f1d1a9a053f52af7f8894955a38ffa582812c2e7c0f9af86e9631e15b0d5ca33008c037c7f8ee934154962eed30b2420656d4a7bd75bee75ebb9278cd82656ab8ae2f0aae984afb619d0ca4c0d339b1a4f4ddd86dad90c16164850caca84f7bab7a7d2d70ad34994ceebd3029967f0751ef5b2064f114783a279694be1bbbad1532388cac908115f5896f1d53bb9272aa2a16dafdc6c646f3eec68a9c9c9ce09b92c80f9665c114783a279694be1bbbad1532388cac908115f5896f1d5afb3b897625f3adaa163737373b3b3bbbbbbb15bda1055f9cf0252af1ad6cb2180a3c9d134b4adf8dddd60a191c4656c8e0ebee15df3a34f5fac73b3838980efff6f9c7bbbaba4297c71727c6b2340a3c9d134b4adf8dddd60a191c4656c8c08afab4b7ea7e7da52e5e3f296c6f6fafd80bfca3a3a3c964a2df9f5a4e059ece8925a5efc66e6b850c0e232b6460457dda5bd5ebabb6bfbf8f8eff32faa73fc6777e7e8ecbf9eded6dddb7595a059ece8925a5efc66e6b850c0e232b6460457de25bc7d4aea49caaea82c6bab9b9898e5fc25b742e2f2fb7b6b6f4380429f0744e2c297d37765b2b6470185921032bea13df3a34ddaf1fc2d9d9997b5241c2b3e307822f39b8905f5b5bd36fc60a14783a279694be1bbbad1532388cac908115f5896f1d9a7afd7070698fcbeaa74f9feeeded8df606c7a3d77f6505d7f2fa3d296914783a279694be1bbbad1532388cac908115f5696fd5fdfac5737575b5bfbf8f4becc964b2bbbb3bc4db75f085e4f0f07073737365650597f3e5bf23484656e0e99c5852fa6eecb656c8e030b2420656d4a7bd55bd7e815d5c5c1c1c1ce0a2bb79ce302ebd6d4f1fbcbebec6370d582dfec1c5f842b2b3b3f3f2e5cb8adee62f632af0744e2c297d37765b2b6470185921032bea13df3aa67625e554b578d091d1a971b18f6bf0e9748a430d4f9f3ef5b7f8e3f075023bafaeaee263f4faf8838b453cac197e548cc492d27763b7b5420687911532b0a23ef1ad43d3fdfa42b41f771ca12b773128f0744e2c297d37765b2b6470185921032bea13df3ab4de5e7f7e7e8e8f71a5b9b3b3a337658bd46ebe4da6576249e9bbb1db5a2183c3c80a1958519ff6d6a2eed7e34af3f0f0b0eaa7398a08c45bd05c249694be1bbbad1532388cac908115f5696f2daad7fb0fd0f1a7d3a96e0a8bd42bde82e622b1a4f4ddd86dad90c16164850caca84f7ceb98da95b43f3e4bf8cb902252ac729a4c23b1a4f4ddd86dad90c16164850caca84f7cebd0127f368b5eaf776d8b546abe4da6576249e9bbb1db5a2183c3c80a1958519ff8d6a125f6faf43fe82e22a5996f93e9955852fa6eecb656c8e030b2420656d4a7bdb5c0fbf5dee1e1a19e7b2e52a9780b9a8bc492d27763b7b5420687911532b0a23eedadc5f67afd1d6a917ac55bd05c249694be1bbbad1532388cac908115f5896f1d53bb925b554d2613bd1547a452e53499466249e9bbb1db5a2183c3c80a1958519ff8d6a1a5dcafc7153daeeb1988486de6db647a259694be1bbbad1532388cac908115f5896f1ddabdbdfef4f4747d7dfdeaeaca8722529df936995e8925a5efc66e6b850c0e232b6460457dda5b8bba5f7f7c7cbcb5b5359bcd467bf6ba880c21de82e622b1a4f4ddd86dad90c16164850caca84f7b6b21bdde3f0f078d5e7fd5486401c45bd05c249694be1bbbad1532388cac908115f5896f1d53bb9272aa1291472af0744e2c297d37765b2b6470185921032bea13df3ab4949fcd8a48d50a3c9d134b4adf8dddd60a191c4656c8c08afac4b70e4dbd5e64e115783a279694be1bbbad1532388cac908115f5696f2dea67b3fc48442a57e0e99c5852fa6eecb656c8e030b2420656d4a7bd55bd5e44b22bf0744e2c297d37765b2b6470185921032bea13df3aa67625e55425228f54e0e99c5852fa6eecb656c8e030b2420656d427be7568ba5f2fb2f00a3c9d134b4adf8dddd60a191c4656c8c08afac4b70e4dbd5e64e115783a279694be1bbbad1532388cac908115f5696fd5fd7a11c9aec0d339b1a4f4ddd86dad90c16164850caca84f7bab7abd886457e0e99c5852fa6eecb656c8e030b2420656d427be754ced4acaa94a441ea9c0d339b1a4f4ddd86dad90c16164850caca84f7cebd074bf5e64e115783a279694be1bbbad1532388cac908115f5896f1d9a7abdc8c22bf0744e2c297d37765b2b6470185921032bead3deaafbf522925d81a7736249e9bbb1db5a2183c3c80a1958519ff656f57a11c9aec0d339b1a4f4ddd86dad90c16164850caca84f7ceb98da95945395883cc6cdcdcdcaca0a8362acaeaedefb4790aeafafb11b83a82c5dda6164850caca84f7cebd074bf5e64b1a577cc31edefefefeded310878f9f2e5e6e62683a82c5dda6164850caca84f7cebd0d4eb4516de6432b9b8b86050869393938d8d0d0601f862802f090ca2b2746987911532b0a23eedadba5f2f22d9a537cdd1dcdcdcacadad5d5d5d31be033bacafaf9f9f9f338ecad2a51d4656c8c08afab4b7aad78b4876e89bd3e9b4ae4b7b34c3f47e98a54b3b8cac908115f5896f1d53bb9272aa1291c7c305f26432417b655c86dddd5db4fb5b57f7d7d7d7dbdbdb9b9b9bf812c5a1fb64e9d20e232b6460457de25b87d6fecad9ae64be55894846b8a8c7195d2354ced710853dd96dadfca753af17918ab54fe78b8b8be3e3e3d3d353c665403d1f7df4d13ffee33fe2035cd77334b9116137765b2b6470185921032bead3de9a7e7f6a08ed4ae2358b4845ea3d9d132bc76eecb656c8e030b2420656d4a7bd55bd5e44b25b5d5dc5195d23fd2ed520da9594539588485c962eed30b2420656d427be7568ba5f2f22b5cbd2a51d4656c8c08afac4b70e4dbd5e446a97a54b3b8cac908115f5696fd5fd7a119187cad2a51d4656c8c08afab4b7aad78b883c54962eed30b2420656d427be754ced4acaa94a44242e4b9776185921032bea73772baeeedb17f88386b3d98c817abd88d4294b9776185921032bea13df3aa67625e55425221297a54b3b8cac908115f5896f1d53bb9272aa121189cbd2a51d4656c8c08afac4b78ea95d4939558988c465e9d20e232b6460457dcafcf5e502ff689988482fb42c765b2bdff786edf52222f21859bab4c3c80a1958918888e496a54b3b8cac9081158988486e59bab4c3c80a1958918888e496a54b3b8cac9081158988486e59bab4c3c80a1958918888e496a54b3b8cac9081158988486e59bab4c3c80a1958918888e496a54b3b8cac9081158988486e59bab4c3c80a195851829b9b9bebeb6b06cbe7934f3ee14722b95d5d5df123592c59bab4c3c80a195851d8d9d9d96c365b5b5b5b5959a9f78fbe9bf957fd852f7c81b1c860d6d7d777767696f98a6af1605ad96dadfcda18b6d7e3427e6f6f0febeff4f4f4f2f292a34be3d5ab57efbcf3ce3ffff33fe3e5e35070f4b5f871f352f61169c375d5e1e1e16432393939e190542e4b9776185921032bba03dd0d5d7e7f7f9ff192393838f8ea57bf8a738f7157e4b83552f611b9ebeaea6a636363694fbd0593a54b3b8cac908115dd81ef257189c160c97cfae9a75ff9ca5722b75023c7ad91b28f4808aeb442971a52912c5dda6164850caca80bdf42e2ca82c1f2f9dbbffddb7ffdd77f65d02774dcda52f61109b9bcbc9c4c26b76e1e4a75b2746987911532b0a2aee9747a7e7ece60c97cf2c9274f9e3c6110103a6e6d29fb8844eceeee1e1c1c30903a65e9d20e232b6460452db894585d5d5dda0b8abdbdbdf7df7f9f4140ef71bb25651f9188a3a3a3eded6d0652a72c5dda6164850caca8e5f4f4f4e9d3a70c129c9d9da13fce66b372de9189627676768e8f8f59e243bcf5d65bf75e4ce153f0a3b0947d44222e2f2f1f74264a81d007d86dad5c47cb9285157585c66fc1b5bf7f53e6fefe3ebe4294f3be6014737878b8b5b5b5b1b1f1d0df52c16bbff785a41c9fc4632812a155543bcc20bbad1532388cac9081157585c6dbd043a7d369e1ef0c3b3939994c260ffad943ca6bcfb58f489c5651ed3083ecb656c8e030b2420656d4151a6fc3257315bff181af4968f7e9df73a4bcf65cfb88c46915d50e33c86e6b850c0e232b6460455da1f1c6e1e1e1cece0e83e21d1f1f6f6d6d31b8cfbdaf1d72ed2312a755543bcc20bbad1532388cac9081157585c6bd1adfa8339bcd4e4f4f1944c55fbb976b1f9138ada2da6106d96dad90c16164850caca82b34ee9d9d9dadafaf33a8c4dede5ee28f16e2afddcbb58f489c5651ed3083ecb656c8e030b2420656d4151af70e0e0e7677771954e2e5cb979b9b9b0ca2e2afddcbb58f489c5651ed3083ecb656c8e030b2420656d4151af72693c9c5c505834a5c5f5fafaeae32888abf762fd73e22715a45b5c30cb2db5a2183c3c80a1958515768dc8b6f2d5662d929bbe5da47244eaba8769841765b2b6470185921032bea0a8d7bf1adc54a2c3b65b75cfb88c46915d50e33c86e6b850c0e232b6460455da1712fbeb5588965a7ec966b1f9138ada2da6106d96dad90c16164850caca82b34eec5b7162bb1ec94dd72ed2312a755543bcc20bbad1532388cac9081157585c6bdf8d66225969db25bae7d44e2b48a6a871964b7b5420687911532b0a2aed0b817df5aacc4b25376cbb58f489c5651ed3083ecb656c8e030b2420656d4151af7e25b8b955876ca6eb9f61189d32aaa1d6690ddd60a191c4656c8c08aba42e35e7c6bb112cb4ed92dd73e22715a45b5c30cb2db5a2183c3c80a1958515768dc8b6f2d5662d929bbe5da47244eaba8769841765b2b6470185921032bea0a8d7bf1adc54a2c3b65b75cfb88c46915d50e33c86e6b850c0e232b6460455da1712fbeb5588965a7ec966b1f9138ada2da6106d96dad90c16164850caca82b34eec5b7162bb1ec94dd72ed2312a755543bcc20bbad1532388cac9081157585c6bdf8d66225969db25bae7d44e2b48a6a871964b7b5420687911532b0a2aed0b817df5aacc4b25376cbb58f489c5651ed3083ecb656c8e030b2420656d4151af7e25b8b955876ca6eb9f61189d32aaa1d6690ddd60a191c4656c8c08aba42e35e7c6bb112cb4ed92dd73e22715a45b5c30cb2db5a2183c3c80a1958515768dc8b6f2d5662d929bbe5da47244eaba8769841765b2b6470185921032bea0a8d7bf1adc54a2c3b65b75cfb88c46915d50e33c86e6b850c0e232b6460455da1712fbeb5588965a7ec966b1f9138ada2da6106d96dad90c16164850caca82b34eec5b7162bb1ec94dd72ed2312a755543bcc20bbad1532388cac9081157585c6bdf8d66225969db25bae7d44e2b48a6a871964b7b5420687911532b0a2aed0b817df5aacc4b25376cbb58f489c5651ed3083ecb656c8e030b2420656d4151af7e25b8b955876ca6eb9f61189d32aaa1d6690ddd60a191c4656c8c08aba42e35e7c6bb112cb4ed92dd73e22715a45b5c30cb2db5a2183c3c80a1958515768dc8b6f2d5662d929bbe5da47244eaba8769841765b2b6470185921032bea0a8d7bf1adc54a2c3b65b75cfb88c46915d50e33c86e6b850c0e232b6460455da1712fbeb5588965a7ec966b1f9138ada2da6106d96dad90c16164850caca82b34eec5b7162bb1ec94dd72ed2312a755543bcc20bbad1532388cac9081157585c6bdf8d66225969db25bae7d44e2b48a6a871964b7b5420687911532b0a2aed0b817df5aacc4b25376cbb58f489c5651ed3083ecb656c8e030b2420656d4151af7e25b8b955876ca6eb9f61189d32aaa1d6690ddd60a191c4656c8c08aba42e35e7c6bb112cb4ed92dd73e22715a45b5c30cb2db5a2183c3c80a1958515768dc8b6f2d5662d929bbe5da47244eaba8769841765b2b6470185921032bea0a8d7bf1adc54a2c3b65b75cfb88c46915d50e33c86e6b850c0e232b6460455da1712fbeb5588965a7ec966b1f9138ada2da6106d96dad90c16164850caca82b34eec5b7162bb1ec94dd72ed2312a755543bcc20bbad1532388cac9081157585c6bdf8d66225969db25bae7d44e2b48a6a871964b7b5420687911532b0a2aed0b817df5aacc4b25376cbb58f489c5651ed3083ecb656c8e030b2420656d4151af7e25b8b955876ca6eb9f61189d32aaa1d6690ddd60a191c4656c8c08aba42e35e7c6bb112cb4ed92dd73e22715a45b5c30cb2db5a2183c3c80a1958515768dc8b6f2d5662d929bbe5da47244eaba8769841765b2b6470185921032bea0a8d7bf1adc54a2c3b65b75cfb88c46915d50e33c86e6b850c0e232b6460455da1712fbeb5588965a7ec966b1f9138ada2da6106d96dad90c16164850caca82b34eec5b7162bb1ec94dd72ed2312a755543bcc20bbad1532388cac9081157585c6bdf8d66225969db25bae7d44e2b48a6a871964b7b5420687911532b0a2aed0b817df5aacc4b25376cbb58f489c5651ed3083ecb656c8e030b2420656d4151af7e25b8b955876ca6eb9f61189d32aaa1d6690ddd60a191c4656c8c08aba42e35e7c6bb112cb4ed92dd73e22715a45b5c30cb2db5a2183c3c80a1958515768dc8b6f2d5662d929bbe5da47244eaba8769841765b2b6470185921032bea0a8d7bf1adc54a2c3b65b75cfb88c46915d50e33c86e6b850c0e232b6460455da1712fbeb5588965a7ec966b1f9138ada2da6106d96dad90c16164850caca82b34eec5b7162bb1ec94dd72ed2312a755543bcc20bbad1532388cac9081157585c6bdf8d66225969db25bae7d44e2b48a6a871964b7b5420687911532b0a2aed0b817df5aacc4b25376cbb58f489c5651ed3083ecb656c8e030b2420656d4151af7e25b8b955876ca6eb9f61189d32aaa1d6690ddd60a191c4656c8c08aba42e35e7c6bb112cb4ed92dd73e22715a45b5c30cb2db5a2183c3c80a1958515768dc8b6f2d5662d929bbe5da47244eaba8769841765b2b6470185921032bea0a8d7bf1adc54a2c3b65b75cfb88c46915d50e33c86e6b850c0e232b6460455da1712fbeb5588965a7ec966b1f9138ada2da6106d96dad90c16164850caca82b34eec5b7162bb1ec94dd72ed2312a755543bcc20bbad1532388cac9081157585c6bdf8d66225969db25bae7d44e2b48a6a871964b7b5420687911532b0a2aed0b817df5aacc4b25376cbb58f489c5651ed3083ecb656c8e030b2420656d4151af7e25b8b955876ca6eb9f61189d32aaa1d6690ddd60a191c4656c8c08aba42e35e7c6bb112cbfeb33ffbb38b8b0b060129a92a3d4a5214ada2da6106d96dad90c16164850caca82b34eec5b7162bb1ece7cf9f1f1d1d3108484955e95192a26815d50e33c86e6b850c0e232b6460455da1712fbeb55889657fe31bdfd8dfdf67109092aad2a32445d12aaa1d6690ddd60a191c4656c8c08aba42e35e7c6bb112cbfece77bef3a31ffd8841404aaa4a8f921445aba8769841765b2b6470185921032bea0a8d7bf1adc54a2cfb830f3ed8dada62109092aad2a32445d12aaa1d6690ddd60a191c4656c8c08aba42e35e7c6bb112cbfee94f7ffafcf973060129a92a3d4a5214ada2da6106d96dad90c16164850caca82b34eec5b7162bbdec959595ebeb6b067d5252557a94a4285a45b5c30cb2db5a2183c3c80a1958515768dc8b6f2d567ad9efbefbeef1f131833e29a92a3d4a5214ada2da6106d96dad90c16164850caca82b34eec5b7162bbdec7b6fd9a7a4aaf4284951b48a6a871964b7b5420687911532b0a2aed0b817df5aacf4b23ff9e493bff88bbff8c10f7e707a7acaa1ae9454951e25298a5651ed3083ecb656c8e030b2420656d4151af7e25b8bf5a0b2d1e8bffad5af3e7bf6ecc99327779b7e4aaa4a8f921445aba8769841765b2b6470185921032bea0a8d7bf1adc57a50d95757576b6b6b373737b8c6fffef7bf8fa6ffc61b6f6c6d6dbd7cf9125bb1c9ef1651e95192a26815d50e33c86e6b850c0e232b6460455da1712fbeb5580f2d7b7777f7e0e080c1fffeefa79f7efac1071f7ced6b5f6b9a3ebe12705b9f4a8f921445aba8769841765b2b6470185921032bea0a8d7bf1adc57a68d9cda53de3cfb49bfef7bef7bde3e3e3dea65fe95192a26815d50e33c86e6b850c0e232b6460455da1716f7575f5de274196e6fafa7a65658541325cdacf66b3d07bed31fee1871fbefbeebbbee91f1d1db5f78c1f4391145a45b5cbd2a51d4656c8c08aba42e3dec1c1019a20834abc7cf97273739341325cb0bf78f1e2de4726f8a6fffcf9737c3979fffdf77dd34fb9a72f12173f13a57c59bab4c3c80a1958515768dc3b3b3b5b5f5f675089bdbdbd7b9f5e19825e1fffd5aa367c22dff4bff5ad6f1d1e1e5e5d5d7183c8c3c5cf44295f962eed30b2420656d4151af770b5bbbaba1affc9646966b359e8cdf2f742bf9e4ea70fedda3ffef18ff1afde7cf3cdf7de7b4f4d5f6ce267a2942f4b9776185921032bea0a8d37708d8c0b5806c53b3939d9d8d8606062bb05e41d1c1cf8a6ffd77ffdd7f8f8f2f2921b44ee73ef992885cbd2a51d4656c8c08aba42e36d8fb9521e93edaafcaeededed7bff5e55dccf7ef6b3af7ffdeb4f9e3cf14dbfba9f6fcbf852ce442959962eed30b2420656d4151a6fc3f5297ae823dbdfd0cecece5024aeeb193fc2f5f5f56432c9722bc637fd2f7ef18bcf9e3dfbe8a38fd4f42524e54c949265e9d20e232b6460455da1f15bd0fe70b5bbb1b1818e8faecad1029c9f9f1f1f1fefececacafaf67eca48fbf1774cbab57afbefded6ffba6ffa31ffd08657383c86b8967a2142b4b9776185921032bea0a8df7420744c747577d5d5111702dbfb5b5757878c812f3c1d78f21d2a2e97fe73bdff9f26bfff44fffa4a62f1e16333f923a6106d96dad5eb7b4327afd52b9b9b9994c26c3fd7cf5e38f3fdedcdcf44d3ff2a04d59123a136b97a54b3b8cac9081157585c605d07f67b31983c1a0e9fb67aef53e68539684cec4da65e9d20e232b6460455da171f1fee66ffee61bdff8c638fdb7f7419bb2247426d62e4b9776185921032bea0a8d8bf71ffff11f68be7ffff77ffff4e9d39d9d9d719afe431fb4290b406762edb2746987911532b0a2aed0b834fc8322aeaeae0e0f0f67b3d9bc9a7ee4419bb2007426d62e4b9776185921032bea0a8d4b5bfb193b7369fafe996ba1076dca02d09958bb2c5dda6164850caca82b342e6db89ac6a5fdadf747ceb1e9df7ad026b749cd7426d62e4b9776185921032bea0a8dcb2d68f468f7bdb750da4d7f7b7b7bb49fa9ea419b8b446762edb2746987911532b0a2aed0b8dcf5e235067dd06d71a1bdb9b9b9baba3a66d3d783361780cec4da65e9d20e232b6460455da1f15ec7c7c71b1b1b6b6b6baf2b2a022ea571418d06c71287848b7a7cae9447445c5f5fcfa5e9eb419bf5c262e6475227cc20bbadd5eb9636ef5e8f4b4574f9adadad939393a23a080a3b3d3dddc9fd3c9c107c0a34d3f437c3ccabe9eb419bd5493c13a55859bab4c3c80a1958515768bc0d9d623299647984e470323ee732cef640fff9367d3d68b37c2967a2942c4b9776185921032bea0a8d37d26f5ccc1dfa69ae6711c7e17b08f30169377dff270fd3bf4b780c3d68b370f79e8952b82c5dda6164850caca82b34deb8f7079245391de50936979797f8a2f2c81e8da68f468f763f7ed3d783360b74ef992885cbd2a51d4656c8c08aba42e31ebacfcaca0a834aa0d78ff056f7c3c3c39d9d1d068f83833c97a6af076d16257e264af9b2746987911532b0a2aed0b837ce65725ea37d2392fd8bca1c9bbe1eb43977f13351ca97a54b3b8cac9081157585c6bdbafeb0b897fd4f4a85f83fcd783dc0afadceabe9eb419b73143f13a57c59bab4c3c80a1958515768dc9b4c26d5bd73036d71b4fb4e474747dbdbdb0c06d06efa9b9b9bf874437c69b94b0fda1c5ffc4c94f265e9d20e232b6460455da1712fbeb55863968def214678a3275a2d1a2ebeaeccb1e9eb419b83aaf45c93066690ddd60a191c4656c8c08aba42e35e7c6bb1c62cfbeaeaeac99327fff00fff30da6deeb9347d7c163d687350959e6bd2c00cb2db5a2183c3c80a1958515768dc8b6f2dd6c865ffcbbffccb7befbd371bfdd967736cfa7ad06676959e6bd2c00cb2db5a2183c3c80a1958515768dc8b6f2dd6f865fb9fa0e21a1fbd0f9d77e49fa9cea5e9831eb49951a5e79a343083ecb656c8e030b2420656d4151af7e25b8b357ed96873d3e9b46976e8b673f9996ad3f4373636c66cbe7ad0e6e3557aae490333c86e6b850c0e232b6460455da1712fbeb55873291b7d166d9dc1676efd4c75b43e787272b2b3b3d33c0474b4e6ab076d9a557aae490333c86e6b850c0e232b6460455da1712fbeb558f32a1b3d1d97f00cee40d36ffaef687df0f4f54340c76ffa7ad0e643557aae490333c86e6b850c0e232b6460455da1712fbeb558f32afb3aede16be8bfbbbbbb6b6b6bb804dedfdf1fa70fceb7e9eb419bf7aaf45c93066690ddd60a191c4656c8c08aba42e35e7c6bb1e658f6837e6bf7fcfc7c6f6f0f5f1e001f8cf318b279357d3d6833aed2734d1a9841765b2b6470185921032bea0a8d7bf1adc59a6fd9e8a4e8a10cd2e06a1717f8b8ccc7c53e2ef9c7798274d3f4d7d7d7c7bcb7ae076df6aaf45c93066690ddd60a191c4656c8c08aba42e35e7c6bb1e65bf6cdcd0daed36dad13ff0a6d17cd172d188d7884dfc8057c6969ee298dd9f49b076dfee55ffe25bef0707459557aae490333c86e6b850c0e232b6460455da1712fbeb558732f1b9d6bf6b8e7835e5d5de19b838d8d8dd5cffe8ed5086fd5c725f65c9afecf7ef6b367cf9ebdfffefbcbfc6b59959e6bd2c00cb2db5a2183c3c80a1958515768dc8b6f2d560965a369a25d327804b4bf5bbf9f3542439c4bd3fff0c30fffeeeffe6e699fb753e9b9260dcc20bbad1532388cac9081157585c6bdf8d6629550367a161a65c6b79d20e1f8bf9f3572d3ff7f5e63b0642a3dd7a4811964b7b5420687911532b0a2aed0b817df5aac42ca3e3b3b5b5f5f679055f3fb59a3bd97a6ddf45fbc7831dc5b27df7df75d7c4963b04c2a3dd7a4811964b7b5420687911532b0a2aed0b817df5aac72cadedbdbdbdfdf673080e6bd34a3dd6c41d347aff7ef131da2e9e388bdfffefb0c9649a5e79a343083ecb656c8e030b2420656d4151af7e25b8b554ed9373737b8b4477f643c98e6ba7ba0167c173ec5104dfffafafa8d37de58c2bbf6959e6bd2c00cb2db5a2183c3c80a1958515768dc8b6f2d565165a30ba3dd8fd6bc9a168cbe8fee3fc29799ec4dff9d77de19e7370c8a52e9b9260dcc20bbad1532388cac9081157585c6bdf8d6629556363a203018cbe5ebb7ea4f5fff7ed6cecece086f60cfd5f49f3c7932dadb3dcb51e9b9260dcc20bbad1532388cac9081157585c6bdf8d6629556362eea67b3d9bcae55d1370f0f0f51c0d3b1fe944abbe91bbeb7f8c217bea07b38521dcc20bbad1532388cac9081157585c6bdf8d662155836da1f2eb1e7dbc2ae46ff532a78d5cdf716e94dbfd255f748cbf9aa17096690ddd60a191c4656c8c08aba42e35e7c6bb1ca2c7b7f7f7f6f6f8fc15c5d8ffea754da3794e24dffa73ffde9f3e7cf192c934acf35696006d96dad90c16164850caca82b34eec5b716abd8b2d7d7d78bfaa923aeeb47fe532af736fd6f7ef39b3ff9c94f182c934acf35696006d96dad90c16164850caca82b34eec5b716abd8b2d1e92693499937a347fe532aa1a6bf9c3f98854acf35696006d96dad90c16164850caca82b34eec5b716abe4b271ed8c96caa048a7e3fe2995a6e9e36bccd2dec0814acf35696006d96dad90c16164850caca82b34eec5b716abf0b2d1d4aa78842faeb547fe532adffef6b73ffae823064ba6d2734d1a9841765b2b6470185921032bea0a8d7bf1adc52abc6c5cc9e23276842797e5824bfb71fe94ca17bff8c5a1bf8d2856a5e79a343083ecb656c8e030b2420656d4151af7e25b8b557ed9474747dbdbdb0ceae1efb70cf4a7545ebd7af5ecd93306cba7d2734d1a9841765b2b6470185921032bea0a8d7bf1adc5aaa2ec8d8d8d71feecd41086f8532acb7c03072a3dd7a4811964b7b5420687911532b0a2aed0b817df5aac2aca46bb9c4c2615ddc9e985fa73fd29952f7ff9cb23fc48a058959e6bd2c00cb2db5a2183c3c80a1958515768dc8b6f2d562d65fb5f686250395cd73fe6f7b33efef863f47a064ba9d2734d1a9841765b2b6470185921032bea0a8d7bf1adc5aaa86c7f2dcc605118fe94ca77bffbdd1ffef0870c9652a5e79a343083ecb656c8e030b2420656d4151af7e25b8b5551d9e883d3e974e8df569d97f43fa5b29ccf316eabf45c93066690ddd60a191c4656c8c08aba42e35e7c6bb1ea2a1b57c19b9b9b0c16d479f44fa9e8060e547aae490333c86e6b850c0e232b6460455da1712fbeb558d595bdbdbd7d7474c460a1a1cbfbc71db71f8df0fdef7fff073ff881df6169557aae490333c86e6b850c0e232b6460455da1712fbeb558d5957d7d7d8df6b7a877727ab51f8df0ecd9b32a7e917850959e6bd2c00cb2db5a2183c3c80a1958515768dc8b6f2d568d659f9c9c6c6c6c3058269f7cf2c993274f182cb14acf35696006d96dad90c16164850caca82b34eec5b716abd2b27776760e0f0f192c0dddc0f12a5db4d2c00cb2db5a2183c3c80a1958515768dc8b6f2d56a565dfdcdc4c2693c89b5516926ee078952e5a696006d96dad90c16164850caca82b34eec5b716abd2b2015d6f369b3158029f7efae9db6fbf5de603fd4756efa2150f33c86e6b850c0e232b6460455da1712fbeb5589596ededeeee1e1c1c3058741f7cf0c1c2fce6f02355bd68053083ecb656c8e030b2420656d4151af7e25b8b5569d91e2e72a7d3e9923cda776d6dadde07c0e555f5a215c00cb2db5a2183c3c80a1958515768dc8b6f2d56a56537cececed6d7d7192c2eddc069ab7dd10a6690ddd60a191c4656c8c08aba42e35e7c6bb12a2dbb6d6f6f6f7f7f9fc182faf0c30fbff7bdef31587a0bb068971c6690ddd60a191c4656c8c08aba42e35e7c6bb12a2dbb0d57bbb8b45fec67fcbefbeebb8bf7dc37b30558b44b0e33c86e6b850c0e232b6460455da1712fbeb55895967d0b1a3ddafda2dee2b8bebe7ee38d377403a7b1188b76996106d96dad90c16164850caca82b34eec5b716abd2b2ef7af11a83c5a21b38b72ccca25d5a9841765b2b6470185921032bea0a8d7bf1adc5aab4ecbb70d93b9bcd16f261bfcf9f3f5f92c7bd255a9845bbb43083ecb656c8e030b2420656d4151af7e25b8b5569d9bd2e2e2ea6d3e982ddebb8bebe7eebadb7cc7fad70212dd2a25d4e9841765b2b6470185921032bea0a8d7bf1adc5aab4ec90fdfdfdbdbd3d060be1c73ffef1b7bef52d06f2da822dda25841964b7b5420687911532b0a2aed0b817df5aac4acb8e585f5f5fa43b39ba8173d7e22dda65831964b7b5420687911532b0a2aed0b817df5aac4acb8eb8bcbc9c4c260b73276765654537706e59bc45bb6c3083ecb656c8e030b2420656d4151af7e25b8b5569d9718787873b3b3b0c6a767070f0de7bef3190cf2ce4a25d2a9841765b2b6470185921032bea0a8d7bf1adc5aab4ec7bcd66b30578fcef743a5dc2c7f4df6b5117edf2c00cb2db5a2183c3c80a1958515768dc8b6f2d56a565dfebf2f2128db2f6bb1f6fbef9e652fdb5c5448bba6897076690ddd60a191c4656c8c08aba42e35e7c6bb12a2d3bc5d1d1d1f6f636830ae9064ec8022fda25811964b7b5420687911532b0a2aed0b817df5aac4acb4eb4b1b151ef7380bffef5af2fcfd3f91f64b117ed32c00cb2db5a2183c3c80a1958515768dc8b6f2d56a56527bababa9a4c2695dec979f2e4c9b2fd91c5448bbd6897016690ddd60a191c4656c8c08aba42e35e7c6bb12a2d3bddf1f1718d7fcee9a73ffde9f3e7cf1948d7c22fda85871964b7b5420687911532b0a2aed0b817df5aac4acb7e10f4faea1e08fccd6f7ef3273ff90903e95a8645bbd83083ecb656c8e030b2420656d4151af7e25b8b5569d90f727575359d4eeb7a438b6ee0442cc3a25d6c9841765b2b6470185921032bea0a8d7bf1adc5aab4ec877af9f2e5e6e62683e2bd7af5ead9b3670ce48e2559b40b0c33c86e6b850c0e232b6460455da1712fbeb55895966db0bdbd5dcb8365befded6f7ff4d1470ce48ee559b48b0a33c86e6b850c0e232b6460455da1712fbeb55895966d707d7d3d994caab893f3c52f7ef1e2e28281dcb13c8b76516106d96dad90c16164850caca82b34eec5b716abd2b26d4e4e4e36363618944a3770eeb5548b76216106d96dad90c16164850caca82b34eec5b716abd2b2cd7676760a7fc2cc77bffbdd1ffef0870ca4cfb22ddac5831964b7b5420687911532b0a2aed0b817df5aac4acb36bbb9b9994c2625bfc5e59d77de59c8bfa498d1b22ddac5831964b7b5420687911532b0a2aed0b817df5aac4acb7e8cd3d3d3d96cc6a0301f7ffcf197bffc650612b0848b76c16006d96dad90c16164850caca82b34eec5b716abd2b21f697777b7cc47cde8064e8ae55cb48b0433c86e6b850c0e232b6460455da1712fbeb5589596fd48373737d3e9b4c0f7ba3c7bf66c011ebb3fb4e55cb48b0433c86e6b850c0e232b6460455da1712fbeb5589596fd78676767ebebeb0ccaf0c9279f3c79f28481842deda25d189841765b2b6470185921032bea0a8d7bf1adc5aab4ec2cf6f6f6f6f7f71914e0fbdffffe0f7ef0030612b6cc8b76316006d96dad90c16164850caca82b34eec5b716abd2b2b3b8b9b9c1a5fdf9f939e379d30d9c44cbbc6817036690ddd60a191c4656c8c08aba42e35e7c6bb12a2d3b17347ab47b347dc6f3a31b38e9967cd12e00cc20bbad1532388cac9081157585c6bdf8d662555a76462f5e63303f1f7cf0418dcfd99f0b2ddada6106d96dad90c16164850caca82b34eec5b716abd2b233c245fd6c369bfbaf2fadadadd5fbe71247a6455b3bcc20bbad1532388cac9081157585c6bdf8d662555a765e171717d3e9748e77723efdf4d3b7df7ebb845b4955d0a2ad1d6690ddd60a191c4656c8c08aba42e3deeaea6a753f58bbbaba42d90c96dbfefefedede1e83d1e906ce83c4cf44295f962eed30b2420656d4151af70e0e0e7677771954a2aebfe031b4f5f5f579ddc9f9dad7be86b96020f7899f8952be2c5dda6164850caca82b34ee9d9f9f4fa753069528f651017371797939994cc6bf91727d7dfdc61b6fe8064ebaf89928e5cbd2a51d4656c8c08aba42e38dd5d5559cb70c6a802f4ee5bcbbbc048787873b3b3b0cc6f2e1871f7eef7bdf632009ee3d13a57059bab4c3c80a1958515768bc717474b4bdbdcda07875553b9ad96c36f2cf5dde7df7dde3e3630692e0de33510a97a54b3b8cac9081157585c6dbb6b6b6aa386fe775bfa27c3832f87667b4efcf7403c720e54c949265e9d20e232b6460452d381b5756561884e1d45d5f5fdfdbdb2bf9ecc5153d1abdeede848cf91dcf8f7ffce36f7deb5b0c244def192a15c9d2a51d4656c8c08a5a1ef49695fdfd7d74fc172f5ee05f15f2e0dcabababd3d35394b4b1b1814656d7cf15c687a334ce6f363d7ffe1c5f5a1848022c5dbd51b87659bab4c3c80a195851cb435718ae9ad158f1e501ffca57355f2863369ba124fd72660aff9b07433f3b018beaadb7ded2d7dd07d11b8517003a12bbad956f6b83f47a984c2605fe750b190ebe011af4a25b37700c4a7b12b51864e9d20e232b6460455df3fdd54a990b5c420ef7c3f6e9747a7878c84012dc14ffa7e12545962eed30b242065674c7f86fc893f9427341bbdfdddd1de287ed6fbef9e6d5d515034930f4775a328e2c5dda6164850cace80eff86bcb93f1351467670708079cffb651e39df7bef3d069200df58eb4efd62c8d2a51d4656c8c08afa5c5c5cf877553296e58079c777756b6b6be83859ee21e8064ebae6a42bf9adcc922e4b9776185921032b0ac3098fdd70e66f6c6ce0a47dfd69451e606565851f4900ce2f7c7dc5819a4c26fa667a916072d96dadfc0a19a3d77bb8be3b3939d12f252d215c609ebea6e7530e07c7164758d7f28b274b9776185921032b121191dcb2746987911532b0221111c92d4b9776185921032b121191dcb2746987911532b0221111c92d4b9776185921032b121191dcb2746987911532b0221111c92d4b9776185921032b121191dcb2746987911532b0221111c92d4b9776185921032b121191dcb2746987911532b0221111c92d4b9776185921032b121191dcb2746987911532b0221111c92d4b9776185921032b121191dcb2746987911532b0a2ae029f5d8c92589c884825d0bbd86dad7c031caad787c647d62ea390924444d265e9d20e232b6460455da1f191b5cb28a42411917459bab4c3c80a19585157687c64ed320a294944245d962eed30b2420656d4d58cbf78f1c27f00f878b4d07fd02e2f54aa8848b1b2746987911532b0a2ae66bcdd8247a35e2f228b214b9776185921032bea0a8d8fac5d4621258988a4cbd2a51d4656c8c08aba42e3236b975148492222e9b2746987911532b0a2aed0f8c8da651452928848ba2c5dda6164850caca8ab19d7fd7a1111b32c5dda6164850caca8ab1957af171131cbd2a51d4656c8c08aba42e3236b975148492222e9b2746987911532b0a2aed0f8c8da651452928848ba2c5dda6164850caca82b343eb2761985942422922e4b9776185921032bea6ac675bf5e44c42c4b9776185921032bea6ac6d5eb4544ccb2746987911532b0a2aed0f8c8da651452928848ba2c5dda6164850caca82b343eb2761985942422922e4b9776185921032bea0a8d8fac5d4621258988a4cbd2a51d4656c8c08aba9a71ddaf171131cbd2a51d4656c8c08aba9a71f57a1111b32c5dda6164850caca82b343eb2761985942422922e4b9776185921032bea0a8d8fac5d4621258988a4cbd2a51d4656c8c08aba42e3236b975148492222e9b2746987911532b0a2ae665cf7eb4544ccb2746987911532b0a2ae665cbd5e44c42c4b9776185921032bea0a8d8fac5d4621258988a4cbd2a51d4656c8c08aba42e3236b975148492222e9b2746987911532b0a2aed0f8c8da651452928848ba2c5dda6164850caca8ab19d7fd7a1111b32c5dda6164850caca8ab1957af171131cbd2a51d4656c8c08aba42e3236b975148492222e9b2746987911532b0a2aed0f8c8da651452928848ba2c5dda6164850caca82b343eb2761985942422922e4b9776185921032bea6ac675bf5e44c42c4b9776185921032bea6ac6d5eb4544ccb2746987911532b0a2aed0f8c8da651452928848ba2c5dda6164850caca82b343eb27619eed57eee73b3d9ece0e0804322226543d762b7b5f2ad6fe9aeeb4f4f4f777777d7d7d72f2f2ffdb88848b1b2746987911532b0a2ae66bcccfbf5676767d3e9f4e6e686b1884891b2746987911532b0a2ae66bcd89fcd629fb9d42622922e4b9776185921032bea0a8d8fac5dc6ad927051bfb2b2c24044a44859bab4c3c80a19585157687c64ed32ee96349d4ecfcfcf19888894274b9776185921032bea0a8d8fac5dc6dd92b6b6b68e8f8f19888894274b9776185921032bea6ac6e7724fbcf9a4edf2ee96bab6b6a677e38848c9b2746987911532b0a2ae66bcd85e7f7575f5f4e95306222245cad2a51d4656c8c08aba42e3236b9771aba4edededa3a32306222245cad2a51d4656c8c08aba42e3236b97d1fef8f0f070636383818848a9b2746987911532b0a2aed0f8c8da65e0e3b3b3b3838383f5f5f59d9d1dfd229588942f4b9776185921032bea6ac68bba5f8f2ebfbbbb8b8ecf211191b265e9d20e232b6460455dcd78b13f9b1511295f962eed30b2420656d4151a1f59bb8c424a12114997a54b3b8cac9081157585c647d62ea390924444d265e9d20e232b6460455da1f191b5cb28a42411917459bab4c3c80a1958515733aefbf522226659bab4c3c80a1958515733ae5e2f226296a54b3b8cac9081157585c647d62ea390924444d265e9d20e232b6460455da1f191b5cb28a42411917459bab4c3c80a19585157687c64ed320a294944245d962eed30b2420656d4d58ceb7ebd888859962eed30b2420656d4d58cabd78b889865e9d20e232b6460455da1f191b5cb28a42411917459bab4c3c80a19585157687c64ed320a294944245d962eed30b2420656d4151a1f59bb8c424a12114997a54b3b8cac9081157535e3ba5f2f226296a54b3b8cac9081157535e3eaf522226659bab4c3c80a19585157687c64ed320a294944245d962eed30b2420656d4151a1f59bb8c424a12114997a54b3b8cac9081157585c647d62ea390924444d265e9d20e232b6460455dcdb8eed78b889865e9d20e232b6460455dcdb87abd888859962eed30b2420656d4151a1f59bb8c424a12114997a54b3b8cac9081157585c647d62ea390924444d265e9d20e232b6460455da1f191b5cb28a42411917459bab4c3c80a1958515733aefbf522226659bab4c3c80a1958515733ae5e2f226296a54b3b8cac9081157585c647d62ea390924444d265e9d20e232b6460455da1f191b5cb28a42411917459bab4c3c80a19585157687c64ed320a294944245d962eed30b2420656d4d58ceb7ebd888859962eed30b2420656d4d58cabd78b889865e9d20e232b6460455d77c7d17fdb7d7fd070369bf98fdb65844a15112956962eed30b2420656d4151a1f59bb8c424a12114997a54b3b8cac9081157585c647d62ea390924444d265e9d20e232b6460455da1f191b5cb28a42411917459bab4c3c80a195851d7eaeaaacf5f0e94c4e244442a81dec56e6be51be050bd5e44441e2f4b9776185921032b121191dcb2746987911532b0221111c92d4b9776185921032b121191dcb2746987911532b0221111c92d4b97761859bdfdf6db4c240fd7fb6ea5e974ca49161917d61e576157816fab5b1e5ffad297d86dad988891c9c71f7ffcead52b06f27038fe3cc95a7a074546105a7b8f6c14f2487ff8c31ff89109a6cf61f4706af48f87e3cf93a9a577506404a1b5f7984621593ca6dd63fa1c460ff4dbdffe568dfef170fc7932b5f40e8a8c20b4f6cc8d4232c2e5353f7a204c9fc3e8217ef39bdf9c9c9c309047c0f1e7c9d4d23b283282d0dab3350ac90b97d7bffffdef193c04a6cf61944c8d3e231c7f9e4c2dbd83222308ad3d43a39021d8da3da6cf6194e657bffa951a7d4638fe3c995a7a074546105a7b0f6d14321cb4fbd3d3530669307d0ea30468f4bffce52f19480e38fe3c995a7a074546105a7b0f6a1432b49ffffce70f6af7983e87d17dd4e88780e3cf93a9e52ffee22ffcd4dca2f7dd4b2ea1f7d163ed718f2e6ce29295323ca8ddfbc94d9a42e4fdf5af7fcd40f2c1f1e7c9d4d23b08a17191877ae81ac33897ac14e317bff845e2f537a6cf6114f6d0ef17241d8e3f4fa696de41088d8b3cd443d718c6b964a52489b75b307d0ea30035fa41e1f8f3646ae91d84d7d3259207575557649c4b560a93d2ee5f4f78740a5fbd7af5bbdffd8e810c00c79f27534bef2084c6451eeaa16b0ce35cb2529e7bdf078fe97318dd617edfbea4c3f1e7c9d4d23b08a17191877ae81ac33897ac1429deee317d0ea32e35fa71e0f8f3646ae91d84d0b8c8433d748d619c4b564a1569f7983e8751d7231fab268970fc7932b5bcf1c61b7e6a6ed1df46975c42cf28c6dae31e5dd8c4252b050b3d8fd24f6ecf14aad18f06c79f27534befa0c808426bafb75148817adb3da6cf61f41935fa31e1f8f3646ae91d14194168eddd6d1452acbb8fc3c4f4398c5efbe31fffc88f641438fe3c995a7a074546105a7bb71a8514eed6253ba6cf61a4463f0f38fe3c995a7a074546105a7bed46215568b77b4c9fe30335fab9c0f1e7c9d4d23b283282d0da6b1a8554a469f7983ea73d2423c3f1e7c9d4d23b283282d0daf38d42aae32fe2317d8e1afd1ce1f8f3646ae91d14194168ed619c4b566a83768fe9fbdc9b6fbee9fe2773f2f9cf7f9e1fb5e87df4322fa1f7ddf72e54a9c59ffff99fffff6abdd5e0f27061d80000000049454e44ae426082);
-- --------------------------------------------------------
--
-- Table structure for table `ponto_acesso`
--
CREATE TABLE IF NOT EXISTS `ponto_acesso` (
`id_pontoAcesso` int(11) NOT NULL AUTO_INCREMENT,
`bssid` varchar(50) NOT NULL,
`ssid` varchar(50) NOT NULL,
`n` double NOT NULL,
`nivelD0` int(11) NOT NULL,
`id_coordenadas` int(11) DEFAULT NULL,
PRIMARY KEY (`id_pontoAcesso`),
UNIQUE KEY `id_coordenada` (`id_coordenadas`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;
--
-- Dumping data for table `ponto_acesso`
--
INSERT INTO `ponto_acesso` (`id_pontoAcesso`, `bssid`, `ssid`, `n`, `nivelD0`, `id_coordenadas`) VALUES
(51, '00:26:5b:3a:33:f9', 'FON_ZON_FREE_INTERNET', 0, 0, NULL),
(53, '00:21:29:77:bd:1e', 'Teste', 5.315084951819779, -22, 282),
(54, '00:1b:11:3d:1f:66', 'MIGUEL', 8.63701304670714, -18, 281),
(56, '00:26:5b:3a:33:f8', 'ZON-33F0', 0, 0, NULL),
(57, '00:22:15:00:10:ff', 'Abreus Home', 0, 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `sinal`
--
CREATE TABLE IF NOT EXISTS `sinal` (
`id_coordenadas` int(11) NOT NULL,
`id_pontoAcesso` int(11) NOT NULL,
`frequencia` int(11) NOT NULL,
`nivel` int(11) NOT NULL,
`data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id_coordenadas`,`id_pontoAcesso`),
KEY `id_pontoAcesso` (`id_pontoAcesso`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sinal`
--
INSERT INTO `sinal` (`id_coordenadas`, `id_pontoAcesso`, `frequencia`, `nivel`, `data`) VALUES
(287, 53, 2462, -58, '2013-08-14 17:41:47'),
(287, 54, 2437, -62, '2013-08-14 17:41:46'),
(287, 57, 2437, -75, '2013-08-14 17:41:46'),
(288, 53, 2462, -65, '2013-08-14 17:45:11'),
(288, 54, 2437, -59, '2013-08-14 17:45:11'),
(288, 57, 2437, -72, '2013-08-14 17:45:11');
--
-- Constraints for dumped tables
--
--
-- Constraints for table `ponto_acesso`
--
ALTER TABLE `ponto_acesso`
ADD CONSTRAINT `ponto_acesso_ibfk_1` FOREIGN KEY (`id_coordenadas`) REFERENCES `coordenadas` (`id_coordenadas`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `sinal`
--
ALTER TABLE `sinal`
ADD CONSTRAINT `sinal_ibfk_1` FOREIGN KEY (`id_pontoAcesso`) REFERENCES `ponto_acesso` (`id_pontoAcesso`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `sinal_ibfk_2` FOREIGN KEY (`id_coordenadas`) REFERENCES `coordenadas` (`id_coordenadas`) ON DELETE CASCADE ON UPDATE CASCADE;
/*!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 */;