Newer
Older
Sabine Schröder
committed
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
--
-- toardb/extension/toar_controlled_vocabulary/toar_controlled_vocabulary--0.5--0.6.sql
--
-- [Step to install]
--
-- 1.
--
-- INSTALL VERSION: '0.6'
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE/ALTER EXTENSION toar_controlled_vocabulary" to load this file. \quit
-- Update Data
-- ===========
-- Data Flags
-- still to do:
-- How to set convoc_schema to result from SELECT:
-- SELECT table_schema INTO convoc_schema FROM information_schema.tables WHERE table_name='df_vocabulary';
SET SCHEMA 'toar_convoc';
INSERT INTO df_vocabulary (enum_val, enum_str, enum_display_str) VALUES
( 7, 'OKPreliminaryNotChecked', 'OK preliminary not checked'),
(16, 'QuestionnablePreliminaryNotChecked', 'questionnable preliminary not checked'),
(26, 'ErroneousPreliminaryFlagged1', 'erroneous preliminary flagged (1)'),
(27, 'ErroneousPreliminaryFlagged2', 'erroneous preliminary flagged (2)'),
(28, 'ErroneousPreliminaryNotChecked', 'erroneous preliminary not checked');
UPDATE df_vocabulary SET (enum_val, enum_str, enum_display_str) = (22, 'ErroneousValidatedFlagged1', 'erroneous validated flagged (1)') WHERE enum_val=22;
UPDATE df_vocabulary SET (enum_val, enum_str, enum_display_str) = (23, 'ErroneousValidatedFlagged2', 'erroneous validated flagged (2)') WHERE enum_val=23;
UPDATE df_vocabulary SET (enum_val, enum_str, enum_display_str) = (24, 'ErroneousPreliminaryConfirmed', 'erroneous preliminary confirmed') WHERE enum_val=24;
UPDATE df_vocabulary SET (enum_val, enum_str, enum_display_str) = (25, 'ErroneousPreliminaryUnconfirmed', 'erroneous preliminary unconfirmed') WHERE enum_val=25;
-- Roles
-- =====
-- Role Status
UPDATE rs_vocabulary SET enum_str = 'Active' WHERE enum_val=0;
UPDATE rs_vocabulary SET enum_str = 'Inactive' WHERE enum_val=1;
UPDATE rs_vocabulary SET enum_str = 'Unkown' WHERE enum_val=2;