CREATE TABLE [dbo].[db_Object]
(
[dbrep_IID] [int] NOT NULL,
[dbrep_ParentIID] [int] NOT NULL,
[dbrep_Name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[dbrep_Status] [smallint] NOT NULL,
[dbrep_Version] [int] NOT NULL,
[dbrep_ObjectType] [tinyint] NOT NULL,
[dbrep_Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER OFF
GO
--
-- create triggers on the IDB+ tables to maintain referential integrity
--
-- if you delete an object - cascade the delete to dependent tables
CREATE TRIGGER del_db_Object ON db_Object FOR DELETE AS BEGIN DELETE FROM db_Application FROM deleted where db_Application.dbrep_IID = deleted.dbrep_IID DELETE FROM db_Parameter FROM deleted  where db_Parameter.dbrep_IID = deleted.dbrep_IID DELETE FROM db_Op FROM deleted where db_Op.dbrep_IID = deleted.dbrep_IID DELETE FROM db_Program FROM deleted where db_Program.dbrep_IID = deleted.dbrep_IID DELETE FROM db_Gator FROM deleted where db_Gator.dbrep_IID = deleted.dbrep_IID DELETE FROM db_Star FROM deleted where db_Star.dbrep_IID = deleted.dbrep_IID DELETE FROM db_Field FROM deleted  where db_Field.dbrep_IID = deleted.dbrep_IID DELETE FROM db_Layout FROM deleted where db_Layout.dbrep_IID = deleted.dbrep_IID DELETE FROM db_Index FROM deleted where db_Index.dbrep_IID = deleted.dbrep_IID DELETE FROM db_Column FROM deleted where db_Column.dbrep_IID = deleted.dbrep_IID DELETE FROM db_Table FROM deleted where db_Table.dbrep_IID = deleted.dbrep_IID DELETE FROM db_DataType FROM deleted where db_DataType.dbrep_IID = deleted.dbrep_IID DELETE FROM db_ServerType FROM deleted where db_ServerType.dbrep_IID = deleted.dbrep_IID DELETE FROM db_InfoBlob FROM deleted where db_InfoBlob.dbrep_IID = deleted.dbrep_IID DELETE FROM db_WKF FROM deleted where db_WKF.dbrep_IID = deleted.dbrep_IID DELETE FROM db_WKFConnection FROM deleted where db_WKFConnection.dbrep_IID = deleted.dbrep_IID DELETE FROM db_ProgramInstance FROM deleted  where db_ProgramInstance.dbrep_IID = deleted.dbrep_IID DELETE FROM db_ProgramType FROM deleted where db_ProgramType.dbrep_IID = deleted.dbrep_IID DELETE FROM db_ProgramTypeMisc FROM deleted where db_ProgramTypeMisc.dbrep_IID = deleted.dbrep_IID DELETE FROM db_PSAFile FROM deleted where db_PSAFile.dbrep_IID = deleted.dbrep_IID END

GO
ALTER TABLE [dbo].[db_Object] ADD CONSTRAINT [PK__db_Object__4EA01C72] PRIMARY KEY CLUSTERED ([dbrep_IID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[db_Object] ADD CONSTRAINT [db_ObjectUnique] UNIQUE NONCLUSTERED ([dbrep_ParentIID], [dbrep_Name], [dbrep_ObjectType], [dbrep_Status], [dbrep_Version]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [idx_db_ObjParent] ON [dbo].[db_Object] ([dbrep_ParentIID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[db_Object] TO [InfoPumpAdmin]
GRANT INSERT ON  [dbo].[db_Object] TO [InfoPumpAdmin]
GRANT DELETE ON  [dbo].[db_Object] TO [InfoPumpAdmin]
GRANT UPDATE ON  [dbo].[db_Object] TO [InfoPumpAdmin]
GRANT SELECT ON  [dbo].[db_Object] TO [InfoPumpUsers]
GRANT INSERT ON  [dbo].[db_Object] TO [InfoPumpUsers]
GRANT DELETE ON  [dbo].[db_Object] TO [InfoPumpUsers]
GRANT UPDATE ON  [dbo].[db_Object] TO [InfoPumpUsers]
GO