delete first 100 user and history-item-less histories

delete_histories_without_user_and_history_items.sql

BEGIN;

-- Clean up pgcleanup table
DELETE FROM cleanup_event_history_association WHERE cleanup_event_history_association.history_id IN (SELECT id FROM history WHERE history.user_id is null AND history.hid_counter = 1 ORDER BY history.update_time LIMIT 100);
-- Clean up audit table
DELETE FROM history_audit WHERE history_audit.history_id IN (select id from history where history.user_id is null and history.hid_counter = 1 ORDER BY history.update_time LIMIT 100);
-- Cleanup galaxy_session_to_history
DELETE FROM galaxy_session_to_history WHERE galaxy_session_to_history.session_id IN (SELECT galaxy_session.id FROM galaxy_session WHERE galaxy_session.current_history_id IN (SELECT history.id FROM history WHERE history.user_id is null AND history.hid_counter = 1 ORDER BY history.update_time LIMIT 100));
-- Clean up galaxy_session
DELETE FROM galaxy_session WHERE galaxy_session.current_history_id IN (select id from history where history.user_id is null AND history.hid_counter = 1 ORDER BY history.update_time LIMIT 100);
-- Now clean up actual history table (start with 100 histories)
DELETE FROM history where id in (select id from history where history.user_id is null and history.hid_counter = 1 ORDER BY history.update_time LIMIT 100);

ROLLBACK;