SELECT DropGeometryColumn('public','poslist','geom');
DROP TABLE IF EXISTS poslist;
SELECT DropGeometryColumn('public','suolo','geom');
DROP TABLE IF EXISTS suolo;
SELECT DropGeometryColumn('public','linee_elementari','geom');
DROP TABLE IF EXISTS linee_elementari;
CREATE TABLE SUOLO (CODPOLIGONO VARCHAR(35) PRIMARY KEY, CODCLASSE VARCHAR(35), CODORIGINESUOLO VARCHAR(35), TAGNO INTEGER  );
SELECT AddGeometryColumn( 'public','suolo', 'geom',3003, 'POLYGON', 2 );
alter table suolo add column oid serial not null;
CREATE TABLE POSLIST (ID VARCHAR(35) PRIMARY KEY, IDLINESTRING VARCHAR(35), POSLIST VARCHAR(200000), LUNG_POSLIST INTEGER, NUM_VERTEX INTEGER , DIMENSION VARCHAR(1)  );
SELECT AddGeometryColumn( 'public','poslist', 'geom',3003, 'LINESTRING', 2 );
alter table poslist add column oid serial not null;
CREATE TABLE LINEE_ELEMENTARI (CODLINEA VARCHAR(35) PRIMARY KEY, CODCTR VARCHAR(35), CODVISIBILITA VARCHAR(35), CODBREAKLINE VARCHAR(35), CODCLASSE VARCHAR(35), CODLATOVESTIZIONE VARCHAR(35), CODORIGINELINEA VARCHAR(35), CODMODIFICA VARCHAR(35), POSLIST VARCHAR(200000), LUNG_POSLIST INTEGER, NUM_VERTEX INTEGER, IDEDGE VARCHAR(35), SRSNAME VARCHAR(35), DIMENSION VARCHAR(1), COORD_N1 VARCHAR(50), COORD_N2 VARCHAR(50)  );
SELECT AddGeometryColumn( 'public','linee_elementari', 'geom',3003, 'LINESTRING', 2 );
alter table linee_elementari add column oid serial not null;
