---
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:
- "( \"03132BFACDB00CC63D6B7DD98D974DD5\", blob(edit-v2a) )"
- "( \"22AF645D1859CB5CA6DA0C484F1F37EA\", blob(new) )"
- "( \"51037A4A37730F52C8732586D3AAA316\", blob(same) )"
- "( \"535A5575B48444EDEB926815AB26EC9B\", blob(1-keep-1-rm) )"
- "( \"63A9F0EA7BB98050796B649E85481845\", blob(root) )"
- "( \"99DEE0E66806ECF1C20C09F64B2C0A34\", blob(not-empty) )"
- "( \"D41D8CD98F00B204E9800998ECF8427E\", blob() )"
- "( \"FF76830FF90D79BB335884F256031731\", blob(edit-v2) )"
- 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, \"63A9F0EA7BB98050796B649E85481845\" )"
- "( 5, 0, 0, \"51037A4A37730F52C8732586D3AAA316\" )"
- "( 5, 0, 1, \"D41D8CD98F00B204E9800998ECF8427E\" )"
- "( 5, 1, 1, \"FF76830FF90D79BB335884F256031731\" )"
- "( 5, 1, 2, \"99DEE0E66806ECF1C20C09F64B2C0A34\" )"
- "( 5, 1, 3, \"D41D8CD98F00B204E9800998ECF8427E\" )"
- "( 5, 3, 7, \"22AF645D1859CB5CA6DA0C484F1F37EA\" )"
- "( 5, 3, 8, \"22AF645D1859CB5CA6DA0C484F1F37EA\" )"
- "( 6, 0, 3, \"51037A4A37730F52C8732586D3AAA316\" )"
- "( 6, 0, 5, \"535A5575B48444EDEB926815AB26EC9B\" )"
- "( 6, 1, 4, \"03132BFACDB00CC63D6B7DD98D974DD5\" )"
- type: table
tbl_name: metadata
sql: "CREATE TABLE metadata (\n name TEXT NOT NULL PRIMARY KEY,\n value TEXT\n)"
values:
- "( \"agg_tiles_hash\", \"3BCDEE3F52407FF1315629298CB99133\" )"
- "( \"md-edit\", \"value - v2\" )"
- "( \"md-new\", \"value - new\" )"
- "( \"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: ~