Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision 2be083e2

Von Jan Büren vor 7 Monaten hinzugefügt

  • ID 2be083e2c626afaa81df48e3206645c689eeb879
  • Vorgänger d1e692bb
  • Nachfolger 20fefc73

constraint wiederherstellen, falls bei drop eine column betroffen ist

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: file_storage_purchase_quotation_intake
3 
-- @depends: files file_storage_purchase_quotation_intake
4 
-- @ignore: 0
5 

  		




  4
  6
  
    

  		




  5
  7
  
    
CREATE TYPE file_object_types AS ENUM (


  		




  6
  8
  
    
  -- order


  		




  ......




  50
  52
  
    
ALTER TABLE files ALTER  COLUMN object_type_new SET NOT NULL;


  		




  51
  53
  
    
ALTER TABLE files DROP   COLUMN object_type;


  		




  52
  54
  
    
ALTER TABLE files RENAME COLUMN object_type_new TO object_type;


  		




  
  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
  
    

  		












Auch abrufbar als:  Unified diff