[maildb-devel] Re: messages in/out of database

[<li...@av...>]

Oops.  I don't imagine m_parent_id can be -1 if I define the field as 
integer unsigned.  Make that integer.  :-) 

li...@av... writes: 

> Ok, so here are today's changes made on queeg.  
> 
> -- msg_ids adds some "header" cols, and m_parent_id (which would map to 
> another m_id, or be -1 if message is standalone).  
> 
> create table msg_ids (
> m_id         integer unsigned not null auto_increment,
> m_msg_id     varchar(255) not null,
> m_to         text,
> m_cc         text,
> m_bcc        text,
> m_subject    text,
> m_date       datetime,
> m_from       text,
> m_in_reply_to text,
> m_sender     text,
> m_parent_id  integer unsigned,
> m_vw_incl    text,
> m_vw_excl    text,
> primary key  (m_id),
> index        m_msg_id_idx (m_msg_id)
> );