-- Prestige Barbershop v3.1 - alternatif upgrade manual
-- Disarankan menggunakan upgrade_v3_1.php agar migrasi data lama berjalan otomatis.
CREATE TABLE IF NOT EXISTS barber_staff (
 id INT AUTO_INCREMENT PRIMARY KEY, staff_code VARCHAR(40) NOT NULL UNIQUE, name VARCHAR(150) NOT NULL,
 phone VARCHAR(40) NULL,email VARCHAR(150) NULL,address TEXT NULL,specialty VARCHAR(150) NULL,join_date DATE NULL,
 employment_status ENUM('permanent','contract','freelance') NOT NULL DEFAULT 'permanent',
 bonus_type ENUM('service','percentage','fixed') NOT NULL DEFAULT 'service', bonus_value DECIMAL(15,2) NOT NULL DEFAULT 0,
 notes TEXT NULL,photo VARCHAR(255) NULL,is_active TINYINT(1) NOT NULL DEFAULT 1,created_by INT NULL,
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 FOREIGN KEY(created_by) REFERENCES users(id) ON DELETE SET NULL,INDEX idx_barber_staff_active(is_active,name)
) ENGINE=InnoDB;
-- Untuk database v3.0, gunakan upgrade_v3_1.php untuk menambah kolom/FK hanya bila belum tersedia.