FaxBack Port Server - Manual - Manual (Page 43)

Chapter 14 – Internals
SQL Tables
NSPortServerMain – ACCOUNTS_TABLE
CREATE TABLE [dbo] . [ACCOUNTS_TABLE] (
[AccountGuid] [uniqueidentifier] NOT NULL,
[AccountId] [nvarchar] ( 64 ) NULL,
[PasswordStr] [nvarchar] ( 64 ) NULL,
[Customer] [nvarchar] ( 64 ) NULL,
[Source] [nvarchar] ( 64 ) NULL,
[CDRInfo] [nvarchar] ( 64 ) NULL,
[RcvEmail] [nvarchar] ( 128 ) NULL,
[SndEmail] [nvarchar] ( 128 ) NULL,
[RcvFormat] [int] NULL,
[RcvCSID] [nvarchar] ( 20 ) NULL,
[SndTSID] [nvarchar] ( 20 ) NULL,
[SndANI] [nvarchar] ( 20 ) NULL,
[SaveCDR] [int] NULL,
[SndFromAccount] [int] NULL,
[RcvToAccount] [int] NULL,
[AccountType] [int] NULL,
[RcvFailoverGuid] [uniqueidentifier] NULL,
[RcvFailoverMode] [int] NULL,
[SntCount] [int] NULL,
[RcvCount] [int] NULL,
[SntSeconds] [int] NULL,
[RcvSeconds] [int] NULL,
[ClientRcvCount] [int] NULL,
[ClientRcvSeconds] [int] NULL,
[SndSecsLeft] [int] NULL,
[RcvSecsLeft] [int] NULL,
[SndCfgSecsLeft] [int] NULL,
[RcvCfgSecsLeft] [int] NULL,
[AccountCSGroup] [nvarchar] ( 64 ) NULL,
[RuleGroup] [nvarchar] ( 64 ) NULL,
[RawXml] [ntext] NULL,
[CreatedOn] [datetime] NULL,
[LastModified] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[AccountGuid] ASC
) WITH ( PAD_INDEX = OFF , STATISTICS_NORECOMPUTE = OFF , IGNORE_DUP_KEY = OFF , ALLOW_ROW_LOCKS
= ON , ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] ,
UNIQUE NONCLUSTERED
(
[SndEmail] ASC
) WITH ( PAD_INDEX = OFF , STATISTICS_NORECOMPUTE = OFF , IGNORE_DUP_KEY = OFF , ALLOW_ROW_LOCKS
= ON , ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] ,
UNIQUE NONCLUSTERED
(
[AccountId] 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]