From 0db5748eefe59b068406e399d62ee938877e9bbd Mon Sep 17 00:00:00 2001
From: Marvin Borner
Date: Thu, 1 Oct 2020 15:26:39 +0200
Subject: Insert

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

diff --git a/tables.sql b/tables.sql
index 39021f1..a8201ab 100644
--- a/tables.sql
+++ b/tables.sql
@@ -15,19 +15,19 @@ DROP TABLE IF EXISTS class;
 
 CREATE TABLE IF NOT EXISTS types(
     id INTEGER PRIMARY KEY AUTO_INCREMENT,
-    name VARCHAR(255) NOT NULL
+    name VARCHAR(255) NOT NULL UNIQUE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS class(
     id INTEGER PRIMARY KEY AUTO_INCREMENT,
-    name VARCHAR(255) NOT NULL
+    name VARCHAR(255) NOT NULL UNIQUE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS users(
     id INTEGER PRIMARY KEY AUTO_INCREMENT,
     username VARCHAR(255) NOT NULL,
     name VARCHAR(255) NOT NULL,
-    middlename VARCHAR(255) NOT NULL,
+    middlename VARCHAR(255) DEFAULT NULL,
     surname VARCHAR(255) NOT NULL,
     password VARCHAR(255) NOT NULL,
     class_id INTEGER NOT NULL,
@@ -37,3 +37,11 @@ CREATE TABLE IF NOT EXISTS users(
     CONSTRAINT `fk_class_user` FOREIGN KEY (class_id) REFERENCES class (id),
     CONSTRAINT `fk_type_user` FOREIGN KEY (type_id) REFERENCES types (id)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+INSERT INTO types VALUES (1, "teacher"), (2, "pupil");
+INSERT INTO class VALUES
+    (1, "TGM13.1"),
+    (2, "TGM13.2"),
+    (3, "TGTM13.1"),
+    (4, "TGI13.1"),
+    (5, "TGI13.2");
-- 
cgit v1.2.3