projects
/
working
/
Evergreen.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Upgrade script for LP#1105225: LOC z39.50 seed data
[working/Evergreen.git]
/
Open-ILS
/
src
/
sql
/
Pg
/
upgrade
/
XXXX.data.loc_z39_settings.sql
1
2
BEGIN;
3
4
UPDATE config.z3950_source
5
SET host = 'lx2.loc.gov', port = 210, db = 'LCDB'
6
WHERE name = 'loc'
7
AND host = 'z3950.loc.gov'
8
AND port = 7090
9
AND db = 'Voyager';
10
11
UPDATE config.z3950_attr
12
SET format = 6
13
WHERE source = 'loc'
14
AND name = 'lccn'
15
AND format = 1;
16
17
COMMIT;
18