Revision 33216
Added by Michele Artini almost 10 years ago
modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/patch-new.sql | ||
---|---|---|
1 |
--FCT ENTITY REGISTRY |
|
2 |
INSERT INTO organizations (_dnet_resource_identifier_, id, legalshortname, legalname, websiteurl, logourl, countryclass, provenanceactionclass) VALUES ('fct_________::FCT', 'fct_________::FCT', 'FCT', 'Fundação para a Ciência e a Tecnologia, I.P.', 'http://www.fct.pt', 'http://www.fct.pt/images/FCT_H_color_v2011_b.png', 'PT', 'sysimport:crosswalk:entityregistry'); |
|
3 |
INSERT INTO datasources (_dnet_resource_identifier_, id, officialname, englishname, websiteurl, logourl, contactemail, latitude, longitude, timezone, namespaceprefix, collectedfrom, datasourceclass) VALUES ('openaire____::fct', 'openaire____::fct', 'FCT - Fundação para a Ciência e a Tecnologia', 'FCT - Foundation for Science and Technology', 'http://www.fct.pt', 'http://www.fct.pt/images/FCT_H_color_v2011_b.png', 'projectos@fct.pt', 38.71, -9.14, 0.0, 'fct_________', 'infrastruct_::openaire', 'entityregistry'); |
|
4 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass) VALUES ('api_________::fct::0', 'api_________::fct::0', 'filesystem', 'openaire____::fct', 'entityregistry', 'native'); |
|
5 |
INSERT INTO apicollections (param, original, api) VALUES ('baseUrl', 'file:///var/lib/dnet/fct', 'api_________::fct::0'); |
|
6 |
INSERT INTO apicollections (param, original, api) VALUES ('extensions', '*.xml', 'api_________::fct::0'); |
|
7 |
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '/project/id', 'api_________::fct::0', false); |
|
8 |
UPDATE apicollections SET _dnet_resource_identifier_ = api||'@@'||param; |
|
9 |
INSERT INTO datasource_organization (_dnet_resource_identifier_, datasource, organization) VALUES ('fct_________::fct@@fct_________::FCT', 'openaire____::fct', 'fct_________::FCT'); |
modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/patch-fct.sql | ||
---|---|---|
1 |
--FCT ENTITY REGISTRY |
|
2 |
INSERT INTO organizations (_dnet_resource_identifier_, id, legalshortname, legalname, websiteurl, logourl, countryclass, provenanceactionclass) VALUES ('fct_________::FCT', 'fct_________::FCT', 'FCT', 'Fundação para a Ciência e a Tecnologia, I.P.', 'http://www.fct.pt', 'http://www.fct.pt/images/FCT_H_color_v2011_b.png', 'PT', 'sysimport:crosswalk:entityregistry'); |
|
3 |
INSERT INTO datasources (_dnet_resource_identifier_, id, officialname, englishname, websiteurl, logourl, contactemail, latitude, longitude, timezone, namespaceprefix, collectedfrom, datasourceclass) VALUES ('openaire____::fct', 'openaire____::fct', 'FCT - Fundação para a Ciência e a Tecnologia', 'FCT - Foundation for Science and Technology', 'http://www.fct.pt', 'http://www.fct.pt/images/FCT_H_color_v2011_b.png', 'projectos@fct.pt', 38.71, -9.14, 0.0, 'fct_________', 'infrastruct_::openaire', 'entityregistry'); |
|
4 |
INSERT INTO api (_dnet_resource_identifier_, id, protocolclass, datasource, typologyclass, compatibilityclass) VALUES ('api_________::fct::0', 'api_________::fct::0', 'filesystem', 'openaire____::fct', 'entityregistry', 'native'); |
|
5 |
INSERT INTO apicollections (param, original, api) VALUES ('baseUrl', 'file:///var/lib/dnet/fct', 'api_________::fct::0'); |
|
6 |
INSERT INTO apicollections (param, original, api) VALUES ('extensions', '*.xml', 'api_________::fct::0'); |
|
7 |
INSERT INTO apicollections (param, original, api, accessparam) VALUES ('metadata_identifier_path', '/project/id', 'api_________::fct::0', false); |
|
8 |
UPDATE apicollections SET _dnet_resource_identifier_ = api||'@@'||param; |
|
9 |
INSERT INTO datasource_organization (_dnet_resource_identifier_, datasource, organization) VALUES ('fct_________::fct@@fct_________::FCT', 'openaire____::fct', 'fct_________::FCT'); |
Also available in: Unified diff
renamed patch-new.sql in patch-fct.sql