X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=da128d54f1bf1e5be3ba9e786a6b9860ca0c38ef;hp=e63dba6f30a9eff314eaf2ceb33a87aa1a8a8c84;hb=95b6042f37f00de9dca4b5654522fc4098a82d04;hpb=01c832583b09f6bb6c3ae6067187e08160424c71 diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index e63dba6f3..da128d54f 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1967,6 +1967,26 @@ sub tables_hashref { ], }, + 'quotation_pkg_tax' => { + 'columns' => [ + 'quotationtaxnum', 'serial', '', '', '', '', + 'quotationpkgnum', 'int', '', '', '', '', + 'itemdesc', 'varchar', '', $char_d, '', '', + 'taxnum', 'int', '', '', '', '', + 'taxtype', 'varchar', '', $char_d, '', '', + 'setup_amount', @money_type, '', '', + 'recur_amount', @money_type, '', '', + ], + 'primary_key' => 'quotationtaxnum',, + 'unique' => [], + 'index' => [ [ 'quotationpkgnum' ] ], + 'foreign_keys' => [ + { columns => [ 'quotationpkgnum' ], + table => 'quotation_pkg', + }, + ], +}, + 'cust_location' => { #'location' now that its prospects too, but... 'columns' => [ 'locationnum', 'serial', '', '', '', '',