24 lines
855 B
Transact-SQL
24 lines
855 B
Transact-SQL
use EnVisage
|
|
|
|
go
|
|
--NotificationType System=0
|
|
--NotificationType Task=1
|
|
--NotificationType Workflow=2
|
|
--NotificationType User=3
|
|
--NotificationType Error=4
|
|
|
|
--HowtoSend Web=0
|
|
--HowtoSend Email=1
|
|
--HowtoSend Text=2
|
|
|
|
delete from NotificationControl where NotificationType=1 and HowtoSend=0
|
|
delete from NotificationControl where NotificationType=4 and HowtoSend=0
|
|
delete from NotificationControl where NotificationType=4 and HowtoSend=1
|
|
|
|
-- send notifications to the client (web) for tasks
|
|
Insert into NotificationControl (Id,NotificationType,HowtoSend) values(NEWID(),1,0)
|
|
-- send notifications to the client (web) for errors
|
|
Insert into NotificationControl (Id,NotificationType,HowtoSend) values(NEWID(),4,0)
|
|
|
|
-- send notifications to the client (email) for errors
|
|
Insert into NotificationControl (Id,NotificationType,HowtoSend) values(NEWID(),4,1) |