[thesite] Tips Database

[Daniel J. Cody]

rulez! would you mind running this once more though? :)

i have the mbox file from the first year of thelist, and it may be cool 
to put that in there..

also, was checking out the data, and it looks like you've got just the 
<tip>'s in there. would i be a serious bitch if i asked that you just 
take the entire message body and insert it into thelist table? then we 
could run through that, grep out tips, and associate them with a 
messageid from thelist table..

does that make sense? i just figure if we should get everything we can 
out of the mbox's while you're kind enough to do this :)

.djc.


Dean Mah wrote:

> 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
> 
> _______________________________________________
> For unsubscribe, archive, and options, go to:
> http://lists.evolt.org/mailman/listinfo/thesite
>