Skip to content

Instantly share code, notes, and snippets.

@kou

kou/schema.sql

Created January 7, 2015 02:09
Show Gist options
  • Save kou/18a96efac421b9ef417f to your computer and use it in GitHub Desktop.
Save kou/18a96efac421b9ef417f to your computer and use it in GitHub Desktop.
Download ZIP
テストに使ったスキーマ
Raw
schema.sql
DROP DATABASE IF EXISTS mroonga;
CREATE DATABASE mroonga;
USE mroonga;
SET NAMES utf8mb4;
CREATE TABLE entries (
id INT NOT NULL PRIMARY KEY,
text1 TEXT NOT NULL,
text2 TEXT NOT NULL,
FULLTEXT INDEX (text1, text2)
) Engine=Mroonga DEFAULT CHARSET=utf8mb4;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment