From 9f5e921f49d57abb597c77e8da6baa48938d0af8 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Sat, 23 Aug 2008 04:15:08 +0000 Subject: [PATCH] seq adjustment --- clear-db.sql | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) 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. /* -- 1.7.2.5