SQL DataBase

CREATE TABLE IF NOT EXISTS users (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
login VARCHAR(32) NOT NULL,
password VARCHAR(32) NOT NULL,
firstname VARCHAR(50) NOT NULL,
lastname VARCHAR(50) NOT NULL,
midname VARCHAR(50),
phone INT(32),
whois INT(15)
);
CREATE TABLE IF NOT EXISTS ratings (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
DATE DATE NOT NULL,
rate INT(12),
uID INT(32),
tID INT(32),
lesson VARCHAR(50)
);
CREATE TABLE IF NOT EXISTS qrkeys (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
KEY VARCHAR(50) NOT NULL,
creationDate DATETIME,
dayExistance INT(5),
isExpired BOOLEAN
);
CREATE TABLE IF NOT EXISTS messages (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
uID INT(32),
cID INT(32),
message TEXT,
attachments TEXT,
senttime DATETIME
);
CREATE TABLE IF NOT EXISTS students_chats (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
gID INT(32),
name VARCHAR(50) NOT NULL,
uID INT(32)
);
CREATE TABLE IF NOT EXISTS teachers_chats (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
cID INT(32),
name VARCHAR(50) NOT NULL,
uID INT(32)
);
CREATE TABLE IF NOT EXISTS admins_chats (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
aID INT(32),
name VARCHAR(50) NOT NULL,
uID INT(32)
);
CREATE TABLE IF NOT EXISTS chat_members (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
uID INT(32),
cID INT(32)
);
CREATE TABLE IF NOT EXISTS cathedra (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(70) NOT NULL,
descript TEXT,
mainuID INT(32) NOT NULL,
phone INT(32) NOT NULL
);
CREATE TABLE IF NOT EXISTS faculty (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(70) NOT NULL,
mainInfo TEXT,
mainuID INT(32),
phone INT(32)
);
CREATE TABLE IF NOT EXISTS coworkers (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
uID INT(32),
job VARCHAR(50) NOT NULL,
isPublic BOOLEAN,
descript VARCHAR(144),
isPhoneView BOOLEAN
);
CREATE TABLE IF NOT EXISTS groups (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(70) NOT NULL,
facID INT(32),
mainuID INT(32)
);
CREATE TABLE IF NOT EXISTS teaching (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
uID INT(32),
cathID INT(32),
descript VARCHAR(144)
);
CREATE TABLE IF NOT EXISTS admins (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
uID INT(32),
whois INT(32),
descript VARCHAR(144),
isPresidential BOOLEAN
);
CREATE TABLE IF NOT EXISTS times (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
halfs INT(5),
timeStart TIME,
brakeTime TIME,
halfTime TIME
);
CREATE TABLE IF NOT EXISTS lesson (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(70) NOT NULL,
abb VARCHAR(20)
);
CREATE TABLE IF NOT EXISTS lessons (
id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
lID INT(32),
timeID INT(32),
gID INT(32),
teacherID INT(32),
descript VARCHAR(50)
);