Skip to content

Instantly share code, notes, and snippets.

@reginaldojunior

reginaldojunior/lancamento_vendas_alter.sql

Created July 8, 2017 15:44
Show Gist options
  • Save reginaldojunior/5ba02b0bfaa6a62e74a5e56393a8155d to your computer and use it in GitHub Desktop.
Save reginaldojunior/5ba02b0bfaa6a62e74a5e56393a8155d to your computer and use it in GitHub Desktop.
Download ZIP
lancamento_vendas_alter.sql
Raw
lancamento_vendas_alter.sql
ALTER TABLE `winners`.`lancamento_vendas`
ADD INDEX `fk_lancamento_vendas_1_idx` (`venda_id` ASC);
ALTER TABLE `winners`.`lancamento_vendas`
ADD CONSTRAINT `fk_lancamento_vendas_1`
FOREIGN KEY (`venda_id`)
REFERENCES `winners`.`vendas` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment