1 files changed, 12 insertions, 0 deletions
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)
+);