Project

General

Profile

Download (481 Bytes)

Bug #638 » sb_tree_tree_FromV4.sql

Nicolas Eysseric, 06/18/2010 03:28 PM

 
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)