---
source: mbtiles/tests/copy.rs
expression: actual_value
---
- type: table
tbl_name: images
sql: "CREATE TABLE images (\n tile_id TEXT NOT NULL PRIMARY KEY,\n tile_data BLOB\n)"
values:
- "( \"0A62AF3A2A3D38C0E8FF098A684C3EC1\", blob(1F8B08000000000000FF2BCACF2F01005BF9F41604000000) )"
- "( \"0D9BABF1C0099632D55F6274FB15419F\", blob(1F8B08000000000000FF2B4ACDCD2F4B0500301D806806000000) )"
- "( \"163BE0A88C70CA629FD516DBAADAD96A\", blob(1F8B08000000000000FF03000000000000000000) )"
- "( \"3CD93E79D6812F995906036D24282DBE\", blob(1F8B08000000000000FF33D4CD4E4D2DD035D42DCA050026D508C30B000000) )"
- "( \"4DE1D83BFD7CB6ACE583AA7D5A18725A\", blob(1F8B08000000000000FFCBCBCFD34DCD2D28A9040006173DB509000000) )"
- "( \"98AD49106F1CE0AA003027C229A70F7E\", blob(1F8B08000000000000FF2B4ECC4D050044F150FC04000000) )"
- "( \"A4D55DDE3B49D78DD9846688A0786F2D\", blob(1F8B08000000000000FF4B4DC92CD12D3304007ED8D6BF07000000) )"
- type: table
tbl_name: map
sql: "CREATE TABLE map (\n zoom_level INTEGER NOT NULL,\n tile_column INTEGER NOT NULL,\n tile_row INTEGER NOT NULL,\n tile_id TEXT,\n PRIMARY KEY (zoom_level, tile_column, tile_row)\n)"
values:
- "( 3, 6, 7, \"0A62AF3A2A3D38C0E8FF098A684C3EC1\" )"
- "( 5, 0, 0, \"98AD49106F1CE0AA003027C229A70F7E\" )"
- "( 5, 0, 1, \"163BE0A88C70CA629FD516DBAADAD96A\" )"
- "( 5, 1, 1, \"A4D55DDE3B49D78DD9846688A0786F2D\" )"
- "( 5, 1, 2, \"163BE0A88C70CA629FD516DBAADAD96A\" )"
- "( 5, 1, 3, \"4DE1D83BFD7CB6ACE583AA7D5A18725A\" )"
- "( 5, 2, 2, \"0D9BABF1C0099632D55F6274FB15419F\" )"
- "( 5, 2, 3, \"163BE0A88C70CA629FD516DBAADAD96A\" )"
- "( 6, 0, 3, \"98AD49106F1CE0AA003027C229A70F7E\" )"
- "( 6, 0, 5, \"3CD93E79D6812F995906036D24282DBE\" )"
- "( 6, 1, 4, \"A4D55DDE3B49D78DD9846688A0786F2D\" )"
- "( 6, 2, 6, \"3CD93E79D6812F995906036D24282DBE\" )"
- type: table
tbl_name: metadata
sql: "CREATE TABLE metadata (\n name TEXT NOT NULL PRIMARY KEY,\n value TEXT\n)"
values:
- "( \"agg_tiles_hash\", \"C0CA886B149CE416242AB2AFE8E641AD\" )"
- "( \"md-edit\", \"value - v1\" )"
- "( \"md-remove\", \"value - remove\" )"
- "( \"md-same\", \"value - same\" )"
- type: index
tbl_name: images
sql: ~
values: ~
- type: index
tbl_name: map
sql: ~
values: ~
- type: index
tbl_name: metadata
sql: ~
values: ~
- type: view
tbl_name: tiles
sql: "CREATE VIEW tiles AS\nSELECT\n map.zoom_level,\n map.tile_column,\n map.tile_row,\n images.tile_data\nFROM map\nINNER JOIN images ON map.tile_id = images.tile_id"
values: ~
- type: view
tbl_name: tiles_with_hash
sql: "CREATE VIEW tiles_with_hash AS\nSELECT\n map.zoom_level,\n map.tile_column,\n map.tile_row,\n images.tile_data,\n images.tile_id AS tile_hash\nFROM map\nINNER JOIN images ON map.tile_id = images.tile_id"
values: ~