Project

General

Profile

« Previous | Next » 

Revision 51176

Added by Claudio Atzori about 6 years ago

utility file we can use to disable/enable the table triggers to speedup manual operations

View differences:

modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/triggers.sql
1 
-- disable the triggers
2 
ALTER TABLE datasources DISABLE TRIGGER ALL;
3 
ALTER TABLE projectpids DISABLE TRIGGER ALL;
4 
ALTER TABLE project_subject DISABLE TRIGGER ALL;
5 
ALTER TABLE fundingpaths DISABLE TRIGGER ALL;
6 
ALTER TABLE project_fundingpath DISABLE TRIGGER ALL;
7 
ALTER TABLE project_organization DISABLE TRIGGER ALL;
8 
ALTER TABLE organizations DISABLE TRIGGER ALL;
9 
ALTER TABLE organizationpids DISABLE TRIGGER ALL;
10 
ALTER TABLE datasource_organization DISABLE TRIGGER ALL;
11 
ALTER TABLE projects DISABLE TRIGGER ALL;
12 

  		




  
  13
  
    
-- enable the triggers


  		




  
  14
  
    
ALTER TABLE datasources ENABLE TRIGGER ALL;


  		




  
  15
  
    
ALTER TABLE projectpids ENABLE TRIGGER ALL;


  		




  
  16
  
    
ALTER TABLE project_subject ENABLE TRIGGER ALL;


  		




  
  17
  
    
ALTER TABLE fundingpaths ENABLE TRIGGER ALL;


  		




  
  18
  
    
ALTER TABLE project_fundingpath ENABLE TRIGGER ALL;


  		




  
  19
  
    
ALTER TABLE project_organization ENABLE TRIGGER ALL;


  		




  
  20
  
    
ALTER TABLE organizations ENABLE TRIGGER ALL;


  		




  
  21
  
    
ALTER TABLE organizationpids ENABLE TRIGGER ALL;


  		




  
  22
  
    
ALTER TABLE datasource_organization ENABLE TRIGGER ALL;


  		




  
  23
  
    
ALTER TABLE projects ENABLE TRIGGER ALL;


  		












Also available in:  Unified diff