CREATE TABLE [dbo].[documentation]
(
[prod] [char] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[id] [varchar] (57) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[type] [smallint] NOT NULL,
[text] [text] COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[summary] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[crt_date] [int] NOT NULL,
[crt_time] [int] NOT NULL,
[crt_id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[upd_date] [int] NOT NULL,
[upd_time] [int] NOT NULL,
[upd_id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_documentation] ON [dbo].[documentation] ([prod], [id], [type]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[documentation] TO [emadmin]
GRANT INSERT ON  [dbo].[documentation] TO [emadmin]
GRANT DELETE ON  [dbo].[documentation] TO [emadmin]
GRANT UPDATE ON  [dbo].[documentation] TO [emadmin]
GRANT SELECT ON  [dbo].[documentation] TO [emuser]
GRANT SELECT ON  [dbo].[documentation] TO [uniadmin]
GRANT INSERT ON  [dbo].[documentation] TO [uniadmin]
GRANT DELETE ON  [dbo].[documentation] TO [uniadmin]
GRANT UPDATE ON  [dbo].[documentation] TO [uniadmin]
GRANT SELECT ON  [dbo].[documentation] TO [uniuser]
GO