[Koha-patches] [PATCH] [3.0.x] [bug 4898] Fix COUNTRY authorised values to uppercase

Zeno Tajoli tajoli at cilea.it
Mon Jun 21 16:57:49 CEST 2010


---
 installer/data/mysql/it-IT/necessari/auth_val.sql |   16 ++++++++--------
 1 files changed, 8 insertions(+), 8 deletions(-)

diff --git a/installer/data/mysql/it-IT/necessari/auth_val.sql b/installer/data/mysql/it-IT/necessari/auth_val.sql
index d047bb0..f6a0d6d 100644
--- a/installer/data/mysql/it-IT/necessari/auth_val.sql
+++ b/installer/data/mysql/it-IT/necessari/auth_val.sql
@@ -83,14 +83,14 @@ INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES
 
 -- Codici dei Paesi (COUNTRY)
 INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES
-('COUNTRY', 'it', 'Italia'),
-('COUNTRY', 'us', 'Stati Uniti'),
-('COUNTRY', 'gb', 'Regno Unito - UK '),
-('COUNTRY', 'de', 'Germania'),
-('COUNTRY', 'fr', 'Francia'),
-('COUNTRY', 'va', 'Vaticano'),
-('COUNTRY', 'cn', 'Cina'),
-('COUNTRY', 'in', 'India');
+('COUNTRY', 'IT', 'Italia'),
+('COUNTRY', 'US', 'Stati Uniti'),
+('COUNTRY', 'GB', 'Regno Unito - UK '),
+('COUNTRY', 'DE', 'Germania'),
+('COUNTRY', 'FR', 'Francia'),
+('COUNTRY', 'VA', 'Vaticano'),
+('COUNTRY', 'CN', 'Cina'),
+('COUNTRY', 'IN', 'India');
 
 -- Codici delle lingue (LANG)
 INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES
-- 
1.5.3.7



More information about the Koha-patches mailing list