Projet

Général

Profil

Télécharger (481 octets)

Bug #638 » sb_tree_tree_FromV4.sql

Nicolas Eysseric, 18/06/2010 15:28

 
ALTER TABLE SB_Tree_Tree
ADD orderNumberBis int NULL
;

ALTER TABLE SB_Tree_Tree
ADD langBis char(2) NULL
;

update sb_tree_tree
set orderNumberBis = cast(orderNumber AS integer)
;

update sb_tree_tree
set langBis = lang
;

ALTER TABLE SB_Tree_Tree
drop column orderNumber
;

ALTER TABLE SB_Tree_Tree
drop column lang
;

ALTER TABLE SB_Tree_Tree
RENAME COLUMN orderNumberBis TO orderNumber
;

ALTER TABLE SB_Tree_Tree
RENAME COLUMN langBis TO lang
;
    (1-1/1)