Tables [dbo].[wsm_advanced_wep_sched]
Properties
PropertyValue
HeapYes
Row Count0
Created11:08:02 AM Wednesday, March 07, 2007
Last Modified11:09:57 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Indexes xwsm_advanced_wep_sched_index: start_time\advanced_wep_sched_idstart_timeint4
No
key1binary(256)256
No
key2binary(256)256
Yes
key3binary(256)256
No
key4binary(256)256
Yes
Foreign Keys r_1541: [dbo].[wsm_advanced_wep].advanced_wep_sched_idIndexes xif1wsm_advanced_wep_sched: advanced_wep_sched_idIndexes xwsm_advanced_wep_sched_index: start_time\advanced_wep_sched_idadvanced_wep_sched_idbinary(16)16
Yes
Indexes Indexes
NameColumnsUnique
xwsm_advanced_wep_sched_indexstart_time, advanced_wep_sched_id
Yes
xif1wsm_advanced_wep_schedadvanced_wep_sched_id
Foreign Keys Foreign Keys
NameColumns
r_1541advanced_wep_sched_id->[dbo].[wsm_advanced_wep].[advanced_wep_sched_id]
Permissions
TypeActionOwning Principal
GrantDeletewsm_admin_group
GrantInsertwsm_admin_group
GrantSelectwsm_admin_group
GrantUpdatewsm_admin_group
SQL Script
CREATE TABLE [dbo].[wsm_advanced_wep_sched]
(
[start_time] [int] NOT NULL,
[key1] [binary] (256) NOT NULL,
[key2] [binary] (256) NULL,
[key3] [binary] (256) NOT NULL,
[key4] [binary] (256) NULL,
[advanced_wep_sched_id] [binary] (16) NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1wsm_advanced_wep_sched] ON [dbo].[wsm_advanced_wep_sched] ([advanced_wep_sched_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [xwsm_advanced_wep_sched_index] ON [dbo].[wsm_advanced_wep_sched] ([start_time], [advanced_wep_sched_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_advanced_wep_sched] ADD CONSTRAINT [r_1541] FOREIGN KEY ([advanced_wep_sched_id]) REFERENCES [dbo].[wsm_advanced_wep] ([advanced_wep_sched_id])
GO
GRANT SELECT ON  [dbo].[wsm_advanced_wep_sched] TO [wsm_admin_group]
GRANT INSERT ON  [dbo].[wsm_advanced_wep_sched] TO [wsm_admin_group]
GRANT DELETE ON  [dbo].[wsm_advanced_wep_sched] TO [wsm_admin_group]
GRANT UPDATE ON  [dbo].[wsm_advanced_wep_sched] TO [wsm_admin_group]
GO
Uses