feat: access tokens

1 files changed, 7 insertions, 0 deletions

diff --git a/database.sql b/database.sql
index 27962fa..a339619 100644
--- a/database.sql
+++ b/database.sql
@@ -3,4 +3,11 @@ CREATE TABLE IF NOT EXISTS users (
     username TEXT NOT NULL UNIQUE,
     `password` TEXT NOT NULL,
     joined_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
+);
+
+CREATE TABLE IF NOT EXISTS tokens (
+    id BIGINT PRIMARY KEY AUTO_INCREMENT,
+    user_id BIGINT NOT NULL REFERENCES users(id) ON DELETE CASCADE,
+    `hash` TEXT NOT NULL UNIQUE,
+    expires_at TIMESTAMP NOT NULL
 );
\ No newline at end of file