Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
- CREATE TABLE film_text1 (
- 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;
- CREATE TABLE film_text2 (
- 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;
- CREATE TABLE film_text3 (
- 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;
- CREATE TABLE film_text4(
- 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;
- CREATE TABLE film_text5 (
- 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;
- CREATE TABLE film_text6 (
- 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;
- CREATE TABLE film_text7 (
- 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;
- CREATE TABLE film_text8 (
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement