[jira] [Created] (TC-222) TO - add unique constraints to parameter, job_status, job_agent, role, status, and type tables

["Jeremy Mitchell (JIRA)" <ji...@apache.org>]

Jeremy Mitchell created TC-222:
----------------------------------

             Summary: TO - add unique constraints to parameter, job_status, job_agent, role, status, and type tables
                 Key: TC-222
                 URL: https://issues.apache.org/jira/browse/TC-222
             Project: Traffic Control
          Issue Type: Improvement
          Components: Traffic Ops
            Reporter: Jeremy Mitchell
            Assignee: Jeremy Mitchell
            Priority: Minor


The following unique constraints would prevent duplicate entries in the database:

- parameter (name, config_file, value)
- job_status (name)
- job_agent (name)
- role (name)
- status (name)
- type (name)

Once these constraints are in place, seeds.sql can be enhanced to avoid duplicate entries.




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)