From 6831948476003527e5ac7eec0f1efa279bac2ac3 Mon Sep 17 00:00:00 2001 From: Jan Tuomi Date: Mon, 7 Feb 2022 14:40:02 +0200 Subject: Add db conn --- migrations/down/001-initial.sql | 1 + migrations/up/001-initial.sql | 5 +++++ 2 files changed, 6 insertions(+) create mode 100644 migrations/down/001-initial.sql create mode 100644 migrations/up/001-initial.sql (limited to 'migrations') 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 +); -- cgit v1.3