Foxhound 4.0.4729a Adhoc Schema

  Tables: A B C D E G M P R S U
  Top A
DBA alert  - view
DBA alert_cancelled  - view
DBA alert_union  - view
DBA alerts_criteria  - view
DBA all_clear  - view
DBA applied_patch  - view
DBA autodrop_candidate  - view
DBA autodropped_connection  - view

  Top B
DBA build_number  - view

  Top C
DBA connection_string  - view

  Top D
DBA data_upgrade_history  - view

  Top E
DBA email_failure  - view
DBA exception_diagnostic  - view
DBA exception_dump  - view
DBA expiry_date  - view

  Top G
DBA global_options  - view

  Top M
DBA monitor_sampler_control  - view

  Top P
DBA peaks  - view
DBA ping_log  - view
DBA purge_run  - view

  Top R
DBA rroad_alert empty
DBA rroad_alert_cancelled empty
DBA rroad_alert_union  - view
DBA rroad_alerts_criteria empty
DBA rroad_all_clear empty
DBA rroad_applied_patch empty
DBA rroad_autodrop_candidate empty
DBA rroad_autodropped_connection empty
DBA rroad_build_number empty
DBA rroad_connection_string empty
DBA rroad_data_upgrade_history empty
DBA rroad_email_failure empty
DBA rroad_exception empty
DBA rroad_exception_dump empty
DBA rroad_expiry_date empty
DBA rroad_global_options empty
DBA rroad_group_1_property_pivot empty
DBA rroad_group_2_property_pivot empty
DBA rroad_monitor_sampler_control empty
DBA rroad_peaks empty
DBA rroad_ping_log empty
DBA rroad_purge_run empty
DBA rroad_run_characteristics empty
DBA rroad_sample_set empty
DBA rroad_sampling_options empty
DBA rroad_schedule empty
DBA rroad_schedule_day_entry empty
DBA rroad_schedule_period_entry empty
DBA rroad_serial_number empty
DBA rroad_session_options empty
DBA run_characteristics  - view

  Top S
DBA sample_connection  - view
DBA sample_detail  - view
DBA sample_header  - view
DBA sampling_options  - view
DBA schedule  - view
DBA schedule_day_entry  - view
DBA schedule_period_entry  - view
DBA serial_number  - view
DBA session_options  - view

  Top U


Top    Tables: A B C D E G M P R S U

DBA.alert

-- DBA.alert (table_id 748) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:19AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.alert (
--    alert_occurrence,    -- UNSIGNED BIGINT
--    sampling_id,         -- UNSIGNED INT
--    sample_set_number,   -- UNSIGNED BIGINT
--    alert_number,        -- INTEGER
--    alert_in_effect_at,  -- TIMESTAMP
--    alert_description,   -- LONG VARCHAR
--    email_status )       -- LONG VARCHAR

create VIEW alert AS SELECT * FROM rroad_alert
;


Top    Tables: A B C D E G M P R S U

DBA.alert_cancelled

-- DBA.alert_cancelled (table_id 752) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:19AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.alert_cancelled (
--    alert_cancelled_occurrence,  -- UNSIGNED BIGINT
--    sampling_id,                 -- UNSIGNED INT
--    sample_set_number,           -- UNSIGNED BIGINT
--    alert_number,                -- INTEGER
--    alert_all_clear_at,          -- TIMESTAMP
--    alert_in_effect_at,          -- TIMESTAMP
--    alert_description,           -- LONG VARCHAR
--    email_status )               -- LONG VARCHAR

create VIEW alert_cancelled AS SELECT * FROM rroad_alert_cancelled
;


Top    Tables: A B C D E G M P R S U

DBA.alert_union

-- DBA.alert_union (table_id 800) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:19AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.alert_union (
--    record_type,                  -- VARCHAR ( 20 )
--    sampling_id,                  -- UNSIGNED INT
--    selected_tab,                 -- VARCHAR ( 1 )
--    selected_name,                -- VARCHAR ( 128 )
--    sample_set_number,            -- NUMERIC ( 20 )
--    alert_number,                 -- INTEGER
--    recorded_at,                  -- TIMESTAMP
--    alert_description,            -- LONG VARCHAR
--    email_status,                 -- LONG VARCHAR
--    alert_is_clear_or_cancelled ) -- VARCHAR ( 1 )

create VIEW alert_union AS SELECT * FROM rroad_alert_union
;


Top    Tables: A B C D E G M P R S U

DBA.alerts_criteria

-- DBA.alerts_criteria (table_id 754) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:19AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.alerts_criteria (
--    criteria_set_type,                                                            -- VARCHAR ( 100 )
--    sampling_id,                                                                  -- UNSIGNED INT
--    send_alert_emails,                                                            -- VARCHAR ( 1 )
--    mail_recipient,                                                               -- LONG VARCHAR
--    use_html_in_emails,                                                           -- VARCHAR ( 1 )
--    email_url_host_port,                                                          -- LONG VARCHAR
--    display_alerts,                                                               -- VARCHAR ( 1 )
--    autodrop_mail_recipients,                                                     -- LONG VARCHAR
--    autodrop_mail_recipients_same_as_for_alerts,                                  -- VARCHAR ( 1 )
--    previous_sample_set_number_processed,                                         -- UNSIGNED BIGINT
--    previous_gathered_sample_finished_at,                                         -- TIMESTAMP
--    current_sample_finished_at,                                                   -- TIMESTAMP
--    alert1_enabled,                                                               -- VARCHAR ( 1 )
--    alert1_is_in_effect,                                                          -- VARCHAR ( 1 )
--    alert1_in_effect_at,                                                          -- TIMESTAMP
--    alert1_all_clear_at,                                                          -- TIMESTAMP
--    alert1_threshold_lost_sample_accumulated_msec,                                -- BIGINT
--    alert1_actual_lost_sample_accumulated_msec,                                   -- BIGINT
--    alert2_enabled,                                                               -- VARCHAR ( 1 )
--    alert2_is_in_effect,                                                          -- VARCHAR ( 1 )
--    alert2_in_effect_at,                                                          -- TIMESTAMP
--    alert2_all_clear_at,                                                          -- TIMESTAMP
--    alert2_threshold_canarian_msec,                                               -- BIGINT
--    alert2_threshold_canarian_msec_sample_count,                                  -- BIGINT
--    alert2_actual_canarian_msec_threshold_reached_sample_counter,                 -- BIGINT
--    alert3_enabled,                                                               -- VARCHAR ( 1 )
--    alert3_is_in_effect,                                                          -- VARCHAR ( 1 )
--    alert3_in_effect_at,                                                          -- TIMESTAMP
--    alert3_all_clear_at,                                                          -- TIMESTAMP
--    alert3_threshold_sample_msec,                                                 -- BIGINT
--    alert3_threshold_sample_msec_sample_count,                                    -- BIGINT
--    alert3_actual_sample_msec_threshold_reached_sample_counter,                   -- BIGINT
--    alert4_enabled,                                                               -- VARCHAR ( 1 )
--    alert4_is_in_effect,                                                          -- VARCHAR ( 1 )
--    alert4_in_effect_at,                                                          -- TIMESTAMP
--    alert4_all_clear_at,                                                          -- TIMESTAMP
--    alert4_threshold_cpu_percent,                                                 -- BIGINT
--    alert4_threshold_cpu_percent_sample_count,                                    -- BIGINT
--    alert4_actual_cpu_percent_threshold_reached_sample_counter,                   -- BIGINT
--    alert5_enabled,                                                               -- VARCHAR ( 1 )
--    alert5_is_in_effect,                                                          -- VARCHAR ( 1 )
--    alert5_in_effect_at,                                                          -- TIMESTAMP
--    alert5_all_clear_at,                                                          -- TIMESTAMP
--    alert5_threshold_system_free_bytes,                                           -- BIGINT
--    alert5_actual_system_free_bytes,                                              -- BIGINT
--    alert6_enabled,                                                               -- VARCHAR ( 1 )
--    alert6_is_in_effect,                                                          -- VARCHAR ( 1 )
--    alert6_in_effect_at,                                                          -- TIMESTAMP
--    alert6_all_clear_at,                                                          -- TIMESTAMP
--    alert6_threshold_temp_file_free_bytes,                                        -- BIGINT
--    alert6_actual_temp_file_free_bytes,                                           -- BIGINT
--    alert7_enabled,                                                               -- VARCHAR ( 1 )
--    alert7_is_in_effect,                                                          -- VARCHAR ( 1 )
--    alert7_in_effect_at,                                                          -- TIMESTAMP
--    alert7_all_clear_at,                                                          -- TIMESTAMP
--    alert7_threshold_log_free_bytes,                                              -- BIGINT
--    alert7_actual_log_free_bytes,                                                 -- BIGINT
--    alert8_enabled,                                                               -- VARCHAR ( 1 )
--    alert8_is_in_effect,                                                          -- VARCHAR ( 1 )
--    alert8_in_effect_at,                                                          -- TIMESTAMP
--    alert8_all_clear_at,                                                          -- TIMESTAMP
--    alert8_threshold_min_other_free_bytes,                                        -- BIGINT
--    alert8_actual_min_other_free_bytes,                                           -- BIGINT
--    alert9_enabled,                                                               -- VARCHAR ( 1 )
--    alert9_is_in_effect,                                                          -- VARCHAR ( 1 )
--    alert9_in_effect_at,                                                          -- TIMESTAMP
--    alert9_all_clear_at,                                                          -- TIMESTAMP
--    alert9_actual_ArbiterState,                                                   -- LONG VARCHAR
--    alert10_enabled,                                                              -- VARCHAR ( 1 )
--    alert10_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert10_in_effect_at,                                                         -- TIMESTAMP
--    alert10_all_clear_at,                                                         -- TIMESTAMP
--    alert10_actual_PartnerState,                                                  -- LONG VARCHAR
--    alert11_enabled,                                                              -- VARCHAR ( 1 )
--    alert11_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert11_in_effect_at,                                                         -- TIMESTAMP
--    alert11_all_clear_at,                                                         -- TIMESTAMP
--    alert11_actual_previous_ServerName,                                           -- LONG VARCHAR
--    alert11_actual_current_ServerName,                                            -- LONG VARCHAR
--    alert12_enabled,                                                              -- VARCHAR ( 1 )
--    alert12_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert12_in_effect_at,                                                         -- TIMESTAMP
--    alert12_all_clear_at,                                                         -- TIMESTAMP
--    alert12_actual_previous_ReadOnly,                                             -- LONG VARCHAR
--    alert12_actual_current_ReadOnly,                                              -- LONG VARCHAR
--    alert13_enabled,                                                              -- VARCHAR ( 1 )
--    alert13_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert13_in_effect_at,                                                         -- TIMESTAMP
--    alert13_all_clear_at,                                                         -- TIMESTAMP
--    alert13_threshold_DBFileFragments,                                            -- BIGINT
--    alert13_actual_DBFileFragments,                                               -- BIGINT
--    alert14_enabled,                                                              -- VARCHAR ( 1 )
--    alert14_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert14_in_effect_at,                                                         -- TIMESTAMP
--    alert14_all_clear_at,                                                         -- TIMESTAMP
--    alert14_threshold_UnschReq,                                                   -- BIGINT
--    alert14_threshold_UnschReq_sample_count,                                      -- BIGINT
--    alert14_actual_UnschReq_threshold_reached_sample_counter,                     -- BIGINT
--    alert15_enabled,                                                              -- VARCHAR ( 1 )
--    alert15_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert15_in_effect_at,                                                         -- TIMESTAMP
--    alert15_all_clear_at,                                                         -- TIMESTAMP
--    alert15_threshold_CurrIO,                                                     -- BIGINT
--    alert15_threshold_CurrIO_sample_count,                                        -- BIGINT
--    alert15_actual_CurrIO_threshold_reached_sample_counter,                       -- BIGINT
--    alert15_threshold_CurrRead_CurrWrite,                                         -- BIGINT
--    alert15_threshold_CurrRead_CurrWrite_sample_count,                            -- BIGINT
--    alert15_actual_CurrRead_CurrWrite_threshold_reached_sample_counter,           -- BIGINT
--    alert16_enabled,                                                              -- VARCHAR ( 1 )
--    alert16_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert16_in_effect_at,                                                         -- TIMESTAMP
--    alert16_all_clear_at,                                                         -- TIMESTAMP
--    alert16_threshold_io_rate,                                                    -- BIGINT
--    alert16_threshold_io_rate_sample_count,                                       -- BIGINT
--    alert16_actual_io_rate_threshold_reached_sample_counter,                      -- BIGINT
--    alert17_enabled,                                                              -- VARCHAR ( 1 )
--    alert17_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert17_in_effect_at,                                                         -- TIMESTAMP
--    alert17_all_clear_at,                                                         -- TIMESTAMP
--    alert17_threshold_CheckpointUrgency,                                          -- BIGINT
--    alert17_threshold_CheckpointUrgency_sample_count,                             -- BIGINT
--    alert17_actual_CheckpointUrgency_threshold_reached_sample_counter,            -- BIGINT
--    alert18_enabled,                                                              -- VARCHAR ( 1 )
--    alert18_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert18_in_effect_at,                                                         -- TIMESTAMP
--    alert18_all_clear_at,                                                         -- TIMESTAMP
--    alert18_threshold_RecoveryUrgency,                                            -- BIGINT
--    alert18_threshold_RecoveryUrgency_sample_count,                               -- BIGINT
--    alert18_actual_RecoveryUrgency_threshold_reached_sample_counter,              -- BIGINT
--    alert19_enabled,                                                              -- VARCHAR ( 1 )
--    alert19_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert19_in_effect_at,                                                         -- TIMESTAMP
--    alert19_all_clear_at,                                                         -- TIMESTAMP
--    alert19_threshold_cache_allocation,                                           -- BIGINT
--    alert19_threshold_cache_allocation_sample_count,                              -- BIGINT
--    alert19_actual_cache_allocation_threshold_reached_sample_counter,             -- BIGINT
--    alert20_enabled,                                                              -- VARCHAR ( 1 )
--    alert20_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert20_in_effect_at,                                                         -- TIMESTAMP
--    alert20_all_clear_at,                                                         -- TIMESTAMP
--    alert20_threshold_cache_satisfaction,                                         -- BIGINT
--    alert20_threshold_cache_satisfaction_sample_count,                            -- BIGINT
--    alert20_actual_cache_satisfaction_threshold_reached_sample_counter,           -- BIGINT
--    alert21_enabled,                                                              -- VARCHAR ( 1 )
--    alert21_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert21_in_effect_at,                                                         -- TIMESTAMP
--    alert21_all_clear_at,                                                         -- TIMESTAMP
--    alert21_threshold_total_temporary_space_usage,                                -- BIGINT
--    alert21_threshold_total_temporary_space_usage_sample_count,                   -- BIGINT
--    alert21_actual_total_temporary_space_usage_threshold_reached_sample_counter,  -- BIGINT
--    alert22_enabled,                                                              -- VARCHAR ( 1 )
--    alert22_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert22_in_effect_at,                                                         -- TIMESTAMP
--    alert22_all_clear_at,                                                         -- TIMESTAMP
--    alert22_threshold_max_temporary_space_usage,                                  -- BIGINT
--    alert22_threshold_max_temporary_space_usage_sample_count,                     -- BIGINT
--    alert22_actual_max_temporary_space_usage_threshold_reached_sample_counter,    -- BIGINT
--    alert23_enabled,                                                              -- VARCHAR ( 1 )
--    alert23_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert23_in_effect_at,                                                         -- TIMESTAMP
--    alert23_all_clear_at,                                                         -- TIMESTAMP
--    alert23_threshold_blocked_connections,                                        -- BIGINT
--    alert23_threshold_blocked_connections_sample_count,                           -- BIGINT
--    alert23_actual_blocked_connections_threshold_reached_sample_counter,          -- BIGINT
--    alert24_enabled,                                                              -- VARCHAR ( 1 )
--    alert24_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert24_in_effect_at,                                                         -- TIMESTAMP
--    alert24_all_clear_at,                                                         -- TIMESTAMP
--    alert24_threshold_max_blocked_by,                                             -- BIGINT
--    alert24_threshold_max_blocked_by_sample_count,                                -- BIGINT
--    alert24_actual_max_blocked_by_threshold_reached_sample_counter,               -- BIGINT
--    alert25_enabled,                                                              -- VARCHAR ( 1 )
--    alert25_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert25_in_effect_at,                                                         -- TIMESTAMP
--    alert25_all_clear_at,                                                         -- TIMESTAMP
--    alert25_threshold_locks,                                                      -- BIGINT
--    alert25_threshold_locks_sample_count,                                         -- BIGINT
--    alert25_actual_locks_threshold_reached_sample_counter,                        -- BIGINT
--    alert26_enabled,                                                              -- VARCHAR ( 1 )
--    alert26_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert26_in_effect_at,                                                         -- TIMESTAMP
--    alert26_all_clear_at,                                                         -- TIMESTAMP
--    alert26_threshold_connections,                                                -- BIGINT
--    alert26_threshold_connections_sample_count,                                   -- BIGINT
--    alert26_actual_connections_threshold_reached_sample_counter,                  -- BIGINT
--    alert27_enabled,                                                              -- VARCHAR ( 1 )
--    alert27_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert27_in_effect_at,                                                         -- TIMESTAMP
--    alert27_all_clear_at,                                                         -- TIMESTAMP
--    alert27_threshold_max_connection_cpu,                                         -- BIGINT
--    alert27_threshold_max_connection_cpu_sample_count,                            -- BIGINT
--    alert27_actual_max_connection_cpu_threshold_reached_sample_counter,           -- BIGINT
--    alert28_enabled,                                                              -- VARCHAR ( 1 )
--    alert28_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert28_in_effect_at,                                                         -- TIMESTAMP
--    alert28_all_clear_at,                                                         -- TIMESTAMP
--    alert28_threshold_max_transaction_time,                                       -- BIGINT
--    alert28_threshold_max_transaction_time_sample_count,                          -- BIGINT
--    alert28_actual_max_transaction_time_threshold_reached_sample_counter,         -- BIGINT
--    alert29_enabled,                                                              -- VARCHAR ( 1 )
--    alert29_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert29_in_effect_at,                                                         -- TIMESTAMP
--    alert29_all_clear_at,                                                         -- TIMESTAMP
--    alert29_threshold_cache_panics,                                               -- BIGINT
--    alert29_threshold_cache_panics_sample_count,                                  -- BIGINT
--    alert29_actual_cache_panics_threshold_reached_sample_counter,                 -- BIGINT
--    alert30_enabled,                                                              -- VARCHAR ( 1 )
--    alert30_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert30_in_effect_at,                                                         -- TIMESTAMP
--    alert30_all_clear_at,                                                         -- TIMESTAMP
--    alert30_actual_previous_ReadOnly,                                             -- LONG VARCHAR
--    alert30_actual_current_ReadOnly,                                              -- LONG VARCHAR
--    alert31_enabled,                                                              -- VARCHAR ( 1 )
--    alert31_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert31_in_effect_at,                                                         -- TIMESTAMP
--    alert31_all_clear_at,                                                         -- TIMESTAMP
--    alert31_actual_previous_ReadOnly,                                             -- LONG VARCHAR
--    alert31_actual_current_ReadOnly,                                              -- LONG VARCHAR
--    alert32_enabled,                                                              -- VARCHAR ( 1 )
--    alert32_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert32_in_effect_at,                                                         -- TIMESTAMP
--    alert32_all_clear_at,                                                         -- TIMESTAMP
--    alert32_threshold_total_rollback_space_usage,                                 -- BIGINT
--    alert32_threshold_total_rollback_space_usage_sample_count,                    -- BIGINT
--    alert32_actual_total_rollback_space_usage_threshold_reached_sample_counter,   -- BIGINT
--    alert33_enabled,                                                              -- VARCHAR ( 1 )
--    alert33_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert33_in_effect_at,                                                         -- TIMESTAMP
--    alert33_all_clear_at,                                                         -- TIMESTAMP
--    alert33_threshold_uncommitted,                                                -- BIGINT
--    alert33_threshold_uncommitted_sample_count,                                   -- BIGINT
--    alert33_actual_uncommitted_threshold_reached_sample_counter,                  -- BIGINT
--    alert34_enabled,                                                              -- VARCHAR ( 1 )
--    alert34_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert34_in_effect_at,                                                         -- TIMESTAMP
--    alert34_all_clear_at,                                                         -- TIMESTAMP
--    alert34_threshold_uncommitted,                                                -- BIGINT
--    alert34_threshold_transaction_time,                                           -- BIGINT
--    alert34_actual_current_thresholds_met,                                        -- VARCHAR ( 1 )
--    alert35_enabled,                                                              -- VARCHAR ( 1 )
--    alert35_is_in_effect,                                                         -- VARCHAR ( 1 )
--    alert35_in_effect_at,                                                         -- TIMESTAMP
--    alert35_all_clear_at,                                                         -- TIMESTAMP
--    alert35_threshold_sample_count,                                               -- BIGINT
--    alert35_actual_sample_counter,                                                -- BIGINT
--    notice1_enabled,                                                              -- VARCHAR ( 1 )
--    autodrop1_enabled,                                                            -- VARCHAR ( 1 )
--    autodrop1_threshold_blocking_connections,                                     -- BIGINT
--    autodrop1_threshold_blocking_connections_sample_count,                        -- BIGINT
--    autodrop1_actual_blocking_connections_threshold_reached_sample_counter,       -- BIGINT
--    autodrop2_enabled,                                                            -- VARCHAR ( 1 )
--    autodrop2_threshold_blocked_sample_count,                                     -- BIGINT
--    autodrop2_actual_blocked_sample_counter,                                      -- BIGINT
--    autodrop3_enabled,                                                            -- VARCHAR ( 1 )
--    autodrop3_threshold_transaction_msec,                                         -- BIGINT
--    autodrop4_enabled,                                                            -- VARCHAR ( 1 )
--    autodrop4_threshold_max_temporary_space_usage,                                -- BIGINT
--    autodrop4_threshold_max_temporary_space_usage_sample_count,                   -- BIGINT
--    autodrop4_actual_max_temporary_space_usage_threshold_reached_sample_counter,  -- BIGINT
--    autodrop5_enabled,                                                            -- VARCHAR ( 1 )
--    autodrop5_threshold_cpu_percent,                                              -- BIGINT
--    autodrop5_threshold_cpu_percent_sample_count,                                 -- BIGINT
--    autodrop5_actual_cpu_percent_threshold_reached_sample_counter,                -- BIGINT
--    autodrop6_enabled,                                                            -- VARCHAR ( 1 )
--    autodrop6_threshold_locks,                                                    -- BIGINT
--    autodrop6_threshold_locks_sample_count,                                       -- BIGINT
--    autodrop6_actual_locks_threshold_reached_sample_counter,                      -- BIGINT
--    do_not_autodrop_user_id_list_enabled,                                         -- VARCHAR ( 1 )
--    do_not_autodrop_user_id_list,                                                 -- LONG VARCHAR
--    do_not_autodrop_connection_name_list_enabled,                                 -- VARCHAR ( 1 )
--    do_not_autodrop_connection_name_list,                                         -- LONG VARCHAR
--    monitor_dedicated_task_enabled,                                               -- VARCHAR ( 1 )
--    monitor_dedicated_task_status,                                                -- LONG VARCHAR
--    monitor_connection_name_template,                                             -- VARCHAR ( 100 )
--    ping_only_sampling,                                                           -- VARCHAR ( 1 )
--    ping_enabled_for_successful_samples,                                          -- VARCHAR ( 1 )
--    ping_enabled_for_lost_samples,                                                -- VARCHAR ( 1 )
--    ping_repeated_during_outages,                                                 -- VARCHAR ( 1 )
--    ping_connection_name_template )                                               -- VARCHAR ( 100 )

