CREATE TABLE [dbo].[jmo_trt1]
(
[trt_trev] [char] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[trt_trid] [char] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[trt_qual] [char] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[trt_apc7] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trt_desc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trt_jnam] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trt_usid] [varchar] (33) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trt_stan] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trt_faill] [int] NULL,
[trt_failh] [int] NULL,
[trt_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trt_ustat] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trt_jobn] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trt_scdn] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trt_bklog] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trt_cal] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trt_fdate] [int] NULL,
[trt_tstat] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [baseidx_jmo_trt1] ON [dbo].[jmo_trt1] ([trt_trev], [trt_trid], [trt_qual]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[jmo_trt1] TO [emadmin]
GRANT INSERT ON  [dbo].[jmo_trt1] TO [emadmin]
GRANT DELETE ON  [dbo].[jmo_trt1] TO [emadmin]
GRANT UPDATE ON  [dbo].[jmo_trt1] TO [emadmin]
GRANT SELECT ON  [dbo].[jmo_trt1] TO [emuser]
GRANT SELECT ON  [dbo].[jmo_trt1] TO [jmoadmin]
GRANT INSERT ON  [dbo].[jmo_trt1] TO [jmoadmin]
GRANT DELETE ON  [dbo].[jmo_trt1] TO [jmoadmin]
GRANT UPDATE ON  [dbo].[jmo_trt1] TO [jmoadmin]
GRANT SELECT ON  [dbo].[jmo_trt1] TO [jmouser]
GRANT SELECT ON  [dbo].[jmo_trt1] TO [uniadmin]
GRANT INSERT ON  [dbo].[jmo_trt1] TO [uniadmin]
GRANT DELETE ON  [dbo].[jmo_trt1] TO [uniadmin]
GRANT UPDATE ON  [dbo].[jmo_trt1] TO [uniadmin]
GRANT SELECT ON  [dbo].[jmo_trt1] TO [uniuser]
GO