data.upgrade_5.4.sql Maven / Gradle / Ivy
ALTER TABLE vulnerability ADD COLUMN v4version VARCHAR(5);
ALTER TABLE vulnerability ADD COLUMN v4attackVector VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4attackComplexity VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4attackRequirements VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4privilegesRequired VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4userInteraction VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4vulnConfidentialityImpact VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4vulnIntegrityImpact VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4vulnAvailabilityImpact VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4subConfidentialityImpact VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4subIntegrityImpact VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4subAvailabilityImpact VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4exploitMaturity VARCHAR(20);
ALTER TABLE vulnerability ADD COLUMN v4confidentialityRequirement VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4integrityRequirement VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4availabilityRequirement VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4modifiedAttackVector VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4modifiedAttackComplexity VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4modifiedAttackRequirements VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4modifiedPrivilegesRequired VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4modifiedUserInteraction VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4modifiedVulnConfidentialityImpact VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4modifiedVulnIntegrityImpact VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4modifiedVulnAvailabilityImpact VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4modifiedSubConfidentialityImpact VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4modifiedSubIntegrityImpact VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4modifiedSubAvailabilityImpact VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4safety VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4automatable VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4recovery VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4valueDensity VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4vulnerabilityResponseEffort VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4providerUrgency VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4baseScore DECIMAL(3,1);
ALTER TABLE vulnerability ADD COLUMN v4baseSeverity VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4threatScore DECIMAL(3,1);
ALTER TABLE vulnerability ADD COLUMN v4threatSeverity VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4environmentalScore DECIMAL(3,1);
ALTER TABLE vulnerability ADD COLUMN v4environmentalSeverity VARCHAR(15);
ALTER TABLE vulnerability ADD COLUMN v4source VARCHAR(50);
ALTER TABLE vulnerability ADD COLUMN v4type VARCHAR(15);
UPDATE Properties SET `value`='5.5' WHERE ID='version';