An-Nida English Hub

-- Database: annidaku_lms (SDIT An-Nida Kunciran Jaya)
CREATE TABLE IF NOT EXISTS users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  full_name VARCHAR(100) NOT NULL,
  class_name VARCHAR(30) NOT NULL,
  role ENUM('student','teacher') DEFAULT 'student',
  stars INT DEFAULT 100,
  best_score INT DEFAULT 0
);

CREATE TABLE IF NOT EXISTS vocabularies (
  id INT AUTO_INCREMENT PRIMARY KEY,
  word VARCHAR(80) NOT NULL,
  phonetic VARCHAR(80) DEFAULT '',
  meaning VARCHAR(120) NOT NULL,
  category VARCHAR(50) NOT NULL,
  grade_level VARCHAR(20) DEFAULT 'lower',
  emoji VARCHAR(16) DEFAULT '🌟',
  example_sentence TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS quizzes (
  id INT AUTO_INCREMENT PRIMARY KEY,
  level_name VARCHAR(50) NOT NULL,
  question TEXT NOT NULL,
  option_a VARCHAR(150) NOT NULL,
  option_b VARCHAR(150) NOT NULL,
  option_c VARCHAR(150) NOT NULL,
  option_d VARCHAR(150) NOT NULL,
  correct_index TINYINT NOT NULL,
  explanation TEXT NOT NULL
);