From 0157900ccb8d03bf8532d7e9c04b926f7ea63853 Mon Sep 17 00:00:00 2001
From: Alessandro Iezzi <aiezzi@alessandroiezzi.it>
Date: Fri, 12 May 2023 15:37:26 +0200
Subject: Initial commit

---
 sql/0001_init.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 sql/0001_init.sql

(limited to 'sql/0001_init.sql')

diff --git a/sql/0001_init.sql b/sql/0001_init.sql
new file mode 100644
index 0000000..920f2b4
--- /dev/null
+++ b/sql/0001_init.sql
@@ -0,0 +1,12 @@
+CREATE TABLE timelog (
+	id          BIGSERIAL NOT NULL PRIMARY KEY,
+	_start      TIMESTAMP,
+	_end        TIMESTAMP,
+	description TEXT
+);
+
+CREATE TABLE turnstile (
+	id        BIGSERIAL NOT NULL PRIMARY KEY,
+	_datetime TIMESTAMP,
+	direction VARCHAR(4)
+);
-- 
cgit v1.2.3

