Revision 53217
Added by Miriam Baglioni about 6 years ago
modules/dnet-openaireplus-workflows/branches/solr7/src/main/resources/eu/dnetlib/patch-db/triggers.sql | ||
---|---|---|
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; |
Also available in: Unified diff
update table name for enabling and disabling of the trigger