FIXED

create table CARDS(
`id`INT NOT NULL AUTO_INCREMENT,
`CardName` VARCHAR(50) NOT NULL,
`CManaCost` INT NOT NULL,
`Type` ENUM('Creature','Enchantment','Sorcery','Instant','Land') NOT NULL,
`Rarity` ENUM('Mythic','Rare','Uncommon','Common','Land') NOT NULL,
`Color` ENUM('None','White','Green','Black','Red','Blue') NOT NULL,
`CORE_SETS` INT NULL,
`DUEL_DECKS` INT NULL,
`EXP_SETS` INT NULL,
`PLANECHASE` INT NULL,
`PREMIUM` INT NULL,
`REPRINTS` INT NULL,
PRIMARY KEY(`id`),
CONSTRAINT CoreSetFK CORE_SETS REFERENCES CORE_SETS(`id`)
        ON DELETE CASCADE,
CONSTRAINT DuelDecksFK DUEL_DECKS REFERENCES DUEL_DECKS(`id`)
        ON DELETE CASCADE,
CONSTRAINT ExpSetsFK EXP_SETS REFERENCES EXP_SETS(`id`)
        ON DELETE CASCADE,
CONSTRAINT VaultFK REFERENCES FROM_THE_VAULT(`id`)
        ON DELETE CASCADE,
CONSTRAINT PlaneChaseFK PLANECHASE REFERENCES PLANECHASE(`id`)
        ON DELETE CASCADE,
CONSTRAINT PremiumFK PREMIUM REFERENCES PREMIUM(`id`)
        ON DELETE CASCADE,
CONSTRAINT ReprintFK REPRINTS REFERENCES REPRINTS(`id`)
        ON DELETE CASCADE
);