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-
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
