aboutsummaryrefslogtreecommitdiff
path: root/migrations/sqls
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/sqls')
-rw-r--r--migrations/sqls/20151030181628-types-values-down.sql1
-rw-r--r--migrations/sqls/20151030181628-types-values-up.sql5
2 files changed, 6 insertions, 0 deletions
diff --git a/migrations/sqls/20151030181628-types-values-down.sql b/migrations/sqls/20151030181628-types-values-down.sql
new file mode 100644
index 0000000..44f074e
--- /dev/null
+++ b/migrations/sqls/20151030181628-types-values-down.sql
@@ -0,0 +1 @@
+/* Replace with your SQL commands */ \ No newline at end of file
diff --git a/migrations/sqls/20151030181628-types-values-up.sql b/migrations/sqls/20151030181628-types-values-up.sql
new file mode 100644
index 0000000..e0b5e61
--- /dev/null
+++ b/migrations/sqls/20151030181628-types-values-up.sql
@@ -0,0 +1,5 @@
+ALTER TABLE value
+ADD COLUMN value_numeric NUMERIC;
+
+ALTER TABLE value
+RENAME COLUMN value TO value_text;