From b300ad869f424cdd26bcfc78635a27656836ca96 Mon Sep 17 00:00:00 2001
From: GrailFinder <wohilas@gmail.com>
Date: Wed, 12 Jun 2024 09:13:05 +0300
Subject: Feat: add cron and defaults table

---
 internal/database/migrations/002_defaults.up.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 internal/database/migrations/002_defaults.up.sql

(limited to 'internal/database/migrations/002_defaults.up.sql')

diff --git a/internal/database/migrations/002_defaults.up.sql b/internal/database/migrations/002_defaults.up.sql
new file mode 100644
index 0000000..4bf42b7
--- /dev/null
+++ b/internal/database/migrations/002_defaults.up.sql
@@ -0,0 +1,11 @@
+BEGIN TRANSACTION;
+
+CREATE TABLE IF NOT EXISTS defaults (
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    key TEXT UNIQUE NOT NULL,
+    value TEXT NOT NULL,
+    description TEXT NOT NULL DEFAULT '',
+    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
+
+COMMIT;
-- 
cgit v1.2.3

