/*
	AutomatedTaskDeviceLink

on the real upgrade this update:
update AutomatedTaskDeviceLink 
   set ScheduleID = (...)
should happen before making ScheduleID NOT NULL

*/
alter table AutomatedTaskDeviceLink
	alter column ScheduleID int not null
go



/*
	AutomatedTask
*/

alter table AutomatedTask
	drop constraint FK_AutomatedTask_Schedule
go

alter table AutomatedTask
	drop column [ScheduleID]
go


