summaryrefslogtreecommitdiffstats
path: root/UPGRADING
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2011-02-26 21:11:25 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2011-02-26 21:11:25 +0100
commitac632980c3789cd99a80d61861b8820ddad14704 (patch)
tree776006cc1f9a605a57942ab4cf19c5392890e3c7 /UPGRADING
parente72f02872fc1f81bdd609c061f08e69b34153c7e (diff)
downloadaurweb-ac632980c3789cd99a80d61861b8820ddad14704.tar.xz
Add missing foreign keys and constraints to the DB.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'UPGRADING')
-rw-r--r--UPGRADING26
1 files changed, 26 insertions, 0 deletions
diff --git a/UPGRADING b/UPGRADING
index e512850..7227479 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -1,6 +1,32 @@
Upgrading
=========
+From 1.8.0 to 1.8.1
+-------------------
+
+1. Drop foreign keys from the "Sessions" table:
+
+`ALTER TABLE Sessions DROP FOREIGN KEY Sessions_ibfk_1;` should work in most
+cases. Otherwise, check the output of `SHOW CREATE TABLE Sessions;` and use the
+foreign key name shown there.
+
+2. Run the following MySQL statements:
+
+----
+ALTER TABLE Sessions
+ ADD FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE;
+ALTER TABLE PackageDepends
+ ADD FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE,
+ ADD FOREIGN KEY (DepPkgID) REFERENCES Packages(ID) ON DELETE CASCADE;
+ALTER TABLE PackageSources
+ ADD FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE;
+ALTER TABLE TU_VoteInfo
+ ADD FOREIGN KEY (SubmitterID) REFERENCES Users(ID) ON DELETE CASCADE;
+ALTER TABLE TU_Votes
+ ADD FOREIGN KEY (VoteID) REFERENCES TU_VoteInfo(ID) ON DELETE CASCADE,
+ ADD FOREIGN KEY (UserID) REFERENCES Users(ID) ON DELETE CASCADE;
+----
+
From 1.7.0 to 1.8.0
-------------------