mirror of
https://github.com/bringout/oca-ocb-technical.git
synced 2026-04-20 08:52:03 +02:00
9 lines
No EOL
320 B
SQL
9 lines
No EOL
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'; |