Individual name for primary key in 'New SpatiaLite Layer' dialogue

[qgib]

Author Name: Reinhard Reiterer (Reinhard Reiterer)
Original Redmine Issue: 14344

Redmine category:data_provider/spatialite

---

Please allow users to set the name of the primary key individually in the 'New SpatiaLite Layer' dialogue (Crtl+Shift+A).

---

• new_spatialite_layer.png (Reinhard Reiterer)
• new_geopackage_layer.png (Reinhard Reiterer)

[qgib]

Author Name: Reinhard Reiterer (Reinhard Reiterer)

---

Maybe 'New SpatiaLite Layer' and 'New GeoPackage Layer' should share the same dialog. 'New GeoPackage Layer' allows to set the name of the primary key/feature id individually.

---

• 10042 was configured as new_geopackage_layer.png
• 10041 was configured as new_spatialite_layer.png

---

• new_geopackage_layer.png (Reinhard Reiterer)
• new_spatialite_layer.png (Reinhard Reiterer)

[qgib]

Author Name: Jukka Rahkonen (Jukka Rahkonen)

---

The "Create autoincrementing primary key" exists there probably because of the word "autoincrementing". SQLite has always a primary key in the system "ROWID". Creating a synonym for ROWID as "COLUMN INTEGER PRIMARY KEY AUTOINCREMENT" makes fids stable so that that the rowids of deleted rows will not be reused.

Would you like to have two selections:

• prevent reuse of rowids of deleted features (autoincrement)
• select the name to be used as synonym for ROWID?

[qgib]

Author Name: Reinhard Reiterer (Reinhard Reiterer)

---

Primary keys for new SpatiaLite layers are always named 'pkuid'. The 'New SpatiaLite Layer' dialog misses a text field to set the name (e.g. 'gid', 'fid').

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• easy_fix was configured as 0