USE [_hMaiServer]
GO

/****** Object:  Table [dbo].[hm_deliverylog]    Script Date: 13.11.2012 16:44:51 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[hm_deliverylog](
    [deliveryid] [INT] IDENTITY(1,1) NOT NULL,
    [deliveryfrom] [VARCHAR](255) NOT NULL,
    [deliveryfilename] [VARCHAR](255) NOT NULL,
    [deliverytime] [datetime] NOT NULL,
    [deliverysubject] [nvarchar](255) NOT NULL,
    [deliverybody] [nvarchar](MAX) NOT NULL,
    [deliveryaccount] [VARCHAR](255) NULL,
 CONSTRAINT [hm_deliverylog_pk] PRIMARY KEY NONCLUSTERED
(
    [deliveryid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


/****** Object:  Index [hm_deliverylog_pk]    Script Date: 13.11.2012 16:57:22 ******/
ALTER TABLE [dbo].[hm_deliverylog] ADD  CONSTRAINT [hm_deliverylog_pk] PRIMARY KEY NONCLUSTERED
(
    [deliveryid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO




/****** Object:  Index [IX_hm_deliverylog]    Script Date: 13.11.2012 16:57:03 ******/
CREATE NONCLUSTERED INDEX [IX_hm_deliverylog] ON [dbo].[hm_deliverylog]
(
    [deliverytime] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO