CREATE TABLE `card_database` (
  `index` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(128) COLLATE latin1_swedish_ci DEFAULT NULL,
  `manacost` VARCHAR(128) COLLATE latin1_swedish_ci DEFAULT NULL,
  `type` VARCHAR(128) COLLATE latin1_swedish_ci DEFAULT NULL,
  `subtype` VARCHAR(128) COLLATE latin1_swedish_ci DEFAULT NULL,
  `supertype` VARCHAR(128) COLLATE latin1_swedish_ci DEFAULT NULL,
  `ability` VARCHAR(256) COLLATE latin1_swedish_ci DEFAULT NULL,
  `power` INTEGER(11) DEFAULT NULL,
  `toughness` INTEGER(11) DEFAULT NULL,
  `handmodifier` INTEGER(11) DEFAULT 0,
  `lifemodifier` INTEGER(11) DEFAULT 0,
  `expansionsymbol` VARCHAR(20) COLLATE latin1_swedish_ci DEFAULT 'seventh',
  PRIMARY KEY USING BTREE (`index`) COMMENT ''
)ENGINE=InnoDB
AUTO_INCREMENT=23 AVG_ROW_LENGTH=744 CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci'
COMMENT=''
;