diff options
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/aur-schema.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql index 0ec4f75..08f87d8 100644 --- a/schema/aur-schema.sql +++ b/schema/aur-schema.sql @@ -198,6 +198,7 @@ CREATE TABLE PackageDepends ( DepTypeID TINYINT UNSIGNED NOT NULL, DepName VARCHAR(255) NOT NULL, DepCondition VARCHAR(255), + DepArch VARCHAR(255) NULL DEFAULT NULL, INDEX (PackageID), INDEX (DepName), FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE, @@ -224,6 +225,7 @@ CREATE TABLE PackageRelations ( RelTypeID TINYINT UNSIGNED NOT NULL, RelName VARCHAR(255) NOT NULL, RelCondition VARCHAR(255), + RelArch VARCHAR(255) NULL DEFAULT NULL, INDEX (PackageID), INDEX (RelName), FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE, @@ -236,6 +238,7 @@ CREATE TABLE PackageRelations ( CREATE TABLE PackageSources ( PackageID INTEGER UNSIGNED NOT NULL, Source VARCHAR(255) NOT NULL DEFAULT "/dev/null", + SourceArch VARCHAR(255) NULL DEFAULT NULL, INDEX (PackageID), FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE ) ENGINE = InnoDB; |