Project

General

Profile

Bug #638 » sb_tree_tree_FromV4.sql

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

 
1
ALTER TABLE SB_Tree_Tree
2
ADD orderNumberBis int NULL
3
;
4

    
5
ALTER TABLE SB_Tree_Tree
6
ADD langBis char(2) NULL
7
;
8

    
9
update sb_tree_tree
10
set orderNumberBis = cast(orderNumber AS integer)
11
;
12

    
13
update sb_tree_tree
14
set langBis = lang
15
;
16

    
17
ALTER TABLE SB_Tree_Tree
18
drop column orderNumber
19
;
20

    
21
ALTER TABLE SB_Tree_Tree
22
drop column lang
23
;
24

    
25
ALTER TABLE SB_Tree_Tree 
26
RENAME COLUMN orderNumberBis TO orderNumber
27
;
28

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