diff options
Diffstat (limited to 'pkg/database/migrations')
| -rw-r--r-- | pkg/database/migrations/0003_unique_url.sql | 3 | ||||
| -rw-r--r-- | pkg/database/migrations/0004_unread_kind.sql | 5 |
2 files changed, 8 insertions, 0 deletions
diff --git a/pkg/database/migrations/0003_unique_url.sql b/pkg/database/migrations/0003_unique_url.sql new file mode 100644 index 0000000..8be3293 --- /dev/null +++ b/pkg/database/migrations/0003_unique_url.sql @@ -0,0 +1,3 @@ +-- +goose Up + +CREATE UNIQUE INDEX ux_entries_url ON entries(url); diff --git a/pkg/database/migrations/0004_unread_kind.sql b/pkg/database/migrations/0004_unread_kind.sql new file mode 100644 index 0000000..e583050 --- /dev/null +++ b/pkg/database/migrations/0004_unread_kind.sql @@ -0,0 +1,5 @@ +-- +goose Up + +INSERT INTO kinds (name, emoji) +VALUES + ("unread", "📚"); |