X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-setup;h=72780e3632b434731e9475dd4e9e402cc6c32575;hp=4e3a09aada5fbe060a84edcf84389509c31006a5;hb=c7e637f35948396ca2bf760160f2a1a3081e0484;hpb=a5bc5bcbadafe55b31d9e97fccb6122477e390fb diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup index 4e3a09aad..72780e363 100755 --- a/FS/bin/freeside-setup +++ b/FS/bin/freeside-setup @@ -342,7 +342,7 @@ sub tables_hash_hack { ], 'primary_key' => 'agentnum', 'unique' => [], - 'index' => [ ['typenum'], ['diabled'] ], + 'index' => [ ['typenum'], ['disabled'] ], }, 'agent_type' => { @@ -708,6 +708,7 @@ sub tables_hash_hack { 'pkgpart', 'int', '', '', 'svcpart', 'int', '', '', 'quantity', 'int', '', '', + 'primary_svc','char', 'NULL', 1, ], 'primary_key' => '', 'unique' => [ ['pkgpart', 'svcpart'] ], @@ -1120,6 +1121,17 @@ sub tables_hash_hack { 'index' => [ [ 'svcnum' ] ], }, + 'svc_external' => { + 'columns' => [ + 'svcnum', 'int', '', '', + 'id', 'int', '', '', + 'title', 'varchar', 'NULL', $char_d, + ], + 'primary_key' => 'svcnum', + 'unique' => [], + 'index' => [], + }, + ); %tables;