SET NAMES 'UTF8';
--
--
start transaction;
-- "Transport par câble. Moyen de transport constitué d'un ou plusieurs c^:ables porteurs":
--
create table TRANSPORT_CABLE (gid SERIAL not null, ID varchar(24) not null, PREC_PLANI decimal(6,1) not null, PREC_ALTI decimal(7,1) not null, NATURE varchar(19) default 'NR', Z_MIN float, Z_MAX float, Z_INI float, Z_FIN float, constraint TRANSPORT_CABLE_pkey primary key (gid));
select AddGeometryColumn('','transport_cable','the_geom','2972','MULTILINESTRING',3);
create index TRANSPORT_CABLE_geoidx on TRANSPORT_CABLE using gist (the_geom);
--
commit;
--
