Add save-state API endpoint

[gamestick-pjgsapi.git] / data / schema.sql

diff --git a/data/schema.sql b/data/schema.sql
index f7cb0d6f93456b4cd8c15d85c47ee9a40e74fe00..f262974d0aaa6c1da557cec24aa4e04c08012550 100644 (file)
--- a/data/schema.sql
+++ b/data/schema.sql
@@ -41,3 +41,13 @@ CREATE TABLE leaderboards (
     created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
     updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
 ) COLLATE 'utf8mb4_general_ci';
+
+CREATE TABLE saves (
+    id INTEGER PRIMARY KEY AUTO_INCREMENT,
+    userId INTEGER NOT NULL,
+    gameId INTEGER,
+    gameState MEDIUMBLOB NOT NULL,
+
+    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
+) COLLATE 'utf8mb4_general_ci';