FaxBack Port Server - Manual - Manual (Page 45)

ALTER
TABLE [dbo] . [ACCOUNTS_TABLE] ADD DEFAULT ((‐ 1 )) FOR [SndSecsLeft]
GO
ALTER
TABLE [dbo] . [ACCOUNTS_TABLE] ADD DEFAULT ((‐ 1 )) FOR [RcvSecsLeft]
GO
ALTER
TABLE [dbo] . [ACCOUNTS_TABLE] ADD DEFAULT ((‐ 1 )) FOR [SndCfgSecsLeft]
GO
ALTER
TABLE [dbo] . [ACCOUNTS_TABLE] ADD DEFAULT ((‐ 1 )) FOR [RcvCfgSecsLeft]
GO
ALTER
TABLE [dbo] . [ACCOUNTS_TABLE] ADD DEFAULT ( '' ) FOR [AccountCSGroup]
GO
ALTER
TABLE [dbo] . [ACCOUNTS_TABLE] ADD DEFAULT ( '' ) FOR [RuleGroup]
GO
ALTER
TABLE [dbo] . [ACCOUNTS_TABLE] ADD DEFAULT ( '<Xml/>' ) FOR [RawXml]
GO
NSPortServerMain – RCV_ROUTING_TABLE
CREATE TABLE [dbo] . [RCV_ROUTING_TABLE] (
[RcvRouterGuid] [uniqueidentifier] NOT NULL,
[RcvRouter] [nvarchar] ( 64 ) NULL,
[AccountGuid] [uniqueidentifier] NULL,
[Customer] [nvarchar] ( 64 ) NULL,
[Source] [nvarchar] ( 64 ) NULL,
[Enabled] [int] NULL,
[RawXml] [ntext] NULL,
[CreatedOn] [datetime] NULL,
[LastModified] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[RcvRouterGuid] ASC
) WITH ( PAD_INDEX = OFF , STATISTICS_NORECOMPUTE = OFF , IGNORE_DUP_KEY = OFF , ALLOW_ROW_LOCKS
= ON , ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] ,
UNIQUE NONCLUSTERED
(
[RcvRouter] 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
ALTER
TABLE [dbo] . [RCV_ROUTING_TABLE] ADD DEFAULT ( '' ) FOR [Customer]
GO
ALTER
TABLE [dbo] . [RCV_ROUTING_TABLE] ADD DEFAULT ( '' ) FOR [Source]
GO
ALTER
TABLE [dbo] . [RCV_ROUTING_TABLE] ADD DEFAULT (( 1 )) FOR [Enabled]
GO
ALTER
TABLE [dbo] . [RCV_ROUTING_TABLE] ADD DEFAULT ( '<Xml/>' ) FOR [RawXml]
GO