   id INT(11) NOT NULL AUTO_INCREMENT,
   instrument_id INT(11) NOT NULL,
   member_id INT(11) NOT NULL,
-  PRIMARY KEY (id)
-  FOREIGN KEY (instrument_id) REFERENCES instruments(id) ON DELETE CASCADE
+  PRIMARY KEY (id),
+  FOREIGN KEY (instrument_id) REFERENCES instruments(id) ON DELETE CASCADE,
   FOREIGN KEY (member_id) REFERENCES members(id) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 

  id INT(11) NOT NULL AUTO_INCREMENT,
  title VARCHAR(255) NOT NULL,
  path VARCHAR(255) NOT NULL,
  PRIMARY KEY (id),
  UNIQUE(id, path)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE titles (
  id INT(11) NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  concert_id INT(11) NOT NULL,
  order TINYINT UNSIGNED(2),
  act TINYINT UNSIGEND(2),
  PRIMARY KEY (id),
  FOREIGN KEY (concert_id) REFERENCES concerts(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

  id INT(11) NOT NULL AUTO_INCREMENT,
  band_id INT(11) NOT NULL,
  member_id INT(11) NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY (band_id) REFERENCES bands(id) ON DELETE CASCADE,
  FOREIGN KEY (member_id) REFERENCES members(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
