# These are the primary keys for the tables in the cms database

NAME tables
    names  @{
    system cms_admin cms_log serv_serv_dep serv_sys_dep sys_serv_dep service
    @}
END

NAME system
    pk		hostname
    log_field   system_id
    check       select @$pk, @$log_field from @$NAME where
    perl_pk	["hostname"]
END

NAME cms_admin
    pk          name
    check       select @$pk from @$NAME where
    perl_pk     ["name"]
END

NAME cms_log
    pk          log_id, tbl
    log_field   log_id
    check       select @$pk, @$log_field from @$NAME where
    perl_pk     ["log_id", "tbl"]
END

NAME serv_serv_dep
    pk          service_id, service2_id
    log_field   dep_id
    check       select @$pk, @$log_field from @$NAME where
    perl_pk     ["service_id", "service2_id"]

END

NAME serv_sys_dep
    pk          service_id, hostname
    log_field   dep_id
    check       select @$pk, @$log_field from @$NAME where
    perl_pk     ["service_id", "hostname"]
END

NAME sys_serv_dep
    pk          service_id, hostname
    log_field   dep_id
    check       select @$pk, @$log_field from @$NAME where
    perl_pk     ["service_id", "hostname"]
END

NAME service
    pk          service_id
    log_field   service_id
    check       select @$pk, @$log_field from @$NAME where
    perl_pk     ["service_id"]
END