3 INSERT into config.org_unit_setting_type
4 ( name, grp, label, description, datatype ) VALUES
6 ( 'lib.timezone', 'lib',
7 oils_i18n_gettext('lib.timezone',
10 oils_i18n_gettext('lib.timezone',
11 'Define the time zone in which a library physically resides',
12 'coust', 'description'),
15 ALTER TABLE actor.org_unit_closed ADD COLUMN full_day BOOLEAN DEFAULT FALSE;
16 ALTER TABLE actor.org_unit_closed ADD COLUMN multi_day BOOLEAN DEFAULT FALSE;
18 UPDATE actor.org_unit_closed SET multi_day = TRUE
19 WHERE close_start::DATE <> close_end::DATE;
21 UPDATE actor.org_unit_closed SET full_day = TRUE
22 WHERE close_start::DATE = close_end::DATE
23 AND SUBSTRING(close_start::time::text FROM 1 FOR 8) = '00:00:00'
24 AND SUBSTRING(close_end::time::text FROM 1 FOR 8) = '23:59:59';