RobinNixon
10 lines
195 B
SQL
10 lines
195 B
SQL
CREATE TABLE classics (
|
|
author VARCHAR(128),
|
|
title VARCHAR(128),
|
|
category VARCHAR(16),
|
|
year SMALLINT,
|
|
INDEX(author(20)),
|
|
INDEX(title(20)),
|
|
INDEX(category(4)),
|
|
INDEX(year)) ENGINE InnoDB;
|