From 70b6b2250b7d6c3881454dc8481b0f68517ad248 Mon Sep 17 00:00:00 2001
From: pjmattal <pjmattal>
Date: Fri, 29 Jul 2005 12:29:57 +0000
Subject: committed schema change for swiergot's checking patch

---
 support/schema/aur-schema.sql | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'support/schema/aur-schema.sql')

diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 490a5ed2..c3c53f8b 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,
-- 
cgit v1.2.3-24-g4f1b

