From 9f7b5a836c8aeb83b66e0b41b8533443b5e99380 Mon Sep 17 00:00:00 2001
From: Arda Serdar Pektezol <1669855+pektezol@users.noreply.github.com>
Date: Sun, 20 Aug 2023 12:36:34 +0300
Subject: fix: change map history from timestamp to date

Former-commit-id: 8a46950e919891f380dda5502e40434383c91245
---
 backend/database/init.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'backend/database/init.sql')

diff --git a/backend/database/init.sql b/backend/database/init.sql
index 50e7c15..11d4944 100644
--- a/backend/database/init.sql
+++ b/backend/database/init.sql
@@ -59,7 +59,7 @@ CREATE TABLE map_history (
   category_id SMALLINT NOT NULL,
   user_name TEXT NOT NULL,
   score_count SMALLINT NOT NULL,
-  record_date TIMESTAMP NOT NULL,
+  record_date DATE NOT NULL,
   PRIMARY KEY (id),
   FOREIGN KEY (category_id) REFERENCES categories(id),
   FOREIGN KEY (map_id) REFERENCES maps(id),
-- 
cgit v1.2.3