Mercurial > hg > LGDataverses

comparison DVN-web/installer/dvninstall/referenceData.sql.TEMPLATE @ 6:1b2188262ae9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%
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_USER%";
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_USER%";
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);