Project

General

Profile

1
-- disable the triggers
2
ALTER TABLE dsm_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 dsm_organizations DISABLE TRIGGER ALL;
9
ALTER TABLE dsm_organizationpids DISABLE TRIGGER ALL;
10
ALTER TABLE dsm_datasource_organization DISABLE TRIGGER ALL;
11
ALTER TABLE projects DISABLE TRIGGER ALL;
12

    
13
-- enable the triggers
14
ALTER TABLE dsm_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 dsm_organizations ENABLE TRIGGER ALL;
21
ALTER TABLE dsm_organizationpids ENABLE TRIGGER ALL;
22
ALTER TABLE dsm_datasource_organization ENABLE TRIGGER ALL;
23
ALTER TABLE projects ENABLE TRIGGER ALL;
(24-24/24)