From 2eff2deb98280aa61241e06163c87155911bbfae Mon Sep 17 00:00:00 2001
From: LarsVomMars
Date: Thu, 28 Jan 2021 12:53:19 +0100
Subject: TEACHER PREDICTION HAHAHA

---
 tables.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)

(limited to 'tables.sql')

diff --git a/tables.sql b/tables.sql
index 99dcf20..5678eae 100644
--- a/tables.sql
+++ b/tables.sql
@@ -176,3 +176,14 @@ CREATE TABLE IF NOT EXISTS profile_char
     CONSTRAINT `fk_char_user2` FOREIGN KEY (user_id) REFERENCES users (id)
 ) ENGINE = InnoDB
   DEFAULT CHARSET = utf8;
+
+CREATE TABLE IF NOT EXISTS teacher_prediction
+(
+  id INTEGER PRIMARY KEY AUTO_INCREMENT,
+  user_id INTEGER NOT NULL UNIQUE,
+  teacher_id INTEGER NOT NULL,
+
+  CONSTRAINT `fk_teacher_user` FOREIGN KEY (user_id) REFERENCES users (id),
+  CONSTRAINT `fk_teacher_teacher` FOREIGN KEY (teacher_id) REFERENCES users (id)
+) ENGINE = InnoDB
+  DEFAULT CHARSET = utf8;
\ No newline at end of file
-- 
cgit v1.2.3

