From cc3244ea8ae0202265df3d0fd2cfe86fbbeb9d30 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Sat, 26 Apr 2014 14:07:20 +0200 Subject: Store package groups in the database Signed-off-by: Lukas Fleischer --- UPGRADING | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'UPGRADING') diff --git a/UPGRADING b/UPGRADING index f523140c..814fea1a 100644 --- a/UPGRADING +++ b/UPGRADING @@ -199,6 +199,24 @@ CREATE TABLE PackageRelations ( ) ENGINE = InnoDB; ---- +17. Create tables to store package groups: + +---- +CREATE TABLE Groups ( + ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, + Name VARCHAR(64) NOT NULL, + PRIMARY KEY (ID), + UNIQUE (Name) +) ENGINE = InnoDB; +CREATE TABLE PackageGroups ( + PackageID INTEGER UNSIGNED NOT NULL, + GroupID INTEGER UNSIGNED NOT NULL, + PRIMARY KEY (PackageID, GroupID), + FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE, + FOREIGN KEY (GroupID) REFERENCES Groups(ID) ON DELETE CASCADE +) ENGINE = InnoDB; +---- + From 2.2.0 to 2.3.0 ------------------- -- cgit v1.2.3-24-g4f1b