Contents

drop table if exists version;
create table version (
  vmail_version text
);
create table if not exists messages (
  message_id text PRIMARY KEY,
  size integer,
  flags text,
  subject text,
  sender text,
  recipients text,
  date text,
  plaintext text,
  rfc822 text
);
create table if not exists labelings (
  label_id integer,
  message_id text,
  uid integer
);
create table if not exists labels (
  label_id integer PRIMARY KEY,
  name text UNIQUE
);

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
vmail-1.7.5	db/create.sql
vmail-1.7.4	db/create.sql
vmail-1.7.3	db/create.sql
vmail-1.7.2	db/create.sql
vmail-1.7.1	db/create.sql
vmail-1.7.0	db/create.sql
vmail-1.6.9	db/create.sql