Tables [dbo].[wsm_link_rsrc_bundle_tmplt]
Properties
PropertyValue
Row Count0
Created12:31:39 PM Sunday, December 05, 2010
Last Modified12:33:46 PM Sunday, December 05, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKwsm_link_rsrc_bundle_tmplt: bundleid\templateuuidForeign Keys r_1538: [dbo].[wsm_resource_bundle].bundleidIndexes xif1wsm_link_rsrc_bundle_tmplt: bundleidbundleidint4
No
Cluster Primary Key XPKwsm_link_rsrc_bundle_tmplt: bundleid\templateuuidForeign Keys r_1539: [dbo].[wsm_template].templateuuidIndexes xif2wsm_link_rsrc_bundle_tmplt: templateuuidtemplateuuidbinary(16)16
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKwsm_link_rsrc_bundle_tmplt: bundleid\templateuuidXPKwsm_link_rsrc_bundle_tmpltbundleid, templateuuid
Yes
xif1wsm_link_rsrc_bundle_tmpltbundleid
xif2wsm_link_rsrc_bundle_tmplttemplateuuid
Foreign Keys Foreign Keys
NameColumns
r_1538bundleid->[dbo].[wsm_resource_bundle].[bundleid]
r_1539templateuuid->[dbo].[wsm_template].[templateuuid]
Permissions
TypeActionOwning Principal
GrantDeletewsm_admin_group
GrantInsertwsm_admin_group
GrantSelectwsm_admin_group
GrantUpdatewsm_admin_group
GrantSelectwsm_ro_group
SQL Script
CREATE TABLE [dbo].[wsm_link_rsrc_bundle_tmplt]
(
[bundleid] [int] NOT NULL,
[templateuuid] [binary] (16) NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[wsm_link_rsrc_bundle_tmplt] ADD CONSTRAINT [XPKwsm_link_rsrc_bundle_tmplt] PRIMARY KEY CLUSTERED ([bundleid], [templateuuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1wsm_link_rsrc_bundle_tmplt] ON [dbo].[wsm_link_rsrc_bundle_tmplt] ([bundleid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2wsm_link_rsrc_bundle_tmplt] ON [dbo].[wsm_link_rsrc_bundle_tmplt] ([templateuuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_link_rsrc_bundle_tmplt] ADD CONSTRAINT [r_1538] FOREIGN KEY ([bundleid]) REFERENCES [dbo].[wsm_resource_bundle] ([bundleid])
GO
ALTER TABLE [dbo].[wsm_link_rsrc_bundle_tmplt] ADD CONSTRAINT [r_1539] FOREIGN KEY ([templateuuid]) REFERENCES [dbo].[wsm_template] ([templateuuid])
GO
GRANT SELECT ON  [dbo].[wsm_link_rsrc_bundle_tmplt] TO [wsm_admin_group]
GRANT INSERT ON  [dbo].[wsm_link_rsrc_bundle_tmplt] TO [wsm_admin_group]
GRANT DELETE ON  [dbo].[wsm_link_rsrc_bundle_tmplt] TO [wsm_admin_group]
GRANT UPDATE ON  [dbo].[wsm_link_rsrc_bundle_tmplt] TO [wsm_admin_group]
GRANT SELECT ON  [dbo].[wsm_link_rsrc_bundle_tmplt] TO [wsm_ro_group]
GO
Uses