Revision 29461
Added by Michele Artini about 10 years ago
| modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/patch.sql | ||
|---|---|---|
| 94 | 94 |
ALTER TABLE api ADD CONSTRAINT api_contentdescriptionscheme_fkey FOREIGN KEY (contentdescriptionscheme) REFERENCES scheme(code); |
| 95 | 95 |
|
| 96 | 96 |
UPDATE api SET typologyclass = d.datasourceclass FROM datasources d WHERE datasource = d.id; |
| 97 |
UPDATE api SET compatibilityclass = 'driver' where typology = 'driver'; |
|
| 97 | 98 |
UPDATE api SET compatibilityclass = 'openaire2.0' FROM apicollections ac WHERE typology = 'openaire' AND id = ac.api AND ac.param = 'set' AND ac.original like '%ec_fundedresources%'; |
| 98 | 99 |
UPDATE api SET compatibilityclass = 'openaire3.0' FROM apicollections ac WHERE typology = 'openaire' AND id = ac.api AND ac.param = 'set' AND ac.original like '%openaire%'; |
| 99 | 100 |
UPDATE api SET (typologyclass, compatibilityclass) = ('entityregistry', 'native') WHERE id = 'api_________::opendoar::0';
|
Also available in: Unified diff
re-added a deleted statement