SHOW:
|
|
- or go back to the newest paste.
| 1 | - | |
| 1 | + | |
| 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 | - | CONSTRAINT CoreSetFK REFERENCES CORE_SETS(`id`) |
| 16 | + | |
| 17 | CONSTRAINT DuelDecksFK DUEL_DECKS REFERENCES DUEL_DECKS(`id`) | |
| 18 | - | CONSTRAINT DuelDecksFK REFERENCES DUEL_DECKS(`id`) |
| 18 | + | |
| 19 | CONSTRAINT ExpSetsFK EXP_SETS REFERENCES EXP_SETS(`id`) | |
| 20 | - | CONSTRAINT ExpSetsFK REFERENCES EXP_SETS(`id`) |
| 20 | + | |
| 21 | CONSTRAINT VaultFK REFERENCES FROM_THE_VAULT(`id`) | |
| 22 | ON DELETE CASCADE, | |
| 23 | CONSTRAINT PlaneChaseFK PLANECHASE REFERENCES PLANECHASE(`id`) | |
| 24 | - | CONSTRAINT PlaneChaseFK REFERENCES PLANECHASE(`id`) |
| 24 | + | |
| 25 | CONSTRAINT PremiumFK PREMIUM REFERENCES PREMIUM(`id`) | |
| 26 | - | CONSTRAINT PremiumFK REFERENCES PREMIUM(`id`) |
| 26 | + | |
| 27 | CONSTRAINT ReprintFK REPRINTS REFERENCES REPRINTS(`id`) | |
| 28 | - | CONSTRAINT ReprintFK REFERENCES REPRINTS(`id`) |
| 28 | + | |
| 29 | ); |