Project

General

Profile

Download (1.16 KB) Statistics
| Revision:

dnet45/modules/dnet-openaire-datasource-manager/branches/eosc_services/src/main/resources/eu/dnetlib/enabling/datasources/queries/addDatasource.sql @ 62012

1 
INSERT INTO dsm_services(
2 
	id,
3 
	officialname,
4 
	englishname,
5 
	websiteurl,
6 
	logourl,
7 
	contactemail,
8 
	latitude,
9 
	longitude,
10 
	timezone,
11 
	namespaceprefix,
12 
	languages,--array
13 
	collectedfrom,
14 
	dateofvalidation,
15 
	typology,
16 
	provenanceaction,
17 
	platform,
18 
	activationid,
19 
	description,
20 
	releasestartdate,
21 
	releaseenddate,
22 
	missionstatementurl,
23 
	databaseaccesstype,
24 
	datauploadtype,
25 
	databaseaccessrestriction,
26 
	datauploadrestriction,
27 
	citationguidelineurl,
28 
	pidsystems,
29 
	certificates,
30 
	aggregator,
31 
	issn,
32 
	eissn,
33 
	lissn,
34 
	registeredby,
35 
	subjects,--array
36 
	managed,
37 
	eosc_datasource_type,
38 
	eosc_type
39 
) VALUES (
40 
	:id,
41 
	:officialname,
42 
	:englishname,
43 
	:websiteurl,
44 
	:logourl,
45 
	:contactemail,
46 
	:latitude,
47 
	:longitude,
48 
	:timezone,
49 
	:namespaceprefix,
50 
	:languages,--array
51 
	:collectedfrom,
52 
	:dateofvalidation,
53 
	:typology,
54 
	:provenanceaction,
55 
	:platform,
56 
	:activationid,
57 
	:description,
58 
	:releasestartdate,
59 
	:releaseenddate,
60 
	:missionstatementurl,
61 
	:databaseaccesstype,
62 
	:datauploadtype,
63 
	:databaseaccessrestriction,
64 
	:datauploadrestriction,
65 
	:citationguidelineurl,
66 
	:pidsystems,
67 
	:certificates,
68 
	:aggregator,
69 
	:issn,
70 
	:eissn,
71 
	:lissn,
72 
	:registeredby,
73 
	:subjects,--array
74 
	:managed,
75 
	:eoscdatasourcetype,
76 
	:eosctype
77 
)
(1-1/25)