I have moved all Traffic Ops seed data into ONE place -
https://github.com/apache/incubator-trafficcontrol/blob/master/traffic_ops/app/db/seeds.sql

(there used to be some in seeds.sql and others in
traffic_ops/install/data/json)

Anyhow, if you run seeds.sql multiple times (i.e. db/admin.pl upgrade),
you'll end up with duplicate data as some tables don't have unique
constraints.

I'd like to add unique constraints to the following database table /
columns:

- role.name
- status.name
- type.name
- job_status.name

In my opinion, these constraints should have been in there since day 1 but
if you have any objections, let me know.

Thanks,

Jeremy

Reply via email to