Project

General

Profile

Download (1.12 KB) Statistics
| Revision:

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

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 
	provenanceaction,
16 
	platform,
17 
	activationid,
18 
	description,
19 
	releasestartdate,
20 
	releaseenddate,
21 
	missionstatementurl,
22 
	databaseaccesstype,
23 
	datauploadtype,
24 
	databaseaccessrestriction,
25 
	datauploadrestriction,
26 
	citationguidelineurl,
27 
	certificates,
28 
	aggregator,
29 
	issn,
30 
	eissn,
31 
	lissn,
32 
	registeredby,
33 
	subjects,--array
34 
	managed,
35 
	eosc_datasource_type,
36 
	eosc_type
37 
) VALUES (
38 
	:id,
39 
	:officialname,
40 
	:englishname,
41 
	:websiteurl,
42 
	:logourl,
43 
	:contactemail,
44 
	:latitude,
45 
	:longitude,
46 
	:timezone,
47 
	:namespaceprefix,
48 
	:languages,--array
49 
	:collectedfrom,
50 
	:dateofvalidation,
51 
	:provenanceaction,
52 
	:platform,
53 
	:activationid,
54 
	:description,
55 
	:releasestartdate,
56 
	:releaseenddate,
57 
	:missionstatementurl,
58 
	:databaseaccesstype,
59 
	:datauploadtype,
60 
	:databaseaccessrestriction,
61 
	:datauploadrestriction,
62 
	:citationguidelineurl,
63 
	:certificates,
64 
	:aggregator,
65 
	:issn,
66 
	:eissn,
67 
	:lissn,
68 
	:registeredby,
69 
	:subjects,--array
70 
	:managed,
71 
	:eoscdatasourcetype,
72 
	:eosctype
73 
)
(1-1/25)