-- Database table creation script for Trauma, Language, and Memory Webinar (March 2026)
-- IMPORTANT: You must first create the database 'akaimh_survey0326' through your hosting control panel (cPanel)
-- Then select that database in phpMyAdmin before running this script

USE akaimh_survey0326;

CREATE TABLE IF NOT EXISTS webinar_feedback (
    id INT AUTO_INCREMENT PRIMARY KEY,
    fullname VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    roles TEXT NOT NULL,
    q4 TINYINT NOT NULL,
    q5 TINYINT NOT NULL,
    q6 TINYINT NOT NULL,
    q7 TINYINT NOT NULL,
    q8 TINYINT NOT NULL,
    q9 TINYINT NOT NULL,
    q10 TINYINT NOT NULL,
    q11 TINYINT NOT NULL,
    q12 TINYINT NOT NULL,
    q13 TINYINT NOT NULL,
    q14 TEXT,
    submitted_at DATETIME NOT NULL,
    INDEX idx_email (email),
    INDEX idx_submitted (submitted_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;