Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 491fcf0c

Von Tamino Steinert vor etwa 2 Jahren hinzugefügt

  • ID 491fcf0cd45f0eea4dba90068d79bd98ecee3172
  • Vorgänger cd160f80
  • Nachfolger ea2edf57

Reclamation: [FIX] file_storage

Unterschiede anzeigen:

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