CREATE TABLE IF NOT EXISTS utility_providers ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, 
ame_en VARCHAR(100) NOT NULL, 
ame_bn VARCHAR(100) NOT NULL, category VARCHAR(50) NOT NULL, provider_code VARCHAR(50) NOT NULL UNIQUE, logo_url VARCHAR(255) NULL, icon_name VARCHAR(50) NULL, instructions_bn TEXT NULL, is_active TINYINT(1) DEFAULT 1, display_order INT UNSIGNED DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;