From 761ddc3ddcaeb46f48fc746ad2f3cedb97cb1249 Mon Sep 17 00:00:00 2001 From: eric Date: Tue, 29 Jun 2004 21:22:31 +0000 Subject: yet another schema change --- support/schema/aur-schema.sql | 9 ++++++--- support/schema/dummy-data.sql.bz2 | Bin 0 -> 687869 bytes support/schema/dummy-data.sql.gz | Bin 77962 -> 0 bytes support/schema/gendummydata.py | 24 +++++++++++++----------- 4 files changed, 19 insertions(+), 14 deletions(-) create mode 100644 support/schema/dummy-data.sql.bz2 delete mode 100644 support/schema/dummy-data.sql.gz (limited to 'support/schema') diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 876cf28..dd02310 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -113,8 +113,9 @@ CREATE TABLE Packages ( NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0, OutOfDate TINYINT UNSIGNED DEFAULT 0, SubmittedTS BIGINT UNSIGNED NOT NULL, - SubmitterUID INTEGER UNSIGNED NOT NULL DEFAULT 0, - MaintainerUID INTEGER UNSIGNED NOT NULL DEFAULT 0, + 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 PRIMARY KEY (ID), UNIQUE (Name), INDEX (CategoryID), @@ -123,10 +124,12 @@ CREATE TABLE Packages ( INDEX (NumVotes), INDEX (SubmitterUID), INDEX (MaintainerUID), + INDEX (AURMaintainerUID), 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, - FOREIGN KEY (MaintainerUID) REFERENCES Users(ID) ON DELETE NO ACTION + FOREIGN KEY (MaintainerUID) REFERENCES Users(ID) ON DELETE NO ACTION, + FOREIGN KEY (AURMaintainerUID) REFERENCES Users(ID) ON DELETE NO ACTION ); diff --git a/support/schema/dummy-data.sql.bz2 b/support/schema/dummy-data.sql.bz2 new file mode 100644 index 0000000..1b5bde3 Binary files /dev/null and b/support/schema/dummy-data.sql.bz2 differ diff --git a/support/schema/dummy-data.sql.gz b/support/schema/dummy-data.sql.gz deleted file mode 100644 index 296b8aa..0000000 Binary files a/support/schema/dummy-data.sql.gz and /dev/null differ diff --git a/support/schema/gendummydata.py b/support/schema/gendummydata.py index 7365296..917b569 100755 --- a/support/schema/gendummydata.py +++ b/support/schema/gendummydata.py @@ -13,15 +13,15 @@ DB_HOST = "localhost" DB_NAME = "AUR" DB_USER = "aur" DB_PASS = "aur" -USER_ID = 5 # Users.ID of first user -PKG_ID = 1 # Packages.ID of first package -MAX_USERS = 1000 # how many users to 'register' -MAX_DEVS = .1 # what percentage of MAX_USERS are Developers -MAX_TUS = .2 # what percentage of MAX_USERS are Trusted Users -MAX_PKGS = 2500 # how many packages to load -PKG_FILES = (8, 30) # min/max number of files in a package -VOTING = (.1, .4) # percentage range for package voting -RANDOM_PATHS = [ # random path locations for package files +USER_ID = 5 # Users.ID of first user +PKG_ID = 1 # Packages.ID of first package +MAX_USERS = 500 # how many users to 'register' +MAX_DEVS = .1 # what percentage of MAX_USERS are Developers +MAX_TUS = .2 # what percentage of MAX_USERS are Trusted Users +MAX_PKGS = 2500 # how many packages to load +PKG_FILES = (8, 30) # min/max number of files in a package +VOTING = (0, .30) # percentage range for package voting +RANDOM_PATHS = [ # random path locations for package files "/usr/bin", "/usr/lib", "/etc", "/etc/rc.d", "/usr/share", "/lib", "/var/spool", "/var/log", "/usr/sbin", "/opt", "/usr/X11R6/bin", "/usr/X11R6/lib", "/usr/libexec", "/usr/man/man1", "/usr/man/man3", @@ -225,8 +225,10 @@ for p in seen_pkgs.keys(): if location_id == 1: # unsupported pkgs don't have a maintainer muid = 0 - s = "INSERT INTO Packages (ID, Name, Version, CategoryID, LocationID, SubmittedTS, SubmitterUID, MaintainerUID) VALUES (%d, '%s', '%s', %d, %d, %d, %d, %d);\n" % (seen_pkgs[p], p, genVersion(location_id), genCategory(), - location_id, long(time.time()), genUID(), muid) + uuid = genUID() # the submitter/user + + s = "INSERT INTO Packages (ID, Name, Version, CategoryID, LocationID, SubmittedTS, SubmitterUID, MaintainerUID, AURMaintainerUID) VALUES (%d, '%s', '%s', %d, %d, %d, %d, %d, %d);\n" % (seen_pkgs[p], p, genVersion(location_id), + genCategory(), location_id, long(time.time()), uuid, uuid, muid) out.write(s) if count % 100 == 0: if DBUG: print ".", -- cgit v1.2.3-70-g09d2