-- Prestige Barbershop Professional v3.5
-- Untuk shared hosting/cPanel: jalankan pada database aplikasi yang SUDAH dipilih.
-- Tidak ada CREATE DATABASE / USE.
CREATE TABLE IF NOT EXISTS member_levels (
 id INT AUTO_INCREMENT PRIMARY KEY, code VARCHAR(40) NOT NULL UNIQUE, name VARCHAR(80) NOT NULL UNIQUE,
 sort_order INT NOT NULL DEFAULT 0, card_color VARCHAR(20) NOT NULL DEFAULT '#d4af37', discount_percent DECIMAL(5,2) NOT NULL DEFAULT 0,
 criteria_mode ENUM('all','any') NOT NULL DEFAULT 'all', min_total_spend DECIMAL(15,2) NOT NULL DEFAULT 0,
 min_transactions INT NOT NULL DEFAULT 0, min_visit_days INT NOT NULL DEFAULT 0, min_points INT NOT NULL DEFAULT 0,
 min_membership_days INT NOT NULL DEFAULT 0, auto_upgrade TINYINT(1) NOT NULL DEFAULT 1, is_active TINYINT(1) NOT NULL DEFAULT 1,
 description VARCHAR(255) NULL, created_by INT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX idx_member_level_order(is_active,sort_order)
) ENGINE=InnoDB;
-- Untuk upgrade paling aman gunakan upgrade_v3_5.php karena script web memeriksa kolom sebelum ALTER TABLE.