Skip to content

Instantly share code, notes, and snippets.

@henare

henare/election_leafets_pull_request_10_migration.sql

Created January 22, 2013 03:48
Show Gist options
  • Save henare/4591900 to your computer and use it in GitHub Desktop.
Save henare/4591900 to your computer and use it in GitHub Desktop.
Download ZIP
Overall migration for election_leaflets pull request #10: https://github.com/openaustralia/electionleaflets/pull/10
Raw
election_leafets_pull_request_10_migration.sql
ALTER TABLE election ADD enabled TINYINT(1) DEFAULT 0 NOT NULL;
UPDATE election SET enabled = 1;
ALTER TABLE `party_election` CHANGE `party_election_id` `party_election_id` INT( 11 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `australian_postcode` ENGINE = InnoDB;
ALTER TABLE `constituency` ENGINE = InnoDB;
ALTER TABLE `constituency_election` ENGINE = InnoDB;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment