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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
adamb10
Forum Commoner
Posts: 91
Joined: Sat Jun 24, 2006 7:44 pm

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

Post 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!
adamb10
Forum Commoner
Posts: 91
Joined: Sat Jun 24, 2006 7:44 pm

Post by adamb10 »

bump.
ZephyrWest
Forum Newbie
Posts: 7
Joined: Mon Oct 16, 2006 9:39 pm

Post 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.
adamb10
Forum Commoner
Posts: 91
Joined: Sat Jun 24, 2006 7:44 pm

Post by adamb10 »

I dont wanna actually distribute it, just something to do when I'm bored.
ZephyrWest
Forum Newbie
Posts: 7
Joined: Mon Oct 16, 2006 9:39 pm

Post 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.
adamb10
Forum Commoner
Posts: 91
Joined: Sat Jun 24, 2006 7:44 pm

Post 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. :)
Post Reply