Sha256: 55b836659fec82dcf714dab6d614c89eb88489d2992f925979df9ba7a3b10f4c

Contents?: true

Size: 524 Bytes

Versions: 118

Compression:

Stored size: 524 Bytes

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.7.8 db/create.sql
vmail-2.7.7 db/create.sql
vmail-2.7.6 db/create.sql
vmail-2.7.5 db/create.sql
vmail-2.7.4 db/create.sql
vmail-2.7.3 db/create.sql
vmail-2.7.1 db/create.sql
vmail-2.7.0 db/create.sql
vmail-2.6.9 db/create.sql
vmail-2.6.7 db/create.sql
vmail-2.6.6 db/create.sql
vmail-2.6.5 db/create.sql
vmail-2.6.4 db/create.sql
vmail-2.6.3 db/create.sql
vmail-2.6.2 db/create.sql
vmail-2.6.1 db/create.sql
vmail-2.6.0 db/create.sql
vmail-2.5.9 db/create.sql
vmail-2.5.8 db/create.sql
vmail-2.5.7 db/create.sql