[thesite] need another template..

Daniel J. Cody djc at starkmedia.com
Fri Mar 2 16:09:50 CST 2001

ok, here's what I got.. for testting purposes, we're using SQL server 
here, not that it matters.. the datasource name in CF is 'thelist'
shouldnt hdr_inreplyto be a number?

anyways, whenever you get around to it, hve fun and lemm eknow if you 
have problems ;) thanks again seth

CREATE TABLE [thelist] (
	[listid] [int] NULL ,
	[messageid] [int] NOT NULL ,
	[hdr_messageid] [int] NOT NULL ,
	[hdr_fromname] [varchar] (75) NOT NULL ,
	[hdr_fromemail] [varchar] (100) NOT NULL ,
	[hdr_toemail] [varchar] (100) NULL ,
	[hdr_subject] [varchar] (100) NOT NULL ,
	[hdr_date] [datetime] NOT NULL ,
	[hdr_inreplyto] [varchar] (75) NULL ,
	[bdy_content] [text] NOT NULL

Seth Bienek wrote:

> listid (fk to lookup table with list names)
> messageid (pk)
> hdr_message-id (text-75char)
> hdr_fromemail (text-100char)
> hdr_fromname (text-100char)
> hdr_toemail (text-100char - optional may be used instead of listid?)
> hdr_subject (text-100char)
> hdr_date (date)
> hdr_in-reply-to (text-75char)
> bdy_content (long, memo, whatever)

More information about the thesite mailing list