Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER TABLE `riskivector_db`.`address`
- ADD COLUMN `street_type_id` INT(11) NOT NULL AFTER `city`,
- DROP PRIMARY KEY,
- ADD PRIMARY KEY (`id`, `street_type_id`),
- ADD INDEX `fk_address_street_type1_idx` (`street_type_id` ASC);
- CREATE TABLE IF NOT EXISTS `riskivector_db`.`street_type` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `type` VARCHAR(45) NOT NULL,
- PRIMARY KEY (`id`))
- ENGINE = InnoDB
- DEFAULT CHARACTER SET = latin1;
- ALTER TABLE `riskivector_db`.`address`
- ADD CONSTRAINT `fk_address_street_type1`
- FOREIGN KEY (`street_type_id`)
- REFERENCES `riskivector_db`.`street_type` (`id`)
- ON DELETE NO ACTION
- ON UPDATE NO ACTION;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement