Mercurial > hg > LGDataverses
comparison DVN-web/installer/dvninstall/referenceData.sql @ 6:1b2188262ae9
adding the installer.
author | "jurzua <jurzua@mpiwg-berlin.mpg.de>" |
---|---|
date | Wed, 13 May 2015 11:50:21 +0200 |
parents | |
children |
comparison
equal
deleted
inserted
replaced
5:dd9adfc73390 | 6:1b2188262ae9 |
---|---|
1 -- | |
2 -- PostgreSQL database dump | |
3 -- | |
4 | |
5 -- Started on 2006-09-19 16:05:05 Eastern Standard Time | |
6 | |
7 SET client_encoding = 'UTF8'; | |
8 SET check_function_bodies = false; | |
9 SET client_min_messages = warning; | |
10 | |
11 SET search_path = public, pg_catalog; | |
12 | |
13 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('metadata', 'id'), 10, false); | |
14 | |
15 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('template', 'id'), 10, false); | |
16 | |
17 | |
18 -- | |
19 -- TOC entry 1840 (class 0 OID 0) | |
20 -- Dependencies: 1304 | |
21 -- Name: datatable_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | |
22 -- | |
23 | |
24 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('pagedef', 'id'), 500, false); | |
25 | |
26 | |
27 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('datatable', 'id'), 1, false); | |
28 | |
29 | |
30 -- | |
31 -- TOC entry 1841 (class 0 OID 0) | |
32 -- Dependencies: 1291 | |
33 -- Name: datavariable_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | |
34 -- | |
35 | |
36 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('datavariable', 'id'), 1, false); | |
37 | |
38 | |
39 -- | |
40 -- TOC entry 1842 (class 0 OID 0) | |
41 -- Dependencies: 1297 | |
42 -- Name: fieldinputlevel_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | |
43 -- | |
44 | |
45 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('fieldinputlevel', 'id'), 10, false); | |
46 | |
47 | |
48 | |
49 | |
50 | |
51 -- | |
52 -- TOC entry 1844 (class 0 OID 0) | |
53 -- Dependencies: 1287 | |
54 -- Name: logindomain_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | |
55 -- | |
56 | |
57 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('logindomain', 'id'), 1, false); | |
58 | |
59 | |
60 | |
61 | |
62 -- | |
63 -- TOC entry 1846 (class 0 OID 0) | |
64 -- Dependencies: 1312 | |
65 -- Name: role_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | |
66 -- | |
67 | |
68 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('"role"', 'id'), 10, false); | |
69 | |
70 | |
71 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('"networkrole"', 'id'), 10, false); | |
72 | |
73 -- | |
74 -- TOC entry 1848 (class 0 OID 0) | |
75 -- Dependencies: 1272 | |
76 -- Name: studyfield_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | |
77 -- | |
78 | |
79 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('studyfield', 'id'), 150, true); | |
80 | |
81 | |
82 | |
83 | |
84 | |
85 -- | |
86 -- TOC entry 1851 (class 0 OID 0) | |
87 -- Dependencies: 1270 | |
88 -- Name: studyfile_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | |
89 -- | |
90 | |
91 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('studyfile', 'id'), 1, false); | |
92 | |
93 | |
94 | |
95 | |
96 | |
97 -- | |
98 -- TOC entry 1856 (class 0 OID 0) | |
99 -- Dependencies: 1302 | |
100 -- Name: usergroup_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | |
101 -- | |
102 | |
103 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('usergroup', 'id'), 1, false); | |
104 | |
105 | |
106 | |
107 -- | |
108 -- TOC entry 1859 (class 0 OID 0) | |
109 -- Dependencies: 1299 | |
110 -- Name: vdcgroup_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | |
111 -- | |
112 | |
113 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('vdcgroup', 'id'), 1, false); | |
114 | |
115 | |
116 -- | |
117 -- TOC entry 1860 (class 0 OID 0) | |
118 -- Dependencies: 1289 | |
119 -- Name: vdcnetwork_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | |
120 -- | |
121 | |
122 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('vdcnetwork', 'id'), 1, false); | |
123 | |
124 | |
125 -- | |
126 -- TOC entry 1861 (class 0 OID 0) | |
127 -- Dependencies: 1294 | |
128 -- Name: vdcuser_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | |
129 -- | |
130 | |
131 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('vdcuser', 'id'), 10, false); | |
132 | |
133 | |
134 | |
135 -- | |
136 -- TOC entry 1813 (class 0 OID 113837) | |
137 -- Dependencies: 1274 | |
138 -- Data for Name: coll_adv_search_fields; Type: TABLE DATA; Schema: public; Owner: postgres | |
139 -- | |
140 | |
141 ALTER TABLE coll_adv_search_fields DISABLE TRIGGER ALL; | |
142 | |
143 | |
144 | |
145 ALTER TABLE coll_adv_search_fields ENABLE TRIGGER ALL; | |
146 | |
147 -- | |
148 -- TOC entry 1818 (class 0 OID 113863) | |
149 -- Dependencies: 1281 | |
150 -- Data for Name: coll_any_search_fields; Type: TABLE DATA; Schema: public; Owner: postgres | |
151 -- | |
152 | |
153 ALTER TABLE coll_any_search_fields DISABLE TRIGGER ALL; | |
154 | |
155 | |
156 | |
157 ALTER TABLE coll_any_search_fields ENABLE TRIGGER ALL; | |
158 | |
159 -- | |
160 -- TOC entry 1804 (class 0 OID 113774) | |
161 -- Dependencies: 1259 | |
162 -- Data for Name: coll_search_result_fields; Type: TABLE DATA; Schema: public; Owner: postgres | |
163 -- | |
164 | |
165 ALTER TABLE coll_search_result_fields DISABLE TRIGGER ALL; | |
166 | |
167 | |
168 | |
169 ALTER TABLE coll_search_result_fields ENABLE TRIGGER ALL; | |
170 | |
171 | |
172 | |
173 | |
174 | |
175 ALTER TABLE datatable ENABLE TRIGGER ALL; | |
176 | |
177 -- | |
178 -- TOC entry 1825 (class 0 OID 113902) | |
179 -- Dependencies: 1292 | |
180 -- Data for Name: datavariable; Type: TABLE DATA; Schema: public; Owner: postgres | |
181 -- | |
182 | |
183 ALTER TABLE datavariable DISABLE TRIGGER ALL; | |
184 | |
185 | |
186 | |
187 ALTER TABLE datavariable ENABLE TRIGGER ALL; | |
188 | |
189 -- | |
190 -- TOC entry 1829 (class 0 OID 113927) | |
191 -- Dependencies: 1298 | |
192 -- Data for Name: fieldinputlevel; Type: TABLE DATA; Schema: public; Owner: postgres | |
193 -- | |
194 | |
195 ALTER TABLE fieldinputlevel DISABLE TRIGGER ALL; | |
196 | |
197 INSERT INTO fieldinputlevel (id, name ) VALUES (1, 'required'); | |
198 INSERT INTO fieldinputlevel (id, name ) VALUES(2, 'recommended'); | |
199 INSERT INTO fieldinputlevel (id, name ) VALUES(3, 'optional'); | |
200 | |
201 | |
202 | |
203 ALTER TABLE fieldinputlevel ENABLE TRIGGER ALL; | |
204 | |
205 | |
206 | |
207 -- | |
208 -- TOC entry 1823 (class 0 OID 113888) | |
209 -- Dependencies: 1288 | |
210 -- Data for Name: logindomain; Type: TABLE DATA; Schema: public; Owner: postgres | |
211 -- | |
212 | |
213 ALTER TABLE logindomain DISABLE TRIGGER ALL; | |
214 | |
215 | |
216 | |
217 ALTER TABLE logindomain ENABLE TRIGGER ALL; | |
218 | |
219 | |
220 | |
221 -- | |
222 -- TOC entry 1838 (class 0 OID 113987) | |
223 -- Dependencies: 1313 | |
224 -- Data for Name: role; Type: TABLE DATA; Schema: public; Owner: postgres | |
225 -- | |
226 | |
227 ALTER TABLE "role" DISABLE TRIGGER ALL; | |
228 INSERT into role(id, name) VALUES (1, 'contributor'); | |
229 INSERT into role(id, name) VALUES (2, 'curator'); | |
230 INSERT into role(id, name) VALUES (3, 'admin'); | |
231 INSERT into role(id,name) VALUES (4, 'privileged viewer'); | |
232 ALTER TABLE "role" ENABLE TRIGGER ALL; | |
233 | |
234 ALTER TABLE "networkrole" DISABLE TRIGGER ALL; | |
235 INSERT into networkrole(id, name) VALUES (1, 'Creator'); | |
236 INSERT into networkrole(id, name) VALUES (2, 'Admin'); | |
237 ALTER TABLE "networkrole" ENABLE TRIGGER ALL; | |
238 | |
239 ALTER TABLE pagedef DISABLE TRIGGER ALL; | |
240 | |
241 | |
242 -- Pages that don't require role authorization | |
243 INSERT INTO pagedef (name, path, role_id, networkrole_id ) VALUES ( 'StudyPage', '/study/StudyPage.xhtml', null,null ); | |
244 INSERT INTO pagedef (name, path, role_id, networkrole_id ) VALUES ( 'SubsettingPage', '/subsetting/SubsettingPage.xhtml', null,null ); | |
245 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ExploreDataPage','/viz/ExploreDataPage.xhtml',null,null ); | |
246 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ErrorPage', '/ErrorPage.xhtml', null,null ); | |
247 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'HomePage', '/HomePage.xhtml', null,null ); | |
248 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'UnauthorizedPage', '/login/UnauthorizedPage.xhtml', null,null ); | |
249 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'StudyLockedPage', '/login/StudyLockedPage.xhtml', null,null ); | |
250 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'LogoutPage', '/login/LogoutPage.xhtml', null,null ); | |
251 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'AddAccountPage', '/login/AddAccountPage.xhtml', null,null ); | |
252 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditAccountPage', '/login/EditAccountPage.xhtml', null,null ); | |
253 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'AccountOptionsPage', '/login/AccountOptionsPage.xhtml', null,null ); | |
254 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'AccountPage', '/login/AccountPage.xhtml', null,null ); | |
255 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'LoginPage', '/login/LoginPage.xhtml', null,null ); | |
256 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ForgotPasswordPage', '/login/ForgotPasswordPage.xhtml', null,null ); | |
257 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ContributorRequestPage', '/login/ContributorRequestPage.xhtml', null,null ); | |
258 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ContributorRequestInfoPage', '/login/ContributorRequestInfoPage.xhtml', null,null ); | |
259 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'CreatorRequestPage','/login/CreatorRequestPage.xhtml', null,null ); | |
260 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'CreatorRequestInfoPage','/login/CreatorRequestInfoPage.xhtml', null,null ); | |
261 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'TermsOfUsePage','/login/TermsOfUsePage.xhtml', null,null ); | |
262 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'AccountTermsOfUsePage','/login/AccountTermsOfUsePage.xhtml', null,null ); | |
263 INSERT INTO pagedef (name, path, role_id, networkrole_id ) VALUES ( 'StudyVersionDifferencesPage', '/study/StudyVersionDifferencesPage.xhtml', null,null ); | |
264 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'OptionsPage','/admin/OptionsPage.xhtml',null,null ); | |
265 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ManageStudiesPage','/study/ManageStudiesPage.xhtml',null,null ); | |
266 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ManifestPage', '/ManifestPage.xhtml', null,null ); | |
267 | |
268 -- Pages that require VDC Role authorization: | |
269 -- Contributor Role | |
270 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditStudyPage','/study/EditStudyPage.xhtml',1,null ); | |
271 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditStudyFilesPage','/study/EditStudyFilesPage.xhtml',1,null ); | |
272 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'AddFilesPage','/study/AddFilesPage.xhtml',1,null ); | |
273 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'SetUpDataExplorationPage','/study/SetUpDataExplorationPage.xhtml',1,null ); | |
274 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'DeleteStudyPage','/study/DeleteStudyPage.xhtml',1,null ); | |
275 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'MyDataversePage','/networkAdmin/MyDataversePage.xhtml',null,null ); | |
276 | |
277 -- Curator Role | |
278 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditCollectionPage','/collection/EditCollectionPage.xhtml',2,null ); | |
279 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ManageCollectionsPage','/collection/ManageCollectionsPage.xhtml',2,null ); | |
280 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'StudyPermissionsPage','/study/StudyPermissionsPage.xhtml',2,null ); | |
281 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'DeaccessionStudyPage', '/study/DeaccessionStudyPage.xhtml', 2, null ); | |
282 | |
283 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ManageTemplatesPage', '/admin/ManageTemplatesPage.xhtml', 2,2 ); | |
284 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'TemplateFormPage','/study/TemplateFormPage.xhtml',2,2 ); | |
285 | |
286 -- Admin Role | |
287 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditSitePage', '/site/EditSitePage.xhtml', 3,null ); | |
288 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditBannerFooterPage','/admin/EditBannerFooterPage.xhtml',3,2 ); | |
289 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditContactUsPage','/admin/EditContactUsPage.xhtml',3,2 ); | |
290 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditHomePanelsPage','/admin/EditHomePanelsPage.xhtml',3,null ); | |
291 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditStudyCommentsPage', '/admin/EditStudyCommentsPage.xhtml', 3,null ); | |
292 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditUserTermsPage','/admin/EditUseTermsPage.xhtml',3,null ); | |
293 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditDepositUseTermsPage','/admin/EditDepositUseTermsPage.xhtml',3,null ); | |
294 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'PrivilegedUsersPage','/admin/PrivilegedUsersPage.xhtml',3,null ); | |
295 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'SearchFieldsPage','/admin/SearchFieldsPage.xhtml',3,null ); | |
296 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'PromotionalLinkSearchBoxPage','/admin/PromotionalLinkSearchBoxPage.xhtml',3,null ); | |
297 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditLockssConfigPage','/admin/EditLockssConfigPage.xhtml',3,2 ); | |
298 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditGuestbookQuestionnairePage', '/admin/EditGuestbookQuestionnairePage.xhtml', 3,null ); | |
299 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'GuestBookResponseDataPage', '/admin/GuestBookResponseDataPage.xhtml', 3,2 ); | |
300 -- Pages that require Network Role authorization | |
301 -- Creator Role | |
302 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'AddSitePage', '/site/AddSitePage.xhtml', null,1 ); | |
303 -- Admin Role | |
304 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'NetworkOptionsPage', '/networkAdmin/NetworkOptionsPage.xhtml', null,2 ); | |
305 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'HarvestSitesPage', '/site/HarvestSitesPage.xhtml', null,2 ); | |
306 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'AddClassificationsPage', '/networkAdmin/AddClassificationsPage.xhtml', null,2 ); | |
307 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ManageClassificationsPage', '/networkAdmin/ManageClassificationsPage.xhtml', null,2 ); | |
308 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ManageControlledVocabularyPage', '/admin/ManageControlledVocabularyPage.xhtml', null,2 ); | |
309 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'CommentReviewPage', '/networkAdmin/CommentReviewPage.xhtml', null, 2 ); | |
310 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ManageDataversesPage', '/networkAdmin/ManageDataversesPage.xhtml', null,2 ); | |
311 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditHarvestSitePage', '/site/EditHarvestSitePage.xhtml', null,2 ); | |
312 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditNetworkNamePage', '/networkAdmin/EditNetworkNamePage.xhtml', null,2 ); | |
313 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'NetworkPrivilegedUsersPage', '/networkAdmin/NetworkPrivilegedUsersPage.xhtml', null,2 ); | |
314 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'AllUsersPage', '/networkAdmin/AllUsersPage.xhtml', null,2 ); | |
315 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditNetworkAnnouncementsPage', '/networkAdmin/EditNetworkAnnouncementsPage.xhtml', null,2 ); | |
316 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditNetworkBannerFooterPage', '/networkAdmin/EditNetworkBannerFooterPage.xhtml', null,2 ); | |
317 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditExportSchedulePage', '/networkAdmin/EditExportSchedulePage.xhtml', null,2 ); | |
318 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditOAISetPage', '/networkAdmin/EditOAISetPage.xhtml', null,2 ); | |
319 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditNetworkDownloadUseTermsPage', '/networkAdmin/EditNetworkDownloadUseTermsPage.xhtml', null,2 ); | |
320 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditNetworkDepositUseTermsPage', '/networkAdmin/EditNetworkDepositUseTermsPage.xhtml', null,2 ); | |
321 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditAccountUseTermsPage', '/networkAdmin/EditAccountUseTermsPage.xhtml', null,2 ); | |
322 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditUserGroupPage', '/networkAdmin/EditUserGroupPage.xhtml', null,2 ); | |
323 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'UserGroupsPage', '/networkAdmin/UserGroupsPage.xhtml', null,2 ); | |
324 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ImportStudyPage', '/networkAdmin/ImportStudyPage.xhtml', null,2 ); | |
325 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'UtilitiesPage', '/networkAdmin/UtilitiesPage.xhtml', null, 2 ); | |
326 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'EditSubnetworkPage', '/networkAdmin/EditSubnetworkPage.xhtml', null, 2 ); | |
327 INSERT INTO pagedef ( name, path, role_id, networkrole_id ) VALUES ( 'ManageSubnetworksPage', '/networkAdmin/ManageSubnetworksPage.xhtml', null, 2 ); | |
328 | |
329 ALTER TABLE pagedef ENABLE TRIGGER ALL; | |
330 | |
331 | |
332 -- | |
333 -- TOC entry 1821 (class 0 OID 113878) | |
334 -- Dependencies: 1285 | |
335 -- Data for Name: search_result_fields; Type: TABLE DATA; Schema: public; Owner: postgres | |
336 -- | |
337 | |
338 ALTER TABLE search_result_fields DISABLE TRIGGER ALL; | |
339 | |
340 | |
341 | |
342 ALTER TABLE search_result_fields ENABLE TRIGGER ALL; | |
343 | |
344 | |
345 -- | |
346 -- TOC entry 1826 (class 0 OID 113907) | |
347 -- Dependencies: 1293 | |
348 -- Data for Name: study_studyfield; Type: TABLE DATA; Schema: public; Owner: postgres | |
349 -- | |
350 | |
351 ALTER TABLE study_studyfield DISABLE TRIGGER ALL; | |
352 | |
353 | |
354 | |
355 ALTER TABLE study_studyfield ENABLE TRIGGER ALL; | |
356 | |
357 -- | |
358 -- TOC entry 1817 (class 0 OID 113859) | |
359 -- Dependencies: 1280 | |
360 -- Data for Name: study_usergroup; Type: TABLE DATA; Schema: public; Owner: postgres | |
361 -- | |
362 | |
363 ALTER TABLE study_usergroup DISABLE TRIGGER ALL; | |
364 | |
365 | |
366 | |
367 ALTER TABLE study_usergroup ENABLE TRIGGER ALL; | |
368 | |
369 -- | |
370 -- TOC entry 1812 (class 0 OID 113829) | |
371 -- Dependencies: 1273 | |
372 -- Data for Name: studyfield; Type: TABLE DATA; Schema: public; Owner: postgres | |
373 -- | |
374 | |
375 ALTER TABLE studyfield DISABLE TRIGGER ALL; | |
376 | |
377 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (1, 'Title', 'Title', 'title', TRUE, TRUE, TRUE, FALSE, TRUE ); | |
378 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (2, 'Study ID', 'Study ID', 'studyId', TRUE, TRUE, TRUE, FALSE, TRUE ); | |
379 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (3, 'Author', 'Author', 'author', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
380 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (4, 'Author Affiliation', 'Author Affiliation', 'authorAffiliation', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
381 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (5, 'Producer', 'Producer', 'producer', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
382 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (6, 'Producer URL', 'Producer URL', 'producerURL', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
383 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (7, 'URL to Producer Logo', 'URL to Producer Logo', 'producerLogo', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
384 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (8, 'Producer Name Abbreviation', 'Producer Name Abbreviation', 'producerAbbreviation', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
385 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (9, 'Production Date', 'Production Date', 'productionDate', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
386 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (10, 'Software', 'Software', 'software', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
387 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (11, 'Software Version', 'Software Version', 'softwareVersion', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
388 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (12, 'Funding Agency', 'Funding Agency', 'fundingAgency', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
389 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (13, 'Grant Number', 'Grant Number', 'grantNumber', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
390 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (14, 'Grant Number Agency', 'Grant Number Agency', 'grantNumberAgency', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
391 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (15, '', '', 'distributor', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
392 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (16, '', '', 'distributorURL', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
393 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (17, '', '', 'distributorLogo', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
394 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (18, '', '', 'distributionDate', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
395 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (19, '', '', 'distributorContact', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
396 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (20, '', '', 'distributorContactAffiliation', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
397 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (21, '', '', 'distributorContactEmail', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
398 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (22, '', '', 'depositor', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
399 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (23, '', '', 'dateOfDeposit', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
400 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (24, '', '', 'series', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
401 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (25, '', '', 'seriesInformation', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
402 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (26, '', '', 'studyVersion', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
403 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (27, '', '', 'keyword', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
404 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (28, '', '', 'keywordVocab', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
405 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (29, '', '', 'keywordVocabURI', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
406 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (30, '', '', 'topicClassification', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
407 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (31, '', '', 'topicClassVocab', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
408 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (32, '', '', 'topicClassVocabURI', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
409 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (33, '', '', 'description', FALSE, TRUE, TRUE, FALSE, TRUE ); | |
410 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (34, '', '', 'descriptionDate', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
411 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (35, '', '', 'timePeriodCoveredStart', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
412 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (36, '', '', 'timePeriodCoveredEnd', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
413 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (37, '', '', 'dateOfCollectionStart', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
414 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (38, '', '', 'dateOfCollectionEnd', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
415 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (39, '', '', 'country', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
416 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (40, '', '', 'geographicCoverage', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
417 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (41, '', '', 'geographicUnit', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
418 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (42, '', '', 'unitOfAnalysis', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
419 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (43, '', '', 'universe', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
420 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (44, '', '', 'kindOfData', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
421 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (45, '', '', 'timeMethod', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
422 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (46, '', '', 'dataCollector', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
423 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (47, '', '', 'frequencyOfDataCollection', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
424 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (48, '', '', 'samplingProcedure', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
425 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (49, '', '', 'deviationsFromSampleDesign', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
426 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (50, '', '', 'collectionMode', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
427 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (51, '', '', 'researchInstrument', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
428 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (52, '', '', 'dataSources', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
429 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (53, '', '', 'originOfSources', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
430 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (54, '', '', 'characteristicOfSources', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
431 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (55, '', '', 'accessToSources', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
432 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (56, '', '', 'dataCollectionSituation', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
433 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (57, '', '', 'actionsToMinimizeLoss', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
434 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (58, '', '', 'controlOperations', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
435 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (59, '', '', 'weighting', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
436 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (60, '', '', 'cleaningOperations', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
437 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (61, '', '', 'studyLevelErrorNotes', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
438 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (62, '', '', 'responseRate', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
439 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (63, '', '', 'samplingErrorEstimates', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
440 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (64, '', '', 'otherDataAppraisal', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
441 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (65, '', '', 'placeOfAccess', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
442 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (66, '', '', 'originalArchive', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
443 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (67, '', '', 'availabilityStatus', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
444 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (68, '', '', 'collectionSize', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
445 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (69, '', '', 'studyCompletion', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
446 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (70, '', '', 'confidentialityDeclaration', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
447 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (71, '', '', 'specialPermissions', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
448 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (72, '', '', 'restrictions', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
449 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (73, '', '', 'contact', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
450 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (74, '', '', 'citationRequirements', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
451 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (75, '', '', 'depositorRequirements', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
452 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (76, '', '', 'conditions', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
453 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (77, '', '', 'disclaimer', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
454 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (78, '', '', 'relatedMaterial', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
455 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (79, '', '', 'publication', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
456 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (80, '', '', 'relatedStudies', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
457 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (81, '', '', 'otherReferences', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
458 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (82, '', '', 'notesText', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
459 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (83, '', '', 'note', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
460 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (84, '', '', 'notesInformationSubject', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
461 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (85, '', '', 'otherId', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
462 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (86, '', '', 'otherIdAgency', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
463 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (87, '', '', 'productionPlace', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
464 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (88, '', '', 'numberOfFiles', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
465 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (89, '', '', 'publicationReplicationData', FALSE, TRUE, FALSE, FALSE, FALSE ); | |
466 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (90, '', '', 'subTitle', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
467 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (91, '', '', 'versionDate', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
468 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (92, '', '', 'geographicBoundingBox', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
469 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (93, '', '', 'eastLongitude', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
470 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (94, '', '', 'northLatitude', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
471 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (95, '', '', 'southLatitude', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
472 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (96, '', '', 'producerAffiliation', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
473 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (97, '', '', 'distributorAffiliation', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
474 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (98, '', '', 'distributorAbbreviation', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
475 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (99, 'Author', 'Author', 'authorName', TRUE, TRUE, TRUE, FALSE, TRUE ); | |
476 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (100, '', '', 'producerName', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
477 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (101, '', '', 'distributorName', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
478 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (102, '', '', 'distributorContactName', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
479 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (103, '', '', 'descriptionText', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
480 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (104, '', '', 'keywordValue', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
481 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (105, '', '', 'topicClassValue', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
482 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (106, '', '', 'otherIdValue', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
483 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (107, '', '', 'softwareName', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
484 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (108, '', '', 'grantNumberValue', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
485 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (109, '', '', 'seriesName', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
486 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (110, '', '', 'studyVersionValue', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
487 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (111, '', '', 'westLongitude', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
488 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (112, '', '', 'noteInformationType', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
489 | |
490 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (113, '', '', 'publicationCitation', FALSE, TRUE, FALSE, FALSE, TRUE ); | |
491 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (114, '', '', 'publicationIDType', FALSE, FALSE, FALSE, FALSE, FALSE ); | |
492 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (115, '', '', 'publicationIDNumber', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
493 INSERT INTO studyfield (id,title,description, name,basicSearchField,advancedSearchField, searchResultField, customField, allowControlledVocabulary) VALUES (116, '', '', 'publicationURL', FALSE, FALSE, FALSE, FALSE, TRUE ); | |
494 | |
495 --set the parent child relationship | |
496 update studyfield set parentstudyfield_id = 3 where id = 99; | |
497 update studyfield set parentstudyfield_id = 3 where id = 4; | |
498 | |
499 update studyfield set parentstudyfield_id = 5 where id = 100; | |
500 update studyfield set parentstudyfield_id = 5 where id = 6; | |
501 update studyfield set parentstudyfield_id = 5 where id = 7; | |
502 update studyfield set parentstudyfield_id = 5 where id = 8; | |
503 update studyfield set parentstudyfield_id = 5 where id = 96; | |
504 | |
505 update studyfield set parentstudyfield_id = 15 where id = 101; | |
506 update studyfield set parentstudyfield_id = 15 where id = 16; | |
507 update studyfield set parentstudyfield_id = 15 where id = 17; | |
508 update studyfield set parentstudyfield_id = 15 where id = 97; | |
509 update studyfield set parentstudyfield_id = 15 where id = 98; | |
510 | |
511 update studyfield set parentstudyfield_id = 19 where id = 102; | |
512 update studyfield set parentstudyfield_id = 19 where id = 20; | |
513 update studyfield set parentstudyfield_id = 19 where id = 21; | |
514 | |
515 update studyfield set parentstudyfield_id = 33 where id = 103; | |
516 update studyfield set parentstudyfield_id = 33 where id = 34; | |
517 | |
518 update studyfield set parentstudyfield_id = 27 where id = 104; | |
519 update studyfield set parentstudyfield_id = 27 where id = 28; | |
520 update studyfield set parentstudyfield_id = 27 where id = 29; | |
521 | |
522 update studyfield set parentstudyfield_id = 30 where id = 105; | |
523 update studyfield set parentstudyfield_id = 30 where id = 31; | |
524 update studyfield set parentstudyfield_id = 30 where id = 32; | |
525 | |
526 update studyfield set parentstudyfield_id = 85 where id = 106; | |
527 update studyfield set parentstudyfield_id = 85 where id = 86; | |
528 | |
529 update studyfield set parentstudyfield_id = 10 where id = 107; | |
530 update studyfield set parentstudyfield_id = 10 where id = 11; | |
531 | |
532 update studyfield set parentstudyfield_id = 13 where id = 108; | |
533 update studyfield set parentstudyfield_id = 13 where id = 14; | |
534 | |
535 update studyfield set parentstudyfield_id = 24 where id = 109; | |
536 update studyfield set parentstudyfield_id = 24 where id = 25; | |
537 | |
538 update studyfield set parentstudyfield_id = 26 where id = 110; | |
539 update studyfield set parentstudyfield_id = 26 where id = 91; | |
540 | |
541 update studyfield set parentstudyfield_id = 92 where id = 111; | |
542 update studyfield set parentstudyfield_id = 92 where id = 93; | |
543 update studyfield set parentstudyfield_id = 92 where id = 94; | |
544 update studyfield set parentstudyfield_id = 92 where id = 95; | |
545 | |
546 update studyfield set parentstudyfield_id = 83 where id = 112; | |
547 update studyfield set parentstudyfield_id = 83 where id = 82; | |
548 update studyfield set parentstudyfield_id = 83 where id = 84; | |
549 | |
550 update studyfield set parentstudyfield_id = 79 where id = 113; | |
551 update studyfield set parentstudyfield_id = 79 where id = 114; | |
552 update studyfield set parentstudyfield_id = 79 where id = 115; | |
553 update studyfield set parentstudyfield_id = 79 where id = 116; | |
554 update studyfield set parentstudyfield_id = 79 where id = 89; | |
555 | |
556 update studyfield set displayorder = 0 where name = 'authorName'; | |
557 update studyfield set displayorder = 2 where name = 'authorAffiliation'; | |
558 update studyfield set displayorder = 2 where name = 'producerAbbreviation'; | |
559 update studyfield set displayorder = 1 where name = 'producerName'; | |
560 update studyfield set displayorder = 3 where name = 'producerAffiliation'; | |
561 update studyfield set displayorder = 4 where name = 'producerURL'; | |
562 update studyfield set displayorder = 5 where name = 'producerLogo'; | |
563 update studyfield set displayorder = 2 where name = 'softwareVersion'; | |
564 update studyfield set displayorder = 1 where name = 'softwareName'; | |
565 update studyfield set displayorder = 1 where name = 'grantNumberValue'; | |
566 update studyfield set displayorder = 2 where name = 'grantNumberAgency'; | |
567 update studyfield set displayorder = 1 where name = 'distributorName'; | |
568 update studyfield set displayorder = 4 where name = 'distributorURL'; | |
569 update studyfield set displayorder = 5 where name = 'distributorLogo'; | |
570 update studyfield set displayorder = 3 where name = 'distributorAffiliation'; | |
571 update studyfield set displayorder = 2 where name = 'distributorAbbreviation'; | |
572 update studyfield set displayorder = 1 where name = 'distributorContactName'; | |
573 update studyfield set displayorder = 2 where name = 'distributorContactAffiliation'; | |
574 update studyfield set displayorder = 3 where name = 'distributorContactEmail'; | |
575 update studyfield set displayorder = 2 where name = 'seriesInformation'; | |
576 update studyfield set displayorder = 1 where name = 'seriesName'; | |
577 update studyfield set displayorder = 1 where name = 'studyVersionValue'; | |
578 update studyfield set displayorder = 2 where name = 'versionDate'; | |
579 update studyfield set displayorder = 1 where name = 'keywordValue'; | |
580 update studyfield set displayorder = 3 where name = 'keywordVocabURI'; | |
581 update studyfield set displayorder = 2 where name = 'keywordVocab'; | |
582 update studyfield set displayorder = 1 where name = 'topicClassValue'; | |
583 update studyfield set displayorder = 2 where name = 'topicClassVocab'; | |
584 update studyfield set displayorder = 3 where name = 'topicClassVocabURI'; | |
585 update studyfield set displayorder = 1 where name = 'descriptionText'; | |
586 update studyfield set displayorder = 2 where name = 'descriptionDate'; | |
587 update studyfield set displayorder = 1 where name = 'publicationCitation'; | |
588 update studyfield set displayorder = 2 where name = 'publicationIDNumber'; | |
589 update studyfield set displayorder = 3 where name = 'publicationURL'; | |
590 update studyfield set displayorder = 3 where name = 'notesText'; | |
591 update studyfield set displayorder = 1 where name = 'noteInformationType'; | |
592 update studyfield set displayorder = 2 where name = 'notesInformationSubject'; | |
593 update studyfield set displayorder = 2 where name = 'otherIdAgency'; | |
594 update studyfield set displayorder = 1 where name = 'otherIdValue'; | |
595 | |
596 | |
597 update studyfield set fieldtype = 'date' where id = 9; | |
598 update studyfield set fieldtype = 'date' where id = 18; | |
599 update studyfield set fieldtype = 'date' where id = 23; | |
600 update studyfield set fieldtype = 'date' where id = 34; | |
601 update studyfield set fieldtype = 'date' where id = 35; | |
602 update studyfield set fieldtype = 'date' where id = 36; | |
603 update studyfield set fieldtype = 'date' where id = 37; | |
604 update studyfield set fieldtype = 'date' where id = 38; | |
605 update studyfield set fieldtype = 'date' where id = 91; | |
606 update studyfield set fieldtype = 'email' where id = 21; | |
607 update studyfield set fieldtype = 'textBox' where id = 4; | |
608 update studyfield set fieldtype = 'textBox' where id = 8; | |
609 update studyfield set fieldtype = 'textBox' where id = 11; | |
610 update studyfield set fieldtype = 'textBox' where id = 12; | |
611 update studyfield set fieldtype = 'textBox' where id = 13; | |
612 update studyfield set fieldtype = 'textBox' where id = 14; | |
613 update studyfield set fieldtype = 'textBox' where id = 19; | |
614 update studyfield set fieldtype = 'textBox' where id = 20; | |
615 update studyfield set fieldtype = 'textBox' where id = 22; | |
616 update studyfield set fieldtype = 'textBox' where id = 24; | |
617 update studyfield set fieldtype = 'textBox' where id = 25; | |
618 update studyfield set fieldtype = 'textBox' where id = 26; | |
619 update studyfield set fieldtype = 'textBox' where id = 27; | |
620 update studyfield set fieldtype = 'textBox' where id = 28; | |
621 update studyfield set fieldtype = 'textBox' where id = 30; | |
622 update studyfield set fieldtype = 'textBox' where id = 31; | |
623 update studyfield set fieldtype = 'textBox' where id = 33; | |
624 update studyfield set fieldtype = 'textBox' where id = 39; | |
625 update studyfield set fieldtype = 'textBox' where id = 40; | |
626 update studyfield set fieldtype = 'textBox' where id = 41; | |
627 update studyfield set fieldtype = 'textBox' where id = 42; | |
628 update studyfield set fieldtype = 'textBox' where id = 43; | |
629 update studyfield set fieldtype = 'textBox' where id = 44; | |
630 update studyfield set fieldtype = 'textBox' where id = 45; | |
631 update studyfield set fieldtype = 'textBox' where id = 46; | |
632 update studyfield set fieldtype = 'textBox' where id = 47; | |
633 update studyfield set fieldtype = 'textBox' where id = 48; | |
634 update studyfield set fieldtype = 'textBox' where id = 49; | |
635 update studyfield set fieldtype = 'textBox' where id = 50; | |
636 update studyfield set fieldtype = 'textBox' where id = 51; | |
637 update studyfield set fieldtype = 'textBox' where id = 52; | |
638 update studyfield set fieldtype = 'textBox' where id = 53; | |
639 update studyfield set fieldtype = 'textBox' where id = 54; | |
640 update studyfield set fieldtype = 'textBox' where id = 55; | |
641 update studyfield set fieldtype = 'textBox' where id = 56; | |
642 update studyfield set fieldtype = 'textBox' where id = 57; | |
643 update studyfield set fieldtype = 'textBox' where id = 58; | |
644 update studyfield set fieldtype = 'textBox' where id = 59; | |
645 update studyfield set fieldtype = 'textBox' where id = 60; | |
646 update studyfield set fieldtype = 'textBox' where id = 61; | |
647 update studyfield set fieldtype = 'textBox' where id = 62; | |
648 update studyfield set fieldtype = 'textBox' where id = 63; | |
649 update studyfield set fieldtype = 'textBox' where id = 64; | |
650 update studyfield set fieldtype = 'textBox' where id = 65; | |
651 update studyfield set fieldtype = 'textBox' where id = 66; | |
652 update studyfield set fieldtype = 'textBox' where id = 67; | |
653 update studyfield set fieldtype = 'textBox' where id = 68; | |
654 update studyfield set fieldtype = 'textBox' where id = 69; | |
655 update studyfield set fieldtype = 'textBox' where id = 70; | |
656 update studyfield set fieldtype = 'textBox' where id = 71; | |
657 update studyfield set fieldtype = 'textBox' where id = 72; | |
658 update studyfield set fieldtype = 'textBox' where id = 73; | |
659 update studyfield set fieldtype = 'textBox' where id = 74; | |
660 update studyfield set fieldtype = 'textBox' where id = 75; | |
661 update studyfield set fieldtype = 'textBox' where id = 76; | |
662 update studyfield set fieldtype = 'textBox' where id = 77; | |
663 update studyfield set fieldtype = 'textBox' where id = 78; | |
664 update studyfield set fieldtype = 'textBox' where id = 79; | |
665 update studyfield set fieldtype = 'textBox' where id = 80; | |
666 update studyfield set fieldtype = 'textBox' where id = 81; | |
667 update studyfield set fieldtype = 'textBox' where id = 82; | |
668 update studyfield set fieldtype = 'textBox' where id = 83; | |
669 update studyfield set fieldtype = 'textBox' where id = 84; | |
670 update studyfield set fieldtype = 'textBox' where id = 85; | |
671 update studyfield set fieldtype = 'textBox' where id = 86; | |
672 update studyfield set fieldtype = 'textBox' where id = 87; | |
673 update studyfield set fieldtype = 'textBox' where id = 88; | |
674 update studyfield set fieldtype = 'textBox' where id = 89; | |
675 update studyfield set fieldtype = 'textBox' where id = 92; | |
676 update studyfield set fieldtype = 'textBox' where id = 96; | |
677 update studyfield set fieldtype = 'textBox' where id = 97; | |
678 update studyfield set fieldtype = 'textBox' where id = 98; | |
679 update studyfield set fieldtype = 'textBox' where id = 99; | |
680 update studyfield set fieldtype = 'textBox' where id = 100; | |
681 update studyfield set fieldtype = 'textBox' where id = 101; | |
682 update studyfield set fieldtype = 'textBox' where id = 102; | |
683 update studyfield set fieldtype = 'textBox' where id = 103; | |
684 update studyfield set fieldtype = 'textBox' where id = 104; | |
685 update studyfield set fieldtype = 'textBox' where id = 105; | |
686 update studyfield set fieldtype = 'textBox' where id = 106; | |
687 update studyfield set fieldtype = 'textBox' where id = 107; | |
688 update studyfield set fieldtype = 'textBox' where id = 108; | |
689 update studyfield set fieldtype = 'textBox' where id = 109; | |
690 update studyfield set fieldtype = 'textBox' where id = 110; | |
691 update studyfield set fieldtype = 'textBox' where id = 112; | |
692 update studyfield set fieldtype = 'textBox' where id = 113; | |
693 update studyfield set fieldtype = 'textBox' where id = 115; | |
694 update studyfield set fieldtype = 'url' where id = 6; | |
695 update studyfield set fieldtype = 'url' where id = 7; | |
696 update studyfield set fieldtype = 'url' where id = 16; | |
697 update studyfield set fieldtype = 'url' where id = 17; | |
698 update studyfield set fieldtype = 'url' where id = 29; | |
699 update studyfield set fieldtype = 'url' where id = 32; | |
700 update studyfield set fieldtype = 'url' where id = 116; | |
701 | |
702 ALTER TABLE studyfield ENABLE TRIGGER ALL; | |
703 | |
704 | |
705 | |
706 | |
707 | |
708 -- | |
709 -- TOC entry 1811 (class 0 OID 113819) | |
710 -- Dependencies: 1271 | |
711 -- Data for Name: studyfile; Type: TABLE DATA; Schema: public; Owner: postgres | |
712 -- | |
713 | |
714 ALTER TABLE studyfile DISABLE TRIGGER ALL; | |
715 | |
716 | |
717 | |
718 ALTER TABLE studyfile ENABLE TRIGGER ALL; | |
719 | |
720 -- | |
721 -- TOC entry 1810 (class 0 OID 113813) | |
722 -- Dependencies: 1269 | |
723 -- Data for Name: studyfile_usergroup; Type: TABLE DATA; Schema: public; Owner: postgres | |
724 -- | |
725 | |
726 ALTER TABLE studyfile_usergroup DISABLE TRIGGER ALL; | |
727 | |
728 | |
729 | |
730 ALTER TABLE studyfile_usergroup ENABLE TRIGGER ALL; | |
731 | |
732 -- | |
733 -- TOC entry 1835 (class 0 OID 113964) | |
734 -- Dependencies: 1307 | |
735 -- Data for Name: summary_fields; Type: TABLE DATA; Schema: public; Owner: postgres | |
736 -- | |
737 | |
738 ALTER TABLE summary_fields DISABLE TRIGGER ALL; | |
739 | |
740 | |
741 | |
742 ALTER TABLE summary_fields ENABLE TRIGGER ALL; | |
743 | |
744 -- | |
745 -- TOC entry 1809 (class 0 OID 113808) | |
746 -- Dependencies: 1268 | |
747 -- Data for Name: template; Type: TABLE DATA; Schema: public; Owner: postgres | |
748 -- | |
749 | |
750 ALTER TABLE "template" DISABLE TRIGGER ALL; | |
751 | |
752 | |
753 | |
754 ALTER TABLE "template" ENABLE TRIGGER ALL; | |
755 | |
756 -- | |
757 -- TOC entry 1807 (class 0 OID 113797) | |
758 -- Dependencies: 1265 | |
759 -- Data for Name: templatefield; Type: TABLE DATA; Schema: public; Owner: postgres | |
760 -- | |
761 | |
762 ALTER TABLE templatefield DISABLE TRIGGER ALL; | |
763 | |
764 | |
765 | |
766 ALTER TABLE templatefield ENABLE TRIGGER ALL; | |
767 | |
768 -- | |
769 -- TOC entry 1832 (class 0 OID 113945) | |
770 -- Dependencies: 1303 | |
771 -- Data for Name: usergroup; Type: TABLE DATA; Schema: public; Owner: postgres | |
772 -- | |
773 | |
774 ALTER TABLE usergroup DISABLE TRIGGER ALL; | |
775 | |
776 | |
777 | |
778 ALTER TABLE usergroup ENABLE TRIGGER ALL; | |
779 | |
780 | |
781 -- | |
782 -- TOC entry 1831 (class 0 OID 113939) | |
783 -- Dependencies: 1301 | |
784 -- Data for Name: vdc_adv_search_fields; Type: TABLE DATA; Schema: public; Owner: postgres | |
785 -- | |
786 | |
787 ALTER TABLE vdc_adv_search_fields DISABLE TRIGGER ALL; | |
788 | |
789 | |
790 | |
791 ALTER TABLE vdc_adv_search_fields ENABLE TRIGGER ALL; | |
792 | |
793 -- | |
794 -- TOC entry 1801 (class 0 OID 113756) | |
795 -- Dependencies: 1255 | |
796 -- Data for Name: vdc_any_search_fields; Type: TABLE DATA; Schema: public; Owner: postgres | |
797 -- | |
798 | |
799 ALTER TABLE vdc_any_search_fields DISABLE TRIGGER ALL; | |
800 | |
801 | |
802 | |
803 ALTER TABLE vdc_any_search_fields ENABLE TRIGGER ALL; | |
804 | |
805 | |
806 -- | |
807 -- TOC entry 1808 (class 0 OID 113802) | |
808 -- Dependencies: 1266 | |
809 -- Data for Name: vdc_usergroup; Type: TABLE DATA; Schema: public; Owner: postgres | |
810 -- | |
811 | |
812 ALTER TABLE vdc_usergroup DISABLE TRIGGER ALL; | |
813 | |
814 | |
815 | |
816 ALTER TABLE vdc_usergroup ENABLE TRIGGER ALL; | |
817 | |
818 | |
819 -- | |
820 -- TOC entry 1830 (class 0 OID 113934) | |
821 -- Dependencies: 1300 | |
822 -- Data for Name: vdcgroup; Type: TABLE DATA; Schema: public; Owner: postgres | |
823 -- | |
824 | |
825 ALTER TABLE vdcgroup DISABLE TRIGGER ALL; | |
826 | |
827 | |
828 | |
829 ALTER TABLE vdcgroup ENABLE TRIGGER ALL; | |
830 | |
831 -- | |
832 -- TOC entry 1828 (class 0 OID 113921) | |
833 -- Dependencies: 1296 | |
834 -- Data for Name: vdcgrouprelationship; Type: TABLE DATA; Schema: public; Owner: postgres | |
835 -- | |
836 | |
837 ALTER TABLE vdcgrouprelationship DISABLE TRIGGER ALL; | |
838 | |
839 | |
840 | |
841 ALTER TABLE vdcgrouprelationship ENABLE TRIGGER ALL; | |
842 | |
843 | |
844 | |
845 | |
846 | |
847 -- | |
848 -- TOC entry 1827 (class 0 OID 113913) | |
849 -- Dependencies: 1295 | |
850 -- Data for Name: vdcuser; Type: TABLE DATA; Schema: public; Owner: postgres | |
851 -- | |
852 | |
853 ALTER TABLE vdcuser DISABLE TRIGGER ALL; | |
854 | |
855 | |
856 | |
857 ALTER TABLE vdcuser ENABLE TRIGGER ALL; | |
858 | |
859 -- | |
860 -- TOC entry 1834 (class 0 OID 113960) | |
861 -- Dependencies: 1306 | |
862 -- Data for Name: vdcuser_usergroup; Type: TABLE DATA; Schema: public; Owner: postgres | |
863 -- | |
864 | |
865 ALTER TABLE vdcuser_usergroup DISABLE TRIGGER ALL; | |
866 | |
867 | |
868 | |
869 ALTER TABLE vdcuser_usergroup ENABLE TRIGGER ALL; | |
870 | |
871 | |
872 ALTER TABLE variableintervaltype DISABLE TRIGGER ALL; | |
873 | |
874 INSERT INTO variableintervaltype (id, name ) VALUES (1, 'discrete'); | |
875 INSERT INTO variableintervaltype (id, name ) VALUES(2, 'continuous'); | |
876 INSERT INTO variableintervaltype (id, name ) VALUES(3, 'nominal'); | |
877 INSERT INTO variableintervaltype (id, name ) VALUES(4, 'dichotomous'); | |
878 | |
879 ALTER TABLE variableintervaltype ENABLE TRIGGER ALL; | |
880 | |
881 | |
882 ALTER TABLE variableformattype DISABLE TRIGGER ALL; | |
883 | |
884 INSERT INTO variableformattype (id, name ) VALUES (1, 'numeric'); | |
885 INSERT INTO variableformattype (id, name ) VALUES(2, 'character'); | |
886 | |
887 ALTER TABLE variableformattype ENABLE TRIGGER ALL; | |
888 | |
889 | |
890 ALTER TABLE variablerangetype DISABLE TRIGGER ALL; | |
891 | |
892 INSERT INTO variablerangetype (id, name ) VALUES(1, 'min'); | |
893 INSERT INTO variablerangetype (id, name ) VALUES(2, 'max'); | |
894 INSERT INTO variablerangetype (id, name ) VALUES(3, 'min exclusive'); | |
895 INSERT INTO variablerangetype (id, name ) VALUES(4, 'max exclusive'); | |
896 INSERT INTO variablerangetype (id, name ) VALUES(5, 'point'); | |
897 | |
898 ALTER TABLE variablerangetype ENABLE TRIGGER ALL; | |
899 | |
900 ALTER TABLE summarystatistictype DISABLE TRIGGER ALL; | |
901 | |
902 INSERT INTO summarystatistictype (id, name ) VALUES(1, 'mean'); | |
903 INSERT INTO summarystatistictype (id, name ) VALUES(2, 'medn'); | |
904 INSERT INTO summarystatistictype (id, name ) VALUES(3, 'mode'); | |
905 INSERT INTO summarystatistictype (id, name ) VALUES(4, 'min'); | |
906 INSERT INTO summarystatistictype (id, name ) VALUES(5, 'max'); | |
907 INSERT INTO summarystatistictype (id, name ) VALUES(6, 'stdev'); | |
908 INSERT INTO summarystatistictype (id, name ) VALUES(7, 'vald'); | |
909 INSERT INTO summarystatistictype (id, name ) VALUES(8, 'invd'); | |
910 | |
911 ALTER TABLE variablerangetype ENABLE TRIGGER ALL; | |
912 | |
913 ALTER TABLE vdcuser DISABLE TRIGGER ALL; | |
914 | |
915 insert into vdcuser(id, version, email, firstname, lastname, username, encryptedpassword, networkRole_id,active, agreedtermsofuse ) VALUES ( 1, 1, 'dataverse@lists.hmdc.harvard.edu','Network','Admin', 'networkAdmin' ,'tf0bLmzOFx5JrBhe2EIraS5GBnI=' ,2,true, true); | |
916 | |
917 ALTER TABLE vdcuser ENABLE TRIGGER ALL; | |
918 | |
919 -- | |
920 -- TOC entry 1809 (class 0 OID 113808) | |
921 -- Dependencies: 1268 | |
922 -- Data for Name: template; Type: TABLE DATA; Schema: public; Owner: postgres | |
923 -- | |
924 | |
925 ALTER TABLE "metadata" DISABLE TRIGGER ALL; | |
926 -- Default metadata - contains no metadata values | |
927 INSERT INTO metadata( id, version ) VALUES ( 1, 1); | |
928 | |
929 ALTER TABLE "metadata" ENABLE TRIGGER ALL; | |
930 | |
931 | |
932 ALTER TABLE "template" DISABLE TRIGGER ALL; | |
933 | |
934 INSERT INTO template( id, version, vdcnetwork_id, name,metadata_id,enabled) VALUES (1, 1, 0, 'Dataverse Network Default Template',1,true); | |
935 | |
936 ALTER TABLE "template" ENABLE TRIGGER ALL; | |
937 | |
938 -- | |
939 -- TOC entry 1824 (class 0 OID 113895) | |
940 -- Dependencies: 1290 | |
941 -- Data for Name: vdcnetwork; Type: TABLE DATA; Schema: public; Owner: postgres | |
942 -- | |
943 | |
944 ALTER TABLE vdcnetwork DISABLE TRIGGER ALL; | |
945 | |
946 INSERT INTO vdcnetwork (id, version, name, networkpageheader, networkpagefooter, announcements, displayannouncements, aboutthisdataversenetwork, contactemail, systememail, defaultvdcheader, defaultvdcfooter, defaultvdcabouttext, defaultvdcannouncements, displayvdcannouncements, displayvdcrecentstudies, defaulttemplate_id, allowcreaterequest, defaultnetworkadmin_id,protocol,authority,handleregistration,termsofuseenabled, deposittermsofuseenabled, downloadtermsofuseenabled, defaultdisplaynumber, exportperiod, exporthourofday) VALUES (0, 1, '[Your]', ' ', ' ', 'A description of your Dataverse Network or announcements may be added here. Use Network Options to edit or remove this text.', TRUE, 'This About page is not used anymore in the DVN application.', 'dataverse@lists.hmdc.harvard.edu','dataverse@lists.hmdc.harvard.edu', ' ', ' ', 'This About page is not used anymore in the DVN application.', '', TRUE, TRUE, 1, FALSE,1,'hdl','TEST',false,false,false,false,16,'daily',3); | |
947 | |
948 update vdcnetwork set defaultvdcheader='<style type="text/css"> | |
949 body {margin:0; padding:0;} | |
950 </style> | |
951 <div style="width:100%; height:40px; background: url(/dvn/resources/images/customizationpattern.png) repeat-x left -35px #698DA2;"></div> | |
952 <div style="margin:0 auto; max-width:1000px;">'; | |
953 | |
954 update vdcnetwork set defaultvdcfooter='</div>'; | |
955 | |
956 | |
957 | |
958 update vdcnetwork set requireDVDescription = false, | |
959 requireDVaffiliation = false, | |
960 requireDVclassification = false, | |
961 requireDVstudiesforrelease = false; | |
962 | |
963 ALTER TABLE vdcnetwork ENABLE TRIGGER ALL; | |
964 | |
965 | |
966 -- | |
967 -- TOC entry 1807 (class 0 OID 113797) | |
968 -- Dependencies: 1265 | |
969 -- Data for Name: templatefield; Type: TABLE DATA; Schema: public; Owner: postgres | |
970 -- | |
971 | |
972 ALTER TABLE templatefield DISABLE TRIGGER ALL; | |
973 | |
974 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(1,1,1,1,'required',-1); | |
975 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(2,1,1,2,'required',-1); | |
976 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(3,1,1,3,'recommended',-1); | |
977 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(4,1,1,4,'optional',-1); | |
978 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(5,1,1,5,'recommended',-1); | |
979 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(6,1,1,6,'optional',-1); | |
980 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(7,1,1,7,'optional',-1); | |
981 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(8,1,1,8,'optional',-1); | |
982 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(9,1,1,9,'recommended',-1); | |
983 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(10,1,1,10,'optional',-1); | |
984 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(11,1,1,11,'optional',-1); | |
985 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(12,1,1,12,'optional',-1); | |
986 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(13,1,1,13,'optional',-1); | |
987 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(14,1,1,14,'optional',-1); | |
988 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(15,1,1,15,'recommended',-1); | |
989 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(16,1,1,16,'optional',-1); | |
990 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(17,1,1,17,'optional',-1); | |
991 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(18,1,1,18,'recommended',-1); | |
992 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(19,1,1,19,'recommended',-1); | |
993 | |
994 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(20,1,1,20,'optional',-1); | |
995 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(21,1,1,21,'recommended',-1); | |
996 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(22,1,1,22,'optional',-1); | |
997 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(23,1,1,23,'recommended',-1); | |
998 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(24,1,1,24,'optional',-1); | |
999 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(25,1,1,25,'optional',-1); | |
1000 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(26,1,1,26,'optional',-1); | |
1001 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(27,1,1,27,'recommended',-1); | |
1002 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(28,1,1,28,'optional',-1); | |
1003 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(29,1,1,29,'optional',-1); | |
1004 | |
1005 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(30,1,1,30,'recommended',-1); | |
1006 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(31,1,1,31,'optional',-1); | |
1007 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(32,1,1,32,'optional',-1); | |
1008 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(33,1,1,33,'recommended',-1); | |
1009 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(34,1,1,34,'optional',-1); | |
1010 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(35,1,1,35,'recommended',-1); | |
1011 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(36,1,1,36,'recommended',-1); | |
1012 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(37,1,1,37,'recommended',-1); | |
1013 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(38,1,1,38,'recommended',-1); | |
1014 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(39,1,1,39,'recommended',-1); | |
1015 | |
1016 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(40,1,1,40,'recommended',-1); | |
1017 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(41,1,1,41,'recommended',-1); | |
1018 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(42,1,1,42,'optional',-1); | |
1019 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(43,1,1,43,'recommended',-1); | |
1020 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(44,1,1,44,'recommended',-1); | |
1021 | |
1022 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(45,1,1,45,'optional',-1); | |
1023 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(46,1,1,46,'optional',-1); | |
1024 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(47,1,1,47,'optional',-1); | |
1025 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(48,1,1,48,'optional',-1); | |
1026 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(49,1,1,49,'optional',-1); | |
1027 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(50,1,1,50,'optional',-1); | |
1028 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(51,1,1,51,'optional',-1); | |
1029 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(52,1,1,52,'optional',-1); | |
1030 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(53,1,1,53,'optional',-1); | |
1031 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(54,1,1,54,'optional',-1); | |
1032 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(55,1,1,55,'optional',-1); | |
1033 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(56,1,1,56,'optional',-1); | |
1034 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(57,1,1,57,'optional',-1); | |
1035 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(58,1,1,58,'optional',-1); | |
1036 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(59,1,1,59,'optional',-1); | |
1037 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(60,1,1,60,'optional',-1); | |
1038 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(61,1,1,61,'optional',-1); | |
1039 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(62,1,1,62,'optional',-1); | |
1040 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(63,1,1,63,'optional',-1); | |
1041 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(64,1,1,64,'optional',-1); | |
1042 | |
1043 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(65,1,1,65,'optional',-1); | |
1044 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(66,1,1,66,'optional',-1); | |
1045 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(67,1,1,67,'optional',-1); | |
1046 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(68,1,1,68,'optional',-1); | |
1047 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(69,1,1,69,'optional',-1); | |
1048 | |
1049 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(70,1,1,70,'optional',-1); | |
1050 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(71,1,1,71,'optional',-1); | |
1051 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(72,1,1,72,'optional',-1); | |
1052 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(73,1,1,73,'optional',-1); | |
1053 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(74,1,1,74,'optional',-1); | |
1054 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(75,1,1,75,'optional',-1); | |
1055 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(76,1,1,76,'optional',-1); | |
1056 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(77,1,1,77,'optional',-1); | |
1057 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(78,1,1,78,'recommended',-1); | |
1058 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(79,1,1,79,'recommended',-1); | |
1059 | |
1060 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(80,1,1,80,'recommended',-1); | |
1061 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(81,1,1,81,'optional',-1); | |
1062 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(82,1,1,82,'optional',-1); | |
1063 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(83,1,1,83,'optional',-1); | |
1064 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(84,1,1,84,'optional',-1); | |
1065 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(85,1,1,85,'optional',-1); | |
1066 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(86,1,1,86,'optional',-1); | |
1067 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(87,1,1,87,'optional',-1); | |
1068 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(88,1,1,88,'optional',-1); | |
1069 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(89,1,1,89,'optional',-1); | |
1070 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(90,1,1,90,'optional',-1); | |
1071 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(91,1,1,91,'optional',-1); | |
1072 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(92,1,1,92,'optional',-1); | |
1073 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(93,1,1,93,'optional',-1); | |
1074 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(94,1,1,94,'optional',-1); | |
1075 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(95,1,1,95,'optional',-1); | |
1076 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(96,1,1,96,'optional',-1); | |
1077 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(97,1,1,97,'optional',-1); | |
1078 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(98,1,1,98,'optional',-1); | |
1079 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(99,1,1,99,'optional',-1); | |
1080 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(100,1,1,100,'optional',-1); | |
1081 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(101,1,1,101,'optional',-1); | |
1082 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(102,1,1,102,'optional',-1); | |
1083 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(103,1,1,103,'optional',-1); | |
1084 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(104,1,1,104,'optional',-1); | |
1085 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(105,1,1,105,'optional',-1); | |
1086 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(106,1,1,106,'optional',-1); | |
1087 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(107,1,1,107,'optional',-1); | |
1088 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(108,1,1,108,'optional',-1); | |
1089 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(109,1,1,109,'optional',-1); | |
1090 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(110,1,1,110,'optional',-1); | |
1091 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(111,1,1,111,'optional',-1); | |
1092 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(112,1,1,112,'optional',-1); | |
1093 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(113,1,1,113,'optional',-1); | |
1094 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(114,1,1,114,'optional',-1); | |
1095 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(115,1,1,115,'optional',-1); | |
1096 INSERT INTO templatefield(id, version, template_id, studyfield_id, fieldinputlevelstring, displayorder) VALUES(116,1,1,116,'optional',-1); | |
1097 | |
1098 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('templatefield', 'id'), 150, false); | |
1099 | |
1100 | |
1101 ALTER TABLE templatefield ENABLE TRIGGER ALL; | |
1102 | |
1103 | |
1104 | |
1105 -- | |
1106 -- TOC entry 1814 (class 0 OID 113843) | |
1107 -- Dependencies: 1276 | |
1108 -- Data for Name: templatefilecategory; Type: TABLE DATA; Schema: public; Owner: postgres | |
1109 -- | |
1110 | |
1111 ALTER TABLE templatefilecategory DISABLE TRIGGER ALL; | |
1112 | |
1113 INSERT INTO templatefilecategory(id, template_id, name, displayorder) VALUES(1,1,'Documentation',1); | |
1114 INSERT INTO templatefilecategory(id, template_id, name, displayorder) VALUES(2,1,'Data Files',2); | |
1115 | |
1116 ALTER TABLE templatefilecategory ENABLE TRIGGER ALL; | |
1117 | |
1118 -- | |
1119 -- TOC entry 1855 (class 0 OID 0) | |
1120 -- Dependencies: 1275 | |
1121 -- Name: templatefilecategory_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | |
1122 -- | |
1123 | |
1124 SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('templatefilecategory', 'id'), 5, false); | |
1125 | |
1126 | |
1127 -- Completed on 2006-09-19 16:05:06 Eastern Standard Time | |
1128 | |
1129 -- | |
1130 -- PostgreSQL database dump complete | |
1131 -- | |
1132 | |
1133 | |
1134 -- Sequence: studyid_seq | |
1135 | |
1136 -- DROP SEQUENCE studyid_seq; | |
1137 | |
1138 CREATE SEQUENCE studyid_seq | |
1139 INCREMENT 1 | |
1140 MINVALUE 1 | |
1141 MAXVALUE 9223372036854775807 | |
1142 START 10000 | |
1143 CACHE 1; | |
1144 ALTER TABLE studyid_seq OWNER TO "postgres"; | |
1145 | |
1146 -- Sequence: filesystemname_seq | |
1147 | |
1148 -- DROP SEQUENCE filesystemname_seq; | |
1149 | |
1150 CREATE SEQUENCE filesystemname_seq | |
1151 INCREMENT 1 | |
1152 MINVALUE 1 | |
1153 MAXVALUE 9223372036854775807 | |
1154 START 2 | |
1155 CACHE 1; | |
1156 ALTER TABLE filesystemname_seq OWNER TO "postgres"; | |
1157 | |
1158 | |
1159 INSERT INTO DataFileFormatType (id, value, name, mimeType) VALUES (1, 'D02', 'Splus', 'text/plain'); | |
1160 INSERT INTO DataFileFormatType (id, value, name, mimeType) VALUES (2, 'D03', 'Stata', 'application/x-stata'); | |
1161 INSERT INTO DataFileFormatType (id, value, name, mimeType) VALUES (3, 'D04', 'R', 'application/x-rlang-transport'); | |
1162 | |
1163 INSERT INTO harvestformattype (id, metadataprefix, name, stylesheetfilename) VALUES (0, 'ddi', 'DDI', null); | |
1164 INSERT INTO harvestformattype (id, metadataprefix, name, stylesheetfilename) VALUES (1, 'oai_etdms', 'MIF', 'mif2ddi.xsl'); | |
1165 INSERT INTO harvestformattype (id, metadataprefix, name, stylesheetfilename) VALUES (2, 'oai_dc', 'DC', 'oai_dc2ddi.xsl'); | |
1166 INSERT INTO harvestformattype (id, metadataprefix, name, stylesheetfilename) VALUES (3, 'oai_fgdc', 'FGDC', 'fgdc2ddi.xsl'); | |
1167 INSERT INTO harvestformattype (id, metadataprefix, name, stylesheetfilename) VALUES (4, 'dcmi_terms', 'DCMI_terms', 'dcmi_terms2ddi.xsl'); | |
1168 | |
1169 create index datavariable_id_index on datavariable (id); | |
1170 create index summarystatistic_id_index on summarystatistic (id); | |
1171 create index summarystatistic_datavariable_id_index on summarystatistic (datavariable_id); | |
1172 create index variablecategory_id_index on variablecategory (id); | |
1173 create index variablecategory_datavariable_id_index on variablecategory (datavariable_id); | |
1174 create index variablerange_id_index on variablerange (id); | |
1175 create index study_id_index on study(id); | |
1176 create index study_owner_id_index on study(owner_id); | |
1177 create index weightedvarrelationship_id_index on weightedvarrelationship (weighted_variable_id,variable_id); | |
1178 create index studyfile_id_index on studyfile(id); | |
1179 create index datavariable_datatable_id_index on datavariable(datatable_id); | |
1180 create index variablerange_datavariable_id_index on variablerange (datavariable_id); | |
1181 create index metadata_id_index on metadata(id); | |
1182 create index studyabstract_metadata_id_index on studyabstract(metadata_id); | |
1183 create index studyauthor_metadata_id_index on studyauthor(metadata_id); | |
1184 create index studydistributor_metadata_id_index on studydistributor(metadata_id); | |
1185 create index studygeobounding_metadata_id_index on studygeobounding(metadata_id); | |
1186 create index studygrant_metadata_id_index on studygrant(metadata_id); | |
1187 create index studykeyword_metadata_id_index on studykeyword(metadata_id); | |
1188 create index studynote_metadata_id_index on studynote(metadata_id); | |
1189 create index studyotherid_metadata_id_index on studyotherid(metadata_id); | |
1190 create index studyotherref_metadata_id_index on studyotherref(metadata_id); | |
1191 create index studyproducer_metadata_id_index on studyproducer(metadata_id); | |
1192 create index studyrelmaterial_metadata_id_index on studyrelmaterial(metadata_id); | |
1193 create index studyrelpublication_metadata_id_index on studyrelpublication(metadata_id); | |
1194 create index studyrelstudy_metadata_id_index on studyrelstudy(metadata_id); | |
1195 create index studysoftware_metadata_id_index on studysoftware(metadata_id); | |
1196 create index studytopicclass_metadata_id_index on studytopicclass(metadata_id); | |
1197 create index template_metadata_id_index on template(metadata_id); | |
1198 create index studyfileactivity_id_index on studyfileactivity(id); | |
1199 create index studyfileactivity_studyfile_id_index on studyfileactivity(studyfile_id); | |
1200 create index studyfileactivity_study_id_index on studyfileactivity(study_id); | |
1201 | |
1202 | |
1203 | |
1204 | |
1205 | |
1206 INSERT INTO vdcnetworkstats (id,vdcnetwork_id,downloadcount,studycount,filecount) values (0,0,0,0,0); | |
1207 | |
1208 insert into licensetype (id, shortname, name, licenseurl, rdfurl, imageurl) values ( 1, 'cc by', 'CC Attribution (cc by)', 'http://creativecommons.org/licenses/by/3.0/', 'http://creativecommons.org/licenses/by/3.0/rdf', 'http://i.creativecommons.org/l/by/3.0/88x31.png' ); | |
1209 -- removed until we support cc0 | |
1210 --insert into licensetype (id, shortname, name, licenseurl, rdfurl, imageurl) values ( 2, 'cc0','CC Zero (cc0)','http://creativecommons.org/publicdomain/zero/1.0/','http://creativecommons.org/publicdomain/zero/1.0/rdf','http://i.creativecommons.org/l/zero/1.0/88x31.png'); | |
1211 insert into licensetype (id, shortname, name, licenseurl, rdfurl, imageurl) values ( 3, 'cc by-sa','CC Attribution Share Alike (cc by-sa)','http://creativecommons.org/licenses/by-sa/3.0/', 'http://creativecommons.org/licenses/by-sa/3.0/rdf', 'http://i.creativecommons.org/l/by-sa/3.0/88x31.png' ); | |
1212 insert into licensetype (id, shortname, name, licenseurl, rdfurl, imageurl) values ( 4, 'cc by-nd','CC Attribution No Derivatives (cc by-nd)','http://creativecommons.org/licenses/by-nd/3.0/', 'http://creativecommons.org/licenses/by-nd/3.0/rdf', 'http://i.creativecommons.org/l/by-nd/3.0/88x31.png' ); | |
1213 insert into licensetype (id, shortname, name, licenseurl, rdfurl, imageurl) values ( 5, 'cc by-nc','CC Attribution Non-Commercial (cc by-nc)','http://creativecommons.org/licenses/by-nc/3.0/', 'http://creativecommons.org/licenses/by-nc/3.0/rdf', 'http://i.creativecommons.org/l/by-nc/3.0/88x31.png' ); | |
1214 insert into licensetype (id, shortname, name, licenseurl, rdfurl, imageurl) values ( 6, 'cc by-nc-sa','CC Attribution Non-Commercial Share Alike (cc by-nc-sa)','http://creativecommons.org/licenses/by-nc-sa/3.0/', 'http://creativecommons.org/licenses/by-nc-sa/3.0/rdf', 'http://i.creativecommons.org/l/by-nc-sa/3.0/88x31.png' ); | |
1215 insert into licensetype (id, shortname, name, licenseurl, rdfurl, imageurl) values ( 7, 'cc by-nc-nd','CC Attribution Non-Commercial No Derivatives (cc by-nc-nd)','http://creativecommons.org/licenses/by-nc-sa/3.0/', 'http://creativecommons.org/licenses/by-nc-sa/3.0/rdf', 'http://i.creativecommons.org/l/by-nc-sa/3.0/88x31.png' ); | |
1216 | |
1217 INSERT INTO metadataformattype (id, name, mimetype, namespace, formatschema, partialexcludesupported, partialselectsupported) VALUES (1, 'ddi', 'application/xml', 'http://www.icpsr.umich.edu/DDI', 'http://www.icpsr.umich.edu/DDI/Version2-0.xsd', true, true); | |
1218 INSERT INTO metadataformattype (id, name, mimetype, namespace, formatschema, partialexcludesupported, partialselectsupported) VALUES (2, 'oai_dc', 'application/xml', 'http://www.openarchives.org/OAI/2.0/oai_dc/', 'http://www.openarchives.org/OAI/2.0/oai_dc.xsd', false, false); | |
1219 INSERT INTO metadataformattype (id, name, mimetype, namespace, formatschema, partialexcludesupported, partialselectsupported) VALUES (3, 'marc', 'application/octet-stream', 'http://www.loc.gov/marc/', 'MARC 21', false, false); | |
1220 | |
1221 /*create network guest book*/ | |
1222 | |
1223 INSERT INTO guestbookquestionnaire(enabled,firstnamerequired, lastnamerequired, emailrequired, institutionrequired, positionrequired, vdc_id) VALUES (true, true, true, true, false, false, null); |