From e3587ddf94ba742beabdaa8a68023f8ee0234b58 Mon Sep 17 00:00:00 2001
From: eric <eric>
Date: Sun, 6 Mar 2005 21:44:56 +0000
Subject: started working on pkgedit for comments

---
 support/schema/aur-schema.sql     |   2 ++
 support/schema/dummy-data.sql.bz2 | Bin 1884846 -> 1882935 bytes
 support/schema/gendummydata.py    |   4 ++--
 3 files changed, 4 insertions(+), 2 deletions(-)

(limited to 'support')

diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index c2cd08b6..2d70dae5 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -187,9 +187,11 @@ CREATE TABLE PackageComments (
 	UsersID INTEGER UNSIGNED NOT NULL,
 	Comments TEXT NOT NULl DEFAULT '',
 	CommentTS BIGINT UNSIGNED NOT NULL DEFAULT 0,
+	DelUsersID INTEGER UNSIGNED NOT NULL DEFAULT 0,
 	INDEX (UsersID),
 	INDEX (PackageID),
 	FOREIGN KEY (UsersID) REFERENCES Users(ID) ON DELETE CASCADE,
+	FOREIGN KEY (DelUsersID) REFERENCES Users(ID) ON DELETE CASCADE,
 	FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE
 );
 
diff --git a/support/schema/dummy-data.sql.bz2 b/support/schema/dummy-data.sql.bz2
index cf1c87a4..e342e287 100644
Binary files a/support/schema/dummy-data.sql.bz2 and b/support/schema/dummy-data.sql.bz2 differ
diff --git a/support/schema/gendummydata.py b/support/schema/gendummydata.py
index fd82bea3..9915f586 100755
--- a/support/schema/gendummydata.py
+++ b/support/schema/gendummydata.py
@@ -267,9 +267,9 @@ for p in seen_pkgs.keys():
 	#
 	num_comments = random.randrange(PKG_CMNTS[0], PKG_CMNTS[1])
 	for i in range(0, num_comments):
-		fortune = esc(commands.getoutput(FORTUNE_CMD).replace("'","").replace("\n"," "))
+		fortune = esc(commands.getoutput(FORTUNE_CMD).replace("'",""))
 		now = NOW + random.randrange(400, 86400*3)
-		s = "INSERT INTO PackageComments (PackageID, UsersID, Comments, CommentTS) VALUES (%d, %d, '%s', %d);\n" % (seen_pkgs[p], uuid, fortune, now)
+		s = "INSERT INTO PackageComments (PackageID, UsersID, Comments, CommentTS) VALUES (%d, %d, '%s', %d);\n" % (seen_pkgs[p], genUID(), fortune, now)
 		out.write(s)
 
 	if location_id == 1: # Unsupported - just a PKGBUILD and maybe other stuff
-- 
cgit v1.2.3-24-g4f1b