ALTER TABLE SchedulTaskTest_DDD ALTER COLUMN TASKTORUN VARCHAR(2000) NOT NULL;

ALTER TABLE CtxCdSessionTest_DDD add (
Session_key		VARCHAR(128)
);

ALTER TABLE CtxCdStatusTest_DDD add (
TITLE		VARCHAR(2000)
);

ALTER TABLE CtxXcXALoginTest_REPORT add CONNECTION_STRENGTH DECIMAL(20,4) constraint PF_connection default '-5' NOT NULL;
ALTER TABLE CtxXcXALoginTest_REPORT add OUTPUT_LINE_SPEED DECIMAL(20,4) constraint PF_output default '-5' NOT NULL;

ALTER TABLE EsxLoginTest_REPORT add  CLIENT_IPADDRESS  VARCHAR(32) constraint PF_clientIp  default '-' NOT NULL;
ALTER TABLE EsxLoginTest_REPORT add  CLIENT_VERSION VARCHAR(32) constraint PF_clientVersion  default '-' NOT NULL;

ALTER TABLE EsxLoginTest_REPORT_INSIDE add  CLIENT_IPADDRESS VARCHAR(32) constraint PF_clIp  default '-' NOT NULL;
ALTER TABLE EsxLoginTest_REPORT_INSIDE add  CLIENT_VERSION VARCHAR(32) constraint PF_clVe  default '-' NOT NULL;

ALTER TABLE OraJobsTest add (
SUCCESSFULL_JOBS DECIMAL(20,4),
SUCCESSFULL_JOBS_ST varchar(32)
);

ALTER TABLE OraJobsTest_TREND add (
SUCCESSFULL_JOBS_MIN DECIMAL(20,4),
SUCCESSFULL_JOBS_MAX DECIMAL(20,4),
SUCCESSFULL_JOBS_STCNT varchar(32)
);

ALTER TABLE OraJobsTest_THRESH add (
SUCCESSFULL_JOBS_MIN VARCHAR(256),
SUCCESSFULL_JOBS_MAX VARCHAR(256)
);

ALTER TABLE BobiCRPSStTest_DDD add (
OBJ_DII_NM		 VARCHAR(32)
); 

ALTER TABLE BobiDCSvrStTest_DDD add (
OBJ_DII_NM		 VARCHAR(32)
); 

ALTER TABLE BobiDPSvrStTest_DDD add (
OBJ_DII_NM		 VARCHAR(32)
);

ALTER TABLE VmgCtxXcXAEuemTest_DDD ALTER COLUMN C_session_lookup	VARCHAR(2000) NOT NULL;

ALTER TABLE CtxNsLicExpiryTest_DDD ALTER COLUMN FEATURES	VARCHAR(2000) NOT NULL;

ALTER TABLE AsAbapUsrLgnTest_DDD add (
Host_Address	 VARCHAR(32)
);

ALTER TABLE VTSessionTest_DDD add (
ClientType	VARCHAR(512),
ClientPrtcl	VARCHAR(512),
ClientId	VARCHAR(512),
ClientIp	VARCHAR(512),
ClientMachne	VARCHAR(512),
ClientZone	VARCHAR(512),
ClientVersion	VARCHAR(512),
ClientLanchTyp	VARCHAR(512),
BrokerFarmId	VARCHAR(512),
BrokerRemoteIp	VARCHAR(512),
BrokerDns	VARCHAR(512),
GatewayIp	VARCHAR(512),
GatewayHost	VARCHAR(512),
GatewayLCN	VARCHAR(512),
BrokerURL	VARCHAR(512)
);

ALTER TABLE CtxNsLicExpiryTest_DDD add (
LICENSE_TYPE	VARCHAR(256),
LICENSE_MODE	VARCHAR(256),
MODEL_ID	VARCHAR(256)
);

ALTER TABLE CtxNsVpnVsTest add (
UP_SERVERS DECIMAL(20,4),
UP_SERVERS_ST varchar(32),
DOWN_SERVERS DECIMAL(20,4),
DOWN_SERVERS_ST varchar(32),
PCT_OF_UP_SERVERS DECIMAL(20,4),
PCT_OF_UP_SERVERS_ST varchar(32)
);

