1. Add DepDesc column to PackageDepends and split dependency names: --- ALTER TABLE PackageDepends ADD COLUMN DepDesc VARCHAR(255) NULL DEFAULT NULL; UPDATE PackageDepends SET DepDesc = SUBSTRING(DepName FROM POSITION(': ' IN DepName) + 2) WHERE POSITION(': ' IN DepName) > 0; UPDATE PackageDepends SET DepName = SUBSTRING(DepName FROM 1 FOR POSITION(': ' IN DepName) - 1) WHERE POSITION(': ' IN DepName) > 0; --- 2. Add RenderedComment column to PackageComments: --- ALTER TABLE PackageComments ADD COLUMN RenderedComment TEXT NOT NULL; ---