create VIEW alerts_criteria AS SELECT * FROM rroad_alerts_criteria
----------------------------------------------------------------------------------------------------- 
-- alerts_criteria -- Foxhound Version 4 Changes...
----------------------------------------------------------------------------------------------------- 
-- New column: autodrop_mail_recipients                                           LONG VARCHAR
-- New column: autodrop_mail_recipients_same_as_for_alerts                        VARCHAR ( 1 )
-- Not used:   alert15_threshold_CurrIO                                           BIGINT
-- Not used:   alert15_threshold_CurrIO_sample_count                              BIGINT
-- Not used:   alert15_actual_CurrIO_threshold_reached_sample_counter             BIGINT
-- New column: alert15_threshold_CurrRead_CurrWrite                               BIGINT
-- New column: alert15_threshold_CurrRead_CurrWrite_sample_count                  BIGINT
-- New column: alert15_actual_CurrRead_CurrWrite_threshold_reached_sample_counter BIGINT
-- New column: monitor_dedicated_task_enabled                                     VARCHAR ( 1 )
-- New column: monitor_dedicated_task_status                                      LONG VARCHAR
-- New column: monitor_connection_name_template                                   VARCHAR ( 100 )
-- New column: ping_only_sampling                                                 VARCHAR ( 1 )
-- New column: ping_enabled_for_successful_samples                                VARCHAR ( 1 )
-- New column: ping_enabled_for_lost_samples                                      VARCHAR ( 1 )
-- New column: ping_repeated_during_outages                                       VARCHAR ( 1 )
-- New column: ping_connection_name_template                                      VARCHAR ( 100 )
;


Top    Tables: A B C D E G M P R S U

DBA.all_clear

-- DBA.all_clear (table_id 750) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:19AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.all_clear (
--    all_clear_occurrence,  -- UNSIGNED BIGINT
--    sampling_id,           -- UNSIGNED INT
--    sample_set_number,     -- UNSIGNED BIGINT
--    alert_number,          -- INTEGER
--    alert_all_clear_at,    -- TIMESTAMP
--    alert_in_effect_at,    -- TIMESTAMP
--    alert_description,     -- LONG VARCHAR
--    email_status )         -- LONG VARCHAR

create VIEW all_clear AS SELECT * FROM rroad_all_clear
;


Top    Tables: A B C D E G M P R S U

DBA.applied_patch

-- DBA.applied_patch (table_id 739) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:19AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.applied_patch (
--    file_name,                -- VARCHAR ( 200 )
--    applied_to_build_number,  -- INTEGER
--    inserted_at,              -- TIMESTAMP
--    updated_at,               -- TIMESTAMP
--    status )                  -- LONG VARCHAR

create VIEW applied_patch AS SELECT * FROM rroad_applied_patch
;


Top    Tables: A B C D E G M P R S U

DBA.autodrop_candidate

-- DBA.autodrop_candidate (table_id 741) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:19AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.autodrop_candidate (
--    sampling_id,                                                                  -- UNSIGNED INT
--    connection_number,                                                            -- BIGINT
--    LoginTime,                                                                    -- LONG VARCHAR
--    autodrop1_actual_blocking_connections_threshold_reached_sample_counter,       -- BIGINT
--    autodrop2_actual_blocked_sample_counter,                                      -- BIGINT
--    autodrop4_actual_max_temporary_space_usage_threshold_reached_sample_counter,  -- BIGINT
--    autodrop5_actual_cpu_percent_threshold_reached_sample_counter,                -- BIGINT
--    autodrop6_actual_locks_threshold_reached_sample_counter )                     -- BIGINT

create VIEW autodrop_candidate AS SELECT * FROM rroad_autodrop_candidate
;


Top    Tables: A B C D E G M P R S U

DBA.autodropped_connection

-- DBA.autodropped_connection (table_id 756) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:19AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.autodropped_connection (
--    autodrop_occurrence,                   -- UNSIGNED BIGINT
--    sampling_id,                           -- UNSIGNED INT
--    autodrop_issued_sample_set_number,     -- UNSIGNED BIGINT
--    autodrop_processed_sample_set_number,  -- UNSIGNED BIGINT
--    connection_number,                     -- BIGINT
--    Name,                                  -- VARCHAR ( 128 )
--    NodeAddress,                           -- LONG VARCHAR
--    OSUser,                                -- LONG VARCHAR
--    Userid,                                -- VARCHAR ( 128 )
--    autodrop_issued_at,                    -- TIMESTAMP
--    autodrop_processed_at,                 -- TIMESTAMP
--    autodrop_reason,                       -- LONG VARCHAR
--    email_status )                         -- LONG VARCHAR

create VIEW autodropped_connection AS SELECT * FROM rroad_autodropped_connection
----------------------------------------------------------------------------------------------------- 
-- autodropped_connection -- Foxhound Version 4 Changes...
----------------------------------------------------------------------------------------------------- 
-- Changed column: autodrop_occurrence from BIGINT to UNSIGNED BIGINT
;


Top    Tables: A B C D E G M P R S U

DBA.build_number

-- DBA.build_number (table_id 758) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:19AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.build_number (
--    artificial_id,         -- INTEGER
--    required_asa_version,  -- VARCHAR ( 100 )
--    version_prefix,        -- VARCHAR ( 100 )
--    build_fork,            -- VARCHAR ( 1 )
--    build_number,          -- INTEGER
--    build_date )           -- TIMESTAMP

create VIEW build_number AS SELECT * FROM rroad_build_number
;


Top    Tables: A B C D E G M P R S U

DBA.connection_string

-- DBA.connection_string (table_id 760) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:19AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.connection_string (
--    connection_string_name,  -- VARCHAR ( 128 )
--    connection_string )      -- LONG VARCHAR

create VIEW connection_string AS SELECT * FROM rroad_connection_string
;


Top    Tables: A B C D E G M P R S U

DBA.data_upgrade_history

-- DBA.data_upgrade_history (table_id 762) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:19AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.data_upgrade_history (
--    artificial_id,              -- INTEGER
--    data_upgraded_at,           -- TIMESTAMP
--    from_required_asa_version,  -- VARCHAR ( 100 )
--    from_version_prefix,        -- VARCHAR ( 100 )
--    from_build_fork,            -- VARCHAR ( 1 )
--    from_build_number,          -- INTEGER
--    from_build_date )           -- TIMESTAMP

create VIEW data_upgrade_history AS SELECT * FROM rroad_data_upgrade_history
;


Top    Tables: A B C D E G M P R S U

DBA.email_failure

-- DBA.email_failure (table_id 766) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:20AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.email_failure (
--    email_failure_occurrence,   -- UNSIGNED BIGINT
--    sampling_id,                -- UNSIGNED INT
--    sample_set_number,          -- UNSIGNED BIGINT
--    email_failure_at,           -- TIMESTAMP
--    email_failure_description ) -- LONG VARCHAR

create VIEW email_failure AS SELECT * FROM rroad_email_failure
;


Top    Tables: A B C D E G M P R S U

DBA.exception_diagnostic

-- DBA.exception_diagnostic (table_id 768) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:20AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.exception_diagnostic (
--    exception_id,          -- BIGINT
--    exception_diagnostic ) -- LONG VARCHAR

create VIEW exception_diagnostic AS SELECT * FROM rroad_exception
;


Top    Tables: A B C D E G M P R S U

DBA.exception_dump

-- DBA.exception_dump (table_id 770) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:20AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.exception_dump (
--    exception_id,      -- BIGINT
--    dump_id,           -- BIGINT
--    dump_inserted_at,  -- TIMESTAMP
--    dump )             -- LONG VARCHAR

create VIEW exception_dump AS SELECT * FROM rroad_exception_dump
;


Top    Tables: A B C D E G M P R S U

DBA.expiry_date

-- DBA.expiry_date (table_id 772) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:20AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.expiry_date (
--    one_row_only,                 -- INTEGER
--    key_type,                     -- VARCHAR ( 1 )
--    edition_name,                 -- VARCHAR ( 100 )
--    expiry_date,                  -- DATE
--    expires_after_how_many_days ) -- BIGINT

create VIEW expiry_date AS SELECT * FROM rroad_expiry_date
;


Top    Tables: A B C D E G M P R S U

DBA.global_options

-- DBA.global_options (table_id 774) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:20AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.global_options (
--    artificial_id,                                   -- INTEGER
--    help_frameset_cols,                              -- VARCHAR ( 100 )
--    export_diagnostics_filespec,                     -- LONG VARCHAR
--    connection_timeout_msec,                         -- BIGINT
--    timeout_retry_msec,                              -- BIGINT
--    enable_automatic_purge_schedule,                 -- VARCHAR ( 1 )
--    sample_purge_enabled,                            -- VARCHAR ( 1 )
--    sample_purge_after_days,                         -- INTEGER
--    uninteresting_connections_purge_enabled,         -- VARCHAR ( 1 )
--    uninteresting_connections_purge_after_days,      -- INTEGER
--    purge_speed,                                     -- VARCHAR ( 100 )
--    export_samples_folder,                           -- LONG VARCHAR
--    smtp_sender,                                     -- LONG VARCHAR
--    smtp_server,                                     -- LONG VARCHAR
--    smtp_port,                                       -- INTEGER
--    smtp_timeout,                                    -- INTEGER
--    smtp_auth_username,                              -- LONG VARCHAR
--    mapi_mail_username,                              -- LONG VARCHAR
--    email_type,                                      -- VARCHAR ( 10 )
--    connection_sampling_connection_count_threshold,  -- BIGINT
--    connection_strings_filespec,                     -- LONG VARCHAR
--    enable_emails,                                   -- VARCHAR ( 1 )
--    enable_autodrop,                                 -- VARCHAR ( 1 )
--    smtp_certificate_filespec,                       -- LONG VARCHAR
--    monitor_sample_set_number_span,                  -- UNSIGNED BIGINT
--    history_sample_set_number_span,                  -- UNSIGNED BIGINT
--    connection_history_number_span,                  -- UNSIGNED BIGINT
--    alerts_sample_set_number_span,                   -- UNSIGNED BIGINT
--    history_frameset_rows,                           -- VARCHAR ( 100 )
--    enable_schedules,                                -- VARCHAR ( 1 )
--    show_connection_details )                        -- VARCHAR ( 1 )

create VIEW global_options AS 
SELECT 
   artificial_id,
   help_frameset_cols,
   export_diagnostics_filespec,
   connection_timeout_msec,
   timeout_retry_msec,
   enable_automatic_purge_schedule,
--   sample_purge_interval,                    -- 2014 04 01 BC 4330a: Changed: Column rroad_global_options.sample_purge_interval no longer used.
--   uninteresting_connections_purge_interval, -- 2014 04 01 BC 4330a: Changed: Column rroad_global_options.uninteresting_connections_purge_interval no longer used.
   sample_purge_enabled,                       -- 2014 04 01 BC 4330a: Added:   Column rroad_global_options.sample_purge_enabled                         VARCHAR ( 1 ) NOT NULL ...
   sample_purge_after_days,                    -- 2014 04 01 BC 4330a: Added:   Column rroad_global_options.sample_purge_after_days                      INTEGER NOT NULL ...
   uninteresting_connections_purge_enabled,    -- 2014 04 01 BC 4330a: Added:   Column rroad_global_options.uninteresting_connections_purge_enabled      VARCHAR ( 1 ) NOT NULL ...
   uninteresting_connections_purge_after_days, -- 2014 04 01 BC 4330a: Added:   Column rroad_global_options.uninteresting_connections_purge_after_days   INTEGER NOT NULL ...
   purge_speed,
   export_samples_folder,
   smtp_sender,
   smtp_server,
   smtp_port,
   smtp_timeout,
   smtp_auth_username,
   mapi_mail_username,
   email_type,
   connection_sampling_connection_count_threshold, 
   connection_strings_filespec,
   enable_emails,
   enable_autodrop,
   smtp_certificate_filespec,
   monitor_sample_set_number_span,
   history_sample_set_number_span,
   connection_history_number_span,
   alerts_sample_set_number_span,
   history_frameset_rows,
--   history_connection_frameset_rows, -- 2013 12 28 BC 4279a: Changed: Column rroad_global_options.history_connection_frameset_rows no longer used.
   enable_schedules,
   show_connection_details             -- 2014 12 31 BC 4534a: Added:   rroad_global_options.show_connection_details          VARCHAR ( 1 ) NOT NULL ...
  FROM rroad_global_options
----------------------------------------------------------------------------------------------------- 
-- global_options -- Foxhound Version 4 Changes...
----------------------------------------------------------------------------------------------------- 
-- New column: show_connection_details VARCHAR ( 1 )
;


Top    Tables: A B C D E G M P R S U

DBA.monitor_sampler_control

-- DBA.monitor_sampler_control (table_id 780) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:20AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.monitor_sampler_control (
--    one_row_only,                         -- INTEGER
--    previous_foxhound_was_running_until,  -- TIMESTAMP
--    foxhound_was_running_until )          -- TIMESTAMP

create VIEW monitor_sampler_control AS SELECT * FROM rroad_monitor_sampler_control
;


Top    Tables: A B C D E G M P R S U

DBA.peaks

-- DBA.peaks (table_id 782) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:20AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.peaks (
--    sampling_id,                                            -- UNSIGNED INT
--    peaks_calculated_to_sample_set_number,                  -- UNSIGNED BIGINT
--    peaks_calculated_after,                                 -- TIMESTAMP
--    peaks_calculated_after_sample_set_number,               -- UNSIGNED BIGINT
--    earliest_preserved_sample_set_number,                   -- UNSIGNED BIGINT
--    peak_sample_elapsed_msec,                               -- BIGINT
--    peak_canarian_query_elapsed_msec,                       -- BIGINT
--    peak_ActiveReq,                                         -- BIGINT
--    peak_CheckpointUrgency,                                 -- BIGINT
--    peak_interval_Chkpt,                                    -- BIGINT
--    peak_ConnCount,                                         -- BIGINT
--    peak_CurrIO,                                            -- BIGINT
--    peak_CurrRead,                                          -- BIGINT
--    peak_CurrWrite,                                         -- BIGINT
--    peak_DBFileFragments,                                   -- BIGINT
--    peak_LockCount,                                         -- BIGINT
--    peak_MultiProgrammingLevel,                             -- BIGINT
--    peak_RecoveryUrgency,                                   -- BIGINT
--    peak_UnschReq,                                          -- BIGINT
--    peak_executing_connection_count,                        -- BIGINT
--    peak_idle_connection_count,                             -- BIGINT
--    peak_waiting_connection_count,                          -- BIGINT
--    peak_total_blocked_connection_count,                    -- BIGINT
--    peak_interval_waiting_time,                             -- DECIMAL ( 30, 6 )
--    peak_total_temporary_file_bytes,                        -- BIGINT
--    peak_rate_Bytes,                                        -- DECIMAL ( 30, 6 )
--    peak_rate_Disk,                                         -- DECIMAL ( 30, 6 )
--    peak_rate_BytesReceived,                                -- DECIMAL ( 30, 6 )
--    peak_rate_BytesSent,                                    -- DECIMAL ( 30, 6 )
--    peak_rate_CachePanics,                                  -- DECIMAL ( 30, 6 )
--    peak_ratio_ReadIndInt,                                  -- DECIMAL ( 30, 6 )
--    peak_ratio_ReadIndLeaf,                                 -- DECIMAL ( 30, 6 )
--    peak_ratio_ReadTable,                                   -- DECIMAL ( 30, 6 )
--    peak_CacheSatisfaction,                                 -- DECIMAL ( 30, 6 )
--    peak_rate_DiskRead,                                     -- DECIMAL ( 30, 6 )
--    peak_rate_DiskWrite,                                    -- DECIMAL ( 30, 6 )
--    peak_rate_FullCompare,                                  -- DECIMAL ( 30, 6 )
--    peak_rate_IndAdd,                                       -- DECIMAL ( 30, 6 )
--    peak_rate_IndLookup,                                    -- DECIMAL ( 30, 6 )
--    peak_IndSatisfaction,                                   -- DECIMAL ( 30, 6 )
--    peak_rate_LogWrite,                                     -- DECIMAL ( 30, 6 )
--    peak_cpu_percentage_string,                             -- VARCHAR ( 10 )
--    peak_cpu_percentage_number,                             -- DECIMAL ( 30, 6 )
--    peak_rate_QueryLowMemoryStrategy,                       -- DECIMAL ( 30, 6 )
--    peak_rate_Req,                                          -- DECIMAL ( 30, 6 )
--    peak_rate_Commit,                                       -- DECIMAL ( 30, 6 )
--    peak_rate_Rlbk,                                         -- DECIMAL ( 30, 6 )
--    peak_CPU_count,                                         -- INTEGER
--    peak_total_child_connection_count,                      -- BIGINT
--    peak_system_file_bytes,                                 -- BIGINT
--    peak_system_file_used_percent,                          -- DECIMAL ( 30, 1 )
--    peak_total_rollback_log_bytes,                          -- BIGINT
--    peak_total_uncommitted_operations,                      -- BIGINT
--    peak_successful_ping_elapsed_msec,                      -- BIGINT
--    peak_sample_elapsed_msec_sample_set_number,             -- UNSIGNED BIGINT
--    peak_canarian_query_elapsed_msec_sample_set_number,     -- UNSIGNED BIGINT
--    peak_ActiveReq_sample_set_number,                       -- UNSIGNED BIGINT
--    peak_CheckpointUrgency_sample_set_number,               -- UNSIGNED BIGINT
--    peak_interval_Chkpt_sample_set_number,                  -- UNSIGNED BIGINT
--    peak_ConnCount_sample_set_number,                       -- UNSIGNED BIGINT
--    peak_CurrIO_sample_set_number,                          -- UNSIGNED BIGINT
--    peak_CurrRead_sample_set_number,                        -- UNSIGNED BIGINT
--    peak_CurrWrite_sample_set_number,                       -- UNSIGNED BIGINT
--    peak_DBFileFragments_sample_set_number,                 -- UNSIGNED BIGINT
--    peak_LockCount_sample_set_number,                       -- UNSIGNED BIGINT
--    peak_MultiProgrammingLevel_sample_set_number,           -- UNSIGNED BIGINT
--    peak_RecoveryUrgency_sample_set_number,                 -- UNSIGNED BIGINT
--    peak_UnschReq_sample_set_number,                        -- UNSIGNED BIGINT
--    peak_executing_connection_count_sample_set_number,      -- UNSIGNED BIGINT
--    peak_idle_connection_count_sample_set_number,           -- UNSIGNED BIGINT
--    peak_waiting_connection_count_sample_set_number,        -- UNSIGNED BIGINT
--    peak_total_blocked_connection_count_sample_set_number,  -- UNSIGNED BIGINT
--    peak_interval_waiting_time_sample_set_number,           -- UNSIGNED BIGINT
--    peak_total_temporary_file_bytes_sample_set_number,      -- UNSIGNED BIGINT
--    peak_rate_Bytes_sample_set_number,                      -- UNSIGNED BIGINT
--    peak_rate_Disk_sample_set_number,                       -- UNSIGNED BIGINT
--    peak_rate_BytesReceived_sample_set_number,              -- UNSIGNED BIGINT
--    peak_rate_BytesSent_sample_set_number,                  -- UNSIGNED BIGINT
--    peak_rate_CachePanics_sample_set_number,                -- UNSIGNED BIGINT
--    peak_ratio_ReadIndInt_sample_set_number,                -- UNSIGNED BIGINT
--    peak_ratio_ReadIndLeaf_sample_set_number,               -- UNSIGNED BIGINT
--    peak_ratio_ReadTable_sample_set_number,                 -- UNSIGNED BIGINT
--    peak_CacheSatisfaction_sample_set_number,               -- UNSIGNED BIGINT
--    peak_rate_DiskRead_sample_set_number,                   -- UNSIGNED BIGINT
--    peak_rate_DiskWrite_sample_set_number,                  -- UNSIGNED BIGINT
--    peak_rate_FullCompare_sample_set_number,                -- UNSIGNED BIGINT
--    peak_rate_IndAdd_sample_set_number,                     -- UNSIGNED BIGINT
--    peak_rate_IndLookup_sample_set_number,                  -- UNSIGNED BIGINT
--    peak_IndSatisfaction_sample_set_number,                 -- UNSIGNED BIGINT
--    peak_rate_LogWrite_sample_set_number,                   -- UNSIGNED BIGINT
--    peak_cpu_percentage_sample_set_number,                  -- UNSIGNED BIGINT
--    peak_rate_QueryLowMemoryStrategy_sample_set_number,     -- UNSIGNED BIGINT
--    peak_rate_Req_sample_set_number,                        -- UNSIGNED BIGINT
--    peak_rate_Commit_sample_set_number,                     -- UNSIGNED BIGINT
--    peak_rate_Rlbk_sample_set_number,                       -- UNSIGNED BIGINT
--    peak_CPU_count_sample_set_number,                       -- UNSIGNED BIGINT
--    peak_total_child_connection_count_sample_set_number,    -- UNSIGNED BIGINT
--    peak_system_file_bytes_sample_set_number,               -- UNSIGNED BIGINT
--    peak_system_file_used_percent_sample_set_number,        -- UNSIGNED BIGINT
--    peak_total_rollback_log_bytes_sample_set_number,        -- UNSIGNED BIGINT
--    peak_total_uncommitted_operations_sample_set_number,    -- UNSIGNED BIGINT
--    peak_successful_ping_elapsed_msec_sample_set_number )   -- UNSIGNED BIGINT

