X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=22a731784d1d5b4a5b8ad654bf848da752b6e246;hp=ec046cb38e74231a84c968fb259ec80454ac1a97;hb=f13afe5e228a220311557e1ca6dacbf847c26baf;hpb=795a85c10d898120a2a6341c4df32fb60b069a64 diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index ec046cb38..22a731784 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1778,11 +1778,23 @@ sub tables_hashref { 'index' => [], }, + 'pkg_category' => { + 'columns' => [ + 'categorynum', 'serial', '', '', '', '', + 'categoryname', 'varchar', '', $char_d, '', '', + 'disabled', 'char', 'NULL', 1, '', '', + ], + 'primary_key' => 'categorynum', + 'unique' => [], + 'index' => [ ['disabled'] ], + }, + 'pkg_class' => { 'columns' => [ - 'classnum', 'serial', '', '', '', '', - 'classname', 'varchar', '', $char_d, '', '', - 'disabled', 'char', 'NULL', 1, '', '', + 'classnum', 'serial', '', '', '', '', + 'classname', 'varchar', '', $char_d, '', '', + 'categorynum', 'int', 'NULL', '', '', '', + 'disabled', 'char', 'NULL', 1, '', '', ], 'primary_key' => 'classnum', 'unique' => [],