Project

General

Profile

« Previous | Next » 

Revision 53725

Added by Alessia Bardi almost 6 years ago

updated to new tables of dsm

View differences:

modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/triggers.sql
1 1 
-- disable the triggers
2 
ALTER TABLE datasources DISABLE TRIGGER ALL;
2 
ALTER TABLE dsm_datasources DISABLE TRIGGER ALL;
3 3 
ALTER TABLE projectpids DISABLE TRIGGER ALL;
4 4 
ALTER TABLE project_subject DISABLE TRIGGER ALL;
5 5 
ALTER TABLE fundingpaths DISABLE TRIGGER ALL;
6 6 
ALTER TABLE project_fundingpath DISABLE TRIGGER ALL;
7 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;
8 
ALTER TABLE dsm_organizations DISABLE TRIGGER ALL;
9 
ALTER TABLE dsm_organizationpids DISABLE TRIGGER ALL;
10 
ALTER TABLE dsm_datasource_organization DISABLE TRIGGER ALL;
11 11 
ALTER TABLE projects DISABLE TRIGGER ALL;
12 12 

  		




  13
  13
  
    
-- enable the triggers


  		




  14
  
  
    
ALTER TABLE datasources ENABLE TRIGGER ALL;


  		




  
  14
  
    
ALTER TABLE dsm_datasources ENABLE TRIGGER ALL;


  		




  15
  15
  
    
ALTER TABLE projectpids ENABLE TRIGGER ALL;


  		




  16
  16
  
    
ALTER TABLE project_subject ENABLE TRIGGER ALL;


  		




  17
  17
  
    
ALTER TABLE fundingpaths ENABLE TRIGGER ALL;


  		




  18
  18
  
    
ALTER TABLE project_fundingpath ENABLE TRIGGER ALL;


  		




  19
  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;


  		




  
  20
  
    
ALTER TABLE dsm_organizations ENABLE TRIGGER ALL;


  		




  
  21
  
    
ALTER TABLE dsm_organizationpids ENABLE TRIGGER ALL;


  		




  
  22
  
    
ALTER TABLE dsm_datasource_organization ENABLE TRIGGER ALL;


  		




  23
  23
  
    
ALTER TABLE projects ENABLE TRIGGER ALL;


  		












Also available in:  Unified diff