create VIEW peaks AS SELECT * FROM rroad_peaks
----------------------------------------------------------------------------------------------------- 
-- peaks -- Foxhound Version 4 Changes...
----------------------------------------------------------------------------------------------------- 
-- New column: peak_CurrRead                                       BIGINT
-- New column: peak_CurrWrite                                      BIGINT
-- New column: peak_ratio_ReadIndInt                               DECIMAL ( 30, 6 )
-- New column: peak_ratio_ReadIndLeaf                              DECIMAL ( 30, 6 )
-- New column: peak_ratio_ReadTable                                DECIMAL ( 30, 6 )
-- New column: peak_successful_ping_elapsed_msec                   BIGINT
-- New column: peak_CurrRead_sample_set_number                     UNSIGNED BIGINT
-- New column: peak_CurrWrite_sample_set_number                    UNSIGNED BIGINT
-- New column: peak_ratio_ReadIndInt_sample_set_number             UNSIGNED BIGINT
-- New column: peak_ratio_ReadIndLeaf_sample_set_number            UNSIGNED BIGINT
-- New column: peak_ratio_ReadTable_sample_set_number              UNSIGNED BIGINT
-- New column: peak_successful_ping_elapsed_msec_sample_set_number UNSIGNED BIGINT
;


Top    Tables: A B C D E G M P R S U

DBA.ping_log

-- DBA.ping_log (table_id 764) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:20AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.ping_log (
--    ping_id,                       -- UNSIGNED BIGINT
--    ping_log_inserted_at,          -- TIMESTAMP
--    sampling_id,                   -- UNSIGNED INT
--    started_at_sample_set_number,  -- UNSIGNED BIGINT
--    connection_string,             -- VARCHAR ( 1000 )
--    ping_elapsed_msec,             -- BIGINT
--    connection_number,             -- INTEGER
--    return_code,                   -- INTEGER
--    diagnostic_code,               -- INTEGER
--    diagnostic_string )            -- VARCHAR ( 255 )

create VIEW ping_log AS SELECT * FROM rroad_ping_log
----------------------------------------------------------------------------------------------------- 
-- ping_log -- Foxhound Version 4 Changes...
----------------------------------------------------------------------------------------------------- 
-- New view: ping_log
;


Top    Tables: A B C D E G M P R S U

DBA.purge_run

-- DBA.purge_run (table_id 784) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:20AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.purge_run (
--    run_number,                                  -- BIGINT
--    diagnostic_location,                         -- VARCHAR ( 100 )
--    connection_number,                           -- INTEGER
--    build_number,                                -- INTEGER
--    progress,                                    -- VARCHAR ( 100 )
--    started_at,                                  -- TIMESTAMP
--    is_complete,                                 -- VARCHAR ( 1 )
--    completed_at,                                -- TIMESTAMP
--    must_trigger_next_purge,                     -- VARCHAR ( 1 )
--    sample_purge_enabled,                        -- VARCHAR ( 1 )
--    sample_purge_after_days,                     -- INTEGER
--    uninteresting_connections_purge_enabled,     -- VARCHAR ( 1 )
--    uninteresting_connections_purge_after_days,  -- INTEGER
--    purge_speed,                                 -- VARCHAR ( 100 )
--    waitfor_delay,                               -- TIME
--    commit_after_operation_count,                -- INTEGER
--    exception_delete_count,                      -- BIGINT
--    orphan_sample_set_delete_count,              -- BIGINT
--    old_sample_set_delete_count,                 -- BIGINT
--    uninteresting_connections_delete_count,      -- BIGINT
--    checkpoint_1_msec,                           -- BIGINT
--    exception_delete_msec,                       -- BIGINT
--    orphan_sample_set_delete_msec,               -- BIGINT
--    old_sample_set_delete_msec,                  -- BIGINT
--    uninteresting_connections_delete_msec,       -- BIGINT
--    checkpoint_2_msec,                           -- BIGINT
--    run_msec,                                    -- BIGINT
--    foxhound_page_size,                          -- BIGINT
--    foxhound_file_size,                          -- BIGINT
--    foxhound_free_pages,                         -- BIGINT
--    foxhound_fragments,                          -- BIGINT
--    foxhound_file,                               -- LONG VARCHAR
--    before_row_count_exception,                  -- BIGINT
--    before_row_count_group_1_property_pivot,     -- BIGINT
--    before_row_count_group_2_property_pivot,     -- BIGINT
--    before_row_count_sample_set,                 -- BIGINT
--    after_row_count_exception,                   -- BIGINT
--    after_row_count_group_1_property_pivot,      -- BIGINT
--    after_row_count_group_2_property_pivot,      -- BIGINT
--    after_row_count_sample_set,                  -- BIGINT
--    before_total_row_count,                      -- DECIMAL ( 30, 6 )
--    after_total_row_count,                       -- DECIMAL ( 30, 6 )
--    percent_total_row_count_change )             -- DECIMAL ( 30, 6 )

create VIEW purge_run AS 
SELECT 
   run_number,
   diagnostic_location,
   connection_number,
   build_number,
   progress,
   started_at,
   is_complete,
   completed_at,
   must_trigger_next_purge,
   sample_purge_enabled,
   sample_purge_after_days,
   uninteresting_connections_purge_enabled,
   uninteresting_connections_purge_after_days,
   purge_speed,
   waitfor_delay,
   commit_after_operation_count,
   exception_delete_count,
   orphan_sample_set_delete_count,
   old_sample_set_delete_count,
   uninteresting_connections_delete_count,
   checkpoint_1_msec,
   exception_delete_msec,
   orphan_sample_set_delete_msec,
   old_sample_set_delete_msec,
   uninteresting_connections_delete_msec,
   checkpoint_2_msec,
   run_msec,
   foxhound_page_size,
   foxhound_file_size,
   foxhound_free_pages,
   foxhound_fragments,
   foxhound_file,
   before_row_count_exception,
   before_row_count_group_1_property_pivot,
   before_row_count_group_2_property_pivot,
   before_row_count_sample_set,
   after_row_count_exception,
   after_row_count_group_1_property_pivot,
   after_row_count_group_2_property_pivot,
   after_row_count_sample_set,
   before_total_row_count,
   after_total_row_count,      
   percent_total_row_count_change
FROM rroad_purge_run
;


Top    Tables: A B C D E G M P R S U

DBA.rroad_alert

-- DBA.rroad_alert (table_id 747) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:20AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_alert ( -- empty
   alert_occurrence     /* PK        */ UNSIGNED BIGINT NOT NULL,
   sampling_id                          UNSIGNED INT NOT NULL,
   sample_set_number                    UNSIGNED BIGINT NOT NULL,
   alert_number                         INTEGER NOT NULL,
   alert_in_effect_at                   TIMESTAMP NOT NULL,
   alert_description                    LONG VARCHAR NOT NULL,
   email_status                         LONG VARCHAR NOT NULL DEFAULT '',
   CONSTRAINT ASA92 PRIMARY KEY (
      alert_occurrence )
 );

-- Parents of DBA.rroad_alert

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_alert_cancelled

-- DBA.rroad_alert_cancelled (table_id 751) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:20AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_alert_cancelled ( -- empty
   alert_cancelled_occurrence   /* PK        */ UNSIGNED BIGINT NOT NULL,
   sampling_id                                  UNSIGNED INT NOT NULL,
   sample_set_number                            UNSIGNED BIGINT NOT NULL,
   alert_number                                 INTEGER NOT NULL,
   alert_all_clear_at                           TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert_in_effect_at                           TIMESTAMP NOT NULL,
   alert_description                            LONG VARCHAR NOT NULL,
   email_status                                 LONG VARCHAR NOT NULL DEFAULT '',
   CONSTRAINT ASA94 PRIMARY KEY (
      alert_cancelled_occurrence )
 );

-- Parents of DBA.rroad_alert_cancelled

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_alert_union

-- DBA.rroad_alert_union (table_id 799) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:20AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.rroad_alert_union (
--    record_type,                  -- VARCHAR ( 20 )
--    sampling_id,                  -- UNSIGNED INT
--    selected_tab,                 -- VARCHAR ( 1 )
--    selected_name,                -- VARCHAR ( 128 )
--    sample_set_number,            -- NUMERIC ( 20 )
--    alert_number,                 -- INTEGER
--    recorded_at,                  -- TIMESTAMP
--    alert_description,            -- LONG VARCHAR
--    email_status,                 -- LONG VARCHAR
--    alert_is_clear_or_cancelled ) -- VARCHAR ( 1 )

create VIEW rroad_alert_union AS
SELECT CAST ( 'Alert' AS VARCHAR ( 20 ) )       AS record_type,
       rroad_alert.sampling_id                  AS sampling_id,
       rroad_sampling_options.selected_tab      AS selected_tab,
       rroad_sampling_options.selected_name     AS selected_name,
       rroad_alert.sample_set_number            AS sample_set_number,
       rroad_alert.alert_number                 AS alert_number,
       rroad_alert.alert_in_effect_at           AS recorded_at,
       rroad_alert.alert_description            AS alert_description,
       rroad_alert.email_status                 AS email_status,
       CAST ( IF EXISTS ( SELECT *
                            FROM rroad_all_clear
                           WHERE rroad_all_clear.sampling_id        = rroad_alert.sampling_id
                             AND rroad_all_clear.alert_number       = rroad_alert.alert_number
                             AND rroad_all_clear.alert_in_effect_at = rroad_alert.alert_in_effect_at ) -- FIXED
              OR EXISTS ( SELECT *
                            FROM rroad_alert_cancelled
                           WHERE rroad_alert_cancelled.sampling_id        =  rroad_alert.sampling_id
                             AND rroad_alert_cancelled.alert_number       =  rroad_alert.alert_number
                             AND rroad_alert_cancelled.alert_in_effect_at = rroad_alert.alert_in_effect_at ) -- FIXED
                 THEN 'Y'
                 ELSE 'N'
              ENDIF AS VARCHAR ( 1 ) )          AS alert_is_clear_or_cancelled
  FROM rroad_alert
          INNER JOIN rroad_sampling_options
             ON rroad_sampling_options.sampling_id = rroad_alert.sampling_id

 UNION ALL

SELECT CAST ( 'All Clear' AS VARCHAR ( 20 ) )   AS record_type,
       rroad_all_clear.sampling_id              AS sampling_id,
       rroad_sampling_options.selected_tab      AS selected_tab,
       rroad_sampling_options.selected_name     AS selected_name,
       rroad_all_clear.sample_set_number        AS sample_set_number,
       rroad_all_clear.alert_number             AS alert_number,
       rroad_all_clear.alert_all_clear_at       AS recorded_at,
       rroad_all_clear.alert_description        AS alert_description,
       rroad_all_clear.email_status             AS email_status,
       'Y'                                      AS alert_is_clear_or_cancelled -- FIXED
  FROM rroad_all_clear
          INNER JOIN rroad_sampling_options
             ON rroad_sampling_options.sampling_id = rroad_all_clear.sampling_id

 UNION ALL

SELECT CAST ( 'Cancelled' AS VARCHAR ( 20 ) )   AS record_type,
       rroad_alert_cancelled.sampling_id        AS sampling_id,
       rroad_sampling_options.selected_tab      AS selected_tab,
       rroad_sampling_options.selected_name     AS selected_name,
       rroad_alert_cancelled.sample_set_number  AS sample_set_number,
       rroad_alert_cancelled.alert_number       AS alert_number,
       rroad_alert_cancelled.alert_all_clear_at AS recorded_at,
       rroad_alert_cancelled.alert_description  AS alert_description,
       rroad_alert_cancelled.email_status       AS email_status,
       'Y'                                      AS alert_is_clear_or_cancelled -- FIXED
  FROM rroad_alert_cancelled
          INNER JOIN rroad_sampling_options
             ON rroad_sampling_options.sampling_id = rroad_alert_cancelled.sampling_id 

 UNION ALL

SELECT CAST ( 'Placeholder' AS VARCHAR ( 20 ) ) AS record_type,
       rroad_sampling_options.sampling_id       AS sampling_id,
       rroad_sampling_options.selected_tab      AS selected_tab,
       rroad_sampling_options.selected_name     AS selected_name,
       0                                        AS sample_set_number,
       0                                        AS alert_number,
       '1900-01-01'                             AS recorded_at,
       ''                                       AS alert_description,
       ''                                       AS email_status,
       CAST ( '?' AS VARCHAR ( 1 ) )            AS alert_is_clear_or_cancelled
  FROM rroad_sampling_options
 WHERE NOT EXISTS ( SELECT * 
                      FROM rroad_alert 
                     WHERE rroad_alert.sampling_id = rroad_sampling_options.sampling_id )
   AND NOT EXISTS ( SELECT * 
                      FROM rroad_all_clear 
                     WHERE rroad_all_clear.sampling_id = rroad_sampling_options.sampling_id )
   AND NOT EXISTS ( SELECT * 
                      FROM rroad_alert_cancelled 
                     WHERE rroad_alert_cancelled.sampling_id = rroad_sampling_options.sampling_id )
;


Top    Tables: A B C D E G M P R S U

DBA.rroad_alerts_criteria

