[thelist] MySQL Tables for weblog
rudy
r937 at interlog.com
Sat Mar 16 08:49:01 CST 2002
>Table Entries
>ID (key) | Title of post | Date | Entry
>
>Table Comments
>Postername | comment | email | entryid
hi lach
the Comments table will probably want an ID of its own, and both it and the
ID of Entries should be auto_increment
the Comments table should also have a date column, and both date columns
should actually be datetime -- and don't call them "Date" which is a
reserved word
you might (it's just a thought) consider some kind of field to hold the
"permalink" anchors which all blogs have, because the auto_increment fields
aren't very good for that purpose
rudy
More information about the thelist
mailing list