From 12bb379ebab23813973fba0bd34287a4e069b778 Mon Sep 17 00:00:00 2001 From: Kaj-Michael Lang Date: Thu, 25 Oct 2007 23:49:55 +0300 Subject: [PATCH] Fix POI id fields to be AUTOINCREMENT.. --- docs/osm-tables.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/docs/osm-tables.sql b/docs/osm-tables.sql index b82f47c..f7938ce 100644 --- a/docs/osm-tables.sql +++ b/docs/osm-tables.sql @@ -72,7 +72,7 @@ create table places ( ); create table poi ( - poi_id int PRIMARY KEY, + poi_id INTEGER PRIMARY KEY AUTOINCREMENT, lat real not null, lon real not null, elev real default 0.0, @@ -89,7 +89,7 @@ create table poi ( ); create table category ( - cat_id int PRIMARY KEY, + cat_id INTEGER PRIMARY KEY AUTOINCREMENT, pcat_id int, priority int not null default 2, label text, -- 2.39.5