diff options
| author | Jan Tuomi <jans.tuomi@gmail.com> | 2022-02-07 14:40:02 +0200 |
|---|---|---|
| committer | Jan Tuomi <jans.tuomi@gmail.com> | 2022-02-07 14:40:02 +0200 |
| commit | 6831948476003527e5ac7eec0f1efa279bac2ac3 (patch) | |
| tree | a79887dbbab88b5f74f95a854880faf13b1f6c76 /migrations | |
| parent | 7a0f65385189cc6e888027d5f286794e07a6fe2a (diff) | |
Add db conn
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/down/001-initial.sql | 1 | ||||
| -rw-r--r-- | migrations/up/001-initial.sql | 5 |
2 files changed, 6 insertions, 0 deletions
diff --git a/migrations/down/001-initial.sql b/migrations/down/001-initial.sql new file mode 100644 index 0000000..4d53211 --- /dev/null +++ b/migrations/down/001-initial.sql @@ -0,0 +1 @@ +DROP TABLE examples; diff --git a/migrations/up/001-initial.sql b/migrations/up/001-initial.sql new file mode 100644 index 0000000..1a05754 --- /dev/null +++ b/migrations/up/001-initial.sql @@ -0,0 +1,5 @@ +CREATE TABLE examples ( + id uuid PRIMARY KEY DEFAULT gen_random_uuid(), + title VARCHAR(40), + content TEXT +); |