age-circs.sql: ensure sitka.aged_circs is populated with xact_finish

diff --git a/maintenance/age-circs.sql b/maintenance/age-circs.sql
index 06d72b4..a5b5353 100644 (file)
--- a/maintenance/age-circs.sql
+++ b/maintenance/age-circs.sql
@@ -54,7 +54,7 @@ $$ LANGUAGE plpgsql;
 \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
 );
 
@@ -127,8 +127,8 @@ BEGIN
   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