summaryrefslogtreecommitdiffstats
path: root/UPGRADING
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2014-04-26 10:29:17 +0200
committerLukas Fleischer <archlinux@cryptocrack.de>2014-04-26 13:20:56 +0200
commit92812050a059a651357f772b58e967154ea8428c (patch)
treec7b61560011b3cbe0671c998b4ee0ce19fc40b22 /UPGRADING
parent34453d32958cc71cf08e932368952f98b46b7020 (diff)
downloadaur-92812050a059a651357f772b58e967154ea8428c.tar.gz
aur-92812050a059a651357f772b58e967154ea8428c.tar.xz
Store conflicts, provides and replaces in the DB
Package conflicts, provides and replaces are now stored in the new PackageRelations table. The gendummydata script generates test entries for these relations. Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'UPGRADING')
-rw-r--r--UPGRADING28
1 files changed, 28 insertions, 0 deletions
diff --git a/UPGRADING b/UPGRADING
index 0a801cce..f523140c 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -171,6 +171,34 @@ ALTER TABLE PackageDepends
ALTER TABLE PackageDepends MODIFY DepName VARCHAR(255) NOT NULL;
----
+15. Create a new table to store package relation types:
+
+----
+CREATE TABLE RelationTypes (
+ ID TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
+ Name VARCHAR(32) NOT NULL DEFAULT '',
+ PRIMARY KEY (ID)
+) ENGINE = InnoDB;
+INSERT INTO RelationTypes VALUES (1, 'conflicts');
+INSERT INTO RelationTypes VALUES (2, 'provides');
+INSERT INTO RelationTypes VALUES (3, 'replaces');
+----
+
+16. Create a new table to store package relations:
+
+----
+CREATE TABLE PackageRelations (
+ PackageID INTEGER UNSIGNED NOT NULL,
+ RelTypeID TINYINT UNSIGNED NOT NULL,
+ RelName VARCHAR(255) NOT NULL,
+ RelCondition VARCHAR(20),
+ INDEX (PackageID),
+ INDEX (RelName),
+ FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE,
+ FOREIGN KEY (RelTypeID) REFERENCES RelationTypes(ID) ON DELETE NO ACTION
+) ENGINE = InnoDB;
+----
+
From 2.2.0 to 2.3.0
-------------------