0qpHKMbV

1CREATE TABLE IF NOT EXISTS users (
2id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
3login VARCHAR(32) NOT NULL,
4password VARCHAR(32) NOT NULL,
5firstname VARCHAR(50) NOT NULL,
6lastname VARCHAR(50) NOT NULL,
7midname VARCHAR(50),
8phone INT(32),
9whois INT(15)
10);
11CREATE TABLE IF NOT EXISTS keys (
12id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
13key VARCHAR(50) NOT NULL,
14creationDate DATETIME,
15dayExistance INT(5),
16isExpired BOOLEAN
17);
18CREATE TABLE IF NOT EXISTS messages (
19id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
20uID INT(32),
21cID INT(32),
22message TEXT,
23attachments TEXT,
24senttime DATETIME
25);
26CREATE TABLE IF NOT EXISTS students_chats (
27id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
28gID INT(32),
29name VARCHAR(50) NOT NULL,
30uID INT(32)
31);
32CREATE TABLE IF NOT EXISTS teachers_chats (
33id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
34cID INT(32),
35name VARCHAR(50) NOT NULL,
36uID INT(32)
37);
38CREATE TABLE IF NOT EXISTS admins_chats (
39id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
40aID INT(32),
41name VARCHAR(50) NOT NULL,
42uID INT(32)
43);
44CREATE TABLE IF NOT EXISTS chat_members (
45id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
46uID INT(32),
47cID INT(32)
48);
49CREATE TABLE IF NOT EXISTS cathedra (
50id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
51name VARCHAR(70) NOT NULL,
52mainuID INT(32) NOT NULL,
53phone INT(32) NOT NULL
54);
55CREATE TABLE IF NOT EXISTS faculty (
56id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
57name VARCHAR(70) NOT NULL,
58mainInfo TEXT,
59mainuID INT(32),
60phone INT(32)
61);
62CREATE TABLE IF NOT EXISTS coworkers (
63id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
64uID INT(32),
65job VARCHAR(50) NOT NULL,
66isPublic BOOLEAN,
67isPhoneView BOOLEAN
68);
69CREATE TABLE IF NOT EXISTS groups (
70id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
71name VARCHAR(70) NOT NULL,
72facID INT(32),
73mainuID INT(32)
74);
75CREATE TABLE IF NOT EXISTS teaching (
76id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
77uID INT(32),
78cathID INT(32)
79);
80CREATE TABLE IF NOT EXISTS admins (
81id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
82uID INT(32),
83whois INT(32),
84isPresidential BOOLEAN
85);
86CREATE TABLE IF NOT EXISTS times (
87id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
88halfs INT(5),
89timeStart TIME,
90brakeTime TIME,
91halfTime TIME
92);
93CREATE TABLE IF NOT EXISTS lessons (
94id INT(32) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
95name VARCHAR (70) NOT NULL,
96timeID INT(32),
97teacherID INT(32)
98);