analytics/configuration/schemas/content/oracle/dbUpgrade4_0056-to-4_0057_oracle.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);