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 | ); |