analytics/configuration/schemas/content/db2/dbUpgrade4_0056-to-4_0057_db2.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)