CREATE TABLE [dbo].[rmobacklog]
(
[uname] [char] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[address] [char] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[date] [int] NOT NULL,
[accessliteral] [char] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[problemid] [char] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[messageid] [char] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[timesent] [int] NULL,
[dataout] [int] NULL,
[datain] [int] NULL,
[status] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[rmobacklog] TO [emadmin]
GRANT INSERT ON  [dbo].[rmobacklog] TO [emadmin]
GRANT DELETE ON  [dbo].[rmobacklog] TO [emadmin]
GRANT UPDATE ON  [dbo].[rmobacklog] TO [emadmin]
GRANT SELECT ON  [dbo].[rmobacklog] TO [emuser]
GRANT SELECT ON  [dbo].[rmobacklog] TO [uniadmin]
GRANT INSERT ON  [dbo].[rmobacklog] TO [uniadmin]
GRANT DELETE ON  [dbo].[rmobacklog] TO [uniadmin]
GRANT UPDATE ON  [dbo].[rmobacklog] TO [uniadmin]
GRANT SELECT ON  [dbo].[rmobacklog] TO [uniuser]
GO