[thesite] Tips Database

[Warden, Matt]

Martin, does thetips list still exist?

I can't recall exactly what all we were going to do with these eithe
(other than have them searchable). I think it would be cool to have like a
"tip of the day" type thing where a random tip was mailed to you every day
or that people could subscribe to a tips digest or maybe just the tips of
type they specify.

So, um, dean, you rock man.

Dan are we going to try and salvage the tips from the older mbox files?


werd (W3RD).

--
mattwarden
mattwarden.com

On Jul 22, Dean Mah had something to say about [thesite] Tips Database

>All of the tips in thelist.mbox file (to Sun Jul 22 14:09:21 2001)
>have been inserted into the test database.  I don't recall what you
>guys were going to do after this point so I'll leave you to it.  The
>table is called THELIST and looks like:
>
>
>SQL> desc thelist;
>Name					   Null?    Type
>----------------------------------------- -------- ----------------------------
> LISTID 					    NUMBER
> MESSAGEID					    NUMBER
> HDR_MESSAGEID					    VARCHAR2(80)
> HDR_FROMNAME					    VARCHAR2(255)
> HDR_FROMEMAIL					    VARCHAR2(255)
> HDR_TOEMAIL					    VARCHAR2(255)
> HDR_SUBJECT					    VARCHAR2(255)
> HDR_DATE					    VARCHAR2(80)
> HDR_INREPLYTO					    VARCHAR2(80)
> BDY_CONTENT					    LONG
>
>
>Have fun,
>Dean