summaryrefslogtreecommitdiffstats
path: root/tests/manual/declarative-location/visual/landmarks.db
blob: e3fb33ac7f70ab74ff232b2ed53491792c899cfc (plain)
ofshex dumpascii
0000 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 04 00 01 01 00 40 20 20 00 00 00 0c 00 00 00 00 SQLite.format.3......@..........
0020 00 00 00 00 00 00 00 00 00 00 00 10 00 00 00 01 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................................
0040 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0060 00 00 00 00 05 00 00 00 05 03 e7 00 00 00 00 16 03 fb 03 f6 03 f1 03 ec 03 e7 00 00 00 00 00 00 ................................
0080 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
00a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
00e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0140 00 00 00 00 43 07 06 17 57 31 01 00 69 6e 64 65 78 73 71 6c 69 74 65 5f 61 75 74 6f 69 6e 64 65 ....C...W1..indexsqlite_autoinde
0160 78 5f 63 61 74 65 67 6f 72 79 5f 61 74 74 72 69 62 75 74 65 5f 31 63 61 74 65 67 6f 72 79 5f 61 x_category_attribute_1category_a
0180 74 74 72 69 62 75 74 65 08 60 05 07 17 1d 1d 01 81 13 74 61 62 6c 65 63 61 74 65 67 6f 72 79 63 ttribute.`........tablecategoryc
01a0 61 74 65 67 6f 72 79 06 43 52 45 41 54 45 20 54 41 42 4c 45 20 63 61 74 65 67 6f 72 79 20 28 0a ategory.CREATE.TABLE.category.(.
01c0 20 20 20 20 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 2c 0a 20 20 20 20 ....id.INTEGER.PRIMARY.KEY,.....
01e0 6e 61 6d 65 20 54 45 58 54 0a 29 81 5e 03 07 17 31 31 01 82 67 74 61 62 6c 65 6c 61 6e 64 6d 61 name.TEXT.).^...11..gtablelandma
0200 72 6b 5f 61 74 74 72 69 62 75 74 65 6c 61 6e 64 6d 61 72 6b 5f 61 74 74 72 69 62 75 74 65 04 43 rk_attributelandmark_attribute.C
0220 52 45 41 54 45 20 54 41 42 4c 45 20 6c 61 6e 64 6d 61 72 6b 5f 61 74 74 72 69 62 75 74 65 28 0a REATE.TABLE.landmark_attribute(.
0240 20 20 20 20 6c 61 6e 64 6d 61 72 6b 49 44 20 49 4e 54 45 47 45 52 2c 0a 20 20 20 20 6b 65 79 20 ....landmarkID.INTEGER,.....key.
0260 54 45 58 54 2c 0a 20 20 20 20 76 61 6c 75 65 20 42 4c 4f 42 2c 0a 20 20 20 20 50 52 49 4d 41 52 TEXT,.....value.BLOB,.....PRIMAR
0280 59 20 4b 45 59 28 6c 61 6e 64 6d 61 72 6b 49 64 2c 6b 65 79 29 2c 0a 20 20 20 20 46 4f 52 45 49 Y.KEY(landmarkId,key),.....FOREI
02a0 47 4e 20 4b 45 59 28 6c 61 6e 64 6d 61 72 6b 49 64 29 20 52 45 46 45 52 45 4e 43 45 53 20 6c 61 GN.KEY(landmarkId).REFERENCES.la
02c0 6e 64 6d 61 72 6b 28 69 64 29 0a 29 43 04 06 17 57 31 01 00 69 6e 64 65 78 73 71 6c 69 74 65 5f ndmark(id).)C...W1..indexsqlite_
02e0 61 75 74 6f 69 6e 64 65 78 5f 6c 61 6e 64 6d 61 72 6b 5f 61 74 74 72 69 62 75 74 65 5f 31 6c 61 autoindex_landmark_attribute_1la
0300 6e 64 6d 61 72 6b 5f 61 74 74 72 69 62 75 74 65 05 00 00 00 04 81 1a 02 07 17 1d 1d 01 82 07 74 ndmark_attribute...............t
0320 61 62 6c 65 6c 61 6e 64 6d 61 72 6b 6c 61 6e 64 6d 61 72 6b 03 43 52 45 41 54 45 20 54 41 42 4c ablelandmarklandmark.CREATE.TABL
0340 45 20 6c 61 6e 64 6d 61 72 6b 20 28 0a 20 20 20 20 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d E.landmark.(.....id.INTEGER.PRIM
0360 41 52 59 20 4b 45 59 2c 0a 20 20 20 20 6e 61 6d 65 20 54 45 58 54 2c 0a 20 20 20 20 6c 61 74 69 ARY.KEY,.....name.TEXT,.....lati
0380 74 75 64 65 20 52 45 41 4c 2c 0a 20 20 20 20 6c 6f 6e 67 69 74 75 64 65 20 52 45 41 4c 2c 0a 20 tude.REAL,.....longitude.REAL,..
03a0 20 20 20 61 6c 74 69 74 75 64 65 20 52 45 41 4c 0a 29 4c 01 06 17 1b 1b 01 71 74 61 62 6c 65 76 ...altitude.REAL.)L......qtablev
03c0 65 72 73 69 6f 6e 76 65 72 73 69 6f 6e 02 43 52 45 41 54 45 20 54 41 42 4c 45 20 76 65 72 73 69 ersionversion.CREATE.TABLE.versi
03e0 6f 6e 20 28 0a 20 20 00 00 00 13 13 00 00 00 12 11 00 00 00 11 0f 00 00 00 0c 0d 00 00 00 09 07 on.(............................
0400 0d 00 00 00 00 04 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0420 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0440 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0460 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0480 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
04a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
04c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
04e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0500 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0520 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0540 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0560 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0580 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
05a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
05c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
05e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0600 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0620 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0640 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0660 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0680 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
06a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
06c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
06e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0700 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0720 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0740 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0760 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0780 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
07a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
07c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
07e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0800 0d 00 00 00 07 03 85 00 03 ea 03 d8 03 c8 03 b8 03 a9 03 9a 03 85 00 00 00 00 00 00 00 00 00 00 ................................
0820 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0840 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0860 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0880 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
08a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
08c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
08e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0900 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0920 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0940 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0960 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0980 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
09a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
09c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
09e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0a00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0a20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0a40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0a60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0a80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0aa0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0ac0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0ae0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0b00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0b20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0b40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0b60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
0b80 00 00 00 00 00 13 07 06 00 23 01 01 00 4f 70 65 72 61 20 48 6f 75 73 65 3c 3c 0d 06 06 00 17 01 .........#...Opera.House<<......
0ba0 01 00 54 6f 77 65 72 47 47 0d 05 06 00 17 01 01 00 54 6f 77 65 72 14 14 0e 04 06 00 19 01 01 00 ..TowerGG........Tower..........
0bc0 4c 6f 6e 64 6f 6e 46 46 0e 03 06 00 19 01 01 00 53 79 64 6e 65 79 3c 3c 10 02 06 00 1d 01 01 00 LondonFF........Sydney<<........
0be0 42 72 69 73 62 61 6e 65 32 32 14 01 06 00 29 00 00 00 41 6c 70 68 61 20 63 65 6e 74 61 75 72 69 Brisbane22....)...Alpha.centauri
0c00 05 00 00 00 01 03 fb 00 00 00 00 18 03 fb 03 b9 03 ab 03 9f 03 92 03 87 03 78 03 6b 03 5c 03 4a .........................x.k.\.J
0c20 03 40 03 2e 03 20 03 0b 02 f9 02 eb 02 df 02 d2 02 c7 02 b8 02 ab 02 9c 02 8a 02 80 02 6e 02 60 [email protected].`
0c40 02 4b 02 39 02 2b 02 1f 02 12 02 07 01 f8 01 eb 01 dc 01 ca 01 c0 01 ae 01 a0 01 8b 01 79 01 6b .K.9.+.......................y.k
0c60 01 5f 01 52 01 47 01 38 01 2b 01 1c 01 0a 01 00 00 ee 00 e0 00 cb 00 b9 00 ab 00 9f 00 92 00 87 ._.R.G.8.+......................
0c80 00 00 00 00 00 00 00 09 3c 04 01 15 00 05 63 69 74 79 0b 3b 04 01 19 00 05 63 6f 75 6e 74 79 0a ........<.....city.;.....county.
0ca0 3a 04 01 17 00 05 73 74 61 74 65 0c 39 04 01 1b 00 05 63 6f 75 6e 74 72 79 10 38 04 01 23 00 05 :.....state.9.....country.8..#..
0cc0 63 6f 75 6e 74 72 79 43 6f 64 65 13 37 04 01 19 07 05 72 61 64 69 75 73 00 00 00 00 00 00 00 00 countryCode.7.....radius........
0ce0 0c 36 04 01 1b 0d 05 69 63 6f 6e 55 72 6c 10 35 04 01 23 00 05 64 65 73 63 72 69 70 74 69 6f 6e .6.....iconUrl.5..#..description
0d00 08 34 04 01 13 0d 04 75 72 6c 10 33 04 01 23 00 04 70 68 6f 6e 65 4e 75 6d 62 65 72 0d 32 04 01 .4.....url.3..#..phoneNumber.2..
0d20 1d 00 04 70 6f 73 74 63 6f 64 65 0b 31 04 01 19 00 04 73 74 72 65 65 74 0d 30 04 01 1d 00 04 64 ...postcode.1.....street.0.....d
0d40 69 73 74 72 69 63 74 09 2f 04 01 15 00 04 63 69 74 79 0b 2e 04 01 19 00 04 63 6f 75 6e 74 79 0a istrict./.....city.......county.
0d60 2d 04 01 17 00 04 73 74 61 74 65 0c 2c 04 01 1b 00 04 63 6f 75 6e 74 72 79 10 2b 04 01 23 00 04 -.....state.,.....country.+..#..
0d80 63 6f 75 6e 74 72 79 43 6f 64 65 13 2a 04 01 19 07 04 72 61 64 69 75 73 00 00 00 00 00 00 00 00 countryCode.*.....radius........
0da0 0c 29 04 01 1b 0d 04 69 63 6f 6e 55 72 6c 10 28 04 01 23 00 04 64 65 73 63 72 69 70 74 69 6f 6e .).....iconUrl.(..#..description
0dc0 08 27 04 01 13 0d 03 75 72 6c 10 26 04 01 23 00 03 70 68 6f 6e 65 4e 75 6d 62 65 72 0d 25 04 01 .'.....url.&..#..phoneNumber.%..
0de0 1d 00 03 70 6f 73 74 63 6f 64 65 0b 24 04 01 19 00 03 73 74 72 65 65 74 0d 23 04 01 1d 00 03 64 ...postcode.$.....street.#.....d
0e00 69 73 74 72 69 63 74 09 22 04 01 15 00 03 63 69 74 79 0b 21 04 01 19 00 03 63 6f 75 6e 74 79 0a istrict.".....city.!.....county.
0e20 20 04 01 17 00 03 73 74 61 74 65 0c 1f 04 01 1b 00 03 63 6f 75 6e 74 72 79 10 1e 04 01 23 00 03 ......state.......country....#..
0e40 63 6f 75 6e 74 72 79 43 6f 64 65 13 1d 04 01 19 07 03 72 61 64 69 75 73 00 00 00 00 00 00 00 00 countryCode.......radius........
0e60 0c 1c 04 01 1b 0d 03 69 63 6f 6e 55 72 6c 10 1b 04 01 23 00 03 64 65 73 63 72 69 70 74 69 6f 6e .......iconUrl....#..description
0e80 08 1a 04 01 13 0d 02 75 72 6c 10 19 04 01 23 00 02 70 68 6f 6e 65 4e 75 6d 62 65 72 0d 18 04 01 .......url....#..phoneNumber....
0ea0 1d 00 02 70 6f 73 74 63 6f 64 65 0b 17 04 01 19 00 02 73 74 72 65 65 74 0d 16 04 01 1d 00 02 64 ...postcode.......street.......d
0ec0 69 73 74 72 69 63 74 09 15 04 01 15 00 02 63 69 74 79 0b 14 04 01 19 00 02 63 6f 75 6e 74 79 0a istrict.......city.......county.
0ee0 13 04 01 17 00 02 73 74 61 74 65 0c 12 04 01 1b 00 02 63 6f 75 6e 74 72 79 10 11 04 01 23 00 02 ......state.......country....#..
0f00 63 6f 75 6e 74 72 79 43 6f 64 65 13 10 04 01 19 07 02 72 61 64 69 75 73 00 00 00 00 00 00 00 00 countryCode.......radius........
0f20 0c 0f 04 01 1b 0d 02 69 63 6f 6e 55 72 6c 10 0e 04 01 23 00 02 64 65 73 63 72 69 70 74 69 6f 6e .......iconUrl....#..description
0f40 08 0d 04 01 13 0d 01 75 72 6c 10 0c 04 01 23 00 01 70 68 6f 6e 65 4e 75 6d 62 65 72 0d 0b 04 01 .......url....#..phoneNumber....
0f60 1d 00 01 70 6f 73 74 63 6f 64 65 0b 0a 04 01 19 00 01 73 74 72 65 65 74 0d 09 04 01 1d 00 01 64 ...postcode.......street.......d
0f80 69 73 74 72 69 63 74 09 08 04 01 15 00 01 63 69 74 79 0b 07 04 01 19 00 01 63 6f 75 6e 74 79 0a istrict.......city.......county.
0fa0 06 04 01 17 00 01 73 74 61 74 65 0c 05 04 01 1b 00 01 63 6f 75 6e 74 72 79 10 04 04 01 23 00 01 ......state.......country....#..
0fc0 63 6f 75 6e 74 72 79 43 6f 64 65 13 03 04 01 19 07 01 72 61 64 69 75 73 00 00 00 00 00 00 00 00 countryCode.......radius........
0fe0 0c 02 04 01 1b 0d 01 69 63 6f 6e 55 72 6c 10 01 04 01 23 00 01 64 65 73 63 72 69 00 00 00 17 3c .......iconUrl....#..descri....<
1000 02 00 00 00 01 03 ed 00 00 00 00 1a 03 ed 03 9a 03 ee 03 80 03 e0 03 52 03 64 03 d3 03 a7 03 73 .......................R.d.....s
1020 03 48 02 d7 02 fb 03 09 02 e2 03 36 02 c8 03 28 02 9a 02 ac 03 1b 02 ef 02 bb 02 90 02 1f 02 43 .H.........6...(...............C
1040 02 51 02 2a 02 7e 02 10 02 70 01 e2 01 f4 02 63 02 37 02 03 01 d8 01 67 01 8b 01 99 01 72 01 c6 .Q.*.~...p.....c.7.....g.....r..
1060 01 58 01 b8 01 2a 01 3c 01 ab 01 7f 01 4b 01 20 00 af 00 d3 00 e1 00 ba 01 0e 00 a0 01 00 00 f3 .X...*.<.....K..................
1080 00 c7 00 93 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0c 04 01 19 01 05 73 74 72 65 65 74 3e .........................street>
10a0 0e 04 01 1d 01 05 64 69 73 74 72 69 63 74 3d 0a 04 01 15 01 05 63 69 74 79 3c 0c 04 01 19 01 05 ......district=......city<......
10c0 63 6f 75 6e 74 79 3b 0b 04 01 17 01 05 73 74 61 74 65 3a 0d 04 01 1b 01 05 63 6f 75 6e 74 72 79 county;......state:......country
10e0 39 11 04 01 23 01 05 63 6f 75 6e 74 72 79 43 6f 64 65 38 0c 04 01 19 01 05 72 61 64 69 75 73 37 9...#..countryCode8......radius7
1100 0d 04 01 1b 01 05 69 63 6f 6e 55 72 6c 36 11 04 01 23 01 05 64 65 73 63 72 69 70 74 69 6f 6e 35 ......iconUrl6...#..description5
1120 09 04 01 13 01 04 75 72 6c 34 11 04 01 23 01 04 70 68 6f 6e 65 4e 75 6d 62 65 72 33 0e 04 01 1d ......url4...#..phoneNumber3....
1140 01 04 70 6f 73 74 63 6f 64 65 32 0c 04 01 19 01 04 73 74 72 65 65 74 31 0e 04 01 1d 01 04 64 69 ..postcode2......street1......di
1160 73 74 72 69 63 74 30 0a 04 01 15 01 04 63 69 74 79 2f 0c 04 01 19 01 04 63 6f 75 6e 74 79 2e 0b strict0......city/......county..
1180 04 01 17 01 04 73 74 61 74 65 2d 0d 04 01 1b 01 04 63 6f 75 6e 74 72 79 2c 11 04 01 23 01 04 63 .....state-......country,...#..c
11a0 6f 75 6e 74 72 79 43 6f 64 65 2b 0c 04 01 19 01 04 72 61 64 69 75 73 2a 0d 04 01 1b 01 04 69 63 ountryCode+......radius*......ic
11c0 6f 6e 55 72 6c 29 11 04 01 23 01 04 64 65 73 63 72 69 70 74 69 6f 6e 28 09 04 01 13 01 03 75 72 onUrl)...#..description(......ur
11e0 6c 27 11 04 01 23 01 03 70 68 6f 6e 65 4e 75 6d 62 65 72 26 0e 04 01 1d 01 03 70 6f 73 74 63 6f l'...#..phoneNumber&......postco
1200 64 65 25 0c 04 01 19 01 03 73 74 72 65 65 74 24 0e 04 01 1d 01 03 64 69 73 74 72 69 63 74 23 0a de%......street$......district#.
1220 04 01 15 01 03 63 69 74 79 22 0c 04 01 19 01 03 63 6f 75 6e 74 79 21 0b 04 01 17 01 03 73 74 61 .....city"......county!......sta
1240 74 65 20 0d 04 01 1b 01 03 63 6f 75 6e 74 72 79 1f 11 04 01 23 01 03 63 6f 75 6e 74 72 79 43 6f te.......country....#..countryCo
1260 64 65 1e 0c 04 01 19 01 03 72 61 64 69 75 73 1d 0d 04 01 1b 01 03 69 63 6f 6e 55 72 6c 1c 11 04 de.......radius.......iconUrl...
1280 01 23 01 03 64 65 73 63 72 69 70 74 69 6f 6e 1b 09 04 01 13 01 02 75 72 6c 1a 11 04 01 23 01 02 .#..description.......url....#..
12a0 70 68 6f 6e 65 4e 75 6d 62 65 72 19 0e 04 01 1d 01 02 70 6f 73 74 63 6f 64 65 18 0c 04 01 19 01 phoneNumber.......postcode......
12c0 02 73 74 72 65 65 74 17 0e 04 01 1d 01 02 64 69 73 74 72 69 63 74 16 0a 04 01 15 01 02 63 69 74 .street.......district.......cit
12e0 79 15 0c 04 01 19 01 02 63 6f 75 6e 74 79 14 0b 04 01 17 01 02 73 74 61 74 65 13 0d 04 01 1b 01 y.......county.......state......
1300 02 63 6f 75 6e 74 72 79 12 11 04 01 23 01 02 63 6f 75 6e 74 72 79 43 6f 64 65 11 0c 04 01 19 01 .country....#..countryCode......
1320 02 72 61 64 69 75 73 10 0d 04 01 1b 01 02 69 63 6f 6e 55 72 6c 0f 11 04 01 23 01 02 64 65 73 63 .radius.......iconUrl....#..desc
1340 72 69 70 74 69 6f 6e 0e 09 04 01 13 01 01 75 72 6c 0d 11 04 01 23 01 01 70 68 6f 6e 65 4e 75 6d ription.......url....#..phoneNum
1360 62 65 72 0c 0e 04 01 1d 01 01 70 6f 73 74 63 6f 64 65 0b 0c 04 01 19 01 01 73 74 72 65 65 74 0a ber.......postcode.......street.
1380 0e 04 01 1d 01 01 64 69 73 74 72 69 63 74 09 0a 04 01 15 01 01 63 69 74 79 08 0c 04 01 19 01 01 ......district.......city.......
13a0 63 6f 75 6e 74 79 07 0b 04 01 17 01 01 73 74 61 74 65 06 0d 04 01 1b 01 01 63 6f 75 6e 74 72 79 county.......state.......country
13c0 05 11 04 01 23 01 01 63 6f 75 6e 74 72 79 43 6f 64 65 04 0c 04 01 19 01 01 72 61 64 69 75 73 03 ....#..countryCode.......radius.
13e0 0d 04 01 1b 01 01 69 63 6f 6e 55 72 6c 00 00 00 19 0e 04 01 1d 01 03 64 69 73 74 72 69 63 74 23 ......iconUrl..........district#
1400 0d 00 00 00 04 03 cc 00 03 ec 03 e2 03 d7 03 cc 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1420 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1440 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1460 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1480 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
14a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
14c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
14e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1500 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1520 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1540 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1560 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1580 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
15a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
15c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
15e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1600 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1620 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1640 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1660 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1680 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
16a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
16c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
16e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1700 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1720 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1740 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1760 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1780 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
17a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
17c0 00 00 00 00 00 00 00 00 00 00 00 00 09 04 03 00 19 53 69 67 68 74 73 09 03 03 00 19 43 69 74 69 .................Sights.....Citi
17e0 65 73 08 02 03 00 17 45 6d 70 74 79 12 01 03 00 2b 53 75 6e 73 68 69 6e 65 20 63 69 74 69 65 73 es.....Empty....+Sunshine.cities
1800 0d 00 00 00 04 03 c8 00 03 f2 03 e4 03 d6 03 c8 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1820 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1840 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1860 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1880 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
18a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
18c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
18e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1900 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1920 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1940 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1960 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1980 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
19a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
19c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
19e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1a00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1a20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1a40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1a60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1a80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1aa0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1ac0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1ae0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1b00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1b20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1b40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1b60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1b80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1ba0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1bc0 00 00 00 00 00 00 00 00 0c 04 04 01 1b 0d 04 69 63 6f 6e 55 72 6c 0c 03 04 01 1b 0d 03 69 63 6f ...............iconUrl.......ico
1be0 6e 55 72 6c 0c 02 04 01 1b 0d 02 69 63 6f 6e 55 72 6c 0c 01 04 01 1b 0d 01 69 63 6f 6e 55 72 6c nUrl.......iconUrl.......iconUrl
1c00 0a 00 00 00 04 03 c8 00 03 f2 03 e4 03 d6 03 c8 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1c20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1c40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1c60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1c80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1ca0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1cc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1ce0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1d00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1d20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1d40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1d60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1d80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1da0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1dc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1de0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1e00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1e20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1e40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1e60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1e80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1ea0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1ec0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1ee0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1f00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1f20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1f40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1f60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1f80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1fa0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
1fc0 00 00 00 00 00 00 00 00 0d 04 01 1b 01 04 69 63 6f 6e 55 72 6c 04 0d 04 01 1b 01 03 69 63 6f 6e ..............iconUrl.......icon
1fe0 55 72 6c 03 0d 04 01 1b 01 02 69 63 6f 6e 55 72 6c 02 0d 04 01 1b 01 01 69 63 6f 6e 55 72 6c 01 Url.......iconUrl.......iconUrl.
2000 0d 00 00 00 07 00 65 00 00 65 00 b3 01 50 02 31 02 76 02 d8 03 bb 00 1e 00 1e 00 00 00 00 41 09 ......e..e...P.1.v............A.
2020 06 17 55 2f 01 00 69 6e 64 65 78 73 71 6c 69 74 65 5f 61 75 74 6f 69 6e 64 65 78 5f 6c 61 6e 64 ..U/..indexsqlite_autoindex_land
2040 6d 61 72 6b 5f 63 61 74 65 67 6f 72 79 5f 31 6c 61 6e 64 6d 61 72 6b 5f 63 61 74 65 67 6f 72 79 mark_category_1landmark_category
2060 0b 00 00 00 04 4c 01 06 17 1b 1b 01 71 74 61 62 6c 65 76 65 72 73 69 6f 6e 76 65 72 73 69 6f 6e .....L......qtableversionversion
2080 02 43 52 45 41 54 45 20 54 41 42 4c 45 20 76 65 72 73 69 6f 6e 20 28 0a 20 20 20 20 76 65 72 73 .CREATE.TABLE.version.(.....vers
20a0 69 6f 6e 4e 75 6d 62 65 72 20 49 4e 54 45 47 45 52 0a 29 81 1a 02 07 17 1d 1d 01 82 07 74 61 62 ionNumber.INTEGER.)..........tab
20c0 6c 65 6c 61 6e 64 6d 61 72 6b 6c 61 6e 64 6d 61 72 6b 03 43 52 45 41 54 45 20 54 41 42 4c 45 20 lelandmarklandmark.CREATE.TABLE.
20e0 6c 61 6e 64 6d 61 72 6b 20 28 0a 20 20 20 20 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 landmark.(.....id.INTEGER.PRIMAR
2100 59 20 4b 45 59 2c 0a 20 20 20 20 6e 61 6d 65 20 54 45 58 54 2c 0a 20 20 20 20 6c 61 74 69 74 75 Y.KEY,.....name.TEXT,.....latitu
2120 64 65 20 52 45 41 4c 2c 0a 20 20 20 20 6c 6f 6e 67 69 74 75 64 65 20 52 45 41 4c 2c 0a 20 20 20 de.REAL,.....longitude.REAL,....
2140 20 61 6c 74 69 74 75 64 65 20 52 45 41 4c 0a 29 81 5e 03 07 17 31 31 01 82 67 74 61 62 6c 65 6c .altitude.REAL.).^...11..gtablel
2160 61 6e 64 6d 61 72 6b 5f 61 74 74 72 69 62 75 74 65 6c 61 6e 64 6d 61 72 6b 5f 61 74 74 72 69 62 andmark_attributelandmark_attrib
2180 75 74 65 04 43 52 45 41 54 45 20 54 41 42 4c 45 20 6c 61 6e 64 6d 61 72 6b 5f 61 74 74 72 69 62 ute.CREATE.TABLE.landmark_attrib
21a0 75 74 65 28 0a 20 20 20 20 6c 61 6e 64 6d 61 72 6b 49 44 20 49 4e 54 45 47 45 52 2c 0a 20 20 20 ute(.....landmarkID.INTEGER,....
21c0 20 6b 65 79 20 54 45 58 54 2c 0a 20 20 20 20 76 61 6c 75 65 20 42 4c 4f 42 2c 0a 20 20 20 20 50 .key.TEXT,.....value.BLOB,.....P
21e0 52 49 4d 41 52 59 20 4b 45 59 28 6c 61 6e 64 6d 61 72 6b 49 64 2c 6b 65 79 29 2c 0a 20 20 20 20 RIMARY.KEY(landmarkId,key),.....
2200 46 4f 52 45 49 47 4e 20 4b 45 59 28 6c 61 6e 64 6d 61 72 6b 49 64 29 20 52 45 46 45 52 45 4e 43 FOREIGN.KEY(landmarkId).REFERENC
2220 45 53 20 6c 61 6e 64 6d 61 72 6b 28 69 64 29 0a 29 43 04 06 17 57 31 01 00 69 6e 64 65 78 73 71 ES.landmark(id).)C...W1..indexsq
2240 6c 69 74 65 5f 61 75 74 6f 69 6e 64 65 78 5f 6c 61 6e 64 6d 61 72 6b 5f 61 74 74 72 69 62 75 74 lite_autoindex_landmark_attribut
2260 65 5f 31 6c 61 6e 64 6d 61 72 6b 5f 61 74 74 72 69 62 75 74 65 05 60 05 07 17 1d 1d 01 81 13 74 e_1landmark_attribute.`........t
2280 61 62 6c 65 63 61 74 65 67 6f 72 79 63 61 74 65 67 6f 72 79 06 43 52 45 41 54 45 20 54 41 42 4c ablecategorycategory.CREATE.TABL
22a0 45 20 63 61 74 65 67 6f 72 79 20 28 0a 20 20 20 20 69 64 20 49 4e 54 45 47 45 52 20 50 52 49 4d E.category.(.....id.INTEGER.PRIM
22c0 41 52 59 20 4b 45 59 2c 0a 20 20 20 20 6e 61 6d 65 20 54 45 58 54 0a 29 81 60 06 07 17 31 31 01 ARY.KEY,.....name.TEXT.).`...11.
22e0 82 6b 74 61 62 6c 65 63 61 74 65 67 6f 72 79 5f 61 74 74 72 69 62 75 74 65 63 61 74 65 67 6f 72 .ktablecategory_attributecategor
2300 79 5f 61 74 74 72 69 62 75 74 65 07 43 52 45 41 54 45 20 54 41 42 4c 45 20 63 61 74 65 67 6f 72 y_attribute.CREATE.TABLE.categor
2320 79 5f 61 74 74 72 69 62 75 74 65 28 0a 20 20 20 20 63 61 74 65 67 6f 72 79 49 64 20 49 4e 54 45 y_attribute(.....categoryId.INTE
2340 47 45 52 2c 0a 20 20 20 20 6b 65 79 20 54 45 58 54 2c 0a 20 20 20 20 76 61 6c 75 65 20 42 4c 4f GER,.....key.TEXT,.....value.BLO
2360 42 2c 0a 20 20 20 20 50 52 49 4d 41 52 59 20 4b 45 59 20 28 63 61 74 65 67 6f 72 79 49 64 2c 6b B,.....PRIMARY.KEY.(categoryId,k
2380 65 79 29 2c 0a 20 20 20 20 46 4f 52 45 49 47 4e 20 4b 45 59 20 28 63 61 74 65 67 6f 72 79 49 44 ey),.....FOREIGN.KEY.(categoryID
23a0 29 20 52 45 46 45 52 45 4e 43 45 53 20 63 61 74 65 67 6f 72 79 28 69 64 29 0a 29 43 07 06 17 57 ).REFERENCES.category(id).)C...W
23c0 31 01 00 69 6e 64 65 78 73 71 6c 69 74 65 5f 61 75 74 6f 69 6e 64 65 78 5f 63 61 74 65 67 6f 72 1..indexsqlite_autoindex_categor
23e0 79 5f 61 74 74 72 69 62 75 74 65 5f 31 63 61 74 65 67 6f 72 79 5f 61 74 74 72 69 62 75 74 65 08 y_attribute_1category_attribute.
2400 0d 00 00 00 08 03 c8 00 03 f9 03 f2 03 eb 03 e4 03 dd 03 d6 03 cf 03 c8 00 00 00 00 00 00 00 00 ................................
2420 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2440 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2460 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2480 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
24a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
24c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
24e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2500 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2520 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2540 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2560 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2580 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
25a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
25c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
25e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2600 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2620 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2640 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2660 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2680 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
26a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
26c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
26e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2700 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2720 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2740 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2760 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2780 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
27a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
27c0 00 00 00 00 00 00 00 00 05 08 03 01 01 07 04 05 07 03 01 01 06 04 05 06 03 01 01 05 04 05 05 03 ................................
27e0 01 01 04 03 05 04 03 01 01 03 03 05 03 03 01 01 03 01 05 02 03 01 01 02 03 05 01 03 01 01 02 01 ................................
2800 0a 00 00 00 08 03 c0 00 03 f8 03 f0 03 e8 03 e0 03 d8 03 d0 03 c8 03 c0 00 00 00 00 00 00 00 00 ................................
2820 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2840 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2860 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2880 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
28a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
28c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
28e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2900 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2920 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2940 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2960 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2980 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
29a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
29c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
29e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2a00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2a20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2a40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2a60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2a80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2aa0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2ac0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2ae0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2b00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2b20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2b40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2b60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2b80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2ba0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
2bc0 07 04 01 01 01 07 04 08 07 04 01 01 01 06 04 07 07 04 01 01 01 05 04 06 07 04 01 01 01 04 03 05 ................................
2be0 07 04 01 01 01 03 03 04 07 04 01 01 01 03 01 03 07 04 01 01 01 02 03 02 07 04 01 01 01 02 01 01 ................................
2c00 0d 00 00 00 06 00 71 00 00 71 01 89 01 cc 02 9b 02 e6 03 b5 00 f7 00 00 00 00 00 00 00 00 00 00 ......q..q......................
2c20 00 00 00 00 00 00 00 00 81 4c 0c 07 17 37 37 01 82 37 74 61 62 6c 65 63 61 74 65 67 6f 72 79 5f .........L...77..7tablecategory_
2c40 6e 6f 74 69 66 69 63 61 74 69 6f 6e 63 61 74 65 67 6f 72 79 5f 6e 6f 74 69 66 69 63 61 74 69 6f notificationcategory_notificatio
2c60 6e 0f 43 52 45 41 54 45 20 54 41 42 4c 45 20 63 61 82 15 08 07 17 2f 2f 01 83 59 74 61 62 6c 65 n.CREATE.TABLE.ca.....//..Ytable
2c80 6c 61 6e 64 6d 61 72 6b 5f 63 61 74 65 67 6f 72 79 6c 61 6e 64 6d 61 72 6b 5f 63 61 74 65 67 6f landmark_categorylandmark_catego
2ca0 72 79 0a 43 52 45 41 54 45 20 54 41 42 4c 45 20 6c 61 6e 64 6d 61 72 6b 5f 63 61 74 65 67 6f 72 ry.CREATE.TABLE.landmark_categor
2cc0 79 20 28 0a 20 20 20 20 6c 61 6e 64 6d 61 72 6b 49 64 20 49 4e 54 45 47 45 52 2c 0a 20 20 20 20 y.(.....landmarkId.INTEGER,.....
2ce0 63 61 74 65 67 6f 72 79 49 64 20 49 4e 54 45 47 45 52 2c 0a 20 20 20 20 50 52 49 4d 41 52 59 20 categoryId.INTEGER,.....PRIMARY.
2d00 4b 45 59 20 28 6c 61 6e 64 6d 61 72 6b 49 64 2c 63 61 74 65 67 6f 72 79 49 64 29 2c 0a 20 20 20 KEY.(landmarkId,categoryId),....
2d20 20 46 4f 52 45 49 47 4e 20 4b 45 59 20 28 6c 61 6e 64 6d 61 72 6b 49 64 29 20 52 45 46 45 52 45 .FOREIGN.KEY.(landmarkId).REFERE
2d40 4e 43 45 53 20 6c 61 6e 64 6d 61 72 6b 28 69 64 29 2c 0a 20 20 20 20 46 4f 52 45 49 47 4e 20 4b NCES.landmark(id),.....FOREIGN.K
2d60 45 59 20 28 63 61 74 65 67 6f 72 79 49 64 29 20 52 45 46 45 52 45 4e 43 45 53 20 63 61 74 65 67 EY.(categoryId).REFERENCES.categ
2d80 6f 72 79 28 69 64 29 0a 29 41 09 06 17 55 2f 01 00 69 6e 64 65 78 73 71 6c 69 74 65 5f 61 75 74 ory(id).)A...U/..indexsqlite_aut
2da0 6f 69 6e 64 65 78 5f 6c 61 6e 64 6d 61 72 6b 5f 63 61 74 65 67 6f 72 79 5f 31 6c 61 6e 64 6d 61 oindex_landmark_category_1landma
2dc0 72 6b 5f 63 61 74 65 67 6f 72 79 0b 81 4c 0a 07 17 37 37 01 82 37 74 61 62 6c 65 6c 61 6e 64 6d rk_category..L...77..7tablelandm
2de0 61 72 6b 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 6c 61 6e 64 6d 61 72 6b 5f 6e 6f 74 69 66 69 63 ark_notificationlandmark_notific
2e00 61 74 69 6f 6e 0d 43 52 45 41 54 45 20 54 41 42 4c 45 20 6c 61 6e 64 6d 61 72 6b 5f 6e 6f 74 69 ation.CREATE.TABLE.landmark_noti
2e20 66 69 63 61 74 69 6f 6e 20 28 0a 20 20 20 20 74 69 6d 65 73 74 61 6d 70 20 49 4e 54 45 47 45 52 fication.(.....timestamp.INTEGER
2e40 2c 0a 20 20 20 20 61 63 74 69 6f 6e 20 54 45 58 54 2c 0a 20 20 20 20 6c 61 6e 64 6d 61 72 6b 49 ,.....action.TEXT,.....landmarkI
2e60 64 20 49 4e 54 45 47 45 52 2c 0a 20 20 20 20 50 52 49 4d 41 52 59 20 4b 45 59 28 74 69 6d 65 73 d.INTEGER,.....PRIMARY.KEY(times
2e80 74 61 6d 70 2c 20 61 63 74 69 6f 6e 2c 20 6c 61 6e 64 6d 61 72 6b 49 64 29 0a 29 49 0b 06 17 5d tamp,.action,.landmarkId).)I...]
2ea0 37 01 00 69 6e 64 65 78 73 71 6c 69 74 65 5f 61 75 74 6f 69 6e 64 65 78 5f 6c 61 6e 64 6d 61 72 7..indexsqlite_autoindex_landmar
2ec0 6b 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 5f 31 6c 61 6e 64 6d 61 72 6b 5f 6e 6f 74 69 66 69 63 k_notification_1landmark_notific
2ee0 61 74 69 6f 6e 0e 81 4c 0c 07 17 37 37 01 82 37 74 61 62 6c 65 63 61 74 65 67 6f 72 79 5f 6e 6f ation..L...77..7tablecategory_no
2f00 74 69 66 69 63 61 74 69 6f 6e 63 61 74 65 67 6f 72 79 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 0f tificationcategory_notification.
2f20 43 52 45 41 54 45 20 54 41 42 4c 45 20 63 61 74 65 67 6f 72 79 5f 6e 6f 74 69 66 69 63 61 74 69 CREATE.TABLE.category_notificati
2f40 6f 6e 20 28 0a 20 20 20 20 74 69 6d 65 73 74 61 6d 70 20 49 4e 54 45 47 45 52 2c 0a 20 20 20 20 on.(.....timestamp.INTEGER,.....
2f60 61 63 74 69 6f 6e 20 54 45 58 54 2c 0a 20 20 20 20 63 61 74 65 67 6f 72 79 49 64 20 49 4e 54 45 action.TEXT,.....categoryId.INTE
2f80 47 45 52 2c 0a 20 20 20 20 50 52 49 4d 41 52 59 20 4b 45 59 28 74 69 6d 65 73 74 61 6d 70 2c 20 GER,.....PRIMARY.KEY(timestamp,.
2fa0 61 63 74 69 6f 6e 2c 20 63 61 74 65 67 6f 72 79 49 64 29 0a 29 49 0d 06 17 5d 37 01 00 69 6e 64 action,.categoryId).)I...]7..ind
2fc0 65 78 73 71 6c 69 74 65 5f 61 75 74 6f 69 6e 64 65 78 5f 63 61 74 65 67 6f 72 79 5f 6e 6f 74 69 exsqlite_autoindex_category_noti
2fe0 66 69 63 61 74 69 6f 6e 5f 31 63 61 74 65 67 6f 72 79 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 10 fication_1category_notification.
3000 0d 00 00 00 07 03 90 00 03 f0 03 e0 03 d0 03 c0 03 b0 03 a0 03 90 00 00 00 00 00 00 00 00 00 00 ................................
3020 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3040 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3060 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3080 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
30a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
30c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
30e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
31a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
31c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
31e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3220 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3240 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3260 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3280 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
32a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
32c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
32e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3300 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3320 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3340 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3360 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3380 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0e 07 04 05 13 01 01 2e 12 61 41 a0 41 44 44 07 .........................aA.ADD.
33a0 0e 06 04 05 13 01 01 2e 12 61 41 6d 41 44 44 06 0e 05 04 05 13 01 01 2e 12 61 41 2b 41 44 44 05 .........aAmADD..........aA+ADD.
33c0 0e 04 04 05 13 01 01 2e 12 61 40 bf 41 44 44 04 0e 03 04 05 13 01 01 2e 12 61 40 8d 41 44 44 03 [email protected]@.ADD.
33e0 0e 02 04 05 13 01 01 2e 12 61 40 64 41 44 44 02 0e 01 04 05 13 01 01 2e 12 61 3f f7 41 44 44 01 [email protected]?.ADD.
3400 0a 00 00 00 07 03 89 00 03 ef 03 de 03 cd 03 bc 03 ab 03 9a 03 89 00 00 00 00 00 00 00 00 00 00 ................................
3420 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3440 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3460 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3480 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
34a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
34c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
34e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3500 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3520 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3540 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3560 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3580 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
35a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
35c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
35e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3600 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3620 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3640 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3660 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3680 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
36a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
36c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
36e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3700 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3720 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3740 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3760 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3780 00 00 00 00 00 00 00 00 00 10 05 05 13 01 01 01 2e 12 61 41 a0 41 44 44 07 07 10 05 05 13 01 01 ..................aA.ADD........
37a0 01 2e 12 61 41 6d 41 44 44 06 06 10 05 05 13 01 01 01 2e 12 61 41 2b 41 44 44 05 05 10 05 05 13 ...aAmADD...........aA+ADD......
37c0 01 01 01 2e 12 61 40 bf 41 44 44 04 04 10 05 05 13 01 01 01 2e 12 61 40 8d 41 44 44 03 03 10 05 [email protected]@.ADD....
37e0 05 13 01 01 01 2e 12 61 40 64 41 44 44 02 02 10 05 05 13 01 01 01 2e 12 61 3f f7 41 44 44 01 01 [email protected]?.ADD..
3800 0d 00 00 00 04 03 c0 00 03 f0 03 e0 03 d0 03 c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3820 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3840 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3860 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3880 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
38a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
38c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
38e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3900 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3920 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3940 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3960 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3980 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
39a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
39c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
39e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3a00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3a20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3a40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3a60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3a80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3aa0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3ac0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3ae0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3b00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3b20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3b40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3b60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3b80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3ba0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3bc0 0e 04 04 05 13 01 01 2e 12 61 40 f1 41 44 44 04 0e 03 04 05 13 01 01 2e 12 61 40 32 41 44 44 03 [email protected]@2ADD.
3be0 0e 02 04 05 13 01 01 2e 12 61 3f bd 41 44 44 02 0e 01 04 05 13 01 01 2e 12 61 3f 87 41 44 44 01 .........a?.ADD..........a?.ADD.
3c00 0a 00 00 00 04 03 bc 00 03 ef 03 de 03 cd 03 bc 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3c20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3c40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3c60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3c80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3ca0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3cc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3ce0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3d00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3d20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3d40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3d60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3d80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3da0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3dc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3de0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3e00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3e20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3e40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3e60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3e80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3ea0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3ec0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3ee0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3f00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3f20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3f40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3f60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3f80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
3fa0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 10 05 05 13 ................................
3fc0 01 01 01 2e 12 61 40 f1 41 44 44 04 04 10 05 05 13 01 01 01 2e 12 61 40 32 41 44 44 03 03 10 05 [email protected]@2ADD....
3fe0 05 13 01 01 01 2e 12 61 3f bd 41 44 44 02 02 10 05 05 13 01 01 01 2e 12 61 3f 87 41 44 44 01 01 .......a?.ADD...........a?.ADD..
4000 0d 00 00 00 02 00 a3 00 00 a3 02 4d 00 58 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ...........M.X..................
4020 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4040 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 83 30 0f 07 1b 45 1d 01 .........................0...E..
4060 86 07 74 72 69 67 67 65 72 63 68 61 6e 67 65 5f 6c 61 6e 64 6d 61 72 6b 5f 6e 6f 74 69 66 69 63 ..triggerchange_landmark_notific
4080 61 74 69 6f 6e 6c 61 6e 64 6d 61 72 6b 00 43 52 45 41 54 45 20 54 52 49 47 47 45 52 20 63 68 61 ationlandmark.CREATE.TRIGGER.cha
40a0 6e 67 65 83 27 0e 07 1b 3f 1d 01 85 7b 74 72 69 67 67 65 72 61 64 64 5f 6c 61 6e 64 6d 61 72 6b nge.'...?...{triggeradd_landmark
40c0 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 6c 61 6e 64 6d 61 72 6b 00 43 52 45 41 54 45 20 54 52 49 _notificationlandmark.CREATE.TRI
40e0 47 47 45 52 20 61 64 64 5f 6c 61 6e 64 6d 61 72 6b 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 0a 41 GGER.add_landmark_notification.A
4100 46 54 45 52 20 49 4e 53 45 52 54 20 4f 4e 20 6c 61 6e 64 6d 61 72 6b 0a 46 4f 52 20 45 41 43 48 FTER.INSERT.ON.landmark.FOR.EACH
4120 20 52 4f 57 0a 20 20 20 20 42 45 47 49 4e 0a 20 20 20 20 20 20 20 20 44 45 4c 45 54 45 20 46 52 .ROW.....BEGIN.........DELETE.FR
4140 4f 4d 20 6c 61 6e 64 6d 61 72 6b 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 0a 20 20 20 20 20 20 20 OM.landmark_notification........
4160 20 57 48 45 52 45 20 74 69 6d 65 73 74 61 6d 70 20 3c 20 73 74 72 66 74 69 6d 65 28 27 25 73 27 .WHERE.timestamp.<.strftime('%s'
4180 2c 20 27 6e 6f 77 27 2c 20 27 2d 32 20 6d 69 6e 75 74 65 73 27 29 3b 0a 20 20 20 20 20 20 20 20 ,.'now',.'-2.minutes');.........
41a0 49 4e 53 45 52 54 20 49 4e 54 4f 20 6c 61 6e 64 6d 61 72 6b 5f 6e 6f 74 69 66 69 63 61 74 69 6f INSERT.INTO.landmark_notificatio
41c0 6e 28 74 69 6d 65 73 74 61 6d 70 2c 20 61 63 74 69 6f 6e 2c 20 6c 61 6e 64 6d 61 72 6b 49 64 29 n(timestamp,.action,.landmarkId)
41e0 0a 20 20 20 20 20 20 20 20 56 41 4c 55 45 53 28 28 73 74 72 66 74 69 6d 65 28 22 25 66 22 2c 20 .........VALUES((strftime("%f",.
4200 22 6e 6f 77 22 29 20 2d 20 73 74 72 66 74 69 6d 65 28 22 25 53 22 2c 20 22 6e 6f 77 22 29 20 2b "now").-.strftime("%S",."now").+
4220 20 73 74 72 66 74 69 6d 65 28 22 25 73 22 29 29 2a 31 30 30 30 2c 27 41 44 44 27 2c 20 6e 65 77 .strftime("%s"))*1000,'ADD',.new
4240 2e 69 64 29 3b 0a 20 20 20 20 45 4e 44 83 30 0f 07 1b 45 1d 01 86 07 74 72 69 67 67 65 72 63 68 .id);.....END.0...E....triggerch
4260 61 6e 67 65 5f 6c 61 6e 64 6d 61 72 6b 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 6c 61 6e 64 6d 61 ange_landmark_notificationlandma
4280 72 6b 00 43 52 45 41 54 45 20 54 52 49 47 47 45 52 20 63 68 61 6e 67 65 5f 6c 61 6e 64 6d 61 72 rk.CREATE.TRIGGER.change_landmar
42a0 6b 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 0a 41 46 54 45 52 20 55 50 44 41 54 45 20 4f 4e 20 6c k_notification.AFTER.UPDATE.ON.l
42c0 61 6e 64 6d 61 72 6b 0a 46 4f 52 20 45 41 43 48 20 52 4f 57 0a 20 20 20 20 42 45 47 49 4e 0a 20 andmark.FOR.EACH.ROW.....BEGIN..
42e0 20 20 20 20 20 20 20 44 45 4c 45 54 45 20 46 52 4f 4d 20 6c 61 6e 64 6d 61 72 6b 5f 6e 6f 74 69 .......DELETE.FROM.landmark_noti
4300 66 69 63 61 74 69 6f 6e 0a 20 20 20 20 20 20 20 20 57 48 45 52 45 20 74 69 6d 65 73 74 61 6d 70 fication.........WHERE.timestamp
4320 20 3c 20 73 74 72 66 74 69 6d 65 28 27 25 73 27 2c 20 27 6e 6f 77 27 2c 20 27 2d 32 20 6d 69 6e .<.strftime('%s',.'now',.'-2.min
4340 75 74 65 73 27 29 3b 0a 20 20 20 20 20 20 20 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 6c 61 6e 64 utes');.........INSERT.INTO.land
4360 6d 61 72 6b 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 28 74 69 6d 65 73 74 61 6d 70 2c 20 61 63 74 mark_notification(timestamp,.act
4380 69 6f 6e 2c 20 6c 61 6e 64 6d 61 72 6b 49 64 29 0a 20 20 20 20 20 20 20 20 56 41 4c 55 45 53 28 ion,.landmarkId).........VALUES(
43a0 28 73 74 72 66 74 69 6d 65 28 22 25 66 22 2c 20 22 6e 6f 77 22 29 20 2d 20 73 74 72 66 74 69 6d (strftime("%f",."now").-.strftim
43c0 65 28 22 25 53 22 2c 20 22 6e 6f 77 22 29 20 2b 20 73 74 72 66 74 69 6d 65 28 22 25 73 22 29 29 e("%S",."now").+.strftime("%s"))
43e0 2a 31 30 30 30 2c 27 43 48 41 4e 47 45 27 2c 20 6e 65 77 2e 69 64 29 3b 0a 20 20 20 20 45 4e 44 *1000,'CHANGE',.new.id);.....END
4400 0d 00 00 00 02 00 a2 00 00 a2 02 56 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ...........V....................
4420 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4440 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4460 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4480 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
44a0 00 00 83 31 10 07 1b 45 1d 01 86 09 74 72 69 67 67 65 72 72 65 6d 6f 76 65 5f 6c 61 6e 64 6d 61 ...1...E....triggerremove_landma
44c0 72 6b 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 6c 61 6e 64 6d 61 72 6b 00 43 52 45 41 54 45 20 54 rk_notificationlandmark.CREATE.T
44e0 52 49 47 47 45 52 20 72 65 6d 6f 76 65 5f 6c 61 6e 64 6d 61 72 6b 5f 6e 6f 74 69 66 69 63 61 74 RIGGER.remove_landmark_notificat
4500 69 6f 6e 0a 42 45 46 4f 52 45 20 44 45 4c 45 54 45 20 4f 4e 20 6c 61 6e 64 6d 61 72 6b 0a 46 4f ion.BEFORE.DELETE.ON.landmark.FO
4520 52 20 45 41 43 48 20 52 4f 57 0a 20 20 20 20 42 45 47 49 4e 0a 20 20 20 20 20 20 20 20 44 45 4c R.EACH.ROW.....BEGIN.........DEL
4540 45 54 45 20 46 52 4f 4d 20 6c 61 6e 64 6d 61 72 6b 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 0a 20 ETE.FROM.landmark_notification..
4560 20 20 20 20 20 20 20 57 48 45 52 45 20 74 69 6d 65 73 74 61 6d 70 20 3c 20 73 74 72 66 74 69 6d .......WHERE.timestamp.<.strftim
4580 65 28 27 25 73 27 2c 20 27 6e 6f 77 27 2c 20 27 2d 32 20 6d 69 6e 75 74 65 73 27 29 3b 0a 20 20 e('%s',.'now',.'-2.minutes');...
45a0 20 20 20 20 20 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 6c 61 6e 64 6d 61 72 6b 5f 6e 6f 74 69 66 ......INSERT.INTO.landmark_notif
45c0 69 63 61 74 69 6f 6e 28 74 69 6d 65 73 74 61 6d 70 2c 20 61 63 74 69 6f 6e 2c 20 6c 61 6e 64 6d ication(timestamp,.action,.landm
45e0 61 72 6b 49 64 29 0a 20 20 20 20 20 20 20 20 56 41 4c 55 45 53 28 28 73 74 72 66 74 69 6d 65 28 arkId).........VALUES((strftime(
4600 22 25 66 22 2c 20 22 6e 6f 77 22 29 20 2d 20 73 74 72 66 74 69 6d 65 28 22 25 53 22 2c 20 22 6e "%f",."now").-.strftime("%S",."n
4620 6f 77 22 29 20 2b 20 73 74 72 66 74 69 6d 65 28 22 25 73 22 29 29 2a 31 30 30 30 2c 27 52 45 4d ow").+.strftime("%s"))*1000,'REM
4640 4f 56 45 27 2c 20 6f 6c 64 2e 69 64 29 3b 0a 20 20 20 20 45 4e 44 83 27 11 07 1b 3f 1d 01 85 7b OVE',.old.id);.....END.'...?...{
4660 74 72 69 67 67 65 72 61 64 64 5f 63 61 74 65 67 6f 72 79 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e triggeradd_category_notification
4680 63 61 74 65 67 6f 72 79 00 43 52 45 41 54 45 20 54 52 49 47 47 45 52 20 61 64 64 5f 63 61 74 65 category.CREATE.TRIGGER.add_cate
46a0 67 6f 72 79 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 0a 41 46 54 45 52 20 49 4e 53 45 52 54 20 4f gory_notification.AFTER.INSERT.O
46c0 4e 20 63 61 74 65 67 6f 72 79 0a 46 4f 52 20 45 41 43 48 20 52 4f 57 0a 20 20 20 20 42 45 47 49 N.category.FOR.EACH.ROW.....BEGI
46e0 4e 0a 20 20 20 20 20 20 20 20 44 45 4c 45 54 45 20 46 52 4f 4d 20 63 61 74 65 67 6f 72 79 5f 6e N.........DELETE.FROM.category_n
4700 6f 74 69 66 69 63 61 74 69 6f 6e 0a 20 20 20 20 20 20 20 20 57 48 45 52 45 20 74 69 6d 65 73 74 otification.........WHERE.timest
4720 61 6d 70 20 3c 20 73 74 72 66 74 69 6d 65 28 27 25 73 27 2c 20 27 6e 6f 77 27 2c 20 27 2d 32 20 amp.<.strftime('%s',.'now',.'-2.
4740 6d 69 6e 75 74 65 73 27 29 3b 0a 20 20 20 20 20 20 20 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 63 minutes');.........INSERT.INTO.c
4760 61 74 65 67 6f 72 79 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 28 74 69 6d 65 73 74 61 6d 70 2c 20 ategory_notification(timestamp,.
4780 61 63 74 69 6f 6e 2c 20 63 61 74 65 67 6f 72 79 49 64 29 0a 20 20 20 20 20 20 20 20 56 41 4c 55 action,.categoryId).........VALU
47a0 45 53 28 28 73 74 72 66 74 69 6d 65 28 22 25 66 22 2c 20 22 6e 6f 77 22 29 20 2d 20 73 74 72 66 ES((strftime("%f",."now").-.strf
47c0 74 69 6d 65 28 22 25 53 22 2c 20 22 6e 6f 77 22 29 20 2b 20 73 74 72 66 74 69 6d 65 28 22 25 73 time("%S",."now").+.strftime("%s
47e0 22 29 29 2a 31 30 30 30 2c 27 41 44 44 27 2c 20 6e 65 77 2e 69 64 29 3b 0a 20 20 20 20 45 4e 44 "))*1000,'ADD',.new.id);.....END
4800 0d 00 00 00 02 00 99 00 00 99 02 4c 00 10 00 00 81 06 14 07 17 47 2f 01 81 23 69 6e 64 65 78 6c ...........L.........G/..#indexl
4820 61 6e 64 6d 61 72 6b 5f 63 61 74 65 67 6f 72 79 5f 66 6b 5f 6c 6d 5f 69 6e 64 65 78 6c 61 6e 64 andmark_category_fk_lm_indexland
4840 6d 61 72 6b 5f 63 61 74 65 67 6f 72 79 14 43 52 45 41 54 45 20 49 4e 44 45 58 20 6c 61 6e 64 6d mark_category.CREATE.INDEX.landm
4860 61 72 6b 5f 63 61 74 65 67 6f 72 79 5f 66 6b 5f 6c 6d 5f 69 6e 64 65 78 20 4f 4e 20 6c 61 6e 64 ark_category_fk_lm_index.ON.land
4880 6d 61 72 6b 5f 63 61 74 65 67 6f 72 79 28 6c 61 6e 64 6d 61 72 6b 49 64 29 83 30 12 07 1b 45 1d mark_category(landmarkId).0...E.
48a0 01 86 07 74 72 69 67 67 65 72 63 68 61 6e 67 65 5f 63 61 74 65 67 6f 72 79 5f 6e 6f 74 69 66 69 ...triggerchange_category_notifi
48c0 63 61 74 69 6f 6e 63 61 74 65 67 6f 72 79 00 43 52 45 41 54 45 20 54 52 49 47 47 45 52 20 63 68 cationcategory.CREATE.TRIGGER.ch
48e0 61 6e 67 65 5f 63 61 74 65 67 6f 72 79 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 0a 41 46 54 45 52 ange_category_notification.AFTER
4900 20 55 50 44 41 54 45 20 4f 4e 20 63 61 74 65 67 6f 72 79 0a 46 4f 52 20 45 41 43 48 20 52 4f 57 .UPDATE.ON.category.FOR.EACH.ROW
4920 0a 20 20 20 20 42 45 47 49 4e 0a 20 20 20 20 20 20 20 20 44 45 4c 45 54 45 20 46 52 4f 4d 20 63 .....BEGIN.........DELETE.FROM.c
4940 61 74 65 67 6f 72 79 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 0a 20 20 20 20 20 20 20 20 57 48 45 ategory_notification.........WHE
4960 52 45 20 74 69 6d 65 73 74 61 6d 70 20 3c 20 73 74 72 66 74 69 6d 65 28 27 25 73 27 2c 20 27 6e RE.timestamp.<.strftime('%s',.'n
4980 6f 77 27 2c 20 27 2d 32 20 6d 69 6e 75 74 65 73 27 29 3b 0a 20 20 20 20 20 20 20 20 49 4e 53 45 ow',.'-2.minutes');.........INSE
49a0 52 54 20 49 4e 54 4f 20 63 61 74 65 67 6f 72 79 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 28 74 69 RT.INTO.category_notification(ti
49c0 6d 65 73 74 61 6d 70 2c 20 61 63 74 69 6f 6e 2c 20 63 61 74 65 67 6f 72 79 49 64 29 0a 20 20 20 mestamp,.action,.categoryId)....
49e0 20 20 20 20 20 56 41 4c 55 45 53 28 28 73 74 72 66 74 69 6d 65 28 22 25 66 22 2c 20 22 6e 6f 77 .....VALUES((strftime("%f",."now
4a00 22 29 20 2d 20 73 74 72 66 74 69 6d 65 28 22 25 53 22 2c 20 22 6e 6f 77 22 29 20 2b 20 73 74 72 ").-.strftime("%S",."now").+.str
4a20 66 74 69 6d 65 28 22 25 73 22 29 29 2a 31 30 30 30 2c 27 43 48 41 4e 47 45 27 2c 20 6e 65 77 2e ftime("%s"))*1000,'CHANGE',.new.
4a40 69 64 29 3b 0a 20 20 20 20 45 4e 44 83 31 13 07 1b 45 1d 01 86 09 74 72 69 67 67 65 72 72 65 6d id);.....END.1...E....triggerrem
4a60 6f 76 65 5f 63 61 74 65 67 6f 72 79 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 63 61 74 65 67 6f 72 ove_category_notificationcategor
4a80 79 00 43 52 45 41 54 45 20 54 52 49 47 47 45 52 20 72 65 6d 6f 76 65 5f 63 61 74 65 67 6f 72 79 y.CREATE.TRIGGER.remove_category
4aa0 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 0a 42 45 46 4f 52 45 20 44 45 4c 45 54 45 20 4f 4e 20 63 _notification.BEFORE.DELETE.ON.c
4ac0 61 74 65 67 6f 72 79 0a 46 4f 52 20 45 41 43 48 20 52 4f 57 0a 20 20 20 20 42 45 47 49 4e 0a 20 ategory.FOR.EACH.ROW.....BEGIN..
4ae0 20 20 20 20 20 20 20 44 45 4c 45 54 45 20 46 52 4f 4d 20 63 61 74 65 67 6f 72 79 5f 6e 6f 74 69 .......DELETE.FROM.category_noti
4b00 66 69 63 61 74 69 6f 6e 0a 20 20 20 20 20 20 20 20 57 48 45 52 45 20 74 69 6d 65 73 74 61 6d 70 fication.........WHERE.timestamp
4b20 20 3c 20 73 74 72 66 74 69 6d 65 28 27 25 73 27 2c 20 27 6e 6f 77 27 2c 20 27 2d 32 20 6d 69 6e .<.strftime('%s',.'now',.'-2.min
4b40 75 74 65 73 27 29 3b 0a 20 20 20 20 20 20 20 20 49 4e 53 45 52 54 20 49 4e 54 4f 20 63 61 74 65 utes');.........INSERT.INTO.cate
4b60 67 6f 72 79 5f 6e 6f 74 69 66 69 63 61 74 69 6f 6e 28 74 69 6d 65 73 74 61 6d 70 2c 20 61 63 74 gory_notification(timestamp,.act
4b80 69 6f 6e 2c 20 63 61 74 65 67 6f 72 79 49 64 29 0a 20 20 20 20 20 20 20 20 56 41 4c 55 45 53 28 ion,.categoryId).........VALUES(
4ba0 28 73 74 72 66 74 69 6d 65 28 22 25 66 22 2c 20 22 6e 6f 77 22 29 20 2d 20 73 74 72 66 74 69 6d (strftime("%f",."now").-.strftim
4bc0 65 28 22 25 53 22 2c 20 22 6e 6f 77 22 29 20 2b 20 73 74 72 66 74 69 6d 65 28 22 25 73 22 29 29 e("%S",."now").+.strftime("%s"))
4be0 2a 31 30 30 30 2c 27 52 45 4d 4f 56 45 27 2c 20 6f 6c 64 2e 69 64 29 3b 0a 20 20 20 20 45 4e 44 *1000,'REMOVE',.old.id);.....END
4c00 0a 00 00 00 08 03 d0 00 03 fa 03 f4 03 ee 03 e8 03 e2 03 dc 03 d6 03 d0 00 00 00 00 00 00 00 00 ................................
4c20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4c40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4c60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4c80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4ca0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4cc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4ce0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4d00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4d20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4d40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4d60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4d80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4da0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4dc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4de0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4e00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4e20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4e40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4e60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4e80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4ea0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4ec0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4ee0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4f00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4f20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4f40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4f60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4f80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4fa0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
4fc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 05 03 01 01 07 08 05 03 01 01 06 07 05 03 01 01 ................................
4fe0 05 06 05 03 01 01 04 05 05 03 01 01 03 04 05 03 01 01 03 03 05 03 01 01 02 02 05 03 01 01 02 01 ................................
5000 0a 00 00 00 08 03 d0 00 03 fa 03 ee 03 f4 03 e8 03 e2 03 dc 03 d6 03 d0 00 00 00 00 00 00 00 00 ................................
5020 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5040 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5060 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5080 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
50a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
50c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
50e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5100 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
51a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
51c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
51e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5220 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5240 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5260 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5280 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
52a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
52c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
52e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5300 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5320 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5340 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5360 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5380 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
53a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
53c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 05 03 01 01 04 08 05 03 01 01 04 07 05 03 01 01 ................................
53e0 04 06 05 03 01 01 03 05 05 03 01 01 03 04 05 03 01 01 01 03 05 03 01 01 03 02 05 03 01 01 01 01 ................................
5400 0d 00 00 00 02 02 ec 00 02 ec 03 75 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ...........u....................
5420 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5440 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5460 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5480 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
54a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
54c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
54e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5500 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5520 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5540 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5560 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5580 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
55a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
55c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
55e0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5600 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5620 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5640 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5660 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5680 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
56a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
56c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
56e0 00 00 00 00 00 00 00 00 00 00 00 00 81 06 14 07 17 47 2f 01 81 23 69 6e 64 65 78 6c 61 6e 64 6d .................G/..#indexlandm
5700 61 72 6b 5f 63 61 74 65 67 6f 72 79 5f 66 6b 5f 6c 6d 5f 69 6e 64 65 78 6c 61 6e 64 6d 61 72 6b ark_category_fk_lm_indexlandmark
5720 5f 63 61 74 65 67 6f 72 79 14 43 52 45 41 54 45 20 49 4e 44 45 58 20 6c 61 6e 64 6d 61 72 6b 5f _category.CREATE.INDEX.landmark_
5740 63 61 74 65 67 6f 72 79 5f 66 6b 5f 6c 6d 5f 69 6e 64 65 78 20 4f 4e 20 6c 61 6e 64 6d 61 72 6b category_fk_lm_index.ON.landmark
5760 5f 63 61 74 65 67 6f 72 79 28 6c 61 6e 64 6d 61 72 6b 49 64 29 81 08 15 07 17 49 2f 01 81 25 69 _category(landmarkId).....I/..%i
5780 6e 64 65 78 6c 61 6e 64 6d 61 72 6b 5f 63 61 74 65 67 6f 72 79 5f 66 6b 5f 63 61 74 5f 69 6e 64 ndexlandmark_category_fk_cat_ind
57a0 65 78 6c 61 6e 64 6d 61 72 6b 5f 63 61 74 65 67 6f 72 79 15 43 52 45 41 54 45 20 49 4e 44 45 58 exlandmark_category.CREATE.INDEX
57c0 20 6c 61 6e 64 6d 61 72 6b 5f 63 61 74 65 67 6f 72 79 5f 66 6b 5f 63 61 74 5f 69 6e 64 65 78 20 .landmark_category_fk_cat_index.
57e0 4f 4e 20 6c 61 6e 64 6d 61 72 6b 5f 63 61 74 65 67 6f 72 79 28 63 61 74 65 67 6f 72 79 49 64 29 ON.landmark_category(categoryId)
5800 0d 00 00 00 3c 00 87 00 03 ee 03 e0 03 cb 03 b9 03 ab 03 9f 03 92 03 87 03 78 03 6b 03 5c 03 4a ....<....................x.k.\.J
5820 03 40 03 2e 03 20 03 0b 02 f9 02 eb 02 df 02 d2 02 c7 02 b8 02 ab 02 9c 02 8a 02 80 02 6e 02 60 [email protected].`
5840 02 4b 02 39 02 2b 02 1f 02 12 02 07 01 f8 01 eb 01 dc 01 ca 01 c0 01 ae 01 a0 01 8b 01 79 01 6b .K.9.+.......................y.k
5860 01 5f 01 52 01 47 01 38 01 2b 01 1c 01 0a 01 00 00 ee 00 e0 00 cb 00 b9 00 ab 00 9f 00 92 00 87 ._.R.G.8.+......................
5880 00 00 00 00 00 00 00 09 3c 04 01 15 00 05 63 69 74 79 0b 3b 04 01 19 00 05 63 6f 75 6e 74 79 0a ........<.....city.;.....county.
58a0 3a 04 01 17 00 05 73 74 61 74 65 0c 39 04 01 1b 00 05 63 6f 75 6e 74 72 79 10 38 04 01 23 00 05 :.....state.9.....country.8..#..
58c0 63 6f 75 6e 74 72 79 43 6f 64 65 13 37 04 01 19 07 05 72 61 64 69 75 73 00 00 00 00 00 00 00 00 countryCode.7.....radius........
58e0 0c 36 04 01 1b 0d 05 69 63 6f 6e 55 72 6c 10 35 04 01 23 00 05 64 65 73 63 72 69 70 74 69 6f 6e .6.....iconUrl.5..#..description
5900 08 34 04 01 13 0d 04 75 72 6c 10 33 04 01 23 00 04 70 68 6f 6e 65 4e 75 6d 62 65 72 0d 32 04 01 .4.....url.3..#..phoneNumber.2..
5920 1d 00 04 70 6f 73 74 63 6f 64 65 0b 31 04 01 19 00 04 73 74 72 65 65 74 0d 30 04 01 1d 00 04 64 ...postcode.1.....street.0.....d
5940 69 73 74 72 69 63 74 09 2f 04 01 15 00 04 63 69 74 79 0b 2e 04 01 19 00 04 63 6f 75 6e 74 79 0a istrict./.....city.......county.
5960 2d 04 01 17 00 04 73 74 61 74 65 0c 2c 04 01 1b 00 04 63 6f 75 6e 74 72 79 10 2b 04 01 23 00 04 -.....state.,.....country.+..#..
5980 63 6f 75 6e 74 72 79 43 6f 64 65 13 2a 04 01 19 07 04 72 61 64 69 75 73 00 00 00 00 00 00 00 00 countryCode.*.....radius........
59a0 0c 29 04 01 1b 0d 04 69 63 6f 6e 55 72 6c 10 28 04 01 23 00 04 64 65 73 63 72 69 70 74 69 6f 6e .).....iconUrl.(..#..description
59c0 08 27 04 01 13 0d 03 75 72 6c 10 26 04 01 23 00 03 70 68 6f 6e 65 4e 75 6d 62 65 72 0d 25 04 01 .'.....url.&..#..phoneNumber.%..
59e0 1d 00 03 70 6f 73 74 63 6f 64 65 0b 24 04 01 19 00 03 73 74 72 65 65 74 0d 23 04 01 1d 00 03 64 ...postcode.$.....street.#.....d
5a00 69 73 74 72 69 63 74 09 22 04 01 15 00 03 63 69 74 79 0b 21 04 01 19 00 03 63 6f 75 6e 74 79 0a istrict.".....city.!.....county.
5a20 20 04 01 17 00 03 73 74 61 74 65 0c 1f 04 01 1b 00 03 63 6f 75 6e 74 72 79 10 1e 04 01 23 00 03 ......state.......country....#..
5a40 63 6f 75 6e 74 72 79 43 6f 64 65 13 1d 04 01 19 07 03 72 61 64 69 75 73 00 00 00 00 00 00 00 00 countryCode.......radius........
5a60 0c 1c 04 01 1b 0d 03 69 63 6f 6e 55 72 6c 10 1b 04 01 23 00 03 64 65 73 63 72 69 70 74 69 6f 6e .......iconUrl....#..description
5a80 08 1a 04 01 13 0d 02 75 72 6c 10 19 04 01 23 00 02 70 68 6f 6e 65 4e 75 6d 62 65 72 0d 18 04 01 .......url....#..phoneNumber....
5aa0 1d 00 02 70 6f 73 74 63 6f 64 65 0b 17 04 01 19 00 02 73 74 72 65 65 74 0d 16 04 01 1d 00 02 64 ...postcode.......street.......d
5ac0 69 73 74 72 69 63 74 09 15 04 01 15 00 02 63 69 74 79 0b 14 04 01 19 00 02 63 6f 75 6e 74 79 0a istrict.......city.......county.
5ae0 13 04 01 17 00 02 73 74 61 74 65 0c 12 04 01 1b 00 02 63 6f 75 6e 74 72 79 10 11 04 01 23 00 02 ......state.......country....#..
5b00 63 6f 75 6e 74 72 79 43 6f 64 65 13 10 04 01 19 07 02 72 61 64 69 75 73 00 00 00 00 00 00 00 00 countryCode.......radius........
5b20 0c 0f 04 01 1b 0d 02 69 63 6f 6e 55 72 6c 10 0e 04 01 23 00 02 64 65 73 63 72 69 70 74 69 6f 6e .......iconUrl....#..description
5b40 08 0d 04 01 13 0d 01 75 72 6c 10 0c 04 01 23 00 01 70 68 6f 6e 65 4e 75 6d 62 65 72 0d 0b 04 01 .......url....#..phoneNumber....
5b60 1d 00 01 70 6f 73 74 63 6f 64 65 0b 0a 04 01 19 00 01 73 74 72 65 65 74 0d 09 04 01 1d 00 01 64 ...postcode.......street.......d
5b80 69 73 74 72 69 63 74 09 08 04 01 15 00 01 63 69 74 79 0b 07 04 01 19 00 01 63 6f 75 6e 74 79 0a istrict.......city.......county.
5ba0 06 04 01 17 00 01 73 74 61 74 65 0c 05 04 01 1b 00 01 63 6f 75 6e 74 72 79 10 04 04 01 23 00 01 ......state.......country....#..
5bc0 63 6f 75 6e 74 72 79 43 6f 64 65 13 03 04 01 19 07 01 72 61 64 69 75 73 00 00 00 00 00 00 00 00 countryCode.......radius........
5be0 0c 02 04 01 1b 0d 01 69 63 6f 6e 55 72 6c 10 01 04 01 23 00 01 64 65 73 63 72 69 70 74 69 6f 6e .......iconUrl....#..description
5c00 0d 00 00 00 1f 02 39 00 03 f1 03 e4 03 d5 03 c3 03 b9 03 a7 03 99 03 84 03 72 03 64 03 58 03 4b ......9..................r.d.X.K
5c20 03 40 03 31 03 24 03 15 03 03 02 f9 02 e7 02 d9 02 c4 02 b2 02 a4 02 98 02 8b 02 80 02 71 02 64 [email protected].$.......................q.d
5c40 02 55 02 43 02 39 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 .U.C.9..........................
5c60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5c80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5ca0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5cc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5ce0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5d00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5d20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5d40 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5d60 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5d80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5da0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5dc0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5de0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5e00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
5e20 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 08 5b 04 01 13 0d 07 ..........................[.....
5e40 75 72 6c 10 5a 04 01 23 00 07 70 68 6f 6e 65 4e 75 6d 62 65 72 0d 59 04 01 1d 00 07 70 6f 73 74 url.Z..#..phoneNumber.Y.....post
5e60 63 6f 64 65 0b 58 04 01 19 00 07 73 74 72 65 65 74 0d 57 04 01 1d 00 07 64 69 73 74 72 69 63 74 code.X.....street.W.....district
5e80 09 56 04 01 15 00 07 63 69 74 79 0b 55 04 01 19 00 07 63 6f 75 6e 74 79 0a 54 04 01 17 00 07 73 .V.....city.U.....county.T.....s
5ea0 74 61 74 65 0c 53 04 01 1b 00 07 63 6f 75 6e 74 72 79 10 52 04 01 23 00 07 63 6f 75 6e 74 72 79 tate.S.....country.R..#..country
5ec0 43 6f 64 65 13 51 04 01 19 07 07 72 61 64 69 75 73 00 00 00 00 00 00 00 00 0c 50 04 01 1b 0d 07 Code.Q.....radius.........P.....
5ee0 69 63 6f 6e 55 72 6c 10 4f 04 01 23 00 07 64 65 73 63 72 69 70 74 69 6f 6e 08 4e 04 01 13 0d 06 iconUrl.O..#..description.N.....
5f00 75 72 6c 10 4d 04 01 23 00 06 70 68 6f 6e 65 4e 75 6d 62 65 72 0d 4c 04 01 1d 00 06 70 6f 73 74 url.M..#..phoneNumber.L.....post
5f20 63 6f 64 65 0b 4b 04 01 19 00 06 73 74 72 65 65 74 0d 4a 04 01 1d 00 06 64 69 73 74 72 69 63 74 code.K.....street.J.....district
5f40 09 49 04 01 15 00 06 63 69 74 79 0b 48 04 01 19 00 06 63 6f 75 6e 74 79 0a 47 04 01 17 00 06 73 .I.....city.H.....county.G.....s
5f60 74 61 74 65 0c 46 04 01 1b 00 06 63 6f 75 6e 74 72 79 10 45 04 01 23 00 06 63 6f 75 6e 74 72 79 tate.F.....country.E..#..country
5f80 43 6f 64 65 13 44 04 01 19 07 06 72 61 64 69 75 73 00 00 00 00 00 00 00 00 0c 43 04 01 1b 0d 06 Code.D.....radius.........C.....
5fa0 69 63 6f 6e 55 72 6c 10 42 04 01 23 00 06 64 65 73 63 72 69 70 74 69 6f 6e 08 41 04 01 13 0d 05 iconUrl.B..#..description.A.....
5fc0 75 72 6c 10 40 04 01 23 00 05 70 68 6f 6e 65 4e 75 6d 62 65 72 0d 3f 04 01 1d 00 05 70 6f 73 74 url.@..#..phoneNumber.?.....post
5fe0 63 6f 64 65 0b 3e 04 01 19 00 05 73 74 72 65 65 74 0d 3d 04 01 1d 00 05 64 69 73 74 72 69 63 74 code.>.....street.=.....district
6000 0a 00 00 00 1f 02 46 00 02 46 02 51 02 5f 02 71 02 7e 02 90 02 9f 02 ad 02 bf 02 ce 02 db 02 e7 ......F..F.Q._.q.~..............
6020 02 f4 02 fe 03 09 03 17 03 29 03 36 03 48 03 57 03 65 03 77 03 86 03 93 03 9f 03 ac 03 b6 03 c1 .........).6.H.W.e.w............
6040 03 cf 03 e1 03 ee 02 10 02 70 01 e2 01 f4 02 63 02 37 02 03 01 d8 01 67 01 8b 01 99 01 72 01 c6 .........p.....c.7.....g.....r..
6060 01 58 01 b8 01 2a 01 3c 01 ab 01 7f 01 4b 01 20 00 af 00 d3 00 e1 00 ba 01 0e 00 a0 01 00 00 f3 .X...*.<.....K..................
6080 00 c7 00 93 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0c 04 01 19 01 05 73 74 72 65 65 74 3e .........................street>
60a0 0e 04 01 1d 01 05 64 69 73 74 72 69 63 74 3d 0a 04 01 15 01 05 63 69 74 79 3c 0c 04 01 19 01 05 ......district=......city<......
60c0 63 6f 75 6e 74 79 3b 0b 04 01 17 01 05 73 74 61 74 65 3a 0d 04 01 1b 01 05 63 6f 75 6e 74 72 79 county;......state:......country
60e0 39 11 04 01 23 01 05 63 6f 75 6e 74 72 79 43 6f 64 65 38 0c 04 01 19 01 05 72 61 64 69 75 73 37 9...#..countryCode8......radius7
6100 0d 04 01 1b 01 05 69 63 6f 6e 55 72 6c 36 11 04 01 23 01 05 64 65 73 63 72 69 70 74 69 6f 6e 35 ......iconUrl6...#..description5
6120 09 04 01 13 01 04 75 72 6c 34 11 04 01 23 01 04 70 68 6f 6e 65 4e 75 6d 62 65 72 33 0e 04 01 1d ......url4...#..phoneNumber3....
6140 01 04 70 6f 73 74 63 6f 64 65 32 0c 04 01 19 01 04 73 74 72 65 65 74 31 0e 04 01 1d 01 04 64 69 ..postcode2......street1......di
6160 73 74 72 69 63 74 30 0a 04 01 15 01 04 63 69 74 79 2f 0c 04 01 19 01 04 63 6f 75 6e 74 79 2e 0b strict0......city/......county..
6180 04 01 17 01 04 73 74 61 74 65 2d 0d 04 01 1b 01 04 63 6f 75 6e 74 72 79 2c 11 04 01 23 01 04 63 .....state-......country,...#..c
61a0 6f 75 6e 74 72 79 43 6f 64 65 2b 0c 04 01 19 01 04 72 61 64 69 75 73 2a 0d 04 01 1b 01 04 69 63 ountryCode+......radius*......ic
61c0 6f 6e 55 72 6c 29 11 04 01 23 01 04 64 65 73 63 72 69 70 74 69 6f 6e 28 09 04 01 13 01 03 75 72 onUrl)...#..description(......ur
61e0 6c 27 11 04 01 23 01 03 70 68 6f 6e 65 4e 75 6d 62 65 72 26 0e 04 01 1d 01 03 70 6f 73 74 63 6f l'...#..phoneNumber&......postco
6200 64 65 25 0c 04 01 19 01 03 73 74 72 65 65 74 24 0e 04 01 1d 01 03 64 69 73 74 72 69 63 74 23 0a de%......street$......district#.
6220 04 01 15 01 03 63 69 74 79 22 0c 04 01 19 01 03 63 6f 75 6e 74 79 21 0b 04 01 17 01 03 73 74 61 .....city"......county!......sta
6240 74 65 20 0d 04 01 0a 04 01 15 01 01 63 69 74 79 08 0d 04 01 1b 01 01 63 6f 75 6e 74 72 79 05 11 te..........city.......country..
6260 04 01 23 01 01 63 6f 75 6e 74 72 79 43 6f 64 65 04 0c 04 01 19 01 01 63 6f 75 6e 74 79 07 11 04 ..#..countryCode.......county...
6280 01 23 01 01 64 65 73 63 72 69 70 74 69 6f 6e 01 0e 04 01 1d 01 01 64 69 73 74 72 69 63 74 09 0d .#..description.......district..
62a0 04 01 1b 01 01 69 63 6f 6e 55 72 6c 02 11 04 01 23 01 01 70 68 6f 6e 65 4e 75 6d 62 65 72 0c 0e .....iconUrl....#..phoneNumber..
62c0 04 01 1d 01 01 70 6f 73 74 63 6f 64 65 0b 0c 04 01 19 01 01 72 61 64 69 75 73 03 0b 04 01 17 01 .....postcode.......radius......
62e0 01 73 74 61 74 65 06 0c 04 01 19 01 01 73 74 72 65 65 74 0a 09 04 01 13 01 01 75 72 6c 0d 0a 04 .state.......street.......url...
6300 01 15 01 02 63 69 74 79 15 0d 04 01 1b 01 02 63 6f 75 6e 74 72 79 12 11 04 01 23 01 02 63 6f 75 ....city.......country....#..cou
6320 6e 74 72 79 43 6f 64 65 11 0c 04 01 19 01 02 63 6f 75 6e 74 79 14 11 04 01 23 01 02 64 65 73 63 ntryCode.......county....#..desc
6340 72 69 70 74 69 6f 6e 0e 0e 04 01 1d 01 02 64 69 73 74 72 69 63 74 16 0d 04 01 1b 01 02 69 63 6f ription.......district.......ico
6360 6e 55 72 6c 0f 11 04 01 23 01 02 70 68 6f 6e 65 4e 75 6d 62 65 72 19 0e 04 01 1d 01 02 70 6f 73 nUrl....#..phoneNumber.......pos
6380 74 63 6f 64 65 18 0c 04 01 19 01 02 72 61 64 69 75 73 10 0b 04 01 17 01 02 73 74 61 74 65 13 0c tcode.......radius.......state..
63a0 04 01 19 01 02 73 74 72 65 65 74 17 09 04 01 13 01 02 75 72 6c 1a 0a 04 01 15 01 03 63 69 74 79 .....street.......url.......city
63c0 22 0d 04 01 1b 01 03 63 6f 75 6e 74 72 79 1f 11 04 01 23 01 03 63 6f 75 6e 74 72 79 43 6f 64 65 "......country....#..countryCode
63e0 1e 0c 04 01 19 01 03 63 6f 75 6e 74 79 21 11 04 01 23 01 03 64 65 73 63 72 69 70 74 69 6f 6e 1b .......county!...#..description.
6400 0a 00 00 00 3b 00 c1 00 02 4d 02 5b 02 6d 02 7c 02 89 02 95 02 a2 02 ac 02 b7 02 c5 02 d7 02 e4 ....;....M.[.m.|................
6420 02 f6 03 05 03 13 03 25 03 34 03 41 03 4d 03 5a 03 64 03 6f 03 7d 03 8f 03 9c 03 ae 03 bd 02 3b .......%.4.A.M.Z.d.o.}.........;
6440 03 cb 03 da 03 e7 03 f3 02 31 01 c0 01 e4 01 f2 01 cb 02 1f 01 b1 02 11 01 83 01 95 02 04 01 d8 .........1......................
6460 01 a4 01 79 01 08 01 2c 01 3a 01 13 01 67 00 f9 01 59 00 cb 00 dd 01 4c 01 20 00 ec 00 c1 00 00 ...y...,.:...g...Y.....L........
6480 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
64a0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................................
64c0 00 09 04 01 13 01 07 75 72 6c 5b 11 04 01 23 01 07 70 68 6f 6e 65 4e 75 6d 62 65 72 5a 0e 04 01 .......url[...#..phoneNumberZ...
64e0 1d 01 07 70 6f 73 74 63 6f 64 65 59 0c 04 01 19 01 07 73 74 72 65 65 74 58 0e 04 01 1d 01 07 64 ...postcodeY......streetX......d
6500 69 73 74 72 69 63 74 57 0a 04 01 15 01 07 63 69 74 79 56 0c 04 01 19 01 07 63 6f 75 6e 74 79 55 istrictW......cityV......countyU
6520 0b 04 01 17 01 07 73 74 61 74 65 54 0d 04 01 1b 01 07 63 6f 75 6e 74 72 79 53 11 04 01 23 01 07 ......stateT......countryS...#..
6540 63 6f 75 6e 74 72 79 43 6f 64 65 52 0c 04 01 19 01 07 72 61 64 69 75 73 51 0d 04 01 1b 01 07 69 countryCodeR......radiusQ......i
6560 63 6f 6e 55 72 6c 50 11 04 01 23 01 07 64 65 73 63 72 69 70 74 69 6f 6e 4f 09 04 01 13 01 06 75 conUrlP...#..descriptionO......u
6580 72 6c 4e 11 04 01 23 01 06 70 68 6f 6e 65 4e 75 6d 62 65 72 4d 0e 04 01 1d 01 06 70 6f 73 74 63 rlN...#..phoneNumberM......postc
65a0 6f 64 65 4c 0c 04 01 19 01 06 73 74 72 65 65 74 4b 0e 04 01 1d 01 06 64 69 73 74 72 69 63 74 4a odeL......streetK......districtJ
65c0 0a 04 01 15 01 06 63 69 74 79 49 0c 04 01 19 01 06 63 6f 75 6e 74 79 48 0b 04 01 17 01 06 73 74 ......cityI......countyH......st
65e0 61 74 65 47 0d 04 01 1b 01 06 63 6f 75 6e 74 72 79 46 11 04 01 23 01 06 63 6f 75 6e 74 72 79 43 ateG......countryF...#..countryC
6600 6f 64 65 45 0c 04 01 19 01 06 72 61 64 69 75 73 44 0d 04 01 1b 01 06 69 63 6f 6e 55 72 6c 43 11 odeE......radiusD......iconUrlC.
6620 04 01 23 01 06 64 65 73 63 72 69 70 74 69 6f 6e 42 09 04 01 13 01 05 75 72 6c 41 11 04 01 23 01 ..#..descriptionB......urlA...#.
6640 05 70 68 6f 6e 65 4e 75 6d 62 65 72 40 0d 04 01 1b 01 03 69 63 6f 6e 55 72 6c 1c 11 04 01 23 01 [email protected]....#.
6660 03 70 68 6f 6e 65 4e 75 6d 62 65 72 26 0e 04 01 1d 01 03 70 6f 73 74 63 6f 64 65 25 0c 04 01 19 .phoneNumber&......postcode%....
6680 01 03 72 61 64 69 75 73 1d 0b 04 01 17 01 03 73 74 61 74 65 20 0c 04 01 19 01 03 73 74 72 65 65 ..radius.......state.......stree
66a0 74 24 09 04 01 13 01 03 75 72 6c 27 0a 04 01 15 01 04 63 69 74 79 2f 0d 04 01 1b 01 04 63 6f 75 t$......url'......city/......cou
66c0 6e 74 72 79 2c 11 04 01 23 01 04 63 6f 75 6e 74 72 79 43 6f 64 65 2b 0c 04 01 19 01 04 63 6f 75 ntry,...#..countryCode+......cou
66e0 6e 74 79 2e 11 04 01 23 01 04 64 65 73 63 72 69 70 74 69 6f 6e 28 0e 04 01 1d 01 04 64 69 73 74 nty....#..description(......dist
6700 72 69 63 74 30 0d 04 01 1b 01 04 69 63 6f 6e 55 72 6c 29 11 04 01 23 01 04 70 68 6f 6e 65 4e 75 rict0......iconUrl)...#..phoneNu
6720 6d 62 65 72 33 0e 04 01 1d 01 04 70 6f 73 74 63 6f 64 65 32 0c 04 01 19 01 04 72 61 64 69 75 73 mber3......postcode2......radius
6740 2a 0b 04 01 17 01 04 73 74 61 74 65 2d 0c 04 01 19 01 04 73 74 72 65 65 74 31 09 04 01 13 01 04 *......state-......street1......
6760 75 72 6c 34 0a 04 01 15 01 05 63 69 74 79 3c 0d 04 01 1b 01 05 63 6f 75 6e 74 72 79 39 11 04 01 url4......city<......country9...
6780 23 01 05 63 6f 75 6e 74 72 79 43 6f 64 65 38 0c 04 01 19 01 05 63 6f 75 6e 74 79 3b 11 04 01 23 #..countryCode8......county;...#
67a0 01 05 64 65 73 63 72 69 70 74 69 6f 6e 35 0e 04 01 1d 01 05 64 69 73 74 72 69 63 74 3d 0d 04 01 ..description5......district=...
67c0 1b 01 05 69 63 6f 6e 55 72 6c 36 0e 04 01 1d 01 05 70 6f 73 74 63 6f 64 65 3f 0c 04 01 19 01 05 ...iconUrl6......postcode?......
67e0 72 61 64 69 75 73 37 0b 04 01 17 01 05 73 74 61 74 65 3a 0c 04 01 19 01 05 73 74 72 65 65 74 3e radius7......state:......street>