From 128443531fae5fced8a8d2adbcaf6cb945218e3d Mon Sep 17 00:00:00 2001 From: Joshua Goodman Date: Tue, 25 Feb 2014 05:35:42 +0000 Subject: [PATCH] Added reasonnum col, allowed reason to be null, implemented key constraint with reasonnum col --- FS/FS/Schema.pm | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index bf516b28f..ec4a1b3e2 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -2847,7 +2847,8 @@ sub tables_hashref { 'currency', 'char', 'NULL', 3, '', '', 'otaker', 'varchar', 'NULL', 32, '', '', 'usernum', 'int', 'NULL', '', '', '', - 'reason', 'varchar', '', $char_d, '', '', + 'reason', 'varchar', 'NULL', $char_d, '', '', + 'reasonnum', 'int', 'NULL', '', '', '', 'payby', 'char', '', 4, '', '', # CARD/BILL/COMP, should # be index into payby # table eventually @@ -2871,6 +2872,9 @@ sub tables_hashref { { columns => [ 'usernum' ], table => 'access_user', }, + { columns => [ 'reasonnum' ], + table => 'reason', + }, { columns => [ 'gatewaynum' ], table => 'payment_gateway', }, -- 2.11.0