/*
-------------------------------------------------------
------------------ ALTER TABLE START --------------------
*/

ALTER TABLE [Device] ALTER COLUMN [TimeLastUp] datetime NULL
go

ALTER TABLE Device 
		ADD SshEnabled bit NOT NULL constraint Device_SshEnabled_DF  DEFAULT 0
go

/*
	 ManagedElementType 
*/
alter table ManagedElementType
	add TableName nvarchar(128) null
go
alter table ManagedElementType
	add ManagedElementGuidColumnName nvarchar(128) null
go



alter table ManagedElementType
	add ME2CategoryID	int			null
go



/*
	 ManagedElementAttributeType 
*/

alter table ManagedElementAttributeType
	add DataLength  int  null
go

alter table ManagedElementAttributeType
	add IsIdentity  bit not  null 
		constraint ManagedElementAttributeType_IsIdentity_DF default (0)
go

alter table ManagedElementAttributeType
	add UnitOfMeasure  nvarchar(100)  null 
go

	alter table ManagedElementAttributeType
		add IsPKMember  bit not  null 
			constraint ManagedElementAttributeType_IsPKMember_DF default (0)
go

/*
	2013-03-22 PostMWData_TRUNK.sql
*/
ALTER TABLE Device ADD RequiresDeletion bit NOT NULL 
	constraint Device_RequiresDeletion_DF default(0)
GO