View | Details | Raw Unified | Return to bug 2399
Collapse All | Expand All

(-)a/installer/data/mysql/de-DE/optional/auth_val.sql (-6 / +1 lines)
Lines 1-18 Link Here
1
-- Reasons for acceptance or rejection of suggestions in acquisitions
1
-- Reasons for acceptance or rejection of suggestions in acquisitions
2
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Bestseller');
2
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Bestseller');
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Vorhandenes Exemplar beschädigt');
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Vorhandenes Exemplar beschädigt');
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Biblitoheksexemplar vermisst');
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Bibliotheksexemplar vermisst');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Über Fernleihe bestellbar');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Über Fernleihe bestellbar');
6
6
7
-- availability statuses
7
-- availability statuses
8
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0','');
9
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Lange überfällig (Verloren)');
8
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Lange überfällig (Verloren)');
10
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Verloren');
9
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Verloren');
11
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Verloren und Buchersatz bezahlt');
10
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Verloren und Buchersatz bezahlt');
12
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Vermisst');
11
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Vermisst');
13
12
14
-- damaged status of an item
13
-- damaged status of an item
15
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('DAMAGED','0','');
16
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Beschädigt');
14
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Beschädigt');
17
15
18
-- location qualification for an item, departments are linked by default to items.location
16
-- location qualification for an item, departments are linked by default to items.location
Lines 33-49 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE Link Here
33
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Sachliteratur');
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Sachliteratur');
34
32
35
-- withdrawn status of an item, linked to items.wthdrawn
33
-- withdrawn status of an item, linked to items.wthdrawn
36
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','0','');
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ausgeschieden');
34
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Ausgeschieden');
38
35
39
-- loanability status of an item, linked to items.notforloan
36
-- loanability status of an item, linked to items.notforloan
40
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Bestellt');
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Bestellt');
41
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','0','');
42
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Nicht entleihbar');
38
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Nicht entleihbar');
43
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Mitarbeiterbibliothek');
39
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Mitarbeiterbibliothek');
44
40
45
-- restricted status of an item, linked to items.restricted
41
-- restricted status of an item, linked to items.restricted
46
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','0','');
47
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Eingeschränkt zugänglich');
42
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Eingeschränkt zugänglich');
48
43
49
-- manual invoice types
44
-- manual invoice types
(-)a/installer/data/mysql/en/optional/auth_val.sql (-5 lines)
Lines 5-18 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST Link Here
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');
6
6
7
-- availability statuses
7
-- availability statuses
8
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0','');
9
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)');
8
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)');
10
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost');
9
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost');
11
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For');
10
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For');
12
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Missing');
11
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Missing');
13
12
14
-- damaged status of an item
13
-- damaged status of an item
15
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('DAMAGED','0','');
16
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged');
14
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged');
17
15
18
-- location qualification for an item, departments are linked by default to items.location
16
-- location qualification for an item, departments are linked by default to items.location
Lines 33-49 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE Link Here
33
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
34
32
35
-- withdrawn status of an item, linked to items.wthdrawn
33
-- withdrawn status of an item, linked to items.wthdrawn
36
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','0','');
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');
34
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');
38
35
39
-- loanability status of an item, linked to items.notforloan
36
-- loanability status of an item, linked to items.notforloan
40
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered');
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered');
41
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','0','');
42
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan');
38
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan');
43
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection');
39
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection');
44
40
45
-- restricted status of an item, linked to items.restricted
41
-- restricted status of an item, linked to items.restricted
46
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','0','');
47
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access');
42
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access');
48
43
49
-- manual invoice types
44
-- manual invoice types
(-)a/installer/data/mysql/es-ES/optional/auth_val.sql (-5 lines)
Lines 5-18 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST Link Here
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');
6
6
7
-- availability statuses
7
-- availability statuses
8
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0','');
9
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)');
8
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)');
10
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost');
9
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost');
11
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For');
10
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For');
12
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Missing');
11
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Missing');
13
12
14
-- damaged status of an item
13
-- damaged status of an item
15
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('DAMAGED','0','');
16
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged');
14
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged');
17
15
18
-- location qualification for an item, departments are linked by default to items.location
16
-- location qualification for an item, departments are linked by default to items.location
Lines 33-49 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE Link Here
33
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
34
32
35
-- withdrawn status of an item, linked to items.wthdrawn
33
-- withdrawn status of an item, linked to items.wthdrawn
36
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','0','');
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');
34
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');
38
35
39
-- loanability status of an item, linked to items.notforloan
36
-- loanability status of an item, linked to items.notforloan
40
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered');
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered');
41
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','0','');
42
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan');
38
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan');
43
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection');
39
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection');
44
40
45
-- restricted status of an item, linked to items.restricted
41
-- restricted status of an item, linked to items.restricted
46
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','0','');
47
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access');
42
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access');
48
43
49
-- manual invoice types
44
-- manual invoice types
(-)a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql (-5 lines)
Lines 26-39 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST Link Here
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Tilgjengelig via fjernlån');
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Tilgjengelig via fjernlån');
27
27
28
-- availability statuses
28
-- availability statuses
29
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0','');
30
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Regnes som tapt');
29
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Regnes som tapt');
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Tapt');
30
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Tapt');
32
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Tapt og erstattet');
31
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Tapt og erstattet');
33
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Savnet');
32
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Savnet');
34
33
35
-- damaged status of an item
34
-- damaged status of an item
36
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('DAMAGED','0','');
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Skadet');
35
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Skadet');
38
36
39
-- location qualification for an item, departments are linked by default to items.location
37
-- location qualification for an item, departments are linked by default to items.location
Lines 54-70 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE Link Here
54
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Faglitteratur');
52
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Faglitteratur');
55
53
56
-- withdrawn status of an item, linked to items.wthdrawn
54
-- withdrawn status of an item, linked to items.wthdrawn
57
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','0','');
58
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Trukket tilbake');
55
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Trukket tilbake');
59
56
60
-- loanability status of an item, linked to items.notforloan
57
-- loanability status of an item, linked to items.notforloan
61
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','I bestilling');
58
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','I bestilling');
62
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','0','');
63
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Ikke til utlån');
59
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Ikke til utlån');
64
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Kun til internt bruk');
60
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Kun til internt bruk');
65
61
66
-- restricted status of an item, linked to items.restricted
62
-- restricted status of an item, linked to items.restricted
67
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','0','');
68
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Begrenset tilgang');
63
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Begrenset tilgang');
69
64
70
-- manual invoice types
65
-- manual invoice types
(-)a/installer/data/mysql/pl-PL/optional/auth_val.sql (-5 lines)
Lines 5-18 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST Link Here
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');
6
6
7
-- availability statuses
7
-- availability statuses
8
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0','');
9
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)');
8
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)');
10
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost');
9
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost');
11
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For');
10
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For');
12
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Missing');
11
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Missing');
13
12
14
-- damaged status of an item
13
-- damaged status of an item
15
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('DAMAGED','0','');
16
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged');
14
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged');
17
15
18
-- location qualification for an item, departments are linked by default to items.location
16
-- location qualification for an item, departments are linked by default to items.location
Lines 31-45 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE Link Here
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
29
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
32
30
33
-- withdrawn status of an item, linked to items.wthdrawn
31
-- withdrawn status of an item, linked to items.wthdrawn
34
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','0','');
35
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');
32
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');
36
33
37
-- loanability status of an item, linked to items.notforloan
34
-- loanability status of an item, linked to items.notforloan
38
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered');
35
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered');
39
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','0','');
40
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan');
36
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan');
41
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection');
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection');
42
38
43
-- restricted status of an item, linked to items.restricted
39
-- restricted status of an item, linked to items.restricted
44
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','0','');
45
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access');
40
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access');
(-)a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].sql (-1 lines)
Lines 1-6 Link Here
1
DELETE FROM authorised_values WHERE category='DAMAGED';
1
DELETE FROM authorised_values WHERE category='DAMAGED';
2
2
3
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES 
3
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES 
4
('DAMAGED','0',''),
5
('DAMAGED','1','Повреждено');
4
('DAMAGED','1','Повреждено');
6
5
(-)a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].sql (-7 / +5 lines)
Lines 1-14 Link Here
1
DELETE FROM authorised_values WHERE category='LOST';
1
DELETE FROM authorised_values WHERE category='LOST';
2
2
3
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'LOST','0','');
3
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'LOST','2','Длительная просрочка (утрачено)');
4
4
5
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'LOST','2','Длительная просрочка (утрачено)');
5
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'LOST','1','Утрачено');
6
6
7
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 2,'LOST','1','Утрачено');
7
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 2,'LOST','3','Потеряны и заплачено за экземпляр');
8
8
9
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 3,'LOST','3','Потеряны и заплачено за экземпляр');
9
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 3,'LOST','5','Отсутствует при запросе на резервирование');
10
10
11
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 4,'LOST','5','Отсутствует при запросе на резервирование');
11
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 4,'LOST','4','Отсутствует при инвентиризации');
12
13
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 5,'LOST','4','Отсутствует при инвентиризации');
14
12
(-)a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].sql (-1 lines)
Lines 1-7 Link Here
1
DELETE FROM authorised_values WHERE category='NOT_LOAN';
1
DELETE FROM authorised_values WHERE category='NOT_LOAN';
2
2
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES 
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES 
4
('NOT_LOAN','0', ' Для займа'),
5
('NOT_LOAN','-1','Заказано'),
4
('NOT_LOAN','-1','Заказано'),
6
('NOT_LOAN','1', 'Не для займа'),
5
('NOT_LOAN','1', 'Не для займа'),
7
('NOT_LOAN','2', 'Собрание работника библиотеки'),
6
('NOT_LOAN','2', 'Собрание работника библиотеки'),
(-)a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].sql (-1 lines)
Lines 1-7 Link Here
1
DELETE FROM authorised_values WHERE category='RESTRICTED';
1
DELETE FROM authorised_values WHERE category='RESTRICTED';
2
2
3
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES 
3
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES 
4
('RESTRICTED','0',''),
5
('RESTRICTED','1','Ограниченный доступ');
4
('RESTRICTED','1','Ограниченный доступ');
6
5
7
6
(-)a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].sql (-1 lines)
Lines 1-7 Link Here
1
DELETE FROM authorised_values WHERE category='WITHDRAWN';
1
DELETE FROM authorised_values WHERE category='WITHDRAWN';
2
2
3
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES 
3
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES 
4
('WITHDRAWN','0',''),
5
('WITHDRAWN','1','Изъято');
4
('WITHDRAWN','1','Изъято');
6
5
7
6
(-)a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[DAMAGED].sql (-1 lines)
Lines 1-5 Link Here
1
DELETE FROM authorised_values WHERE category='DAMAGED';
1
DELETE FROM authorised_values WHERE category='DAMAGED';
2
2
3
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES 
3
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES 
4
('DAMAGED','0',''),
5
('DAMAGED','1','Пошкоджено');
4
('DAMAGED','1','Пошкоджено');
(-)a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[LOST].sql (-7 / +5 lines)
Lines 1-13 Link Here
1
DELETE FROM authorised_values WHERE category='LOST';
1
DELETE FROM authorised_values WHERE category='LOST';
2
2
3
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'LOST','0','');
3
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'LOST','2','Тривале прострочення (втрачено)');
4
4
5
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'LOST','2','Тривале прострочення (втрачено)');
5
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'LOST','1','Втрачено');
6
6
7
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 2,'LOST','1','Втрачено');
7
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 2,'LOST','3','Втрачено і заплачено за примірник');
8
8
9
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 3,'LOST','3','Втрачено і заплачено за примірник');
9
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 3,'LOST','5','Відсутнє при запиті на резервування');
10
10
11
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 4,'LOST','5','Відсутнє при запиті на резервування');
11
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 4,'LOST','4','Відсутнє при інвентаризації');
12
13
INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 5,'LOST','4','Відсутнє при інвентаризації');
(-)a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[NOT_LOAN].sql (-1 lines)
Lines 1-7 Link Here
1
DELETE FROM authorised_values WHERE category='NOT_LOAN';
1
DELETE FROM authorised_values WHERE category='NOT_LOAN';
2
2
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES 
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES 
4
('NOT_LOAN','0', ' Для випожичання'),
5
('NOT_LOAN','-1','Замовлено'),
4
('NOT_LOAN','-1','Замовлено'),
6
('NOT_LOAN','1', 'Не для випожичання'),
5
('NOT_LOAN','1', 'Не для випожичання'),
7
('NOT_LOAN','2', 'Зібрання працівника бібліотеки'),
6
('NOT_LOAN','2', 'Зібрання працівника бібліотеки'),
(-)a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[RESTRICTED].sql (-1 lines)
Lines 1-5 Link Here
1
DELETE FROM authorised_values WHERE category='RESTRICTED';
1
DELETE FROM authorised_values WHERE category='RESTRICTED';
2
2
3
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES 
3
INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES 
4
('RESTRICTED','0',''),
5
('RESTRICTED','1','Обмежений доступ');
4
('RESTRICTED','1','Обмежений доступ');
(-)a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].sql (-2 lines)
Lines 1-5 Link Here
1
DELETE FROM authorised_values WHERE category='WITHDRAWN';
1
DELETE FROM authorised_values WHERE category='WITHDRAWN';
2
2
3
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES 
3
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES 
4
('WITHDRAWN','0',''),
5
('WITHDRAWN','1','Вилучено');
4
('WITHDRAWN','1','Вилучено');
6
- 

Return to bug 2399