diff options
| author | pjmattal <pjmattal> | 2005-07-29 12:29:57 +0000 |
|---|---|---|
| committer | pjmattal <pjmattal> | 2005-07-29 12:29:57 +0000 |
| commit | 70b6b2250b7d6c3881454dc8481b0f68517ad248 (patch) | |
| tree | a18f1ed0d952eed729769582aa4eb5ea02675bf2 | |
| parent | a8999a691777a96ea07f53a479a154b743712a46 (diff) | |
| download | aurweb-70b6b2250b7d6c3881454dc8481b0f68517ad248.tar.xz | |
committed schema change for swiergot's checking patch
| -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, |