Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision b335cac1

Von Jan Büren vor 6 Monaten hinzugefügt

  • ID b335cac190e844376b21fa62de806daf222a3ba0
  • Vorgänger efadb96f
  • Nachfolger 9e6b32c2

korrekte abhängigkeit db-skript, dann gibt es auch keinen Folgekonflikt

Unterschiede anzeigen:

sql/Pg-upgrade2/file_object_type_as_enum.sql
1 1 
-- @tag: file_object_type_as_enum
2 2 
-- @description: Objekttype von Dateien in Enum ändern
3 
-- @depends: files file_storage_purchase_quotation_intake
3 
-- @depends: files file_storage_purchase_order_confirmation
4 4 
-- @ignore: 0
5 5 

  		




  6
  6
  
    

  		




  ......




  53
  53
  
    
ALTER TABLE files DROP   COLUMN object_type;


  		




  54
  54
  
    
ALTER TABLE files RENAME COLUMN object_type_new TO object_type;


  		




  55
  55
  
    

  		




  56
  
  
    
-- constraint aus file_storage_purchase_quotation_intake wiederherstellen:


  		




  57
  
  
    
ALTER TABLE files


  		




  58
  
  
    
  ADD  CONSTRAINT valid_type CHECK (


  		




  59
  
  
    
             (object_type = 'credit_note'                 ) OR (object_type = 'invoice'                   )


  		




  60
  
  
    
          OR (object_type = 'sales_order'                 ) OR (object_type = 'sales_order_intake'        )


  		




  61
  
  
    
          OR (object_type = 'sales_quotation'             ) OR (object_type = 'sales_delivery_order'      )


  		




  62
  
  
    
          OR (object_type = 'request_quotation'           ) OR (object_type = 'purchase_quotation_intake' ) OR (object_type = 'purchase_order'          )


  		




  63
  
  
    
          OR (object_type = 'purchase_delivery_order'     ) OR (object_type = 'purchase_invoice'          )


  		




  64
  
  
    
          OR (object_type = 'vendor'                      ) OR (object_type = 'customer'                  ) OR (object_type = 'part'                    )


  		




  65
  
  
    
          OR (object_type = 'gl_transaction'              ) OR (object_type = 'dunning'                   ) OR (object_type = 'dunning1'                )


  		




  66
  
  
    
          OR (object_type = 'dunning2'                    ) OR (object_type = 'dunning3'                  ) OR (object_type = 'dunning_orig_invoice'    )


  		




  67
  
  
    
          OR (object_type = 'dunning_invoice'             ) OR (object_type = 'draft'                     ) OR (object_type = 'statement'               )


  		




  68
  
  
    
          OR (object_type = 'shop_image'                  ) OR (object_type = 'letter'                    ) OR (object_type = 'project'                 )


  		




  69
  
  
    
          OR (object_type = 'invoice_for_advance_payment' ) OR (object_type = 'final_invoice'             ) OR (object_type = 'supplier_delivery_order' )


  		




  70
  
  
    
          OR (object_type = 'sales_reclamation'           ) OR (object_type = 'purchase_reclamation'      ) OR (object_type = 'rma_delivery_order'      )


  		




  71
  
  
    
  );


  		




  72
  56
  
    

  		












Auch abrufbar als:  Unified diff