CREATE TABLE [dbo].[usm_service_desk_ticket]
(
[service_desk_ticket_id] [int] NOT NULL CONSTRAINT [DF__usm_servi__servi__60290479] DEFAULT ((1)),
[ticket_id] [int] NOT NULL,
[ticket_name] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[server_id] [int] NULL,
[priority_id] [int] NOT NULL CONSTRAINT [DF__usm_servi__prior__611D28B2] DEFAULT ((1)),
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[message] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[problem_type] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[start_date] [int] NULL,
[open_date] [int] NULL,
[resolve_date] [int] NULL,
[close_date] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_service_desk_ticket] ADD CONSTRAINT [XPKusm_service_desk_ticket] PRIMARY KEY CLUSTERED ([service_desk_ticket_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_service_desk_ticket] ADD CONSTRAINT [$usm_s_r00002a1d00000000] FOREIGN KEY ([server_id]) REFERENCES [dbo].[usm_slm_server] ([server_id])
GO
GRANT SELECT ON  [dbo].[usm_service_desk_ticket] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_service_desk_ticket] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_service_desk_ticket] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_service_desk_ticket] TO [usmgroup]
GO