-- SQL MBTILES
CREATE TABLE metadata (name text, value text);
INSERT INTO "metadata" VALUES('name','point_polygon.mbtiles');
INSERT INTO "metadata" VALUES('description','point_polygon.mbtiles');
INSERT INTO "metadata" VALUES('version','2');
INSERT INTO "metadata" VALUES('minzoom','0');
INSERT INTO "metadata" VALUES('maxzoom','1');
INSERT INTO "metadata" VALUES('center','-1.000000,42.525564,1');
INSERT INTO "metadata" VALUES('bounds','-1.000000,-4.000000,4.000000,49.000000');
INSERT INTO "metadata" VALUES('type','overlay');
INSERT INTO "metadata" VALUES('format','pbf');
INSERT INTO "metadata" VALUES('json','{"vector_layers": [ { "id": "point", "description": "", "minzoom": 0, "maxzoom": 1, "fields": {} }, { "id": "polygon2", "description": "", "minzoom": 0, "maxzoom": 1, "fields": {"": "String"} } ],"tilestats": {"layerCount": 2,"layers": [{"layer": "point","count": 1,"geometry": "Point","attributeCount": 0,"attributes": []},{"layer": "polygon2","count": 1,"geometry": "Polygon","attributeCount": 1,"attributes": [{"attribute": "","count": 1,"type": "string","values": [""]}]}]}}');
CREATE TABLE tiles (zoom_level integer, tile_column integer, tile_row integer, tile_data blob);
INSERT INTO "tiles" VALUES(0,0,0,X'1F8B08000000000002039312AF60E2622DC8CFCC2BD1685010E294605462E55CA3F04754CA1B28C151909F53999E9F67049493625062E262103291601662626050D2E1BCA5B044DE8A611B63240383AE0E0343A43690E6E764709162D0130733F578A418C4B8191844F901670F28AB66000000');
INSERT INTO "tiles" VALUES(1,0,0,X'1F8B080000000000020393F2AD60E2E228C8CFA94CCFCF33D2685090625062E262103293601662626050D2E35CE0389FD18AE11AD37C460686E8280686AD8C910C0CCEFC9C0C45520C51BA0C0C91FC9C5162520C7AA20C0CBAFC006F0E5DB54F000000');
INSERT INTO "tiles" VALUES(1,1,0,X'1F8B080000000000020393F2AD60E2E228C8CFA94CCFCF33D2685090625062E262103293601662626050D2E3DCC6389FD18AE11AD356460686E8280686AD8C910C0CCEFC9C0C45520C51BA0C0C91FC9C5162520C7AA20C0CBAFC007E53E8BB4F000000');
INSERT INTO "tiles" VALUES(1,1,1,X'1F8B08000000000002039312AB60E2622DC8CFCC2BD1685010E290605462E18CFAA52DE50714E728C8CFA94CCFCF33024A49312831713108994B300B31313028E9736E633C6167C57083692B2303836B1403C356C6480686687E4E862E462986285D0686487ECE283129063D5106065D7E000A58525F68000000');
INSERT INTO "tiles" VALUES(1,0,1,X'1F8B08000000000002039312AF60E2622DC8CFCC2BD1685010E294605462E5BCE5F04B5BCA0F28C151909F53999E9F67049493625062E262103297601662626050D2E75CE078C2CE8AE106D37C460606D7280686AD8C910C0CD1FC9C0C5D8C520C51BA0C0C91FC9C5162520C7AA20C0CBAFC00C96A5E0169000000');
