Initial commit

2 files changed, 25 insertions, 0 deletions

diff --git a/pkg/database/migrations/0001_initial.sql b/pkg/database/migrations/0001_initial.sql
new file mode 100644
index 0000000..5e69229
--- /dev/null
+++ b/pkg/database/migrations/0001_initial.sql
@@ -0,0 +1,19 @@
+-- +goose Up
+
+CREATE TABLE entries (
+  id          integer PRIMARY KEY,
+  title       text    NOT NULL,
+  kind        integer NOT NULL,
+  url         text    NOT NULL,
+  description text    NOT NULL,
+  timestamp   text    NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  FOREIGN KEY(kind) REFERENCES kinds(id)
+) STRICT;
+
+CREATE TABLE kinds (
+  id    integer PRIMARY KEY,
+  name  text    NOT NULL,
+  emoji text    NOT NULL
+) STRICT;
+
+CREATE INDEX idx_kinds_name ON kinds(name);
diff --git a/pkg/database/migrations/0002_seed.sql b/pkg/database/migrations/0002_seed.sql
new file mode 100644
index 0000000..8be0bba
--- /dev/null
+++ b/pkg/database/migrations/0002_seed.sql
@@ -0,0 +1,6 @@
+-- +goose Up
+
+INSERT INTO kinds (name, emoji)
+VALUES
+  ("read", "👀"),
+  ("starred", "⭐");