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