CREATE TABLE schools(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(150)
);

CREATE TABLE users(
id INT AUTO_INCREMENT PRIMARY KEY,
school_id INT,
name VARCHAR(100),
username VARCHAR(100),
password VARCHAR(255),
role VARCHAR(30)
);

CREATE TABLE modules(
id INT AUTO_INCREMENT PRIMARY KEY,
school_id INT,
user_id INT,
title VARCHAR(200),
docx VARCHAR(255),
pdf VARCHAR(255)
);