CREATE TABLE [dbo].[job_template]
(
[templateid] [int] NOT NULL,
[name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[owner] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[templateleft] [int] NULL,
[templateright] [int] NULL,
[templatetop] [int] NULL,
[templatebottom] [int] NULL,
[clonename] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[clonedescription] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[clonebox] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[cloneinstance] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[checkoutsid] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[checkoutname] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[psname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[clonepsname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[autosystemplate] [smallint] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [job_template_idx_01] ON [dbo].[job_template] ([name]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_job_template] ON [dbo].[job_template] ([templateid]) ON [PRIMARY]
GO