[Koha-patches] =?y?q?=5BPATCH=5D=20Bug=202399=3A=20All=20status=20fields=20in=20the=20item=20edit=20interface=20offer=20two=20blank/null=20entries=20per=20dropdown=20instead=20of=20one?=

Katrin Fischer Katrin.Fischer.83 at web.de
Mon Apr 2 22:03:21 CEST 2012 

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
---
 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

More information about the Koha-patches mailing list