Changes between Version 15 and Version 16 of PATE Anguille

Timestamp:

Feb 2, 2012 11:03:40 AM (13 years ago)

Author:

celine

Comment:

--

PATE Anguille

@@ -56 +56 @@
 alter table rht.rhtvs2_roe_pate_bv11axes rename to rht.pate;
 COMMENT ON TABLE rht.pate IS 'Table pate comes from roe_pate_bv11axes.xls'
+}}}
+
+'''Changement des noms'''
+{{{
+alter table rht.pate RENAME COLUMN "Numéro" TO Numero;
+alter table rht.pate RENAME COLUMN "BV" TO BV;
+alter table rht.pate RENAME COLUMN "Q équipement" TO Q_equipement;
+alter table rht.pate RENAME COLUMN "XL93" TO XL93;
+alter table rht.pate RENAME COLUMN "YL93" TO YL93;
+alter table rht.pate RENAME COLUMN "Nom" TO Nom;
+alter table rht.pate RENAME COLUMN "typeNom" TO typeNom;
+alter table rht.pate RENAME COLUMN "stypeNom" TO stypeNom;
+alter table rht.pate RENAME COLUMN "staNom" TO staNom;
+alter table rht.pate RENAME COLUMN "dateModif" TO dateModif;
+alter table rht.pate RENAME COLUMN "nomCart" TO nomCart;
+alter table rht.pate RENAME COLUMN "nomTopo" TO nomTopo;
+alter table rht.pate RENAME COLUMN "commNom" TO commNom;
+alter table rht.pate RENAME COLUMN "deptNom" TO deptNom;
+alter table rht.pate RENAME COLUMN "CHCart" TO CHCart;
+alter table rht.pate RENAME COLUMN "note_fr_An" TO note_fr_An
 }}}