Update Clients Table Structure

Executing SQL statements to update table structure...

Column already exists, skipping: -- Add street address column ALTER TABLE clients ADD COLUMN street_address VARCHAR(255) DEFAULT NULL AFTER country

Column already exists, skipping: -- Add state/province column ALTER TABLE clients ADD COLUMN state VARCHAR(100) DEFAULT NULL AFTER street_address

Column already exists, skipping: -- Add zip/postal code column ALTER TABLE clients ADD COLUMN zip VARCHAR(20) DEFAULT NULL AFTER state

Column already exists, skipping: -- Add open balance amount column ALTER TABLE clients ADD COLUMN open_balance DECIMAL(10,2) DEFAULT 0.00 AFTER zip

Column already exists, skipping: -- Add attachments count column ALTER TABLE clients ADD COLUMN attachments INT(11) DEFAULT 0 AFTER open_balance

Error: SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_street_address'