Revision 59015
Added by Alessia Bardi over 3 years ago
modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/patch-db/migrate-projects.sql | ||
---|---|---|
66 | 66 |
optional1 varchar(255), |
67 | 67 |
optional2 varchar(255), |
68 | 68 |
funderid varchar(255) |
69 |
) |
|
69 |
);
|
|
70 | 70 |
|
71 | 71 |
-- fill it |
72 | 72 |
\copy xxx_fundingpaths from '/home/alessia.bardi/migrate-projects/xxx/xxx_fundingpaths-beta.sql' CSV; |
... | ... | |
85 | 85 |
semanticscheme varchar(255), |
86 | 86 |
optional1 varchar(255), |
87 | 87 |
optional2 varchar(255) |
88 |
) |
|
88 |
);
|
|
89 | 89 |
|
90 | 90 |
-- fill it |
91 | 91 |
\copy xxx_project_fundingpath from '/home/alessia.bardi/migrate-projects/xxx/xxx_project_fundingpath-beta.sql' CSV; |
... | ... | |
118 | 118 |
_dnet_resource_identifier_ varchar(2048), |
119 | 119 |
lastupdate date, |
120 | 120 |
trust double precision |
121 |
) |
|
121 |
);
|
|
122 | 122 |
|
123 | 123 |
-- fill it |
124 | 124 |
\copy xxx_orgs from '/home/alessia.bardi/migrate-projects/xxx/xxx_orgs-beta.sql' CSV; |
... | ... | |
135 | 135 |
_dnet_resource_identifier_ varchar(2048), |
136 | 136 |
contribution numeric, |
137 | 137 |
currency text |
138 |
) |
|
138 |
);
|
|
139 | 139 |
|
140 | 140 |
-- fill it |
141 | 141 |
\copy xxx_project_orgs from '/home/alessia.bardi/migrate-projects/xxx/xxx_project_orgs-beta.sql' CSV; |
Also available in: Unified diff
Missing ';' to properly end statements