-- 60_schema_migrations_table.sql
-- Banking Pattern Pack — PostgreSQL
-- Purpose: Schema migrations tracking table.
-- Context: Retail bank example with customers, accounts, transactions, cards, loans.
-- Date: 2025-08-18
-- Notes:
--   * Safe to read; run on a development DB.
--   * Requires: CREATE privileges; some files may need superuser for extensions.
--   * Search path set to 'bank' schema for clarity.

-- Track migrations
CREATE TABLE IF NOT EXISTS bank.schema_migrations (
  version TEXT PRIMARY KEY,
  applied_at TIMESTAMPTZ DEFAULT now()
);
-- INSERT INTO bank.schema_migrations(version) VALUES ('2025-08-18_init');
