CREATE TABLE [dbo].[jmo_gens]
(
[sim_key] [char] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[scp_key] [char] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[scj_prty] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[scg_en1] [binary] (1) NULL,
[scg_en2] [binary] (1) NULL,
[scg_en6] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sca_utotm] [int] NULL,
[sca_utoit] [smallint] NULL,
[scw_s] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[scd_tab] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sch_istc] [smallint] NULL,
[scm_xaudt] [smallint] NULL,
[scq_name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[scm_axpsr] [smallint] NULL,
[scm_axinp] [smallint] NULL,
[scm_axres] [smallint] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [baseidx_jmo_gens] ON [dbo].[jmo_gens] ([scp_key]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[jmo_gens] TO [emadmin]
GRANT INSERT ON  [dbo].[jmo_gens] TO [emadmin]
GRANT DELETE ON  [dbo].[jmo_gens] TO [emadmin]
GRANT UPDATE ON  [dbo].[jmo_gens] TO [emadmin]
GRANT SELECT ON  [dbo].[jmo_gens] TO [emuser]
GRANT SELECT ON  [dbo].[jmo_gens] TO [jmoadmin]
GRANT INSERT ON  [dbo].[jmo_gens] TO [jmoadmin]
GRANT DELETE ON  [dbo].[jmo_gens] TO [jmoadmin]
GRANT UPDATE ON  [dbo].[jmo_gens] TO [jmoadmin]
GRANT SELECT ON  [dbo].[jmo_gens] TO [jmouser]
GRANT SELECT ON  [dbo].[jmo_gens] TO [uniadmin]
GRANT INSERT ON  [dbo].[jmo_gens] TO [uniadmin]
GRANT DELETE ON  [dbo].[jmo_gens] TO [uniadmin]
GRANT UPDATE ON  [dbo].[jmo_gens] TO [uniadmin]
GRANT SELECT ON  [dbo].[jmo_gens] TO [uniuser]
GO