text: --
  -- Monitored services.
  --
  CREATE TABLE services (
    host_id int NOT NULL,
    description varchar(255) NOT NULL,
    service_id int NOT NULL,
  
    acknowledged boolean default NULL,
    acknowledgement_type smallint default NULL,
    action_url varchar(255) default NULL,
    active_checks boolean default NULL,
    check_attempt smallint default NULL,
    check_command text default NULL,
    check_freshness boolean default NULL,
    check_interval double precision default NULL,
    check_period varchar(75) default NULL,
    check_type smallint default NULL,
    checked boolean default NULL,
    command_line text default NULL,
    default_active_checks boolean default NULL,
    default_event_handler_enabled boolean default NULL,
    default_failure_prediction boolean default NULL,
    default_flap_detection boolean default NULL,
    default_notify boolean default NULL,
    default_passive_checks boolean default NULL,
    default_process_perfdata boolean default NULL,
    display_name varchar(160) default NULL,
    enabled bool NOT NULL default true,
    event_handler varchar(255) default NULL,
    event_handler_enabled boolean default NULL,
    execution_time double precision default NULL,
    failure_prediction boolean default NULL,
    failure_prediction_options varchar(64) default NULL,
    first_notification_delay double precision default NULL,
    flap_detection boolean default NULL,
    flap_detection_on_critical boolean default NULL,
    flap_detection_on_ok boolean default NULL,
    flap_detection_on_unknown boolean default NULL,
    flap_detection_on_warning boolean default NULL,
    flapping boolean default NULL,
    freshness_threshold double precision default NULL,
    high_flap_threshold double precision default NULL,
    icon_image varchar(255) default NULL,
    icon_image_alt varchar(255) default NULL,
    last_check int default NULL,
    last_hard_state smallint default NULL,
    last_hard_state_change int default NULL,
    last_notification int default NULL,
    last_state_change int default NULL,
    last_time_critical int default NULL,
    last_time_ok int default NULL,
    last_time_unknown int default NULL,
    last_time_warning int default NULL,
    last_update int default NULL,
    latency double precision default NULL,
    low_flap_threshold double precision default NULL,
    max_check_attempts smallint default NULL,
    modified_attributes int default NULL,
    next_check int default NULL,
    next_notification int default NULL,
    no_more_notifications boolean default NULL,
    notes varchar(255) default NULL,
    notes_url varchar(255) default NULL,
    notification_interval double precision default NULL,
    notification_number smallint default NULL,
    notification_period varchar(75) default NULL,
    notify boolean default NULL,
    notify_on_critical boolean default NULL,
    notify_on_downtime boolean default NULL,
    notify_on_flapping boolean default NULL,
    notify_on_recovery boolean default NULL,
    notify_on_unknown boolean default NULL,
    notify_on_warning boolean default NULL,
    obsess_over_service boolean default NULL,
    output text default NULL,
    passive_checks boolean default NULL,
    percent_state_change double precision default NULL,
    perfdata text default NULL,
    process_perfdata boolean default NULL,
    real_state smallint default NULL,
    retain_nonstatus_information boolean default NULL,
    retain_status_information boolean default NULL,
    retry_interval double precision default NULL,
    scheduled_downtime_depth smallint default NULL,
    should_be_scheduled boolean default NULL,
    stalk_on_critical boolean default NULL,
    stalk_on_ok boolean default NULL,
    stalk_on_unknown boolean default NULL,
    stalk_on_warning boolean default NULL,
    state smallint default NULL,
    state_type smallint default NULL,
    volatile boolean default NULL,
  
    UNIQUE (host_id, service_id),
    INDEX (service_id),
    INDEX (description),
    FOREIGN KEY (host_id) REFERENCES hosts (host_id)
      ON DELETE CASCADE
  );
  