Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `court`.`products` (
- `id` INT NOT NULL AUTO_INCREMENT ,
- `merchant` INT(10) NOT NULL ,
- `price` DECIMAL(5,2) NULL ,
- `conv_fee` DECIMAL(5,2) NULL ,
- `product_name` VARCHAR(45) NOT NULL ,
- PRIMARY KEY (`id`) ,
- INDEX `merchant` (`merchant` ASC) ,
- CONSTRAINT `merchant`
- FOREIGN KEY (`merchant` )
- REFERENCES `court`.`merchants` (`id` )
- ON DELETE RESTRICT
- ON UPDATE CASCADE)
- ENGINE = InnoDB
- -- Gives me the following error:
- -- #1005 - Can't create table 'court.products' (errno: 150) (Details...)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement