help design the structure if anyone can please.

[xcoderx]

guys help plan with categories thing, the idea is

 

Category

100 words description in text

    Subcategory name with link to next page-> post under subcategory with link to post details for next page again.

 

i need the table structure for it but not being able to do it

 

in subcategory there will title, place, date/time, description etc.

 

anyone could design the structure please? 

 

 

 

[xcoderx]

is this the righy way im doing?

 

--

-- Table structure for table `class_category`

--

 

CREATE TABLE IF NOT EXISTS `class_category` (

  `category_id` int(11) NOT NULL AUTO_INCREMENT,

  `category_name` varchar(100) NOT NULL,

  `category_description` text NOT NULL,

  PRIMARY KEY (`category_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

--

-- Dumping data for table `class_category`

--

 

 

-- --------------------------------------------------------

 

--

-- Table structure for table `class_users`

--

 

CREATE TABLE IF NOT EXISTS `class_users` (

  `identity` bigint(20) NOT NULL AUTO_INCREMENT,

  `user_name` varchar(20) NOT NULL,

  `password` varchar(20) NOT NULL,

  `f_name` varchar(30) NOT NULL,

  `l_name` varchar(30) NOT NULL,

  `email` varchar(50) NOT NULL,

  `user_auth` varchar(5) NOT NULL,

  `date` datetime NOT NULL,

  PRIMARY KEY (`identity`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

--

-- Dumping data for table `class_users`

--

[fenway]

I don't see a hierarchy anywhere.