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)