-- DBA.rroad_alerts_criteria (table_id 753) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:21AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_alerts_criteria ( -- empty
   criteria_set_type                                                             /* PK        */ VARCHAR ( 100 ) NOT NULL 
                                                                                                    CONSTRAINT ASA95 CHECK ( @criteria_set_type in( 
'Factory Settings',
'Saved Defaults',
'Target Specific' )  ),
   sampling_id                                                                   /* PK        */ UNSIGNED INT NOT NULL,
   send_alert_emails                                                                             VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA96 CHECK ( @column in( 'Y','N' )  ),
   mail_recipient                                                                                LONG VARCHAR NOT NULL,
   use_html_in_emails                                                                            VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA97 CHECK ( @column in( 'Y','N' )  ),
   email_url_host_port                                                                           LONG VARCHAR NOT NULL,
   display_alerts                                                                                VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA98 CHECK ( @column in( 'Y','N' )  ),
   autodrop_mail_recipients                                                                      LONG VARCHAR NOT NULL DEFAULT '',
   autodrop_mail_recipients_same_as_for_alerts                                                   VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                                                    CONSTRAINT ASA99 CHECK ( @column in( 'Y','N' )  ),
   previous_sample_set_number_processed                                                          UNSIGNED BIGINT NOT NULL,
   previous_gathered_sample_finished_at                                                          TIMESTAMP NOT NULL,
   current_sample_finished_at                                                                    TIMESTAMP NOT NULL,
   alert1_enabled                                                                                VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA100 CHECK ( @column in( 'Y','N' )  ),
   alert1_is_in_effect                                                                           VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA101 CHECK ( @column in( 'Y','N' )  ),
   alert1_in_effect_at                                                                           TIMESTAMP NOT NULL,
   alert1_all_clear_at                                                                           TIMESTAMP NOT NULL,
   alert1_threshold_lost_sample_accumulated_msec                                                 BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA102 CHECK ( @column >= 10000 ),
   alert1_actual_lost_sample_accumulated_msec                                                    BIGINT NOT NULL,
   alert2_enabled                                                                                VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA103 CHECK ( @column in( 'Y','N' )  ),
   alert2_is_in_effect                                                                           VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA104 CHECK ( @column in( 'Y','N' )  ),
   alert2_in_effect_at                                                                           TIMESTAMP NOT NULL,
   alert2_all_clear_at                                                                           TIMESTAMP NOT NULL,
   alert2_threshold_canarian_msec                                                                BIGINT NOT NULL,
   alert2_threshold_canarian_msec_sample_count                                                   BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA105 CHECK ( @column >= 1 ),
   alert2_actual_canarian_msec_threshold_reached_sample_counter                                  BIGINT NOT NULL,
   alert3_enabled                                                                                VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA106 CHECK ( @column in( 'Y','N' )  ),
   alert3_is_in_effect                                                                           VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA107 CHECK ( @column in( 'Y','N' )  ),
   alert3_in_effect_at                                                                           TIMESTAMP NOT NULL,
   alert3_all_clear_at                                                                           TIMESTAMP NOT NULL,
   alert3_threshold_sample_msec                                                                  BIGINT NOT NULL,
   alert3_threshold_sample_msec_sample_count                                                     BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA108 CHECK ( @column >= 1 ),
   alert3_actual_sample_msec_threshold_reached_sample_counter                                    BIGINT NOT NULL,
   alert4_enabled                                                                                VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA109 CHECK ( @column in( 'Y','N' )  ),
   alert4_is_in_effect                                                                           VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA110 CHECK ( @column in( 'Y','N' )  ),
   alert4_in_effect_at                                                                           TIMESTAMP NOT NULL,
   alert4_all_clear_at                                                                           TIMESTAMP NOT NULL,
   alert4_threshold_cpu_percent                                                                  BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA111 CHECK ( @column between 1 and 100 ),
   alert4_threshold_cpu_percent_sample_count                                                     BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA112 CHECK ( @column >= 1 ),
   alert4_actual_cpu_percent_threshold_reached_sample_counter                                    BIGINT NOT NULL,
   alert5_enabled                                                                                VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA113 CHECK ( @column in( 'Y','N' )  ),
   alert5_is_in_effect                                                                           VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA114 CHECK ( @column in( 'Y','N' )  ),
   alert5_in_effect_at                                                                           TIMESTAMP NOT NULL,
   alert5_all_clear_at                                                                           TIMESTAMP NOT NULL,
   alert5_threshold_system_free_bytes                                                            BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA115 CHECK ( @column >= 1024 ),
   alert5_actual_system_free_bytes                                                               BIGINT NOT NULL,
   alert6_enabled                                                                                VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA116 CHECK ( @column in( 'Y','N' )  ),
   alert6_is_in_effect                                                                           VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA117 CHECK ( @column in( 'Y','N' )  ),
   alert6_in_effect_at                                                                           TIMESTAMP NOT NULL,
   alert6_all_clear_at                                                                           TIMESTAMP NOT NULL,
   alert6_threshold_temp_file_free_bytes                                                         BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA118 CHECK ( @column >= 1024 ),
   alert6_actual_temp_file_free_bytes                                                            BIGINT NOT NULL,
   alert7_enabled                                                                                VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA119 CHECK ( @column in( 'Y','N' )  ),
   alert7_is_in_effect                                                                           VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA120 CHECK ( @column in( 'Y','N' )  ),
   alert7_in_effect_at                                                                           TIMESTAMP NOT NULL,
   alert7_all_clear_at                                                                           TIMESTAMP NOT NULL,
   alert7_threshold_log_free_bytes                                                               BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA121 CHECK ( @column >= 1024 ),
   alert7_actual_log_free_bytes                                                                  BIGINT NOT NULL,
   alert8_enabled                                                                                VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA122 CHECK ( @column in( 'Y','N' )  ),
   alert8_is_in_effect                                                                           VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA123 CHECK ( @column in( 'Y','N' )  ),
   alert8_in_effect_at                                                                           TIMESTAMP NOT NULL,
   alert8_all_clear_at                                                                           TIMESTAMP NOT NULL,
   alert8_threshold_min_other_free_bytes                                                         BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA124 CHECK ( @column >= 1024 ),
   alert8_actual_min_other_free_bytes                                                            BIGINT NOT NULL,
   alert9_enabled                                                                                VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA125 CHECK ( @column in( 'Y','N' )  ),
   alert9_is_in_effect                                                                           VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA126 CHECK ( @column in( 'Y','N' )  ),
   alert9_in_effect_at                                                                           TIMESTAMP NOT NULL,
   alert9_all_clear_at                                                                           TIMESTAMP NOT NULL,
   alert9_actual_ArbiterState                                                                    LONG VARCHAR NOT NULL,
   alert10_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA127 CHECK ( @column in( 'Y','N' )  ),
   alert10_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA128 CHECK ( @column in( 'Y','N' )  ),
   alert10_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert10_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert10_actual_PartnerState                                                                   LONG VARCHAR NOT NULL,
   alert11_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA129 CHECK ( @column in( 'Y','N' )  ),
   alert11_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA130 CHECK ( @column in( 'Y','N' )  ),
   alert11_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert11_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert11_actual_previous_ServerName                                                            LONG VARCHAR NOT NULL,
   alert11_actual_current_ServerName                                                             LONG VARCHAR NOT NULL,
   alert12_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA131 CHECK ( @column in( 'Y','N' )  ),
   alert12_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA132 CHECK ( @column in( 'Y','N' )  ),
   alert12_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert12_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert12_actual_previous_ReadOnly                                                              LONG VARCHAR NOT NULL,
   alert12_actual_current_ReadOnly                                                               LONG VARCHAR NOT NULL,
   alert13_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA133 CHECK ( @column in( 'Y','N' )  ),
   alert13_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA134 CHECK ( @column in( 'Y','N' )  ),
   alert13_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert13_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert13_threshold_DBFileFragments                                                             BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA135 CHECK ( @column >= 2 ),
   alert13_actual_DBFileFragments                                                                BIGINT NOT NULL,
   alert14_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA136 CHECK ( @column in( 'Y','N' )  ),
   alert14_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA137 CHECK ( @column in( 'Y','N' )  ),
   alert14_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert14_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert14_threshold_UnschReq                                                                    BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA138 CHECK ( @column >= 1 ),
   alert14_threshold_UnschReq_sample_count                                                       BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA139 CHECK ( @column >= 1 ),
   alert14_actual_UnschReq_threshold_reached_sample_counter                                      BIGINT NOT NULL,
   alert15_enabled                                                                               VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA140 CHECK ( @column in( 'Y','N' )  ),
   alert15_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA141 CHECK ( @column in( 'Y','N' )  ),
   alert15_in_effect_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert15_all_clear_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert15_threshold_CurrIO                                                                      BIGINT NOT NULL DEFAULT 1,
   alert15_threshold_CurrIO_sample_count                                                         BIGINT NOT NULL DEFAULT 1,
   alert15_actual_CurrIO_threshold_reached_sample_counter                                        BIGINT NOT NULL DEFAULT 0,
   alert15_threshold_CurrRead_CurrWrite                                                          BIGINT NOT NULL DEFAULT 2 
                                                                                                    CONSTRAINT ASA142 CHECK ( @column >= 1 ),
   alert15_threshold_CurrRead_CurrWrite_sample_count                                             BIGINT NOT NULL DEFAULT 10 
                                                                                                    CONSTRAINT ASA143 CHECK ( @column >= 1 ),
   alert15_actual_CurrRead_CurrWrite_threshold_reached_sample_counter                            BIGINT NOT NULL DEFAULT 0,
   alert16_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA144 CHECK ( @column in( 'Y','N' )  ),
   alert16_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA145 CHECK ( @column in( 'Y','N' )  ),
   alert16_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert16_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert16_threshold_io_rate                                                                     BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA146 CHECK ( @column >= 1 ),
   alert16_threshold_io_rate_sample_count                                                        BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA147 CHECK ( @column >= 1 ),
   alert16_actual_io_rate_threshold_reached_sample_counter                                       BIGINT NOT NULL,
   alert17_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA148 CHECK ( @column in( 'Y','N' )  ),
   alert17_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA149 CHECK ( @column in( 'Y','N' )  ),
   alert17_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert17_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert17_threshold_CheckpointUrgency                                                           BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA150 CHECK ( @column >= 1 ),
   alert17_threshold_CheckpointUrgency_sample_count                                              BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA151 CHECK ( @column >= 1 ),
   alert17_actual_CheckpointUrgency_threshold_reached_sample_counter                             BIGINT NOT NULL,
   alert18_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA152 CHECK ( @column in( 'Y','N' )  ),
   alert18_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA153 CHECK ( @column in( 'Y','N' )  ),
   alert18_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert18_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert18_threshold_RecoveryUrgency                                                             BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA154 CHECK ( @column >= 1 ),
   alert18_threshold_RecoveryUrgency_sample_count                                                BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA155 CHECK ( @column >= 1 ),
   alert18_actual_RecoveryUrgency_threshold_reached_sample_counter                               BIGINT NOT NULL,
   alert19_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA156 CHECK ( @column in( 'Y','N' )  ),
   alert19_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA157 CHECK ( @column in( 'Y','N' )  ),
   alert19_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert19_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert19_threshold_cache_allocation                                                            BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA158 CHECK ( @column between 1 and 100 ),
   alert19_threshold_cache_allocation_sample_count                                               BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA159 CHECK ( @column >= 1 ),
   alert19_actual_cache_allocation_threshold_reached_sample_counter                              BIGINT NOT NULL,
   alert20_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA160 CHECK ( @column in( 'Y','N' )  ),
   alert20_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA161 CHECK ( @column in( 'Y','N' )  ),
   alert20_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert20_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert20_threshold_cache_satisfaction                                                          BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA162 CHECK ( @column between 1 and 99 ),
   alert20_threshold_cache_satisfaction_sample_count                                             BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA163 CHECK ( @column >= 1 ),
   alert20_actual_cache_satisfaction_threshold_reached_sample_counter                            BIGINT NOT NULL,
   alert21_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA164 CHECK ( @column in( 'Y','N' )  ),
   alert21_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA165 CHECK ( @column in( 'Y','N' )  ),
   alert21_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert21_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert21_threshold_total_temporary_space_usage                                                 BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA166 CHECK ( @column >= 1024 ),
   alert21_threshold_total_temporary_space_usage_sample_count                                    BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA167 CHECK ( @column >= 1 ),
   alert21_actual_total_temporary_space_usage_threshold_reached_sample_counter                   BIGINT NOT NULL,
   alert22_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA168 CHECK ( @column in( 'Y','N' )  ),
   alert22_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA169 CHECK ( @column in( 'Y','N' )  ),
   alert22_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert22_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert22_threshold_max_temporary_space_usage                                                   BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA170 CHECK ( @column >= 1024 ),
   alert22_threshold_max_temporary_space_usage_sample_count                                      BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA171 CHECK ( @column >= 1 ),
   alert22_actual_max_temporary_space_usage_threshold_reached_sample_counter                     BIGINT NOT NULL,
   alert23_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA172 CHECK ( @column in( 'Y','N' )  ),
   alert23_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA173 CHECK ( @column in( 'Y','N' )  ),
   alert23_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert23_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert23_threshold_blocked_connections                                                         BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA174 CHECK ( @column >= 1 ),
   alert23_threshold_blocked_connections_sample_count                                            BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA175 CHECK ( @column >= 1 ),
   alert23_actual_blocked_connections_threshold_reached_sample_counter                           BIGINT NOT NULL,
   alert24_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA176 CHECK ( @column in( 'Y','N' )  ),
   alert24_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA177 CHECK ( @column in( 'Y','N' )  ),
   alert24_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert24_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert24_threshold_max_blocked_by                                                              BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA178 CHECK ( @column >= 1 ),
   alert24_threshold_max_blocked_by_sample_count                                                 BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA179 CHECK ( @column >= 1 ),
   alert24_actual_max_blocked_by_threshold_reached_sample_counter                                BIGINT NOT NULL,
   alert25_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA180 CHECK ( @column in( 'Y','N' )  ),
   alert25_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA181 CHECK ( @column in( 'Y','N' )  ),
   alert25_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert25_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert25_threshold_locks                                                                       BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA182 CHECK ( @column >= 1 ),
   alert25_threshold_locks_sample_count                                                          BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA183 CHECK ( @column >= 1 ),
   alert25_actual_locks_threshold_reached_sample_counter                                         BIGINT NOT NULL,
   alert26_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA184 CHECK ( @column in( 'Y','N' )  ),
   alert26_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA185 CHECK ( @column in( 'Y','N' )  ),
   alert26_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert26_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert26_threshold_connections                                                                 BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA186 CHECK ( @column >= 2 ),
   alert26_threshold_connections_sample_count                                                    BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA187 CHECK ( @column >= 1 ),
   alert26_actual_connections_threshold_reached_sample_counter                                   BIGINT NOT NULL,
   alert27_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA188 CHECK ( @column in( 'Y','N' )  ),
   alert27_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA189 CHECK ( @column in( 'Y','N' )  ),
   alert27_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert27_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert27_threshold_max_connection_cpu                                                          BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA190 CHECK ( @column <= 100 ),
   alert27_threshold_max_connection_cpu_sample_count                                             BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA191 CHECK ( @column >= 1 ),
   alert27_actual_max_connection_cpu_threshold_reached_sample_counter                            BIGINT NOT NULL,
   alert28_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA192 CHECK ( @column in( 'Y','N' )  ),
   alert28_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA193 CHECK ( @column in( 'Y','N' )  ),
   alert28_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert28_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert28_threshold_max_transaction_time                                                        BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA194 CHECK ( @column >= 1000 ),
   alert28_threshold_max_transaction_time_sample_count                                           BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA195 CHECK ( @column >= 1 ),
   alert28_actual_max_transaction_time_threshold_reached_sample_counter                          BIGINT NOT NULL,
   alert29_enabled                                                                               VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA196 CHECK ( @column in( 'Y','N' )  ),
   alert29_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL 
                                                                                                    CONSTRAINT ASA197 CHECK ( @column in( 'Y','N' )  ),
   alert29_in_effect_at                                                                          TIMESTAMP NOT NULL,
   alert29_all_clear_at                                                                          TIMESTAMP NOT NULL,
   alert29_threshold_cache_panics                                                                BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA198 CHECK ( @column >= 1 ),
   alert29_threshold_cache_panics_sample_count                                                   BIGINT NOT NULL 
                                                                                                    CONSTRAINT ASA199 CHECK ( @column >= 1 ),
   alert29_actual_cache_panics_threshold_reached_sample_counter                                  BIGINT NOT NULL,
   alert30_enabled                                                                               VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                                                    CONSTRAINT ASA200 CHECK ( @column in( 'Y','N' )  ),
   alert30_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA201 CHECK ( @column in( 'Y','N' )  ),
   alert30_in_effect_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert30_all_clear_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert30_actual_previous_ReadOnly                                                              LONG VARCHAR NOT NULL DEFAULT '',
   alert30_actual_current_ReadOnly                                                               LONG VARCHAR NOT NULL DEFAULT '',
   alert31_enabled                                                                               VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                                                    CONSTRAINT ASA202 CHECK ( @column in( 'Y','N' )  ),
   alert31_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA203 CHECK ( @column in( 'Y','N' )  ),
   alert31_in_effect_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert31_all_clear_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert31_actual_previous_ReadOnly                                                              LONG VARCHAR NOT NULL DEFAULT '',
   alert31_actual_current_ReadOnly                                                               LONG VARCHAR NOT NULL DEFAULT '',
   alert32_enabled                                                                               VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                                                    CONSTRAINT ASA204 CHECK ( @column in( 'Y','N' )  ),
   alert32_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA205 CHECK ( @column in( 'Y','N' )  ),
   alert32_in_effect_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert32_all_clear_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert32_threshold_total_rollback_space_usage                                                  BIGINT NOT NULL DEFAULT 1073741824 
                                                                                                    CONSTRAINT ASA206 CHECK ( @column >= 1024 ),
   alert32_threshold_total_rollback_space_usage_sample_count                                     BIGINT NOT NULL DEFAULT 10 
                                                                                                    CONSTRAINT ASA207 CHECK ( @column >= 1 ),
   alert32_actual_total_rollback_space_usage_threshold_reached_sample_counter                    BIGINT NOT NULL DEFAULT 0,
   alert33_enabled                                                                               VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                                                    CONSTRAINT ASA208 CHECK ( @column in( 'Y','N' )  ),
   alert33_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA209 CHECK ( @column in( 'Y','N' )  ),
   alert33_in_effect_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert33_all_clear_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert33_threshold_uncommitted                                                                 BIGINT NOT NULL DEFAULT 1000000 
                                                                                                    CONSTRAINT ASA210 CHECK ( @column >= 1 ),
   alert33_threshold_uncommitted_sample_count                                                    BIGINT NOT NULL DEFAULT 10 
                                                                                                    CONSTRAINT ASA211 CHECK ( @column >= 1 ),
   alert33_actual_uncommitted_threshold_reached_sample_counter                                   BIGINT NOT NULL DEFAULT 0,
   alert34_enabled                                                                               VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                                                    CONSTRAINT ASA212 CHECK ( @column in( 'Y','N' )  ),
   alert34_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA213 CHECK ( @column in( 'Y','N' )  ),
   alert34_in_effect_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert34_all_clear_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert34_threshold_uncommitted                                                                 BIGINT NOT NULL DEFAULT 1000000 
                                                                                                    CONSTRAINT ASA214 CHECK ( @column >= 1 ),
   alert34_threshold_transaction_time                                                            BIGINT NOT NULL DEFAULT 60000 
                                                                                                    CONSTRAINT ASA215 CHECK ( @column >= 1000 ),
   alert34_actual_current_thresholds_met                                                         VARCHAR ( 1 ) NOT NULL DEFAULT 'N',
   alert35_enabled                                                                               VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                                                    CONSTRAINT ASA216 CHECK ( @column in( 'Y','N' )  ),
   alert35_is_in_effect                                                                          VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA217 CHECK ( @column in( 'Y','N' )  ),
   alert35_in_effect_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert35_all_clear_at                                                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert35_threshold_sample_count                                                                BIGINT NOT NULL DEFAULT 10 
                                                                                                    CONSTRAINT ASA218 CHECK ( @column >= 1 ),
   alert35_actual_sample_counter                                                                 BIGINT NOT NULL DEFAULT 0,
   notice1_enabled                                                                               VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA219 CHECK ( @column in( 'Y','N' )  ),
   autodrop1_enabled                                                                             VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA220 CHECK ( @column in( 'Y','N' )  ),
   autodrop1_threshold_blocking_connections                                                      BIGINT NOT NULL DEFAULT 5 
                                                                                                    CONSTRAINT ASA221 CHECK ( @column >= 1 ),
   autodrop1_threshold_blocking_connections_sample_count                                         BIGINT NOT NULL DEFAULT 10 
                                                                                                    CONSTRAINT ASA222 CHECK ( @column >= 1 ),
   autodrop1_actual_blocking_connections_threshold_reached_sample_counter                        BIGINT NOT NULL DEFAULT 0,
   autodrop2_enabled                                                                             VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA223 CHECK ( @column in( 'Y','N' )  ),
   autodrop2_threshold_blocked_sample_count                                                      BIGINT NOT NULL DEFAULT 100 
                                                                                                    CONSTRAINT ASA224 CHECK ( @column >= 1 ),
   autodrop2_actual_blocked_sample_counter                                                       BIGINT NOT NULL DEFAULT 0,
   autodrop3_enabled                                                                             VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA225 CHECK ( @column in( 'Y','N' )  ),
   autodrop3_threshold_transaction_msec                                                          BIGINT NOT NULL DEFAULT 600000 
                                                                                                    CONSTRAINT ASA226 CHECK ( @column >= 1 ),
   autodrop4_enabled                                                                             VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA227 CHECK ( @column in( 'Y','N' )  ),
   autodrop4_threshold_max_temporary_space_usage                                                 BIGINT NOT NULL DEFAULT 536870912 
                                                                                                    CONSTRAINT ASA228 CHECK ( @column >= 1024 ),
   autodrop4_threshold_max_temporary_space_usage_sample_count                                    BIGINT NOT NULL DEFAULT 10 
                                                                                                    CONSTRAINT ASA229 CHECK ( @column >= 1 ),
   autodrop4_actual_max_temporary_space_usage_threshold_reached_sample_counter                   BIGINT NOT NULL DEFAULT 0,
   autodrop5_enabled                                                                             VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA230 CHECK ( @column in( 'Y','N' )  ),
   autodrop5_threshold_cpu_percent                                                               BIGINT NOT NULL DEFAULT 25 
                                                                                                    CONSTRAINT ASA231 CHECK ( @column between 1 and 100 ),
   autodrop5_threshold_cpu_percent_sample_count                                                  BIGINT NOT NULL DEFAULT 10 
                                                                                                    CONSTRAINT ASA232 CHECK ( @column >= 1 ),
   autodrop5_actual_cpu_percent_threshold_reached_sample_counter                                 BIGINT NOT NULL DEFAULT 0,
   autodrop6_enabled                                                                             VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA233 CHECK ( @column in( 'Y','N' )  ),
   autodrop6_threshold_locks                                                                     BIGINT NOT NULL DEFAULT 1000000 
                                                                                                    CONSTRAINT ASA234 CHECK ( @column >= 1 ),
   autodrop6_threshold_locks_sample_count                                                        BIGINT NOT NULL DEFAULT 10 
                                                                                                    CONSTRAINT ASA235 CHECK ( @column >= 1 ),
   autodrop6_actual_locks_threshold_reached_sample_counter                                       BIGINT NOT NULL DEFAULT 0,
   do_not_autodrop_user_id_list_enabled                                                          VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA236 CHECK ( @column in( 'Y','N' )  ),
   do_not_autodrop_user_id_list                                                                  LONG VARCHAR NOT NULL DEFAULT '',
   do_not_autodrop_connection_name_list_enabled                                                  VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA237 CHECK ( @column in( 'Y','N' )  ),
   do_not_autodrop_connection_name_list                                                          LONG VARCHAR NOT NULL DEFAULT '',
   monitor_dedicated_task_enabled                                                                VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA238 CHECK ( @monitor_dedicated_task_enabled in( 'Y','N' )  ),
   monitor_dedicated_task_status                                                                 LONG VARCHAR NOT NULL DEFAULT '',
   monitor_connection_name_template                                                              VARCHAR ( 100 ) NOT NULL DEFAULT 'Foxhound-Monitor-nnnn',
   ping_only_sampling                                                                            VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA239 CHECK ( @ping_only_sampling in( 'Y','N' )  ),
   ping_enabled_for_successful_samples                                                           VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA240 CHECK ( @ping_enabled_for_successful_samples in( 'Y','N' )  ),
   ping_enabled_for_lost_samples                                                                 VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA241 CHECK ( @ping_enabled_for_lost_samples in( 'Y','N' )  ),
   ping_repeated_during_outages                                                                  VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                                                    CONSTRAINT ASA242 CHECK ( @ping_repeated_during_outages in( 'Y','N' )  ),
   ping_connection_name_template                                                                 VARCHAR ( 100 ) NOT NULL DEFAULT 'Foxhound-ping-nnnn',
   CONSTRAINT ASA243 PRIMARY KEY (
      criteria_set_type,
      sampling_id )
 );

-- Parents of DBA.rroad_alerts_criteria

-- none --

-- Children

-- DBA.rroad_schedule


Top    Tables: A B C D E G M P R S U

DBA.rroad_all_clear

-- DBA.rroad_all_clear (table_id 749) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:21AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_all_clear ( -- empty
   all_clear_occurrence   /* PK        */ UNSIGNED BIGINT NOT NULL,
   sampling_id                            UNSIGNED INT NOT NULL,
   sample_set_number                      UNSIGNED BIGINT NOT NULL,
   alert_number                           INTEGER NOT NULL,
   alert_all_clear_at                     TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   alert_in_effect_at                     TIMESTAMP NOT NULL,
   alert_description                      LONG VARCHAR NOT NULL,
   email_status                           LONG VARCHAR NOT NULL DEFAULT '',
   CONSTRAINT ASA93 PRIMARY KEY (
      all_clear_occurrence )
 );

-- Parents of DBA.rroad_all_clear

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_applied_patch

-- DBA.rroad_applied_patch (table_id 738) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:21AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_applied_patch ( -- empty
   file_name                 /* PK        */ VARCHAR ( 200 ) NOT NULL,
   applied_to_build_number                   INTEGER NOT NULL,
   inserted_at                               TIMESTAMP NOT NULL DEFAULT current timestamp,
   updated_at                                TIMESTAMP NOT NULL DEFAULT timestamp,
   status                                    LONG VARCHAR NOT NULL DEFAULT 'started',
   CONSTRAINT ASA78 PRIMARY KEY (
      file_name )
 );

-- Parents of DBA.rroad_applied_patch

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_autodrop_candidate

-- DBA.rroad_autodrop_candidate (table_id 740) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:21AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_autodrop_candidate ( -- empty
   sampling_id                                                                   /* PK        */ UNSIGNED INT NOT NULL,
   connection_number                                                             /* PK        */ BIGINT NOT NULL,
   LoginTime                                                                     /* PK        */ LONG VARCHAR NOT NULL,
   autodrop1_actual_blocking_connections_threshold_reached_sample_counter                        BIGINT NOT NULL DEFAULT 0,
   autodrop2_actual_blocked_sample_counter                                                       BIGINT NOT NULL DEFAULT 0,
   autodrop4_actual_max_temporary_space_usage_threshold_reached_sample_counter                   BIGINT NOT NULL DEFAULT 0,
   autodrop5_actual_cpu_percent_threshold_reached_sample_counter                                 BIGINT NOT NULL DEFAULT 0,
   autodrop6_actual_locks_threshold_reached_sample_counter                                       BIGINT NOT NULL DEFAULT 0,
   CONSTRAINT ASA79 PRIMARY KEY (
      sampling_id,
      connection_number,
      LoginTime )
 );

-- Parents of DBA.rroad_autodrop_candidate

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_autodropped_connection

