CREATE TABLE [dbo].[HARFORMATTACHMENT]
(
[ATTACHMENTOBJID] [int] NOT NULL,
[ATTACHMENTNAME] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ATTACHMENTTYPE] [int] NOT NULL,
[FORMOBJID] [int] NOT NULL,
[CREATORID] [int] NOT NULL,
[CREATIONTIME] [datetime] NOT NULL,
[FILESIZE] [int] NOT NULL,
[FILEDATA] [image] NULL,
[FILECOMPRESSED] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__HARFORMAT__FILEC__48CFD27E] DEFAULT ('Y')
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER OFF
GO

   CREATE TRIGGER HARUSDDEPLOYINFO_ATTID_TRIGGER ON dbo.HARFORMATTACHMENT FOR DELETE AS IF
   (@@ROWCOUNT = 0)
   RETURN IF EXISTS(SELECT *
   FROM HARUSDDEPLOYINFO AS E           JOIN DELETED AS D
       ON E.ATTACHMENTOBJID = D.ATTACHMENTOBJID )    DELETE
   FROM HARUSDDEPLOYINFO    
   FROM HARUSDDEPLOYINFO AS E         JOIN DELETED AS D
       ON E.ATTACHMENTOBJID = D.ATTACHMENTOBJID  

GO
ALTER TABLE [dbo].[HARFORMATTACHMENT] ADD CONSTRAINT [HARFORMATTACHMENT_PK] PRIMARY KEY CLUSTERED ([ATTACHMENTOBJID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [HARFORMATTACHMENT_IND2] ON [dbo].[HARFORMATTACHMENT] ([ATTACHMENTNAME], [FORMOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARFORMATTACHMENT_IND] ON [dbo].[HARFORMATTACHMENT] ([FORMOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARFORMATTACHMENT] ADD CONSTRAINT [HARFORMATTACHMENT_FORMOBJID_FK] FOREIGN KEY ([FORMOBJID]) REFERENCES [dbo].[HARFORM] ([FORMOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARFORMATTACHMENT table stores the definition of an attachment data form. ', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMATTACHMENT', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Name of attachment', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMATTACHMENT', 'COLUMN', N'ATTACHMENTNAME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of attachment', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMATTACHMENT', 'COLUMN', N'ATTACHMENTOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Type of attachment (0/1) file/URL', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMATTACHMENT', 'COLUMN', N'ATTACHMENTTYPE'
GO
EXEC sp_addextendedproperty N'Caption', N'Time object was created', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMATTACHMENT', 'COLUMN', N'CREATIONTIME'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of creator', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMATTACHMENT', 'COLUMN', N'CREATORID'
GO
EXEC sp_addextendedproperty N'Caption', N'File compressed (Y/N)', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMATTACHMENT', 'COLUMN', N'FILECOMPRESSED'
GO
EXEC sp_addextendedproperty N'Caption', N'Attachment data', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMATTACHMENT', 'COLUMN', N'FILEDATA'
GO
EXEC sp_addextendedproperty N'Caption', N'Attachment file size', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMATTACHMENT', 'COLUMN', N'FILESIZE'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of form', 'SCHEMA', N'dbo', 'TABLE', N'HARFORMATTACHMENT', 'COLUMN', N'FORMOBJID'
GO