CREATE TABLE privatemsg (
  id            int(10) unsigned NOT NULL auto_increment primary key,
  author        int(10) unsigned NOT NULL,
  recipient     int(10) unsigned NOT NULL,
  subject       varchar(64) NOT NULL,
  message       text NOT NULL,
  timestamp     int(11) unsigned NOT NULL,
  newmsg        tinyint unsigned NOT NULL,
  hostname      varchar(255) NOT NULL,
  folder        int(10) unsigned NOT NULL DEFAULT '0',
  author_del    tinyint unsigned NOT NULL,
  recipient_del tinyint unsigned NOT NULL,
  format        int(4) NOT NULL DEFAULT '0',
  key (recipient),
  key (folder)
);

CREATE TABLE privatemsg_folder (
  fid           int(10) unsigned NOT NULL auto_increment primary key,
  uid           int(10) unsigned NOT NULL,
  name          varchar(255) NOT NULL
);

INSERT INTO privatemsg_folder VALUES (1, 0, 'Sent');

CREATE TABLE privatemsg_archive (
  id            int(10) unsigned NOT NULL auto_increment primary key,
  author        int(10) unsigned NOT NULL,
  recipient     int(10) unsigned NOT NULL,
  subject       VARCHAR(64) NOT NULL,
  message       text NOT NULL,
  timestamp     int(11) unsigned NOT NULL,
  hostname      varchar(255) NOT NULL,
  folder        int(10) unsigned NOT NULL,
  format        int(4) NOT NULL DEFAULT '0',
  key (recipient)
);