Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Try this.
UPDATE bugs SET bug_severity = 'normal' WHERE bug_severity = 'enhancement';
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Air Mozilla' AND component.name = 'Events') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'AUS Graveyard' AND component.name = 'Administration') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Bugzilla' AND component.name = 'Administration') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'bugzilla.mozilla.org' AND component.name = 'Administration') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'bugzilla.mozilla.org' AND component.name = 'Bulk Bug Edit Requests') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'bugzilla.mozilla.org' AND component.name = 'Graveyard Tasks') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Iodide') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Activedata') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: AMO') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Antenna') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Autopush') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: AWS Account Request') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Bzetl') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Delivery Console') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Deployment Requests') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: LandoAPI') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: LandoUI') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Marketplace') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Metrics/Monitoring') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Normandy') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Pageshot') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Phabricator') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Product Delivery') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Sentry') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Shavar') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Cloud Services' AND component.name = 'Operations: Storage') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Community Building') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Conduit' AND component.name = 'Administration') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Data & BI Services Team') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Data & BI Services Team Graveyard') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Data Compliance') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Data Science') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Developer Engagement') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Developer Services' AND component.name = 'General') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'developer.mozilla.org' AND component.name = 'Account Help') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'developer.mozilla.org' AND component.name = 'Administration') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'developer.mozilla.org' AND component.name = 'Events') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'developer.mozilla.org' AND component.name = 'Marketing') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'developer.mozilla.org' AND component.name = 'User management') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Enterprise Information Security') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Enterprise Information Security Graveyard') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Finance') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Firefox Build System' AND component.name = 'Task Configuration') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'FSA Graveyard') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Infrastructure & Operations') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Infrastructure & Operations Graveyard') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Internet Public Policy') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Legal Graveyard') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Localization Infrastructure and Tools' AND component.name = 'Administration / Setup') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Marketing') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Mozilla Foundation') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Mozilla Foundation Communications') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Mozilla Foundation Operations') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Mozilla Grants') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Mozilla Metrics' AND component.name = 'Metrics Operations') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Mozilla Reps') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Mozilla Reps Graveyard' AND component.name = 'Community IT Requests') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Mozilla Reps Graveyard' AND component.name = 'Planning') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'mozilla.org') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'mozilla.org Graveyard') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'NSS' AND component.name = 'CA Certificate Compliance') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'NSS' AND component.name = 'CA Certificate Root Program') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'NSS' AND component.name = 'CA Certificates Code') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Participation Infrastructure' AND component.name = 'Account Help') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Participation Infrastructure' AND component.name = 'API Requests') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Participation Infrastructure' AND component.name = 'Community Ops') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Participation Infrastructure' AND component.name = 'Data Complaints') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Privacy Graveyard') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Recruiting') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Snippets' AND component.name = 'Campaign') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Snippets' AND component.name = 'Surveys') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Socorro') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'support.mozilla.org' AND component.name = 'Army of Awesome') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'support.mozilla.org' AND component.name = 'Code Quality') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'support.mozilla.org' AND component.name = 'Forum') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'support.mozilla.org' AND component.name = 'Knowledge Base Articles') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'support.mozilla.org' AND component.name = 'Knowledge Base Content') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'support.mozilla.org' AND component.name = 'Knowledge Base Software') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'support.mozilla.org' AND component.name = 'Lithium Migration') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'support.mozilla.org' AND component.name = 'Localization') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'support.mozilla.org' AND component.name = 'Mobile') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'support.mozilla.org' AND component.name = 'Questions') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'support.mozilla.org' AND component.name = 'Users and Groups') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Taskcluster' AND component.name = 'Operations and Service Requests') temp);
UPDATE components SET default_bug_type = 'task' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Websites' AND component.name = 'Web Analytics') temp);
UPDATE components SET default_bug_type = 'enhancement' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'Firefox Build System' AND component.name = 'Mach Core') temp);
UPDATE components SET default_bug_type = 'enhancement' WHERE id IN (SELECT * FROM (
SELECT component.id FROM components as component
JOIN products AS product ON component.product_id = product.id
WHERE product.name = 'support.mozilla.org - Lithium' AND component.name = 'Feature request') temp);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.