CREATE TABLE [dbo].[ATConnection] (
    [Id]               INT NOT NULL IDENTITY(1,1),
    [Name]             NVARCHAR (50)  NOT NULL,
    [Type]             INT            NOT NULL,
    [ConnectionString] NVARCHAR (255) NOT NULL,
    [UserName]         NVARCHAR (50)  NOT NULL,
    [Password]         NVARCHAR (50)  NOT NULL,
    [Options]          NVARCHAR (50)  NULL,
    [Description]      NVARCHAR (255) NULL,
    [DefaultFrom]      NVARCHAR (255) NULL,
    [DefaultReplyTo]   NVARCHAR (255) NULL,
    CONSTRAINT [PK_ATConnection] PRIMARY KEY ([Id] ASC),
    CONSTRAINT [FK_ATConnection_ATConnectionType] FOREIGN KEY ([Type]) REFERENCES [dbo].[ATConnectionType] ([Id])
);

