-
Notifications
You must be signed in to change notification settings - Fork 208
/
db-19.01-to-20.01.sql
63 lines (50 loc) · 3.46 KB
/
db-19.01-to-20.01.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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
--
-- 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='SAMLGroupAttribute', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='memberOf';
INSERT into fac_Config set Parameter='AttrFirstName', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='givenName';
INSERT into fac_Config set Parameter='AttrLastName', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='sn';
INSERT into fac_Config set Parameter='AttrEmail', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='mail';
INSERT into fac_Config set Parameter='AttrPhone1', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='';
INSERT into fac_Config set Parameter='AttrPhone2', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='';
INSERT into fac_Config set Parameter='AttrPhone3', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='';
--
-- New fields tracked in the CDUDeviceTemplate
--
alter table fac_CDUTemplate add column OutletNameOID varchar(80) NOT NULL after VersionOID;
alter table fac_CDUTemplate add column OutletDescOID varchar(80) NOT NULL after OutletNameOID;
alter table fac_CDUTemplate add column OutletCountOID varchar(80) NOT NULL after OutletDescOID;
alter table fac_CDUTemplate add column OutletStatusOID varchar(80) NOT NULL after OutletCountOID;
alter table fac_CDUTemplate add column OutletStatusOn varchar(80) NOT NULL after OutletStatusOID;
--
-- New parameter for Changing cabinet labels from cabinet name to user preference based label
--
insert into fac_Config set Parameter='RackRequestsActions', Value='Disabled', UnitOfMeasure='string', ValType='string', DefaultVal='disabled';
insert into fac_Config set Parameter='AssignCabinetLabels', Value='Location', UnitOfMeasure='string', ValType='string', DefaultVal='Location';
--
-- Changes for streamlining the Saml configuration
--
DELETE from fac_Config where Parameter='SAMLStrict';
DELETE from fac_Config where Parameter='SAMLDebug';
DELETE from fac_Config where Parameter='SAMLidpcertFingerprint';
DELETE from fac_Config where Parameter='SAMLidpcertFingerprintAlgorithm';
DELETE from fac_Config where Parameter='SAMLspacsURL';
DELETE from fac_Config where Parameter='SAMLspslsURL';
ALTER TABLE fac_Config MODIFY Value text;
INSERT into fac_Config set Parameter='SAMLidpx509cert', Value='', UnitOfMeasure='string',ValType='string', DefaultVal='';
INSERT into fac_Config set Parameter='SAMLIdPMetadataURL', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='';
INSERT into fac_Config set Parameter='SAMLCertCountry', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='US';
INSERT into fac_Config set Parameter='SAMLCertProvince', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='Tennessee';
INSERT into fac_Config set Parameter='SAMLCertOrganization', Value='', UnitOfMeasure='string', ValType='string', DefaultVal='openDCIM User';
--
-- Bump up the database version (uncomment below once released)
--
UPDATE fac_Config set Value="20.01" WHERE Parameter="Version";