diff options
Diffstat (limited to 'FS/bin/freeside-setup')
-rwxr-xr-x | FS/bin/freeside-setup | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup index c867a721f..24b0685de 100755 --- a/FS/bin/freeside-setup +++ b/FS/bin/freeside-setup @@ -1209,6 +1209,26 @@ sub tables_hash_hack { 'index' => [ [ 'countrycode' ], [ 'regionnum' ] ], }, + 'reg_code' => { + 'columns' => [ + 'codenum', 'serial', '', '', + 'code', 'varchar', '', $char_d, + 'agentnum', 'int', '', '', + ], + 'primary_key' => 'codenum', + 'unique' => [ [ 'agentnum', 'code' ] ], + 'index' => [ [ 'agentnum' ] ], + }, + + 'reg_code_pkg' => { + 'columns' => [ + 'codenum', 'int', '', '', + 'pkgpart', 'int', '', '', + ], + 'primary_key' => '', + 'unique' => [ [ 'codenum', 'pkgpart' ] ], + 'index' => [ [ 'codenum' ] ], + }, ); |