Advertisement
Braber01

Still getting the same bloody error

Oct 1st, 2012
368
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create table CARDS(
  2. id INT NOT NULL AUTO_INCREMENT,
  3. CardName VARCHAR(50) NOT NULL,
  4. CManaCost INT NOT NULL,
  5. Type ENUM('Creature','Enchantment','Sorcery','Instant','Land') NOT NULL,
  6. Rarity ENUM('Mythic','Rare','Uncommon','Common','Land') NOT NULL,
  7. Color ENUM('None','White','Green','Black','Red','Blue') NOT NULL,
  8. CORE_SETS INT NULL,
  9. DUEL_DECKS INT NULL,
  10. EXP_SETS INT NULL,
  11. PLANECHASE INT NULL,
  12. PREMIUM INT NULL,
  13. REPRINTS INT NULL,
  14. PRIMARY KEY(id),
  15. CONSTRAINT CoreSetFK CORE_SETS REFERENCES CORE_SETS(id)
  16.              ON DELETE CASCADE,
  17. CONSTRAINT DuelDecksFK DUEL_DECKS REFERENCES DUEL_DECKS(id)
  18.              ON DELETE CASCADE,
  19. CONSTRAINT ExpSetsFK EXP_SETS REFERENCES EXP_SETS(id)
  20.              ON DELETE CASCADE,
  21. CONSTRAINT VaultFK REFERENCES FROM_THE_VAULT(id)
  22.              ON DELETE CASCADE,
  23. CONSTRAINT PlaneChaseFK PLANECHASE REFERENCES PLANECHASE(id)
  24.              ON DELETE CASCADE,
  25. CONSTRAINT PremiumFK PREMIUM REFERENCES PREMIUM(id)
  26.              ON DELETE CASCADE,
  27. CONSTRAINT ReprintFK REPRINTS REFERENCES REPRINTS(id)
  28.              ON DELETE CASCADE    
  29. );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