X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-setup;h=b7b45dc63d2d284d701f40f10ae9899f1a50ed14;hp=bb122700a235267cb18c12aa5cd79694e50f541c;hb=7598ece6cac31548505dd610ef418ca001adf5b2;hpb=e17e58178d528e16d45c333996f763afda55e054 diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup index bb122700a..b7b45dc63 100755 --- a/FS/bin/freeside-setup +++ b/FS/bin/freeside-setup @@ -337,8 +337,8 @@ sub tables_hash_hack { 'freq', 'int', 'NULL', '', 'prog', @perl_type, 'disabled', 'char', 'NULL', 1, - 'username', 'varchar', '', $char_d, - '_password','varchar', '', $char_d, + 'username', 'varchar', 'NULL', $char_d, + '_password','varchar', 'NULL', $char_d, ], 'primary_key' => 'agentnum', 'unique' => [], @@ -1104,6 +1104,20 @@ sub tables_hash_hack { 'index' => [], }, + 'acct_snarf' => { + 'columns' => [ + 'snarfnum', 'int', '', '', + 'svcnum', 'int', '', '', + 'machine', 'varchar', '', 255, + 'protocol', 'varchar', '', $char_d, + 'username', 'varchar', '', $char_d, + '_password', 'varchar', '', $char_d, + ], + 'primary_key' => 'snarfnum', + 'unique' => [], + 'index' => [ [ 'svcnum' ] ], + }, + ); %tables;