CREATE TABLE [dbo].[harpackage]
(
[packageobjid] [int] NOT NULL,
[packagename] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[envobjid] [int] NOT NULL,
[stateobjid] [int] NOT NULL CONSTRAINT [DF__harpackag__state__68736660] DEFAULT ((0)),
[viewobjid] [int] NOT NULL CONSTRAINT [DF__harpackag__viewo__69678A99] DEFAULT ((-1)),
[approved] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[status] [char] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[creationtime] [datetime] NOT NULL,
[creatorid] [int] NOT NULL,
[modifiedtime] [datetime] NOT NULL,
[modifierid] [int] NOT NULL,
[packagedes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[note] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[priority] [int] NOT NULL CONSTRAINT [DF__harpackag__prior__6A5BAED2] DEFAULT ((0)),
[assigneeid] [int] NOT NULL CONSTRAINT [DF__harpackag__assig__6B4FD30B] DEFAULT ((-1)),
[stateentrytime] [datetime] NOT NULL CONSTRAINT [DF__harpackag__state__6C43F744] DEFAULT ('now'),
[notifywebservice] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL CONSTRAINT [DF__harpackag__notif__6D381B7D] DEFAULT ('N')
) ON [PRIMARY]
GO

/****** Object:  Trigger dbo.HARPKGSINGRP_PKGID_TRIGGER    Script Date: 12/1/2005 11:51:03 PM ******/

/* HARPKGSINGRP - HARPACKAGE  TRIGGER */

CREATE TRIGGER HARPKGSINGRP_PKGID_TRIGGER ON HARPACKAGE FOR DELETE
AS

IF (@@ROWCOUNT = 0) RETURN

IF EXISTS(SELECT *
          FROM
              HARPKGSINPKGGRP AS E
            JOIN
              DELETED   AS D ON E.PACKAGEOBJID = D.PACKAGEOBJID)
  DELETE FROM HARPKGSINPKGGRP
  FROM
      HARPKGSINPKGGRP AS E
    JOIN
      DELETED   AS D ON E.PACKAGEOBJID = D.PACKAGEOBJID


GO
ALTER TABLE [dbo].[harpackage] ADD CONSTRAINT [XPKharpackage] PRIMARY KEY CLUSTERED ([packageobjid]) WITH (FILLFACTOR=90) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARPACKAGE_IND_ENV] ON [dbo].[harpackage] ([envobjid], [stateobjid]) WITH (FILLFACTOR=90) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [harpackage_ind] ON [dbo].[harpackage] ([packagename], [envobjid]) WITH (FILLFACTOR=90) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [harpackage_state_env_pobj] ON [dbo].[harpackage] ([stateobjid], [envobjid], [packageobjid]) WITH (FILLFACTOR=90) ON [PRIMARY]
GO
ALTER TABLE [dbo].[harpackage] ADD CONSTRAINT [harpackage_aid_fk] FOREIGN KEY ([assigneeid]) REFERENCES [dbo].[harallusers] ([usrobjid])
GO
ALTER TABLE [dbo].[harpackage] ADD CONSTRAINT [HARPACKAGE_ENVID_FK] FOREIGN KEY ([envobjid]) REFERENCES [dbo].[harenvironment] ([envobjid]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[harpackage] TO [harvest_group]
GRANT INSERT ON  [dbo].[harpackage] TO [harvest_group]
GRANT DELETE ON  [dbo].[harpackage] TO [harvest_group]
GRANT UPDATE ON  [dbo].[harpackage] TO [harvest_group]
GRANT SELECT ON  [dbo].[harpackage] TO [harvest_rep]
GO