|
From: <li...@av...> - 2003-05-22 18:36:34
|
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) > ); |