Re: Traffic Ops database unique constraints

I created a Jira - https://issues.apache.org/jira/browse/TC-222 I'll submit a PR shortly if there are no objections. On Tue, Apr 4, 2017 at 2:18 PM, Jeremy Mitchell wrote: > and i forgot one. i'd like to make parameter unique by > name/config_file/value > > On Tue, Apr

Re: Traffic Ops database unique constraints

If I add these database constraints, you can't create 2 statuses (for example) with the same name (which I think is probably the desired effect)...so I can change my seeded data to look like: insert into status (name, description) values ('OFFLINE', 'Server is Offline. Not active in any

Traffic Ops database unique constraints

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