Advertisement
Guest User

Untitled

a guest
Jun 25th, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.16 KB | None | 0 0
  1. ALTER TABLE `vportal_saptest`.`admins` ENGINE = InnoDB;
  2. ALTER TABLE `vportal_saptest`.`admins_login_logs` ENGINE = InnoDB;
  3. ALTER TABLE `vportal_saptest`.`newsletter` ENGINE = InnoDB;
  4. ALTER TABLE `vportal_saptest`.`products_logs` ENGINE = InnoDB;
  5. ALTER TABLE `vportal_saptest`.`products_vote` ENGINE = InnoDB;
  6. ALTER TABLE `vportal_saptest`.`segmentos` ENGINE = InnoDB;
  7. ALTER TABLE `vportal_saptest`.`users_login_logs` ENGINE = InnoDB;
  8. CREATE TABLE `vportal_saptest`.`companySolutionsPartner` (
  9.   `idCompanySolutionsPartner` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  10.   `idCompanySolutions` INTEGER UNSIGNED NOT NULL,
  11.   `idPartner` INTEGER UNSIGNED NOT NULL,
  12.   PRIMARY KEY (`idCompanySolutionsPartner`),
  13.   INDEX `Index_2`(`idCompanySolutions`),
  14.   INDEX `Index_3`(`idPartner`),
  15.   CONSTRAINT `FK_companySolutionsPartner_1` FOREIGN KEY `FK_companySolutionsPartner_1` (`idCompanySolutions`)
  16.     REFERENCES `companysolutions` (`id`)
  17.     ON DELETE CASCADE
  18.     ON UPDATE CASCADE,
  19.   CONSTRAINT `FK_companySolutionsPartner_2` FOREIGN KEY `FK_companySolutionsPartner_2` (`idPartner`)
  20.     REFERENCES `partner` (`id`)
  21.     ON DELETE CASCADE
  22.     ON UPDATE CASCADE
  23. )
  24. ENGINE = InnoDB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement