analytics/configuration/schemas/content/sqlserver/dbUpgrade4_0056-to-4_0057_mssqlserver.sql

-- Licensed Materials - Property of IBM
--
-- BI and PM: CM
--
-- (C) Copyright IBM Corp. 2008, 2009
--
-- US Government Users Restricted Rights - Use, duplication or disclosure
-- restricted by GSA ADP Schedule Contract with IBM Corp.

-- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
-- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).


update CMOBJECTS set DISPSEQ=135 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=0)

update CMOBJECTS set DISPSEQ=20 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=1)

update CMOBJECTS set DISPSEQ=160 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=2)

update CMOBJECTS set DISPSEQ=145 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=3)

update CMOBJECTS set DISPSEQ=15 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=4)

update CMOBJECTS set DISPSEQ=15 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=5)

update CMOBJECTS set DISPSEQ=25 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=6)

update CMOBJECTS set DISPSEQ=10 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=8)

update CMOBJECTS set DISPSEQ=165 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=10)

update CMOBJECTS set DISPSEQ=10 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=11)

update CMOBJECTS set DISPSEQ=10 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=12)

update CMOBJECTS set DISPSEQ=180 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=13)

update CMOBJECTS set DISPSEQ=20 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=14)

update CMOBJECTS set DISPSEQ=10 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=15)

update CMOBJECTS set DISPSEQ=30 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=16)

update CMOBJECTS set DISPSEQ=40 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=17)

update CMOBJECTS set DISPSEQ=60 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=18)

update CMOBJECTS set DISPSEQ=45 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=19)

update CMOBJECTS set DISPSEQ=30 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=21)

update CMOBJECTS set DISPSEQ=70 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=22)

update CMOBJECTS set DISPSEQ=140 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=23)

update CMOBJECTS set DISPSEQ=150 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=24)

update CMOBJECTS set DISPSEQ=115 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=25)

update CMOBJECTS set DISPSEQ=110 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=26)

update CMOBJECTS set DISPSEQ=27 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=27)

update CMOBJECTS set DISPSEQ=20 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=28)

update CMOBJECTS set DISPSEQ=175 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=29)

update CMOBJECTS set DISPSEQ=15 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=30)

update CMOBJECTS set DISPSEQ=170 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=31)

update CMOBJECTS set DISPSEQ=100 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=32)

update CMOBJECTS set DISPSEQ=120 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=34)

update CMOBJECTS set DISPSEQ=130 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=36)

update CMOBJECTS set DISPSEQ=125 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=37)

update CMOBJECTS set DISPSEQ=155 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=38)

update CMOBJECTS set DISPSEQ=25 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=39)

update CMOBJECTS set DISPSEQ=75 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=40)

update CMOBJECTS set DISPSEQ=65 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=41)

update CMOBJECTS set DISPSEQ=55 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=42)

update CMOBJECTS set DISPSEQ=40 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=43)

update CMOBJECTS set DISPSEQ=35 where CMID in (select CMID from CMOBJPROPS17 where USERCAPABILITY=44)