aboutsummaryrefslogtreecommitdiff
path: root/migrations/sqls/20151030181628-types-values-up.sql
diff options
context:
space:
mode:
authorTrygve Laugstøl <trygvis@inamo.no>2015-10-30 19:45:22 +0100
committerTrygve Laugstøl <trygvis@inamo.no>2015-10-30 19:45:22 +0100
commitecb664a8550ee787a593db6cf45907100a875a54 (patch)
treedc241c9941df27715f721ef12bd40a7648f09f37 /migrations/sqls/20151030181628-types-values-up.sql
parent5e634d62d599c60a34f405e26ef0c3037e9a37a3 (diff)
downloaddiller-server-ecb664a8550ee787a593db6cf45907100a875a54.tar.gz
diller-server-ecb664a8550ee787a593db6cf45907100a875a54.tar.bz2
diller-server-ecb664a8550ee787a593db6cf45907100a875a54.tar.xz
diller-server-ecb664a8550ee787a593db6cf45907100a875a54.zip
o Splitting the value field into value_numeric and value_text.
Diffstat (limited to 'migrations/sqls/20151030181628-types-values-up.sql')
-rw-r--r--migrations/sqls/20151030181628-types-values-up.sql5
1 files changed, 5 insertions, 0 deletions
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;