summaryrefslogtreecommitdiff
path: root/migrations/2020-02-05-020613_raw_data_entry
diff options
context:
space:
mode:
authorKjetil Orbekk <kjetil.orbekk@gmail.com>2020-02-05 22:26:37 -0500
committerKjetil Orbekk <kjetil.orbekk@gmail.com>2020-02-05 22:26:37 -0500
commitcbe2ff86f1a6873b88e314011ee64b6c25f3359c (patch)
tree03f20093fd59edccb9dcafd1dbb7d1d65fd96c02 /migrations/2020-02-05-020613_raw_data_entry
parent97b82520aacacbe600c8918b26b5b29b8d47d4d1 (diff)
Extract basics info from strava and display it
Diffstat (limited to 'migrations/2020-02-05-020613_raw_data_entry')
-rw-r--r--migrations/2020-02-05-020613_raw_data_entry/down.sql5
-rw-r--r--migrations/2020-02-05-020613_raw_data_entry/up.sql5
2 files changed, 10 insertions, 0 deletions
diff --git a/migrations/2020-02-05-020613_raw_data_entry/down.sql b/migrations/2020-02-05-020613_raw_data_entry/down.sql
new file mode 100644
index 0000000..342a2d7
--- /dev/null
+++ b/migrations/2020-02-05-020613_raw_data_entry/down.sql
@@ -0,0 +1,5 @@
+alter table raw_data
+ drop column if exists entry_type;
+
+alter table raw_data
+ drop column if exists entry_id;
diff --git a/migrations/2020-02-05-020613_raw_data_entry/up.sql b/migrations/2020-02-05-020613_raw_data_entry/up.sql
new file mode 100644
index 0000000..a14d215
--- /dev/null
+++ b/migrations/2020-02-05-020613_raw_data_entry/up.sql
@@ -0,0 +1,5 @@
+alter table raw_data
+ add column entry_type varchar(16);
+
+alter table raw_data
+ add column entry_id bigint;