FaxBack Port Server - Manual User Manual
Page 47
ALTER
TABLE
[dbo]
.
[SERVERS_TABLE]
ADD
DEFAULT
(
'<Xml/>'
)
FOR
[RawXml]
GO
ALTER
TABLE
[dbo]
.
[SERVERS_TABLE]
ADD
DEFAULT
(
''
)
FOR
[Version]
GO
ALTER
TABLE
[dbo]
.
[SERVERS_TABLE]
ADD
DEFAULT
(
''
)
FOR
[SysInfo]
GO
NSPortServerMain – SND_ROUTING_TABLE
CREATE
TABLE
[dbo]
.
[SND_ROUTING_TABLE]
(
[SndRouter] [nvarchar]
(
96
)
NOT
NULL,
[RuleId] [nvarchar]
(
4
)
NULL,
[RawXml] [ntext]
NULL,
PRIMARY
KEY
CLUSTERED
(
[SndRouter]
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]
.
[SND_ROUTING_TABLE]
ADD
DEFAULT
(
''
)
FOR
[RuleId]
GO
NSPortServerBilling – BILLING_TABLE
CREATE
TABLE
[dbo]
.
[BILLING_TABLE]
(
[LogId] [bigint]
IDENTITY
(
2
,
1
)
NOT
NULL,
[AccountId] [nvarchar]
(
64
)
NULL,
[RcvAccountId] [nvarchar]
(
64
)
NULL,
[Customer] [nvarchar]
(
64
)
NULL,
[Source] [nvarchar]
(
64
)
NULL,
[CDRInfo] [nvarchar]
(
64
)
NULL,
[PerFaxCDRInfo] [nvarchar]
(
64
)
NULL,
[IsSend] [int]
NULL,
[StartTime] [datetime]
NULL,
[DialNumber] [nvarchar]
(
64
)
NULL,
[CallerID] [nvarchar]
(
32
)
NULL,
[LocalCSID] [nvarchar]
(
32
)
NULL,
[RemoteCSID] [nvarchar]
(
32
)
NULL,
[ErrorCode] [int]
NULL,
[TotalSeconds] [int]
NULL,
[ConnectBPS] [int]
NULL,
[PageCount] [int]
NULL,
[ConnectionServer] [nvarchar]
(
64
)
NULL,
[PortServer] [nvarchar]
(
64
)
NULL,
[PortUsed] [nvarchar]
(
64
)
NULL,
[SessionId] [nvarchar]
(
32
)
NULL,
[CreatedOn] [datetime]
NULL,
[RawXml] [ntext]
NULL,
PRIMARY
KEY
CLUSTERED
(
[LogId]
ASC
)
WITH
(
PAD_INDEX
=
OFF
,
STATISTICS_NORECOMPUTE
=
OFF
,
IGNORE_DUP_KEY
=
OFF
,
ALLOW_ROW_LOCKS
=
ON
,
ALLOW_PAGE_LOCKS
=
ON
)
ON
[PRIMARY]