-
Book Overview & Buying
-
Table Of Contents
Learning Joomla! 1.5 Extension Development - Second Edition
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...