CREATE TABLE [dbo].[SY01200]
(
[Master_Type] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Master_ID] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ADRSCODE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[INET1] [varchar] (201) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SY01200_INET1] DEFAULT (''),
[INET2] [varchar] (201) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SY01200_INET2] DEFAULT (''),
[INET3] [varchar] (201) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SY01200_INET3] DEFAULT (''),
[INET4] [varchar] (201) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SY01200_INET4] DEFAULT (''),
[INET5] [varchar] (201) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SY01200_INET5] DEFAULT (''),
[INET6] [varchar] (201) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SY01200_INET6] DEFAULT (''),
[INET7] [varchar] (201) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SY01200_INET7] DEFAULT (''),
[INET8] [varchar] (201) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SY01200_INET8] DEFAULT (''),
[Messenger_Address] [varchar] (201) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SY01200_Messenger_Address] DEFAULT (''),
[DEX_ROW_TS] [datetime] NOT NULL CONSTRAINT [DF_SY01200_DEX_ROW_TS] DEFAULT (getutcdate()),
[DEX_ROW_ID] [int] NOT NULL IDENTITY(1, 1),
[INETINFO] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SY01200_Messenger_INETINFO] DEFAULT (''),
[EmailToAddress] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SY01200_Messenger_EmailToAddress] DEFAULT (''),
[EmailCcAddress] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SY01200_Messenger_EmailCcAddress] DEFAULT (''),
[EmailBccAddress] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SY01200_Messenger_EmailBccAddress] DEFAULT ('')
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[SY01200] ADD CONSTRAINT [PK_SY01200] PRIMARY KEY NONCLUSTERED  ([Master_Type], [Master_ID], [ADRSCODE]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[SY01200] TO [MssExec]
GRANT INSERT ON  [dbo].[SY01200] TO [MssExec]
GRANT DELETE ON  [dbo].[SY01200] TO [MssExec]
GRANT UPDATE ON  [dbo].[SY01200] TO [MssExec]
GO