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