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

(-)a/installer/data/mysql/en/optional/auth_val.sql (-36 / +108 lines)
Lines 1-59 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
3
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Shelf Copy Damaged');
3
INTO authorised_values (category, authorised_value, lib)
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Library Copy Lost');
4
VALUES ('SUGGEST', 'BSELL', i18n('Bestseller'));
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Available via ILL');
5
INSERT
6
INTO authorised_values (category, authorised_value, lib)
7
VALUES ('SUGGEST', 'SCD', i18n('Shelf Copy Damaged'));
8
INSERT
9
INTO authorised_values (category, authorised_value, lib)
10
VALUES ('SUGGEST', 'LCL', i18n('Library Copy Lost'));
11
INSERT
12
INTO authorised_values (category, authorised_value, lib)
13
VALUES ('SUGGEST', 'AVILL', i18n('Available via ILL'));
6
14
7
-- availability statuses
15
-- availability statuses
8
INSERT INTO `authorised_values`  (category, authorised_value, lib) VALUES ('LOST','2','Long Overdue (Lost)');
16
INSERT
9
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','1','Lost');
17
INTO authorised_values (category, authorised_value, lib)
10
INSERT INTO `authorised_values`  (category, authorised_value, lib ) VALUES ('LOST','3','Lost and Paid For');
18
VALUES ('LOST', '2', i18n('Long Overdue (Lost)'));
11
INSERT INTO `authorised_values`  (category, authorised_value, lib )VALUES ('LOST','4','Missing');
19
INSERT
20
INTO authorised_values (category, authorised_value, lib)
21
VALUES ('LOST', '1', i18n('Lost'));
22
INSERT
23
INTO authorised_values (category, authorised_value, lib)
24
VALUES ('LOST', '3', i18n('Lost and Paid For'));
25
INSERT
26
INTO authorised_values (category, authorised_value, lib)
27
VALUES ('LOST', '4', i18n('Missing'));
12
28
13
-- damaged status of an item
29
-- damaged status of an item
14
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('DAMAGED','1','Damaged');
30
INSERT
31
INTO authorised_values (category, authorised_value, lib)
32
VALUES ('DAMAGED', '1', i18n('Damaged'));
15
33
16
-- location qualification for an item, departments are linked by default to items.location
34
-- location qualification for an item, departments are linked by default to items.location
17
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Fiction');
35
INSERT
18
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CHILD','Children\'s Area');
36
INTO authorised_values (category, authorised_value, lib)
19
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','DISPLAY','On Display');
37
VALUES ('LOC', 'FIC', i18n('Fiction'));
20
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','NEW','New Materials Shelf');
38
INSERT
21
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','STAFF','Staff Office');
39
INTO authorised_values (category, authorised_value, lib)
22
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','General Stacks');
40
VALUES ('LOC', 'CHILD', i18n('Children\'s Area'));
23
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','Audio Visual');
41
INSERT
24
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Reference');
42
INTO authorised_values (category, authorised_value, lib)
25
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CART','Book Cart');
43
VALUES ('LOC', 'DISPLAY', i18n('On Display'));
26
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','PROC','Processing Center');
44
INSERT
45
INTO authorised_values (category, authorised_value, lib)
46
VALUES ('LOC', 'NEW', i18n('New Materials Shelf'));
47
INSERT
48
INTO authorised_values (category, authorised_value, lib)
49
VALUES ('LOC', 'STAFF', i18n('Staff Office'));
50
INSERT
51
INTO authorised_values (category, authorised_value, lib)
52
VALUES ('LOC', 'GEN', i18n('General Stacks'));
53
INSERT
54
INTO authorised_values (category, authorised_value, lib)
55
VALUES ('LOC', 'AV', i18n('Audio Visual'));
56
INSERT
57
INTO authorised_values (category, authorised_value, lib)
58
VALUES ('LOC', 'REF', i18n('Reference'));
59
INSERT
60
INTO authorised_values (category, authorised_value, lib)
61
VALUES ('LOC', 'CART', i18n('Book Cart'));
62
INSERT
63
INTO authorised_values (category, authorised_value, lib)
64
VALUES ('LOC', 'PROC', i18n('Processing Center'));
27
65
28
-- collection codes for an item
66
-- collection codes for an item
29
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction');
67
INSERT
30
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','REF','Reference');
68
INTO authorised_values (category, authorised_value, lib)
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('CCODE','NFIC','Non Fiction');
69
VALUES ('CCODE', 'FIC', i18n('Fiction'));
70
INSERT
71
INTO authorised_values (category, authorised_value, lib)
72
VALUES ('CCODE', 'REF', i18n('Reference'));
73
INSERT
74
INTO authorised_values (category, authorised_value, lib)
75
VALUES ('CCODE', 'NFIC', i18n('Non Fiction'));
32
76
33
-- withdrawn status of an item, linked to items.wthdrawn
77
-- withdrawn status of an item, linked to items.wthdrawn
34
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('WITHDRAWN','1','Withdrawn');
78
INSERT
79
INTO authorised_values (category, authorised_value, lib)
80
VALUES ('WITHDRAWN', '1', i18n('Withdrawn'));
35
81
36
-- loanability status of an item, linked to items.notforloan
82
-- loanability status of an item, linked to items.notforloan
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','-1','Ordered');
83
INSERT
38
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','1','Not For Loan');
84
INTO authorised_values (category, authorised_value, lib)
39
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('NOT_LOAN','2','Staff Collection');
85
VALUES ('NOT_LOAN', '-1', i18n('Ordered'));
86
INSERT
87
INTO authorised_values (category, authorised_value, lib)
88
VALUES ('NOT_LOAN', '1', i18n('Not For Loan'));
89
INSERT
90
INTO authorised_values (category, authorised_value, lib)
91
VALUES ('NOT_LOAN', '2', i18n('Staff Collection'));
40
92
41
-- restricted status of an item, linked to items.restricted
93
-- restricted status of an item, linked to items.restricted
42
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('RESTRICTED','1','Restricted Access');
94
INSERT
95
INTO authorised_values (category, authorised_value, lib)
96
VALUES ('RESTRICTED', '1', i18n('Restricted Access'));
43
97
44
-- manual invoice types
98
-- manual invoice types
45
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('MANUAL_INV','Copier Fees','.25');
99
INSERT
100
INTO authorised_values (category, authorised_value, lib)
101
VALUES ('MANUAL_INV', 'Copier Fees', i18n('.25'));
46
102
47
-- custom borrower notes
103
-- custom borrower notes
48
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('BOR_NOTES','ADDR','Address Notes');
104
INSERT
105
INTO authorised_values (category, authorised_value, lib)
106
VALUES ('BOR_NOTES', 'ADDR', i18n('Address Notes'));
49
107
50
-- OPAC Suggestions reasons
108
-- OPAC Suggestions reasons
51
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','damaged','The copy on the shelf is damaged','The copy on the shelf is damaged');
109
INSERT
52
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('OPAC_SUG','bestseller','Upcoming title by popular author','Upcoming title by popular author');
110
INTO authorised_values (category, authorised_value, lib, lib_opac)
111
VALUES ('OPAC_SUG', 'damaged', i18n('The copy on the shelf is damaged'), i18n('The copy on the shelf is damaged'));
112
INSERT
113
INTO authorised_values (category, authorised_value, lib, lib_opac)
114
VALUES ('OPAC_SUG', 'bestseller', i18n('Upcoming title by popular author'), i18n('Upcoming title by popular author'));
53
115
54
-- Report groups
116
-- Report groups
55
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CIRC', 'Circulation');
117
INSERT
56
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'CAT', 'Catalog');
118
INTO authorised_values (category, authorised_value, lib)
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Patrons');
119
VALUES ('REPORT_GROUP', 'CIRC', i18n('Circulation'));
58
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Acquisitions');
120
INSERT
59
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Accounts');
121
INTO authorised_values (category, authorised_value, lib)
122
VALUES ('REPORT_GROUP', 'CAT', i18n('Catalog'));
123
INSERT
124
INTO authorised_values (category, authorised_value, lib)
125
VALUES ('REPORT_GROUP', 'PAT', i18n('Patrons'));
126
INSERT
127
INTO authorised_values (category, authorised_value, lib)
128
VALUES ('REPORT_GROUP', 'ACQ', i18n('Acquisitions'));
129
INSERT
130
INTO authorised_values (category, authorised_value, lib)
131
VALUES ('REPORT_GROUP', 'ACC', i18n('Accounts'));
(-)a/installer/data/mysql/en/optional/marc21_holdings_coded_values.sql (-127 / +356 lines)
Lines 3-145 Link Here
3
-- Refer to http://www.niso.org/standards/index.html
3
-- Refer to http://www.niso.org/standards/index.html
4
4
5
-- General Holdings: Type of Unit Designator
5
-- General Holdings: Type of Unit Designator
6
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','0','Information not available; Not applicable');INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','a','Basic bibliographic unit');
6
INSERT
7
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','c','Secondary bibliographic unit: supplements, special issues, accompanying material, other secondary bibliographic units');
7
INTO authorised_values (category, authorised_value, lib)
8
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','d','Indexes');
8
VALUES ('HINGS_UT', '0', i18n('Information not available; Not applicable'));
9
INSERT
10
INTO authorised_values (category, authorised_value, lib)
11
VALUES ('HINGS_UT', 'a', i18n('Basic bibliographic unit'));
12
INSERT
13
INTO authorised_values (category, authorised_value, lib)
14
VALUES ('HINGS_UT', 'c', i18n('Secondary bibliographic unit: supplements, special issues, accompanying material, other secondary bibliographic units'));
15
INSERT
16
INTO authorised_values (category, authorised_value, lib)
17
VALUES ('HINGS_UT', 'd', i18n('Indexes'));
9
18
10
-- Physical Form Designators
19
-- Physical Form Designators
11
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','au','Cartographic material');
20
INSERT
12
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ad','Cartographic material, atlas');
21
INTO authorised_values (category, authorised_value, lib)
13
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ag' ,'Cartographic material, diagram');
22
VALUES ('HINGS_PF', 'au', i18n('Cartographic material'));
14
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','aj' ,'Cartographic material, map');
23
INSERT
15
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ak' ,'Cartographic material, profile');
24
INTO authorised_values (category, authorised_value, lib)
16
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','aq' ,'Cartographic material, model');
25
VALUES ('HINGS_PF', 'ad', i18n('Cartographic material, atlas'));
17
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ar' ,'Cartographic material, remote sensing image');
26
INSERT
18
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','as' ,'Cartographic material, section');
27
INTO authorised_values (category, authorised_value, lib)
19
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ay' ,'Cartographic material, view');
28
VALUES ('HINGS_PF', 'ag', i18n('Cartographic material, diagram'));
20
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','az' ,'Cartographic material, other');
29
INSERT
21
30
INTO authorised_values (category, authorised_value, lib)
22
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cu' ,'Computer file');
31
VALUES ('HINGS_PF', 'aj', i18n('Cartographic material, map'));
23
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ca' ,'Computer file, tape cartridge');
32
INSERT
24
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cb' ,'Computer file, chip cartridge');
33
INTO authorised_values (category, authorised_value, lib)
25
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cc' ,'Computer file, computer optical disk cartridge');
34
VALUES ('HINGS_PF', 'ak', i18n('Cartographic material, profile'));
26
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cf' ,'Computer file, tape cassette');
35
INSERT
27
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ch' ,'Computer file, tape reel');
36
INTO authorised_values (category, authorised_value, lib)
28
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cj' ,'Computer file, magnetic disk');
37
VALUES ('HINGS_PF', 'aq', i18n('Cartographic material, model'));
29
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cm' ,'Computer file, magneto-optical disk');
38
INSERT
30
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','co' ,'Computer file, optical disk');
39
INTO authorised_values (category, authorised_value, lib)
31
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cr' ,'Computer file, remote');
40
VALUES ('HINGS_PF', 'ar', i18n('Cartographic material, remote sensing image'));
32
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cz' ,'Computer file, other');
41
INSERT
33
42
INTO authorised_values (category, authorised_value, lib)
34
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','du' ,'Globe');
43
VALUES ('HINGS_PF', 'as', i18n('Cartographic material, section'));
35
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','da' ,'Globe, celestial');
44
INSERT
36
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','db' ,'Globe, planetary or lunar');
45
INTO authorised_values (category, authorised_value, lib)
37
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','dc' ,'Globe, terrestrial');
46
VALUES ('HINGS_PF', 'ay', i18n('Cartographic material, view'));
38
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','de' ,'Globe, earth moon');
47
INSERT
39
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','dz' ,'Globe, other');
48
INTO authorised_values (category, authorised_value, lib)
40
49
VALUES ('HINGS_PF', 'az', i18n('Cartographic material, other'));
41
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ou' ,'Kit');
50
42
51
INSERT
43
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hu' ,'Microform');
52
INTO authorised_values (category, authorised_value, lib)
44
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ha' ,'Microform, aperture card');
53
VALUES ('HINGS_PF', 'cu', i18n('Computer file'));
45
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hb',' Microform, microfilm cartridge');
54
INSERT
46
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hc',' Microform, microfilm cassette');
55
INTO authorised_values (category, authorised_value, lib)
47
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hd',' Microform, microfilm reel');
56
VALUES ('HINGS_PF', 'ca', i18n('Computer file, tape cartridge'));
48
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','he' ,'Microform, microfiche');
57
INSERT
49
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hf' ,'Microform, microfiche cassette');
58
INTO authorised_values (category, authorised_value, lib)
50
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hg' ,'Microform, micro-opaque');
59
VALUES ('HINGS_PF', 'cb', i18n('Computer file, chip cartridge'));
51
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hz' ,'Microform, other');
60
INSERT
52
61
INTO authorised_values (category, authorised_value, lib)
53
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mu' ,'Motion picture');
62
VALUES ('HINGS_PF', 'cc', i18n('Computer file, computer optical disk cartridge'));
54
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mc' ,'Motion picture, film cartridge');
63
INSERT
55
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mf' ,'Motion picture, film cassette');
64
INTO authorised_values (category, authorised_value, lib)
56
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mr' ,'Motion picture, film reel');
65
VALUES ('HINGS_PF', 'cf', i18n('Computer file, tape cassette'));
57
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mz' ,'Motion picture, other');
66
INSERT
58
67
INTO authorised_values (category, authorised_value, lib)
59
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ku' ,'Nonprojected graphic');
68
VALUES ('HINGS_PF', 'ch', i18n('Computer file, tape reel'));
60
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kc' ,'Nonprojected graphic, collage');
69
INSERT
61
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kd' ,'Nonprojected graphic, drawing');
70
INTO authorised_values (category, authorised_value, lib)
62
71
VALUES ('HINGS_PF', 'cj', i18n('Computer file, magnetic disk'));
63
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ke' ,'Nonprojected graphic, painting');
72
INSERT
64
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kf' ,'Nonprojected graphic, photomechanical print');
73
INTO authorised_values (category, authorised_value, lib)
65
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kg' ,'Nonprojected graphic, photonegative');
74
VALUES ('HINGS_PF', 'cm', i18n('Computer file, magneto-optical disk'));
66
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kh' ,'Nonprojected graphic, photoprint');
75
INSERT
67
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ki' ,'Nonprojected graphic, picture');
76
INTO authorised_values (category, authorised_value, lib)
68
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kj' ,'Nonprojected graphic, print');
77
VALUES ('HINGS_PF', 'co', i18n('Computer file, optical disk'));
69
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kl' ,'Nonprojected graphic, technical drawing');
78
INSERT
70
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kn' ,'Nonprojected graphic, chart');
79
INTO authorised_values (category, authorised_value, lib)
71
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ko' ,'Nonprojected graphic, flash card');
80
VALUES ('HINGS_PF', 'cr', i18n('Computer file, remote'));
72
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kz' ,'Nonprojected graphic, other');
81
INSERT
73
82
INTO authorised_values (category, authorised_value, lib)
74
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','qu' ,'Notated music');
83
VALUES ('HINGS_PF', 'cz', i18n('Computer file, other'));
75
84
76
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gu' ,'Projected graphic');
85
INSERT
77
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gc' ,'Projected graphic, filmstrip cartridge');
86
INTO authorised_values (category, authorised_value, lib)
78
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gd' ,'Projected graphic, filmstrip');
87
VALUES ('HINGS_PF', 'du', i18n('Globe'));
79
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gf' ,'Projected graphic, other type of filmstrip');
88
INSERT
80
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','go' ,'Projected graphic, filmstrip roll');
89
INTO authorised_values (category, authorised_value, lib)
81
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gs' ,'Projected graphic, slide');
90
VALUES ('HINGS_PF', 'da', i18n('Globe, celestial'));
82
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gt' ,'Projected graphic, transparency');
91
INSERT
83
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gz' ,'Projected graphic, other');
92
INTO authorised_values (category, authorised_value, lib)
84
93
VALUES ('HINGS_PF', 'db', i18n('Globe, planetary or lunar'));
85
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ru' ,'Remote-sensing image');
94
INSERT
86
95
INTO authorised_values (category, authorised_value, lib)
87
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','su' ,'Sound recording');
96
VALUES ('HINGS_PF', 'dc', i18n('Globe, terrestrial'));
88
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sd' ,'Sound recording, sound disk');
97
INSERT
89
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','se' ,'Sound recording, cylinder');
98
INTO authorised_values (category, authorised_value, lib)
90
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sg' ,'Sound recording, sound cartridge');
99
VALUES ('HINGS_PF', 'de', i18n('Globe, earth moon'));
91
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','si' ,'Sound recording, sound-track film');
100
INSERT
92
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sq' ,'Sound recording, roll');
101
INTO authorised_values (category, authorised_value, lib)
93
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ss' ,'Sound recording, sound cassette');
102
VALUES ('HINGS_PF', 'dz', i18n('Globe, other'));
94
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','st' ,'Sound recording, sound-tape reel');
103
95
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sw' ,'Sound recording, wire recording');
104
INSERT
96
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sz' ,'Sound recording, other');
105
INTO authorised_values (category, authorised_value, lib)
97
106
VALUES ('HINGS_PF', 'ou', i18n('Kit'));
98
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tu' ,'Text');
107
99
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ta' ,'Text, regular print');
108
INSERT
100
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tb' ,'Text, large print');
109
INTO authorised_values (category, authorised_value, lib)
101
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tc' ,'Text, Braille');
110
VALUES ('HINGS_PF', 'hu', i18n('Microform'));
102
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','td' ,'Text, loose-leaf');
111
INSERT
103
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tz' ,'Text, other');
112
INTO authorised_values (category, authorised_value, lib)
104
113
VALUES ('HINGS_PF', 'ha', i18n('Microform, aperture card'));
105
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vu' ,'Videorecording');
114
INSERT
106
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vc' ,'Videorecording, videocartridge');
115
INTO authorised_values (category, authorised_value, lib)
107
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vd' ,'Videorecording, videodisc');
116
VALUES ('HINGS_PF', 'hb', i18n(' Microform, microfilm cartridge'));
108
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vf' ,'Videorecording, videocassette');
117
INSERT
109
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vr' ,'Videorecording, videoreel');
118
INTO authorised_values (category, authorised_value, lib)
110
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vz' ,'Videorecording, other');
119
VALUES ('HINGS_PF', 'hc', i18n(' Microform, microfilm cassette'));
111
120
INSERT
112
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zu' ,'Physical form is unspecified');
121
INTO authorised_values (category, authorised_value, lib)
113
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zm' ,'Multiple physical forms');
122
VALUES ('HINGS_PF', 'hd', i18n(' Microform, microfilm reel'));
114
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zz' ,'Other physical media');
123
INSERT
124
INTO authorised_values (category, authorised_value, lib)
125
VALUES ('HINGS_PF', 'he', i18n('Microform, microfiche'));
126
INSERT
127
INTO authorised_values (category, authorised_value, lib)
128
VALUES ('HINGS_PF', 'hf', i18n('Microform, microfiche cassette'));
129
INSERT
130
INTO authorised_values (category, authorised_value, lib)
131
VALUES ('HINGS_PF', 'hg', i18n('Microform, micro-opaque'));
132
INSERT
133
INTO authorised_values (category, authorised_value, lib)
134
VALUES ('HINGS_PF', 'hz', i18n('Microform, other'));
135
136
INSERT
137
INTO authorised_values (category, authorised_value, lib)
138
VALUES ('HINGS_PF', 'mu', i18n('Motion picture'));
139
INSERT
140
INTO authorised_values (category, authorised_value, lib)
141
VALUES ('HINGS_PF', 'mc', i18n('Motion picture, film cartridge'));
142
INSERT
143
INTO authorised_values (category, authorised_value, lib)
144
VALUES ('HINGS_PF', 'mf', i18n('Motion picture, film cassette'));
145
INSERT
146
INTO authorised_values (category, authorised_value, lib)
147
VALUES ('HINGS_PF', 'mr', i18n('Motion picture, film reel'));
148
INSERT
149
INTO authorised_values (category, authorised_value, lib)
150
VALUES ('HINGS_PF', 'mz', i18n('Motion picture, other'));
151
152
INSERT
153
INTO authorised_values (category, authorised_value, lib)
154
VALUES ('HINGS_PF', 'ku', i18n('Nonprojected graphic'));
155
INSERT
156
INTO authorised_values (category, authorised_value, lib)
157
VALUES ('HINGS_PF', 'kc', i18n('Nonprojected graphic, collage'));
158
INSERT
159
INTO authorised_values (category, authorised_value, lib)
160
VALUES ('HINGS_PF', 'kd', i18n('Nonprojected graphic, drawing'));
161
162
INSERT
163
INTO authorised_values (category, authorised_value, lib)
164
VALUES ('HINGS_PF', 'ke', i18n('Nonprojected graphic, painting'));
165
INSERT
166
INTO authorised_values (category, authorised_value, lib)
167
VALUES ('HINGS_PF', 'kf', i18n('Nonprojected graphic, photomechanical print'));
168
INSERT
169
INTO authorised_values (category, authorised_value, lib)
170
VALUES ('HINGS_PF', 'kg', i18n('Nonprojected graphic, photonegative'));
171
INSERT
172
INTO authorised_values (category, authorised_value, lib)
173
VALUES ('HINGS_PF', 'kh', i18n('Nonprojected graphic, photoprint'));
174
INSERT
175
INTO authorised_values (category, authorised_value, lib)
176
VALUES ('HINGS_PF', 'ki', i18n('Nonprojected graphic, picture'));
177
INSERT
178
INTO authorised_values (category, authorised_value, lib)
179
VALUES ('HINGS_PF', 'kj', i18n('Nonprojected graphic, print'));
180
INSERT
181
INTO authorised_values (category, authorised_value, lib)
182
VALUES ('HINGS_PF', 'kl', i18n('Nonprojected graphic, technical drawing'));
183
INSERT
184
INTO authorised_values (category, authorised_value, lib)
185
VALUES ('HINGS_PF', 'kn', i18n('Nonprojected graphic, chart'));
186
INSERT
187
INTO authorised_values (category, authorised_value, lib)
188
VALUES ('HINGS_PF', 'ko', i18n('Nonprojected graphic, flash card'));
189
INSERT
190
INTO authorised_values (category, authorised_value, lib)
191
VALUES ('HINGS_PF', 'kz', i18n('Nonprojected graphic, other'));
192
193
INSERT
194
INTO authorised_values (category, authorised_value, lib)
195
VALUES ('HINGS_PF', 'qu', i18n('Notated music'));
196
197
INSERT
198
INTO authorised_values (category, authorised_value, lib)
199
VALUES ('HINGS_PF', 'gu', i18n('Projected graphic'));
200
INSERT
201
INTO authorised_values (category, authorised_value, lib)
202
VALUES ('HINGS_PF', 'gc', i18n('Projected graphic, filmstrip cartridge'));
203
INSERT
204
INTO authorised_values (category, authorised_value, lib)
205
VALUES ('HINGS_PF', 'gd', i18n('Projected graphic, filmstrip'));
206
INSERT
207
INTO authorised_values (category, authorised_value, lib)
208
VALUES ('HINGS_PF', 'gf', i18n('Projected graphic, other type of filmstrip'));
209
INSERT
210
INTO authorised_values (category, authorised_value, lib)
211
VALUES ('HINGS_PF', 'go', i18n('Projected graphic, filmstrip roll'));
212
INSERT
213
INTO authorised_values (category, authorised_value, lib)
214
VALUES ('HINGS_PF', 'gs', i18n('Projected graphic, slide'));
215
INSERT
216
INTO authorised_values (category, authorised_value, lib)
217
VALUES ('HINGS_PF', 'gt', i18n('Projected graphic, transparency'));
218
INSERT
219
INTO authorised_values (category, authorised_value, lib)
220
VALUES ('HINGS_PF', 'gz', i18n('Projected graphic, other'));
221
222
INSERT
223
INTO authorised_values (category, authorised_value, lib)
224
VALUES ('HINGS_PF', 'ru', i18n('Remote-sensing image'));
225
226
INSERT
227
INTO authorised_values (category, authorised_value, lib)
228
VALUES ('HINGS_PF', 'su', i18n('Sound recording'));
229
INSERT
230
INTO authorised_values (category, authorised_value, lib)
231
VALUES ('HINGS_PF', 'sd', i18n('Sound recording, sound disk'));
232
INSERT
233
INTO authorised_values (category, authorised_value, lib)
234
VALUES ('HINGS_PF', 'se', i18n('Sound recording, cylinder'));
235
INSERT
236
INTO authorised_values (category, authorised_value, lib)
237
VALUES ('HINGS_PF', 'sg', i18n('Sound recording, sound cartridge'));
238
INSERT
239
INTO authorised_values (category, authorised_value, lib)
240
VALUES ('HINGS_PF', 'si', i18n('Sound recording, sound-track film'));
241
INSERT
242
INTO authorised_values (category, authorised_value, lib)
243
VALUES ('HINGS_PF', 'sq', i18n('Sound recording, roll'));
244
INSERT
245
INTO authorised_values (category, authorised_value, lib)
246
VALUES ('HINGS_PF', 'ss', i18n('Sound recording, sound cassette'));
247
INSERT
248
INTO authorised_values (category, authorised_value, lib)
249
VALUES ('HINGS_PF', 'st', i18n('Sound recording, sound-tape reel'));
250
INSERT
251
INTO authorised_values (category, authorised_value, lib)
252
VALUES ('HINGS_PF', 'sw', i18n('Sound recording, wire recording'));
253
INSERT
254
INTO authorised_values (category, authorised_value, lib)
255
VALUES ('HINGS_PF', 'sz', i18n('Sound recording, other'));
256
257
INSERT
258
INTO authorised_values (category, authorised_value, lib)
259
VALUES ('HINGS_PF', 'tu', i18n('Text'));
260
INSERT
261
INTO authorised_values (category, authorised_value, lib)
262
VALUES ('HINGS_PF', 'ta', i18n('Text, regular print'));
263
INSERT
264
INTO authorised_values (category, authorised_value, lib)
265
VALUES ('HINGS_PF', 'tb', i18n('Text, large print'));
266
INSERT
267
INTO authorised_values (category, authorised_value, lib)
268
VALUES ('HINGS_PF', 'tc', i18n('Text, Braille'));
269
INSERT
270
INTO authorised_values (category, authorised_value, lib)
271
VALUES ('HINGS_PF', 'td', i18n('Text, loose-leaf'));
272
INSERT
273
INTO authorised_values (category, authorised_value, lib)
274
VALUES ('HINGS_PF', 'tz', i18n('Text, other'));
275
276
INSERT
277
INTO authorised_values (category, authorised_value, lib)
278
VALUES ('HINGS_PF', 'vu', i18n('Videorecording'));
279
INSERT
280
INTO authorised_values (category, authorised_value, lib)
281
VALUES ('HINGS_PF', 'vc', i18n('Videorecording, videocartridge'));
282
INSERT
283
INTO authorised_values (category, authorised_value, lib)
284
VALUES ('HINGS_PF', 'vd', i18n('Videorecording, videodisc'));
285
INSERT
286
INTO authorised_values (category, authorised_value, lib)
287
VALUES ('HINGS_PF', 'vf', i18n('Videorecording, videocassette'));
288
INSERT
289
INTO authorised_values (category, authorised_value, lib)
290
VALUES ('HINGS_PF', 'vr', i18n('Videorecording, videoreel'));
291
INSERT
292
INTO authorised_values (category, authorised_value, lib)
293
VALUES ('HINGS_PF', 'vz', i18n('Videorecording, other'));
294
295
INSERT
296
INTO authorised_values (category, authorised_value, lib)
297
VALUES ('HINGS_PF', 'zu', i18n('Physical form is unspecified'));
298
INSERT
299
INTO authorised_values (category, authorised_value, lib)
300
VALUES ('HINGS_PF', 'zm', i18n('Multiple physical forms'));
301
INSERT
302
INTO authorised_values (category, authorised_value, lib)
303
VALUES ('HINGS_PF', 'zz', i18n('Other physical media'));
115
304
116
-- General Holdings: Completeness Designator 
305
-- General Holdings: Completeness Designator 
117
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','0','Information not available, or Retention is limited');
306
INSERT
118
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','1','Complete (95%-100% held)');
307
INTO authorised_values (category, authorised_value, lib)
119
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','2','Incomplete (50%-94% held)');
308
VALUES ('HINGS_C', '0', i18n('Information not available, or Retention is limited'));
120
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','3','Very incomplete or scattered (less than 50% held)');
309
INSERT
121
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','4','Not applicable');
310
INTO authorised_values (category, authorised_value, lib)
311
VALUES ('HINGS_C', '1', i18n('Complete (95%-100% held)'));
312
INSERT
313
INTO authorised_values (category, authorised_value, lib)
314
VALUES ('HINGS_C', '2', i18n('Incomplete (50%-94% held)'));
315
INSERT
316
INTO authorised_values (category, authorised_value, lib)
317
VALUES ('HINGS_C', '3', i18n('Very incomplete or scattered (less than 50% held)'));
318
INSERT
319
INTO authorised_values (category, authorised_value, lib)
320
VALUES ('HINGS_C', '4', i18n('Not applicable'));
122
321
123
-- General Holdings: Acquisition Status Designator
322
-- General Holdings: Acquisition Status Designator
124
-- This data element specifies acquisition status for the unit at the time of the holdings report.
323
-- This data element specifies acquisition status for the unit at the time of the holdings report.
125
324
126
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','0','Information not available, or Retention is limited');
325
INSERT
127
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','1','Other');
326
INTO authorised_values (category, authorised_value, lib)
128
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','2','Received and complete or Ceased');
327
VALUES ('HINGS_AS', '0', i18n('Information not available, or Retention is limited'));
129
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','3','On order');
328
INSERT
130
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','4','Currently received');
329
INTO authorised_values (category, authorised_value, lib)
131
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','5','Not currently received');
330
VALUES ('HINGS_AS', '1', i18n('Other'));
331
INSERT
332
INTO authorised_values (category, authorised_value, lib)
333
VALUES ('HINGS_AS', '2', i18n('Received and complete or Ceased'));
334
INSERT
335
INTO authorised_values (category, authorised_value, lib)
336
VALUES ('HINGS_AS', '3', i18n('On order'));
337
INSERT
338
INTO authorised_values (category, authorised_value, lib)
339
VALUES ('HINGS_AS', '4', i18n('Currently received'));
340
INSERT
341
INTO authorised_values (category, authorised_value, lib)
342
VALUES ('HINGS_AS', '5', i18n('Not currently received'));
132
343
133
-- General Holdings: Retention Designator
344
-- General Holdings: Retention Designator
134
-- This data element specifies the retention policy for the unit at the time of the holdings report. 
345
-- This data element specifies the retention policy for the unit at the time of the holdings report. 
135
346
136
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','0','Information not available');
347
INSERT
137
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','1','Other');
348
INTO authorised_values (category, authorised_value, lib)
138
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','2','Retained except as replaced by updates');
349
VALUES ('HINGS_RD', '0', i18n('Information not available'));
139
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','3','Sample issue retained');
350
INSERT
140
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','4','Retained until replaced by microform, or other preservation format');
351
INTO authorised_values (category, authorised_value, lib)
141
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','5','Retained until replaced by cumulation, replacement volume, or revision');
352
VALUES ('HINGS_RD', '1', i18n('Other'));
142
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','6','Limited retention (only some parts kept)');
353
INSERT
143
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','7','No retention (no parts kept)');
354
INTO authorised_values (category, authorised_value, lib)
144
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','8','Permanent retention (all parts kept permanently)');
355
VALUES ('HINGS_RD', '2', i18n('Retained except as replaced by updates'));
356
INSERT
357
INTO authorised_values (category, authorised_value, lib)
358
VALUES ('HINGS_RD', '3', i18n('Sample issue retained'));
359
INSERT
360
INTO authorised_values (category, authorised_value, lib)
361
VALUES ('HINGS_RD', '4', i18n('Retained until replaced by microform, or other preservation format'));
362
INSERT
363
INTO authorised_values (category, authorised_value, lib)
364
VALUES ('HINGS_RD', '5', i18n('Retained until replaced by cumulation, replacement volume, or revision'));
365
INSERT
366
INTO authorised_values (category, authorised_value, lib)
367
VALUES ('HINGS_RD', '6', i18n('Limited retention (only some parts kept)'));
368
INSERT
369
INTO authorised_values (category, authorised_value, lib)
370
VALUES ('HINGS_RD', '7', i18n('No retention (no parts kept)'));
371
INSERT
372
INTO authorised_values (category, authorised_value, lib)
373
VALUES ('HINGS_RD', '8', i18n('Permanent retention (all parts kept permanently)'));
145
374
(-)a/installer/data/mysql/en/optional/marc21_relatorterms.sql (-223 / +669 lines)
Lines 1-226 Link Here
1
-- MARC code list for Relators, taken from
1
-- MARC code list for Relators, taken from
2
-- http://www.loc.gov/marc/relators/relacode.html
2
-- http://www.loc.gov/marc/relators/relacode.html
3
3
4
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','acp','Art copyist');
4
INSERT
5
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','act','Actor');
5
INTO authorised_values (category, authorised_value, lib)
6
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','adp','Adapter');
6
VALUES ('RELTERMS', 'acp', i18n('Art copyist'));
7
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aft','Author of afterword, colophon, etc.');
7
INSERT
8
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anl','Analyst');
8
INTO authorised_values (category, authorised_value, lib)
9
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','anm','Animator');
9
VALUES ('RELTERMS', 'act', i18n('Actor'));
10
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ann','Annotator');
10
INSERT
11
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ant','Bibliographic antecedent');
11
INTO authorised_values (category, authorised_value, lib)
12
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','app','Applicant');
12
VALUES ('RELTERMS', 'adp', i18n('Adapter'));
13
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aqt','Author in quotations or text abstracts');
13
INSERT
14
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arc','Architect');
14
INTO authorised_values (category, authorised_value, lib)
15
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ard','Artistic director');
15
VALUES ('RELTERMS', 'aft', i18n('Author of afterword, colophon, etc.'));
16
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','arr','Arranger');
16
INSERT
17
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','art','Artist');
17
INTO authorised_values (category, authorised_value, lib)
18
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asg','Assignee');
18
VALUES ('RELTERMS', 'anl', i18n('Analyst'));
19
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','asn','Associated name');
19
INSERT
20
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','att','Attributed name');
20
INTO authorised_values (category, authorised_value, lib)
21
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','auc','Auctioneer');
21
VALUES ('RELTERMS', 'anm', i18n('Animator'));
22
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aud','Author of dialog');
22
INSERT
23
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aui','Author of introduction');
23
INTO authorised_values (category, authorised_value, lib)
24
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aus','Author of screenplay');
24
VALUES ('RELTERMS', 'ann', i18n('Annotator'));
25
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','aut','Author');
25
INSERT
26
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bdd','Binding designer');
26
INTO authorised_values (category, authorised_value, lib)
27
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bjd','Bookjacket designer');
27
VALUES ('RELTERMS', 'ant', i18n('Bibliographic antecedent'));
28
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkd','Book designer');
28
INSERT
29
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bkp','Book producer');
29
INTO authorised_values (category, authorised_value, lib)
30
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','blw','Blurb writer');
30
VALUES ('RELTERMS', 'app', i18n('Applicant'));
31
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bnd','Binder');
31
INSERT
32
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bpd','Bookplate designer');
32
INTO authorised_values (category, authorised_value, lib)
33
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','bsl','Bookseller');
33
VALUES ('RELTERMS', 'aqt', i18n('Author in quotations or text abstracts'));
34
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ccp','Conceptor');
34
INSERT
35
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','chr','Choreographer');
35
INTO authorised_values (category, authorised_value, lib)
36
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clb','Collaborator');
36
VALUES ('RELTERMS', 'arc', i18n('Architect'));
37
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cli','Client');
37
INSERT
38
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cll','Calligrapher');
38
INTO authorised_values (category, authorised_value, lib)
39
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clr','Colorist');
39
VALUES ('RELTERMS', 'ard', i18n('Artistic director'));
40
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','clt','Collotyper');
40
INSERT
41
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmm','Commentator');
41
INTO authorised_values (category, authorised_value, lib)
42
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmp','Composer');
42
VALUES ('RELTERMS', 'arr', i18n('Arranger'));
43
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cmt','Compositor');
43
INSERT
44
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cng','Cinematographer');
44
INTO authorised_values (category, authorised_value, lib)
45
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cnd','Conductor');
45
VALUES ('RELTERMS', 'art', i18n('Artist'));
46
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cns','Censor');
46
INSERT
47
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','coe','Contestant -appellee');
47
INTO authorised_values (category, authorised_value, lib)
48
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','col','Collector');
48
VALUES ('RELTERMS', 'asg', i18n('Assignee'));
49
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','com','Compiler');
49
INSERT
50
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','con','Conservator');
50
INTO authorised_values (category, authorised_value, lib)
51
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cos','Contestant');
51
VALUES ('RELTERMS', 'asn', i18n('Associated name'));
52
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cot','Contestant -appellant');
52
INSERT
53
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cov','Cover designer');
53
INTO authorised_values (category, authorised_value, lib)
54
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpc','Copyright claimant');
54
VALUES ('RELTERMS', 'att', i18n('Attributed name'));
55
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpe','Complainant-appellee');
55
INSERT
56
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cph','Copyright holder');
56
INTO authorised_values (category, authorised_value, lib)
57
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpl','Complainant');
57
VALUES ('RELTERMS', 'auc', i18n('Auctioneer'));
58
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cpt','Complainant-appellant');
58
INSERT
59
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cre','Creator');
59
INTO authorised_values (category, authorised_value, lib)
60
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','crp','Correspondent');
60
VALUES ('RELTERMS', 'aud', i18n('Author of dialog'));
61
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','crr','Corrector');
61
INSERT
62
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csl','Consultant');
62
INTO authorised_values (category, authorised_value, lib)
63
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','csp','Consultant to a project');
63
VALUES ('RELTERMS', 'aui', i18n('Author of introduction'));
64
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cst','Costume designer');
64
INSERT
65
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctb','Contributor');
65
INTO authorised_values (category, authorised_value, lib)
66
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cte','Contestee-appellee');
66
VALUES ('RELTERMS', 'aus', i18n('Author of screenplay'));
67
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctg','Cartographer');
67
INSERT
68
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctr','Contractor');
68
INTO authorised_values (category, authorised_value, lib)
69
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cts','Contestee');
69
VALUES ('RELTERMS', 'aut', i18n('Author'));
70
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ctt','Contestee-appellant');
70
INSERT
71
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cur','Curator');
71
INTO authorised_values (category, authorised_value, lib)
72
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','cwt','Commentator for written text');
72
VALUES ('RELTERMS', 'bdd', i18n('Binding designer'));
73
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfd','Defendant');
73
INSERT
74
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dfe','Defendant-appellee');
74
INTO authorised_values (category, authorised_value, lib)
75
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dft','Defendant-appellant');
75
VALUES ('RELTERMS', 'bjd', i18n('Bookjacket designer'));
76
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dgg','Degree grantor');
76
INSERT
77
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dis','Dissertant');
77
INTO authorised_values (category, authorised_value, lib)
78
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dln','Delineator');
78
VALUES ('RELTERMS', 'bkd', i18n('Book designer'));
79
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnc','Dancer');
79
INSERT
80
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dnr','Donor');
80
INTO authorised_values (category, authorised_value, lib)
81
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpb','Distribution place');
81
VALUES ('RELTERMS', 'bkp', i18n('Book producer'));
82
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpc','Depicted');
82
INSERT
83
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dpt','Depositor');
83
INTO authorised_values (category, authorised_value, lib)
84
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drm','Draftsman');
84
VALUES ('RELTERMS', 'blw', i18n('Blurb writer'));
85
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','drt','Director');
85
INSERT
86
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dsr','Designer');
86
INTO authorised_values (category, authorised_value, lib)
87
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dst','Distributor');
87
VALUES ('RELTERMS', 'bnd', i18n('Binder'));
88
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtc','Data contributor');
88
INSERT
89
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dte','Dedicatee');
89
INTO authorised_values (category, authorised_value, lib)
90
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dtm','Data manager');
90
VALUES ('RELTERMS', 'bpd', i18n('Bookplate designer'));
91
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dto','Dedicator');
91
INSERT
92
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','dub','Dubious author');
92
INTO authorised_values (category, authorised_value, lib)
93
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','edt','Editor');
93
VALUES ('RELTERMS', 'bsl', i18n('Bookseller'));
94
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','egr','Engraver');
94
INSERT
95
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elg','Electrician');
95
INTO authorised_values (category, authorised_value, lib)
96
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','elt','Electrotyper');
96
VALUES ('RELTERMS', 'ccp', i18n('Conceptor'));
97
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','eng','Engineer');
97
INSERT
98
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','etr','Etcher');
98
INTO authorised_values (category, authorised_value, lib)
99
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','evp','Event place');
99
VALUES ('RELTERMS', 'chr', i18n('Choreographer'));
100
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','exp','Expert');
100
INSERT
101
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fac','Facsimilist');
101
INTO authorised_values (category, authorised_value, lib)
102
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fld','Field director');
102
VALUES ('RELTERMS', 'clb', i18n('Collaborator'));
103
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','flm','Film editor');
103
INSERT
104
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fmo','Former owner');
104
INTO authorised_values (category, authorised_value, lib)
105
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fpy','First party');
105
VALUES ('RELTERMS', 'cli', i18n('Client'));
106
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','fnd','Funder');
106
INSERT
107
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','frg','Forger');
107
INTO authorised_values (category, authorised_value, lib)
108
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','gis','Geographic information specialist');
108
VALUES ('RELTERMS', 'cll', i18n('Calligrapher'));
109
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','-grt','Graphic technician');
109
INSERT
110
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hnr','Honoree');
110
INTO authorised_values (category, authorised_value, lib)
111
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','hst','Host');
111
VALUES ('RELTERMS', 'clr', i18n('Colorist'));
112
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ill','Illustrator');
112
INSERT
113
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ilu','Illuminator');
113
INTO authorised_values (category, authorised_value, lib)
114
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ins','Inscriber');
114
VALUES ('RELTERMS', 'clt', i18n('Collotyper'));
115
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','inv','Inventor');
115
INSERT
116
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','itr','Instrumentalist');
116
INTO authorised_values (category, authorised_value, lib)
117
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ive','Interviewee');
117
VALUES ('RELTERMS', 'cmm', i18n('Commentator'));
118
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ivr','Interviewer');
118
INSERT
119
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbr','Laboratory');
119
INTO authorised_values (category, authorised_value, lib)
120
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lbt','Librettist');
120
VALUES ('RELTERMS', 'cmp', i18n('Composer'));
121
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ldr','Laboratory director');
121
INSERT
122
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','led','Lead');
122
INTO authorised_values (category, authorised_value, lib)
123
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lee','Libelee-appellee');
123
VALUES ('RELTERMS', 'cmt', i18n('Compositor'));
124
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lel','Libelee');
124
INSERT
125
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','len','Lender');
125
INTO authorised_values (category, authorised_value, lib)
126
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','let','Libelee-appellant');
126
VALUES ('RELTERMS', 'cng', i18n('Cinematographer'));
127
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lgd','Lighting designer');
127
INSERT
128
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lie','Libelant-appellee');
128
INTO authorised_values (category, authorised_value, lib)
129
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lil','Libelant');
129
VALUES ('RELTERMS', 'cnd', i18n('Conductor'));
130
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lit','Libelant-appellant');
130
INSERT
131
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lsa','Landscape architect');
131
INTO authorised_values (category, authorised_value, lib)
132
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lse','Licensee');
132
VALUES ('RELTERMS', 'cns', i18n('Censor'));
133
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lso','Licensor');
133
INSERT
134
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ltg','Lithographer');
134
INTO authorised_values (category, authorised_value, lib)
135
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','lyr','Lyricist');
135
VALUES ('RELTERMS', 'coe', i18n('Contestant -appellee'));
136
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mcp','Music copyist');
136
INSERT
137
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfp','Manufacture place');
137
INTO authorised_values (category, authorised_value, lib)
138
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mfr','Manufacturer');
138
VALUES ('RELTERMS', 'col', i18n('Collector'));
139
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mdc','Metadata contact');
139
INSERT
140
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mod','Moderator');
140
INTO authorised_values (category, authorised_value, lib)
141
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mon','Monitor');
141
VALUES ('RELTERMS', 'com', i18n('Compiler'));
142
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrb','Marbler');
142
INSERT
143
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mrk','Markup editor');
143
INTO authorised_values (category, authorised_value, lib)
144
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','msd','Musical director');
144
VALUES ('RELTERMS', 'con', i18n('Conservator'));
145
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mte','Metal-engraver');
145
INSERT
146
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','mus','Musician');
146
INTO authorised_values (category, authorised_value, lib)
147
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','nrt','Narrator');
147
VALUES ('RELTERMS', 'cos', i18n('Contestant'));
148
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','opn','Opponent');
148
INSERT
149
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','org','Originator');
149
INTO authorised_values (category, authorised_value, lib)
150
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','orm','Organizer of meeting');
150
VALUES ('RELTERMS', 'cot', i18n('Contestant -appellant'));
151
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','oth','Other');
151
INSERT
152
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','own','Owner');
152
INTO authorised_values (category, authorised_value, lib)
153
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pat','Patron');
153
VALUES ('RELTERMS', 'cov', i18n('Cover designer'));
154
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbd','Publishing director');
154
INSERT
155
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pbl','Publisher');
155
INTO authorised_values (category, authorised_value, lib)
156
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pdr','Project director');
156
VALUES ('RELTERMS', 'cpc', i18n('Copyright claimant'));
157
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pfr','Proofreader');
157
INSERT
158
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pht','Photographer');
158
INTO authorised_values (category, authorised_value, lib)
159
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','plt','Platemaker');
159
VALUES ('RELTERMS', 'cpe', i18n('Complainant-appellee'));
160
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pma','Permitting agency');
160
INSERT
161
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pmn','Production manager');
161
INTO authorised_values (category, authorised_value, lib)
162
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pop','Printer of plates');
162
VALUES ('RELTERMS', 'cph', i18n('Copyright holder'));
163
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppm','Papermaker');
163
INSERT
164
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ppt','Puppeteer');
164
INTO authorised_values (category, authorised_value, lib)
165
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prc','Process contact');
165
VALUES ('RELTERMS', 'cpl', i18n('Complainant'));
166
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prd','Production personnel');
166
INSERT
167
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prf','Performer');
167
INTO authorised_values (category, authorised_value, lib)
168
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prg','Programmer');
168
VALUES ('RELTERMS', 'cpt', i18n('Complainant-appellant'));
169
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prm','Printmaker');
169
INSERT
170
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pro','Producer');
170
INTO authorised_values (category, authorised_value, lib)
171
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prp','Production place');
171
VALUES ('RELTERMS', 'cre', i18n('Creator'));
172
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','prt','Printer');
172
INSERT
173
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pta','Patent applicant');
173
INTO authorised_values (category, authorised_value, lib)
174
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pte','Plaintiff -appellee');
174
VALUES ('RELTERMS', 'crp', i18n('Correspondent'));
175
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptf','Plaintiff');
175
INSERT
176
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pth','Patent holder');
176
INTO authorised_values (category, authorised_value, lib)
177
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ptt','Plaintiff-appellant');
177
VALUES ('RELTERMS', 'crr', i18n('Corrector'));
178
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','pup','Publication place');
178
INSERT
179
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rbr','Rubricator');
179
INTO authorised_values (category, authorised_value, lib)
180
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rce','Recording engineer');
180
VALUES ('RELTERMS', 'csl', i18n('Consultant'));
181
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rcp','Recipient');
181
INSERT
182
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','red','Redactor');
182
INTO authorised_values (category, authorised_value, lib)
183
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ren','Renderer');
183
VALUES ('RELTERMS', 'csp', i18n('Consultant to a project'));
184
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','res','Researcher');
184
INSERT
185
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rev','Reviewer');
185
INTO authorised_values (category, authorised_value, lib)
186
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rps','Repository');
186
VALUES ('RELTERMS', 'cst', i18n('Costume designer'));
187
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpt','Reporter');
187
INSERT
188
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rpy','Responsible party');
188
INTO authorised_values (category, authorised_value, lib)
189
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rse','Respondent-appellee');
189
VALUES ('RELTERMS', 'ctb', i18n('Contributor'));
190
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsg','Restager');
190
INSERT
191
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rsp','Respondent');
191
INTO authorised_values (category, authorised_value, lib)
192
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rst','Respondent-appellant');
192
VALUES ('RELTERMS', 'cte', i18n('Contestee-appellee'));
193
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rth','Research team head');
193
INSERT
194
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','rtm','Research team member');
194
INTO authorised_values (category, authorised_value, lib)
195
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sad','Scientific advisor');
195
VALUES ('RELTERMS', 'ctg', i18n('Cartographer'));
196
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sce','Scenarist');
196
INSERT
197
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scl','Sculptor');
197
INTO authorised_values (category, authorised_value, lib)
198
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','scr','Scribe');
198
VALUES ('RELTERMS', 'ctr', i18n('Contractor'));
199
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sds','Sound designer');
199
INSERT
200
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sec','Secretary');
200
INTO authorised_values (category, authorised_value, lib)
201
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sgn','Signer');
201
VALUES ('RELTERMS', 'cts', i18n('Contestee'));
202
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sht','Supporting host');
202
INSERT
203
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','sng','Singer');
203
INTO authorised_values (category, authorised_value, lib)
204
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spk','Speaker');
204
VALUES ('RELTERMS', 'ctt', i18n('Contestee-appellant'));
205
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spn','Sponsor');
205
INSERT
206
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','spy','Second party');
206
INTO authorised_values (category, authorised_value, lib)
207
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','srv','Surveyor');
207
VALUES ('RELTERMS', 'cur', i18n('Curator'));
208
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','std','Set designer');
208
INSERT
209
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stl','Storyteller');
209
INTO authorised_values (category, authorised_value, lib)
210
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stm','Stage manager');
210
VALUES ('RELTERMS', 'cwt', i18n('Commentator for written text'));
211
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','stn','Standards body');
211
INSERT
212
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','str','Stereotyper');
212
INTO authorised_values (category, authorised_value, lib)
213
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tcd','Technical director');
213
VALUES ('RELTERMS', 'dfd', i18n('Defendant'));
214
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tch','Teacher');
214
INSERT
215
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','ths','Thesis advisor');
215
INTO authorised_values (category, authorised_value, lib)
216
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trc','Transcriber');
216
VALUES ('RELTERMS', 'dfe', i18n('Defendant-appellee'));
217
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','trl','Translator');
217
INSERT
218
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyd','Type designer');
218
INTO authorised_values (category, authorised_value, lib)
219
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','tyg','Typographer');
219
VALUES ('RELTERMS', 'dft', i18n('Defendant-appellant'));
220
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','uvp','University place');
220
INSERT
221
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','vdg','Videographer');
221
INTO authorised_values (category, authorised_value, lib)
222
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','voc','Vocalist');
222
VALUES ('RELTERMS', 'dgg', i18n('Degree grantor'));
223
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wam','Writer of accompanying material');
223
INSERT
224
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wdc','Woodcutter');
224
INTO authorised_values (category, authorised_value, lib)
225
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wde','Wood-engraver');
225
VALUES ('RELTERMS', 'dis', i18n('Dissertant'));
226
INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RELTERMS','wit','Witness');
226
INSERT
227
INTO authorised_values (category, authorised_value, lib)
228
VALUES ('RELTERMS', 'dln', i18n('Delineator'));
229
INSERT
230
INTO authorised_values (category, authorised_value, lib)
231
VALUES ('RELTERMS', 'dnc', i18n('Dancer'));
232
INSERT
233
INTO authorised_values (category, authorised_value, lib)
234
VALUES ('RELTERMS', 'dnr', i18n('Donor'));
235
INSERT
236
INTO authorised_values (category, authorised_value, lib)
237
VALUES ('RELTERMS', 'dpb', i18n('Distribution place'));
238
INSERT
239
INTO authorised_values (category, authorised_value, lib)
240
VALUES ('RELTERMS', 'dpc', i18n('Depicted'));
241
INSERT
242
INTO authorised_values (category, authorised_value, lib)
243
VALUES ('RELTERMS', 'dpt', i18n('Depositor'));
244
INSERT
245
INTO authorised_values (category, authorised_value, lib)
246
VALUES ('RELTERMS', 'drm', i18n('Draftsman'));
247
INSERT
248
INTO authorised_values (category, authorised_value, lib)
249
VALUES ('RELTERMS', 'drt', i18n('Director'));
250
INSERT
251
INTO authorised_values (category, authorised_value, lib)
252
VALUES ('RELTERMS', 'dsr', i18n('Designer'));
253
INSERT
254
INTO authorised_values (category, authorised_value, lib)
255
VALUES ('RELTERMS', 'dst', i18n('Distributor'));
256
INSERT
257
INTO authorised_values (category, authorised_value, lib)
258
VALUES ('RELTERMS', 'dtc', i18n('Data contributor'));
259
INSERT
260
INTO authorised_values (category, authorised_value, lib)
261
VALUES ('RELTERMS', 'dte', i18n('Dedicatee'));
262
INSERT
263
INTO authorised_values (category, authorised_value, lib)
264
VALUES ('RELTERMS', 'dtm', i18n('Data manager'));
265
INSERT
266
INTO authorised_values (category, authorised_value, lib)
267
VALUES ('RELTERMS', 'dto', i18n('Dedicator'));
268
INSERT
269
INTO authorised_values (category, authorised_value, lib)
270
VALUES ('RELTERMS', 'dub', i18n('Dubious author'));
271
INSERT
272
INTO authorised_values (category, authorised_value, lib)
273
VALUES ('RELTERMS', 'edt', i18n('Editor'));
274
INSERT
275
INTO authorised_values (category, authorised_value, lib)
276
VALUES ('RELTERMS', 'egr', i18n('Engraver'));
277
INSERT
278
INTO authorised_values (category, authorised_value, lib)
279
VALUES ('RELTERMS', 'elg', i18n('Electrician'));
280
INSERT
281
INTO authorised_values (category, authorised_value, lib)
282
VALUES ('RELTERMS', 'elt', i18n('Electrotyper'));
283
INSERT
284
INTO authorised_values (category, authorised_value, lib)
285
VALUES ('RELTERMS', 'eng', i18n('Engineer'));
286
INSERT
287
INTO authorised_values (category, authorised_value, lib)
288
VALUES ('RELTERMS', 'etr', i18n('Etcher'));
289
INSERT
290
INTO authorised_values (category, authorised_value, lib)
291
VALUES ('RELTERMS', 'evp', i18n('Event place'));
292
INSERT
293
INTO authorised_values (category, authorised_value, lib)
294
VALUES ('RELTERMS', 'exp', i18n('Expert'));
295
INSERT
296
INTO authorised_values (category, authorised_value, lib)
297
VALUES ('RELTERMS', 'fac', i18n('Facsimilist'));
298
INSERT
299
INTO authorised_values (category, authorised_value, lib)
300
VALUES ('RELTERMS', 'fld', i18n('Field director'));
301
INSERT
302
INTO authorised_values (category, authorised_value, lib)
303
VALUES ('RELTERMS', 'flm', i18n('Film editor'));
304
INSERT
305
INTO authorised_values (category, authorised_value, lib)
306
VALUES ('RELTERMS', 'fmo', i18n('Former owner'));
307
INSERT
308
INTO authorised_values (category, authorised_value, lib)
309
VALUES ('RELTERMS', 'fpy', i18n('First party'));
310
INSERT
311
INTO authorised_values (category, authorised_value, lib)
312
VALUES ('RELTERMS', 'fnd', i18n('Funder'));
313
INSERT
314
INTO authorised_values (category, authorised_value, lib)
315
VALUES ('RELTERMS', 'frg', i18n('Forger'));
316
INSERT
317
INTO authorised_values (category, authorised_value, lib)
318
VALUES ('RELTERMS', 'gis', i18n('Geographic information specialist'));
319
INSERT
320
INTO authorised_values (category, authorised_value, lib)
321
VALUES ('RELTERMS', '-grt', i18n('Graphic technician'));
322
INSERT
323
INTO authorised_values (category, authorised_value, lib)
324
VALUES ('RELTERMS', 'hnr', i18n('Honoree'));
325
INSERT
326
INTO authorised_values (category, authorised_value, lib)
327
VALUES ('RELTERMS', 'hst', i18n('Host'));
328
INSERT
329
INTO authorised_values (category, authorised_value, lib)
330
VALUES ('RELTERMS', 'ill', i18n('Illustrator'));
331
INSERT
332
INTO authorised_values (category, authorised_value, lib)
333
VALUES ('RELTERMS', 'ilu', i18n('Illuminator'));
334
INSERT
335
INTO authorised_values (category, authorised_value, lib)
336
VALUES ('RELTERMS', 'ins', i18n('Inscriber'));
337
INSERT
338
INTO authorised_values (category, authorised_value, lib)
339
VALUES ('RELTERMS', 'inv', i18n('Inventor'));
340
INSERT
341
INTO authorised_values (category, authorised_value, lib)
342
VALUES ('RELTERMS', 'itr', i18n('Instrumentalist'));
343
INSERT
344
INTO authorised_values (category, authorised_value, lib)
345
VALUES ('RELTERMS', 'ive', i18n('Interviewee'));
346
INSERT
347
INTO authorised_values (category, authorised_value, lib)
348
VALUES ('RELTERMS', 'ivr', i18n('Interviewer'));
349
INSERT
350
INTO authorised_values (category, authorised_value, lib)
351
VALUES ('RELTERMS', 'lbr', i18n('Laboratory'));
352
INSERT
353
INTO authorised_values (category, authorised_value, lib)
354
VALUES ('RELTERMS', 'lbt', i18n('Librettist'));
355
INSERT
356
INTO authorised_values (category, authorised_value, lib)
357
VALUES ('RELTERMS', 'ldr', i18n('Laboratory director'));
358
INSERT
359
INTO authorised_values (category, authorised_value, lib)
360
VALUES ('RELTERMS', 'led', i18n('Lead'));
361
INSERT
362
INTO authorised_values (category, authorised_value, lib)
363
VALUES ('RELTERMS', 'lee', i18n('Libelee-appellee'));
364
INSERT
365
INTO authorised_values (category, authorised_value, lib)
366
VALUES ('RELTERMS', 'lel', i18n('Libelee'));
367
INSERT
368
INTO authorised_values (category, authorised_value, lib)
369
VALUES ('RELTERMS', 'len', i18n('Lender'));
370
INSERT
371
INTO authorised_values (category, authorised_value, lib)
372
VALUES ('RELTERMS', 'let', i18n('Libelee-appellant'));
373
INSERT
374
INTO authorised_values (category, authorised_value, lib)
375
VALUES ('RELTERMS', 'lgd', i18n('Lighting designer'));
376
INSERT
377
INTO authorised_values (category, authorised_value, lib)
378
VALUES ('RELTERMS', 'lie', i18n('Libelant-appellee'));
379
INSERT
380
INTO authorised_values (category, authorised_value, lib)
381
VALUES ('RELTERMS', 'lil', i18n('Libelant'));
382
INSERT
383
INTO authorised_values (category, authorised_value, lib)
384
VALUES ('RELTERMS', 'lit', i18n('Libelant-appellant'));
385
INSERT
386
INTO authorised_values (category, authorised_value, lib)
387
VALUES ('RELTERMS', 'lsa', i18n('Landscape architect'));
388
INSERT
389
INTO authorised_values (category, authorised_value, lib)
390
VALUES ('RELTERMS', 'lse', i18n('Licensee'));
391
INSERT
392
INTO authorised_values (category, authorised_value, lib)
393
VALUES ('RELTERMS', 'lso', i18n('Licensor'));
394
INSERT
395
INTO authorised_values (category, authorised_value, lib)
396
VALUES ('RELTERMS', 'ltg', i18n('Lithographer'));
397
INSERT
398
INTO authorised_values (category, authorised_value, lib)
399
VALUES ('RELTERMS', 'lyr', i18n('Lyricist'));
400
INSERT
401
INTO authorised_values (category, authorised_value, lib)
402
VALUES ('RELTERMS', 'mcp', i18n('Music copyist'));
403
INSERT
404
INTO authorised_values (category, authorised_value, lib)
405
VALUES ('RELTERMS', 'mfp', i18n('Manufacture place'));
406
INSERT
407
INTO authorised_values (category, authorised_value, lib)
408
VALUES ('RELTERMS', 'mfr', i18n('Manufacturer'));
409
INSERT
410
INTO authorised_values (category, authorised_value, lib)
411
VALUES ('RELTERMS', 'mdc', i18n('Metadata contact'));
412
INSERT
413
INTO authorised_values (category, authorised_value, lib)
414
VALUES ('RELTERMS', 'mod', i18n('Moderator'));
415
INSERT
416
INTO authorised_values (category, authorised_value, lib)
417
VALUES ('RELTERMS', 'mon', i18n('Monitor'));
418
INSERT
419
INTO authorised_values (category, authorised_value, lib)
420
VALUES ('RELTERMS', 'mrb', i18n('Marbler'));
421
INSERT
422
INTO authorised_values (category, authorised_value, lib)
423
VALUES ('RELTERMS', 'mrk', i18n('Markup editor'));
424
INSERT
425
INTO authorised_values (category, authorised_value, lib)
426
VALUES ('RELTERMS', 'msd', i18n('Musical director'));
427
INSERT
428
INTO authorised_values (category, authorised_value, lib)
429
VALUES ('RELTERMS', 'mte', i18n('Metal-engraver'));
430
INSERT
431
INTO authorised_values (category, authorised_value, lib)
432
VALUES ('RELTERMS', 'mus', i18n('Musician'));
433
INSERT
434
INTO authorised_values (category, authorised_value, lib)
435
VALUES ('RELTERMS', 'nrt', i18n('Narrator'));
436
INSERT
437
INTO authorised_values (category, authorised_value, lib)
438
VALUES ('RELTERMS', 'opn', i18n('Opponent'));
439
INSERT
440
INTO authorised_values (category, authorised_value, lib)
441
VALUES ('RELTERMS', 'org', i18n('Originator'));
442
INSERT
443
INTO authorised_values (category, authorised_value, lib)
444
VALUES ('RELTERMS', 'orm', i18n('Organizer of meeting'));
445
INSERT
446
INTO authorised_values (category, authorised_value, lib)
447
VALUES ('RELTERMS', 'oth', i18n('Other'));
448
INSERT
449
INTO authorised_values (category, authorised_value, lib)
450
VALUES ('RELTERMS', 'own', i18n('Owner'));
451
INSERT
452
INTO authorised_values (category, authorised_value, lib)
453
VALUES ('RELTERMS', 'pat', i18n('Patron'));
454
INSERT
455
INTO authorised_values (category, authorised_value, lib)
456
VALUES ('RELTERMS', 'pbd', i18n('Publishing director'));
457
INSERT
458
INTO authorised_values (category, authorised_value, lib)
459
VALUES ('RELTERMS', 'pbl', i18n('Publisher'));
460
INSERT
461
INTO authorised_values (category, authorised_value, lib)
462
VALUES ('RELTERMS', 'pdr', i18n('Project director'));
463
INSERT
464
INTO authorised_values (category, authorised_value, lib)
465
VALUES ('RELTERMS', 'pfr', i18n('Proofreader'));
466
INSERT
467
INTO authorised_values (category, authorised_value, lib)
468
VALUES ('RELTERMS', 'pht', i18n('Photographer'));
469
INSERT
470
INTO authorised_values (category, authorised_value, lib)
471
VALUES ('RELTERMS', 'plt', i18n('Platemaker'));
472
INSERT
473
INTO authorised_values (category, authorised_value, lib)
474
VALUES ('RELTERMS', 'pma', i18n('Permitting agency'));
475
INSERT
476
INTO authorised_values (category, authorised_value, lib)
477
VALUES ('RELTERMS', 'pmn', i18n('Production manager'));
478
INSERT
479
INTO authorised_values (category, authorised_value, lib)
480
VALUES ('RELTERMS', 'pop', i18n('Printer of plates'));
481
INSERT
482
INTO authorised_values (category, authorised_value, lib)
483
VALUES ('RELTERMS', 'ppm', i18n('Papermaker'));
484
INSERT
485
INTO authorised_values (category, authorised_value, lib)
486
VALUES ('RELTERMS', 'ppt', i18n('Puppeteer'));
487
INSERT
488
INTO authorised_values (category, authorised_value, lib)
489
VALUES ('RELTERMS', 'prc', i18n('Process contact'));
490
INSERT
491
INTO authorised_values (category, authorised_value, lib)
492
VALUES ('RELTERMS', 'prd', i18n('Production personnel'));
493
INSERT
494
INTO authorised_values (category, authorised_value, lib)
495
VALUES ('RELTERMS', 'prf', i18n('Performer'));
496
INSERT
497
INTO authorised_values (category, authorised_value, lib)
498
VALUES ('RELTERMS', 'prg', i18n('Programmer'));
499
INSERT
500
INTO authorised_values (category, authorised_value, lib)
501
VALUES ('RELTERMS', 'prm', i18n('Printmaker'));
502
INSERT
503
INTO authorised_values (category, authorised_value, lib)
504
VALUES ('RELTERMS', 'pro', i18n('Producer'));
505
INSERT
506
INTO authorised_values (category, authorised_value, lib)
507
VALUES ('RELTERMS', 'prp', i18n('Production place'));
508
INSERT
509
INTO authorised_values (category, authorised_value, lib)
510
VALUES ('RELTERMS', 'prt', i18n('Printer'));
511
INSERT
512
INTO authorised_values (category, authorised_value, lib)
513
VALUES ('RELTERMS', 'pta', i18n('Patent applicant'));
514
INSERT
515
INTO authorised_values (category, authorised_value, lib)
516
VALUES ('RELTERMS', 'pte', i18n('Plaintiff -appellee'));
517
INSERT
518
INTO authorised_values (category, authorised_value, lib)
519
VALUES ('RELTERMS', 'ptf', i18n('Plaintiff'));
520
INSERT
521
INTO authorised_values (category, authorised_value, lib)
522
VALUES ('RELTERMS', 'pth', i18n('Patent holder'));
523
INSERT
524
INTO authorised_values (category, authorised_value, lib)
525
VALUES ('RELTERMS', 'ptt', i18n('Plaintiff-appellant'));
526
INSERT
527
INTO authorised_values (category, authorised_value, lib)
528
VALUES ('RELTERMS', 'pup', i18n('Publication place'));
529
INSERT
530
INTO authorised_values (category, authorised_value, lib)
531
VALUES ('RELTERMS', 'rbr', i18n('Rubricator'));
532
INSERT
533
INTO authorised_values (category, authorised_value, lib)
534
VALUES ('RELTERMS', 'rce', i18n('Recording engineer'));
535
INSERT
536
INTO authorised_values (category, authorised_value, lib)
537
VALUES ('RELTERMS', 'rcp', i18n('Recipient'));
538
INSERT
539
INTO authorised_values (category, authorised_value, lib)
540
VALUES ('RELTERMS', 'red', i18n('Redactor'));
541
INSERT
542
INTO authorised_values (category, authorised_value, lib)
543
VALUES ('RELTERMS', 'ren', i18n('Renderer'));
544
INSERT
545
INTO authorised_values (category, authorised_value, lib)
546
VALUES ('RELTERMS', 'res', i18n('Researcher'));
547
INSERT
548
INTO authorised_values (category, authorised_value, lib)
549
VALUES ('RELTERMS', 'rev', i18n('Reviewer'));
550
INSERT
551
INTO authorised_values (category, authorised_value, lib)
552
VALUES ('RELTERMS', 'rps', i18n('Repository'));
553
INSERT
554
INTO authorised_values (category, authorised_value, lib)
555
VALUES ('RELTERMS', 'rpt', i18n('Reporter'));
556
INSERT
557
INTO authorised_values (category, authorised_value, lib)
558
VALUES ('RELTERMS', 'rpy', i18n('Responsible party'));
559
INSERT
560
INTO authorised_values (category, authorised_value, lib)
561
VALUES ('RELTERMS', 'rse', i18n('Respondent-appellee'));
562
INSERT
563
INTO authorised_values (category, authorised_value, lib)
564
VALUES ('RELTERMS', 'rsg', i18n('Restager'));
565
INSERT
566
INTO authorised_values (category, authorised_value, lib)
567
VALUES ('RELTERMS', 'rsp', i18n('Respondent'));
568
INSERT
569
INTO authorised_values (category, authorised_value, lib)
570
VALUES ('RELTERMS', 'rst', i18n('Respondent-appellant'));
571
INSERT
572
INTO authorised_values (category, authorised_value, lib)
573
VALUES ('RELTERMS', 'rth', i18n('Research team head'));
574
INSERT
575
INTO authorised_values (category, authorised_value, lib)
576
VALUES ('RELTERMS', 'rtm', i18n('Research team member'));
577
INSERT
578
INTO authorised_values (category, authorised_value, lib)
579
VALUES ('RELTERMS', 'sad', i18n('Scientific advisor'));
580
INSERT
581
INTO authorised_values (category, authorised_value, lib)
582
VALUES ('RELTERMS', 'sce', i18n('Scenarist'));
583
INSERT
584
INTO authorised_values (category, authorised_value, lib)
585
VALUES ('RELTERMS', 'scl', i18n('Sculptor'));
586
INSERT
587
INTO authorised_values (category, authorised_value, lib)
588
VALUES ('RELTERMS', 'scr', i18n('Scribe'));
589
INSERT
590
INTO authorised_values (category, authorised_value, lib)
591
VALUES ('RELTERMS', 'sds', i18n('Sound designer'));
592
INSERT
593
INTO authorised_values (category, authorised_value, lib)
594
VALUES ('RELTERMS', 'sec', i18n('Secretary'));
595
INSERT
596
INTO authorised_values (category, authorised_value, lib)
597
VALUES ('RELTERMS', 'sgn', i18n('Signer'));
598
INSERT
599
INTO authorised_values (category, authorised_value, lib)
600
VALUES ('RELTERMS', 'sht', i18n('Supporting host'));
601
INSERT
602
INTO authorised_values (category, authorised_value, lib)
603
VALUES ('RELTERMS', 'sng', i18n('Singer'));
604
INSERT
605
INTO authorised_values (category, authorised_value, lib)
606
VALUES ('RELTERMS', 'spk', i18n('Speaker'));
607
INSERT
608
INTO authorised_values (category, authorised_value, lib)
609
VALUES ('RELTERMS', 'spn', i18n('Sponsor'));
610
INSERT
611
INTO authorised_values (category, authorised_value, lib)
612
VALUES ('RELTERMS', 'spy', i18n('Second party'));
613
INSERT
614
INTO authorised_values (category, authorised_value, lib)
615
VALUES ('RELTERMS', 'srv', i18n('Surveyor'));
616
INSERT
617
INTO authorised_values (category, authorised_value, lib)
618
VALUES ('RELTERMS', 'std', i18n('Set designer'));
619
INSERT
620
INTO authorised_values (category, authorised_value, lib)
621
VALUES ('RELTERMS', 'stl', i18n('Storyteller'));
622
INSERT
623
INTO authorised_values (category, authorised_value, lib)
624
VALUES ('RELTERMS', 'stm', i18n('Stage manager'));
625
INSERT
626
INTO authorised_values (category, authorised_value, lib)
627
VALUES ('RELTERMS', 'stn', i18n('Standards body'));
628
INSERT
629
INTO authorised_values (category, authorised_value, lib)
630
VALUES ('RELTERMS', 'str', i18n('Stereotyper'));
631
INSERT
632
INTO authorised_values (category, authorised_value, lib)
633
VALUES ('RELTERMS', 'tcd', i18n('Technical director'));
634
INSERT
635
INTO authorised_values (category, authorised_value, lib)
636
VALUES ('RELTERMS', 'tch', i18n('Teacher'));
637
INSERT
638
INTO authorised_values (category, authorised_value, lib)
639
VALUES ('RELTERMS', 'ths', i18n('Thesis advisor'));
640
INSERT
641
INTO authorised_values (category, authorised_value, lib)
642
VALUES ('RELTERMS', 'trc', i18n('Transcriber'));
643
INSERT
644
INTO authorised_values (category, authorised_value, lib)
645
VALUES ('RELTERMS', 'trl', i18n('Translator'));
646
INSERT
647
INTO authorised_values (category, authorised_value, lib)
648
VALUES ('RELTERMS', 'tyd', i18n('Type designer'));
649
INSERT
650
INTO authorised_values (category, authorised_value, lib)
651
VALUES ('RELTERMS', 'tyg', i18n('Typographer'));
652
INSERT
653
INTO authorised_values (category, authorised_value, lib)
654
VALUES ('RELTERMS', 'uvp', i18n('University place'));
655
INSERT
656
INTO authorised_values (category, authorised_value, lib)
657
VALUES ('RELTERMS', 'vdg', i18n('Videographer'));
658
INSERT
659
INTO authorised_values (category, authorised_value, lib)
660
VALUES ('RELTERMS', 'voc', i18n('Vocalist'));
661
INSERT
662
INTO authorised_values (category, authorised_value, lib)
663
VALUES ('RELTERMS', 'wam', i18n('Writer of accompanying material'));
664
INSERT
665
INTO authorised_values (category, authorised_value, lib)
666
VALUES ('RELTERMS', 'wdc', i18n('Woodcutter'));
667
INSERT
668
INTO authorised_values (category, authorised_value, lib)
669
VALUES ('RELTERMS', 'wde', i18n('Wood-engraver'));
670
INSERT
671
INTO authorised_values (category, authorised_value, lib)
672
VALUES ('RELTERMS', 'wit', i18n('Witness'));
(-)a/installer/data/mysql/en/optional/parameters.sql (-5 / +7 lines)
Lines 1-6 Link Here
1
INSERT INTO `currency` (currency, rate, symbol) VALUES
1
INSERT
2
('USD', 1.0, '$'),
2
INTO currency (currency, rate, symbol)
3
('GBP', 1.9929, '£'),
3
VALUES
4
('CAD', 1.02207, '$'),
4
    ('USD', 1.0, '$'),
