SET NAMES 'UTF8';
--
--
start transaction;
-- "Canalisation ou tapis roulant":
--
create table CANALISATION_EAU (gid SERIAL not null, ID varchar(24) not null, PREC_PLANI decimal(6,1) not null, PREC_ALTI decimal(7,1) not null, POS_SOL integer not null, constraint CANALISATION_EAU_pkey primary key (gid));
select AddGeometryColumn('','canalisation_eau','the_geom','4471','MULTILINESTRING',3);
create index CANALISATION_EAU_geoidx on CANALISATION_EAU using gist (the_geom);
--
commit;
--
