blob: 7c0a6451820dd07af5834f11375a00bc6664e4d8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
CREATE TABLE film_text (
film_id SMALLINT NOT NULL,
title VARCHAR(255) NOT NULL,
description TEXT,
PRIMARY KEY (film_id),
FULLTEXT KEY idx_title_description (title,description),
FULLTEXT KEY (description),
FULLTEXT KEY (title)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 ENCRYPTED=YES;
# shutdown server
# remove datadir
# xtrabackup move back
# restart
drop table film_text;
|