5
('EUR', .874003, '€');
5
    ('GBP', 1.9929, '£'),
6
    ('CAD', 1.02207, '$'),
7
    ('EUR', .874003, '€');
6
8
(-)a/installer/data/mysql/en/optional/patron_atributes.sql (-2 / +3 lines)
Lines 1-2 Link Here
1
INSERT INTO `borrower_attribute_types` (`code`, `description`, `repeatable`, `unique_id`, `opac_display`, `password_allowed`, `staff_searchable`, `authorised_value_category`)
1
INSERT
2
VALUES ('SHOW_BCODE',  'Show barcode on the summary screen items listings', 0, 0, 1, 0, 0, 'YES_NO');
2
INTO borrower_attribute_types (code, description, repeatable, unique_id, opac_display, password_allowed, staff_searchable, authorised_value_category)
3
VALUES ('SHOW_BCODE', i18n('Show barcode on the summary screen items listings'), 0, 0, 1, 0, 0, 'YES_NO');
(-)a/installer/data/mysql/en/optional/patron_categories.sql (-23 / +15 lines)
Lines 1-23 Link Here
1
INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES 
1
INSERT
2
2
INTO categories (categorycode, description, enrolmentperiod, upperagelimit, dateofbirthrequired, finetype, bulk, enrolmentfee, overduenoticerequired, issuelimit, reservefee, category_type)
3
-- Adult Patrons
3
VALUES
4
('PT','Patron',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
4
    ('PT', i18n('Patron'), 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'A'),
5
('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
5
    ('ST', i18n('Student'), 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'A'),
6
('HB','Home Bound',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
6
    ('HB', i18n('Home Bound'), 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'A'),
7
7
    ('K', i18n('Kid'), 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C'),
8
-- Children
8
    ('J', i18n('Juvenile'), 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C'),
9
('K','Kid',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
9
    ('YA', i18n('Young Adult'), 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'C'),
10
('J','Juvenile',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
10
    ('T', i18n('Teacher'), 99, 999, 18, NULL, NULL, '0.000000', 0, NULL, '0.000000', 'P'),
11
('YA','Young Adult',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
11
    ('B', i18n('Board'), 99, 17, 5, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'P'),
12
12
    ('IL', i18n('Inter-Library Loan'), 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'I'),
13
-- Professionals
13
    ('SC', i18n('School'), 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'I'),
14
('T','Teacher',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
14
    ('L', i18n('Library'), 99, 999, 18, NULL, NULL, '0.000000', 1, NULL, '0.000000', 'I'),
15
('B','Board',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
15
    ('S', i18n('Staff'), 99, 999, 18, NULL, NULL, '0.000000', 0, NULL, '0.000000', 'S');
16
17
-- Institutional
18
('IL','Inter-Library Loan',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
19
('SC','School',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
20
('L','Library',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
21
22
-- Staff
23
('S','Staff',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');
(-)a/installer/data/mysql/en/optional/sample_creator_data.sql (-22 / +22 lines)
Lines 1-9 Link Here
1
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
1
INSERT
2
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2
INTO creator_layouts (layout_id, barcode_type, start_label, printing_type, layout_name, guidebox, font, font_size, units, callnum_split, text_justify, format_string, layout_xml, creator)
3
3
VALUES
4
LOCK TABLES `creator_layouts` WRITE;
4
    (17, 'CODE39', 1, 'BIBBAR', 'Label Test', 0, 'TR', 3, 'POINT', 0, 'L', 'title, author, isbn, issn, itemtype, barcode, itemcallnumber', i18n('<opt></opt>'), 'Labels'),
5
/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
5
    (18, 'CODE39', 1, 'BAR', 'DEFAULT', 0, 'TR', 3, 'POINT', 0, 'L', 'title, author, isbn, issn, itemtype, barcode, itemcallnumber', i18n('<opt></opt>'), 'Labels'),
6
INSERT INTO `creator_layouts` VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(18,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(19,'CODE39',1,'BAR','DEFAULT',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),(20,'CODE39',1,'BAR','Test Layout',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT">
6
    (19, 'CODE39', 1, 'BAR', 'DEFAULT', 0, 'TR', 3, 'POINT', 0, 'L', 'title, author, isbn, issn, itemtype, barcode, itemcallnumber', i18n('<opt></opt>'), 'Labels'),
7
    (20, 'CODE39', 1, 'BAR', 'Test Layout', 0, 'TR', 10, 'POINT', 0, 'L', 'barcode', i18n('<opt page_side="F" units="POINT">
7
  <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
8
  <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
8
    <data_source image_name="none" image_source="patronimages" />
9
    <data_source image_name="none" image_source="patronimages" />
9
  </images>
10
  </images>
Lines 14-34 INSERT INTO `creator_layouts` VALUES (17,'CODE39',1,'BIBBAR','Label Test',0,'TR' Link Here
14
  <text>Expires: August 31, 2010</text>
15
  <text>Expires: August 31, 2010</text>
15
  <text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" />
16
  <text font="TR" font_size="6" llx="115" lly="65" text_alignment="L" />
16
</opt>
17
</opt>
17
','Patroncards');
18
'), 'Patroncards');
18
/*!40000 ALTER TABLE `creator_layouts` ENABLE KEYS */;
19
UNLOCK TABLES;
20
21
19
22
LOCK TABLES `creator_templates` WRITE;
20
INSERT
23
/*!40000 ALTER TABLE `creator_templates` DISABLE KEYS */;
21
INTO creator_templates (template_id, profile_id, template_code, template_desc, page_width, page_height, label_width, label_height, top_text_margin, left_text_margin, top_margin, left_margin, cols, rows, col_gap, row_gap, units, creator)
24
INSERT INTO `creator_templates` VALUES (1,1,'Avery 5160 | 1 x 2-5/8','3 columns, 10 rows of labels',8.5,11,2.63,1,0.139,0,0.35,0.23,3,10,0.13,0,'INCH','Labels'),(7,13,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for up to four lines of text',8.5,11,1.5,1,0.236,0,0.5,0.25,5,10,0.0625,0,'INCH','Labels'),(12,14,'Demco WS14942260','1\" X 1.5\" Spine Label | Setup for five lines of text',8.5,11,1.5,1,0.139,0,0.53,0.3,5,10,0.0625,0,'INCH','Labels'),(22,0,'DEFAULT TEMPLATE 01','Default description',0,5,0,0,0,0,0,0,0,0,0,0,'POINT','Labels'),(23,16,'HB-PC0001','A template for home brewed patron card forms',8.5,11,3.1875,1.9375,0,0,0.6875,0.875,2,4,0.4375,0.1875,'INCH','Patroncards');
22
VALUES
25
/*!40000 ALTER TABLE `creator_templates` ENABLE KEYS */;
23
    (1, 1, 'Avery 5160 | 1 x 2-5/8', i18n('3 columns, 10 rows of labels'), 8.5, 11, 2.63, 1, 0.139, 0, 0.35, 0.23, 3, 10, 0.13, 0, 'INCH', 'Labels'),
26
UNLOCK TABLES;
24
    (7, 13, 'Demco WS14942260', i18n('1\" X 1.5\" Spine Label | Setup for up to four lines of text'), 8.5, 11, 1.5, 1, 0.236, 0, 0.5, 0.25, 5, 10, 0.0625, 0, 'INCH', 'Labels'),
25
    (12, 14, 'Demco WS14942260', i18n('1\" X 1.5\" Spine Label | Setup for five lines of text'), 8.5, 11, 1.5, 1, 0.139, 0, 0.53, 0.3, 5, 10, 0.0625, 0, 'INCH', 'Labels'),
26
    (22, 0, 'DEFAULT TEMPLATE 01', i18n('Default description'), 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'POINT', 'Labels'),
27
    (23, 16, 'HB-PC0001', i18n('A template for home brewed patron card forms'), 8.5, 11, 3.1875, 1.9375, 0, 0, 0.6875, 0.875, 2, 4, 0.4375, 0.1875, 'INCH', 'Patroncards');
27
28
28
LOCK TABLES `printers_profile` WRITE;
29
INSERT
29
/*!40000 ALTER TABLE `printers_profile` DISABLE KEYS */;
30
INTO printers_profile (profile_id, printer_name, template_id, paper_bin, offset_horz, offset_vert, creep_horz, creep_vert, units, creator)
30
INSERT INTO `printers_profile` VALUES (1,'Library Laser',1,'Bypass',-2,9,3,0,'POINT','Labels'),(11,'Library Laser',1,'Tray 1',0,0,0,0,'POINT','Labels'),(16,'Test Printer 01',23,'Test Bin',0,0,0,0,'POINT','Patroncards');
31
VALUES
31
/*!40000 ALTER TABLE `printers_profile` ENABLE KEYS */;
32
    (1, i18n('Library Laser'), 1, 'Bypass', -2, 9, 3, 0, 'POINT', 'Labels'),
32
UNLOCK TABLES;
33
    (11, i18n('Library Laser'), 1, 'Tray 1', 0, 0, 0, 0, 'POINT', 'Labels'),
33
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
34
    (16, i18n('Test Printer 01'), 23, 'Test Bin', 0, 0, 0, 0, 'POINT', 'Patroncards');
34
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
(-)a/installer/data/mysql/en/optional/sample_holidays.sql (-4 / +6 lines)
Lines 1-4 Link Here
1
INSERT INTO `repeatable_holidays` VALUES 
1
INSERT
2
(2,'MPL',0,NULL,NULL,'','Sundays'),
2
INTO repeatable_holidays (id, branchcode, weekday, day, month, title, description)
3
(3,'MPL',NULL,1,1,'','New Year\'s Day'),
3
VALUES
4
(4,'MPL',NULL,25,12,'','Christmas');
4
    (2, 'MPL', 0, NULL, NULL, '', i18n('Sundays')),
5
    (3, 'MPL', NULL, 1, 1, '', i18n('New Year\'s Day')),
6
    (4, 'MPL', NULL, 25, 12, '', i18n('Christmas'));
(-)a/installer/data/mysql/en/optional/sample_itemtypes.sql (-8 / +11 lines)
Lines 1-8 Link Here
1
INSERT INTO `itemtypes` VALUES ('BK', 'Books',5,0,'bridge/book.gif','');
1
INSERT
2
INSERT INTO `itemtypes` VALUES ('MX', 'Mixed Materials',5,0,'bridge/kit.gif','');
2
INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary)
3
INSERT INTO `itemtypes` VALUES ('CF', 'Computer Files',5,0,'bridge/computer_file.gif','');
3
VALUES
4
INSERT INTO `itemtypes` VALUES ('MP', 'Maps',5,0,'bridge/map.gif','');
4
    ('BK', i18n('Books'), 5, 0, 'bridge/book.gif', ''),
5
INSERT INTO `itemtypes` VALUES ('VM', 'Visual Materials',5,1,'bridge/dvd.gif','');
5
    ('MX', i18n('Mixed Materials'), 5, 0, 'bridge/kit.gif', ''),
6
INSERT INTO `itemtypes` VALUES ('MU', 'Music',5,0,'bridge/sound.gif','');
6
    ('CF', i18n('Computer Files'), 5, 0, 'bridge/computer_file.gif', ''),
7
INSERT INTO `itemtypes` VALUES ('CR', 'Continuing Resources',5,0,'bridge/periodical.gif','');
7
    ('MP', i18n('Maps'), 5, 0, 'bridge/map.gif', ''),
8
INSERT INTO `itemtypes` VALUES ('REF', 'Reference',0,1,'','');
8
    ('VM', i18n('Visual Materials'), 5, 1, 'bridge/dvd.gif', ''),
9
    ('MU', i18n('Music'), 5, 0, 'bridge/sound.gif', ''),
10
    ('CR', i18n('Continuing Resources'), 5, 0, 'bridge/periodical.gif', ''),
11
    ('REF', i18n('Reference'), 0, 1, '', '');
(-)a/installer/data/mysql/en/optional/sample_libraries.sql (-19 / +15 lines)
Lines 1-19 Link Here
1
-- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES
1
INSERT
2
2
INTO branches (branchcode, branchname, branchaddress1)
3
INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
3
VALUES
4
4
    ('MPL', 'Midway', '372 Forest Street'),
5
('MPL','Midway','372 Forest Street'),
5
    ('SPL', 'Springfield', 'Highland Boulevard'),
6
('SPL','Springfield','Highland Boulevard'),
6
    ('RPL', 'Riverside', 'Johnson Terrace'),
7
('RPL','Riverside','Johnson Terrace'),
7
    ('CPL', 'Centerville', 'Jefferson Summit'),
8
('CPL','Centerville','Jefferson Summit'),
8
    ('FPL', 'Fairview', 'Hickory Squere'),
9
('FPL','Fairview','Hickory Squere'),
9
    ('FFL', 'Fairfield', 'River Station'),
10
('FFL','Fairfield','River Station'),
10
    ('IPT', 'Institut Protestant de Théologie', ''),
11
('IPT','Institut Protestant de Théologie',''),
11
    ('PVL', 'Pleasant Valley', 'Meadow Grove'),
12
('PVL','Pleasant Valley','Meadow Grove'),
12
    ('TPL', 'Troy', 'Valley Way'),
13
('TPL','Troy','Valley Way'),
13
    ('FRL', 'Franklin', 'Smith Heights'),
14
('FRL','Franklin','Smith Heights'),
14
    ('LPL', 'Liberty', 'East Hills'),
15
('LPL','Liberty','East Hills'),
15
    ('UPL', 'Union', 'Chestnut Hollow');
16
('UPL','Union','Chestnut Hollow')
17
;
18
19
-- INSERT INTO branchrelations ( `branchcode`,`categorycode`) VALUES
(-)a/installer/data/mysql/en/optional/sample_news.sql (-2 / +5 lines)
Lines 1-2 Link Here
1
INSERT INTO `opac_news` VALUES (1,'Welcome to Koha','Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe.','koha','2007-10-29 05:25:58','2099-01-10',1),
1
INSERT
2
(2,'What\'s Next?','Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Read Koha Documentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Read/Write to the Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Read and Contribute to Discussions</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Report Koha Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Submit Patches to Koha using Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chat with Koha users and developers</a></li>\r\n</ul>\r\n','koha','2007-10-29 05:34:45','2099-01-10',2);
2
INTO opac_news (idnew, title, new, lang, timestamp, expirationdate, number)
3
VALUES
4
    (1, i18n('Welcome to Koha'), i18n('Welcome to Koha. Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust, Koha is currently maintained by a team of software providers and library technology staff from around the globe.'), i18n('koha'), '2007-10-29 05:25:58', '2099-01-10', 1),
5
    (2, i18n('What\'s Next?'), i18n('Now that you\'ve installed Koha, what\'s next? Here are some suggestions:\r\n<ul>\r\n<li><a href=\"http://koha-community.org/documentation/\">Read Koha Documentation</a></li>\r\n<li><a href=\"http://wiki.koha-community.org\">Read/Write to the Koha Wiki</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Read and Contribute to Discussions</a></li>\r\n<li><a href=\"http://bugs.koha-community.org\">Report Koha Bugs</a></li>\r\n<li><a href=\"http://wiki.koha-community.org/wiki/Version_Control_Using_Git\">Submit Patches to Koha using Git (Version Control System)</a></li>\r\n<li><a href=\"http://koha-community.org/support/\">Chat with Koha users and developers</a></li>\r\n</ul>\r\n'), i18n('koha'), '2007-10-29 05:34:45', '2099-01-10', 2);
(-)a/installer/data/mysql/en/optional/sample_patrons.sql (-52 / +53 lines)
Lines 1-52 Link Here
1
INSERT INTO `borrowers` (`borrowernumber`, `cardnumber`, `surname`, `firstname`, `title`, `othernames`, `initials`, `streetnumber`, `streettype`, `address`, `address2`, `city`, `zipcode`, `email`, `phone`, `mobile`, `fax`, `emailpro`, `phonepro`, `B_streetnumber`, `B_streettype`, `B_address`, `B_city`, `B_zipcode`, `B_email`, `B_phone`, `dateofbirth`, `branchcode`, `categorycode`, `dateenrolled`, `dateexpiry`, `gonenoaddress`, `lost`, `debarred`, `contactname`, `contactfirstname`, `contacttitle`, `guarantorid`, `borrowernotes`, `relationship`, `ethnicity`, `ethnotes`, `sex`, `userid`, `opacnote`, `contactnote`, `password`, `flags`, `sort1`, `sort2`) VALUES 
1
INSERT
2
2
INTO borrowers (borrowernumber, cardnumber, surname, firstname, title, othernames, initials, streetnumber, streettype, address, address2, city, zipcode, email, phone, mobile, fax, emailpro, phonepro, B_streetnumber, B_streettype, B_address, B_city, B_zipcode, B_email, B_phone, dateofbirth, branchcode, categorycode, dateenrolled, dateexpiry, gonenoaddress, lost, debarred, contactname, contactfirstname, contacttitle, guarantorid, borrowernotes, relationship, ethnicity, ethnotes, sex, userid, opacnote, contactnote, password, flags, sort1, sort2)
3
(1,'1','Admin','Koha',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','S',NULL,'2099-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
3
VALUES
4
(2,'23529000152273','Welch','Marcus',NULL,NULL,'',NULL,NULL,'5601 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'FRL','ST','1985-10-24','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000152273',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.43609457503641','0.38613959717205'),
4
    (1, '1', 'Admin', 'Koha', NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MPL', 'S', NULL, '2099-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
5
(3,'23529000445172','Daniels','Tanya',NULL,NULL,'',NULL,NULL,'2035 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1966-10-14','MPL','PT','1990-08-22','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000445172',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62241429148467','0.95365269664084'),
5
    (2, '23529000152273', 'Welch', 'Marcus', NULL, NULL, '', NULL, NULL, '5601 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'FRL', 'ST', '1985-10-24', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000152273', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.43609457503641', '0.38613959717205'),
6
(4,'23529000105040','Dillon','Eva',NULL,NULL,'',NULL,NULL,'8916 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-04-03','MPL','PT','1987-07-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000105040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.90102063948384','0.64414513823031'),
6
    (3, '23529000445172', 'Daniels', 'Tanya', NULL, NULL, '', NULL, NULL, '2035 Library Rd.', NULL, 'Portland, ME', '44236', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1966-10-14', 'MPL', 'PT', '1990-08-22', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000445172', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.62241429148467', '0.95365269664084'),
7
(5,'23529001000463','Acosta','Edna',NULL,NULL,'',NULL,NULL,'7896 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1980-04-24','MPL','PT','1990-11-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529001000463',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.72642678648832','0.6644830635418'),
7
    (4, '23529000105040', 'Dillon', 'Eva', NULL, NULL, '', NULL, NULL, '8916 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1952-04-03', 'MPL', 'PT', '1987-07-01', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000105040', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.90102063948384', '0.64414513823031'),
8
(6,'23529000591678','Glass','Virgil',NULL,NULL,'',NULL,NULL,'6250 Library Rd.',NULL,'Santa Cruz, CA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1974-06-19','SPL','T','1985-02-13','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,102,NULL,NULL,NULL,NULL,'M','23529000591678',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.1431349889777','0.72222578499673'),
8
    (5, '23529001000463', 'Acosta', 'Edna', NULL, NULL, '', NULL, NULL, '7896 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1980-04-24', 'MPL', 'PT', '1990-11-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529001000463', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.72642678648832', '0.6644830635418'),
9
(7,'23529000080862','Middleton','Bobbie',NULL,NULL,'',NULL,NULL,'4619 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-07-24','SPL','J','1991-03-13','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,104,NULL,NULL,NULL,NULL,'M','23529000080862',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.18172398878422','0.74194261966454'),
9
    (6, '23529000591678', 'Glass', 'Virgil', NULL, NULL, '', NULL, NULL, '6250 Library Rd.', NULL, 'Santa Cruz, CA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1974-06-19', 'SPL', 'T', '1985-02-13', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 102, NULL, NULL, NULL, NULL, 'M', '23529000591678', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.1431349889777', '0.72222578499673'),
10
(8,'23529000358268','Rivera','Olga',NULL,NULL,'',NULL,NULL,'6058 Library Rd.',NULL,'Mayfield Heights, OH','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1979-12-22','PVL','T','1986-04-17','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,112,NULL,NULL,NULL,NULL,'F','23529000358268',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.16454116270369','0.59687798525847'),
10
    (7, '23529000080862', 'Middleton', 'Bobbie', NULL, NULL, '', NULL, NULL, '4619 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1953-07-24', 'SPL', 'J', '1991-03-13', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 104, NULL, NULL, NULL, NULL, 'M', '23529000080862', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.18172398878422', '0.74194261966454'),
11
(9,'23529000429697','Waters','Annie',NULL,NULL,'',NULL,NULL,'5444 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1932-10-27','FRL','ST','1984-05-07','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000429697',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.49076646891494','0.66319841953292'),
11
    (8, '23529000358268', 'Rivera', 'Olga', NULL, NULL, '', NULL, NULL, '6058 Library Rd.', NULL, 'Mayfield Heights, OH', '21234', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1979-12-22', 'PVL', 'T', '1986-04-17', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 112, NULL, NULL, NULL, NULL, 'F', '23529000358268', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.16454116270369', '0.59687798525847'),
12
(10,'23529000068917','Herring','Frances',NULL,NULL,'',NULL,NULL,'4024 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-02-13','SPL','PT','1993-03-12','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000068917',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84369272165344','0.22886838040209'),
12
    (9, '23529000429697', 'Waters', 'Annie', NULL, NULL, '', NULL, NULL, '5444 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1932-10-27', 'FRL', 'ST', '1984-05-07', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000429697', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.49076646891494', '0.66319841953292'),
13
(11,'23529000065863','Hawkins','Sam',NULL,NULL,'',NULL,NULL,'665 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1924-03-26','SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000065863',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.61326376778378','0.37971372844625'),
13
    (10, '23529000068917', 'Herring', 'Frances', NULL, NULL, '', NULL, NULL, '4024 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1953-02-13', 'SPL', 'PT', '1993-03-12', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000068917', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.84369272165344', '0.22886838040209'),
14
(12,'23529000878885','Mcknight','Marie',NULL,NULL,'',NULL,NULL,'4241 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','YA','1990-08-06','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000878885',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.058777369613552','0.15474569346266'),
14
    (11, '23529000065863', 'Hawkins', 'Sam', NULL, NULL, '', NULL, NULL, '665 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1924-03-26', 'SPL', 'PT', '1984-05-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000065863', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.61326376778378', '0.37971372844625'),
15
(13,'23529000132291','Edwards','Roy',NULL,NULL,'',NULL,NULL,'9929 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1928-09-09','MPL','PT','1992-03-10','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000132291',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.59739638920631','0.5227448963772'),
15
    (12, '23529000878885', 'Mcknight', 'Marie', NULL, NULL, '', NULL, NULL, '4241 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SPL', 'YA', '1990-08-06', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000878885', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.058777369613552', '0.15474569346266'),
16
(14,'23529000035726','Mccullough','Phillip',NULL,NULL,'',NULL,NULL,'410 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1943-11-23','SPL','PT','1986-01-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000035726',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.82153534500071','0.53944206660561'),
16
    (13, '23529000132291', 'Edwards', 'Roy', NULL, NULL, '', NULL, NULL, '9929 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1928-09-09', 'MPL', 'PT', '1992-03-10', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000132291', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.59739638920631', '0.5227448963772'),
17
(15,'23529001203323','Peterson','Gordon',NULL,NULL,'',NULL,NULL,'6285 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1963-10-01','SPL','J','1984-09-11','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,131,NULL,NULL,NULL,NULL,'F','23529001203323',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.23260432875958','0.54469547471469'),
17
    (14, '23529000035726', 'Mccullough', 'Phillip', NULL, NULL, '', NULL, NULL, '410 Library Rd.', NULL, 'Portland, ME', '44236', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1943-11-23', 'SPL', 'PT', '1986-01-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000035726', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.82153534500071', '0.53944206660561'),
18
(16,'23529000991266','Walker','Andrea',NULL,NULL,'',NULL,NULL,'4992 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1956-08-05','FRL','IL','1993-06-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000991266',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.025664418028355','0.49423569673135'),
18
    (15, '23529001203323', 'Peterson', 'Gordon', NULL, NULL, '', NULL, NULL, '6285 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1963-10-01', 'SPL', 'J', '1984-09-11', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 131, NULL, NULL, NULL, NULL, 'F', '23529001203323', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.23260432875958', '0.54469547471469'),
19
(17,'23529000711078','King','Casey',NULL,NULL,'',NULL,NULL,'3438 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1953-09-23','SPL','S','1992-05-18','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000711078',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.39418526030535','0.48821924206635'),
19
    (16, '23529000991266', 'Walker', 'Andrea', NULL, NULL, '', NULL, NULL, '4992 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1956-08-05', 'FRL', 'IL', '1993-06-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000991266', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.025664418028355', '0.49423569673135'),
20
(18,'23529000809559','Delgado','Floyd',NULL,NULL,'',NULL,NULL,'6661 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1968-02-01','MPL','K','1988-08-05','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,160,NULL,NULL,NULL,NULL,'M','23529000809559',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.25854046014933','0.82804460528125'),
20
    (17, '23529000711078', 'King', 'Casey', NULL, NULL, '', NULL, NULL, '3438 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1953-09-23', 'SPL', 'S', '1992-05-18', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000711078', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.39418526030535', '0.48821924206635'),
21
(19,'23529000035676','Acevedo','Henry',NULL,NULL,'',NULL,NULL,'4345 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1958-05-30','MPL','S','1990-09-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000035676',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.36460167669188','0.33887459834933'),
21
    (18, '23529000809559', 'Delgado', 'Floyd', NULL, NULL, '', NULL, NULL, '6661 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1968-02-01', 'MPL', 'K', '1988-08-05', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 160, NULL, NULL, NULL, NULL, 'M', '23529000809559', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.25854046014933', '0.82804460528125'),
22
(20,'23529000033739','Frazier','Sonia',NULL,NULL,'',NULL,NULL,'8165 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1945-09-16','MPL','PT','1984-06-21','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000033739',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60056799240463','0.98621619770882'),
22
    (19, '23529000035676', 'Acevedo', 'Henry', NULL, NULL, '', NULL, NULL, '4345 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1958-05-30', 'MPL', 'S', '1990-09-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000035676', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.36460167669188', '0.33887459834933'),
23
(21,'23529000139858','Ballard','Ronnie',NULL,NULL,'',NULL,NULL,'5730 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1956-02-23','MPL','T','1989-06-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,177,NULL,NULL,NULL,NULL,'F','23529000139858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12937704206386','0.68823664792649'),
23
    (20, '23529000033739', 'Frazier', 'Sonia', NULL, NULL, '', NULL, NULL, '8165 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1945-09-16', 'MPL', 'PT', '1984-06-21', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000033739', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.60056799240463', '0.98621619770882'),
24
(22,'23529000224510','Gaines','Joyce',NULL,NULL,'',NULL,NULL,'6012 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1957-08-01','SPL','YA','1992-09-16','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000224510',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.053052144174513','0.20055080782673'),
24
    (21, '23529000139858', 'Ballard', 'Ronnie', NULL, NULL, '', NULL, NULL, '5730 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1956-02-23', 'MPL', 'T', '1989-06-01', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 177, NULL, NULL, NULL, NULL, 'F', '23529000139858', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.12937704206386', '0.68823664792649'),
25
(23,'23529000120056','Bryan','Johnny',NULL,NULL,'',NULL,NULL,'8180 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1961-10-24','MPL','PT','1990-08-22','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000120056',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.84359763734378','0.61633579397233'),
25
    (22, '23529000224510', 'Gaines', 'Joyce', NULL, NULL, '', NULL, NULL, '6012 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1957-08-01', 'SPL', 'YA', '1992-09-16', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000224510', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.053052144174513', '0.20055080782673'),
26
(24,'23529000218553','Duffy','Joann',NULL,NULL,'',NULL,NULL,'1555 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1942-02-17','MPL','ST','1984-08-02','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000218553',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.55088608856395','0.90542309163643'),
26
    (23, '23529000120056', 'Bryan', 'Johnny', NULL, NULL, '', NULL, NULL, '8180 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1961-10-24', 'MPL', 'PT', '1990-08-22', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000120056', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.84359763734378', '0.61633579397233'),
27
(25,'23529000662701','Mejia','Armando',NULL,NULL,'',NULL,NULL,'8209 Library Rd.',NULL,'Portland, OR','44240',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1939-07-22','SPL','PT','1990-09-26','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000662701',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.87445722322395','0.65601687194409'),
27
    (24, '23529000218553', 'Duffy', 'Joann', NULL, NULL, '', NULL, NULL, '1555 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1942-02-17', 'MPL', 'ST', '1984-08-02', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000218553', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.55088608856395', '0.90542309163643'),
28
(26,'23529000092040','Hendrix','Keith',NULL,NULL,'',NULL,NULL,'6546 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1944-04-05','SPL','PT','1987-12-12','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000092040',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.65671272078223','0.31551301881253'),
28
    (25, '23529000662701', 'Mejia', 'Armando', NULL, NULL, '', NULL, NULL, '8209 Library Rd.', NULL, 'Portland, OR', '44240', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1939-07-22', 'SPL', 'PT', '1990-09-26', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000662701', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.87445722322395', '0.65601687194409'),
29
(27,'23529000058017','Turner','Sherri',NULL,NULL,'',NULL,NULL,'1731 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1964-11-21','FRL','PT','1987-09-14','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000058017',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.60742696244961','0.090595786544118'),
29
    (26, '23529000092040', 'Hendrix', 'Keith', NULL, NULL, '', NULL, NULL, '6546 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1944-04-05', 'SPL', 'PT', '1987-12-12', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000092040', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.65671272078223', '0.31551301881253'),
30
(28,'23529000299603','Cherry','Lillie',NULL,NULL,'',NULL,NULL,'263 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1931-01-19','MPL','PT','1993-03-19','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000299603',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.6306980761054','0.88170305162827'),
30
    (27, '23529000058017', 'Turner', 'Sherri', NULL, NULL, '', NULL, NULL, '1731 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1964-11-21', 'FRL', 'PT', '1987-09-14', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000058017', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.60742696244961', '0.090595786544118'),
31
(29,'23529000121682','Schneider','Nicole',NULL,NULL,'',NULL,NULL,'1008 Library Rd.',NULL,'Centerville, CA','44306',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1954-01-12','FRL','ST','1985-09-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000121682',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.5164210605588','0.93699617864284'),
31
    (28, '23529000299603', 'Cherry', 'Lillie', NULL, NULL, '', NULL, NULL, '263 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1931-01-19', 'MPL', 'PT', '1993-03-19', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000299603', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.6306980761054', '0.88170305162827'),
32
(30,'23529000240482','White','Jamie',NULL,NULL,'',NULL,NULL,'937 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1950-04-22','FRL','T','1990-02-03','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,254,NULL,NULL,NULL,NULL,'F','23529000240482',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.13571774227146','0.86760020616241'),
32
    (29, '23529000121682', 'Schneider', 'Nicole', NULL, NULL, '', NULL, NULL, '1008 Library Rd.', NULL, 'Centerville, CA', '44306', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1954-01-12', 'FRL', 'ST', '1985-09-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000121682', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.5164210605588', '0.93699617864284'),
33
(31,'23529000714163','Burgess','Dawn',NULL,NULL,'',NULL,NULL,'7907 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','PT','1985-05-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000714163',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.93084783473131','0.051438585902973'),
33
    (30, '23529000240482', 'White', 'Jamie', NULL, NULL, '', NULL, NULL, '937 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1950-04-22', 'FRL', 'T', '1990-02-03', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 254, NULL, NULL, NULL, NULL, 'F', '23529000240482', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.13571774227146', '0.86760020616241'),
34
(32,'23529000318858','Bennett','Pamela',NULL,NULL,'',NULL,NULL,'9898 Library Rd.',NULL,'Centerville, CA','44310',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1946-09-16','MPL','ST','1984-05-08','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000318858',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.46464945605458','0.16893155329761'),
34
    (31, '23529000714163', 'Burgess', 'Dawn', NULL, NULL, '', NULL, NULL, '7907 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MPL', 'PT', '1985-05-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000714163', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.93084783473131', '0.051438585902973'),
35
(33,'23529000526047','Hatfield','Lester',NULL,NULL,'',NULL,NULL,'393 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1983-01-22','SPL','ST','1988-07-30','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000526047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.45070942905798','0.74675251613069'),
35
    (32, '23529000318858', 'Bennett', 'Pamela', NULL, NULL, '', NULL, NULL, '9898 Library Rd.', NULL, 'Centerville, CA', '44310', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1946-09-16', 'MPL', 'ST', '1984-05-08', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000318858', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.46464945605458', '0.16893155329761'),
36
(34,'23529000686353','Harper','Ruben',NULL,NULL,'',NULL,NULL,'6963 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1917-09-24','SPL','S','1991-02-19','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000686353',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.38163432421315','0.66791410340733'),
36
    (33, '23529000526047', 'Hatfield', 'Lester', NULL, NULL, '', NULL, NULL, '393 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1983-01-22', 'SPL', 'ST', '1988-07-30', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000526047', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.45070942905798', '0.74675251613069'),
37
(35,'23529000719519','Kinney','Mae',NULL,NULL,'',NULL,NULL,'2114 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','J','1991-12-29','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,287,NULL,NULL,NULL,NULL,'F','23529000719519',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.19466757513086','0.96959559616595'),
37
    (34, '23529000686353', 'Harper', 'Ruben', NULL, NULL, '', NULL, NULL, '6963 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1917-09-24', 'SPL', 'S', '1991-02-19', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000686353', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.38163432421315', '0.66791410340733'),
38
(36,'23529000179433','Williamson','Catherine',NULL,NULL,'',NULL,NULL,'5879 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1930-12-18','FRL','K','1985-01-23','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,288,NULL,NULL,NULL,NULL,'M','23529000179433',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26397528617082','0.41108967308988'),
38
    (35, '23529000719519', 'Kinney', 'Mae', NULL, NULL, '', NULL, NULL, '2114 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SPL', 'J', '1991-12-29', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 287, NULL, NULL, NULL, NULL, 'F', '23529000719519', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.19466757513086', '0.96959559616595'),
39
(37,'23529000197047','Charles','Lisa',NULL,NULL,'',NULL,NULL,'6813 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1982-10-14','MPL','K','1988-11-14','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,289,NULL,NULL,NULL,NULL,'M','23529000197047',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.26352253767058','0.084343699816934'),
39
    (36, '23529000179433', 'Williamson', 'Catherine', NULL, NULL, '', NULL, NULL, '5879 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1930-12-18', 'FRL', 'K', '1985-01-23', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 288, NULL, NULL, NULL, NULL, 'M', '23529000179433', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.26397528617082', '0.41108967308988'),
40
(38,'23529000695412','Singleton','Bob',NULL,NULL,'',NULL,NULL,'4554 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1983-04-15','FRL','PT','1991-07-01','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000695412',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.63115091680656','0.90272351531566'),
40
    (37, '23529000197047', 'Charles', 'Lisa', NULL, NULL, '', NULL, NULL, '6813 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1982-10-14', 'MPL', 'K', '1988-11-14', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 289, NULL, NULL, NULL, NULL, 'M', '23529000197047', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.26352253767058', '0.084343699816934'),
41
(39,'23529000603242','Mcconnell','Terrence',NULL,NULL,'',NULL,NULL,'7200 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1949-06-10','SPL','PT','1984-05-31','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000603242',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.62016485689223','0.39265376924784'),
41
    (38, '23529000695412', 'Singleton', 'Bob', NULL, NULL, '', NULL, NULL, '4554 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1983-04-15', 'FRL', 'PT', '1991-07-01', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000695412', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.63115091680656', '0.90272351531566'),
42
(40,'23529000589458','Knight','Mabel',NULL,NULL,'',NULL,NULL,'8997 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-12-22','SPL','T','1985-04-17','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,320,NULL,NULL,NULL,NULL,'M','23529000589458',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.10277430629616','0.33591025447092'),
42
    (39, '23529000603242', 'Mcconnell', 'Terrence', NULL, NULL, '', NULL, NULL, '7200 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1949-06-10', 'SPL', 'PT', '1984-05-31', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000603242', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.62016485689223', '0.39265376924784'),
43
(41,'23529000054503','Odom','Gloria',NULL,NULL,'',NULL,NULL,'9156 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-04-05','SPL','S','1992-07-21','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000054503',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.37122838419976','0.84841118831971'),
43
    (40, '23529000589458', 'Knight', 'Mabel', NULL, NULL, '', NULL, NULL, '8997 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1952-12-22', 'SPL', 'T', '1985-04-17', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 320, NULL, NULL, NULL, NULL, 'M', '23529000589458', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.10277430629616', '0.33591025447092'),
44
(42,'23529000126806','Hopkins','Brent',NULL,NULL,'',NULL,NULL,'6692 Library Rd.',NULL,'Santa Cruz, CA','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1977-11-13','SPL','T','1984-06-28','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,337,NULL,NULL,NULL,NULL,'F','23529000126806',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.12837081973289','0.096620564438981'),
44
    (41, '23529000054503', 'Odom', 'Gloria', NULL, NULL, '', NULL, NULL, '9156 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1952-04-05', 'SPL', 'S', '1992-07-21', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000054503', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.37122838419976', '0.84841118831971'),
45
(43,'23529000104159','Benson','Clinton',NULL,NULL,'',NULL,NULL,'4695 Library Rd.',NULL,'Atwater, OH','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MPL','YA','1985-10-28','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000104159',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.097990393729872','0.20009030606606'),
45
    (42, '23529000126806', 'Hopkins', 'Brent', NULL, NULL, '', NULL, NULL, '6692 Library Rd.', NULL, 'Santa Cruz, CA', '21234', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1977-11-13', 'SPL', 'T', '1984-06-28', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, 337, NULL, NULL, NULL, NULL, 'F', '23529000126806', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.12837081973289', '0.096620564438981'),
46
(44,'23529000395609','Stuart','Shannon',NULL,NULL,'',NULL,NULL,'5011 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1951-02-13','FRL','PT','1986-01-16','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000395609',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.70648037987433','0.93213101190713'),
46
    (43, '23529000104159', 'Benson', 'Clinton', NULL, NULL, '', NULL, NULL, '4695 Library Rd.', NULL, 'Atwater, OH', '21234', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'MPL', 'YA', '1985-10-28', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000104159', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.097990393729872', '0.20009030606606'),
47
(45,'23529000050113','Alford','Jordan',NULL,NULL,'',NULL,NULL,'5129 Library Rd.',NULL,'Centerville, CA','44262',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1952-05-27','MPL','ST','1985-09-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000050113',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.54121395064631','0.90967674824379'),
47
    (44, '23529000395609', 'Stuart', 'Shannon', NULL, NULL, '', NULL, NULL, '5011 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1951-02-13', 'FRL', 'PT', '1986-01-16', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000395609', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.70648037987433', '0.93213101190713'),
48
(46,'23529000053836','Mcfarland','Marilyn',NULL,NULL,'',NULL,NULL,'4600 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000053836',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.92474192001367','0.89467938607063'),
48
    (45, '23529000050113', 'Alford', 'Jordan', NULL, NULL, '', NULL, NULL, '5129 Library Rd.', NULL, 'Centerville, CA', '44262', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1952-05-27', 'MPL', 'ST', '1985-09-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000050113', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.54121395064631', '0.90967674824379'),
49
(47,'23529000774373','Morris','Lauren',NULL,NULL,'',NULL,NULL,'5436 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SPL','PT','1986-03-20','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000774373',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.69917120104578','0.81181787775067'),
49
    (46, '23529000053836', 'Mcfarland', 'Marilyn', NULL, NULL, '', NULL, NULL, '4600 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SPL', 'PT', '1984-05-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000053836', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.92474192001367', '0.89467938607063'),
50
(48,'23529000117565','Palmer','Bill',NULL,NULL,'',NULL,NULL,'2761 Library Rd.',NULL,'Springfield, MA','44224',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1984-01-10','SPL','PT','1991-10-07','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'M','23529000117565',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.96157581634966','0.37242547922994'),
50
    (47, '23529000774373', 'Morris', 'Lauren', NULL, NULL, '', NULL, NULL, '5436 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SPL', 'PT', '1986-03-20', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000774373', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.69917120104578', '0.81181787775067'),
51
(49,'23529000651225','Burton','Mary',NULL,NULL,'',NULL,NULL,'8131 Library Rd.',NULL,'Santa Cruz, CA','21234',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1977-12-25','MPL','PT','1985-05-30','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529000651225',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.97739997783434','0.76972348221552'),
51
    (48, '23529000117565', 'Palmer', 'Bill', NULL, NULL, '', NULL, NULL, '2761 Library Rd.', NULL, 'Springfield, MA', '44224', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1984-01-10', 'SPL', 'PT', '1991-10-07', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M', '23529000117565', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.96157581634966', '0.37242547922994'),
52
(50,'23529001223636','Peters','Tommy',NULL,NULL,'',NULL,NULL,'5171 Library Rd.',NULL,'Portland, ME','44236',NULL,'(212) 555-1212',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1951-06-14','SPL','PT','1984-05-09','2020-12-31',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','23529001223636',NULL,NULL,'42b29d0771f3b7ef',NULL,'0.91641750830823','0.27291712562825');
52
    (49, '23529000651225', 'Burton', 'Mary', NULL, NULL, '', NULL, NULL, '8131 Library Rd.', NULL, 'Santa Cruz, CA', '21234', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1977-12-25', 'MPL', 'PT', '1985-05-30', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529000651225', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.97739997783434', '0.76972348221552'),
53
    (50, '23529001223636', 'Peters', 'Tommy', NULL, NULL, '', NULL, NULL, '5171 Library Rd.', NULL, 'Portland, ME', '44236', NULL, '(212) 555-1212', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1951-06-14', 'SPL', 'PT', '1984-05-09', '2020-12-31', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'F', '23529001223636', NULL, NULL, '42b29d0771f3b7ef', NULL, '0.91641750830823', '0.27291712562825');
(-)a/installer/data/mysql/en/optional/sample_quotes.sql (-34 / +34 lines)
Lines 1-34 Link Here
1
/*!40000 ALTER TABLE `quotes` DISABLE KEYS */;
1
INSERT
2
INSERT INTO `quotes` VALUES
2
INTO quotes (id, source, text, timestamp)
3
(1,'George Washington','To be prepared for war is one of the most effectual means of preserving peace.','0000-00-00 00:00:00'),
3
VALUES
4
(2,'Thomas Jefferson','When angry, count ten, before you speak; if very angry, an hundred.','0000-00-00 00:00:00'),
4
    (1, 'George Washington', i18n('To be prepared for war is one of the most effectual means of preserving peace.'), '0000-00-00 00:00:00'),
5
(3,'Abraham Lincoln','Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.','0000-00-00 00:00:00'),
5
    (2, 'Thomas Jefferson', i18n('When angry, count ten, before you speak; if very angry, an hundred.'), '0000-00-00 00:00:00'),
6
(4,'Abraham Lincoln','I have always found that mercy bears richer fruits than strict justice.','0000-00-00 00:00:00'),
6
    (3, 'Abraham Lincoln', i18n('Four score and seven years ago our fathers brought forth on this continent, a new nation, conceived in Liberty, and dedicated to the proposition that all men are created equal.'), '0000-00-00 00:00:00'),
7
(5,'Andrew Johnson','I feel incompetent to perform duties...which have been so unexpectedly thrown upon me.','0000-00-00 00:00:00'),
7
    (4, 'Abraham Lincoln', i18n('I have always found that mercy bears richer fruits than strict justice.'), '0000-00-00 00:00:00'),
8
(6,'Rutherford B. Hayes','He serves his party best who serves his country best.','0000-00-00 00:00:00'),
8
    (5, 'Andrew Johnson', i18n('I feel incompetent to perform duties...which have been so unexpectedly thrown upon me.'), '0000-00-00 00:00:00'),
9
(7,'Theodore Roosevelt','No President has ever enjoyed himself as much as I?','0000-00-00 00:00:00'),
9
    (6, 'Rutherford B. Hayes', i18n('He serves his party best who serves his country best.'), '0000-00-00 00:00:00'),
10
(8,'Theodore Roosevelt','Speak softly and carry a big stick.','0000-00-00 00:00:00'),
10
    (7, 'Theodore Roosevelt', i18n('No President has ever enjoyed himself as much as I?'), '0000-00-00 00:00:00'),
11
(9,'William H. Taft','I have come to the conclusion that the major part of the president is to increase the gate receipts of expositions and fairs and bring tourists to town.','0000-00-00 00:00:00'),
11
    (8, 'Theodore Roosevelt', i18n('Speak softly and carry a big stick.'), '0000-00-00 00:00:00'),
12
(11,'Woodrow Wilson','You cannot become thorough Americans if you think of yourselves in groups. America does not consist of groups. A man who thinks of himself as belonging to a particular national group in America has not yet become an American.','0000-00-00 00:00:00'),
12
    (9, 'William H. Taft', i18n('I have come to the conclusion that the major part of the president is to increase the gate receipts of expositions and fairs and bring tourists to town.'), '0000-00-00 00:00:00'),
13
(12,'Calvin Coolidge','If you don\'t say anything, you won\'t be called on to repeat it.','0000-00-00 00:00:00'),
13
    (11, 'Woodrow Wilson', i18n('You cannot become thorough Americans if you think of yourselves in groups. America does not consist of groups. A man who thinks of himself as belonging to a particular national group in America has not yet become an American.'), '0000-00-00 00:00:00'),
14
(13,'Calvin Coolidge','Four fifths of all our troubles in this life would disappear if we would only sit down and keep still.','0000-00-00 00:00:00'),
14
    (12, 'Calvin Coolidge', i18n('If you don\'t say anything, you won\'t be called on to repeat it.'), '0000-00-00 00:00:00'),
15
(14,'Herbert Hoover','The slogan of progress is changing from the full dinner pail to the full garage.','0000-00-00 00:00:00'),
15
    (13, 'Calvin Coolidge', i18n('Four fifths of all our troubles in this life would disappear if we would only sit down and keep still.'), '0000-00-00 00:00:00'),
16
(15,'Franklin D. Roosevelt','Let me assert my firm belief that the only thing we have to fear is fear itself.','0000-00-00 00:00:00'),
16
    (14, 'Herbert Hoover', i18n('The slogan of progress is changing from the full dinner pail to the full garage.'), '0000-00-00 00:00:00'),
17
(16,'Harry S. Truman','If you can\'t stand the heat, get out of the kitchen.','0000-00-00 00:00:00'),
17
    (15, 'Franklin D. Roosevelt', i18n('Let me assert my firm belief that the only thing we have to fear is fear itself.'), '0000-00-00 00:00:00'),
18
(17,'Harry S. Truman','The atom bomb was no great decision. It was merely another powerful weapon in the arsenal of righteousness.','0000-00-00 00:00:00'),
18
    (16, 'Harry S. Truman', i18n('If you can\'t stand the heat, get out of the kitchen.'), '0000-00-00 00:00:00'),
19
(18,'Harry S. Truman','The buck stops here.','0000-00-00 00:00:00'),
19
    (17, 'Harry S. Truman', i18n('The atom bomb was no great decision. It was merely another powerful weapon in the arsenal of righteousness.'), '0000-00-00 00:00:00'),
20
(19,'Dwight D. Eisenhower','History does not long entrust the care of freedom to the weak or the timid.','0000-00-00 00:00:00'),
20
    (18, 'Harry S. Truman', i18n('The buck stops here.'), '0000-00-00 00:00:00'),
21
(20,'John F. Kennedy','My fellow Americans, ask not what your country can do for you; ask what you can do for your country.','0000-00-00 00:00:00'),
21
    (19, 'Dwight D. Eisenhower', i18n('History does not long entrust the care of freedom to the weak or the timid.'), '0000-00-00 00:00:00'),
22
(22,'John F. Kennedy','I do not think it altogether inappropriate to introduce myself to this audience. I am the man who accompanied Jacqueline Kennedy to Paris, and I have enjoyed it.','0000-00-00 00:00:00'),
22
    (20, 'John F. Kennedy', i18n('My fellow Americans, ask not what your country can do for you; ask what you can do for your country.'), '0000-00-00 00:00:00'),
23
(23,'Lyndon B. Johnson','The Great Society is a place where every child can find knowledge to enrich his mind and to enlarge his talents. It is a place where the city of man serves not only the needs of the body and the demands of commerce but the desire for beauty and the hunger for community. It is a place where men are more concerned with the quality of their goals than the quantity of their goods.','0000-00-00 00:00:00'),
23
    (22, 'John F. Kennedy', i18n('I do not think it altogether inappropriate to introduce myself to this audience. I am the man who accompanied Jacqueline Kennedy to Paris, and I have enjoyed it.'), '0000-00-00 00:00:00'),
24
(24,'Richard Nixon','People have got to know whether or not their president is a crook. Well, I\'m not a crook.','0000-00-00 00:00:00'),
24
    (23, 'Lyndon B. Johnson', i18n('The Great Society is a place where every child can find knowledge to enrich his mind and to enlarge his talents. It is a place where the city of man serves not only the needs of the body and the demands of commerce but the desire for beauty and the hunger for community. It is a place where men are more concerned with the quality of their goals than the quantity of their goods.'), '0000-00-00 00:00:00'),
25
(25,'Richard Nixon','When the President does it, that means that it is not illegal.','0000-00-00 00:00:00'),
25
    (24, 'Richard Nixon', i18n('People have got to know whether or not their president is a crook. Well, I\'m not a crook.'), '0000-00-00 00:00:00'),
26
(26,'Gerald R. Ford','Our Long national nightmare is over.','0000-00-00 00:00:00'),
26
    (25, 'Richard Nixon', i18n('When the President does it, that means that it is not illegal.'), '0000-00-00 00:00:00'),
27
(27,'Gerald R. Ford','Our constitution works. Our great republic is a government of laws, not of men.','0000-00-00 00:00:00'),
27
    (26, 'Gerald R. Ford', i18n('Our Long national nightmare is over.'), '0000-00-00 00:00:00'),
28
(28,'Jimmy Carter','A strong nation, like a strong person, can afford to be gentle, firm, thoughtful, and restrained. It can afford to extend a helping hand to others. It\'s a weak nation, like a weak person, that must behave with bluster and boasting and rashness and other signs of insecurity.','0000-00-00 00:00:00'),
28
    (27, 'Gerald R. Ford', i18n('Our constitution works. Our great republic is a government of laws, not of men.'), '0000-00-00 00:00:00'),
29
(30,'Ronald Reagan','It is not my intention to do away with government. It is rather to make it work -work with us, not over us; stand by our side, not ride on our back. Government can and must provide opportunity, not smother it; foster productivity, not stifle it. This Administration\'s objective will be a healthy, vigorous, growing economy.','0000-00-00 00:00:00'),
29
    (28, 'Jimmy Carter', i18n('A strong nation, like a strong person, can afford to be gentle, firm, thoughtful, and restrained. It can afford to extend a helping hand to others. It\'s a weak nation, like a weak person, that must behave with bluster and boasting and rashness and other signs of insecurity.'), '0000-00-00 00:00:00'),
30
(31,'Ronald Reagan','Each generation goes further than the generation preceding it because it stands on the shoulders of that generation. You will have opportunities beyond anything we\'ve ever known.','0000-00-00 00:00:00'),
30
    (30, 'Ronald Reagan', i18n('It is not my intention to do away with government. It is rather to make it work -work with us, not over us; stand by our side, not ride on our back. Government can and must provide opportunity, not smother it; foster productivity, not stifle it. This Administration\'s objective will be a healthy, vigorous, growing economy.'), '0000-00-00 00:00:00'),
31
(32,'George H. W. Bush ','We have ...drawn a line in the sand.','0000-00-00 00:00:00'),
31
    (31, 'Ronald Reagan', i18n('Each generation goes further than the generation preceding it because it stands on the shoulders of that generation. You will have opportunities beyond anything we\'ve ever known.'), '0000-00-00 00:00:00'),
32
(33,'George W. Bush','If America shows weakness and uncertainty, the world will drift toward tragedy. That will not happen on my watch.','0000-00-00 00:00:00'),
32
    (32, 'George H. W. Bush ', i18n('We have ...drawn a line in the sand.'), '0000-00-00 00:00:00'),
33
(34,'George W. Bush','Every nation in every region now has a decision to make. Either you are with us, or you are with the terrorists.','0000-00-00 00:00:00');
33
    (33, 'George W. Bush', i18n('If America shows weakness and uncertainty, the world will drift toward tragedy. That will not happen on my watch.'), '0000-00-00 00:00:00'),
34
/*!40000 ALTER TABLE `quotes` ENABLE KEYS */;
34
    (34, 'George W. Bush', i18n('Every nation in every region now has a decision to make. Either you are with us, or you are with the terrorists.'), '0000-00-00 00:00:00');
(-)a/installer/data/mysql/en/optional/sample_z3950_servers.sql (-6 / +6 lines)
Lines 1-5 Link Here
1
INSERT INTO `z3950servers`
1
INSERT
2
(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `encoding`) VALUES 
2
INTO z3950servers (host, port, db, userid, password, name, id, checked, rank, syntax, encoding)
3
('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,1,'USMARC','utf8'),
3
VALUES
4
('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',6,0,0,'USMARC','MARC-8'),
4
    ('lx2.loc.gov', 210, 'LCDB', '', '', i18n('LIBRARY OF CONGRESS'), 1, 1, 1, 'USMARC', 'utf8'),
5
('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',10,0,0,'USMARC','MARC-8'); 
5
    ('clio-db.cc.columbia.edu', 7090, 'voyager', '', '', i18n('COLUMBIA UNIVERSITY'), 6, 0, 0, 'USMARC', 'MARC-8'),
6
    ('siris-libraries.si.edu', 210, 'Default', '', '', i18n('SMITHSONIAN INSTITUTION LIBRARIES'), 10, 0, 0, 'USMARC', 'MARC-8');
6
- 

Return to bug 10520