diff options
author | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-04-26 14:07:20 +0200 |
---|---|---|
committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2014-04-26 14:07:20 +0200 |
commit | cc3244ea8ae0202265df3d0fd2cfe86fbbeb9d30 (patch) | |
tree | acdf3629538c57886b41f9216bb4e132939d7452 /schema | |
parent | 3720bdf6b264cb4bb603e4199f2758598c260ed4 (diff) | |
download | aurweb-cc3244ea8ae0202265df3d0fd2cfe86fbbeb9d30.tar.xz |
Store package groups in the database
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'schema')
-rw-r--r-- | schema/aur-schema.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql index c98ba77..ae42fd3 100644 --- a/schema/aur-schema.sql +++ b/schema/aur-schema.sql @@ -133,6 +133,27 @@ CREATE TABLE Packages ( ) ENGINE = InnoDB; +-- Information about groups +-- +CREATE TABLE Groups ( + ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, + Name VARCHAR(64) NOT NULL, + PRIMARY KEY (ID), + UNIQUE (Name) +) ENGINE = InnoDB; + + +-- Information about package-group-relations +-- +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; + + -- Define the package dependency types -- CREATE TABLE DependencyTypes ( |