--------------------------------------------------------------------------------
-- Instructions pour l'utilisation du SIG via postgis
--
-- @package openfoncier
-- @version SVN : $Id: init_metier_sig.sql 1804 2013-04-30 14:45:17Z fmichon $
--------------------------------------------------------------------------------

--
ALTER TABLE dossier DROP COLUMN geom;
ALTER TABLE dossier DROP COLUMN geom1;
ALTER TABLE parcelle DROP COLUMN geom;
ALTER TABLE parcelle_lot DROP COLUMN geom;
ALTER TABLE pos DROP COLUMN geom;
ALTER TABLE servitude_surfacique DROP COLUMN geom;
ALTER TABLE servitude_ligne DROP COLUMN geom;
ALTER TABLE servitude_point DROP COLUMN geom;

--
SELECT AddGeometryColumn ( 'dossier', 'geom', 2154 , 'POINT', 2 );
SELECT AddGeometryColumn ( 'dossier', 'geom1', 2154 , 'MULTIPOLYGON', 2 );
SELECT AddGeometryColumn ( 'parcelle', 'geom', 2154 , 'POLYGON', 2 );
SELECT AddGeometryColumn ( 'parcelle_lot', 'geom', 2154 , 'POLYGON', 2 );
SELECT AddGeometryColumn ( 'pos', 'geom', 2154 , 'POLYGON', 2 );
SELECT AddGeometryColumn ( 'servitude_surfacique', 'geom', 2154 , 'POLYGON', 2 );
SELECT AddGeometryColumn ( 'servitude_ligne', 'geom', 2154 , 'LINESTRING', 2 );
SELECT AddGeometryColumn ( 'servitude_point', 'geom', 2154 , 'POINT', 2 );
