summaryrefslogtreecommitdiff
path: root/FS/bin/freeside-setup
diff options
context:
space:
mode:
Diffstat (limited to 'FS/bin/freeside-setup')
-rwxr-xr-xFS/bin/freeside-setup20
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' ] ],
+ },
);