CREATE TABLE [dbo].[e2e_apm_temp_data]
(
[trans_id] [int] NULL,
[app_id] [int] NULL,
[op_id] [int] NULL,
[host_id] [int] NULL,
[client_id] [int] NULL,
[user_id] [int] NULL,
[server_id] [int] NULL,
[start_datetime] [datetime] NULL,
[gmt_datetime] [datetime] NULL,
[local_time] [int] NULL,
[local_date] [int] NULL,
[gmt_time] [int] NULL,
[gmt_date] [int] NULL,
[duration] [float] NULL,
[local_dur] [float] NULL,
[wire_dur] [float] NULL,
[server_dur] [float] NULL,
[num_complete] [int] NULL,
[num_cancelled] [int] NULL,
[num_exception] [int] NULL,
[delta_threshold] [float] NULL,
[cpu_util] [int] NULL,
[mem_util] [int] NULL,
[net_global] [int] NULL,
[net_total] [int] NULL,
[packet_loss] [int] NULL,
[source_id] [smallint] NULL,
[old_data] [tinyint] NULL,
[trans_cached] [tinyint] NULL,
[trans_wellness] [tinyint] NULL,
[exception_threshold] [int] NULL,
[trans_detail] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[trans_title] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[old_hourly] [tinyint] NULL,
[old_daily] [tinyint] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[e2e_apm_temp_data] TO [apmadmin]
GRANT INSERT ON  [dbo].[e2e_apm_temp_data] TO [apmadmin]
GRANT DELETE ON  [dbo].[e2e_apm_temp_data] TO [apmadmin]
GRANT UPDATE ON  [dbo].[e2e_apm_temp_data] TO [apmadmin]
GO