about summary refs log tree commit diff
path: root/server/migrations/2021-01-12-171443_create_links
diff options
context:
space:
mode:
authorMelonai <einebeere@gmail.com>2021-01-13 22:37:31 +0100
committerMelonai <einebeere@gmail.com>2021-01-13 22:37:31 +0100
commit5b6ed8cfb245f7f9991f5fc192b8c9215f0ecdc1 (patch)
treec4b9ef58c708900d2a88fa5e8790629d415e2b75 /server/migrations/2021-01-12-171443_create_links
parent6e8a1117ddef390453d6b695c301d7f4d219f947 (diff)
downloadshorest-5b6ed8cfb245f7f9991f5fc192b8c9215f0ecdc1.tar.zst
shorest-5b6ed8cfb245f7f9991f5fc192b8c9215f0ecdc1.zip
Created diesel migrations
Diffstat (limited to 'server/migrations/2021-01-12-171443_create_links')
-rw-r--r--server/migrations/2021-01-12-171443_create_links/down.sql1
-rw-r--r--server/migrations/2021-01-12-171443_create_links/up.sql4
2 files changed, 5 insertions, 0 deletions
diff --git a/server/migrations/2021-01-12-171443_create_links/down.sql b/server/migrations/2021-01-12-171443_create_links/down.sql
new file mode 100644
index 0000000..72bbc99
--- /dev/null
+++ b/server/migrations/2021-01-12-171443_create_links/down.sql
@@ -0,0 +1 @@
+DROP TABLE links;
diff --git a/server/migrations/2021-01-12-171443_create_links/up.sql b/server/migrations/2021-01-12-171443_create_links/up.sql
new file mode 100644
index 0000000..17e3f92
--- /dev/null
+++ b/server/migrations/2021-01-12-171443_create_links/up.sql
@@ -0,0 +1,4 @@
+CREATE TABLE links (
+    hash CHAR(3) PRIMARY KEY,
+    url VARCHAR(2048) NOT NULL
+);