Most visitors will take our word for it when we say that a restaurant is great (or that it isn't). However, there may be a few who disagree. Why not give them the opportunity to leave comments about their experiences with the restaurant? We'll need a place to store these comments, so enter the following SQL command into your database console:
CREATE TABLE `jos_reviews_comments` ( `id` int(11) NOT NULL auto_increment, `review_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `full_name` varchar(50) NOT NULL, `comment_date` datetime NOT NULL, `comment_text` text NOT NULL, PRIMARY KEY (`id`) )
If you're using phpMyAdmin, pull up the following screen and enter jos_reviews_comments as the table name and 6 in the Number of fields section:
After clicking Go, a grid is displayed. Fill in the details so that it looks like the following screen:
Make sure that you make the field id into an automatically-incremented primary key:
We also want to add another database class to handle...