Menu
▾
▴
Re: [maildb-cvs] cvs commit: maildb/libmaildb/db/mysql/doc cr_maildb.sql design.html
|
From: Jeff S. <jsq...@os...> - 2003-05-30 13:15:14
|
On Fri, 30 May 2003, Jeff Squyres wrote:
> What were the essential changes that you made, since this diff is
> practically useless?
Here's that diff again, ignoring whitespace (I've updated the CVS
scripty-foo to ignore whitespace to avoid this problem in the future):
Index: cr_maildb.sql
===================================================================
RCS file: /cvsroot/maildb/maildb/libmaildb/db/mysql/doc/cr_maildb.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -c -w -r1.6 -r1.7
*** cr_maildb.sql 22 May 2003 18:37:49 -0000 1.6
--- cr_maildb.sql 30 May 2003 00:18:00 -0000 1.7
***************
*** 5,11 ****
-- information, see the LICENSE file in the top level directory of the
-- MailDB source distribution.
--
! -- $Id: cr_maildb.sql,v 1.6 2003/05/22 18:37:49 lweissler Exp $
-- -------------------------------------------------------
-- maildb tables
--- 5,11 ----
-- information, see the LICENSE file in the top level directory of the
-- MailDB source distribution.
--
! -- $Id: cr_maildb.sql,v 1.7 2003/05/30 00:18:00 jlscott3 Exp $
-- -------------------------------------------------------
-- maildb tables
***************
*** 104,114 ****
m_from text,
m_in_reply_to text,
m_sender text,
m_parent_id integer,
m_vw_incl text,
m_vw_excl text,
primary key (m_id),
! index m_msg_id_idx (m_msg_id)
);
-- msg_hdrs
--- 104,120 ----
m_from text,
m_in_reply_to text,
m_sender text,
+ m_reply_to text,
+ m_references text,
m_parent_id integer,
m_vw_incl text,
m_vw_excl text,
primary key (m_id),
! index m_msg_id_idx (m_msg_id),
! index m_date_idx(m_date),
! index m_from_idx(m_from(255)),
! index m_to_idx (m_to(255)),
! index m_subject_idx (m_subject(255))
);
-- msg_hdrs
Index: design.html
===================================================================
RCS file: /cvsroot/maildb/maildb/libmaildb/db/mysql/doc/design.html,v
retrieving revision 1.6
retrieving revision 1.7
diff -c -w -r1.6 -r1.7
*** design.html 22 May 2003 18:37:49 -0000 1.6
--- design.html 30 May 2003 00:18:00 -0000 1.7
***************
*** 125,131 ****
</td>
<td valign="top">Numeric message record identifier (m_id)<br>
</td>
! <td valign="top">Message id (m_msg_id)<br>
</td>
<td valign="top">n/a<br>
</td>
--- 125,132 ----
</td>
<td valign="top">Numeric message record identifier (m_id)<br>
</td>
! <td valign="top">Message id (m_msg_id)<br>Date (m_date)<br>
! From (m_from)<br>To (m_to)<br>Subject (m_subject)
</td>
<td valign="top">n/a<br>
</td>
***************
*** 378,384 ****
</td>
<td valign="top"><br>
</td>
! <td valign="top"><br>
</td>
<td valign="top">To header line contents<br>
</td>
--- 379,385 ----
</td>
<td valign="top"><br>
</td>
! <td valign="top">X<br>
</td>
<td valign="top">To header line contents<br>
</td>
***************
*** 414,420 ****
</td>
<td valign="top"><br>
</td>
! <td valign="top"><br>
</td>
<td valign="top">Subject header line contents<br>
</td>
--- 415,421 ----
</td>
<td valign="top"><br>
</td>
! <td valign="top">X<br>
</td>
<td valign="top">Subject header line contents<br>
</td>
***************
*** 422,432 ****
<tr>
<td valign="top">m_date<br>
</td>
! <td valign="top">text<br>
</td>
<td valign="top"><br>
</td>
! <td valign="top"><br>
</td>
<td valign="top">Date header line contents<br>
</td>
--- 423,433 ----
<tr>
<td valign="top">m_date<br>
</td>
! <td valign="top">datetime<br>
</td>
<td valign="top"><br>
</td>
! <td valign="top">X<br>
</td>
<td valign="top">Date header line contents<br>
</td>
***************
*** 438,444 ****
</td>
<td valign="top"><br>
</td>
! <td valign="top"><br>
</td>
<td valign="top">From header line contents<br>
</td>
--- 439,445 ----
</td>
<td valign="top"><br>
</td>
! <td valign="top">X<br>
</td>
<td valign="top">From header line contents<br>
</td>
***************
*** 468,473 ****
--- 469,498 ----
</td>
</tr>
<tr>
+ <td valign="top">m_reply_to<br>
+ </td>
+ <td valign="top">text<br>
+ </td>
+ <td valign="top"><br>
+ </td>
+ <td valign="top"><br>
+ </td>
+ <td valign="top">Reply-To header line contents<br>
+ </td>
+ </tr>
+ <tr>
+ <td valign="top">m_references<br>
+ </td>
+ <td valign="top">text<br>
+ </td>
+ <td valign="top"><br>
+ </td>
+ <td valign="top"><br>
+ </td>
+ <td valign="top">References header line contents<br>
+ </td>
+ </tr>
+ <tr>
<td valign="top">m_parent_id<br>
</td>
<td valign="top">integer<br>
***************
*** 793,799 ****
</p>
<p>...where (U) = unsigned, and L = length of text string. </p>
<p></p>
! <hr><i>Last update: 17 October 2002 by <a href="mailto:li...@av...">Liza
! Weissler</a></i><a href="mailto:li...@av..."> </a><br>
</body>
</html>
--- 818,824 ----
</p>
<p>...where (U) = unsigned, and L = length of text string. </p>
<p></p>
! <hr><i>Last update: 22 May 2003 by <a href="mailto:jls...@do...">James
! Scott</a></i><br>
</body>
</html>
--
{+} Jeff Squyres
{+} jsq...@os...
{+} Research Associate, Open Systems Lab, Indiana University
{+} http://www.osl.iu.edu/
|
