SHOW:
|
|
- or go back to the newest paste.
| 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,
|
| 5 | + | CType 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 |
