Différences entre version initiale et version 1 de RequetesMigrationLims

Timestamp :

22 mars 2009 à 10:20:06 (15 ans)

Auteur :

laz

Commentaire :

--

RequetesMigrationLims

@@ +1 @@
+{{{
+ALTER TABLE at_san_person DROP COLUMN animal_type;
+ALTER TABLE at_san_person ADD COLUMN new_col varchar;
+UPDATE at_san_person SET new_col = CAST(sanitel_id AS varchar);
+ALTER TABLE at_san_person DROP COLUMN sanitel_id;
+ALTER TABLE at_san_person RENAME new_col TO sanitel_id;
+
+ALTER TABLE at_account drop column lab_alken;
+ALTER TABLE at_account drop column lab_drongen;
+ALTER TABLE at_account drop column lab_torhout;
+ALTER TABLE at_account drop column lab_lier;
+ALTER TABLE at_account drop column lab_ciney;
+ALTER TABLE at_account rename lab_marloie to lab_dgz;
+ALTER TABLE at_account rename lab_loncin to lab_arsia;
+ALTER TABLE at_account rename lab_mons to lab_var;
+}}}