
Chapter14– Internals
SQLTables
NSPortServerMain–ACCOUNTS_TABLE
CREATETABLE[dbo].[ACCOUNTS_TABLE](
[AccountGuid][uniqueidentifier]NOTNULL,
[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,
PRIMARYKEYCLUSTERED
(
[AccountGuid]ASC
)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS
=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY],
UNIQUENONCLUSTERED
(
[SndEmail]ASC
)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS
=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY],
UNIQUENONCLUSTERED
(
[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]
Komentarze do niniejszej Instrukcji