X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-setup;h=bc27c79d0cd02390da50d2ae092a10d84b3ffbe1;hp=386c4c7cd513fb570e3052835e355f7136e12f3b;hb=6fe8172b11d0369d0b1274d6825ec0c57afe8001;hpb=c69dd0d922bba433b16e3408f71f1cac0e16a069 diff --git a/FS/bin/freeside-setup b/FS/bin/freeside-setup index 386c4c7cd..bc27c79d0 100755 --- a/FS/bin/freeside-setup +++ b/FS/bin/freeside-setup @@ -1127,7 +1127,7 @@ sub tables_hash_hack { 'svc_external' => { 'columns' => [ 'svcnum', 'int', '', '', - 'id', 'int', '', '', + 'id', 'int', 'NULL', '', 'title', 'varchar', 'NULL', $char_d, ], 'primary_key' => 'svcnum', @@ -1148,7 +1148,17 @@ sub tables_hash_hack { 'index' => [ ['paynum'], ['refundnum'] ], }, - + 'part_pkg_option' => { + 'columns' => [ + 'optionnum', 'serial', '', '', + 'pkgpart', 'int', '', '', + 'optionname', 'varchar', '', $char_d, + 'optionvalue', 'text', 'NULL', '', + ], + 'primary_key' => 'optionnum', + 'unique' => [], + 'index' => [ [ 'pkgpart' ], [ 'optionname' ] ], + }, );