Revision 53725
Added by Alessia Bardi almost 6 years ago
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
updated to new tables of dsm