MailFerret

From HTYP, the free directory anyone can edit

Contents 1 Overview 2 Tables 2.1 hdr_types 2.2 hdr_lines

[edit] Overview

MailFerret is Woozle's attempt to create a database-driven email client with specific features.

Project was started over on HypertWiki; documentation will be built up here on HTYP gradually.

[edit] Tables

[edit] hdr_types

CREATE TABLE `hdr_types` (
  `ID` INT  NOT NULL AUTO_INCREMENT,
  `Key` VARCHAR(63) COMMENT "header identifier string",
  `Descr` VARCHAR(255) COMMENT "descriptive/explanatory text",
  PRIMARY KEY(`ID`)
 )
 ENGINE = MYISAM;

[edit] hdr_lines

CREATE TABLE `hdr_lines` (
  `ID_Msg` INT NOT NULL COMMENT "core_msgs.ID",
  `Line` INT NOT NULL COMMENT "line #, i.e. order in which this line appears in header",
  `ID_Type` INT NOT NULL COMMENT "hdr_types.ID",
  `Data`  TEXT COMMENT "contents of header line; assuming <64kb",
  PRIMARY KEY(`ID_Msg`,`Line`)
 )
 ENGINE = MYISAM;