tbl-EmailQueue.sql

CREATE TABLE [dbo].[EmailQueue]
(
      [ID] [INT] NOT NULL IDENTITY(1,1)
    , [ToName] [VARCHAR](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
    , [ToEmail] [VARCHAR](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
    , [FromName] [VARCHAR](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__EmailQueu__FromN__24134F1B] DEFAULT ('Repeater Council (automated)')
    , [FromEmail] [VARCHAR](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__EmailQueu__FromE__25077354] DEFAULT ('hiram@repeatercouncil.org')
    , [Subject] [VARCHAR](MAX) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
    , [Body] [TEXT] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
    , [Sent] [DATETIME] NULL
    , [TemplateID] [VARCHAR](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__EmailQueu__Templ__24285DB4] DEFAULT (NULL)  
	    , CONSTRAINT [PK_EmailQueue] PRIMARY KEY CLUSTERED ([ID])
);