Changes between Version 42 and Version 43 of PATE Anguille

Timestamp:

Feb 15, 2012 2:12:17 PM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -261 +261 @@
 
 
-== ROE_v2.obstacle ==
+== ROE_v3.obstacle ==
 Integration du ROE version 13/02/2012
 {{{
@@ -269 +269 @@
 C:\"Program Files"\PostgreSQL\8.4\bin\psql  -U postgres --dbname "eda2.0_RHT" -f "roe.sql"
 
-alter table obstacle set schema roe_v2
-COMMENT ON TABLE roe_v2.obstacle IS 'Table transmise par Laurent du 13 février 2012';
-
-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;
+alter table obstacle set schema roe_v3
+COMMENT ON TABLE roe_v3.obstacle IS 'Table transmise par Laurent du 13 février 2012';
+
+UPDATE roe_v3.obstacle SET the_geom = ST_transform(the_geom, 3035); 
+ALTER TABLE roe_v3.obstacle ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
+
+alter table roe_v3.obstacle RENAME COLUMN "Id_ROE" TO Id_ROE;
+alter table roe_v3.obstacle RENAME COLUMN  "Nom" TO Nom;
+alter table roe_v3.obstacle RENAME COLUMN "typeNom" TO typeNom;
+alter table roe_v3.obstacle RENAME COLUMN "stypeNom" TO stypeNom;
+alter table roe_v3.obstacle RENAME COLUMN "staNom" TO staNom;
+alter table roe_v3.obstacle RENAME COLUMN "etatNom" TO etatNom;
+alter table roe_v3.obstacle RENAME COLUMN "IdTrCart" TO IdTrCart;
+alter table roe_v3.obstacle RENAME COLUMN "nomCart" TO nomCart;
+alter table roe_v3.obstacle RENAME COLUMN "CHCart" TO CHCart;
+alter table roe_v3.obstacle RENAME COLUMN "CGCart" TO CGCart;
+alter table roe_v3.obstacle RENAME COLUMN "ZHCart" TO ZHCart;
+alter table roe_v3.obstacle RENAME COLUMN "nomTopo" TO nomTopo;
+alter table roe_v3.obstacle RENAME COLUMN "commNom" TO commNom;
+alter table roe_v3.obstacle RENAME COLUMN "deptCd" TO deptCd;
 }}}