File: test.sql

Recommend this page to a friend!
  Classes of Taiwo Peace  >  PHP MySQL Full Text Search  >  test.sql  >  Download  
File: test.sql
Role: Unit test script
Content type: text/plain
Description: test sql
Class: PHP MySQL Full Text Search
Perform full text search on MySQL with autocorrect
Author: By
Last change:
Date: 6 years ago
Size: 2,333 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 20, 2014 at 08:40 AM
-- Server version: 5.5.24-log
-- PHP Version: 5.3.13

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `test`
--

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

--
-- Table structure for table `testorder`
--

CREATE TABLE IF NOT EXISTS `testorder` (
  `text_id` int(3) NOT NULL AUTO_INCREMENT,
  `text_name` text NOT NULL,
  `date` int(20) NOT NULL,
  PRIMARY KEY (`text_id`),
  KEY `text_id` (`text_id`),
  FULLTEXT KEY `text_name` (`text_name`),
  FULLTEXT KEY `text_name_2` (`text_name`),
  FULLTEXT KEY `text_name_3` (`text_name`),
  FULLTEXT KEY `text_name_4` (`text_name`),
  FULLTEXT KEY `text_name_5` (`text_name`),
  FULLTEXT KEY `text_name_6` (`text_name`),
  FULLTEXT KEY `text_name_7` (`text_name`),
  FULLTEXT KEY `text_name_8` (`text_name`),
  FULLTEXT KEY `text_name_9` (`text_name`),
  FULLTEXT KEY `text_name_10` (`text_name`),
  FULLTEXT KEY `text_name_11` (`text_name`),
  FULLTEXT KEY `text_name_12` (`text_name`),
  FULLTEXT KEY `text_name_13` (`text_name`),
  FULLTEXT KEY `text_name_14` (`text_name`),
  FULLTEXT KEY `text_name_15` (`text_name`),
  FULLTEXT KEY `text_name_16` (`text_name`),
  FULLTEXT KEY `text_name_17` (`text_name`),
  FULLTEXT KEY `text_name_18` (`text_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `testorder`
--

INSERT INTO `testorder` (`text_id`, `text_name`, `date`) VALUES
(6, 'hillodss', 20141114),
(7, 'djfjfhofkfkf', 20141114),
(8, 'hrfrllodssfjfdfrfr', 20141114),
(9, 'MySQL is a very fast database', 20141114),
(10, 'Green is everyone''s favourite colour', 20141114),
(11, 'Databases are helpful for storing data', 20141114),
(12, 'PHP is a very nice language', 20141114),
(13, 'PHP is a very nice language', 20141114);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

For more information send a message to info at phpclasses dot org.