-- DBA.rroad_autodropped_connection (table_id 755) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:21AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_autodropped_connection ( -- empty
   autodrop_occurrence                    /* PK        */ UNSIGNED BIGINT NOT NULL,
   sampling_id                                            UNSIGNED INT NOT NULL,
   autodrop_issued_sample_set_number                      UNSIGNED BIGINT NOT NULL,
   autodrop_processed_sample_set_number                   UNSIGNED BIGINT NOT NULL,
   connection_number                                      BIGINT NOT NULL,
   Name                                                   VARCHAR ( 128 ) NOT NULL,
   NodeAddress                                            LONG VARCHAR NOT NULL,
   OSUser                                                 LONG VARCHAR NULL,
   Userid                                                 VARCHAR ( 128 ) NOT NULL,
   autodrop_issued_at                                     TIMESTAMP NOT NULL,
   autodrop_processed_at                                  TIMESTAMP NOT NULL,
   autodrop_reason                                        LONG VARCHAR NOT NULL,
   email_status                                           LONG VARCHAR NOT NULL DEFAULT '',
   CONSTRAINT ASA244 PRIMARY KEY (
      autodrop_occurrence )
 );

-- Parents of DBA.rroad_autodropped_connection

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_build_number

-- DBA.rroad_build_number (table_id 757) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:21AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_build_number ( -- empty
   artificial_id          /* PK        */ INTEGER NOT NULL DEFAULT 1 
                                             CONSTRAINT ASA245 CHECK ( @artificial_id = 1 ),
   required_asa_version                   VARCHAR ( 100 ) NOT NULL,
   version_prefix                         VARCHAR ( 100 ) NOT NULL,
   build_fork                             VARCHAR ( 1 ) NOT NULL,
   build_number                           INTEGER NOT NULL,
   build_date                             TIMESTAMP NOT NULL,
   CONSTRAINT ASA246 PRIMARY KEY (
      artificial_id )
 );

-- Parents of DBA.rroad_build_number

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_connection_string

-- DBA.rroad_connection_string (table_id 759) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:21AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_connection_string ( -- empty
   connection_string_name   /* PK        */ VARCHAR ( 128 ) NOT NULL,
   connection_string                        LONG VARCHAR NOT NULL,
   CONSTRAINT ASA247 PRIMARY KEY (
      connection_string_name )
 );

-- Parents of DBA.rroad_connection_string

-- none --

-- Children

-- DBA.rroad_global_options


Top    Tables: A B C D E G M P R S U

DBA.rroad_data_upgrade_history

-- DBA.rroad_data_upgrade_history (table_id 761) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:21AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_data_upgrade_history ( -- empty
   artificial_id               /* PK        */ INTEGER NOT NULL DEFAULT autoincrement,
   data_upgraded_at                            TIMESTAMP NOT NULL,
   from_required_asa_version                   VARCHAR ( 100 ) NOT NULL,
   from_version_prefix                         VARCHAR ( 100 ) NOT NULL,
   from_build_fork                             VARCHAR ( 1 ) NOT NULL,
   from_build_number                           INTEGER NOT NULL,
   from_build_date                             TIMESTAMP NOT NULL,
   CONSTRAINT ASA248 PRIMARY KEY (
      artificial_id )
 );

-- Parents of DBA.rroad_data_upgrade_history

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_email_failure

-- DBA.rroad_email_failure (table_id 765) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:22AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_email_failure ( -- empty
   email_failure_occurrence    /* PK        */ UNSIGNED BIGINT NOT NULL,
   sampling_id                                 UNSIGNED INT NOT NULL,
   sample_set_number                           UNSIGNED BIGINT NOT NULL,
   email_failure_at                            TIMESTAMP NOT NULL,
   email_failure_description                   LONG VARCHAR NOT NULL,
   CONSTRAINT ASA250 PRIMARY KEY (
      email_failure_occurrence )
 );

-- Parents of DBA.rroad_email_failure

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_exception

-- DBA.rroad_exception (table_id 767) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:22AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_exception ( -- empty
   exception_id           /* PK        */ BIGINT NOT NULL DEFAULT autoincrement,
   exception_diagnostic                   LONG VARCHAR NOT NULL,
   CONSTRAINT ASA251 PRIMARY KEY CLUSTERED (
      exception_id )
 );

-- Parents of DBA.rroad_exception

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_exception_dump

-- DBA.rroad_exception_dump (table_id 769) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:22AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_exception_dump ( -- empty
   exception_id       /*         X */ BIGINT NOT NULL,
   dump_id            /* PK        */ BIGINT NOT NULL DEFAULT autoincrement,
   dump_inserted_at                   TIMESTAMP NOT NULL DEFAULT current timestamp,
   dump                               LONG VARCHAR NOT NULL,
   CONSTRAINT ASA252 PRIMARY KEY (
      dump_id )
 );

-- Parents of DBA.rroad_exception_dump

-- none --

-- Children

-- none --

CREATE CLUSTERED INDEX ix_exception_id ON DBA.rroad_exception_dump (
   exception_id );


Top    Tables: A B C D E G M P R S U

DBA.rroad_expiry_date

-- DBA.rroad_expiry_date (table_id 771) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:22AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_expiry_date ( -- empty
   one_row_only                  /* PK        */ INTEGER NOT NULL DEFAULT 1 
                                                    CONSTRAINT ASA253 CHECK ( "one_row_only" = 1 ),
   key_type                                      VARCHAR ( 1 ) NOT NULL 
                                                    CONSTRAINT ASA254 CHECK ( @key_type in( 'G',
'R',
'S',
'X',
'U',
'A',
'C',
'D',
'F',
'J',
'K' )  ),
   edition_name                                  VARCHAR ( 100 ) NOT NULL 
                                                    COMPUTE ( case when "key_type" = 'G' then 'GA'
when "key_type" = 'R' then 'Rental'
when "key_type" = 'S' then 'Basic'
when "key_type" = 'X' then 'Extended'
when "key_type" = 'U' then 'Extended'
when "key_type" = 'A' then 'Basic'
when "key_type" = 'C' then 'Basic'
when "key_type" = 'D' then 'Extended'
when "key_type" = 'F' then 'Extended'
when "key_type" = 'J' then 'Basic'
when "key_type" = 'K' then 'Extended'
else 'Unknown'
end ),
   expiry_date                                   DATE NOT NULL,
   expires_after_how_many_days                   BIGINT NOT NULL,
   CONSTRAINT ASA255 PRIMARY KEY (
      one_row_only )
 );

-- Parents of DBA.rroad_expiry_date

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_global_options

-- DBA.rroad_global_options (table_id 773) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:22AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_global_options ( -- empty
   artificial_id                                    /* PK        */ INTEGER NOT NULL DEFAULT 1 
                                                                       CONSTRAINT ASA256 CHECK ( @artificial_id = 1 ),
   selected_tab                                                     VARCHAR ( 1 ) NOT NULL DEFAULT '1' 
                                                                       CONSTRAINT ASA257 CHECK ( @selected_tab in( '1','2','3' )  ),
   selected_dsn                                                     VARCHAR ( 128 ) NOT NULL DEFAULT '',
   selected_connection_string_name                  /*    FK     */ VARCHAR ( 128 ) NOT NULL DEFAULT 'Foxhound 4 Adhoc Schema - autostart and connect',
   include_system_owners                                            VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                       CONSTRAINT ASA258 CHECK ( @include_system_owners in( 'Y','N' )  ),
   show_all_dsns                                                    VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                       CONSTRAINT ASA259 CHECK ( @show_all_dsns in( 'Y','N' )  ),
   s1                                                               VARCHAR ( 1 ) NULL,
   z1                                                               LONG VARCHAR NULL,
   c1                                                               LONG VARCHAR NULL,
   u1                                                               LONG VARCHAR NULL,
   sf1                                                              LONG VARCHAR NULL,
   i1                                                               LONG VARCHAR NULL,
   z2                                                               LONG VARCHAR NULL,
   c2                                                               LONG VARCHAR NULL,
   n2                                                               LONG VARCHAR NULL,
   s2                                                               LONG VARCHAR NULL,
   sf2                                                              LONG VARCHAR NULL,
   i2                                                               LONG VARCHAR NULL,
   help_frameset_cols                                               VARCHAR ( 100 ) NOT NULL DEFAULT '50%,50%',
   export_diagnostics_filespec                                      LONG VARCHAR NOT NULL DEFAULT 'C:\\temp\\foxhound_diagnostics.txt',
   connection_timeout_msec                                          BIGINT NOT NULL DEFAULT 15000 
                                                                       CONSTRAINT ASA260 CHECK ( @connection_timeout_msec in( 15000,30000,60000,0 )  ),
   timeout_retry_msec                                               BIGINT NOT NULL DEFAULT 60000 
                                                                       CONSTRAINT ASA261 CHECK ( @timeout_retry_msec in( 60000,600000,3600000,0 )  ),
   most_recent_purge_connection_number                              INTEGER NOT NULL DEFAULT 0,
   cancel_this_purge_connection_number                              INTEGER NOT NULL DEFAULT 0,
   enable_automatic_purge_schedule                                  VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                       CONSTRAINT ASA262 CHECK ( @enable_automatic_purge_schedule in( 'Y','N' )  ),
   sample_purge_interval                                            VARCHAR ( 100 ) NOT NULL DEFAULT '1 month' 
                                                                       CONSTRAINT ASA263 CHECK ( @sample_purge_interval in( '1 day','1 week','1 month','1 year','no purge' )  ),
   uninteresting_connections_purge_interval                         VARCHAR ( 100 ) NOT NULL DEFAULT '1 week' 
                                                                       CONSTRAINT ASA264 CHECK ( @uninteresting_connections_purge_interval in( '1 day','1 week','1 month','1 year','no purge' )  ),
   sample_purge_enabled                                             VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                       CONSTRAINT ASA265 CHECK ( @sample_purge_enabled in( 'Y','N' )  ),
   sample_purge_after_days                                          INTEGER NOT NULL DEFAULT 30 
                                                                       CONSTRAINT ASA266 CHECK ( @sample_purge_after_days >= 1 ),
   uninteresting_connections_purge_enabled                          VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                       CONSTRAINT ASA267 CHECK ( @uninteresting_connections_purge_enabled in( 'Y','N' )  ),
   uninteresting_connections_purge_after_days                       INTEGER NOT NULL DEFAULT 7 
                                                                       CONSTRAINT ASA268 CHECK ( @uninteresting_connections_purge_after_days >= 1 ),
   purge_speed                                                      VARCHAR ( 100 ) NOT NULL DEFAULT '5' 
                                                                       CONSTRAINT ASA269 CHECK ( @purge_speed in( '1','2','3','4','5','6','7','8','9','10' )  ),
   export_samples_folder                                            LONG VARCHAR NOT NULL DEFAULT 'C:\\temp',
   max_proxy_owner_count                                            INTEGER NOT NULL DEFAULT 100,
   public_demo                                                      VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                       CONSTRAINT ASA270 CHECK ( @show_all_dsns in( 'Y','N' )  ),
   enable_features_password                                         VARCHAR ( 80 ) NOT NULL,
   foxhound_db_folder                                               LONG VARCHAR NOT NULL DEFAULT '',
   shutting_down                                                    VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                       CONSTRAINT ASA271 CHECK ( @show_all_dsns in( 'Y','N' )  ),
   smtp_sender                                                      LONG VARCHAR NOT NULL DEFAULT '',
   smtp_server                                                      LONG VARCHAR NOT NULL DEFAULT '',
   smtp_port                                                        INTEGER NOT NULL DEFAULT 25,
   smtp_timeout                                                     INTEGER NOT NULL DEFAULT 60,
   smtp_auth_username                                               LONG VARCHAR NOT NULL DEFAULT '',
   smtp_auth_password                                               LONG BINARY NOT NULL DEFAULT '',
   mapi_mail_username                                               LONG VARCHAR NOT NULL DEFAULT '',
   mapi_mail_password                                               LONG BINARY NOT NULL DEFAULT '',
   email_type                                                       VARCHAR ( 10 ) NOT NULL DEFAULT 'smtp' 
                                                                       CONSTRAINT ASA272 CHECK ( @email_type in( 'smtp','mapi' )  ),
   connection_sampling_connection_count_threshold                   BIGINT NOT NULL DEFAULT 9223372036854775807 
                                                                       CONSTRAINT ASA273 CHECK ( @connection_sampling_connection_count_threshold in( 0,10,100,1000,10000,9223372036854775807 )  ),
   connection_strings_filespec                                      LONG VARCHAR NOT NULL DEFAULT '',
   enable_emails                                                    VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                       CONSTRAINT ASA274 CHECK ( @enable_emails in( 'Y','N' )  ),
   enable_autodrop                                                  VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                       CONSTRAINT ASA275 CHECK ( @enable_autodrop in( 'Y','N' )  ),
   smtp_certificate_filespec                                        LONG VARCHAR NOT NULL DEFAULT '',
   monitor_sample_set_number_span                                   UNSIGNED BIGINT NULL DEFAULT 10,
   history_sample_set_number_span                                   UNSIGNED BIGINT NULL DEFAULT 100,
   connection_history_number_span                                   UNSIGNED BIGINT NULL DEFAULT 100,
   alerts_sample_set_number_span                                    UNSIGNED BIGINT NULL DEFAULT 50,
   history_frameset_rows                                            VARCHAR ( 100 ) NULL DEFAULT '100,2*,1*',
   history_connection_frameset_rows                                 VARCHAR ( 100 ) NULL DEFAULT '20%,80%',
   enable_schedules                                                 VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                       CONSTRAINT ASA276 CHECK ( @enable_schedules in( 'Y','N' )  ),
   show_connection_details                                          VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                                       CONSTRAINT ASA277 CHECK ( @enable_autodrop in( 'Y','N' )  ),
   CONSTRAINT ASA278 PRIMARY KEY (
      artificial_id )
 );

-- Parents of DBA.rroad_global_options

-- DBA.rroad_connection_string

-- Children

-- none --

ALTER TABLE DBA.rroad_global_options ADD CONSTRAINT fk_connection_string NOT NULL FOREIGN KEY (
      selected_connection_string_name )
   REFERENCES DBA.rroad_connection_string (
      connection_string_name )
   ON UPDATE RESTRICT ON DELETE RESTRICT;


Top    Tables: A B C D E G M P R S U

DBA.rroad_group_1_property_pivot

-- DBA.rroad_group_1_property_pivot (table_id 775) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:22AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_group_1_property_pivot ( -- empty
   sampling_id                                /*         X */ UNSIGNED INT NOT NULL,
   sample_set_number                          /* PK      X */ UNSIGNED BIGINT NOT NULL,
   sample_lost                                /*         X */ VARCHAR ( 1 ) NOT NULL,
   connected_ok                                               VARCHAR ( 1 ) NOT NULL,
   exception_description                                      VARCHAR ( 32767 ) NOT NULL,
   sample_elapsed_msec                                        BIGINT NOT NULL,
   canarian_query_elapsed_msec                                BIGINT NOT NULL,
   datediff_msec_between_target_and_local                     BIGINT NULL,
   sample_recorded_at                                         TIMESTAMP NOT NULL,
   current_database_version                                   LONG VARCHAR NULL,
   current_engine_version                                     LONG VARCHAR NULL,
   page_size                                                  INTEGER NULL,
   proxy_rroad_engine_properties_exists                       VARCHAR ( 1 ) NULL,
   proxy_rroad_database_properties_exists                     VARCHAR ( 1 ) NULL,
   proxy_rroad_connection_properties_exists                   VARCHAR ( 1 ) NULL,
   system_free_bytes                                          UNSIGNED BIGINT NULL,
   temp_file_free_bytes                                       UNSIGNED BIGINT NULL,
   log_free_bytes                                             UNSIGNED BIGINT NULL,
   min_other_free_bytes                                       UNSIGNED BIGINT NULL,
   ArbiterState                                               LONG VARCHAR NULL,
   ActiveReq                                                  BIGINT NULL,
   BytesReceived                                              BIGINT NULL,
   BytesSent                                                  BIGINT NULL,
   CacheHits                                                  BIGINT NULL,
   CachePanics                                                BIGINT NULL,
   CacheRead                                                  BIGINT NULL,
   CacheReadIndInt                                            BIGINT NULL,
   CacheReadIndLeaf                                           BIGINT NULL,
   CacheReadTable                                             BIGINT NULL,
   CheckpointLogSize                                          BIGINT NULL,
   CheckpointUrgency                                          BIGINT NULL,
   Chkpt                                                      BIGINT NULL,
   ConnCount                                                  BIGINT NULL,
   CurrentCacheSize                                           BIGINT NULL,
   CurrIO                                                     BIGINT NULL,
   CurrRead                                                   BIGINT NULL,
   CurrWrite                                                  BIGINT NULL,
   DBFileFragments                                            BIGINT NULL,
   DiskRead                                                   BIGINT NULL,
   DiskReadIndInt                                             BIGINT NULL,
   DiskReadIndLeaf                                            BIGINT NULL,
   DiskReadTable                                              BIGINT NULL,
   DiskWrite                                                  BIGINT NULL,
   File                                                       LONG VARCHAR NULL,
   FileSize                                                   BIGINT NULL,
   FreePages                                                  BIGINT NULL,
   FullCompare                                                BIGINT NULL,
   GlobalDBId                                                 BIGINT NULL,
   IndAdd                                                     BIGINT NULL,
   IndLookup                                                  BIGINT NULL,
   LockCount                                                  BIGINT NULL,
   LogWrite                                                   BIGINT NULL,
   MachineName                                                LONG VARCHAR NULL,
   MaxCacheSize                                               BIGINT NULL,
   MirrorMode                                                 LONG VARCHAR NULL,
   MirrorState                                                LONG VARCHAR NULL,
   MultiProgrammingLevel                                      BIGINT NULL,
   Name                                                       LONG VARCHAR NULL,
   NumLogicalProcessorsUsed                                   BIGINT NULL,
   NumProcessorsAvail                                         BIGINT NULL,
   PartnerState                                               LONG VARCHAR NULL,
   ProcessCPU                                                 DECIMAL ( 30, 6 ) NULL,
   QueryLowMemoryStrategy                                     BIGINT NULL,
   ReadOnly                                                   LONG VARCHAR NULL,
   RecoveryUrgency                                            BIGINT NULL,
   RememberLastPlan                                           LONG VARCHAR NULL,
   RememberLastStatement                                      LONG VARCHAR NULL,
   Req                                                        BIGINT NULL,
   RequestTiming                                              LONG VARCHAR NULL,
   ServerName                                                 LONG VARCHAR NULL,
   SnapshotIsolationState                                     LONG VARCHAR NULL,
   StartTime                                                  LONG VARCHAR NOT NULL DEFAULT '1900-01-01',
   UnschReq                                                   BIGINT NULL,
   interval_msec                                              BIGINT NULL,
   interval_BytesReceived                                     BIGINT NULL,
   interval_BytesSent                                         BIGINT NULL,
   interval_CacheHits                                         BIGINT NULL,
   interval_CachePanics                                       BIGINT NULL,
   interval_CacheRead                                         BIGINT NULL,
   ratio_ReadIndInt                                           DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   ratio_ReadIndLeaf                                          DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   ratio_ReadTable                                            DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   interval_Chkpt                                             BIGINT NULL,
   interval_DiskRead                                          BIGINT NULL,
   interval_DiskWrite                                         BIGINT NULL,
   interval_FullCompare                                       BIGINT NULL,
   interval_IndAdd                                            BIGINT NULL,
   interval_IndLookup                                         BIGINT NULL,
   interval_LogWrite                                          BIGINT NULL,
   interval_ProcessCPU                                        DECIMAL ( 30, 6 ) NULL,
   interval_QueryLowMemoryStrategy                            BIGINT NULL,
   interval_Req                                               BIGINT NULL,
   executing_connection_count                                 BIGINT NULL,
   idle_connection_count                                      BIGINT NULL,
   waiting_connection_count                                   BIGINT NULL,
   total_blocked_connection_count                             BIGINT NULL,
   total_waiting_time                                         DECIMAL ( 30, 6 ) NULL,
   interval_waiting_time                                      DECIMAL ( 30, 6 ) NULL,
   total_temporary_file_pages                                 BIGINT NULL,
   "Commit"                                                   BIGINT NULL,
   interval_Commit                                            BIGINT NULL,
   Rlbk                                                       BIGINT NULL,
   interval_CPU_percent                                       DECIMAL ( 30, 1 ) NULL,
   CPU_count                                                  INTEGER NOT NULL 
                                                                 COMPUTE ( case when "COALESCE"("NumLogicalProcessorsUsed",0) > 0 then "NumLogicalProcessorsUsed"
when "COALESCE"("NumProcessorsAvail",0) > 0 then "NumProcessorsAvail"
else 1
end ),
   autodropped_connection_count                               INTEGER NOT NULL DEFAULT 0,
   foxhound_connection_count                                  INTEGER NOT NULL DEFAULT 0,
   total_child_connection_count                               INTEGER NOT NULL DEFAULT 0,
   system_file_used_percent                                   DECIMAL ( 30, 1 ) NOT NULL 
                                                                 COMPUTE ( if "COALESCE"("FileSize",0) > 0
and "COALESCE"("FreePages",0) > 0 then
  "ROUND"(100.0*("FileSize"-"FreePages")/"FileSize",1)
else 0.0
endif ),
   total_rollback_log_pages                                   BIGINT NOT NULL DEFAULT 0,
   total_uncommitted_operations                               BIGINT NOT NULL DEFAULT 0,
   ping_id                                                    UNSIGNED BIGINT NOT NULL DEFAULT 0,
   ping_was_successful                                        VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                 CONSTRAINT ASA279 CHECK ( @ping_was_successful in( 'Y','N' )  ),
   successful_ping_elapsed_msec                               BIGINT NOT NULL DEFAULT 0,
   LogFileFragments                                           BIGINT NOT NULL DEFAULT 0,
   logFileSize                                                BIGINT NOT NULL DEFAULT 0,
   logFreePages                                               BIGINT NOT NULL DEFAULT 0,
   LogName                                                    LONG VARCHAR NOT NULL DEFAULT '',
   tempFileFragments                                          BIGINT NOT NULL DEFAULT 0,
   TempFileName                                               LONG VARCHAR NOT NULL DEFAULT '',
   tempFileSize                                               BIGINT NOT NULL DEFAULT 0,
   tempFreePages                                              BIGINT NOT NULL DEFAULT 0,
   CONSTRAINT ASA280 PRIMARY KEY (
      sample_set_number )
 );

-- Parents of DBA.rroad_group_1_property_pivot

-- none --

-- Children

-- none --

CREATE INDEX ix_id_lost ON DBA.rroad_group_1_property_pivot (
   sampling_id,
   sample_lost );

CREATE INDEX ix_number_DESC_id_lost ON DBA.rroad_group_1_property_pivot (
   sample_set_number DESC,
   sampling_id,
   sample_lost );


Top    Tables: A B C D E G M P R S U

DBA.rroad_group_2_property_pivot

-- DBA.rroad_group_2_property_pivot (table_id 777) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:22AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_group_2_property_pivot ( -- empty
   sampling_id                                     UNSIGNED INT NOT NULL,
   sample_set_number               /* PK      X */ UNSIGNED BIGINT NOT NULL,
   connection_number               /* PK        */ BIGINT NOT NULL,
   connection_id_string            /*         X */ VARCHAR ( 50 ) NOT NULL 
                                                      COMPUTE ( "STRING"(
"sampling_id",
'-',
"connection_number",
'-',
"DATEFORMAT"("LoginTime",'YYYYMMDDHHNNSS-SSS')) ),
   blocker_owner_table_name                        VARCHAR ( 257 ) NULL,
   blocker_lock_type                               VARCHAR ( 32 ) NULL,
   blocker_owner_name                              VARCHAR ( 128 ) NULL,
   blocker_table_name                              VARCHAR ( 128 ) NULL,
   blocker_reason                                  LONG VARCHAR NULL,
   blocker_row_identifier                          VARCHAR ( 32 ) NULL,
   current_engine_version                          LONG VARCHAR NOT NULL,
   page_size                                       INTEGER NOT NULL,
   ApproximateCPUTime                              DECIMAL ( 30, 6 ) NULL,
   BlockedOn                                       BIGINT NULL,
   BytesReceived                                   BIGINT NULL,
   BytesSent                                       BIGINT NULL,
   CacheHits                                       BIGINT NULL,
   CacheRead                                       BIGINT NULL,
   CacheReadIndInt                                 BIGINT NULL,
   CacheReadIndLeaf                                BIGINT NULL,
   CacheReadTable                                  BIGINT NULL,
   ClientStmtCacheHits                             BIGINT NULL,
   ClientStmtCacheMisses                           BIGINT NULL,
   "Commit"                                        BIGINT NULL,
   CurrentLineNumber                               BIGINT NULL,
   CurrentProcedure                                LONG VARCHAR NULL,
   Dedicated_task                                  LONG VARCHAR NULL,
   DiskRead                                        BIGINT NULL,
   DiskReadIndInt                                  BIGINT NULL,
   DiskReadIndLeaf                                 BIGINT NULL,
   DiskReadTable                                   BIGINT NULL,
   DiskWrite                                       BIGINT NULL,
   FullCompare                                     BIGINT NULL,
   IndAdd                                          BIGINT NULL,
   IndLookup                                       BIGINT NULL,
   Isolation_level                                 LONG VARCHAR NULL,
   LastReqTime                                     LONG VARCHAR NOT NULL DEFAULT '1900-01-01',
   LastStatement                                   LONG VARCHAR NULL,
   LastPlanText                                    LONG VARCHAR NULL DEFAULT '',
   LockCount                                       BIGINT NULL,
   LockName                                        BIGINT NULL,
   LockObjectOID                                   BIGINT NULL,
   LockObjectType                                  BIGINT NULL,
   LockRowID                                       BIGINT NULL,
   LockTableOID                                    BIGINT NULL,
   LoginTime                                       LONG VARCHAR NOT NULL DEFAULT '1900-01-01',
   LogWrite                                        BIGINT NULL,
   max_client_statements_cached                    BIGINT NULL,
   Max_plans_cached                                BIGINT NULL,
   max_query_tasks                                 BIGINT NULL,
   Name                                            VARCHAR ( 128 ) NULL,
   NodeAddress                                     LONG VARCHAR NULL,
   OSUser                                          LONG VARCHAR NULL,
   ParentConnection                                BIGINT NULL,
   Prepares                                        BIGINT NULL,
   PrepStmt                                        BIGINT NULL,
   priority                                        LONG VARCHAR NULL,
   QueryHeapPages                                  BIGINT NULL,
   QueryLowMemoryStrategy                          BIGINT NULL,
   QueryOptimized                                  BIGINT NULL,
   QueryReused                                     BIGINT NULL,
   ReqCountActive                                  BIGINT NULL,
   ReqStatus                                       LONG VARCHAR NULL,
   ReqTimeActive                                   DECIMAL ( 30, 6 ) NULL,
   ReqTimeBlockContention                          DECIMAL ( 30, 6 ) NULL,
   ReqTimeBlockIO                                  DECIMAL ( 30, 6 ) NULL,
   ReqTimeBlockLock                                DECIMAL ( 30, 6 ) NULL,
   ReqTimeUnscheduled                              DECIMAL ( 30, 6 ) NULL,
   ReqType                                         LONG VARCHAR NULL,
   RequestsReceived                                BIGINT NULL,
   Rlbk                                            BIGINT NULL,
   RollbackLogPages                                BIGINT NULL,
   TempFilePages                                   BIGINT NULL,
   TransactionStartTime                            LONG VARCHAR NOT NULL DEFAULT '1900-01-01',
   UncommitOp                                      BIGINT NULL,
   updatable_statement_isolation                   LONG VARCHAR NULL,
   Userid                                          VARCHAR ( 128 ) NULL,
   interval_ApproximateCPUTime                     DECIMAL ( 30, 6 ) NULL,
   ratio_ReadIndInt                                DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   ratio_ReadIndLeaf                               DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   ratio_ReadTable                                 DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   interval_Commit                                 BIGINT NULL,
   rate_bytes                                      DECIMAL ( 30, 6 ) NULL,
   rate_Commit                                     DECIMAL ( 30, 6 ) NULL,
   rate_ReqCountActive                             DECIMAL ( 30, 6 ) NULL,
   rate_DiskRead                                   DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   rate_DiskWrite                                  DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   rate_FullCompare                                DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   rate_IndAdd                                     DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   rate_IndLookup                                  DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   rate_LogWrite                                   DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   blocked_connection_count                        BIGINT NOT NULL DEFAULT 0,
   current_req_status                              VARCHAR ( 100 ) NOT NULL DEFAULT '',
   cache_satisfaction                              DECIMAL ( 30 ) NOT NULL DEFAULT 0.0,
   time_connected                                  BIGINT NOT NULL DEFAULT 0,
   waiting_time                                    DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   transaction_running_time                        BIGINT NOT NULL DEFAULT 0,
   time_since_last_request                         BIGINT NOT NULL DEFAULT 0,
   index_satisfaction                              DECIMAL ( 30 ) NOT NULL DEFAULT 0.0,
   autodrop_reason                                 LONG VARCHAR NOT NULL DEFAULT '',
   autodrop_result                                 LONG VARCHAR NOT NULL DEFAULT '',
   interval_CPU_percent                            DECIMAL ( 30, 1 ) NOT NULL DEFAULT 0,
   busy_percent                                    TINYINT NOT NULL DEFAULT 0,
   wait_percent                                    TINYINT NOT NULL DEFAULT 0,
   idle_percent                                    TINYINT NOT NULL DEFAULT 0,
   child_connection_count                          INTEGER NOT NULL DEFAULT 0,
   CONSTRAINT ASA281 PRIMARY KEY (
      sample_set_number,
      connection_number )
 );

-- Parents of DBA.rroad_group_2_property_pivot

-- none --

-- Children

-- none --

CREATE INDEX xconnection_id_string ON DBA.rroad_group_2_property_pivot (
   connection_id_string,
   sample_set_number );


Top    Tables: A B C D E G M P R S U

DBA.rroad_monitor_sampler_control

-- DBA.rroad_monitor_sampler_control (table_id 779) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:22AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_monitor_sampler_control ( -- empty
   one_row_only                          /* PK        */ INTEGER NOT NULL DEFAULT 1 
                                                            CONSTRAINT ASA282 CHECK ( "one_row_only" = 1 ),
   previous_foxhound_was_running_until                   TIMESTAMP NOT NULL,
   foxhound_was_running_until                            TIMESTAMP NOT NULL,
   CONSTRAINT ASA283 PRIMARY KEY (
      one_row_only )
 );

-- Parents of DBA.rroad_monitor_sampler_control

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_peaks

-- DBA.rroad_peaks (table_id 781) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:22AM - Foxhound  2017 RisingRoad

-- Note: The table DBA.rroad_peaks has more than one index on
-- columns ( sampling_id ):
--    Primary key     "ASA284"
--    Foreign key     "fk_sampling_options"

CREATE TABLE DBA.rroad_peaks ( -- empty
   sampling_id                                             /* PK FK     */ UNSIGNED INT NOT NULL,
   peaks_calculated_to_sample_set_number                                   UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peaks_calculated_after                                                  TIMESTAMP NOT NULL DEFAULT current timestamp,
   peaks_calculated_after_sample_set_number                                UNSIGNED BIGINT NOT NULL DEFAULT 0,
   earliest_preserved_sample_set_number                                    UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_sample_elapsed_msec                                                BIGINT NOT NULL DEFAULT 0,
   peak_canarian_query_elapsed_msec                                        BIGINT NOT NULL DEFAULT 0,
   peak_ActiveReq                                                          BIGINT NOT NULL DEFAULT 0,
   peak_CheckpointUrgency                                                  BIGINT NOT NULL DEFAULT 0,
   peak_interval_Chkpt                                                     BIGINT NOT NULL DEFAULT 0,
   peak_ConnCount                                                          BIGINT NOT NULL DEFAULT 0,
   peak_CurrIO                                                             BIGINT NOT NULL DEFAULT 0,
   peak_CurrRead                                                           BIGINT NOT NULL DEFAULT 0,
   peak_CurrWrite                                                          BIGINT NOT NULL DEFAULT 0,
   peak_DBFileFragments                                                    BIGINT NOT NULL DEFAULT 0,
   peak_LockCount                                                          BIGINT NOT NULL DEFAULT 0,
   peak_MultiProgrammingLevel                                              BIGINT NOT NULL DEFAULT 0,
   peak_RecoveryUrgency                                                    BIGINT NOT NULL DEFAULT 0,
   peak_UnschReq                                                           BIGINT NOT NULL DEFAULT 0,
   peak_executing_connection_count                                         BIGINT NOT NULL DEFAULT 0,
   peak_idle_connection_count                                              BIGINT NOT NULL DEFAULT 0,
   peak_waiting_connection_count                                           BIGINT NOT NULL DEFAULT 0,
   peak_total_blocked_connection_count                                     BIGINT NOT NULL DEFAULT 0,
   peak_interval_waiting_time                                              DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_total_temporary_file_bytes                                         BIGINT NOT NULL DEFAULT 0,
   peak_rate_Bytes                                                         DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_rate_Disk                                                          DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_rate_BytesReceived                                                 DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_rate_BytesSent                                                     DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_rate_CachePanics                                                   DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_ratio_ReadIndInt                                                   DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0,
   peak_ratio_ReadIndLeaf                                                  DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0,
   peak_ratio_ReadTable                                                    DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0,
   peak_CacheSatisfaction                                                  DECIMAL ( 30, 6 ) NOT NULL DEFAULT 1.0,
   peak_rate_DiskRead                                                      DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_rate_DiskWrite                                                     DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_rate_FullCompare                                                   DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_rate_IndAdd                                                        DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_rate_IndLookup                                                     DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_IndSatisfaction                                                    DECIMAL ( 30, 6 ) NOT NULL DEFAULT 1.0,
   peak_rate_LogWrite                                                      DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_cpu_percentage_string                                              VARCHAR ( 10 ) NOT NULL DEFAULT '',
   peak_cpu_percentage_number                                              DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_rate_QueryLowMemoryStrategy                                        DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_rate_Req                                                           DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_rate_Commit                                                        DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_rate_Rlbk                                                          DECIMAL ( 30, 6 ) NOT NULL DEFAULT 0.0,
   peak_CPU_count                                                          INTEGER NOT NULL DEFAULT 0,
   peak_total_child_connection_count                                       BIGINT NOT NULL DEFAULT 0,
   peak_system_file_bytes                                                  BIGINT NOT NULL DEFAULT 0.0,
   peak_system_file_used_percent                                           DECIMAL ( 30, 1 ) NOT NULL DEFAULT 0.0,
   peak_total_rollback_log_bytes                                           BIGINT NOT NULL DEFAULT 0,
   peak_total_uncommitted_operations                                       BIGINT NOT NULL DEFAULT 0,
   peak_successful_ping_elapsed_msec                                       BIGINT NOT NULL DEFAULT 0,
   peak_sample_elapsed_msec_sample_set_number                              UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_canarian_query_elapsed_msec_sample_set_number                      UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_ActiveReq_sample_set_number                                        UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_CheckpointUrgency_sample_set_number                                UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_interval_Chkpt_sample_set_number                                   UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_ConnCount_sample_set_number                                        UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_CurrIO_sample_set_number                                           UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_CurrRead_sample_set_number                                         UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_CurrWrite_sample_set_number                                        UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_DBFileFragments_sample_set_number                                  UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_LockCount_sample_set_number                                        UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_MultiProgrammingLevel_sample_set_number                            UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_RecoveryUrgency_sample_set_number                                  UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_UnschReq_sample_set_number                                         UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_executing_connection_count_sample_set_number                       UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_idle_connection_count_sample_set_number                            UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_waiting_connection_count_sample_set_number                         UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_total_blocked_connection_count_sample_set_number                   UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_interval_waiting_time_sample_set_number                            UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_total_temporary_file_bytes_sample_set_number                       UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_Bytes_sample_set_number                                       UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_Disk_sample_set_number                                        UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_BytesReceived_sample_set_number                               UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_BytesSent_sample_set_number                                   UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_CachePanics_sample_set_number                                 UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_ratio_ReadIndInt_sample_set_number                                 UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_ratio_ReadIndLeaf_sample_set_number                                UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_ratio_ReadTable_sample_set_number                                  UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_CacheSatisfaction_sample_set_number                                UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_DiskRead_sample_set_number                                    UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_DiskWrite_sample_set_number                                   UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_FullCompare_sample_set_number                                 UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_IndAdd_sample_set_number                                      UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_IndLookup_sample_set_number                                   UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_IndSatisfaction_sample_set_number                                  UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_LogWrite_sample_set_number                                    UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_cpu_percentage_sample_set_number                                   UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_QueryLowMemoryStrategy_sample_set_number                      UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_Req_sample_set_number                                         UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_Commit_sample_set_number                                      UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_rate_Rlbk_sample_set_number                                        UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_CPU_count_sample_set_number                                        UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_total_child_connection_count_sample_set_number                     UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_system_file_bytes_sample_set_number                                UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_system_file_used_percent_sample_set_number                         UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_total_rollback_log_bytes_sample_set_number                         UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_total_uncommitted_operations_sample_set_number                     UNSIGNED BIGINT NOT NULL DEFAULT 0,
   peak_successful_ping_elapsed_msec_sample_set_number                     UNSIGNED BIGINT NOT NULL DEFAULT 0,
   CONSTRAINT ASA284 PRIMARY KEY (
      sampling_id )
 );

-- Parents of DBA.rroad_peaks

-- DBA.rroad_sampling_options

-- Children

-- none --

ALTER TABLE DBA.rroad_peaks ADD CONSTRAINT fk_sampling_options NOT NULL FOREIGN KEY (
      sampling_id )
   REFERENCES DBA.rroad_sampling_options (
      sampling_id )
   ON UPDATE RESTRICT ON DELETE RESTRICT;


Top    Tables: A B C D E G M P R S U

DBA.rroad_ping_log

-- DBA.rroad_ping_log (table_id 763) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:22AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_ping_log ( -- empty
   ping_id                        /* PK        */ UNSIGNED BIGINT NOT NULL,
   ping_log_inserted_at           /*       U   */ TIMESTAMP NOT NULL DEFAULT timestamp,
   sampling_id                    /*       U   */ UNSIGNED INT NOT NULL,
   started_at_sample_set_number   /*         X */ UNSIGNED BIGINT NOT NULL DEFAULT 0,
   connection_string                              VARCHAR ( 1000 ) NOT NULL DEFAULT '',
   ping_elapsed_msec                              BIGINT NOT NULL DEFAULT 0,
   connection_number                              INTEGER NOT NULL DEFAULT 0,
   return_code                                    INTEGER NOT NULL DEFAULT 0,
   diagnostic_code                                INTEGER NOT NULL DEFAULT 0,
   diagnostic_string                              VARCHAR ( 255 ) NOT NULL DEFAULT '',
   CONSTRAINT ASA249 PRIMARY KEY (
      ping_id )
 );

-- Parents of DBA.rroad_ping_log

-- none --

-- Children

-- none --

CREATE UNIQUE INDEX ix_ping_inserted ON DBA.rroad_ping_log (
   ping_log_inserted_at,
   sampling_id );

CREATE CLUSTERED INDEX ix_ping_sample_set ON DBA.rroad_ping_log (
   started_at_sample_set_number );


Top    Tables: A B C D E G M P R S U

DBA.rroad_purge_run

-- DBA.rroad_purge_run (table_id 783) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:22AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_purge_run ( -- empty
   run_number                                   /* PK        */ BIGINT NOT NULL DEFAULT autoincrement,
   diagnostic_location                                          VARCHAR ( 100 ) NOT NULL DEFAULT '[starting]',
   connection_number                                            INTEGER NOT NULL,
   build_number                                                 INTEGER NOT NULL,
   progress                                                     VARCHAR ( 100 ) NOT NULL DEFAULT 'Starting',
   started_at                                                   TIMESTAMP NOT NULL DEFAULT current timestamp,
   is_complete                                                  VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                   CONSTRAINT ASA285 CHECK ( "is_complete" in( 'Y','N' )  ),
   completed_at                                                 TIMESTAMP NOT NULL DEFAULT timestamp,
   must_trigger_next_purge                                      VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                   CONSTRAINT ASA286 CHECK ( "must_trigger_next_purge" in( 'Y','N' )  ),
   sample_purge_interval                                        VARCHAR ( 100 ) NOT NULL DEFAULT '',
   uninteresting_connections_purge_interval                     VARCHAR ( 100 ) NOT NULL DEFAULT '',
   sample_purge_enabled                                         VARCHAR ( 1 ) NOT NULL DEFAULT '',
   sample_purge_after_days                                      INTEGER NOT NULL DEFAULT 0,
   uninteresting_connections_purge_enabled                      VARCHAR ( 1 ) NOT NULL DEFAULT '',
   uninteresting_connections_purge_after_days                   INTEGER NOT NULL DEFAULT 0,
   purge_speed                                                  VARCHAR ( 100 ) NOT NULL DEFAULT '',
   waitfor_delay                                                TIME NULL,
   commit_after_operation_count                                 INTEGER NULL,
   exception_delete_count                                       BIGINT NOT NULL DEFAULT 0,
   orphan_sample_set_delete_count                               BIGINT NOT NULL DEFAULT 0,
   old_sample_set_delete_count                                  BIGINT NOT NULL DEFAULT 0,
   uninteresting_connections_delete_count                       BIGINT NOT NULL DEFAULT 0,
   checkpoint_1_msec                                            BIGINT NOT NULL DEFAULT 0,
   exception_delete_msec                                        BIGINT NOT NULL DEFAULT 0,
   orphan_sample_set_delete_msec                                BIGINT NOT NULL DEFAULT 0,
   old_sample_set_delete_msec                                   BIGINT NOT NULL DEFAULT 0,
   uninteresting_connections_delete_msec                        BIGINT NOT NULL DEFAULT 0,
   checkpoint_2_msec                                            BIGINT NOT NULL DEFAULT 0,
   run_msec                                                     BIGINT NOT NULL 
                                                                   COMPUTE ( "DATEDIFF"("millisecond","started_at","completed_at") ),
   foxhound_page_size                                           BIGINT NOT NULL DEFAULT cast("COALESCE"("DB_PROPERTY"('PageSize'),'0') as bigint),
   foxhound_file_size                                           BIGINT NOT NULL DEFAULT cast("COALESCE"("DB_PROPERTY"('FileSize'),'0') as bigint),
   foxhound_free_pages                                          BIGINT NOT NULL DEFAULT cast("COALESCE"("DB_PROPERTY"('FreePages'),'0') as bigint),
   foxhound_fragments                                           BIGINT NOT NULL DEFAULT cast("COALESCE"("DB_PROPERTY"('DBFileFragments'),'0') as bigint),
   foxhound_file                                                LONG VARCHAR NOT NULL DEFAULT "COALESCE"("DB_PROPERTY"('File'),'???'),
   before_row_count_exception                                   BIGINT NOT NULL DEFAULT -1,
   before_row_count_group_1_property_pivot                      BIGINT NOT NULL DEFAULT -1,
   before_row_count_group_2_property_pivot                      BIGINT NOT NULL DEFAULT -1,
   before_row_count_sample_set                                  BIGINT NOT NULL DEFAULT -1,
   after_row_count_exception                                    BIGINT NOT NULL DEFAULT -1,
   after_row_count_group_1_property_pivot                       BIGINT NOT NULL DEFAULT -1,
   after_row_count_group_2_property_pivot                       BIGINT NOT NULL DEFAULT -1,
   after_row_count_sample_set                                   BIGINT NOT NULL DEFAULT -1,
   before_total_row_count                                       DECIMAL ( 30, 6 ) NOT NULL 
                                                                   COMPUTE ( "before_row_count_exception"
+"before_row_count_group_1_property_pivot"
+"before_row_count_group_2_property_pivot"
+"before_row_count_sample_set" ),
   after_total_row_count                                        DECIMAL ( 30, 6 ) NOT NULL 
                                                                   COMPUTE ( "after_row_count_exception"
+"after_row_count_group_1_property_pivot"
+"after_row_count_group_2_property_pivot"
+"after_row_count_sample_set" ),
   percent_total_row_count_change                               DECIMAL ( 30, 6 ) NOT NULL 
                                                                   COMPUTE ( if "before_total_row_count" = 0 then
  0.0
else(("after_total_row_count"-"before_total_row_count")/"before_total_row_count")*100.0
endif ),
   CONSTRAINT ASA287 PRIMARY KEY (
      run_number )
 );

