Page 1 of 1

[56K WARN] Coding a blog, need help with database structure

Posted: Sun Oct 15, 2006 1:12 pm
by adamb10
Alright, Im gonna code a blog and it's in the planning stages. It's gonna use MySQL but my last script kinda showed the flaws of my database design.

Here is a db design I used:

Image
This comes from a bans table.

Here is a way I learned from this site...

Image
Clicking on Browse is PHPMyadmin would show this...

Image

So the question I bring to you is, what is the smart way to do the DB design?

Thanx!

Posted: Sat Oct 21, 2006 9:01 am
by adamb10
bump.

Posted: Sat Oct 21, 2006 9:05 am
by ZephyrWest
My question is: Why reinvent the wheel? There are several high quality blogs out there that you can download for free, most notably WordPress.

Posted: Sat Oct 21, 2006 10:03 am
by adamb10
I dont wanna actually distribute it, just something to do when I'm bored.

Posted: Sun Oct 22, 2006 12:00 am
by ZephyrWest
Ok, well there's really not much to say since it doesn't look anywhere near finished. I would suggest a tutorial on relational database design.

Posted: Thu Oct 26, 2006 12:00 pm
by adamb10
The screenshots above were from an old script of mine. I just need to know how to do the DB design before I dive in coding. :)

Thanx for the article also. :)