sqlplain/tests/books-schema.sql


1
2
3
4
5
6
7
8
9

CREATE TABLE score(
  score VARCHAR(4) PRIMARY KEY);

CREATE TABLE book(
 title VARCHAR(64),
 author VARCHAR(64),
 score VARCHAR(4) REFERENCES score (score),
 PRIMARY KEY (author, title)
);