From: Jason Etheridge <jason@esilibrary.com>
Date: Sat, 23 Aug 2008 04:15:08 +0000 (+0000)
Subject: seq adjustment
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=9f5e921f49d57abb597c77e8da6baa48938d0af8

seq adjustment
---

diff --git a/clear-db.sql b/clear-db.sql
index 7e31652..c51f091 100644
--- 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.
 /*