DROP TABLE IF EXISTS mixes;
DROP TABLE IF EXISTS students;
DROP TABLE IF EXISTS users;

create table users (
 id_imm INTEGER PRIMARY KEY AUTOINCREMENT,
 id INTEGER NOT NULL,
 password TEXT NOT NULL,
 flag TEXT NOT NULL
);

create table mixes (
 section_id INTEGER PRIMARY KEY AUTOINCREMENT,
 question TEXT NOT NULL,
 program TEXT NOT NULL,
 comment TEXT NOT NULL,
 answer TEXT NOT NULL,
 section TEXT NOT NULL
);

create table students (
 id INTEGER PRIMARY KEY AUTOINCREMENT,
 user_id TEXT NOT NULL,
 code TEXT NOT NULL,
 result TEXT NOT NULL,
 comment TEXT NOT NULL,
 success TEXT NOT NULL,
 section  TEXT NOT NULL,
 time
);