diff options
| author | ced <> | 2007-09-13 14:21:54 +0000 |
|---|---|---|
| committer | ced <> | 2007-09-13 14:21:54 +0000 |
| commit | 21a2cfd693ca980925a6488c8ce9202037285c2f (patch) | |
| tree | 1b042f8645183912ae80ff80156643a15857996d /doc | |
| parent | 38ddf6d439c34f487b985211d66631343cfe8476 (diff) | |
Force upper case for state/country code
bzr revid: ced-e884e4e3cbf4099c2356627c3da0277772660b19
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/migrate/4.0.0-4.2.0/pre.py | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/doc/migrate/4.0.0-4.2.0/pre.py b/doc/migrate/4.0.0-4.2.0/pre.py index f11188face0..00caf4338d6 100644 --- a/doc/migrate/4.0.0-4.2.0/pre.py +++ b/doc/migrate/4.0.0-4.2.0/pre.py @@ -193,4 +193,12 @@ if cr.fetchall(): cr.execute('ALTER TABLE stock_production_lot DROP CONSTRAINT \'stock_production_lot_name_uniq\'') cr.commit() +# ------------------------------------ # +# Put country/state code in upper case # +# ------------------------------------ # + +cr.execute('UPDATE res_country SET code = UPPER(code)') +cr.execute('UPDATE res_country_state SET code = UPPER(code)') +cr.commit() + cr.close |