GWR72QZ0

1CREATE TABLE IF NOT EXISTS admin_login (
2    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
3    user_name VARCHAR(20) NOT NULL,
4    password VARCHAR(40) NOT NULL
5);
6
7INSERT INTO admin_login (user_name, password) VALUES
8('admin', SHA1('password')) ;
9
10CREATE TABLE IF NOT EXISTS classes (
11    class_id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
12    class_name VARCHAR(30) NOT NULL,
13    subject_name VARCHAR(30) NOT NULL,
14    meeting_dates VARCHAR(900) NOT NULL,
15    student_ids VARCHAR(900) NOT NULL,
16    teacher_id VARCHAR(50) NOT NULL,
17    completed BOOL,
18    FOREIGN KEY (teacher_id)
19        REFERENCES teachers (teacher_id)
20); 
21
22CREATE TABLE IF NOT EXISTS students (
23    student_id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
24    first_name CHAR(30) NOT NULL,
25    last_name CHAR(30) NOT NULL,
26    profile_picture LONGBLOB NOT NULL
27);
28
29CREATE TABLE IF NOT EXISTS teachers (
30    teacher_id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
31    first_name CHAR(30) NOT NULL,
32    last_name CHAR(30) NOT NULL,
33    profile_picture LONGBLOB NOT NULL,
34    username VARCHAR(20) NOT NULL,
35    password VARCHAR(40) NOT NULL
36);
37
38CREATE TABLE IF NOT EXISTS attendance (
39    id INT PRIMARY KEY AUTO_INCREMENT,
40    student_id INT REFERENCES students (student_id),
41    class_id INT,
42    attendence_outcome CHAR,
43    date CHAR
44);