From 86ae1e284963a8c04510be0c0a937c02ff4da76e Mon Sep 17 00:00:00 2001 From: Katrin Fischer 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 --- 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 ----- installer/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 c60d78f8ef..5832f61c16 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 4c813251cb..e1c79174ff 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 4c813251cb..e1c79174ff 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 19444261e8..3deeae27f8 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 11328e1591..0bc10c9e93 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 8bccb69fe9..2b2ca36dab 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 17aff3b210..0334fdc806 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 138cba7d6b..4aafe8a52e 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 e96bcefa54..4878a30804 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 e442303656..b602b81e04 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 67209452fe..3280209560 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 849613bb4b..3819a1b03e 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 b8544ff8c5..2e5b88c408 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 a1079f1f79..c51d2c0775 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 e5d46622e6..77d0e328d8 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','Вилучено'); -- 2.20.1