Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table CARDS(
- `id`INT NOT NULL AUTO_INCREMENT,
- `CardName` VARCHAR(50) NOT NULL,
- `CManaCost` INT NOT NULL,
- `Type` ENUM('Creature','Enchantment','Sorcery','Instant','Land') NOT NULL,
- `Rarity` ENUM('Mythic','Rare','Uncommon','Common','Land') NOT NULL,
- `Color` ENUM('None','White','Green','Black','Red','Blue') NOT NULL,
- `CORE_SETS` INT NULL,
- `DUEL_DECKS` INT NULL,
- `EXP_SETS` INT NULL,
- `PLANECHASE` INT NULL,
- `PREMIUM` INT NULL,
- `REPRINTS` INT NULL,
- PRIMARY KEY(`id`),
- CONSTRAINT CoreSetFK REFERENCES CORE_SETS(`id`)
- ON DELETE CASCADE,
- CONSTRAINT DuelDecksFK REFERENCES DUEL_DECKS(`id`)
- ON DELETE CASCADE,
- CONSTRAINT ExpSetsFK REFERENCES EXP_SETS(`id`)
- ON DELETE CASCADE,
- CONSTRAINT VaultFK REFERENCES FROM_THE_VAULT(`id`)
- ON DELETE CASCADE,
- CONSTRAINT PlaneChaseFK REFERENCES PLANECHASE(`id`)
- ON DELETE CASCADE,
- CONSTRAINT PremiumFK REFERENCES PREMIUM(`id`)
- ON DELETE CASCADE,
- CONSTRAINT ReprintFK REFERENCES REPRINTS(`id`)
- ON DELETE CASCADE
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement