[gdal-dev] Schema of gpkg_metadata in Geopackage

[Rahkonen Jukka (MML)]

Hi,

GDAL 2.3-dev creates gpkg_metadata table as

CREATE TABLE gpkg_metadata (id INTEGER CONSTRAINT m_pk PRIMARY KEY ASC NOT NULL UNIQUE,md_scope TEXT NOT NULL DEFAULT 'dataset',md_standard_uri TEXT NOT NULL,mime_type TEXT NOT NULL DEFAULT 'text/xml',metadata TEXT NOT NULL DEFAULT '');

In GPKG standard v. 1.0.1 and 1.2 the SQL is


CREATE TABLE gpkg_metadata (

id INTEGER CONSTRAINT m_pk PRIMARY KEY ASC NOT NULL,

md_scope TEXT NOT NULL DEFAULT 'dataset',

md_standard_uri TEXT NOT NULL,

mime_type TEXT NOT NULL DEFAULT 'text/xml',

metadata TEXT NOT NULL
)

It seems that UNIQUE was removed in 1.0.1 corrigendum. I am not sure about what to think about having "metadata TEXT NOT NULL DEFAULT ''". In table 14 in standard version 1.0.1 and also in table 32 in standard v. 1.2 there is an empty string as a default value but it does not reflect to the CREATE TABLE example.

-Jukka Rahkonen-


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20170823/80946755/attachment.html>