Project

General

Profile

Download (1.28 KB) Statistics
| Revision:

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

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