15 lines
495 B
PL/PgSQL
15 lines
495 B
PL/PgSQL
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;
|