Revision 491fcf0c
Von Tamino Steinert vor fast 2 Jahren hinzugefügt
sql/Pg-upgrade2/file_storage_reclamation.sql | ||
---|---|---|
1 | 1 |
-- @tag: file_storage_reclamation |
2 | 2 |
-- @description: Dateispeicher auch für Reklamationen anbieten |
3 |
-- @depends: file_storage_partial_invoices
|
|
3 |
-- @depends: file_storage_supplier_delivery_order
|
|
4 | 4 |
|
5 | 5 |
ALTER TABLE files |
6 | 6 |
DROP CONSTRAINT valid_type; |
7 | 7 |
ALTER TABLE files |
8 | 8 |
ADD CONSTRAINT valid_type CHECK ( |
9 |
(object_type = 'credit_note' ) OR (object_type = 'invoice' ) OR (object_type = 'sales_order' )
|
|
10 |
OR (object_type = 'sales_quotation' ) OR (object_type = 'sales_delivery_order' ) OR (object_type = 'request_quotation' )
|
|
11 |
OR (object_type = 'purchase_order' ) OR (object_type = 'purchase_delivery_order' ) OR (object_type = 'purchase_invoice' )
|
|
12 |
OR (object_type = 'vendor' ) OR (object_type = 'customer' ) OR (object_type = 'part' )
|
|
13 |
OR (object_type = 'gl_transaction' ) OR (object_type = 'dunning' ) OR (object_type = 'dunning1' )
|
|
14 |
OR (object_type = 'dunning2' ) OR (object_type = 'dunning3' ) OR (object_type = 'dunning_orig_invoice' )
|
|
15 |
OR (object_type = 'dunning_invoice' ) OR (object_type = 'draft' ) OR (object_type = 'statement' )
|
|
16 |
OR (object_type = 'shop_image' ) OR (object_type = 'letter' ) OR (object_type = 'project' )
|
|
17 |
OR (object_type = 'invoice_for_advance_payment') OR (object_type = 'final_invoice')
|
|
18 |
OR (object_type = 'sales_reclamation') OR (object_type = 'purchase_reclamation')
|
|
9 |
(object_type = 'credit_note' ) OR (object_type = 'invoice' ) OR (object_type = 'sales_order' )
|
|
10 |
OR (object_type = 'sales_quotation' ) OR (object_type = 'sales_delivery_order' ) OR (object_type = 'request_quotation' )
|
|
11 |
OR (object_type = 'purchase_order' ) OR (object_type = 'purchase_delivery_order' ) OR (object_type = 'purchase_invoice' )
|
|
12 |
OR (object_type = 'vendor' ) OR (object_type = 'customer' ) OR (object_type = 'part' )
|
|
13 |
OR (object_type = 'gl_transaction' ) OR (object_type = 'dunning' ) OR (object_type = 'dunning1' )
|
|
14 |
OR (object_type = 'dunning2' ) OR (object_type = 'dunning3' ) OR (object_type = 'dunning_orig_invoice' )
|
|
15 |
OR (object_type = 'dunning_invoice' ) OR (object_type = 'draft' ) OR (object_type = 'statement' )
|
|
16 |
OR (object_type = 'shop_image' ) OR (object_type = 'letter' ) OR (object_type = 'project' )
|
|
17 |
OR (object_type = 'invoice_for_advance_payment' ) OR (object_type = 'final_invoice' ) OR (object_type = 'supplier_delivery_order' )
|
|
18 |
OR (object_type = 'sales_reclamation' ) OR (object_type = 'purchase_reclamation' )
|
|
19 | 19 |
); |
Auch abrufbar als: Unified diff
Reclamation: [FIX] file_storage