⚲
Project
General
Profile
Sign in
Register
Home
Projects
Help
Search
:
Silverpeas Core
All Projects
Silverpeas
»
Silverpeas Core
Overview
Activity
Roadmap
Issues
Spent time
Gantt
Calendar
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)
Loading...