[maildb-cvs] cvs commit: maildb/libmaildb/db/mysql/doc cr_maildb.sql design.html message.sql

[Liza W. <lwe...@us...>]

lweissler    03/05/21 14:04:19

  Modified:    libmaildb/db/mysql/doc cr_maildb.sql design.html message.sql
  Log:
  Added m_vw_incl, mv_vw_excl fields to msg_ids table, to be used to
  indicate views that a message should be included in/excluded from.

Revision  Changes    Path
1.4       +3 -1      maildb/libmaildb/db/mysql/doc/cr_maildb.sql

Index: cr_maildb.sql
===================================================================
RCS file: /cvsroot/maildb/maildb/libmaildb/db/mysql/doc/cr_maildb.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -c -r1.3 -r1.4
*** cr_maildb.sql	21 Dec 2002 14:06:57 -0000	1.3
--- cr_maildb.sql	21 May 2003 21:04:19 -0000	1.4
***************
*** 5,11 ****
  -- information, see the LICENSE file in the top level directory of the
  -- MailDB source distribution.
  --
! -- $Id: cr_maildb.sql,v 1.3 2002/12/21 14:06:57 jsquyres 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.4 2003/05/21 21:04:19 lweissler Exp $
  -- -------------------------------------------------------
  
  -- maildb tables
***************
*** 96,101 ****
--- 96,103 ----
  create table msg_ids (
    m_id	       integer unsigned not null auto_increment,
    m_msg_id     varchar(255) not null,
+   m_vw_incl    text,
+   m_vw_excl    text,
    primary key  (m_id),
    index	       m_msg_id_idx (m_msg_id)
  ); 



1.4       +24 -0     maildb/libmaildb/db/mysql/doc/design.html

Index: design.html
===================================================================
RCS file: /cvsroot/maildb/maildb/libmaildb/db/mysql/doc/design.html,v
retrieving revision 1.3
retrieving revision 1.4
diff -c -r1.3 -r1.4
*** design.html	21 Dec 2002 14:06:57 -0000	1.3
--- design.html	21 May 2003 21:04:19 -0000	1.4
***************
*** 372,377 ****
--- 372,401 ----
        </td>
      </tr>
      <tr>
+       <td valign="top">m_vw_incl<br>
+       </td>
+       <td valign="top">text<br>
+       </td>
+       <td valign="top"><br>
+       </td>
+       <td valign="top">X<br>
+       </td>
+       <td valign="to">Specify views in which to include this message<br>
+       </td>
+     </tr>
+     <tr>
+       <td valign="top">m_vw_excl<br>
+       </td>
+       <td valign="top">text<br>
+       </td>
+       <td valign="top"><br>
+       </td>
+       <td valign="top">X<br>
+       </td>
+       <td valign="top">Specify views from which to exclude this message<br>
+       </td>
+     </tr>
+     <tr>
      <td valign="top" rowspan="5">msg_hdrs</td>
      <td>mh_id</td>
      <td>integer unsigned not null auto_increment</td>



1.4       +2 -2      maildb/libmaildb/db/mysql/doc/message.sql

Index: message.sql
===================================================================
RCS file: /cvsroot/maildb/maildb/libmaildb/db/mysql/doc/message.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -c -r1.3 -r1.4
*** message.sql	21 Dec 2002 14:06:57 -0000	1.3
--- message.sql	21 May 2003 21:04:19 -0000	1.4
***************
*** 5,11 ****
  -- information, see the LICENSE file in the top level directory of the
  -- MailDB source distribution.
  --
! -- $Id: message.sql,v 1.3 2002/12/21 14:06:57 jsquyres Exp $
  -- -------------------------------------------------------
  
  delete from config where cf_name is not null;
--- 5,11 ----
  -- information, see the LICENSE file in the top level directory of the
  -- MailDB source distribution.
  --
! -- $Id: message.sql,v 1.4 2003/05/21 21:04:19 lweissler Exp $
  -- -------------------------------------------------------
  
  delete from config where cf_name is not null;
***************
*** 17,23 ****
  insert into config values ('fs_path', '/home/lyw/maildb/foo');
  insert into config values ('max_msg_size', '99999999');
  
! insert into msg_ids values (NULL, '<001801c27523$aa5d46a0$af270444@CX434770b>');
  
  insert into msg_hdrs values (NULL, 1,
         'From', 'lyu...@co... Wed Oct 16 10:53:33 2002', 0);
--- 17,23 ----
  insert into config values ('fs_path', '/home/lyw/maildb/foo');
  insert into config values ('max_msg_size', '99999999');
  
! insert into msg_ids values (NULL, '<001801c27523$aa5d46a0$af270444@CX434770b>',NULL,NULL);
  
  insert into msg_hdrs values (NULL, 1,
         'From', 'lyu...@co... Wed Oct 16 10:53:33 2002', 0);