aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--migrations/2020-08-25-102403_add_event_table/down.sql2
-rw-r--r--migrations/2020-08-25-102403_add_event_table/up.sql8
2 files changed, 10 insertions, 0 deletions
diff --git a/migrations/2020-08-25-102403_add_event_table/down.sql b/migrations/2020-08-25-102403_add_event_table/down.sql
new file mode 100644
index 0000000..1d3e072
--- /dev/null
+++ b/migrations/2020-08-25-102403_add_event_table/down.sql
@@ -0,0 +1,2 @@
+-- Drop the event table to revert.
+DROP TABLE event;
diff --git a/migrations/2020-08-25-102403_add_event_table/up.sql b/migrations/2020-08-25-102403_add_event_table/up.sql
new file mode 100644
index 0000000..16deae0
--- /dev/null
+++ b/migrations/2020-08-25-102403_add_event_table/up.sql
@@ -0,0 +1,8 @@
+-- The event table holds information about the event.
+-- This is typically used on the main website, page titles
+-- etc.
+CREATE TABLE event (
+ id SERIAL PRIMARY KEY,
+ name varchar(64) NOT NULL,
+ description text
+)