LS_dbUpgrade0_015-to-0_016_mssql.sql 1.1 KB

12345678910111213141516171819202122232425262728
  1. -- Licensed Materials - Property of IBM
  2. -- IBM Cognos Products: ccllogging
  3. -- (C) Copyright IBM Corp. 2005, 2010
  4. -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  5. CREATE TABLE COGIPF_MIGRATION (
  6. COGIPF_HOST_IPADDR varchar (15) NULL ,
  7. COGIPF_HOST_PORT int NULL ,
  8. COGIPF_PROC_ID int NULL ,
  9. COGIPF_LOCALTIMESTAMP datetime NULL ,
  10. COGIPF_TIMEZONE_OFFSET int NULL ,
  11. COGIPF_SESSIONID varchar (255) NULL ,
  12. COGIPF_REQUESTID varchar (255) NOT NULL ,
  13. COGIPF_STEPID varchar (255) NULL ,
  14. COGIPF_SUBREQUESTID varchar (255) NULL ,
  15. COGIPF_THREADID varchar (255) NULL ,
  16. COGIPF_COMPONENTID varchar (64) NULL ,
  17. COGIPF_BUILDNUMBER int NULL ,
  18. COGIPF_LOG_LEVEL int NULL ,
  19. COGIPF_OPERATION varchar (64) NULL,
  20. COGIPF_TARGET_TYPE varchar (255) NULL,
  21. COGIPF_TARGET_PATH nvarchar (1024) NULL,
  22. COGIPF_TARGET_NAME nvarchar (255) NULL,
  23. COGIPF_STATUS varchar (255) NULL ,
  24. COGIPF_DETAILS varchar (2000) NULL ,
  25. COGIPF_PACKAGE nvarchar (512) NULL ,
  26. COGIPF_MODEL nvarchar (255) NULL
  27. )