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 INDEX idx_labelings ON labelings(message_id, label_id);

create table if not exists labels (
  label_id integer PRIMARY KEY,
  name text UNIQUE
);

Version data entries

118 entries across 118 versions & 1 rubygems

Version	Path
vmail-2.9.11	db/create.sql
vmail-2.9.10	db/create.sql
vmail-2.9.9	db/create.sql
vmail-2.9.8	db/create.sql
vmail-2.9.7	db/create.sql
vmail-2.9.6	db/create.sql
vmail-2.9.5	db/create.sql
vmail-2.9.4	db/create.sql
vmail-2.9.3	db/create.sql
vmail-2.9.2	db/create.sql
vmail-2.9.1	db/create.sql
vmail-2.9.0	db/create.sql
vmail-2.8.9	db/create.sql
vmail-2.8.7	db/create.sql
vmail-2.8.6	db/create.sql
vmail-2.8.5	db/create.sql
vmail-2.8.4	db/create.sql
vmail-2.8.2	db/create.sql
vmail-2.8.1	db/create.sql
vmail-2.8.0	db/create.sql