Skip to content

Instantly share code, notes, and snippets.

@brandonsavage

brandonsavage/upgrade.sql

Created September 21, 2012 20:16
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save brandonsavage/3763660 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save brandonsavage/3763660 to your computer and use it in GitHub Desktop.
Download ZIP
SQL to upgrade bouncer
Raw
upgrade.sql
ALTER TABLE `geoip_regions` ADD COLUMN `fallback_id` integer;
ALTER TABLE `geoip_regions` ADD CONSTRAINT `fallback_id_refs_id_e6bfe66d` FOREIGN KEY (`fallback_id`) REFERENCES `geoip_regions` (`id`);
CREATE INDEX `geoip_regions_e28329c2` ON `geoip_regions` (`fallback_id`);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment