9 lines
320 B
SQL
9 lines
320 B
SQL
-- 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'; |