[thesite] Tips Database

[Dean Mah]

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