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)
    );
""";