Add user keys to database

Next step is to generate authorized_keys files for git server
based on keys.

1 files changed, 13 insertions, 0 deletions

diff --git a/server/migrations/1_initial_eyeballs.sql b/server/migrations/1_initial_eyeballs.sql
index 3f31781..728c329 100644
--- a/server/migrations/1_initial_eyeballs.sql
+++ b/server/migrations/1_initial_eyeballs.sql
@@ -69,3 +69,16 @@ CREATE TABLE IF NOT EXISTS review_users (
          ON DELETE CASCADE
          ON UPDATE RESTRICT
 );
+
+CREATE TABLE IF NOT EXISTS user_keys (
+       id BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
+       user VARCHAR(128) NOT NULL,
+       kind VARCHAR(128) NOT NULL,
+       data VARCHAR(8192) NOT NULL,
+       comment VARCHAR(1024) NOT NULL,
+
+       CONSTRAINT `fk_user_keys_user`
+         FOREIGN KEY (user) REFERENCES users (id)
+         ON DELETE CASCADE
+         ON UPDATE RESTRICT
+);