Startseite Erkunden Hilfe
Registrieren Anmelden
GlobalCube
/
analytics
3
0
Fork 0
Dateien Issues 0 Pull-Requests 0 Wiki
Struktur: 0a263e0aff
Branches Tags
analytics
/
configuration
/
schemas
/
logging
/
sqlserver
/
LS_dbUpgrade0_012-to-0_013_mssql.sql

LS_dbUpgrade0_012-to-0_013_mssql.sql 4.1 KB
Verlauf Originalformat

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596 
  1. -- Licensed Materials - Property of IBM
    2. 

  2. -- IBM Cognos Products: ccllogging
    3. 

  3. -- (C) Copyright IBM Corp. 2005, 2010
    4. 

  4. -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. 
    5. 

  5. 

  6. sp_rename 'COGIPF_ACTION', 'COGIPF_ACTION_OLD'
    7. 

  7. 

  8. CREATE TABLE COGIPF_ACTION (
    9. 

  9. 	COGIPF_HOST_IPADDR 	varchar (15) NULL ,
    10. 

  10. 	COGIPF_HOST_PORT 	int NULL ,
    11. 

  11. 	COGIPF_PROC_ID 		int NULL ,
    12. 

  12. 	COGIPF_LOCALTIMESTAMP 	datetime NULL ,
    13. 

  13. 	COGIPF_TIMEZONE_OFFSET 	int NULL ,
    14. 

  14. 	COGIPF_SESSIONID 	varchar (255) NULL ,
    15. 

  15. 	COGIPF_REQUESTID 	varchar (255) NOT NULL ,
    16. 

  16. 	COGIPF_STEPID 		varchar (255) NULL ,
    17. 

  17. 	COGIPF_SUBREQUESTID 	varchar (255) NULL ,
    18. 

  18. 	COGIPF_THREADID 	varchar (255) NULL ,
    19. 

  19. 	COGIPF_COMPONENTID 	varchar (64) NULL ,
    20. 

  20. 	COGIPF_BUILDNUMBER 	int NULL ,
    21. 

  21. 	COGIPF_LOG_LEVEL 	int NULL ,
    22. 

  22. 	COGIPF_OPERATION 	varchar (255) NULL ,
    23. 

  23. 	COGIPF_TARGET_TYPE 	varchar (255) NULL ,
    24. 

  24. 	COGIPF_TARGET_PATH 	varchar (1024) NULL ,
    25. 

  25. 	COGIPF_STATUS 		varchar (255) NULL ,
    26. 

  26. 	COGIPF_ERRORDETAILS 	varchar (2000) NULL 
    27. 

  27. )
    28. 

  28. 

  29. insert into COGIPF_ACTION select * from COGIPF_ACTION_OLD
    30. 

  30. 

  31. drop table COGIPF_ACTION_OLD
    32. 

  32. 

  33. sp_rename 'COGIPF_AGENTBUILD', 'COGIPF_AGENTBUILD_OLD'
    34. 

  34. 

  35. CREATE TABLE COGIPF_AGENTBUILD (
    36. 

  36. 	COGIPF_HOST_IPADDR 	varchar (15) NULL ,
    37. 

  37. 	COGIPF_HOST_PORT 	int NULL ,
    38. 

  38. 	COGIPF_PROC_ID 		int NULL ,
    39. 

  39. 	COGIPF_LOCALTIMESTAMP 	datetime NULL ,
    40. 

  40. 	COGIPF_TIMEZONE_OFFSET 	int NULL ,
    41. 

  41. 	COGIPF_SESSIONID 	varchar (255) NULL ,
    42. 

  42. 	COGIPF_REQUESTID 	varchar (255) NOT NULL ,
    43. 

  43. 	COGIPF_STEPID 		varchar (255) NULL ,
    44. 

  44. 	COGIPF_SUBREQUESTID 	varchar (255) NULL ,
    45. 

  45. 	COGIPF_THREADID 	varchar (255) NULL ,
    46. 

  46. 	COGIPF_COMPONENTID 	varchar (64) NULL ,
    47. 

  47. 	COGIPF_BUILDNUMBER 	int NULL ,
    48. 

  48. 	COGIPF_LOG_LEVEL 	int NULL ,
    49. 

  49. 	COGIPF_OPERATION	varchar (64) NULL,
    50. 

  50. 	COGIPF_TARGET_TYPE    	varchar (255) NULL,
    51. 

  51. 	COGIPF_TARGET_PATH     	nvarchar (1024) NULL,
    52. 

  52. 	COGIPF_TARGET_NAME     	nvarchar (255) NULL,
    53. 

  53. 	COGIPF_STATUS 		varchar (255) NULL ,
    54. 

  54. 	COGIPF_ERRORDETAILS 	varchar (2000) NULL ,
    55. 

  55. 	COGIPF_AGENT_PATH     	nvarchar (512) NULL,
    56. 

  56. 	COGIPF_SCHEDULETIME	int NULL,
    57. 

  57. 	COGIPF_USER		nvarchar (255) NULL,
    58. 

  58. 	COGIPF_EMAIL		nvarchar (255) NULL
    59. 

  59. )
    60. 

  60. 

  61. insert into COGIPF_AGENTBUILD select * from COGIPF_AGENTBUILD_OLD
    62. 

  62. 

  63. drop table COGIPF_AGENTBUILD_OLD
    64. 

  64. 

  65. sp_rename 'COGIPF_AGENTRUN', 'COGIPF_AGENTRUN_OLD'
    66. 

  66. 

  67. CREATE TABLE COGIPF_AGENTRUN (
    68. 

  68. 	COGIPF_HOST_IPADDR 	varchar (15) NULL ,
    69. 

  69. 	COGIPF_HOST_PORT 	int NULL ,
    70. 

  70. 	COGIPF_PROC_ID 		int NULL ,
    71. 

  71. 	COGIPF_LOCALTIMESTAMP 	datetime NULL ,
    72. 

  72. 	COGIPF_TIMEZONE_OFFSET 	int NULL ,
    73. 

  73. 	COGIPF_SESSIONID 	varchar (255) NULL ,
    74. 

  74. 	COGIPF_REQUESTID 	varchar (255) NOT NULL ,
    75. 

  75. 	COGIPF_STEPID 		varchar (255) NULL ,
    76. 

  76. 	COGIPF_SUBREQUESTID 	varchar (255) NULL ,
    77. 

  77. 	COGIPF_THREADID 	varchar (255) NULL ,
    78. 

  78. 	COGIPF_COMPONENTID 	varchar (64) NULL ,
    79. 

  79. 	COGIPF_BUILDNUMBER 	int NULL ,
    80. 

  80. 	COGIPF_LOG_LEVEL 	int NULL ,
    81. 

  81. 	COGIPF_OPERATION	varchar (64) NULL,
    82. 

  82. 	COGIPF_TARGET_TYPE    	varchar (255) NULL,
    83. 

  83. 	COGIPF_TARGET_PATH     	nvarchar (1024) NULL,
    84. 

  84. 	COGIPF_TARGET_NAME     	nvarchar (255) NULL,
    85. 

  85. 	COGIPF_STATUS 		varchar (255) NULL ,
    86. 

  86. 	COGIPF_ERRORDETAILS 	varchar (2000) NULL ,
    87. 

  87. 	COGIPF_AGENT_PATH     	nvarchar (512) NULL,
    88. 

  88. 	COGIPF_SCHEDULETIME	int NULL,
    89. 

  89. 	COGIPF_USER		nvarchar (255) NULL,
    90. 

  90. 	COGIPF_EMAIL		nvarchar (255) NULL,
    91. 

  91. 	COGIPF_MESSAGEID	varchar  (255) NULL
    92. 

  92. )
    93. 

  93. 

  94. insert into COGIPF_AGENTRUN  (COGIPF_HOST_IPADDR,COGIPF_HOST_PORT,COGIPF_PROC_ID,COGIPF_LOCALTIMESTAMP,COGIPF_TIMEZONE_OFFSET,COGIPF_SESSIONID,COGIPF_REQUESTID,COGIPF_STEPID,COGIPF_SUBREQUESTID,COGIPF_THREADID,COGIPF_COMPONENTID,COGIPF_BUILDNUMBER,COGIPF_LOG_LEVEL,COGIPF_OPERATION,COGIPF_TARGET_TYPE,COGIPF_TARGET_PATH,COGIPF_TARGET_NAME ,COGIPF_STATUS,COGIPF_ERRORDETAILS,COGIPF_AGENT_PATH,COGIPF_SCHEDULETIME,COGIPF_USER,COGIPF_EMAIL,COGIPF_MESSAGEID) select  COGIPF_HOST_IPADDR,COGIPF_HOST_PORT,COGIPF_PROC_ID,COGIPF_LOCALTIMESTAMP,COGIPF_TIMEZONE_OFFSET,COGIPF_SESSIONID,COGIPF_REQUESTID,COGIPF_STEPID,COGIPF_SUBREQUESTID,COGIPF_THREADID,COGIPF_COMPONENTID,COGIPF_BUILDNUMBER,COGIPF_LOG_LEVEL,COGIPF_OPERATION,COGIPF_TARGET_TYPE,COGIPF_TARGET_PATH,COGIPF_TARGET_NAME, COGIPF_STATUS,COGIPF_ERRORDETAILS,COGIPF_AGENT_PATH,COGIPF_SCHEDULETIME,COGIPF_USER,COGIPF_EMAIL,SUBSTRING(COGIPF_MESSAGEID, 0, 255) from COGIPF_AGENTRUN_OLD
    95. 

  95. 

  96. drop table COGIPF_AGENTRUN_OLD
    97.