Skip to content

Instantly share code, notes, and snippets.

@pigreco
Last active Dec 21, 2016
Embed
What would you like to do?
CREATE TABLE "pti_monumenti"
(
"pk_uid" integer PRIMARY KEY autoincrement NOT NULL,
"data_rilievo" date,
"nome_monumento" text,
"link_foto" text,
"note" text
)
-- aggiungo colonna geometrica
SELECT AddGeometryColumn ('pti_monumenti','geom',3004,'POINT','XY'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment