File size: 1.07Kb
+--------+------------------------------------------------------+------+-----+---------+-------+
| 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
);