Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER TABLE `vportal_saptest`.`admins` ENGINE = InnoDB;
- ALTER TABLE `vportal_saptest`.`admins_login_logs` ENGINE = InnoDB;
- ALTER TABLE `vportal_saptest`.`newsletter` ENGINE = InnoDB;
- ALTER TABLE `vportal_saptest`.`products_logs` ENGINE = InnoDB;
- ALTER TABLE `vportal_saptest`.`products_vote` ENGINE = InnoDB;
- ALTER TABLE `vportal_saptest`.`segmentos` ENGINE = InnoDB;
- ALTER TABLE `vportal_saptest`.`users_login_logs` ENGINE = InnoDB;
- CREATE TABLE `vportal_saptest`.`companySolutionsPartner` (
- `idCompanySolutionsPartner` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
- `idCompanySolutions` INTEGER UNSIGNED NOT NULL,
- `idPartner` INTEGER UNSIGNED NOT NULL,
- PRIMARY KEY (`idCompanySolutionsPartner`),
- INDEX `Index_2`(`idCompanySolutions`),
- INDEX `Index_3`(`idPartner`),
- CONSTRAINT `FK_companySolutionsPartner_1` FOREIGN KEY `FK_companySolutionsPartner_1` (`idCompanySolutions`)
- REFERENCES `companysolutions` (`id`)
- ON DELETE CASCADE
- ON UPDATE CASCADE,
- CONSTRAINT `FK_companySolutionsPartner_2` FOREIGN KEY `FK_companySolutionsPartner_2` (`idPartner`)
- REFERENCES `partner` (`id`)
- ON DELETE CASCADE
- ON UPDATE CASCADE
- )
- ENGINE = InnoDB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement