[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


More information about the thelist mailing list