-- Customers tablosuna profil sayfası için gerekli sütunları ekle
ALTER TABLE `customers` 
ADD COLUMN `address` TEXT NULL AFTER `phone`,
ADD COLUMN `city` VARCHAR(50) NULL AFTER `address`,
ADD COLUMN `country` VARCHAR(50) NULL DEFAULT 'Turkey' AFTER `city`,
ADD COLUMN `postal_code` VARCHAR(20) NULL AFTER `country`,
ADD COLUMN `company_name` VARCHAR(100) NULL AFTER `postal_code`,
ADD COLUMN `tax_number` VARCHAR(20) NULL AFTER `company_name`,
ADD COLUMN `tax_office` VARCHAR(100) NULL AFTER `tax_number`,
ADD COLUMN `billing_address` TEXT NULL AFTER `tax_office`; 