CREATE TABLE [dbo].[tng_geomap]
(
[name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[height] [int] NOT NULL,
[width] [int] NOT NULL,
[altitude] [int] NOT NULL CONSTRAINT [DF__tng_geoma__altit__534E2C48] DEFAULT ((1)),
[map_file_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[background] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[map_id] [int] NULL,
[upper_left_longitude] [float] NULL,
[upper_left_latitude] [float] NULL,
[lower_right_longitude] [float] NULL,
[lower_right_latitude] [float] NULL,
[mapfunction] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[tnd_xyz_vp11] [float] NULL,
[tnd_xyz_vp12] [float] NULL,
[tnd_xyz_vp13] [float] NULL,
[tnd_xyz_vp21] [float] NULL,
[tnd_xyz_vp22] [float] NULL,
[tnd_xyz_vp23] [float] NULL,
[tnd_xyz_vp31] [float] NULL,
[tnd_xyz_vp32] [float] NULL,
[tnd_xyz_vp33] [float] NULL,
[tnd_vp_position_xyz1] [float] NULL,
[tnd_vp_position_xyz2] [float] NULL,
[tnd_vp_position_xyz3] [float] NULL,
[tnd_image_pixels] [int] NULL,
[tnd_image_raster_lines] [int] NULL,
[tnd_projection_type] [int] NULL,
[tnd_upper_left_corner_bitmap_x] [int] NULL,
[tnd_upper_left_corner_bitmap_y] [int] NULL,
[tnd_screen_height] [float] NULL,
[tnd_screen_width] [float] NULL,
[tnd_background_thumbnail] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_tng_geomap] ON [dbo].[tng_geomap] ([name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[tng_geomap] TO [uniadmin]
GRANT INSERT ON  [dbo].[tng_geomap] TO [uniadmin]
GRANT DELETE ON  [dbo].[tng_geomap] TO [uniadmin]
GRANT UPDATE ON  [dbo].[tng_geomap] TO [uniadmin]
GRANT SELECT ON  [dbo].[tng_geomap] TO [uniuser]
GRANT SELECT ON  [dbo].[tng_geomap] TO [wvadmin]
GRANT INSERT ON  [dbo].[tng_geomap] TO [wvadmin]
GRANT DELETE ON  [dbo].[tng_geomap] TO [wvadmin]
GRANT UPDATE ON  [dbo].[tng_geomap] TO [wvadmin]
GRANT SELECT ON  [dbo].[tng_geomap] TO [wvuser]
GO