BEGIN;
SET ROLE capability_role;
CREATE TABLE IF NOT EXISTS capability.cognitive_binding_revision_heads (
  binding_id TEXT PRIMARY KEY,
  revision BIGINT NOT NULL CHECK (revision > 0),
  updated_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP
);
INSERT INTO capability.cognitive_binding_revision_heads (binding_id,revision)
SELECT DISTINCT ON (binding_id) binding_id,revision
FROM capability.cognitive_bindings
ORDER BY binding_id,recorded_at DESC
ON CONFLICT DO NOTHING;
RESET ROLE;
COMMIT;