v.1.0

account_database/schema.sql

@@ -2,5 +2,14 @@ CREATE TABLE IF NOT EXISTS users (
     user_id SERIAL PRIMARY KEY,
     email VARCHAR(255) UNIQUE NOT NULL,
     password_hash VARCHAR(255) NOT NULL,
-    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
+    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    reset_token VARCHAR(100) UNIQUE,
+    reset_token_expiry TIMESTAMP     
+);
+
+CREATE TABLE IF NOT EXISTS account_events (
+    user_id INT NOT NULL,
+    event_id INT,
+    PRIMARY KEY (user_id, event_id),
+    FOREIGN KEY (user_id) REFERENCES users(user_id)
 );
\ No newline at end of file