diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2014-09-16 06:38:09 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2014-09-16 06:38:09 -0700 |
| commit | a1c723188509e9e251b233672e68327bb4ad42e7 (patch) | |
| tree | b18fc05298bda50aa3fdff8b70cb97138a5104db /FS/FS/Schema.pm | |
| parent | f1885b7eb233b3853f0e8baba781846f55bf64ae (diff) | |
convert prospects to customers via quotations, RT#20688
Diffstat (limited to 'FS/FS/Schema.pm')
| -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 02fcf8e..1de3709 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1811,10 +1811,11 @@ sub tables_hashref { 'add_date', @date_type, '', '', 'disabled', 'char', 'NULL', 1, '', '', 'custnum', 'int', 'NULL', '', '', '', + 'refnum', 'int', 'NULL', '', '', '', ], 'primary_key' => 'prospectnum', 'unique' => [], - 'index' => [ [ 'company' ], [ 'agentnum' ], [ 'disabled' ] ], + 'index' => [ ['company'], ['agentnum'], ['disabled'], ['refnum'] ], 'foreign_keys' => [ { columns => [ 'agentnum' ], table => 'agent', @@ -1822,6 +1823,9 @@ sub tables_hashref { { columns => [ 'custnum' ], table => 'cust_main', }, + { columns => [ 'refnum' ], + table => 'part_referral', + }, ], }, |