From 69c5423f7954b641109166e03ad0ab174b3d55c6 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Sat, 2 Sep 2023 11:09:42 +0300
Subject: feat: testing logging system (#55)

Former-commit-id: d8c5fda30ab08b42218aead1febdf83200948763
---
 backend/database/init.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)

(limited to 'backend/database')

diff --git a/backend/database/init.sql b/backend/database/init.sql
index 25de872..abace5c 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -139,3 +139,13 @@ CREATE TABLE countries (
   country_name TEXT NOT NULL,
   PRIMARY KEY (country_code)
 );
+
+CREATE TABLE logs (
+  id SERIAL,
+  user_id TEXT NOT NULL,
+  type TEXT NOT NULL,
+  description TEXT NOT NULL,
+  date TIMESTAMP NOT NULL DEFAULT now(),
+  PRIMARY KEY (id),
+  FOREIGN KEY (user_id) REFERENCES users(steam_id)
+);
\ No newline at end of file
-- 
cgit v1.2.3