-- Parents of DBA.rroad_purge_run

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_run_characteristics

-- DBA.rroad_run_characteristics (table_id 742) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:23AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_run_characteristics ( -- empty
   artificial_id                      /* PK        */ INTEGER NOT NULL DEFAULT 1 
                                                         CONSTRAINT ASA80 CHECK ( @artificial_id = 1 ),
   foxhound_db_folder                                 LONG VARCHAR NOT NULL DEFAULT '',
   command_line                                       VARCHAR ( 32766 ) NOT NULL DEFAULT '',
   rroad_dll_name                                     VARCHAR ( 100 ) NOT NULL DEFAULT '',
   safe_mode                                          VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                         CONSTRAINT ASA81 CHECK ( @safe_mode in( 'Y','N' )  ),
   previous_run_probably_stopped_at                   TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   startup_checked_ok_on                              DATE NOT NULL DEFAULT '1900-01-01',
   CONSTRAINT ASA82 PRIMARY KEY (
      artificial_id )
 );

-- Parents of DBA.rroad_run_characteristics

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_sample_set

-- DBA.rroad_sample_set (table_id 785) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:23AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_sample_set ( -- empty
   sampling_id                              /*         X */ UNSIGNED INT NOT NULL,
   sample_set_number                        /* PK      X */ UNSIGNED BIGINT NOT NULL DEFAULT autoincrement,
   sample_lost                                              VARCHAR ( 1 ) NOT NULL DEFAULT 'N',
   connected_ok                                             VARCHAR ( 1 ) NOT NULL DEFAULT 'Y',
   exception_description                                    VARCHAR ( 32767 ) NOT NULL DEFAULT '',
   sample_elapsed_msec                                      BIGINT NOT NULL 
                                                               COMPUTE ( "DATEDIFF"("millisecond","sample_started_at","sample_finished_at") ),
   canarian_query_elapsed_msec                              BIGINT NOT NULL 
                                                               COMPUTE ( "DATEDIFF"("millisecond","canarian_query_started_at","canarian_query_finished_at") ),
   sample_started_at                        /*         X */ TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   sample_finished_at                                       TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   canarian_query_started_at                                TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   canarian_query_finished_at                               TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   datediff_msec_between_target_and_local                   BIGINT NOT NULL DEFAULT 0,
   CONSTRAINT ASA288 PRIMARY KEY (
      sample_set_number )
 );

-- Parents of DBA.rroad_sample_set

-- none --

-- Children

-- none --

CREATE INDEX ix_id_number ON DBA.rroad_sample_set (
   sampling_id,
   sample_set_number DESC );

CREATE INDEX ix_id_started ON DBA.rroad_sample_set (
   sampling_id,
   sample_started_at );

CREATE CLUSTERED INDEX ix_sample_started_at ON DBA.rroad_sample_set (
   sample_started_at );

CREATE INDEX ix_sampling_id ON DBA.rroad_sample_set (
   sampling_id );


Top    Tables: A B C D E G M P R S U

DBA.rroad_sampling_options

-- DBA.rroad_sampling_options (table_id 787) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:23AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_sampling_options ( -- empty
   sampling_id                                              /* PK        */ UNSIGNED INT NOT NULL DEFAULT autoincrement,
   selected_tab                                             /*       U   */ VARCHAR ( 1 ) NOT NULL 
                                                                               CONSTRAINT ASA289 CHECK ( @selected_tab in( '1','2' )  ),
   selected_name                                            /*       U   */ VARCHAR ( 128 ) NOT NULL,
   selected_dsn                                                             VARCHAR ( 128 ) NOT NULL,
   selected_connection_string_name                                          VARCHAR ( 128 ) NOT NULL,
   u1                                                                       LONG VARCHAR NULL,
   p1                                                                       LONG VARCHAR NULL,
   p2                                                                       LONG VARCHAR NULL,
   sampling_should_be_running                                               VARCHAR ( 1 ) NOT NULL DEFAULT 'Y',
   timed_out                                                                VARCHAR ( 1 ) NOT NULL DEFAULT 'N',
   timeout_retry_at                                                         TIMESTAMP NULL DEFAULT current timestamp,
   connection_status_message                                                VARCHAR ( 32767 ) NOT NULL 
                                                                               COMPUTE ( case when "ping_only_sampling_in_progress" = 'N' and "sampling_should_be_running" = 'Y' and "connected_ok" = 'Y' then 'Sampling OK'
when "ping_only_sampling_in_progress" = 'N' and "sampling_should_be_running" = 'Y' and "connected_ok" = 'N' and "timed_out" = 'N' and "connection_errormsg" = '' then 'Sampling starting...'
when "ping_only_sampling_in_progress" = 'N' and "sampling_should_be_running" = 'Y' and "connected_ok" = 'N' and "timed_out" = 'N' then "connection_errormsg"
when "sampling_should_be_running" = 'N' then 'Sampling stopped'
when "ping_only_sampling_in_progress" = 'N' and "timed_out" = 'Y' then 'Timed out'
when "ping_only_sampling_in_progress" = 'Y' and "connection_errormsg" = '' then 'Ping OK'
else "connection_errormsg"
end ),
   rroad_monitor_sample_loop_connection_number                              INTEGER NOT NULL DEFAULT 0,
   fatal_error_message                                                      LONG VARCHAR NOT NULL DEFAULT '',
   connected_ok                                                             VARCHAR ( 1 ) NOT NULL DEFAULT 'N',
   connection_errormsg                                                      VARCHAR ( 32767 ) NOT NULL DEFAULT '(not connected yet)',
   last_sample_elapsed_msec                                                 BIGINT NOT NULL 
                                                                               COMPUTE ( "DATEDIFF"("millisecond","last_sample_started_at","last_sample_finished_at") ),
   last_canarian_query_elapsed_msec                                         BIGINT NOT NULL 
                                                                               COMPUTE ( "DATEDIFF"("millisecond","last_canarian_query_started_at","last_canarian_query_finished_at") ),
   last_sample_started_at                                                   TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   last_sample_finished_at                                                  TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   last_canarian_query_started_at                                           TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   last_canarian_query_finished_at                                          TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   current_database_version                                                 LONG VARCHAR NOT NULL DEFAULT '',
   current_engine_version                                                   LONG VARCHAR NOT NULL DEFAULT '',
   proxy_owner                                                              VARCHAR ( 128 ) NULL,
   page_size                                                                INTEGER NOT NULL DEFAULT 4096,
   ok_to_create_rroad_engine_properties                                     VARCHAR ( 1 ) NOT NULL DEFAULT 'N',
   ok_to_create_rroad_database_properties                                   VARCHAR ( 1 ) NOT NULL DEFAULT 'N',
   ok_to_create_rroad_connection_properties                                 VARCHAR ( 1 ) NOT NULL DEFAULT 'N',
   connected_user_id                                                        VARCHAR ( 128 ) NOT NULL DEFAULT '',
   user_request                                                             VARCHAR ( 100 ) NOT NULL DEFAULT '',
   GlobalDBId                                                               BIGINT NOT NULL DEFAULT 0,
   connection_order_by_column_title                                         LONG VARCHAR NOT NULL DEFAULT 'Conn #',
   connection_order_by_direction                                            VARCHAR ( 4 ) NOT NULL DEFAULT 'ASC' 
                                                                               CONSTRAINT ASA290 CHECK ( @connection_order_by_direction in( 'ASC','DESC' )  ),
   purge_uninteresting_connections_from_sample_set_number                   UNSIGNED BIGINT NOT NULL DEFAULT 0,
   schedule_request                                                         VARCHAR ( 100 ) NOT NULL DEFAULT '',
   history_goto                                                             VARCHAR ( 100 ) NOT NULL DEFAULT '',
   connection_history_goto                                                  VARCHAR ( 100 ) NOT NULL DEFAULT '',
   ping_only_sample_set_number                                              UNSIGNED BIGINT NOT NULL DEFAULT 0,
   ping_only_sampling_in_progress                                           VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                                               CONSTRAINT ASA291 CHECK ( @ping_only_sampling_in_progress in( 'Y','N' )  ),
   CONSTRAINT ASA292 PRIMARY KEY (
      sampling_id ),
   CONSTRAINT ASA293 UNIQUE (
      selected_tab,
      selected_name )
 );

-- Parents of DBA.rroad_sampling_options

-- none --

-- Children

-- DBA.rroad_peaks
-- DBA.rroad_session_options


Top    Tables: A B C D E G M P R S U

DBA.rroad_schedule

-- DBA.rroad_schedule (table_id 789) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:23AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_schedule ( -- empty
   schedule_id             /* PK        */ INTEGER NOT NULL DEFAULT autoincrement,
   criteria_set_type       /*    FK U   */ VARCHAR ( 100 ) NOT NULL,
   sampling_id             /*    FK U   */ UNSIGNED INT NOT NULL,
   schedule_type           /*       U   */ VARCHAR ( 100 ) NOT NULL 
                                              CONSTRAINT ASA294 CHECK ( @schedule_id in( 
'Sample',
'Connection',
'Alerts',
'AutoDrop' )  ),
   enforce_this_schedule                   VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                              CONSTRAINT ASA295 CHECK ( @enforce_this_schedule in( 'Y','N' )  ),
   CONSTRAINT ASA296 PRIMARY KEY (
      schedule_id ),
   CONSTRAINT ASA297 UNIQUE (
      criteria_set_type,
      sampling_id,
      schedule_type )
 );

-- Parents of DBA.rroad_schedule

-- DBA.rroad_alerts_criteria

-- Children

-- DBA.rroad_schedule_day_entry
-- DBA.rroad_schedule_period_entry

ALTER TABLE DBA.rroad_schedule ADD CONSTRAINT rroad_alerts_criteria NOT NULL FOREIGN KEY (
      criteria_set_type,
      sampling_id )
   REFERENCES DBA.rroad_alerts_criteria (
      criteria_set_type,
      sampling_id )
   ON UPDATE RESTRICT ON DELETE CASCADE;


Top    Tables: A B C D E G M P R S U

DBA.rroad_schedule_day_entry

-- DBA.rroad_schedule_day_entry (table_id 791) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:23AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_schedule_day_entry ( -- empty
   schedule_id   /* PK FK     */ INTEGER NOT NULL,
   day_number    /* PK        */ INTEGER NOT NULL 
                                    CONSTRAINT ASA299 CHECK ( @day_number between 1 and 7 ),
   day_name                      VARCHAR ( 10 ) NOT NULL,
   day_string                    VARCHAR ( 96 ) NOT NULL,
   CONSTRAINT ASA300 PRIMARY KEY (
      schedule_id,
      day_number )
 );

-- Parents of DBA.rroad_schedule_day_entry

-- DBA.rroad_schedule

-- Children

-- none --

ALTER TABLE DBA.rroad_schedule_day_entry ADD CONSTRAINT rroad_schedule NOT NULL FOREIGN KEY (
      schedule_id )
   REFERENCES DBA.rroad_schedule (
      schedule_id )
   ON UPDATE RESTRICT ON DELETE CASCADE;


Top    Tables: A B C D E G M P R S U

DBA.rroad_schedule_period_entry

-- DBA.rroad_schedule_period_entry (table_id 793) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:23AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_schedule_period_entry ( -- empty
   schedule_id     /* PK FK     */ INTEGER NOT NULL,
   period_number   /* PK        */ INTEGER NOT NULL,
   period_code                     VARCHAR ( 1 ) NOT NULL DEFAULT 'Y',
   CONSTRAINT ASA302 PRIMARY KEY (
      schedule_id,
      period_number )
 );

-- Parents of DBA.rroad_schedule_period_entry

-- DBA.rroad_schedule

-- Children

-- none --

ALTER TABLE DBA.rroad_schedule_period_entry ADD CONSTRAINT rroad_schedule NOT NULL FOREIGN KEY (
      schedule_id )
   REFERENCES DBA.rroad_schedule (
      schedule_id )
   ON UPDATE RESTRICT ON DELETE CASCADE;


Top    Tables: A B C D E G M P R S U

DBA.rroad_serial_number

-- DBA.rroad_serial_number (table_id 795) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:23AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_serial_number ( -- empty
   one_row_only    /* PK        */ INTEGER NOT NULL DEFAULT 1 
                                      CONSTRAINT ASA304 CHECK ( "one_row_only" = 1 ),
   key_type                        VARCHAR ( 1 ) NOT NULL 
                                      CONSTRAINT ASA305 CHECK ( @key_type in( 'R',
'S',
'X',
'U',
'J',
'K' )  ),
   serial_number                   LONG VARCHAR NOT NULL,
   CONSTRAINT ASA306 PRIMARY KEY (
      one_row_only )
 );

-- Parents of DBA.rroad_serial_number

-- none --

-- Children

-- none --


Top    Tables: A B C D E G M P R S U

DBA.rroad_session_options

-- DBA.rroad_session_options (table_id 744) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:23AM - Foxhound  2017 RisingRoad
CREATE TABLE DBA.rroad_session_options ( -- empty
   session_id                            /* PK        */ VARCHAR ( 36 ) NOT NULL,
   integer_session_id                    /*       U   */ INTEGER NOT NULL DEFAULT autoincrement,
   sampling_id                           /*    FK     */ UNSIGNED INT NULL,
   list_refresh_count                                    BIGINT NOT NULL DEFAULT 0,
   display_refresh_count                                 BIGINT NOT NULL DEFAULT 0,
   display_running                                       VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                            CONSTRAINT ASA83 CHECK ( @display_running in( 'Y','N' )  ),
   samples_have_been_deleted                             VARCHAR ( 1 ) NOT NULL DEFAULT 'N' 
                                                            CONSTRAINT ASA84 CHECK ( @samples_have_been_deleted in( 'Y','N' )  ),
   selected_tab                                          VARCHAR ( 1 ) NOT NULL DEFAULT '1' 
                                                            CONSTRAINT ASA85 CHECK ( @selected_tab in( '1','2','3' )  ),
   selected_dsn                                          VARCHAR ( 128 ) NOT NULL,
   selected_connection_string_name                       VARCHAR ( 128 ) NOT NULL,
   include_system_owners                                 VARCHAR ( 1 ) NOT NULL,
   show_all_dsns                                         VARCHAR ( 1 ) NOT NULL,
   s1                                                    VARCHAR ( 1 ) NULL,
   z1                                                    LONG VARCHAR NULL,
   c1                                                    LONG VARCHAR NULL,
   u1                                                    LONG VARCHAR NULL,
   p1                                                    LONG VARCHAR NULL,
   sf1                                                   LONG VARCHAR NULL,
   i1                                                    LONG VARCHAR NULL,
   z2                                                    LONG VARCHAR NULL,
   c2                                                    LONG VARCHAR NULL,
   n2                                                    LONG VARCHAR NULL,
   s2                                                    LONG VARCHAR NULL,
   p2                                                    LONG VARCHAR NULL,
   sf2                                                   LONG VARCHAR NULL,
   i2                                                    LONG VARCHAR NULL,
   current_database_version                              LONG VARCHAR NOT NULL DEFAULT '',
   current_database_timestamp                            TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   current_upgraded_database_version                     LONG VARCHAR NOT NULL DEFAULT '',
   current_upgraded_database_timestamp                   TIMESTAMP NOT NULL DEFAULT '1900-01-01',
   current_engine_version                                LONG VARCHAR NOT NULL DEFAULT '',
   proxy_owner                                           VARCHAR ( 128 ) NOT NULL,
   page_size                                             INTEGER NOT NULL DEFAULT 4096,
   menu_monitor_refresh_enabled                          VARCHAR ( 1 ) NOT NULL DEFAULT 'Y' 
                                                            CONSTRAINT ASA86 CHECK ( "menu_monitor_refresh_enabled" in( 'Y','N' )  ),
   CONSTRAINT ASA87 PRIMARY KEY (
      session_id ),
   CONSTRAINT ASA88 UNIQUE (
      integer_session_id )
 );

-- Parents of DBA.rroad_session_options

-- DBA.rroad_sampling_options

-- Children

-- none --

ALTER TABLE DBA.rroad_session_options ADD CONSTRAINT fk_rroad_sampling_options FOREIGN KEY (
      sampling_id )
   REFERENCES DBA.rroad_sampling_options (
      sampling_id )
   ON UPDATE RESTRICT ON DELETE SET NULL;


Top    Tables: A B C D E G M P R S U

DBA.run_characteristics

-- DBA.run_characteristics (table_id 743) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:23AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.run_characteristics (
--    artificial_id,                     -- INTEGER
--    foxhound_db_folder,                -- LONG VARCHAR
--    command_line,                      -- VARCHAR ( 32766 )
--    rroad_dll_name,                    -- VARCHAR ( 100 )
--    safe_mode,                         -- VARCHAR ( 1 )
--    previous_run_probably_stopped_at,  -- TIMESTAMP
--    startup_checked_ok_on )            -- DATE

create VIEW run_characteristics AS SELECT * FROM rroad_run_characteristics
----------------------------------------------------------------------------------------------------- 
-- run_characteristics -- Foxhound Version 4 Changes...
----------------------------------------------------------------------------------------------------- 
-- New column: startup_checked_ok_on DATE
;


Top    Tables: A B C D E G M P R S U

DBA.sample_connection

-- DBA.sample_connection (table_id 778) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:23AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.sample_connection (
--    sampling_id,                    -- UNSIGNED INT
--    sample_set_number,              -- UNSIGNED BIGINT
--    connection_number,              -- BIGINT
--    connection_id_string,           -- VARCHAR ( 50 )
--    blocker_owner_table_name,       -- VARCHAR ( 257 )
--    blocker_lock_type,              -- VARCHAR ( 32 )
--    blocker_owner_name,             -- VARCHAR ( 128 )
--    blocker_table_name,             -- VARCHAR ( 128 )
--    blocker_reason,                 -- LONG VARCHAR
--    blocker_row_identifier,         -- VARCHAR ( 32 )
--    current_engine_version,         -- LONG VARCHAR
--    page_size,                      -- INTEGER
--    ApproximateCPUTime,             -- DECIMAL ( 30, 6 )
--    BlockedOn,                      -- BIGINT
--    BytesReceived,                  -- BIGINT
--    BytesSent,                      -- BIGINT
--    CacheHits,                      -- BIGINT
--    CacheRead,                      -- BIGINT
--    CacheReadIndInt,                -- BIGINT
--    CacheReadIndLeaf,               -- BIGINT
--    CacheReadTable,                 -- BIGINT
--    ClientStmtCacheHits,            -- BIGINT
--    ClientStmtCacheMisses,          -- BIGINT
--    "Commit",                       -- BIGINT
--    CurrentLineNumber,              -- BIGINT
--    CurrentProcedure,               -- LONG VARCHAR
--    Dedicated_task,                 -- LONG VARCHAR
--    DiskRead,                       -- BIGINT
--    DiskReadIndInt,                 -- BIGINT
--    DiskReadIndLeaf,                -- BIGINT
--    DiskReadTable,                  -- BIGINT
--    DiskWrite,                      -- BIGINT
--    FullCompare,                    -- BIGINT
--    IndAdd,                         -- BIGINT
--    IndLookup,                      -- BIGINT
--    Isolation_level,                -- LONG VARCHAR
--    LastReqTime,                    -- LONG VARCHAR
--    LastStatement,                  -- LONG VARCHAR
--    LastPlanText,                   -- LONG VARCHAR
--    LockCount,                      -- BIGINT
--    LockName,                       -- BIGINT
--    LockObjectOID,                  -- BIGINT
--    LockObjectType,                 -- BIGINT
--    LockRowID,                      -- BIGINT
--    LockTableOID,                   -- BIGINT
--    LoginTime,                      -- LONG VARCHAR
--    LogWrite,                       -- BIGINT
--    max_client_statements_cached,   -- BIGINT
--    Max_plans_cached,               -- BIGINT
--    max_query_tasks,                -- BIGINT
--    Name,                           -- VARCHAR ( 128 )
--    NodeAddress,                    -- LONG VARCHAR
--    OSUser,                         -- LONG VARCHAR
--    ParentConnection,               -- BIGINT
--    Prepares,                       -- BIGINT
--    PrepStmt,                       -- BIGINT
--    priority,                       -- LONG VARCHAR
--    QueryHeapPages,                 -- BIGINT
--    QueryLowMemoryStrategy,         -- BIGINT
--    QueryOptimized,                 -- BIGINT
--    QueryReused,                    -- BIGINT
--    ReqCountActive,                 -- BIGINT
--    ReqStatus,                      -- LONG VARCHAR
--    ReqTimeActive,                  -- DECIMAL ( 30, 6 )
--    ReqTimeBlockContention,         -- DECIMAL ( 30, 6 )
--    ReqTimeBlockIO,                 -- DECIMAL ( 30, 6 )
--    ReqTimeBlockLock,               -- DECIMAL ( 30, 6 )
--    ReqTimeUnscheduled,             -- DECIMAL ( 30, 6 )
--    ReqType,                        -- LONG VARCHAR
--    RequestsReceived,               -- BIGINT
--    Rlbk,                           -- BIGINT
--    RollbackLogPages,               -- BIGINT
--    TempFilePages,                  -- BIGINT
--    TransactionStartTime,           -- LONG VARCHAR
--    UncommitOp,                     -- BIGINT
--    updatable_statement_isolation,  -- LONG VARCHAR
--    Userid,                         -- VARCHAR ( 128 )
--    interval_ApproximateCPUTime,    -- DECIMAL ( 30, 6 )
--    ratio_ReadIndInt,               -- DECIMAL ( 30, 6 )
--    ratio_ReadIndLeaf,              -- DECIMAL ( 30, 6 )
--    ratio_ReadTable,                -- DECIMAL ( 30, 6 )
--    interval_Commit,                -- BIGINT
--    rate_bytes,                     -- DECIMAL ( 30, 6 )
--    rate_Commit,                    -- DECIMAL ( 30, 6 )
--    rate_ReqCountActive,            -- DECIMAL ( 30, 6 )
--    rate_DiskRead,                  -- DECIMAL ( 30, 6 )
--    rate_DiskWrite,                 -- DECIMAL ( 30, 6 )
--    rate_FullCompare,               -- DECIMAL ( 30, 6 )
--    rate_IndAdd,                    -- DECIMAL ( 30, 6 )
--    rate_IndLookup,                 -- DECIMAL ( 30, 6 )
--    rate_LogWrite,                  -- DECIMAL ( 30, 6 )
--    blocked_connection_count,       -- BIGINT
--    current_req_status,             -- VARCHAR ( 100 )
--    cache_satisfaction,             -- DECIMAL ( 30 )
--    time_connected,                 -- BIGINT
--    waiting_time,                   -- DECIMAL ( 30, 6 )
--    transaction_running_time,       -- BIGINT
--    time_since_last_request,        -- BIGINT
--    index_satisfaction,             -- DECIMAL ( 30 )
--    autodrop_reason,                -- LONG VARCHAR
--    autodrop_result,                -- LONG VARCHAR
--    interval_CPU_percent,           -- DECIMAL ( 30, 1 )
--    busy_percent,                   -- TINYINT
--    wait_percent,                   -- TINYINT
--    idle_percent,                   -- TINYINT
--    child_connection_count )        -- INTEGER

