dbUpgrade7_0003-to-7_0004_mssqlserver.sql 1006 B

123456789101112131415161718192021222324252627282930313233343536
  1. -- Licensed Materials - Property of IBM
  2. --
  3. -- BI and PM: CM
  4. --
  5. -- (C) Copyright IBM Corp. 2012
  6. --
  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
  9. alter table CMOBJPROPS31 add
  10. IDVIZAUDITLVL tinyint null,
  11. REPOSAUDITLVL tinyint null,
  12. SACAMAUDITLVL tinyint null
  13. insert into CMOBJPROPS31(CMID) select CMID from CMOBJECTS
  14. where (CLASSID in (240))
  15. alter table CMOBJPROPS48 add
  16. RMDSCONS int null,
  17. RMDSPEAKCONS int null,
  18. QSVERBGCLOGLIMIT int null,
  19. QSMDQUERYSIZELIMIT int null,
  20. QSGENCOMINNATSQL bit null,
  21. QSDISVERBGCLOG bit null,
  22. QSINITNURSESIZE int null,
  23. QSNURSESIZELIMIT int null,
  24. QSGCPOLICY tinyint null
  25. alter table CMOBJPROPS23 add
  26. QSRMEMCACHEROOT nvarchar(256) null
  27. insert into CMOBJPROPS23(CMID) select CMID from CMOBJECTS where (CLASSID=227)
  28. delete from CMREFNOORD1 where PROPID=54
  29. !RunCMScript CMUpgradeScript_configuration_update_38.xml