diff options
Diffstat (limited to 'support/schema')
| -rw-r--r-- | support/schema/aur-schema.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 490a5ed..c3c53f8 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -122,6 +122,8 @@ CREATE TABLE Packages ( SubmitterUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- who submitted it? MaintainerUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- User AURMaintainerUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- TU/Dev + Safe TINYINT UNSIGNED NOT NULL DEFAULT 0, -- verified to be safe? + VerifiedBy INTEGER UNSIGNED NOT NULL DEFAULT 0, -- who verified? PRIMARY KEY (ID), UNIQUE (Name), INDEX (CategoryID), @@ -132,6 +134,8 @@ CREATE TABLE Packages ( INDEX (SubmitterUID), INDEX (MaintainerUID), INDEX (AURMaintainerUID), + INDEX (Safe), + INDEX (VerifiedBy), FOREIGN KEY (CategoryID) REFERENCES PackageCategories(ID) ON DELETE NO ACTION, FOREIGN KEY (LocationID) REFERENCES PackageLocations(ID) ON DELETE NO ACTION, FOREIGN KEY (SubmitterUID) REFERENCES Users(ID) ON DELETE NO ACTION, |