1 |
59460
|
alessia.ba
|
-- disable the triggers
|
2 |
|
|
ALTER TABLE projectpids DISABLE TRIGGER ALL;
|
3 |
|
|
ALTER TABLE project_subject DISABLE TRIGGER ALL;
|
4 |
|
|
ALTER TABLE fundingpaths DISABLE TRIGGER ALL;
|
5 |
|
|
ALTER TABLE project_fundingpath DISABLE TRIGGER ALL;
|
6 |
|
|
ALTER TABLE project_organization DISABLE TRIGGER ALL;
|
7 |
|
|
ALTER TABLE dsm_organizations DISABLE TRIGGER ALL;
|
8 |
|
|
ALTER TABLE projects DISABLE TRIGGER ALL;
|
9 |
|
|
|
10 |
|
|
-- then for each funder, changing the PREFIX
|
11 |
|
|
DELETE FROM projectpids where project like 'PREFIX%';
|
12 |
|
|
DELETE FROM project_subject where project like 'PREFIX%';
|
13 |
|
|
DELETE FROM subjects where id like 'PREFIX%';
|
14 |
|
|
DELETE FROM project_fundingpath where project like 'PREFIX%';
|
15 |
|
|
DELETE FROM fundingpaths where id like 'PREFIX%';
|
16 |
|
|
DELETE FROM project_organization where project like 'PREFIX%';
|
17 |
|
|
DELETE FROM dsm_organizations where id like 'PREFIX%';
|
18 |
|
|
DELETE FROM projects where id like 'PREFIX%';
|
19 |
|
|
|
20 |
|
|
-- enable the triggers
|
21 |
|
|
ALTER TABLE projectpids ENABLE TRIGGER ALL;
|
22 |
|
|
ALTER TABLE project_subject ENABLE TRIGGER ALL;
|
23 |
|
|
ALTER TABLE subjects ENABLE TRIGGER ALL;
|
24 |
|
|
ALTER TABLE fundingpaths ENABLE TRIGGER ALL;
|
25 |
|
|
ALTER TABLE project_fundingpath ENABLE TRIGGER ALL;
|
26 |
|
|
ALTER TABLE project_organization ENABLE TRIGGER ALL;
|
27 |
|
|
ALTER TABLE dsm_organizations ENABLE TRIGGER ALL;
|
28 |
|
|
ALTER TABLE projects ENABLE TRIGGER ALL;
|