Script SQL complet pour Namecheap / phpMyAdmin

-- BASE DE DONNEES : candidats_db
-- HEBERGEMENT : Namecheap + phpMyAdmin

CREATE DATABASE IF NOT EXISTS candidats_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE candidats_db;

CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL,
    phone VARCHAR(30),
    role ENUM('Admin','Candidat') DEFAULT 'Candidat',
    approved TINYINT(1) DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT IGNORE INTO users (username, password, name, email, role, approved)
VALUES ('admin', 'admin123', 'Administrateur', 'admin@gestion.com', 'Admin', 1);

CREATE TABLE IF NOT EXISTS candidats (
    id VARCHAR(20) PRIMARY KEY,
    prenom VARCHAR(100) NOT NULL,
    nom VARCHAR(100) NOT NULL,
    postnom VARCHAR(100),
    date_naissance DATE NOT NULL,
    sexe ENUM('Masculin','Feminin') NOT NULL,
    etat_civil ENUM('Celibataire','Marie(e)','Divorce(e)','Veuf/Veuve') NOT NULL,
    province VARCHAR(100) NOT NULL,
    fonction VARCHAR(100) NOT NULL,
    profession VARCHAR(100) NOT NULL,
    nom_mentor VARCHAR(100),
    nom_coordonnateur VARCHAR(100),
    nom_conjoint VARCHAR(200),
    adresse TEXT NOT NULL,
    telephone VARCHAR(30) NOT NULL,
    email VARCHAR(100),
    montant DECIMAL(10,2) NOT NULL DEFAULT 0.00,
    date_paiement DATE NOT NULL,
    observation TEXT,
    created_by VARCHAR(50),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;