Changes between Version 1 and Version 2 of Ticket #7007, comment 7


Ignore:
Timestamp:
Aug 18, 2017, 2:14:13 PM (7 years ago)
Author:
Jukka Rahkonen

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #7007, comment 7

    v1 v2  
    33Pragma shows some differences in the primary key column
    44
     5
     6{{{
    57Original gpkg
    680       OBJECTID        INTEGER 1       NULL    1
    … …  
    10120       OBJECTID        INTEGER 0       NULL    1
    1113
     14}}}
     15
    1216The difference is in the "not null" but we both know from the discussion on the OGC GeoPackage issue tracker that it does not really change anything to have not null or not to have it in "CREATE TABLE counties (OBJECTID INTEGER primary key autoincrement not null"