-- backend/includes/setup.sql
-- cPanel → phpMyAdmin → আপনার database সিলেক্ট করুন → SQL ট্যাব → এটা paste করে Go চাপুন

CREATE TABLE IF NOT EXISTS donors (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    blood VARCHAR(5) NOT NULL,
    union_name VARCHAR(100) NOT NULL,
    phone VARCHAR(20) NOT NULL,
    last_donation DATE DEFAULT NULL,
    available TINYINT(1) DEFAULT 1,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS requests (
    id INT AUTO_INCREMENT PRIMARY KEY,
    patient VARCHAR(100) NOT NULL,
    blood VARCHAR(5) NOT NULL,
    bags INT DEFAULT 1,
    hospital VARCHAR(200) NOT NULL,
    phone VARCHAR(20) NOT NULL,
    req_date DATE NOT NULL,
    urgent TINYINT(1) DEFAULT 1,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS admins (
    id INT AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(100) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ডিফল্ট অ্যাডমিন তৈরি (password: Admin@1234 — পরে বদলান)
INSERT INTO admins (email, password)
VALUES ('admin@ulipur.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi')
ON DUPLICATE KEY UPDATE id=id;