aboutsummaryrefslogtreecommitdiffstats
path: root/migrations
diff options
context:
space:
mode:
Diffstat (limited to 'migrations')
-rw-r--r--migrations/down/001-initial.sql1
-rw-r--r--migrations/up/001-initial.sql5
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
+);