From ecb664a8550ee787a593db6cf45907100a875a54 Mon Sep 17 00:00:00 2001 From: Trygve Laugstøl Date: Fri, 30 Oct 2015 19:45:22 +0100 Subject: o Splitting the value field into value_numeric and value_text. --- migrations/sqls/20151030181628-types-values-down.sql | 1 + migrations/sqls/20151030181628-types-values-up.sql | 5 +++++ 2 files changed, 6 insertions(+) create mode 100644 migrations/sqls/20151030181628-types-values-down.sql create mode 100644 migrations/sqls/20151030181628-types-values-up.sql (limited to 'migrations/sqls') 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; -- cgit v1.2.3