Différences entre version 1 et version 2 de RequetesMigrationLims

Timestamp :

23 mars 2009 à 15:59:37 (16 ans)

Auteur :

laz

Commentaire :

--

RequetesMigrationLims

@@ -14 +14 @@
 ALTER TABLE at_account rename lab_loncin to lab_arsia;
 ALTER TABLE at_account rename lab_mons to lab_var;
+
+ALTER TABLE vetoweb_info ADD COLUMN new_col varchar;
+UPDATE vetoweb_info SET new_col = CAST(vwinfo_rq_sanitel_id AS varchar);
+ALTER TABLE vetoweb_info DROP COLUMN vwinfo_rq_sanitel_id;
+ALTER TABLE vetoweb_info RENAME new_col TO vwinfo_rq_sanitel_id;
+update vetoweb_info set vwinfo_rq_sanitel_id = 'BE'||vwinfo_rq_sanitel_id||'-0101' where vwinfo_rq_sanitel_id != '';
 }}}