Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- );ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CORE_SETS REFERENCES CORE_SETS(id) ON DELETE CASCADE, CONSTRAINT' at line 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement