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