diff options
| author | Joshua Goodman <jgoodman1990@gmail.com> | 2014-02-25 05:35:42 +0000 |
|---|---|---|
| committer | Joshua Goodman <jgoodman1990@gmail.com> | 2014-02-25 05:35:42 +0000 |
| commit | 128443531fae5fced8a8d2adbcaf6cb945218e3d (patch) | |
| tree | a8fed20d13a17c588aa0f40596415857ad247ddb | |
| parent | 23b5c810efb0975fb4a06142674aa27eabd5e689 (diff) | |
Added reasonnum col, allowed reason to be null, implemented key constraint with reasonnum col
| -rw-r--r-- | FS/FS/Schema.pm | 6 |
1 files changed, 5 insertions, 1 deletions
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', }, |