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