CREATE TABLE [dbo].[usm_doctmpl_layoutlist]
(
[document_template_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[order] [int] NOT NULL CONSTRAINT [DF__usm_doctm__order__58746AC6] DEFAULT ((-1)),
[report_layout_id] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[content_order] [int] NOT NULL CONSTRAINT [DF__usm_doctm__conte__59688EFF] DEFAULT ((-1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_doctmpl_layoutlist] ADD CONSTRAINT [PK__usm_doctmpl_layo__5A5CB338] PRIMARY KEY CLUSTERED ([document_template_id], [order], [content_order]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_doctmpl_layoutlist] ADD CONSTRAINT [$usm_d_r0000226b00000000] FOREIGN KEY ([document_template_id]) REFERENCES [dbo].[usm_document_template] ([document_template_id]) ON DELETE CASCADE ON UPDATE CASCADE
GO
GRANT SELECT ON  [dbo].[usm_doctmpl_layoutlist] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_doctmpl_layoutlist] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_doctmpl_layoutlist] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_doctmpl_layoutlist] TO [usmgroup]
GO