dnet45/modules/dnet-openaire-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/queries/addOrganization.sql @ 59199
| 1 | 49990 | michele.ar | BEGIN; |
|---|---|---|---|
| 2 | |||
| 3 | INSERT INTO dsm_organizations( |
||
| 4 | id, |
||
| 5 | legalshortname, |
||
| 6 | legalname, |
||
| 7 | websiteurl, |
||
| 8 | logourl, |
||
| 9 | 59199 | alessia.ba | country, |
| 10 | collectedfrom
|
||
| 11 | 49990 | michele.ar | ) VALUES ( |
| 12 | :orgId, |
||
| 13 | :legalshortname, |
||
| 14 | :legalname, |
||
| 15 | :websiteurl, |
||
| 16 | :logourl, |
||
| 17 | 59199 | alessia.ba | :country, |
| 18 | :collectedfrom |
||
| 19 | 49990 | michele.ar | );
|
| 20 | |||
| 21 | INSERT INTO dsm_datasource_organization( |
||
| 22 | datasource, |
||
| 23 | organization
|
||
| 24 | ) VALUES ( |
||
| 25 | :dsId, |
||
| 26 | :orgId |
||
| 27 | );
|
||
| 28 | |||
| 29 | COMMIT; |