Project

General

Profile

« Previous | Next » 

Revision 62109

Added by Michele Artini over 2 years ago

merge from eosc_services

View differences:

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

Also available in: Unified diff