create VIEW sample_connection AS SELECT * FROM rroad_group_2_property_pivot
----------------------------------------------------------------------------------------------------- 
-- sample_connection -- Foxhound Version 4 Changes...
----------------------------------------------------------------------------------------------------- 
-- Removed:    ReqCountBlockContention      BIGINT
-- Removed:    ReqCountBlockIO              BIGINT
-- Removed:    ReqCountBlockLock            BIGINT
-- Removed:    ReqCountUnscheduled          BIGINT
-- Removed:    previous_ApproximateCPUTime  DECIMAL ( 30, 6 )
-- Removed:    previous_Commit              BIGINT
-- Removed:    previous_Rlbk                BIGINT
-- Removed:    interval_Rlbk                BIGINT
-- Removed:    total_waits                  BIGINT
-- New column: CacheReadIndInt              BIGINT
-- New column: CacheReadIndLeaf             BIGINT
-- New column: CacheReadTable               BIGINT
-- New column: ClientStmtCacheHits          BIGINT
-- New column: ClientStmtCacheMisses        BIGINT
-- New column: CurrentLineNumber            BIGINT
-- New column: CurrentProcedure             LONG VARCHAR
-- New column: Dedicated_task               LONG VARCHAR
-- New column: DiskReadIndInt               BIGINT
-- New column: DiskReadIndLeaf              BIGINT
-- New column: DiskReadTable                BIGINT
-- New column: LockObjectOID                BIGINT
-- New column: LockObjectType               BIGINT
-- New column: max_client_statements_cached BIGINT
-- New column: Max_plans_cached             BIGINT
-- New column: max_query_tasks              BIGINT
-- New column: priority                     LONG VARCHAR
-- New column: QueryHeapPages               BIGINT
-- New column: ratio_ReadIndInt             DECIMAL ( 30, 6 )
-- New column: ratio_ReadIndLeaf            DECIMAL ( 30, 6 )
-- New column: ratio_ReadTable              DECIMAL ( 30, 6 )
-- New column: rate_bytes                   DECIMAL ( 30, 6 )
-- New column: rate_Commit                  DECIMAL ( 30, 6 )
-- New column: rate_ReqCountActive          DECIMAL ( 30, 6 )
-- New column: rate_DiskRead                DECIMAL ( 30, 6 )
-- New column: rate_DiskWrite               DECIMAL ( 30, 6 )
-- New column: rate_FullCompare             DECIMAL ( 30, 6 )
-- New column: rate_IndAdd                  DECIMAL ( 30, 6 )
-- New column: rate_IndLookup               DECIMAL ( 30, 6 )
-- New column: rate_LogWrite                DECIMAL ( 30, 6 )
;


Top    Tables: A B C D E G M P R S U

DBA.sample_detail

-- DBA.sample_detail (table_id 776) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:23AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.sample_detail (
--    sampling_id,                               -- UNSIGNED INT
--    sample_set_number,                         -- UNSIGNED BIGINT
--    sample_lost,                               -- VARCHAR ( 1 )
--    connected_ok,                              -- VARCHAR ( 1 )
--    exception_description,                     -- VARCHAR ( 32767 )
--    sample_elapsed_msec,                       -- BIGINT
--    canarian_query_elapsed_msec,               -- BIGINT
--    datediff_msec_between_target_and_local,    -- BIGINT
--    sample_recorded_at,                        -- TIMESTAMP
--    current_database_version,                  -- LONG VARCHAR
--    current_engine_version,                    -- LONG VARCHAR
--    page_size,                                 -- INTEGER
--    proxy_rroad_engine_properties_exists,      -- VARCHAR ( 1 )
--    proxy_rroad_database_properties_exists,    -- VARCHAR ( 1 )
--    proxy_rroad_connection_properties_exists,  -- VARCHAR ( 1 )
--    system_free_bytes,                         -- UNSIGNED BIGINT
--    temp_file_free_bytes,                      -- UNSIGNED BIGINT
--    log_free_bytes,                            -- UNSIGNED BIGINT
--    min_other_free_bytes,                      -- UNSIGNED BIGINT
--    ArbiterState,                              -- LONG VARCHAR
--    ActiveReq,                                 -- BIGINT
--    BytesReceived,                             -- BIGINT
--    BytesSent,                                 -- BIGINT
--    CacheHits,                                 -- BIGINT
--    CachePanics,                               -- BIGINT
--    CacheRead,                                 -- BIGINT
--    CacheReadIndInt,                           -- BIGINT
--    CacheReadIndLeaf,                          -- BIGINT
--    CacheReadTable,                            -- BIGINT
--    CheckpointLogSize,                         -- BIGINT
--    CheckpointUrgency,                         -- BIGINT
--    Chkpt,                                     -- BIGINT
--    ConnCount,                                 -- BIGINT
--    CurrentCacheSize,                          -- BIGINT
--    CurrIO,                                    -- BIGINT
--    CurrRead,                                  -- BIGINT
--    CurrWrite,                                 -- BIGINT
--    DBFileFragments,                           -- BIGINT
--    DiskRead,                                  -- BIGINT
--    DiskReadIndInt,                            -- BIGINT
--    DiskReadIndLeaf,                           -- BIGINT
--    DiskReadTable,                             -- BIGINT
--    DiskWrite,                                 -- BIGINT
--    File,                                      -- LONG VARCHAR
--    FileSize,                                  -- BIGINT
--    FreePages,                                 -- BIGINT
--    FullCompare,                               -- BIGINT
--    GlobalDBId,                                -- BIGINT
--    IndAdd,                                    -- BIGINT
--    IndLookup,                                 -- BIGINT
--    LockCount,                                 -- BIGINT
--    LogWrite,                                  -- BIGINT
--    MachineName,                               -- LONG VARCHAR
--    MaxCacheSize,                              -- BIGINT
--    MirrorMode,                                -- LONG VARCHAR
--    MirrorState,                               -- LONG VARCHAR
--    MultiProgrammingLevel,                     -- BIGINT
--    Name,                                      -- LONG VARCHAR
--    NumLogicalProcessorsUsed,                  -- BIGINT
--    NumProcessorsAvail,                        -- BIGINT
--    PartnerState,                              -- LONG VARCHAR
--    ProcessCPU,                                -- DECIMAL ( 30, 6 )
--    QueryLowMemoryStrategy,                    -- BIGINT
--    ReadOnly,                                  -- LONG VARCHAR
--    RecoveryUrgency,                           -- BIGINT
--    RememberLastPlan,                          -- LONG VARCHAR
--    RememberLastStatement,                     -- LONG VARCHAR
--    Req,                                       -- BIGINT
--    RequestTiming,                             -- LONG VARCHAR
--    ServerName,                                -- LONG VARCHAR
--    SnapshotIsolationState,                    -- LONG VARCHAR
--    StartTime,                                 -- LONG VARCHAR
--    UnschReq,                                  -- BIGINT
--    interval_msec,                             -- BIGINT
--    interval_BytesReceived,                    -- BIGINT
--    interval_BytesSent,                        -- BIGINT
--    interval_CacheHits,                        -- BIGINT
--    interval_CachePanics,                      -- BIGINT
--    interval_CacheRead,                        -- BIGINT
--    ratio_ReadIndInt,                          -- DECIMAL ( 30, 6 )
--    ratio_ReadIndLeaf,                         -- DECIMAL ( 30, 6 )
--    ratio_ReadTable,                           -- DECIMAL ( 30, 6 )
--    interval_Chkpt,                            -- BIGINT
--    interval_DiskRead,                         -- BIGINT
--    interval_DiskWrite,                        -- BIGINT
--    interval_FullCompare,                      -- BIGINT
--    interval_IndAdd,                           -- BIGINT
--    interval_IndLookup,                        -- BIGINT
--    interval_LogWrite,                         -- BIGINT
--    interval_ProcessCPU,                       -- DECIMAL ( 30, 6 )
--    interval_QueryLowMemoryStrategy,           -- BIGINT
--    interval_Req,                              -- BIGINT
--    executing_connection_count,                -- BIGINT
--    idle_connection_count,                     -- BIGINT
--    waiting_connection_count,                  -- BIGINT
--    total_blocked_connection_count,            -- BIGINT
--    total_waiting_time,                        -- DECIMAL ( 30, 6 )
--    interval_waiting_time,                     -- DECIMAL ( 30, 6 )
--    total_temporary_file_pages,                -- BIGINT
--    "Commit",                                  -- BIGINT
--    interval_Commit,                           -- BIGINT
--    Rlbk,                                      -- BIGINT
--    interval_CPU_percent,                      -- DECIMAL ( 30, 1 )
--    CPU_count,                                 -- INTEGER
--    autodropped_connection_count,              -- INTEGER
--    foxhound_connection_count,                 -- INTEGER
--    total_child_connection_count,              -- INTEGER
--    system_file_used_percent,                  -- DECIMAL ( 30, 1 )
--    total_rollback_log_pages,                  -- BIGINT
--    total_uncommitted_operations,              -- BIGINT
--    ping_id,                                   -- UNSIGNED BIGINT
--    ping_was_successful,                       -- VARCHAR ( 1 )
--    successful_ping_elapsed_msec,              -- BIGINT
--    LogFileFragments,                          -- BIGINT
--    logFileSize,                               -- BIGINT
--    logFreePages,                              -- BIGINT
--    LogName,                                   -- LONG VARCHAR
--    tempFileFragments,                         -- BIGINT
--    TempFileName,                              -- LONG VARCHAR
--    tempFileSize,                              -- BIGINT
--    tempFreePages )                            -- BIGINT

create VIEW sample_detail AS SELECT * FROM rroad_group_1_property_pivot
----------------------------------------------------------------------------------------------------- 
-- sample_detail -- Foxhound Version 4 Changes...
----------------------------------------------------------------------------------------------------- 
-- Removed:    interval_Rlbk                BIGINT
-- New column: CacheReadIndInt              BIGINT
-- New column: CacheReadIndLeaf             BIGINT
-- New column: CacheReadTable               BIGINT
-- New column: CheckpointLogSize            BIGINT
-- New column: CurrRead                     BIGINT
-- New column: CurrWrite                    BIGINT
-- New column: DiskReadIndInt               BIGINT
-- New column: DiskReadIndLeaf              BIGINT
-- New column: DiskReadTable                BIGINT
-- New column: GlobalDBId                   BIGINT
-- New column: SnapshotIsolationState       LONG VARCHAR
-- New column: ratio_ReadIndInt             DECIMAL ( 30, 6 )
-- New column: ratio_ReadIndLeaf            DECIMAL ( 30, 6 )
-- New column: ratio_ReadTable              DECIMAL ( 30, 6 )
-- New column: ping_id                      UNSIGNED BIGINT
-- New column: ping_was_successful          VARCHAR ( 1 )
-- New column: successful_ping_elapsed_msec BIGINT
;


Top    Tables: A B C D E G M P R S U

DBA.sample_header

-- DBA.sample_header (table_id 786) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:24AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.sample_header (
--    sampling_id,                             -- UNSIGNED INT
--    sample_set_number,                       -- UNSIGNED BIGINT
--    sample_lost,                             -- VARCHAR ( 1 )
--    connected_ok,                            -- VARCHAR ( 1 )
--    exception_description,                   -- VARCHAR ( 32767 )
--    sample_elapsed_msec,                     -- BIGINT
--    canarian_query_elapsed_msec,             -- BIGINT
--    sample_started_at,                       -- TIMESTAMP
--    sample_finished_at,                      -- TIMESTAMP
--    canarian_query_started_at,               -- TIMESTAMP
--    canarian_query_finished_at,              -- TIMESTAMP
--    datediff_msec_between_target_and_local ) -- BIGINT

create VIEW sample_header AS SELECT * FROM rroad_sample_set
;


Top    Tables: A B C D E G M P R S U

DBA.sampling_options

-- DBA.sampling_options (table_id 788) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:24AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.sampling_options (
--    sampling_id,                                             -- UNSIGNED INT
--    selected_tab,                                            -- VARCHAR ( 1 )
--    selected_name,                                           -- VARCHAR ( 128 )
--    sampling_should_be_running,                              -- VARCHAR ( 1 )
--    timed_out,                                               -- VARCHAR ( 1 )
--    timeout_retry_at,                                        -- TIMESTAMP
--    connection_status_message,                               -- VARCHAR ( 32767 )
--    rroad_monitor_sample_loop_connection_number,             -- INTEGER
--    fatal_error_message,                                     -- LONG VARCHAR
--    connected_ok,                                            -- VARCHAR ( 1 )
--    connection_errormsg,                                     -- VARCHAR ( 32767 )
--    last_sample_elapsed_msec,                                -- BIGINT
--    last_canarian_query_elapsed_msec,                        -- BIGINT
--    last_sample_started_at,                                  -- TIMESTAMP
--    last_sample_finished_at,                                 -- TIMESTAMP
--    last_canarian_query_started_at,                          -- TIMESTAMP
--    last_canarian_query_finished_at,                         -- TIMESTAMP
--    current_database_version,                                -- LONG VARCHAR
--    current_engine_version,                                  -- LONG VARCHAR
--    proxy_owner,                                             -- VARCHAR ( 128 )
--    page_size,                                               -- INTEGER
--    ok_to_create_rroad_engine_properties,                    -- VARCHAR ( 1 )
--    ok_to_create_rroad_database_properties,                  -- VARCHAR ( 1 )
--    ok_to_create_rroad_connection_properties,                -- VARCHAR ( 1 )
--    connected_user_id,                                       -- VARCHAR ( 128 )
--    user_request,                                            -- VARCHAR ( 100 )
--    connection_order_by_column_title,                        -- LONG VARCHAR
--    connection_order_by_direction,                           -- VARCHAR ( 4 )
--    purge_uninteresting_connections_from_sample_set_number,  -- UNSIGNED BIGINT
--    schedule_request,                                        -- VARCHAR ( 100 )
--    history_goto,                                            -- VARCHAR ( 100 )
--    connection_history_goto,                                 -- VARCHAR ( 100 )
--    ping_only_sample_set_number,                             -- UNSIGNED BIGINT
--    ping_only_sampling_in_progress )                         -- VARCHAR ( 1 )

create VIEW sampling_options AS 
SELECT 
      sampling_id,
      selected_tab,
      selected_name,

      sampling_should_be_running,
      timed_out,
      timeout_retry_at,

      connection_status_message,

      rroad_monitor_sample_loop_connection_number,
      fatal_error_message,
      connected_ok,
      connection_errormsg,
      last_sample_elapsed_msec,
      last_canarian_query_elapsed_msec,

      last_sample_started_at,
      last_sample_finished_at,
      last_canarian_query_started_at,
      last_canarian_query_finished_at,
      current_database_version,
      current_engine_version,
      proxy_owner,
      page_size,
      ok_to_create_rroad_engine_properties,
      ok_to_create_rroad_database_properties,
      ok_to_create_rroad_connection_properties,

      connected_user_id,
      user_request,

      connection_order_by_column_title,
      connection_order_by_direction,
      purge_uninteresting_connections_from_sample_set_number,
      schedule_request,
      history_goto,
      connection_history_goto, 

      ping_only_sample_set_number,
      ping_only_sampling_in_progress

FROM rroad_sampling_options
----------------------------------------------------------------------------------------------------- 
-- sampling_options -- Foxhound Version 4 Changes...
----------------------------------------------------------------------------------------------------- 
-- Removed:    GlobalDBId                     BIGINT
-- New column: ping_only_sample_set_number    UNSIGNED BIGINT
-- New column: ping_only_sampling_in_progress VARCHAR ( 1 )
;


Top    Tables: A B C D E G M P R S U

DBA.schedule

-- DBA.schedule (table_id 790) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:24AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.schedule (
--    schedule_id,            -- INTEGER
--    criteria_set_type,      -- VARCHAR ( 100 )
--    sampling_id,            -- UNSIGNED INT
--    schedule_type,          -- VARCHAR ( 100 )
--    enforce_this_schedule ) -- VARCHAR ( 1 )

create VIEW schedule AS SELECT * FROM rroad_schedule
;


Top    Tables: A B C D E G M P R S U

DBA.schedule_day_entry

-- DBA.schedule_day_entry (table_id 792) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:24AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.schedule_day_entry (
--    schedule_id,  -- INTEGER
--    day_number,   -- INTEGER
--    day_name,     -- VARCHAR ( 10 )
--    day_string )  -- VARCHAR ( 96 )

create VIEW schedule_day_entry AS SELECT * FROM rroad_schedule_day_entry
;


Top    Tables: A B C D E G M P R S U

DBA.schedule_period_entry

-- DBA.schedule_period_entry (table_id 794) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:24AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.schedule_period_entry (
--    schedule_id,    -- INTEGER
--    period_number,  -- INTEGER
--    period_code )   -- VARCHAR ( 1 )

create VIEW schedule_period_entry AS SELECT * FROM rroad_schedule_period_entry
;


Top    Tables: A B C D E G M P R S U

DBA.serial_number

-- DBA.serial_number (table_id 796) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:24AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.serial_number (
--    one_row_only,   -- INTEGER
--    key_type,       -- VARCHAR ( 1 )
--    serial_number ) -- LONG VARCHAR

create VIEW serial_number AS SELECT * FROM rroad_serial_number
;


Top    Tables: A B C D E G M P R S U

DBA.session_options

-- DBA.session_options (table_id 745) in Foxhound 4.0.4729a Adhoc Schema - Mar 6 2017 10:57:24AM - Foxhound  2017 RisingRoad

-- CREATE VIEW DBA.session_options (
--    session_id,                           -- VARCHAR ( 36 )
--    integer_session_id,                   -- INTEGER
--    sampling_id,                          -- UNSIGNED INT
--    list_refresh_count,                   -- BIGINT
--    display_refresh_count,                -- BIGINT
--    display_running,                      -- VARCHAR ( 1 )
--    samples_have_been_deleted,            -- VARCHAR ( 1 )
--    selected_tab,                         -- VARCHAR ( 1 )
--    selected_dsn,                         -- VARCHAR ( 128 )
--    selected_connection_string_name,      -- VARCHAR ( 128 )
--    include_system_owners,                -- VARCHAR ( 1 )
--    show_all_dsns,                        -- VARCHAR ( 1 )
--    current_database_version,             -- LONG VARCHAR
--    current_database_timestamp,           -- TIMESTAMP
--    current_upgraded_database_version,    -- LONG VARCHAR
--    current_upgraded_database_timestamp,  -- TIMESTAMP
--    current_engine_version,               -- LONG VARCHAR
--    proxy_owner,                          -- VARCHAR ( 128 )
--    page_size,                            -- INTEGER
--    menu_monitor_refresh_enabled )        -- VARCHAR ( 1 )

create VIEW session_options AS 
SELECT 
   session_id,
   integer_session_id,
   sampling_id,
   list_refresh_count,
   display_refresh_count,
   display_running,
   samples_have_been_deleted,
   selected_tab,
   selected_dsn,
   selected_connection_string_name,
   include_system_owners,
   show_all_dsns,
   current_database_version,
   current_database_timestamp,
   current_upgraded_database_version,
   current_upgraded_database_timestamp,
   current_engine_version,
   proxy_owner,
   page_size,
   menu_monitor_refresh_enabled
 FROM rroad_session_options
----------------------------------------------------------------------------------------------------- 
-- session_options -- Foxhound Version 4 Changes...
----------------------------------------------------------------------------------------------------- 
-- Removed: GlobalDBId BIGINT
;