projects
/
migration-tools.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
(parent:
6a59386
)
seq adjustment
author
Jason Etheridge
<jason@esilibrary.com>
Sat, 23 Aug 2008 04:15:08 +0000 (
04:15
+0000)
committer
Jason Etheridge
<jason@esilibrary.com>
Sat, 23 Aug 2008 04:15:08 +0000 (
04:15
+0000)
clear-db.sql
patch
|
blob
|
history
diff --git
a/clear-db.sql
b/clear-db.sql
index
7e31652
..
c51f091
100644
(file)
--- a/
clear-db.sql
+++ b/
clear-db.sql
@@
-81,6
+81,8
@@
INSERT INTO asset.copy_location SELECT * FROM backup_loc;
INSERT INTO actor.usr SELECT * FROM backup_usr;
INSERT INTO actor.card SELECT * FROM backup_card;
UPDATE actor.usr SET card = actor.card.id FROM actor.card WHERE actor.usr.id = actor.card.usr;
+SELECT SETVAL('actor.usr_id_seq', (SELECT MAX(id)+1 FROM actor.usr));
+SELECT SETVAL('actor.card_id_seq', (SELECT MAX(id)+1 FROM actor.card));
-- Put any scripts that reload bibs/items/etc here. Example included.
/*