blob: b051bacac2c858bd2e4390c41b262eb25b946b49 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
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;
---
|
