SHOW:
|
|
- or go back to the newest paste.
| 1 | create table CARDS( | |
| 2 | - | `id`INT NOT NULL AUTO_INCREMENT, |
| 2 | + | id INT NOT NULL AUTO_INCREMENT, |
| 3 | - | `CardName` VARCHAR(50) NOT NULL, |
| 3 | + | CardName VARCHAR(50) NOT NULL, |
| 4 | - | `CManaCost` INT NOT NULL, |
| 4 | + | CManaCost INT NOT NULL, |
| 5 | - | `Type` ENUM('Creature','Enchantment','Sorcery','Instant','Land') NOT NULL,
|
| 5 | + | Type ENUM('Creature','Enchantment','Sorcery','Instant','Land') NOT NULL,
|
| 6 | - | `Rarity` ENUM('Mythic','Rare','Uncommon','Common','Land') NOT NULL,
|
| 6 | + | Rarity ENUM('Mythic','Rare','Uncommon','Common','Land') NOT NULL,
|
| 7 | - | `Color` ENUM('None','White','Green','Black','Red','Blue') NOT NULL,
|
| 7 | + | Color ENUM('None','White','Green','Black','Red','Blue') NOT NULL,
|
| 8 | - | `CORE_SETS` INT NULL, |
| 8 | + | CORE_SETS INT NULL, |
| 9 | - | `DUEL_DECKS` INT NULL, |
| 9 | + | DUEL_DECKS INT NULL, |
| 10 | - | `EXP_SETS` INT NULL, |
| 10 | + | EXP_SETS INT NULL, |
| 11 | - | `PLANECHASE` INT NULL, |
| 11 | + | PLANECHASE INT NULL, |
| 12 | - | `PREMIUM` INT NULL, |
| 12 | + | PREMIUM INT NULL, |
| 13 | - | `REPRINTS` INT NULL, |
| 13 | + | REPRINTS INT NULL, |
| 14 | - | PRIMARY KEY(`id`), |
| 14 | + | PRIMARY KEY(id), |
| 15 | - | CONSTRAINT CoreSetFK CORE_SETS REFERENCES CORE_SETS(`id`) |
| 15 | + | CONSTRAINT CoreSetFK CORE_SETS REFERENCES CORE_SETS(id) |
| 16 | - | ON DELETE CASCADE, |
| 16 | + | ON DELETE CASCADE, |
| 17 | - | CONSTRAINT DuelDecksFK DUEL_DECKS REFERENCES DUEL_DECKS(`id`) |
| 17 | + | CONSTRAINT DuelDecksFK DUEL_DECKS REFERENCES DUEL_DECKS(id) |
| 18 | - | ON DELETE CASCADE, |
| 18 | + | ON DELETE CASCADE, |
| 19 | - | CONSTRAINT ExpSetsFK EXP_SETS REFERENCES EXP_SETS(`id`) |
| 19 | + | CONSTRAINT ExpSetsFK EXP_SETS REFERENCES EXP_SETS(id) |
| 20 | - | ON DELETE CASCADE, |
| 20 | + | ON DELETE CASCADE, |
| 21 | - | CONSTRAINT VaultFK REFERENCES FROM_THE_VAULT(`id`) |
| 21 | + | CONSTRAINT VaultFK REFERENCES FROM_THE_VAULT(id) |
| 22 | - | ON DELETE CASCADE, |
| 22 | + | ON DELETE CASCADE, |
| 23 | - | CONSTRAINT PlaneChaseFK PLANECHASE REFERENCES PLANECHASE(`id`) |
| 23 | + | CONSTRAINT PlaneChaseFK PLANECHASE REFERENCES PLANECHASE(id) |
| 24 | - | ON DELETE CASCADE, |
| 24 | + | ON DELETE CASCADE, |
| 25 | - | CONSTRAINT PremiumFK PREMIUM REFERENCES PREMIUM(`id`) |
| 25 | + | CONSTRAINT PremiumFK PREMIUM REFERENCES PREMIUM(id) |
| 26 | - | ON DELETE CASCADE, |
| 26 | + | ON DELETE CASCADE, |
| 27 | - | CONSTRAINT ReprintFK REPRINTS REFERENCES REPRINTS(`id`) |
| 27 | + | CONSTRAINT ReprintFK REPRINTS REFERENCES REPRINTS(id) |
| 28 | - | ON DELETE CASCADE |
| 28 | + | ON DELETE CASCADE |
| 29 | - | ); |
| 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 |
