X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fnuke-bibs-and-items.sql;h=d872671aa793817d61e2b3135b17ccbc4f9bcd69;hp=9e646479f8670c4e2a82124ce61debd06bb121dc;hb=220c52587cae597d5ac513f122342b1e703a099b;hpb=7af21df77fb31c255c21c4a37addf7c645d42731

diff --git a/sql/nuke-bibs-and-items.sql b/sql/nuke-bibs-and-items.sql
index 9e64647..d872671 100644
--- a/sql/nuke-bibs-and-items.sql
+++ b/sql/nuke-bibs-and-items.sql
@@ -30,13 +30,24 @@ CREATE TABLE biblio.record_entry_temp AS (
 TRUNCATE
   action.circulation,
   asset.copy,
+  asset.opac_visible_copies,
   biblio.record_entry,
   asset.call_number,
   metabib.metarecord_source_map,
-  metabib.metarecord
+  metabib.metarecord,
+  metabib.facet_entry,
+  metabib.browse_entry,
+  authority.record_entry,
+  authority.full_rec,
+  authority.rec_descriptor
 CASCADE;
 
 INSERT INTO asset.call_number SELECT * FROM asset.call_number_temp;
 INSERT INTO biblio.record_entry SELECT * FROM biblio.record_entry_temp;
 
+DROP TABLE asset.call_number_temp;
+DROP TABLE biblio.record_entry_temp;
+
+\echo If the purge looks good, please COMMIT
+\echo You should also follow with a VACUUM ANALYZE or the like.