---
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: []
- 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: []
- type: table
tbl_name: metadata
sql: "CREATE TABLE metadata (\n name TEXT NOT NULL PRIMARY KEY,\n value TEXT\n)"
values:
- "( \"agg_tiles_hash\", \"D41D8CD98F00B204E9800998ECF8427E\" )"
- 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: ~