12 lines
491 B
Transact-SQL
12 lines
491 B
Transact-SQL
CREATE TABLE [dbo].[EmailConfiguration] (
|
|
[id] nvarchar(128) NOT NULL,
|
|
[from] nvarchar(1024) NULL DEFAULT (''),
|
|
[toTest] nvarchar(1024) NULL DEFAULT (''),
|
|
[toBank] nvarchar(1024) NULL DEFAULT (''),
|
|
[cc] nvarchar(1024) NULL DEFAULT (''),
|
|
[bcc] nvarchar(1024) NULL DEFAULT (''),
|
|
[subject] nvarchar(1024) NULL DEFAULT (''),
|
|
[body] varchar(8000) NULL DEFAULT ('')
|
|
)
|
|
ALTER TABLE [dbo].[EmailConfiguration] ADD CONSTRAINT [PK__EmailCon__3213E83F5F04031C] PRIMARY KEY CLUSTERED ([id])
|
|
GO |