MailFerret

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.

Tables

hdr_types

<mysql>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;</mysql>

hdr_lines

<mysql>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;</mysql>