Moved all the long descriptions out of the bugs table, and into a new

table.  There is now a separate entry for each new long description,
rather than appending them all together in one big field.

1 files changed, 5 insertions, 2 deletions

diff --git a/post_bug.cgi b/post_bug.cgi
index 93e7b3226..c3be5c67b 100755
--- a/post_bug.cgi
+++ b/post_bug.cgi
@@ -128,7 +128,7 @@ foreach my $f (@bug_fields) {
 }
 
 my $query = "insert into bugs (\n" . join(",\n", @used_fields) . ",
-creation_ts, long_desc )
+creation_ts )
 values (
 ";
 
@@ -142,7 +142,7 @@ $comment =~ s/\r\n/\n/g;     # Get rid of windows-style line endings.
 $comment =~ s/\r/\n/g;       # Get rid of mac-style line endings.
 $comment = trim($comment);
 
-$query .= "now(), " . SqlQuote($comment) . " )\n";
+$query .= "now())\n";
 
 
 my %ccids;
@@ -164,6 +164,9 @@ SendSQL($query);
 SendSQL("select LAST_INSERT_ID()");
 my $id = FetchOneColumn();
 
+SendSQL("INSERT INTO longdescs (bug_id, who, bug_when, thetext) VALUES " .
+        "($id, $::FORM{'reporter'}, now(), " . SqlQuote($comment) . ")");
+
 foreach my $person (keys %ccids) {
     SendSQL("insert into cc (bug_id, who) values ($id, $person)");
 }