CREATE TABLE [dbo].[lac_filenames]
(
[strid] [decimal] (31, 0) NOT NULL,
[serverid] [decimal] (31, 0) NOT NULL,
[database_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[file_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[file_type] [decimal] (31, 0) NOT NULL,
[file_location] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[filenm_manualentry] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_lac_filenames] ON [dbo].[lac_filenames] ([strid], [serverid], [database_name]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[lac_filenames] TO [udmadmin_group]
GRANT INSERT ON [dbo].[lac_filenames] TO [udmadmin_group]
GRANT DELETE ON [dbo].[lac_filenames] TO [udmadmin_group]
GRANT UPDATE ON [dbo].[lac_filenames] TO [udmadmin_group]
GO
[dbo].[lac_filenames]
