summaryrefslogtreecommitdiffstats
path: root/support/schema/aur-schema.sql
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2011-02-27 17:12:43 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2011-02-27 19:46:19 +0100
commit1e3fa38de5f940fef474fc3961c70b357b976308 (patch)
tree3474eadc3354f5312f245425deb9a2bf1fe64114 /support/schema/aur-schema.sql
parent84c2491e63ef2797084f9378674d3e38248b7c24 (diff)
downloadaur-1e3fa38de5f940fef474fc3961c70b357b976308.tar.gz
aur-1e3fa38de5f940fef474fc3961c70b357b976308.tar.xz
Define "Packages.SubmitterUID" and "Packages.MaintainerUID" as "NULL".
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'support/schema/aur-schema.sql')
-rw-r--r--support/schema/aur-schema.sql4
1 files changed, 2 insertions, 2 deletions
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),