CREATE TABLE [dbo].[usm_form_component_attributes]
(
[form_comp_attr_id] [bigint] NOT NULL,
[form_comp_id] [bigint] NOT NULL,
[attr_locale] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[attr_name] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[attr_value] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[usm_form_component_attributes] ADD CONSTRAINT [XPKusm_form_comp_attributes] PRIMARY KEY CLUSTERED ([form_comp_attr_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_forrm_comp_attr_idx_2] ON [dbo].[usm_form_component_attributes] ([attr_name], [attr_locale]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_forrm_comp_attr_idx_1] ON [dbo].[usm_form_component_attributes] ([form_comp_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_form_component_attributes] ADD CONSTRAINT [XFK1usm_form_comp_attributes] FOREIGN KEY ([form_comp_id]) REFERENCES [dbo].[usm_form_entities] ([form_entity_id])
GO