Changes between Version 10 and Version 11 of BDCarthage2011 into eda2.0_RHT

Timestamp:

Sep 27, 2011 5:43:16 PM (14 years ago)

Author:

celine

Comment:

--

BDCarthage2011 into eda2.0_RHT

@@ -86 +86 @@
 CREATE TABLE  rht.rht_Bretagne AS
     SELECT * FROM rht.rht
-        WHERE id_drain IN (SELECT id_drain FROM uga2010.id_drain WHERE area='Bretagne');
-ALTER TABLE rht.rht_Bretagne ADD CONSTRAINT c_pk_gid_rht_Bretagne PRIMARY KEY  (id_drain);
+        WHERE id_drain IN (SELECT id_drain FROM uga2010.id_drain WHERE uga='Bretagne');
+ALTER TABLE rht.rht_Bretagne ADD CONSTRAINT pk_id_drain_rht_Bretagne PRIMARY KEY  (id_drain);
 INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
 SELECT '', 'rht', 'rht_Bretagne', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)