From 1e3fa38de5f940fef474fc3961c70b357b976308 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Sun, 27 Feb 2011 17:12:43 +0100 Subject: Define "Packages.SubmitterUID" and "Packages.MaintainerUID" as "NULL". Signed-off-by: Lukas Fleischer --- 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