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__14270015] DEFAULT ((0)),
[VIEWOBJID] [int] NOT NULL CONSTRAINT [DF__HARPACKAG__VIEWO__151B244E] DEFAULT ((-1)),
[APPROVED] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[STATUS] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CREATIONTIME] [datetime] NOT NULL CONSTRAINT [DF__HARPACKAG__CREAT__160F4887] DEFAULT (getutcdate()),
[CREATORID] [int] NOT NULL,
[MODIFIEDTIME] [datetime] NOT NULL CONSTRAINT [DF__HARPACKAG__MODIF__17036CC0] DEFAULT (getutcdate()),
[MODIFIERID] [int] NOT NULL,
[PACKAGEDES] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NOTE] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PRIORITY] [int] NOT NULL CONSTRAINT [DF__HARPACKAG__PRIOR__17F790F9] DEFAULT ((0)),
[ASSIGNEEID] [int] NOT NULL CONSTRAINT [DF__HARPACKAG__ASSIG__18EBB532] DEFAULT ((-1)),
[STATEENTRYTIME] [datetime] NOT NULL CONSTRAINT [DF__HARPACKAG__STATE__19DFD96B] DEFAULT (getutcdate()),
[NOTIFYWEBSERVICE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__HARPACKAG__NOTIF__1AD3FDA4] DEFAULT ('N')
) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER OFF
GO

   CREATE TRIGGER HARPKGSINGRP_PKGID_TRIGGER ON dbo.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 [HARPACKAGE_PK] PRIMARY KEY CLUSTERED ([PACKAGEOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARPACKAGE_IND_ENV] ON [dbo].[HARPACKAGE] ([ENVOBJID], [STATEOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARPACKAGE_IND] ON [dbo].[HARPACKAGE] ([PACKAGENAME], [ENVOBJID]) 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
EXEC sp_addextendedproperty N'Caption', N'The HARPACKAGE table stores the definition of a package.', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Reserved for future use', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'APPROVED'
GO
EXEC sp_addextendedproperty N'Caption', N'Assigned user object ID', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'ASSIGNEEID'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of project', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'ENVOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was modified', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'MODIFIEDTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of modifier', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'MODIFIERID'
GO
EXEC sp_addextendedproperty N'Caption', N'User-defined note', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'NOTE'
GO
EXEC sp_addextendedproperty N'Caption', N'Web service notification flag (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'NOTIFYWEBSERVICE'
GO
EXEC sp_addextendedproperty N'Caption', N'Descriptions for package object', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'PACKAGEDES'
GO
EXEC sp_addextendedproperty N'Caption', N'Name of package', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'PACKAGENAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of package', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'PACKAGEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Priority of package', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'PRIORITY'
GO
EXEC sp_addextendedproperty N'Caption', N'Entry time to current state', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'STATEENTRYTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of state', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'STATEOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Package status: idle or operation that has exclusive use of the package.', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'STATUS'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of view', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGE', 'COLUMN', N'VIEWOBJID'
GO