DROP TABLE IF EXISTS Coins;
CREATE TABLE Coins (
  Value int(3) NOT NULL default 0,
  Colour char(15) NOT NULL default '',
  ColourCode int(1) NOT NULL default 0,
  PRIMARY KEY (value),
  KEY ColIndex (ColourCode) 
) ENGINE=NDBCLUSTER DEFAULT CHARSET=latin1;