Changes between Version 39 and Version 40 of PATE Anguille

Timestamp:

Feb 15, 2012 9:59:18 AM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -260 +260 @@
 
 
-== ROE ==
+== ROE_v2.obstacle ==
 Integration du ROE version 13/02/2012
 {{{
@@ -273 +273 @@
 UPDATE roe_v2.obstacle SET the_geom = ST_transform(the_geom, 3035); 
 ALTER TABLE roe_v2.obstacle ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+
+alter table roe_v2.obstacle RENAME COLUMN "Id_ROE" TO Id_ROE;
+alter table roe_v2.obstacle RENAME COLUMN  "Nom" TO Nom;
+alter table roe_v2.obstacle RENAME COLUMN "typeNom" TO typeNom;
+alter table roe_v2.obstacle RENAME COLUMN "stypeNom" TO stypeNom;
+alter table roe_v2.obstacle RENAME COLUMN "staNom" TO staNom;
+alter table roe_v2.obstacle RENAME COLUMN "etatNom" TO etatNom;
+alter table roe_v2.obstacle RENAME COLUMN "IdTrCart" TO IdTrCart;
+alter table roe_v2.obstacle RENAME COLUMN "nomCart" TO nomCart;
+alter table roe_v2.obstacle RENAME COLUMN "CHCart" TO CHCart;
+alter table roe_v2.obstacle RENAME COLUMN "CGCart" TO CGCart;
+alter table roe_v2.obstacle RENAME COLUMN "ZHCart" TO ZHCart;
+alter table roe_v2.obstacle RENAME COLUMN "nomTopo" TO nomTopo;
+alter table roe_v2.obstacle RENAME COLUMN "commNom" TO commNom;
+alter table roe_v2.obstacle RENAME COLUMN "deptCd" TO deptCd;
 }}}