blob: 01a99e592000b85c48e99a1ca7a9c28aa786826e (
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 server
drop table film_text;
|
