Github user mitchell852 commented on a diff in the pull request:
https://github.com/apache/incubator-trafficcontrol/pull/435#discussion_r113052674
--- Diff: traffic_ops/app/db/seeds.sql ---
@@ -22,6 +22,257 @@ insert into role (id, name, description, priv_level)
values (5, 'portal', 'Porta
insert into role (id, name, description, priv_level) values (6,
'migrations', 'database migrations user - DO NOT REMOVE', 20) ON CONFLICT DO
NOTHING;
insert into role (id, name, description, priv_level) values (7,
'federation', 'Role for Secondary CZF', 15) ON CONFLICT DO NOTHING;
insert into role (id, name, description, priv_level) values (8,
'steering', 'Role for Steering Delivery Services', 15) ON CONFLICT DO NOTHING;
+insert into role (id, name, description, priv_level) values (9, 'root',
'Role for full capabilities - super-user ', 30) ON CONFLICT DO NOTHING;
+
+-- capabilities
+insert into capability (name, description) values ('all-read', 'Full read
access') ON CONFLICT DO NOTHING;
--- End diff --
when you sync up with the new seeds.sql file, you'll see that the "ON
CONFLICT DO NOTHING"s have been changed to be more specific. For example, "ON
CONFLICT (name) DO NOTHING;" . with both a proper unique constraint and a more
specific "ON CONFLICT (whatever) DO NOTHING", we can avoid getting duplicates
in the database if seeds.sql is run multiple times.
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
