1 -- @tag: file_storage_dunning_invoice
2 -- @description: Datei pro Mahnlauf als dunning. Altes dunning (Mahnrechnung) wird dunning_invoice
3 -- @depends: file_storage_type_dunning_orig_invoice
6 DROP CONSTRAINT valid_type;
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' )
17 OR (object_type = 'letter' )
20 UPDATE files SET object_type = 'dunning_invoice' WHERE object_type LIKE 'dunning';