New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL definition of gpkg_metadata omits DEFAULT of '' for metadata column #243

Closed
rcasscslt opened this Issue Sep 20, 2016 · 0 comments

Comments

Projects
None yet
2 participants
@rcasscslt
Contributor

rcasscslt commented Sep 20, 2016

In Table 32 "Metadata Table definition",

The metadata column is defined as NOT NULL and having a default of ''

However, Table 35 , gpkg_metadata Table Definition SQLdefines the column as not null, but does not explicitly declare the default value of ''

Should the definition be


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 DEFAULT '');


jyutzler added a commit to jyutzler/geopackage that referenced this issue Sep 20, 2016

@jyutzler jyutzler added this to the 1.2 milestone Sep 20, 2016

jyutzler added a commit that referenced this issue Sep 27, 2016

Merge pull request #246 from jyutzler/i243
adding default to SQL for table creation #243

@jyutzler jyutzler closed this Sep 27, 2016

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment