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