Changes between Version 21 and Version 22 of OriaEda

Timestamp:

Nov 23, 2010 3:51:18 PM (14 years ago)

Author:

celine

Comment:

--

OriaEda

@@ -165 +165 @@
 );
 alter table oria.obstacles_ccm_500 add column id serial;
+-- creation d'index, clé primaire, et constraintes qui vont bien
+alter table oria.obstacles_ccm_500 add CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2);
+alter table oria.obstacles_ccm_500 add  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL);
+alter table oria.obstacles_ccm_500 add  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 3035);
+
 }}}