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