-- Add street address column
ALTER TABLE clients ADD COLUMN street_address VARCHAR(255) DEFAULT NULL AFTER country;

-- Add state/province column
ALTER TABLE clients ADD COLUMN state VARCHAR(100) DEFAULT NULL AFTER street_address;

-- Add zip/postal code column
ALTER TABLE clients ADD COLUMN zip VARCHAR(20) DEFAULT NULL AFTER state;

-- Add open balance amount column
ALTER TABLE clients ADD COLUMN open_balance DECIMAL(10,2) DEFAULT 0.00 AFTER zip;

-- Add attachments count column
ALTER TABLE clients ADD COLUMN attachments INT(11) DEFAULT 0 AFTER open_balance;

-- Create indexes for new columns
CREATE INDEX idx_street_address ON clients(street_address);
CREATE INDEX idx_state ON clients(state);
CREATE INDEX idx_zip ON clients(zip);
CREATE INDEX idx_open_balance ON clients(open_balance);
