Project

General

Profile

Download (1.02 KB) Statistics
| Revision:

dnet45/modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/triggers.sql @ 61029

1 51176 claudio.at 
-- disable the triggers
2 53725 alessia.ba 
ALTER TABLE dsm_datasources DISABLE TRIGGER ALL;
3 51176 claudio.at 
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 53725 alessia.ba 
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 51176 claudio.at 
ALTER TABLE projects DISABLE TRIGGER ALL;
12 

      

      

        13
        
        
        
        
        
-- enable the triggers


      

      

        14
        
            53725
        
        
            alessia.ba
        
        
ALTER TABLE dsm_datasources ENABLE TRIGGER ALL;


      

      

        15
        
            51176
        
        
            claudio.at
        
        
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
        
            53725
        
        
            alessia.ba
        
        
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
        
            51176
        
        
            claudio.at
        
        
ALTER TABLE projects ENABLE TRIGGER ALL;