From 1e3fa38de5f940fef474fc3961c70b357b976308 Mon Sep 17 00:00:00 2001
From: Lukas Fleischer <archlinux@cryptocrack.de>
Date: Sun, 27 Feb 2011 17:12:43 +0100
Subject: Define "Packages.SubmitterUID" and "Packages.MaintainerUID" as
 "NULL".

Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
---
 support/schema/aur-schema.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

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

diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index be1296a7..c896aa37 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -104,8 +104,8 @@ CREATE TABLE Packages (
 	OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL,
 	SubmittedTS BIGINT UNSIGNED NOT NULL,
 	ModifiedTS BIGINT UNSIGNED NOT NULL,
-	SubmitterUID INTEGER UNSIGNED NOT NULL DEFAULT 0,     -- who submitted it?
-	MaintainerUID INTEGER UNSIGNED NOT NULL DEFAULT 0,    -- User
+	SubmitterUID INTEGER UNSIGNED NULL DEFAULT NULL,     -- who submitted it?
+	MaintainerUID INTEGER UNSIGNED NULL DEFAULT NULL,    -- User
 	PRIMARY KEY (ID),
 	UNIQUE (Name),
 	INDEX (CategoryID),
-- 
cgit v1.2.3-24-g4f1b

