From 78865fda79e5b78288aafd75b531924c73b27883 Mon Sep 17 00:00:00 2001
From: "terry%mozilla.org" <>
Date: Fri, 21 Jan 2000 05:31:18 +0000
Subject: 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.

---
 post_bug.cgi | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

(limited to 'post_bug.cgi')

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)");
 }
-- 
cgit v1.2.3-24-g4f1b