View difference between Paste ID: 4R2nTSPQ and E9Hy1r24
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
);