GPKG_GEOMETRY_COLUMNS top-level constant
String
const GPKG_GEOMETRY_COLUMNS
Implementation
const GPKG_GEOMETRY_COLUMNS = """
CREATE TABLE IF NOT EXISTS $TABLE_GEOMETRY_COLUMNS (
table_name TEXT NOT NULL,
column_name TEXT NOT NULL,
geometry_type_name TEXT NOT NULL,
srs_id INTEGER NOT NULL,
z TINYINT NOT NULL,
m TINYINT NOT NULL,
CONSTRAINT pk_geom_cols PRIMARY KEY (table_name, column_name),
CONSTRAINT uk_gc_table_name UNIQUE (table_name),
CONSTRAINT fk_gc_tn FOREIGN KEY (table_name) REFERENCES $TABLE_GEOPACKAGE_CONTENTS(table_name),
CONSTRAINT fk_gc_srs FOREIGN KEY (srs_id) REFERENCES $TABLE_SPATIAL_REF_SYS (srs_id)
);
""";