GPKG_CONTENTS top-level constant
String
const GPKG_CONTENTS
Implementation
const GPKG_CONTENTS = """
CREATE TABLE IF NOT EXISTS $TABLE_GEOPACKAGE_CONTENTS (
table_name TEXT NOT NULL PRIMARY KEY,
data_type TEXT NOT NULL,
identifier TEXT UNIQUE,
description TEXT DEFAULT '',
last_change DATETIME NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
min_x DOUBLE,
min_y DOUBLE,
max_x DOUBLE,
max_y DOUBLE,
srs_id INTEGER,
CONSTRAINT fk_gc_r_srs_id FOREIGN KEY (srs_id) REFERENCES $TABLE_SPATIAL_REF_SYS(srs_id)
);
""";