suggestion about schema

[hamza]

-- ----------------------------
-- Table structure for articals
-- ----------------------------
CREATE TABLE `articals` (
  `artical_id` int(11) NOT NULL auto_increment,
  `cat_id` int(11) default NULL,
  `title` varchar(255) default NULL,
  `dateandtime` datetime default NULL,
  `img` varchar(255) default NULL,
  `description` text,
  `tags` varchar(255) default NULL,
  PRIMARY KEY  (`artical_id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;


catagory table
- ----------------------------
-- Table structure for categories
-- ----------------------------
CREATE TABLE `categories` (
  `cat_id` int(11) NOT NULL auto_increment,
  `cat_name` varchar(255) default NULL,
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

 

problem :

when i del catagory from catagory table then evey artical have catagory field.

but if i del a catagory which is present in artical table then.

it soud ugly or what should i do del the artical when del the catagory.

kindly guide me and see the data schema.

 

 

 

 

 

[hamza]

kindly help me out

[fenway]

We'll pretend "artical" is a word for the moment.... are you talking about foreign keys? I don't follow.