9 lines
320 B
MySQL
9 lines
320 B
MySQL
|
-- happy path
|
||
|
|
UPDATE iap_account
|
||
|
|
SET account_token = REGEXP_REPLACE(account_token, '(\+.*)?$', '+disabled')
|
||
|
|
WHERE LENGTH(account_token) <= 33;
|
||
|
|
-- Legacy (invalid) records (pre v17)
|
||
|
|
UPDATE iap_account
|
||
|
|
SET account_token = 'dummy_value+disabled'
|
||
|
|
WHERE LENGTH(account_token) > 33
|
||
|
|
AND account_token NOT LIKE '%+disabled';
|