summaryrefslogtreecommitdiffstats
path: root/support/schema
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
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')
-rw-r--r--support/schema/aur-schema.sql4
-rwxr-xr-xsupport/schema/gendummydata.py7
2 files changed, 8 insertions, 3 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),
diff --git a/support/schema/gendummydata.py b/support/schema/gendummydata.py
index e3c14f83..45812a9c 100755
--- a/support/schema/gendummydata.py
+++ b/support/schema/gendummydata.py
@@ -228,8 +228,13 @@ for p in seen_pkgs.keys():
uuid = genUID() # the submitter/user
- s = "INSERT INTO Packages (ID, Name, Version, CategoryID, SubmittedTS, SubmitterUID, MaintainerUID) VALUES (%d, '%s', '%s', %d, %d, %d, %d);\n" % (seen_pkgs[p], p, genVersion(),
+ if muid == 0:
+ s = "INSERT INTO Packages (ID, Name, Version, CategoryID, SubmittedTS, SubmitterUID, MaintainerUID) VALUES (%d, '%s', '%s', %d, %d, %d, NULL);\n" % (seen_pkgs[p], p, genVersion(),
+ genCategory(), NOW, uuid)
+ else:
+ s = "INSERT INTO Packages (ID, Name, Version, CategoryID, SubmittedTS, SubmitterUID, MaintainerUID) VALUES (%d, '%s', '%s', %d, %d, %d, %d);\n" % (seen_pkgs[p], p, genVersion(),
genCategory(), NOW, uuid, muid)
+
out.write(s)
if count % 100 == 0:
if DBUG: print ".",