From 1fe14899aa808f50144162d6b14fc583873d08fc Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Sun, 29 Jun 2014 23:09:35 +0200 Subject: Split UPGRADING Split the upgrade instructions into several files, one file per version in order to keep them small, readable and to avoid merge conflicts. Signed-off-by: Lukas Fleischer --- upgrading/1.8.2.txt | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 upgrading/1.8.2.txt (limited to 'upgrading/1.8.2.txt') diff --git a/upgrading/1.8.2.txt b/upgrading/1.8.2.txt new file mode 100644 index 0000000..ba3aebd --- /dev/null +++ b/upgrading/1.8.2.txt @@ -0,0 +1,18 @@ +1. Update the modified package timestamp for new packages. + +UPDATE Packages SET ModifiedTS = SubmittedTS WHERE ModifiedTS = 0; + +2. Move to new method of storing package depends. + +---- +ALTER TABLE PackageDepends ADD COLUMN DepName VARCHAR(64) NOT NULL DEFAULT '' AFTER PackageID; +UPDATE PackageDepends SET DepName = (SELECT Name FROM Packages WHERE ID = DepPkgID); +ALTER TABLE PackageDepends MODIFY DepName VARCHAR(64) NOT NULL; +ALTER TABLE PackageDepends DROP FOREIGN KEY `PackageDepends_ibfk_2`; +ALTER TABLE PackageDepends DROP COLUMN DepPkgID; +DELETE FROM Packages WHERE DummyPkg = 1; +ALTER TABLE Packages DROP COLUMN DummyPkg; +---- + +3. The File_Find PEAR module is no longer required. You can safely uninstall it +if nothing else depends on it. -- cgit v1.2.3-54-g00ecf