FaxBack Port Server - Manual - Manual (Page 46)

NSPortServerMain – SERVERS_TABLE
CREATE TABLE [dbo] . [SERVERS_TABLE] (
[ServerGuid] [uniqueidentifier] NOT NULL,
[ServerId] [nvarchar] ( 64 ) NULL,
[PasswordStr] [nvarchar] ( 64 ) NULL,
[AdminPassword] [nvarchar] ( 64 ) NULL,
[ServerType] [int] NULL,
[Url] [nvarchar] ( 128 ) NULL,
[ProxyUrl] [nvarchar] ( 128 ) NULL,
[Offsite] [int] NULL,
[AccountCSGroup] [nvarchar] ( 64 ) NULL,
[PortServerCSGroup] [nvarchar] ( 64 ) NULL,
[Enabled] [int] NULL,
[RawXml] [ntext] NULL,
[Version] [nvarchar] ( 32 ) NULL,
[SysInfo] [nvarchar] ( 255 ) NULL,
[CreatedOn] [datetime] NULL,
[LastModified] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[ServerGuid] ASC
) WITH ( PAD_INDEX = OFF , STATISTICS_NORECOMPUTE = OFF , IGNORE_DUP_KEY = OFF , ALLOW_ROW_LOCKS
= ON , ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] ,
UNIQUE NONCLUSTERED
(
[ServerId] 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] . [SERVERS_TABLE] ADD DEFAULT ( '' ) FOR [PasswordStr]
GO
ALTER
TABLE [dbo] . [SERVERS_TABLE] ADD DEFAULT ( '' ) FOR [AdminPassword]
GO
ALTER
TABLE [dbo] . [SERVERS_TABLE] ADD DEFAULT (( 0 )) FOR [ServerType]
GO
ALTER
TABLE [dbo] . [SERVERS_TABLE] ADD DEFAULT ( '' ) FOR [Url]
GO
ALTER
TABLE [dbo] . [SERVERS_TABLE] ADD DEFAULT ( '' ) FOR [ProxyUrl]
GO
ALTER
TABLE [dbo] . [SERVERS_TABLE] ADD DEFAULT (( 0 )) FOR [Offsite]
GO
ALTER
TABLE [dbo] . [SERVERS_TABLE] ADD DEFAULT ( '' ) FOR [AccountCSGroup]
GO
ALTER
TABLE [dbo] . [SERVERS_TABLE] ADD DEFAULT ( '' ) FOR [PortServerCSGroup]
GO
ALTER
TABLE [dbo] . [SERVERS_TABLE] ADD DEFAULT (( 1 )) FOR [Enabled]
GO