This is an automated email from the ASF dual-hosted git repository.
mitchell852 pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/trafficcontrol.git
The following commit(s) were added to refs/heads/master by this push:
new 2c72564 Fixing migrations for CI build (#4844)
2c72564 is described below
commit 2c72564a4148ba70273f54d7af5e4211133cce39
Author: Srijeet Chatterjee <[email protected]>
AuthorDate: Tue Jun 30 15:05:49 2020 -0600
Fixing migrations for CI build (#4844)
* Fixing seeds for last_deleted table to ensure they are not seeded more
than once
---
traffic_ops/app/db/seeds.sql | 106 +++++++++++++++++++++----------------------
1 file changed, 53 insertions(+), 53 deletions(-)
diff --git a/traffic_ops/app/db/seeds.sql b/traffic_ops/app/db/seeds.sql
index f0519016..c301417 100644
--- a/traffic_ops/app/db/seeds.sql
+++ b/traffic_ops/app/db/seeds.sql
@@ -885,56 +885,56 @@ values (30, 'OPEN', '', 'bd', '1.0.0', '-', '', '0', '',
(select id from type wh
insert into to_extension (id, name, servercheck_short_name,
servercheck_column_name, version, info_url, script_file, isactive,
additional_config_json, type)
values (31, 'OPEN', '', 'be', '1.0.0', '-', '', '0', '', (select id from type
where name='CHECK_EXTENSION_OPEN_SLOT')) ON CONFLICT DO NOTHING;
-insert into last_deleted (table_name) VALUES ('api_capability');
-insert into last_deleted (table_name) VALUES ('asn');
-insert into last_deleted (table_name) VALUES ('cachegroup');
-insert into last_deleted (table_name) VALUES ('cachegroup_fallbacks');
-insert into last_deleted (table_name) VALUES
('cachegroup_localization_method');
-insert into last_deleted (table_name) VALUES ('cachegroup_parameter');
-insert into last_deleted (table_name) VALUES ('capability');
-insert into last_deleted (table_name) VALUES ('cdn');
-insert into last_deleted (table_name) VALUES ('coordinate');
-insert into last_deleted (table_name) VALUES ('deliveryservice');
-insert into last_deleted (table_name) VALUES ('deliveryservice_regex');
-insert into last_deleted (table_name) VALUES ('deliveryservice_request');
-insert into last_deleted (table_name) VALUES
('deliveryservice_request_comment');
-insert into last_deleted (table_name) VALUES ('deliveryservice_server');
-insert into last_deleted (table_name) VALUES ('deliveryservice_tmuser');
-insert into last_deleted (table_name) VALUES ('division');
-insert into last_deleted (table_name) VALUES ('federation');
-insert into last_deleted (table_name) VALUES ('federation_deliveryservice');
-insert into last_deleted (table_name) VALUES
('federation_federation_resolver');
-insert into last_deleted (table_name) VALUES ('federation_resolver');
-insert into last_deleted (table_name) VALUES ('federation_tmuser');
-insert into last_deleted (table_name) VALUES ('hwinfo');
-insert into last_deleted (table_name) VALUES ('job');
-insert into last_deleted (table_name) VALUES ('job_agent');
-insert into last_deleted (table_name) VALUES ('job_status');
-insert into last_deleted (table_name) VALUES ('log');
-insert into last_deleted (table_name) VALUES ('origin');
-insert into last_deleted (table_name) VALUES ('parameter');
-insert into last_deleted (table_name) VALUES ('phys_location');
-insert into last_deleted (table_name) VALUES ('profile');
-insert into last_deleted (table_name) VALUES ('profile_parameter');
-insert into last_deleted (table_name) VALUES ('regex');
-insert into last_deleted (table_name) VALUES ('region');
-insert into last_deleted (table_name) VALUES ('role');
-insert into last_deleted (table_name) VALUES ('role_capability');
-insert into last_deleted (table_name) VALUES ('server');
-insert into last_deleted (table_name) VALUES ('servercheck');
-insert into last_deleted (table_name) VALUES ('snapshot');
-insert into last_deleted (table_name) VALUES ('staticdnsentry');
-insert into last_deleted (table_name) VALUES ('stats_summary');
-insert into last_deleted (table_name) VALUES ('status');
-insert into last_deleted (table_name) VALUES ('steering_target');
-insert into last_deleted (table_name) VALUES ('tenant');
-insert into last_deleted (table_name) VALUES ('tm_user');
-insert into last_deleted (table_name) VALUES ('topology');
-insert into last_deleted (table_name) VALUES ('topology_cachegroup');
-insert into last_deleted (table_name) VALUES ('topology_cachegroup_parents');
-insert into last_deleted (table_name) VALUES ('to_extension');
-insert into last_deleted (table_name) VALUES ('type');
-insert into last_deleted (table_name) VALUES ('user_role');
-insert into last_deleted (table_name) VALUES ('server_capability');
-insert into last_deleted (table_name) VALUES ('server_server_capability');
-insert into last_deleted (table_name) VALUES
('deliveryservices_required_capability');
\ No newline at end of file
+insert into last_deleted (table_name) VALUES ('api_capability') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('asn') ON CONFLICT (table_name)
DO NOTHING;
+insert into last_deleted (table_name) VALUES ('cachegroup') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('cachegroup_fallbacks') ON
CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES
('cachegroup_localization_method') ON CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('cachegroup_parameter') ON
CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('capability') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('cdn') ON CONFLICT (table_name)
DO NOTHING;
+insert into last_deleted (table_name) VALUES ('coordinate') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('deliveryservice') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('deliveryservice_regex') ON
CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('deliveryservice_request') ON
CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES
('deliveryservice_request_comment') ON CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('deliveryservice_server') ON
CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('deliveryservice_tmuser') ON
CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('division') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('federation') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('federation_deliveryservice') ON
CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES
('federation_federation_resolver') ON CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('federation_resolver') ON
CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('federation_tmuser') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('hwinfo') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('job') ON CONFLICT (table_name)
DO NOTHING;
+insert into last_deleted (table_name) VALUES ('job_agent') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('job_status') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('log') ON CONFLICT (table_name)
DO NOTHING;
+insert into last_deleted (table_name) VALUES ('origin') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('parameter') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('phys_location') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('profile') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('profile_parameter') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('regex') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('region') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('role') ON CONFLICT (table_name)
DO NOTHING;
+insert into last_deleted (table_name) VALUES ('role_capability') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('server') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('servercheck') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('snapshot') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('staticdnsentry') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('stats_summary') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('status') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('steering_target') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('tenant') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('tm_user') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('topology') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('topology_cachegroup') ON
CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('topology_cachegroup_parents')
ON CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('to_extension') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('type') ON CONFLICT (table_name)
DO NOTHING;
+insert into last_deleted (table_name) VALUES ('user_role') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('server_capability') ON CONFLICT
(table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES ('server_server_capability') ON
CONFLICT (table_name) DO NOTHING;
+insert into last_deleted (table_name) VALUES
('deliveryservices_required_capability') ON CONFLICT (table_name) DO NOTHING;
\ No newline at end of file
