From cdffcd2a32d54137de96567f0d211eda6039a9d3 Mon Sep 17 00:00:00 2001
From: LarsVomMars
Date: Sat, 20 Feb 2021 17:42:04 +0100
Subject: Multiple images
ShouldTM work
---
tables.sql | 11 +++++++++++
1 file changed, 11 insertions(+)
(limited to 'tables.sql')
diff --git a/tables.sql b/tables.sql
index c638cab..66363b6 100644
--- a/tables.sql
+++ b/tables.sql
@@ -198,3 +198,14 @@ CREATE TABLE IF NOT EXISTS secrets
CONSTRAINT `fk_user_secret` FOREIGN KEY (user_id) REFERENCES users (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8;
+
+CREATE TABLE IF NOT EXISTS profile_image_ratios
+(
+ id INTEGER PRIMARY KEY AUTO_INCREMENT,
+ question_id INTEGER NOT NULL UNIQUE,
+ x INTEGER NOT NULL,
+ y INTEGER NOT NULL,
+
+ CONSTRAINT `fk_profile_image_question` FOREIGN KEY (question_id) REFERENCES profile_questions (id)
+) ENGINE = InnoDB
+ DEFAULT CHARSET = utf8;
\ No newline at end of file
--
cgit v1.2.3