CREATE TABLE [dbo].[arg_reconcile_task]
(
[task_uuid] [binary] (16) NOT NULL,
[task_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[task_description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[match_indicator] [smallint] NULL,
[add_assets_indicator] [smallint] NULL,
[asset_changes_indicator] [smallint] NULL,
[own_resource_deletes_indicator] [smallint] NULL,
[own_resource_deactiv_indicator] [smallint] NULL,
[discovery_deleted_indicator] [smallint] NULL,
[undo_match_indicator] [smallint] NULL,
[send_msg_to_queue_switch] [smallint] NULL,
[send_msg_to_event_log_switch] [smallint] NULL,
[send_msg_to_email_switch] [smallint] NULL,
[email_ids] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[watch_os_switch] [smallint] NULL,
[watch_computer_name_switch] [smallint] NULL,
[watch_capacity_indicator] [smallint] NULL,
[load_capacity_indicator] [smallint] NULL,
[set_contact_switch] [smallint] NULL,
[add_item_switch] [smallint] NULL,
[item_translation_list_id] [int] NULL,
[os_translation_list_id] [int] NULL,
[new_asset_status] [int] NULL,
[missing_asset_status] [int] NULL,
[deactivated_asset_status] [int] NULL,
[external_sys_id] [int] NULL,
[locking_flag] [smallint] NULL,
[refresh_interval] [int] NULL,
[last_refresh_date] [datetime] NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__arg_recon__versi__703EA55A] DEFAULT ('0'),
[watch_disk_space_switch] [smallint] NULL,
[watch_memory_switch] [smallint] NULL,
[watch_processor_count_switch] [smallint] NULL,
[watch_processor_speed_switch] [smallint] NULL,
[watch_processor_type_switch] [smallint] NULL,
[watch_last_run_date_switch] [smallint] NULL,
[tenant] [binary] (16) NULL,
[load_asset_nm_from_host_nm_sw] [int] NULL,
[is_active] [int] NOT NULL CONSTRAINT [DF__ARG_RECON__IS_AC__0618D7E0] DEFAULT ('1'),
[is_deleted] [int] NOT NULL CONSTRAINT [DF__ARG_RECON__IS_DE__070CFC19] DEFAULT ('0'),
[last_process_date] [int] NOT NULL CONSTRAINT [DF__ARG_RECON__LAST___08012052] DEFAULT ('0'),
[disc_dup_table_name] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[owned_dup_table_name] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_reconcile_task] ADD CONSTRAINT [XPKarg_reconcile_task] PRIMARY KEY CLUSTERED ([task_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_reconcile_task] ADD CONSTRAINT [FK_ARG_RECONCILE_TASK_TENANT] FOREIGN KEY ([tenant]) REFERENCES [dbo].[ca_tenant] ([id])
GO
ALTER TABLE [dbo].[arg_reconcile_task] ADD CONSTRAINT [RTLDJOIN01] FOREIGN KEY ([item_translation_list_id]) REFERENCES [dbo].[arg_listdef] ([ldid])
GO
ALTER TABLE [dbo].[arg_reconcile_task] ADD CONSTRAINT [RTLDJOIN02] FOREIGN KEY ([os_translation_list_id]) REFERENCES [dbo].[arg_listdef] ([ldid])
GO
ALTER TABLE [dbo].[arg_reconcile_task] ADD CONSTRAINT [RTRSJOIN01] FOREIGN KEY ([deactivated_asset_status]) REFERENCES [dbo].[ca_resource_status] ([id])
GO
ALTER TABLE [dbo].[arg_reconcile_task] ADD CONSTRAINT [RTRSJOIN02] FOREIGN KEY ([missing_asset_status]) REFERENCES [dbo].[ca_resource_status] ([id])
GO
ALTER TABLE [dbo].[arg_reconcile_task] ADD CONSTRAINT [RTRSJOIN03] FOREIGN KEY ([new_asset_status]) REFERENCES [dbo].[ca_resource_status] ([id])
GO
ALTER TABLE [dbo].[arg_reconcile_task] ADD CONSTRAINT [RTSLJOIN05] FOREIGN KEY ([load_capacity_indicator]) REFERENCES [dbo].[arg_sl_capacity_types] ([id])
GO
ALTER TABLE [dbo].[arg_reconcile_task] ADD CONSTRAINT [RTSLJOIN15] FOREIGN KEY ([watch_capacity_indicator]) REFERENCES [dbo].[arg_sl_capacity_types] ([id])
GO
GRANT SELECT ON  [dbo].[arg_reconcile_task] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_reconcile_task] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_reconcile_task] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_reconcile_task] TO [swcmadmin]
GO