Tables [dbo].[wtaccesspointreference]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created11:07:46 AM Wednesday, March 07, 2007
Last Modified11:09:16 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
namevarchar(40)40
No
descriptionvarchar(40)40
Yes
Cluster Primary Key XPKwtaccesspointreference: uuiduuidbinary(16)16
No
failedcountwint4
Yes
failedcountcint4
Yes
deltafailedcountwint4
Yes
deltafailedcountcint4
Yes
ratefailedcountwint4
Yes
ratefailedcountcint4
Yes
failedcountrateintint4
Yes
retrycountwint4
Yes
retrycountcint4
Yes
deltaretrycountwint4
Yes
deltaretrycountcint4
Yes
rateretrycountwint4
Yes
rateretrycountcint4
Yes
retrycountrateintint4
Yes
multipleretrycountwint4
Yes
multipleretrycountcint4
Yes
deltamultipleretrycountwint4
Yes
deltamultipleretrycountcint4
Yes
ratemultipleretrycountwint4
Yes
ratemultipleretrycountcint4
Yes
multipleretrycountrateintint4
Yes
frameduplicatecountwint4
Yes
frameduplicatecountcint4
Yes
deltaframeduplicatecountwint4
Yes
deltaframeduplicatecountcint4
Yes
rateframeduplicatecountwint4
Yes
rateframeduplicatecountcint4
Yes
frameduplicatecountrateintint4
Yes
rtsfailurecountwint4
Yes
rtsfailurecountcint4
Yes
deltartsfailurecountwint4
Yes
deltartsfailurecountcint4
Yes
ratertsfailurecountwint4
Yes
ratertsfailurecountcint4
Yes
rtsfailurecountrateintint4
Yes
ackfailurecountwint4
Yes
ackfailurecountcint4
Yes
deltaackfailurecountwint4
Yes
deltaackfailurecountcint4
Yes
rateackfailurecountwint4
Yes
rateackfailurecountcint4
Yes
ackfailurecountrateintint4
Yes
fcserrorcountwint4
Yes
fcserrorcountcint4
Yes
deltafcserrorcountwint4
Yes
deltafcserrorcountcint4
Yes
ratefcserrorcountwint4
Yes
ratefcserrorcountcint4
Yes
fcserrorcountrateintint4
Yes
wepundecryptablecountwint4
Yes
wepundecryptablecountcint4
Yes
deltawepundecryptablecountwint4
Yes
deltawepundecryptablecountcint4
Yes
ratewepundecryptablecountwint4
Yes
ratewepundecryptablecountcint4
Yes
wepundecryptablecountrateintint4
Yes
wepexcludedcountwint4
Yes
wepexcludedcountcint4
Yes
deltawepexcludedcountwint4
Yes
deltawepexcludedcountcint4
Yes
ratewepexcludedcountwint4
Yes
ratewepexcludedcountcint4
Yes
wepexcludedcountrateintint4
Yes
wepicverrorcountwint4
Yes
wepicverrorcountcint4
Yes
deltawepicverrorcountwint4
Yes
deltawepicverrorcountcint4
Yes
ratewepicverrorcountwint4
Yes
ratewepicverrorcountcint4
Yes
wepicverrorcountrateintint4
Yes
validssidvarchar(40)40
Yes
securityviolationsettingint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKwtaccesspointreference: uuidXPKwtaccesspointreferenceuuid
Yes
SQL Script
CREATE TABLE [dbo].[wtaccesspointreference]
(
[name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[description] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uuid] [binary] (16) NOT NULL,
[failedcountw] [int] NULL,
[failedcountc] [int] NULL,
[deltafailedcountw] [int] NULL,
[deltafailedcountc] [int] NULL,
[ratefailedcountw] [int] NULL,
[ratefailedcountc] [int] NULL,
[failedcountrateint] [int] NULL,
[retrycountw] [int] NULL,
[retrycountc] [int] NULL,
[deltaretrycountw] [int] NULL,
[deltaretrycountc] [int] NULL,
[rateretrycountw] [int] NULL,
[rateretrycountc] [int] NULL,
[retrycountrateint] [int] NULL,
[multipleretrycountw] [int] NULL,
[multipleretrycountc] [int] NULL,
[deltamultipleretrycountw] [int] NULL,
[deltamultipleretrycountc] [int] NULL,
[ratemultipleretrycountw] [int] NULL,
[ratemultipleretrycountc] [int] NULL,
[multipleretrycountrateint] [int] NULL,
[frameduplicatecountw] [int] NULL,
[frameduplicatecountc] [int] NULL,
[deltaframeduplicatecountw] [int] NULL,
[deltaframeduplicatecountc] [int] NULL,
[rateframeduplicatecountw] [int] NULL,
[rateframeduplicatecountc] [int] NULL,
[frameduplicatecountrateint] [int] NULL,
[rtsfailurecountw] [int] NULL,
[rtsfailurecountc] [int] NULL,
[deltartsfailurecountw] [int] NULL,
[deltartsfailurecountc] [int] NULL,
[ratertsfailurecountw] [int] NULL,
[ratertsfailurecountc] [int] NULL,
[rtsfailurecountrateint] [int] NULL,
[ackfailurecountw] [int] NULL,
[ackfailurecountc] [int] NULL,
[deltaackfailurecountw] [int] NULL,
[deltaackfailurecountc] [int] NULL,
[rateackfailurecountw] [int] NULL,
[rateackfailurecountc] [int] NULL,
[ackfailurecountrateint] [int] NULL,
[fcserrorcountw] [int] NULL,
[fcserrorcountc] [int] NULL,
[deltafcserrorcountw] [int] NULL,
[deltafcserrorcountc] [int] NULL,
[ratefcserrorcountw] [int] NULL,
[ratefcserrorcountc] [int] NULL,
[fcserrorcountrateint] [int] NULL,
[wepundecryptablecountw] [int] NULL,
[wepundecryptablecountc] [int] NULL,
[deltawepundecryptablecountw] [int] NULL,
[deltawepundecryptablecountc] [int] NULL,
[ratewepundecryptablecountw] [int] NULL,
[ratewepundecryptablecountc] [int] NULL,
[wepundecryptablecountrateint] [int] NULL,
[wepexcludedcountw] [int] NULL,
[wepexcludedcountc] [int] NULL,
[deltawepexcludedcountw] [int] NULL,
[deltawepexcludedcountc] [int] NULL,
[ratewepexcludedcountw] [int] NULL,
[ratewepexcludedcountc] [int] NULL,
[wepexcludedcountrateint] [int] NULL,
[wepicverrorcountw] [int] NULL,
[wepicverrorcountc] [int] NULL,
[deltawepicverrorcountw] [int] NULL,
[deltawepicverrorcountc] [int] NULL,
[ratewepicverrorcountw] [int] NULL,
[ratewepicverrorcountc] [int] NULL,
[wepicverrorcountrateint] [int] NULL,
[validssid] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[securityviolationsetting] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtaccesspointreference] ADD CONSTRAINT [XPKwtaccesspointreference] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
Uses