diff options
author | Ivan Kohler <ivan@freeside.biz> | 2015-03-05 17:30:26 -0800 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2015-03-05 17:30:26 -0800 |
commit | aaa1a91c209ec3547b2c62dc59af935649a62b58 (patch) | |
tree | 95f75a577534f09a8ffdce286d375732a1cfb681 /FS/FS/Schema.pm | |
parent | 3f27b7ce7c72b0ff7061baf3586e130b1c9a1569 (diff) |
legacy change history, RT#29311
Diffstat (limited to 'FS/FS/Schema.pm')
-rw-r--r-- | FS/FS/Schema.pm | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 9c2e9ba..89fc5f7 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -200,6 +200,7 @@ sub dbdef_dist { grep { ! /^(clientapi|access_user)_session/ && ! /^h_/ && ! /^log(_context)?$/ + && ! /^legacy_cust_history$/ && ( ! /^queue(_arg|_depend|_stat)?$/ || ! $opt->{'queue-no_history'} ) && ! $tables_hashref_torrus->{$_} } @@ -778,6 +779,31 @@ sub tables_hashref { ], }, + 'legacy_cust_history' => { + 'columns' => [ + 'legacyhistorynum', 'serial', '', '', '', '', + 'custnum', 'int', '', '', '', '', + 'history_action', 'varchar', '', $char_d, '', '', + 'history_date', @date_type, '', '', + 'history_usernum', 'int', 'NULL', '', '', '', + 'item', 'varchar', 'NULL', $char_d, '', '', + 'description', 'varchar', 'NULL', 2*$char_d, '', '', + 'change_data', 'text', 'NULL', '', '', '', + ], + 'primary_key' => 'legacyhistorynum', + 'unique' => [], + 'index' => [ ['custnum'], ['history_date'], ], + 'foreign_keys' => [ + { columns => [ 'custnum' ], + table => 'cust_main', + }, + { columns => [ 'history_usernum' ], + table => 'access_user', + references => [ 'usernum' ], + }, + ], + }, + 'cust_statement' => { 'columns' => [ 'statementnum', 'serial', '', '', '', '', |