e107inc/e107

CREATE TABLE private_msg (
  pm_id int(10) unsigned NOT NULL auto_increment,
  pm_from int(10) unsigned NOT NULL default '0',
  pm_to varchar(250) NOT NULL default '',
  pm_sent int(10) unsigned NOT NULL default '0',            /* Date sent */
  pm_read int(10) unsigned NOT NULL default '0',            /* Date read */
  pm_subject text NOT NULL,
  pm_text text NOT NULL,
  pm_sent_del tinyint(1) unsigned NOT NULL default '0',        /* Set when can delete */
  pm_read_del tinyint(1) unsigned NOT NULL default '0',        /* set when can delete */
  pm_attachments text NOT NULL,
  pm_option varchar(250) NOT NULL default '',                /* Options associated with PM - '+rr' for read receipt */
  pm_size int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (pm_id)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE private_msg_block (
  pm_block_id int(10) unsigned NOT NULL auto_increment,
  pm_block_from int(10) unsigned NOT NULL default '0',
  pm_block_to int(10) unsigned NOT NULL default '0',
  pm_block_datestamp int(10) unsigned NOT NULL default '0',
  pm_block_count int(10) unsigned NOT NULL default '0',            /* Counts number of blocked PMs */
  PRIMARY KEY  (pm_block_id)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;