fix missing primary keys for status seeds
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/7ac3bf19 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/7ac3bf19 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/7ac3bf19 Branch: refs/heads/master Commit: 7ac3bf1951c0ba304c8e2f56b299a29ad7262b29 Parents: 2dd2712 Author: Derek Gelinas <derek_geli...@cable.comcast.com> Authored: Tue Apr 4 15:28:49 2017 +0000 Committer: Dewayne Richardson <dewr...@apache.org> Committed: Tue Apr 4 09:30:52 2017 -0600 ---------------------------------------------------------------------- traffic_ops/app/db/seeds.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/7ac3bf19/traffic_ops/app/db/seeds.sql ---------------------------------------------------------------------- diff --git a/traffic_ops/app/db/seeds.sql b/traffic_ops/app/db/seeds.sql index ecdd991..bef8211 100644 --- a/traffic_ops/app/db/seeds.sql +++ b/traffic_ops/app/db/seeds.sql @@ -76,12 +76,12 @@ insert into type (name, description, use_in_table) values ('AAAA_RECORD', 'Stati insert into type (name, description, use_in_table) values ('CNAME_RECORD', 'Static DNS CNAME entry', 'staticdnsentry') ON CONFLICT DO NOTHING; -- statuses -insert into status (name, description) values ('OFFLINE', 'Server is Offline. Not active in any configuration.') ON CONFLICT DO NOTHING; -insert into status (name, description) values ('ONLINE', 'Server is online.') ON CONFLICT DO NOTHING; -insert into status (name, description) values ('REPORTED', 'Server is online and reporeted in the health protocol.') ON CONFLICT DO NOTHING; -insert into status (name, description) values ('ADMIN_DOWN', 'Sever is administrative down and does not receive traffic.') ON CONFLICT DO NOTHING; -insert into status (name, description) values ('CCR_IGNORE', 'Server is ignored by traffic router.') ON CONFLICT DO NOTHING; -insert into status (name, description) values ('PRE_PROD', 'Pre Production. Not active in any configuration.') ON CONFLICT DO NOTHING; +insert into status (id, name, description) values (1, 'OFFLINE', 'Server is Offline. Not active in any configuration.') ON CONFLICT DO NOTHING; +insert into status (id, name, description) values (2, 'ONLINE', 'Server is online.') ON CONFLICT DO NOTHING; +insert into status (id, name, description) values (3, 'REPORTED', 'Server is online and reporeted in the health protocol.') ON CONFLICT DO NOTHING; +insert into status (id, name, description) values (4, 'ADMIN_DOWN', 'Sever is administrative down and does not receive traffic.') ON CONFLICT DO NOTHING; +insert into status (id, name, description) values (5, 'CCR_IGNORE', 'Server is ignored by traffic router.') ON CONFLICT DO NOTHING; +insert into status (id, name, description) values (6, 'PRE_PROD', 'Pre Production. Not active in any configuration.') ON CONFLICT DO NOTHING; -- job agents insert into job_agent (name, description, active) values ('dummy', 'Description of Purge Agent', '1') ON CONFLICT DO NOTHING;