Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.64 KB | None | 0 0
  1. ALTER TABLE `riskivector_db`.`address`
  2. ADD COLUMN `street_type_id` INT(11) NOT NULL AFTER `city`,
  3. DROP PRIMARY KEY,
  4. ADD PRIMARY KEY (`id`, `street_type_id`),
  5. ADD INDEX `fk_address_street_type1_idx` (`street_type_id` ASC);
  6.  
  7.  
  8. CREATE TABLE IF NOT EXISTS `riskivector_db`.`street_type` (
  9.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  10.   `type` VARCHAR(45) NOT NULL,
  11.   PRIMARY KEY (`id`))
  12. ENGINE = InnoDB
  13. DEFAULT CHARACTER SET = latin1;
  14.  
  15. ALTER TABLE `riskivector_db`.`address`
  16. ADD CONSTRAINT `fk_address_street_type1`
  17.   FOREIGN KEY (`street_type_id`)
  18.   REFERENCES `riskivector_db`.`street_type` (`id`)
  19.   ON DELETE NO ACTION
  20.   ON UPDATE NO ACTION;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement