forked from opendcim/openDCIM
-
Notifications
You must be signed in to change notification settings - Fork 0
/
db-19.01-to-19.02.sql
34 lines (25 loc) · 1.55 KB
/
db-19.01-to-19.02.sql
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
--
-- Backwards compatibility for change to allow logo.png to be anywhere
--
UPDATE fac_Config set Value=concat("images/",Value) WHERE Parameter="PDFLogoFile";
--
-- New configuration parameter for whether or not to enable LDAP debugging
--
INSERT into fac_Config set Parameter='LDAP_Debug_Password', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='disabled';
--
-- New parameters for mapping SAML/LDAP entries to fields in the database
--
INSERT into fac_Config set Parameter='LDAPFirstName', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='';
INSERT into fac_Config set Parameter='LDAPLastName', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='';
INSERT into fac_Config set Parameter='LDAPEmail', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='';
INSERT into fac_Config set Parameter='LDAPPhone1', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='';
INSERT into fac_Config set Parameter='LDAPPhone2', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='';
INSERT into fac_Config set Parameter='LDAPPhone3', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='';
--
-- New parameter for Changing cabinet labels from cabinet name to user preference based label
--
insert into fac_Config set Parameter='AssignCabinetLabels', Value='OwnerName', UnitOfMeasure='string', ValType='string', DefaultVal='OwnerName';
--
-- Bump up the database version (uncomment below once released)
--
UPDATE fac_Config set Value="19.02" WHERE Parameter="Version";