\echo 'table for aged circs'
CREATE TABLE sitka.aged_circs (
id BIGINT NOT NULL,
- circ_chain_tail_xact_finish TIMESTAMPTZ,
+ circ_chain_tail_xact_finish TIMESTAMPTZ NOT NULL,
delete_date DATE NOT NULL
);
END LOOP;
-- log the aging of this circ
- INSERT INTO sitka.aged_circs (id, delete_date)
- SELECT id, today FROM circs_to_age;
+ INSERT INTO sitka.aged_circs (id, circ_chain_tail_xact_finish, delete_date)
+ SELECT id, circ_chain_tail.xact_finish, today FROM circs_to_age;
-- update user circ counts
CREATE TEMPORARY TABLE usr_circ_totals AS