Skip to content

Instantly share code, notes, and snippets.

@roylee0704

roylee0704/unique.sql

Created January 9, 2017 15:49
Show Gist options
  • Save roylee0704/68db82695708d26469976f967c37535d to your computer and use it in GitHub Desktop.
Save roylee0704/68db82695708d26469976f967c37535d to your computer and use it in GitHub Desktop.
Download ZIP
unique constraints
Raw
unique.sql
ALTER TABLE `gb_n_incentive` ADD CONSTRAINT `sp_id` UNIQUE `sp_id` (`sp_id`,`incentive_program_id`,`term_weeks`);
ALTER TABLE `gb_n_incentive` DROP INDEX `sp_id`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment