Revision 55620
Added by Alessia Bardi almost 5 years ago
modules/dnet-openaire-datasource-manager/trunk/src/main/resources/db_fixes/script.sql | ||
---|---|---|
1 | 1 |
alter table dsm_api add column compatibility_override varchar(255) default NULL; |
2 | 2 |
|
3 |
update |
|
3 |
update dsm_api set removable = true where id in (select api.id from dsm_api api left join dsm_datasources d on d.id = api.datasource where d.managed = true and api.removable=false); |
Also available in: Unified diff
Added sql to fix removable values of APIs