ok i am creating an .sql file for my articles script that i plan to use for my site, once i got everything planned just right. anyways, if this is in the wrong forum move it to proper one .

ok here's everything i got so far...


create table article (
id
title
author
published
updated
length
bio
article rating
author rating
articles by author
);

ok here's where i get stumped, adding more stuff to the sql file. some of the fields will have multiple fields, and i was wondering how do i add all of to sql file.

like on the bio i want to be able to add a small image, along with some fields to kinda tell people who they are and whatnot.

did i confuse anybody? i hope not, anyways i hope someone can kindly explain how to do what i'm asking.