CREATE TABLE [dbo].[db_Program]
(
[dbrep_IID] [int] NOT NULL,
[dbrep_executableName] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dbrep_location] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dbrep_lastExecution] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dbrep_rowsInserted] [int] NULL,
[dbrep_rowsDeleted] [int] NULL,
[dbrep_rowsUpdated] [int] NULL,
[dbrep_lastModified] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dbrep_modifier] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
-- if you delete a program, delete the program instances from the workflow
CREATE TRIGGER del_db_Program ON db_Program FOR DELETE AS BEGIN DELETE FROM db_ProgramInstance FROM deleted where db_ProgramInstance.dbrep_ProgramIID = deleted.dbrep_IID END
GO
ALTER TABLE [dbo].[db_Program] ADD CONSTRAINT [PK__db_Program__6D24A392] PRIMARY KEY CLUSTERED ([dbrep_IID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[db_Program] TO [InfoPumpAdmin]
GRANT INSERT ON  [dbo].[db_Program] TO [InfoPumpAdmin]
GRANT DELETE ON  [dbo].[db_Program] TO [InfoPumpAdmin]
GRANT UPDATE ON  [dbo].[db_Program] TO [InfoPumpAdmin]
GRANT SELECT ON  [dbo].[db_Program] TO [InfoPumpUsers]
GRANT INSERT ON  [dbo].[db_Program] TO [InfoPumpUsers]
GRANT DELETE ON  [dbo].[db_Program] TO [InfoPumpUsers]
GRANT UPDATE ON  [dbo].[db_Program] TO [InfoPumpUsers]
GO