
NSPortServerMain–SERVERS_TABLE
CREATETABLE[dbo].[SERVERS_TABLE](
[ServerGuid][uniqueidentifier]NOTNULL,
[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,
PRIMARYKEYCLUSTERED
(
[ServerGuid]ASC
)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS
=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY],
UNIQUENONCLUSTERED
(
[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
ALTERTABLE[dbo].[SERVERS_TABLE]ADDDEFAULT('')FOR[PasswordStr]
GO
ALTERTABLE[dbo].[SERVERS_TABLE]ADDDEFAULT('')FOR[AdminPassword]
GO
ALTERTABLE[dbo].[SERVERS_TABLE]ADDDEFAULT((0))FOR[ServerType]
GO
ALTERTABLE[dbo].[SERVERS_TABLE]ADDDEFAULT('')FOR[Url]
GO
ALTERTABLE[dbo].[SERVERS_TABLE]ADDDEFAULT('')FOR[ProxyUrl]
GO
ALTERTABLE[dbo].[SERVERS_TABLE]ADDDEFAULT((0))FOR[Offsite]
GO
ALTERTABLE[dbo].[SERVERS_TABLE]ADDDEFAULT('')FOR[AccountCSGroup]
GO
ALTERTABLE[dbo].[SERVERS_TABLE]ADDDEFAULT('')FOR[PortServerCSGroup]
GO
ALTERTABLE[dbo].[SERVERS_TABLE]ADDDEFAULT((1))FOR[Enabled]
GO
Komentarze do niniejszej Instrukcji