-
Notifications
You must be signed in to change notification settings - Fork 2
/
db-3.1-to-3.2.sql
executable file
·105 lines (89 loc) · 3.38 KB
/
db-3.1-to-3.2.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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
--
-- Add this again because it was left out of the create.sql for the 3.1 release
--
ALTER TABLE fac_CabRow ADD COLUMN CabOrder ENUM( 'ASC', 'DESC' ) NOT NULL DEFAULT 'ASC';
--
-- Add the picture fields for front/rear views, and front/rear slots in device template
--
ALTER TABLE fac_DeviceTemplate ADD COLUMN FrontPictureFile VARCHAR(45) NOT NULL AFTER Notes;
ALTER TABLE fac_DeviceTemplate ADD COLUMN RearPictureFile VARCHAR(45) NOT NULL AFTER FrontPictureFile;
ALTER TABLE fac_DeviceTemplate ADD COLUMN ChassisSlots SMALLINT(6) NOT NULL AFTER RearPictureFile;
ALTER TABLE fac_DeviceTemplate ADD COLUMN RearChassisSlots SMALLINT(6) NOT NULL AFTER ChassisSlots;
--
-- Slots table content the coodinates os slots in a picture of a chassis device template
--
CREATE TABLE IF NOT EXISTS fac_Slots (
TemplateID INT(11) NOT NULL,
Position INT(11) NOT NULL,
BackSide TINYINT(1) NOT NULL,
X INT(11) NULL,
Y INT(11) NULL,
W INT(11) NULL,
H INT(11) NULL,
PRIMARY KEY (TemplateID, Position, BackSide)
) ENGINE = InnoDB;
--
-- Add field to indicate the intake/front edge of a cabinet
--
ALTER TABLE fac_Cabinet ADD COLUMN FrontEdge ENUM("Top","Right","Bottom","Left") NOT NULL DEFAULT "Top" AFTER MapX2;
--
-- TempaltePorts table content the ports of a device template
--
CREATE TABLE IF NOT EXISTS `fac_TemplatePorts` (
`TemplateID` int(11) NOT NULL,
`PortNumber` int(11) NOT NULL,
`Label` varchar(40) NOT NULL,
`MediaID` int(11) NOT NULL DEFAULT '0',
`ColorID` int(11) NOT NULL DEFAULT '0',
`PortNotes` varchar(80) NOT NULL,
PRIMARY KEY (`TemplateID`,`PortNumber`),
UNIQUE KEY `LabeledPort` (`TemplateID`,`PortNumber`,`Label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Disable MediaType Enforcing, again.
--
UPDATE fac_Config SET Value='Disabled' WHERE Parameter='MediaEnforce' LIMIT 1;
--
-- Table structure for table `fac_GenericLog`
--
CREATE TABLE IF NOT EXISTS `fac_GenericLog` (
UserID varchar(80) NOT NULL,
Class varchar(40) NOT NULL,
ObjectID varchar(80) NOT NULL,
ChildID int(11) DEFAULT NULL,
Action varchar(40) NOT NULL,
Property varchar(40) NOT NULL,
OldVal varchar(255) NOT NULL,
NewVal varchar(255) NOT NULL,
Time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Add configuration items for path weights
-- I honestly don't understand this so I didn't fill in what the UnitOfMeasure is
--
INSERT INTO fac_Config VALUES ('path_weight_cabinet', '1', '', 'int', '1'),
('path_weight_rear', '1', '', 'int', '1'),
('path_weight_row', '4', '', 'int', '4');
--
-- Extend the length on the ip address field to allow for ipv6 and/or dns hosts
--
ALTER TABLE fac_PowerDistribution CHANGE IPAddress IPAddress VARCHAR(254);
ALTER TABLE fac_Device CHANGE PrimaryIP PrimaryIP VARCHAR(254);
ALTER TABLE fac_PowerSource CHANGE IPAddress IPAddress VARCHAR(254);
ALTER TABLE fac_Cabinet CHANGE SensorIPAddress SensorIPAddress VARCHAR(254);
--
-- Add in 0.1 as a possible multiplier value for the CDU Templates
--
ALTER TABLE fac_CDUTemplate CHANGE Multiplier Multiplier ENUM( '0.1', '1', '10', '100' );
--
-- Add in column to track an audit date on a device
--
ALTER TABLE fac_Device ADD AuditStamp DATETIME NOT NULL;
--
-- Bump up the database version
--
UPDATE fac_Config set Value='3.2' WHERE Parameter='Version';
--
-- We've changed how we're handling devices in storage move them all to the general storage room
--
UPDATE fac_Device SET Position=0 WHERE Cabinet=-1;