Suggest Table Structure
| From: | kachaloo | Date: | Thu, 05 Jul 2001 09:01:55 +0000 |
| Subject: | Suggest Table Structure | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-56282@lists.php.net to get a copy of this message | ||
Hi guys,
I am making a table which will store articles for a site
and the feilds are :
ID int(6) NOT NULL auto_increment,
CATEORY varchar(10) NOT NULL DEFAULT 'EVENTS' ,
HEADING varchar(30) NOT NULL DEFAULT '' ,
BODY longblob ,
PICTURE longblob ,
KEYWORD varchar(30) NOT NULL DEFAULT '' ,
FILENAME varchar(50) ,
FILESIZE varchar(50) ,
FILETYPE varchar(50) ,
PRIMARY KEY (ID),
UNIQUE ID (ID)
But now I noticed some of the articles will have more than one
picture... so how do I structure my talbe ?
Thanks in advance,
Vishal