CREATE TABLE users (
 id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 username VARCHAR(50) NOT NULL UNIQUE,
 password_hash VARCHAR(255) NOT NULL,
 display_name VARCHAR(100) NOT NULL,
 role ENUM('student','viewer') NOT NULL DEFAULT 'viewer',
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE activities (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 activity_date DATE NOT NULL,
 start_time TIME NOT NULL,
 end_time TIME NOT NULL,
 subject VARCHAR(100) DEFAULT '',
 title VARCHAR(180) NOT NULL,
 type ENUM('study','class','daily') NOT NULL DEFAULT 'study',
 status ENUM('planned','done') NOT NULL DEFAULT 'planned',
 description TEXT,
 created_by INT UNSIGNED NOT NULL,
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 INDEX(activity_date),
 CONSTRAINT fk_activity_user FOREIGN KEY(created_by) REFERENCES users(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE notes (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 from_user_id INT UNSIGNED NOT NULL,
 text TEXT NOT NULL,
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 INDEX(created_at),
 CONSTRAINT fk_note_user FOREIGN KEY(from_user_id) REFERENCES users(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- بعد از Import، با setup.php حساب‌ها را ایجاد کنید.