From 94a2a31e15793ad43394c055e347d8fef09c662f Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Sat, 23 Aug 2008 05:01:06 +0000 Subject: [PATCH] --- clear-db.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/clear-db.sql b/clear-db.sql index c51f091..1602265 100644 --- a/clear-db.sql +++ b/clear-db.sql @@ -9,7 +9,7 @@ CREATE TEMP TABLE dummy_cn AS SELECT * FROM asset.call_number WHERE id = -1; CREATE TEMP TABLE backup_loc AS SELECT * FROM asset.copy_location WHERE id = 1; CREATE TEMP TABLE backup_usr AS SELECT * FROM actor.usr WHERE id = 1; -CREATE TEMP TABLE backup_card AS SELECT * FROM actor.card WHERE usr = 1; +CREATE TEMP TABLE backup_card AS SELECT * FROM actor.card WHERE usr IN (SELECT id FROM backup_usr); UPDATE backup_usr SET card = NULL; -- 1.7.2.5