Skip to content

Instantly share code, notes, and snippets.

View JakubTesarek's full-sized avatar
🏠
Working from home

Jakub Tesárek JakubTesarek

🏠
Working from home
View GitHub Profile
@JakubTesarek
JakubTesarek / InnoDb_fulltext.sql
Created April 8, 2013 11:11
Fulltext searching in InnoDb table.
-- MAIN INNODB TABLE FOR ARTICLES
CREATE TABLE `article` (
`id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`title` VARCHAR(50) NOT NULL,
`abstract` TEXT NOT NULL,
`content` MEDIUMTEXT NOT NULL,
`publish_date` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'