PHP Classes

File: search.sql

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: 1 year 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;