| commit | 62055f7c7c32974e85ff683729c1ab68bf79bb72 | [log] [tgz] |
|---|---|---|
| author | margaretha <margaretha@ids-mannheim.de> | Tue Apr 11 19:17:43 2017 +0200 |
| committer | margaretha <margaretha@ids-mannheim.de> | Tue Apr 11 19:17:43 2017 +0200 |
| tree | 73c9947180a284522aa54c2cdb71bec0600de48a | |
| parent | 9c0f1bec192039a5315183c85ac256257b9b7a4c [diff] [blame] |
Changed admin authentication by using database and removed SSL. Change-Id: Idca1d91aea908326771d34432a93c77032639c62
diff --git a/src/main/resources/db/mysql/mysql_schema_comp.sql b/src/main/resources/db/mysql/mysql_schema_comp.sql index 6ee11c5..44ec4de 100644 --- a/src/main/resources/db/mysql/mysql_schema_comp.sql +++ b/src/main/resources/db/mysql/mysql_schema_comp.sql
@@ -22,6 +22,13 @@ accountLink VARCHAR(100) )$$ +CREATE TABLE IF NOT EXISTS admin_users ( + id INTEGER PRIMARY KEY AUTO_INCREMENT, + user_id INTEGER NOT NULL, + foreign key (user_id) + references korap_users (id) +)$$ + CREATE TABLE IF NOT EXISTS user_details ( Id INTEGER PRIMARY KEY AUTO_INCREMENT, userID INTEGER NOT NULL UNIQUE,