Silverpeas » Silverpeas Core

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

;