1. Create the database by executing the following query:
CREATE DATABASE myblog
2. Create the
poststable:CREATE TABLE `myblog`.`posts` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `title` VARCHAR( 255 ) NOT NULL , `content` TEXT NOT NULL , `author_id` INT UNSIGNED NOT NULL , `publish_date` DATETIME NOT NULL ) ENGINE = MYISAM;
3. Create the
authorstable:CREATE TABLE `myblog`.`authors` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` VARCHAR( 50 ) NOT NULL ) ENGINE = MYISAM;
4. Create the
categoriestable:CREATE TABLE `myblog`.`categories` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` VARCHAR( 50 ) NOT NULL ) ENGINE = MYISAM;
5. Create the
posts_categoriestable:CREATE TABLE `myblog`.`posts_categories` ( `post_id` INT UNSIGNED NOT NULL , `category_id` INT UNSIGNED NOT NULL , PRIMARY KEY ( `post_id` , `category_id` ) ) ENGINE = MYISAM;
Sphinx Search Beginner's Guide
By :
Sphinx Search Beginner's Guide
By:
Overview of this book
Related Content you might be interested in
Current Title:
Sphinx Search Beginner's Guide
No titles found
Table of Contents (15 chapters)
Sphinx Search
Credits
About the Author
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Setting Up Sphinx
Getting Started
Indexing
Searching
Feed Search
Property Search
Sphinx Configuration
Customer Reviews