Am 02.04.12 22:03, schrieb Katrin Fischer:
> Removes the '0' values without description from the sample date for
> authorised values.
In this patch, you add new MySQLisms. Please remove them and re-submit
thepatch. Backquotes for columns names are not acceptable and very easy
to avoid.
Thanks,
Marc
>
> 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','Вилучено');
>
>
>
> _______________________________________________
> Koha-patches mailing list
> [email protected]
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
