-- Migration: Add bank_name to payments table
-- Run this after the initial schema

USE ebilit_stat;

-- Add bank_name column to payments table
ALTER TABLE payments 
ADD COLUMN bank_name VARCHAR(50) NOT NULL DEFAULT '' AFTER account_number;