Woozle: two tables - saving for now

2008-05-09T11:29:56Z

two tables - saving for now

New page

==Overview==
[[MailFerret]] is [[User:Woozle|Woozle]]'s attempt to create a [[database]]-driven [[email client]] with specific features.

Project was started over on [[htwiki:MailFerret|HypertWiki]]; documentation will be built up here on HTYP gradually.
==Tables==
===hdr_types===
<section begin=sql /><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>
<section end=sql />
===hdr_lines===
<section begin=sql /><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>

MailFerret - Revision history

Woozle: two tables - saving for now