File: eca-update.sql

package info (click to toggle)
ledgersmb 1.6.33%2Bds-2.1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 33,000 kB
  • sloc: perl: 52,612; sql: 43,562; xml: 36,194; javascript: 2,428; sh: 1,099; makefile: 361; pascal: 25
file content (6 lines) | stat: -rw-r--r-- 261 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
 

UPDATE entity_credit_account
   SET curr = (select s from unnest(string_to_array((select value from defaults where setting_key = 'curr'), ':')) s limit 1)
 WHERE curr IS NULL;

update entity_credit_account set language_code = 'en' where language_code is null;