From c9782a782be1f388b3dcbf15dc86f3123815384f Mon Sep 17 00:00:00 2001 From: Don Armstrong Date: Tue, 7 Mar 2017 18:59:02 -0800 Subject: [PATCH] to/from_addr are pointless columns; remove them --- sql/debbugs_schema.sql | 4 ---- 1 file changed, 4 deletions(-) diff --git a/sql/debbugs_schema.sql b/sql/debbugs_schema.sql index 9069030..7779a35 100644 --- a/sql/debbugs_schema.sql +++ b/sql/debbugs_schema.sql @@ -458,9 +458,7 @@ CREATE TABLE message ( id SERIAL PRIMARY KEY, msgid TEXT NOT NULL DEFAULT '', from_complete TEXT NOT NULL DEFAULT '', - from_addr TEXT NOT NULL DEFAULT '', to_complete TEXT NOT NULL DEFAULT '', - to_addr TEXT NOT NULL DEFAULT '', subject TEXT NOT NULL DEFAULT '', sent_date TIMESTAMP WITH TIME ZONE, refs TEXT NOT NULL DEFAULT '', @@ -471,9 +469,7 @@ INSERT INTO table_comments VALUES ('message','Messages sent to bugs'); INSERT INTO column_comments VALUES ('message','id','Message id'); INSERT INTO column_comments VALUES ('message','msgid','Message id header'); INSERT INTO column_comments VALUES ('message','from_complete','Complete from header of message'); -INSERT INTO column_comments VALUES ('message','from_addr','Address(es) of From: headers'); INSERT INTO column_comments VALUES ('message','to_complete','Complete to header of message'); -INSERT INTO column_comments VALUES ('message','to_addr','Address(es) of To: header'); INSERT INTO column_comments VALUES ('message','subject','Subject of the message'); INSERT INTO column_comments VALUES ('message','sent_date','Time/date message was sent (from Date header)'); INSERT INTO column_comments VALUES ('message','refs','Contents of References: header'); -- 2.39.2