-- Adds Address/City/State to the customers table (POS "Add Customer" quick-add
-- form and the Customers admin page). Only needed if your `customers` table
-- predates this change — a fresh `mysql -u root -p < schema.sql` import
-- already includes these columns.
--
-- Usage: mysql -u root -p petzy_pos < add_customer_address_fields.sql

ALTER TABLE customers
    ADD COLUMN address VARCHAR(255) NULL AFTER notes,
    ADD COLUMN city VARCHAR(100) NULL AFTER address,
    ADD COLUMN state VARCHAR(100) NULL AFTER city;