Project

General

Profile

« Previous | Next » 

Revision 55620

Added sql to fix removable values of APIs

View differences:

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