diff options
| author | Jonathan Prykop <jonathan@freeside.biz> | 2015-10-15 21:07:34 -0500 |
|---|---|---|
| committer | Jonathan Prykop <jonathan@freeside.biz> | 2015-11-10 18:05:14 -0600 |
| commit | 315f5c9e8d797046db1bc6f91ae9e9e365309514 (patch) | |
| tree | a37b7cb6e955415f639a2c271f88a7be0fdd6d08 /FS/FS/Schema.pm | |
| parent | 13988f1ad2e1d8ad878af12fbd455a8653309d15 (diff) | |
RT#34960: Quotations
Diffstat (limited to 'FS/FS/Schema.pm')
| -rw-r--r-- | FS/FS/Schema.pm | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 0e5efe9..5ac4a6a 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1970,6 +1970,24 @@ sub tables_hashref { ], }, + 'quotation_pkg_detail' => { + 'columns' => [ + 'detailnum', 'serial', '', '', '', '', + 'billpkgnum', 'int', '', '', '', '', # actually links to quotationpkgnum + 'format', 'char', 'NULL', 1, '', '', # not used for anything + 'detail', 'varchar', '', 255, '', '', + ], + 'primary_key' => 'detailnum', + 'unique' => [], + 'index' => [ [ 'billpkgnum' ] ], + 'foreign_keys' => [ + { columns => [ 'billpkgnum' ], + table => 'quotation_pkg', + references => [ 'quotationpkgnum' ], + }, + ], + }, + 'quotation_pkg_discount' => { 'columns' => [ 'quotationpkgdiscountnum', 'serial', '', '', '', '', |