2vYX4k9S

1DROP TABLE IF EXISTS gym;
2CREATE TABLE gym (gym_id VARCHAR(50) NOT NULL PRIMARY KEY, team_id INTEGER NOT NULL, guard_pokemon_id INTEGER NOT NULL, gym_points INTEGER NOT NULL, enabled INTEGER NOT NULL, latitude REAL NOT NULL, longitude REAL NOT NULL, last_modified DATETIME NOT NULL, last_scanned DATETIME NOT NULL);
3INSERT INTO gym VALUES('495089ccdea84b109f9104f8fbdc52f2.16',1,134,14043,1,29.997703,-95.58127,'2016-09-07 02:34:45.690000','2016-09-07 04:05:15.776000');
4INSERT INTO gym VALUES('17d2ef8d0c734673b9d22152d35bfdf2.16',3,149,52000,1,30.012216,-95.585698,'2016-09-06 15:29:48.873000','2016-09-07 04:05:15.776000');
5INSERT INTO gym VALUES('38b22bda09f7435eb7c8c7339c1cc87e.16',3,103,14129,1,30.011373,-95.58549,'2016-09-07 01:46:12.518000','2016-09-07 04:05:27.124000');
6INSERT INTO gym VALUES('6ef8563046ac48abb83cf38c8914a73a.16',1,149,52000,1,29.991091,-95.619141,'2016-09-06 01:07:40.654000','2016-09-07 04:06:24.280000');
7INSERT INTO gym VALUES('5b3c0e198d324176a520252ccbf24b18.16',3,149,42004,1,30.01302,-95.588227,'2016-09-06 23:34:31.917000','2016-09-07 04:07:02.506000');
8INSERT INTO gym VALUES('29318c1d5e0144a5a4411c702b71b501.16',2,149,21770,1,30.022234,-95.603785,'2016-09-06 22:32:49.372000','2016-09-07 04:07:02.507000');
9INSERT INTO gym VALUES('eed6cfab9ba14a1c880a76dd025bfa9e.16',3,103,4000,1,29.998245,-95.589777,'2016-09-07 03:58:42.985000','2016-09-07 04:07:15.609000');
10INSERT INTO gym VALUES('21d39a3ab66b4762a092a7a333bce5a6.16',2,143,6000,1,30.008269,-95.588707,'2016-09-07 03:50:33.212000','2016-09-07 04:07:15.610000');
11INSERT INTO gym VALUES('1ae199f7186a49a7bf5d2a9b5a4c020c.16',1,130,52000,1,29.993457,-95.625497,'2016-09-06 12:43:08.159000','2016-09-07 04:07:20.404000');
12INSERT INTO gym VALUES('24ccc8c5f143440182363d46bad7c2c3.16',1,143,52000,1,29.995628,-95.614789,'2016-09-07 02:03:02.147000','2016-09-07 04:07:20.404000');
13INSERT INTO gym VALUES('005f3486a4624b42a4ef720e791921b7.16',3,134,4000,1,30.004084,-95.590999,'2016-09-07 03:52:26.052000','2016-09-07 04:07:57.581000');
14INSERT INTO gym VALUES('3da443fb77da41feb9b40dd92915f732.16',1,103,6232,1,30.012218,-95.599777,'2016-09-07 01:32:46.978000','2016-09-07 04:07:57.581000');
15INSERT INTO gym VALUES('458590107ffc4dbaa9a79984cfe72960.16',2,131,22055,1,30.015319,-95.597116,'2016-09-04 05:30:42.009000','2016-09-07 04:07:57.581000');
16INSERT INTO gym VALUES('b3385aa7c8fb4caeb3f7bb9732fd7796.16',2,134,6000,1,30.008056,-95.600499,'2016-09-06 03:39:03.916000','2016-09-07 04:08:02.123000');
17INSERT INTO gym VALUES('30ace38accc5471890c7ac644a3d1dda.16',3,143,4000,1,29.996303,-95.604988,'2016-09-07 04:05:40.598000','2016-09-07 04:08:02.123000');
18INSERT INTO gym VALUES('af4f0b776d6f425cb18b887bede7f237.16',1,103,21685,1,30.012981,-95.617149,'2016-09-07 00:08:16.338000','2016-09-07 04:08:10.785000');
19INSERT INTO gym VALUES('acd2af60bedf4401b7e491c6c88c3fe6.16',2,130,33219,1,30.014926,-95.604469,'2016-09-07 01:52:43.382000','2016-09-07 04:08:10.785000');
20INSERT INTO gym VALUES('24da0f1455734d1287c1bb308f42383c.16',1,103,6000,1,30.020799,-95.618084,'2016-09-07 03:25:06.458000','2016-09-07 04:08:10.785000');
21INSERT INTO gym VALUES('30f45eb19b6548d088c9621ba27185e8.16',1,149,52000,1,30.011955,-95.610833,'2016-09-06 00:46:04.740000','2016-09-07 04:08:10.785000');