Bugzilla – Attachment 9006 Details for
Bug 2399
All status fields in the item edit interface offer two blank/null entries per dropdown instead of one
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 2399: All status fields in the item edit interface offer two blank/null entries per dropdown instead of one
Bug-2399-All-status-fields-in-the-item-edit-interf.patch (text/plain), 24.22 KB, created by
Chris Cormack
on 2012-04-08 08:56:17 UTC
(
hide
)
Description:
Bug 2399: All status fields in the item edit interface offer two blank/null entries per dropdown instead of one
Filename:
MIME Type:
Creator:
Chris Cormack
Created:
2012-04-08 08:56:17 UTC
Size:
24.22 KB
patch
obsolete
>From c3f28b48c98bc7058cf2d98a5d4361abda624d96 Mon Sep 17 00:00:00 2001 >From: Katrin Fischer <Katrin.Fischer.83@web.de> >Date: Mon, 2 Apr 2012 19:28:37 +0200 >Subject: [PATCH] Bug 2399: All status fields in the item edit interface offer > two blank/null entries per dropdown instead of one > >Removes the '0' values without description from the sample date for >authorised values. > >To test: >1) Verify that SQL files load correctly >- truncate authorised_values; /* empty authorised values table */ >- load sample data using one of the SQL files >2) Check cataloging interface - all status fields should only show 1 empty line > >Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz> >--- > installer/data/mysql/de-DE/optional/auth_val.sql | 7 +------ > installer/data/mysql/en/optional/auth_val.sql | 5 ----- > installer/data/mysql/es-ES/optional/auth_val.sql | 5 ----- > .../data/mysql/nb-NO/2-Valgfritt/auth_val.sql | 5 ----- > installer/data/mysql/pl-PL/optional/auth_val.sql | 5 ----- > .../authorised_values_[DAMAGED].sql | 1 - > .../authorised_values/authorised_values_[LOST].sql | 12 +++++------- > .../authorised_values_[NOT_LOAN].sql | 1 - > .../authorised_values_[RESTRICTED].sql | 1 - > .../authorised_values_[WITHDRAWN].sql | 1 - > .../authorised_values_[DAMAGED].sql | 1 - > .../authorised_values/authorised_values_[LOST].sql | 12 +++++------- > .../authorised_values_[NOT_LOAN].sql | 1 - > .../authorised_values_[RESTRICTED].sql | 1 - > .../authorised_values_[WITHDRAWN].sql | 1 - > 15 files changed, 11 insertions(+), 48 deletions(-) > >diff --git a/installer/data/mysql/de-DE/optional/auth_val.sql b/installer/data/mysql/de-DE/optional/auth_val.sql >index c60d78f..5832f61 100644 >--- a/installer/data/mysql/de-DE/optional/auth_val.sql >+++ b/installer/data/mysql/de-DE/optional/auth_val.sql >@@ -1,18 +1,16 @@ > -- Reasons for acceptance or rejection of suggestions in acquisitions > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Bestseller'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Vorhandenes Exemplar beschädigt'); >-INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Biblitoheksexemplar vermisst'); >+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Bibliotheksexemplar vermisst'); > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Ãber Fernleihe bestellbar'); > > -- availability statuses >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Lange überfällig (Verloren)'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Verloren'); > INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Verloren und Buchersatz bezahlt'); > INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Vermisst'); > > -- damaged status of an item >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Beschädigt'); > > -- location qualification for an item, departments are linked by default to items.location >@@ -33,17 +31,14 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Sachliteratur'); > > -- withdrawn status of an item, linked to items.wthdrawn >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ausgeschieden'); > > -- loanability status of an item, linked to items.notforloan > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Bestellt'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Nicht entleihbar'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Mitarbeiterbibliothek'); > > -- restricted status of an item, linked to items.restricted >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Eingeschränkt zugänglich'); > > -- manual invoice types >diff --git a/installer/data/mysql/en/optional/auth_val.sql b/installer/data/mysql/en/optional/auth_val.sql >index 4c81325..e1c7917 100644 >--- a/installer/data/mysql/en/optional/auth_val.sql >+++ b/installer/data/mysql/en/optional/auth_val.sql >@@ -5,14 +5,12 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL'); > > -- availability statuses >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost'); > INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For'); > INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Missing'); > > -- damaged status of an item >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged'); > > -- location qualification for an item, departments are linked by default to items.location >@@ -33,17 +31,14 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction'); > > -- withdrawn status of an item, linked to items.wthdrawn >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn'); > > -- loanability status of an item, linked to items.notforloan > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection'); > > -- restricted status of an item, linked to items.restricted >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access'); > > -- manual invoice types >diff --git a/installer/data/mysql/es-ES/optional/auth_val.sql b/installer/data/mysql/es-ES/optional/auth_val.sql >index 4c81325..e1c7917 100644 >--- a/installer/data/mysql/es-ES/optional/auth_val.sql >+++ b/installer/data/mysql/es-ES/optional/auth_val.sql >@@ -5,14 +5,12 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL'); > > -- availability statuses >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost'); > INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For'); > INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Missing'); > > -- damaged status of an item >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged'); > > -- location qualification for an item, departments are linked by default to items.location >@@ -33,17 +31,14 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction'); > > -- withdrawn status of an item, linked to items.wthdrawn >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn'); > > -- loanability status of an item, linked to items.notforloan > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection'); > > -- restricted status of an item, linked to items.restricted >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access'); > > -- manual invoice types >diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql >index 1944426..3deeae2 100644 >--- a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql >+++ b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql >@@ -26,14 +26,12 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Tilgjengelig via fjernlÃ¥n'); > > -- availability statuses >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Regnes som tapt'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Tapt'); > INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Tapt og erstattet'); > INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Savnet'); > > -- damaged status of an item >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Skadet'); > > -- location qualification for an item, departments are linked by default to items.location >@@ -54,17 +52,14 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Faglitteratur'); > > -- withdrawn status of an item, linked to items.wthdrawn >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Trukket tilbake'); > > -- loanability status of an item, linked to items.notforloan > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','I bestilling'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Ikke til utlÃ¥n'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Kun til internt bruk'); > > -- restricted status of an item, linked to items.restricted >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Begrenset tilgang'); > > -- manual invoice types >diff --git a/installer/data/mysql/pl-PL/optional/auth_val.sql b/installer/data/mysql/pl-PL/optional/auth_val.sql >index 11328e1..0bc10c9 100644 >--- a/installer/data/mysql/pl-PL/optional/auth_val.sql >+++ b/installer/data/mysql/pl-PL/optional/auth_val.sql >@@ -5,14 +5,12 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST > INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL'); > > -- availability statuses >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost'); > INSERT INTO `authorised_values` (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For'); > INSERT INTO `authorised_values` (category, authorised_value, lib )VALUES ('LOST','4','Missing'); > > -- damaged status of an item >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged'); > > -- location qualification for an item, departments are linked by default to items.location >@@ -31,15 +29,12 @@ INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction'); > > -- withdrawn status of an item, linked to items.wthdrawn >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn'); > > -- loanability status of an item, linked to items.notforloan > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered'); >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan'); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection'); > > -- restricted status of an item, linked to items.restricted >-INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','0',''); > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access'); >diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].sql >index 8bccb69..2b2ca36 100644 >--- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].sql >+++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].sql >@@ -1,6 +1,5 @@ > DELETE FROM authorised_values WHERE category='DAMAGED'; > > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES >-('DAMAGED','0',''), > ('DAMAGED','1','ÐовÑеждено'); > >diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].sql >index 17aff3b..0334fdc 100644 >--- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].sql >+++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].sql >@@ -1,14 +1,12 @@ > DELETE FROM authorised_values WHERE category='LOST'; > >-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'LOST','0',''); >+INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'LOST','2','ÐлиÑелÑÐ½Ð°Ñ Ð¿ÑоÑÑоÑка (ÑÑÑаÑено)'); > >-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'LOST','2','ÐлиÑелÑÐ½Ð°Ñ Ð¿ÑоÑÑоÑка (ÑÑÑаÑено)'); >+INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'LOST','1','УÑÑаÑено'); > >-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 2,'LOST','1','УÑÑаÑено'); >+INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 2,'LOST','3','ÐоÑеÑÑÐ½Ñ Ð¸ заплаÑено за ÑкземплÑÑ'); > >-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 3,'LOST','3','ÐоÑеÑÑÐ½Ñ Ð¸ заплаÑено за ÑкземплÑÑ'); >+INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 3,'LOST','5','ÐÑÑÑÑÑÑвÑÐµÑ Ð¿Ñи запÑоÑе на ÑезеÑвиÑование'); > >-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 4,'LOST','5','ÐÑÑÑÑÑÑвÑÐµÑ Ð¿Ñи запÑоÑе на ÑезеÑвиÑование'); >- >-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 5,'LOST','4','ÐÑÑÑÑÑÑвÑÐµÑ Ð¿Ñи инвенÑиÑизаÑии'); >+INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 4,'LOST','4','ÐÑÑÑÑÑÑвÑÐµÑ Ð¿Ñи инвенÑиÑизаÑии'); > >diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].sql >index 138cba7..4aafe8a 100644 >--- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].sql >+++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].sql >@@ -1,7 +1,6 @@ > DELETE FROM authorised_values WHERE category='NOT_LOAN'; > > INSERT INTO authorised_values (category, authorised_value, lib) VALUES >-('NOT_LOAN','0', ' ÐÐ»Ñ Ð·Ð°Ð¹Ð¼Ð°'), > ('NOT_LOAN','-1','Ðаказано'), > ('NOT_LOAN','1', 'Ðе Ð´Ð»Ñ Ð·Ð°Ð¹Ð¼Ð°'), > ('NOT_LOAN','2', 'СобÑание ÑабоÑника библиоÑеки'), >diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].sql >index e96bcef..4878a30 100644 >--- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].sql >+++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].sql >@@ -1,7 +1,6 @@ > DELETE FROM authorised_values WHERE category='RESTRICTED'; > > INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES >-('RESTRICTED','0',''), > ('RESTRICTED','1','ÐгÑаниÑеннÑй доÑÑÑп'); > > >diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].sql >index e442303..b602b81 100644 >--- a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].sql >+++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].sql >@@ -1,7 +1,6 @@ > DELETE FROM authorised_values WHERE category='WITHDRAWN'; > > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES >-('WITHDRAWN','0',''), > ('WITHDRAWN','1','ÐзÑÑÑо'); > > >diff --git a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[DAMAGED].sql b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[DAMAGED].sql >index 6720945..3280209 100644 >--- a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[DAMAGED].sql >+++ b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[DAMAGED].sql >@@ -1,5 +1,4 @@ > DELETE FROM authorised_values WHERE category='DAMAGED'; > > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES >-('DAMAGED','0',''), > ('DAMAGED','1','ÐоÑкоджено'); >diff --git a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[LOST].sql b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[LOST].sql >index 849613b..3819a1b 100644 >--- a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[LOST].sql >+++ b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[LOST].sql >@@ -1,13 +1,11 @@ > DELETE FROM authorised_values WHERE category='LOST'; > >-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'LOST','0',''); >+INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'LOST','2','ТÑивале пÑоÑÑÑоÑÐµÐ½Ð½Ñ (вÑÑаÑено)'); > >-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'LOST','2','ТÑивале пÑоÑÑÑоÑÐµÐ½Ð½Ñ (вÑÑаÑено)'); >+INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'LOST','1','ÐÑÑаÑено'); > >-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 2,'LOST','1','ÐÑÑаÑено'); >+INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 2,'LOST','3','ÐÑÑаÑено Ñ Ð·Ð°Ð¿Ð»Ð°Ñено за пÑимÑÑник'); > >-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 3,'LOST','3','ÐÑÑаÑено Ñ Ð·Ð°Ð¿Ð»Ð°Ñено за пÑимÑÑник'); >+INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 3,'LOST','5','ÐÑдÑÑÑÐ½Ñ Ð¿Ñи запиÑÑ Ð½Ð° ÑезеÑвÑваннÑ'); > >-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 4,'LOST','5','ÐÑдÑÑÑÐ½Ñ Ð¿Ñи запиÑÑ Ð½Ð° ÑезеÑвÑваннÑ'); >- >-INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 5,'LOST','4','ÐÑдÑÑÑÐ½Ñ Ð¿Ñи ÑнвенÑаÑизаÑÑÑ'); >+INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 4,'LOST','4','ÐÑдÑÑÑÐ½Ñ Ð¿Ñи ÑнвенÑаÑизаÑÑÑ'); >diff --git a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[NOT_LOAN].sql b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[NOT_LOAN].sql >index b8544ff..2e5b88c 100644 >--- a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[NOT_LOAN].sql >+++ b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[NOT_LOAN].sql >@@ -1,7 +1,6 @@ > DELETE FROM authorised_values WHERE category='NOT_LOAN'; > > INSERT INTO authorised_values (category, authorised_value, lib) VALUES >-('NOT_LOAN','0', ' ÐÐ»Ñ Ð²Ð¸Ð¿Ð¾Ð¶Ð¸ÑаннÑ'), > ('NOT_LOAN','-1','Ðамовлено'), > ('NOT_LOAN','1', 'Ðе Ð´Ð»Ñ Ð²Ð¸Ð¿Ð¾Ð¶Ð¸ÑаннÑ'), > ('NOT_LOAN','2', 'ÐÑбÑÐ°Ð½Ð½Ñ Ð¿ÑаÑÑвника бÑблÑоÑеки'), >diff --git a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RESTRICTED].sql b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RESTRICTED].sql >index a1079f1..c51d2c0 100644 >--- a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RESTRICTED].sql >+++ b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RESTRICTED].sql >@@ -1,5 +1,4 @@ > DELETE FROM authorised_values WHERE category='RESTRICTED'; > > INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES >-('RESTRICTED','0',''), > ('RESTRICTED','1','Ðбмежений доÑÑÑп'); >diff --git a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].sql b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].sql >index e5d4662..77d0e32 100644 >--- a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].sql >+++ b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].sql >@@ -1,5 +1,4 @@ > DELETE FROM authorised_values WHERE category='WITHDRAWN'; > > INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES >-('WITHDRAWN','0',''), > ('WITHDRAWN','1','ÐилÑÑено'); >-- >1.7.5.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 2399
:
8783
|
8828
| 9006 |
9007