Attachment 1191949 Details for Bug 1367874 – certificate reset SQL to re-enable capsule sync

certificate reset SQL to re-enable capsule sync

certificate-reset.sql (text/plain), 1.08 KB, created by Mike McCune on 2016-08-18 17:23:17 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Mike McCune

Created: 2016-08-18 17:23:17 UTC

Size: 1.08 KB

patch

obsolete

>delete from cp_subscription where id in (select s.id from cp_subscription s inner join cp_product p on s.product_id = p.id left outer join cp_pool pool on pool.productid = p.id where p.name LIKE '%_ueber_product');
>
>delete from cp_ent_certificate where entitlement_id in (select e.id from cp_entitlement e inner join cp_pool p on e.pool_id = p.id inner join cp_product prod on prod.id = p.productid where prod.name like '%ueber%');
>
>delete from cp_entitlement where pool_id in (select p.id from cp_pool p inner join cp_product prod on prod.id = p.productid where prod.name like '%ueber%');
>
>delete from cp_pool where id in (select p.id from cp_pool p inner join cp_product prod on prod.id = p.productid where prod.name like '%ueber%');
>
>delete from cp_content where id in (select c.id from cp_content c inner join cp_product_content pc on pc.content_id=c.id inner join cp_product p on p.id=pc.product_id left outer join cp_pool pool on pool.productid = p.id where p.name LIKE '%_ueber_product');
>
>delete from cp_product where name like '%_ueber_product';
>
>delete from cp_consumer where name like '%ueber%';

Actions: View

Attachments on bug 1367874: 1191949