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