diff options
Diffstat (limited to 'upgrading')
| -rw-r--r-- | upgrading/4.6.0.txt | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/upgrading/4.6.0.txt b/upgrading/4.6.0.txt new file mode 100644 index 00000000..45740f40 --- /dev/null +++ b/upgrading/4.6.0.txt @@ -0,0 +1,11 @@ +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; +--- |