Confirmed users
1,158
edits
User:Clouserw/AMODBrefresh: Difference between revisions
no edit summary
mNo edit summary |
No edit summary |
||
| Line 28: | Line 28: | ||
</pre> | </pre> | ||
<p>Solitude and payment accounts are in a seperate database, so after a sync, run this to clear out all payment accounts and reset all public paid apps to pending:</p> | |||
<pre> | |||
set foreign_key_checks = 0; | |||
truncate payments_seller; | |||
truncate payment_accounts; | |||
truncate addon_payment_account; | |||
truncate user_inapp_keys; | |||
-- purchases and contributions etc | |||
truncate addon_purchase; | |||
truncate stats_contributions; | |||
set foreign_key_checks = 1; | |||
-- find all public webapps that might have payments and make them unreviewed | |||
update addons set status = 1 where addontype_id = 11 and premium_type in (1, 2, 3,4) and status in (4, 13); | |||
</pre> | |||
<p>We then need to truncate all the tables in solitude on stage or dev, or drop and recreate it.</p> | |||