ALTER TABLE CtxNsVpnVsTest_TREND add (
UP_SERVERS_MIN DECIMAL(20,4),
UP_SERVERS_MAX DECIMAL(20,4),
UP_SERVERS_STCNT varchar(32),
DOWN_SERVERS_MIN DECIMAL(20,4),
DOWN_SERVERS_MAX DECIMAL(20,4),
DOWN_SERVERS_STCNT varchar(32),
PCT_OF_UP_SERVERS_MIN DECIMAL(20,4),
PCT_OF_UP_SERVERS_MAX DECIMAL(20,4),
PCT_OF_UP_SERVERS_STCNT varchar(32)
);

ALTER TABLE CtxNsVpnVsTest_THRESH add (
UP_SERVERS_MIN VARCHAR(256),
UP_SERVERS_MAX VARCHAR(256),
DOWN_SERVERS_MIN VARCHAR(256),
DOWN_SERVERS_MAX VARCHAR(256),
PCT_OF_UP_SERVERS_MIN VARCHAR(256),
PCT_OF_UP_SERVERS_MAX VARCHAR(256)
);

ALTER TABLE CtxNsLicExpiryTest add (
STATUS DECIMAL(20,4),
STATUS_ST varchar(32),
GRACE DECIMAL(20,4),
GRACE_ST varchar(32),
GRACE_LEFT DECIMAL(20,4),
GRACE_LEFT_ST varchar(32),
TOTAL_LICENSES DECIMAL(20,4),
TOTAL_LICENSES_ST varchar(32),
AVAILABLE_LICENSES DECIMAL(20,4),
AVAILABLE_LICENSES_ST varchar(32),
USED_LICENSES DECIMAL(20,4),
USED_LICENSES_ST varchar(32),
LICENSE_UTIL DECIMAL(20,4),
LICENSE_UTIL_ST varchar(32)
);

ALTER TABLE CtxNsLicExpiryTest_TREND add (
STATUS_MIN DECIMAL(20,4),
STATUS_MAX DECIMAL(20,4),
STATUS_STCNT varchar(32),
GRACE_MIN DECIMAL(20,4),
GRACE_MAX DECIMAL(20,4),
GRACE_STCNT varchar(32),
GRACE_LEFT_MIN DECIMAL(20,4),
GRACE_LEFT_MAX DECIMAL(20,4),
GRACE_LEFT_STCNT varchar(32),
TOTAL_LICENSES_MIN DECIMAL(20,4),
TOTAL_LICENSES_MAX DECIMAL(20,4),
TOTAL_LICENSES_STCNT varchar(32),
AVAILABLE_LICENSES_MIN DECIMAL(20,4),
AVAILABLE_LICENSES_MAX DECIMAL(20,4),
AVAILABLE_LICENSES_STCNT varchar(32),
USED_LICENSES_MIN DECIMAL(20,4),
USED_LICENSES_MAX DECIMAL(20,4),
USED_LICENSES_STCNT varchar(32),
LICENSE_UTIL_MIN DECIMAL(20,4),
LICENSE_UTIL_MAX DECIMAL(20,4),
LICENSE_UTIL_STCNT varchar(32)
);

ALTER TABLE CtxNsLicExpiryTest_THRESH add (
STATUS_MIN VARCHAR(256),
STATUS_MAX VARCHAR(256),
GRACE_MIN VARCHAR(256),
GRACE_MAX VARCHAR(256),
GRACE_LEFT_MIN VARCHAR(256),
GRACE_LEFT_MAX VARCHAR(256),
TOTAL_LICENSES_MIN VARCHAR(256),
TOTAL_LICENSES_MAX VARCHAR(256),
AVAILABLE_LICENSES_MIN VARCHAR(256),
AVAILABLE_LICENSES_MAX VARCHAR(256),
USED_LICENSES_MIN VARCHAR(256),
USED_LICENSES_MAX VARCHAR(256),
LICENSE_UTIL_MIN VARCHAR(256),
LICENSE_UTIL_MAX VARCHAR(256)
);

ALTER TABLE RUM_ERROR_DETAILS ALTER COLUMN ERROR_MESSAGE		VARCHAR(1024) NOT NULL;

ALTER TABLE EXOMailActSumTest_DDD ALTER COLUMN AssigndPrdts		VARCHAR(512) NOT NULL;