Просмотр файла docs/tables/pieces.txt

+--------+------------------------------------------------------+------+-----+---------+-------+
| Field  | Type                                                 | Null | Key | Default | Extra |
+--------+------------------------------------------------------+------+-----+---------+-------+
| gameID | smallint(6)                                          |      |     | 0       |       |
| color  | enum('white','black')                                |      |     | white   |       |
| piece  | enum('pawn','rook','knight','bishop','queen','king') |      |     | pawn    |       |
| col    | smallint(6)                                          |      |     | 0       |       |
| row    | smallint(6)                                          |      |     | 0       |       |
+--------+------------------------------------------------------+------+-----+---------+-------+

CREATE TABLE pieces (
	gameID SMALLINT NOT NULL,
	color ENUM('white','black') NOT NULL,
	piece ENUM('pawn','rook','knight','bishop','queen','king') NOT NULL,
	col SMALLINT NOT NULL,
	row SMALLINT NOT NULL
);