PHP Classes

File: SQL File

Recommend this page to a friend!
  Classes of Faris AL-Otabi   Searchy PHP Search Engine   search.sql   Download  
File: search.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Searchy PHP Search Engine
Crawl, index and search multiple Web sites
Author: By
Last change:
Date: 2 years ago
Size: 474 bytes
 

Contents

Class file image Download 
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

CREATE TABLE `sites` (
  `id` int UNSIGNED NOT NULL,
  `title` text NOT NULL,
  `blurb` text NOT NULL,
  `keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `url` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

ALTER TABLE `sites`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `sites`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;