{"action":"closed","issue":{"url":"https://api.github.com/repos/mozilla/ichnaea/issues/353","labels_url":"https://api.github.com/repos/mozilla/ichnaea/issues/353/labels{/name}","comments_url":"https://api.github.com/repos/mozilla/ichnaea/issues/353/comments","events_url":"https://api.github.com/repos/mozilla/ichnaea/issues/353/events","html_url":"https://github.com/mozilla/ichnaea/issues/353","id":49712032,"number":353,"title":"Change primary key on cell/_blacklist tables","user":{"login":"hannosch","id":483109,"avatar_url":"https://avatars.githubusercontent.com/u/483109?v=3","gravatar_id":"","url":"https://api.github.com/users/hannosch","html_url":"https://github.com/hannosch","followers_url":"https://api.github.com/users/hannosch/followers","following_url":"https://api.github.com/users/hannosch/following{/other_user}","gists_url":"https://api.github.com/users/hannosch/gists{/gist_id}","starred_url":"https://api.github.com/users/hannosch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hannosch/subscriptions","organizations_url":"https://api.github.com/users/hannosch/orgs","repos_url":"https://api.github.com/users/hannosch/repos","events_url":"https://api.github.com/users/hannosch/events{/privacy}","received_events_url":"https://api.github.com/users/hannosch/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/mozilla/ichnaea/labels/idea","name":"idea","color":"0052cc"}],"state":"closed","locked":false,"assignee":{"login":"jaredkerim","id":119884,"avatar_url":"https://avatars.githubusercontent.com/u/119884?v=3","gravatar_id":"","url":"https://api.github.com/users/jaredkerim","html_url":"https://github.com/jaredkerim","followers_url":"https://api.github.com/users/jaredkerim/followers","following_url":"https://api.github.com/users/jaredkerim/following{/other_user}","gists_url":"https://api.github.com/users/jaredkerim/gists{/gist_id}","starred_url":"https://api.github.com/users/jaredkerim/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jaredkerim/subscriptions","organizations_url":"https://api.github.com/users/jaredkerim/orgs","repos_url":"https://api.github.com/users/jaredkerim/repos","events_url":"https://api.github.com/users/jaredkerim/events{/privacy}","received_events_url":"https://api.github.com/users/jaredkerim/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2014-11-21T15:50:48Z","updated_at":"2015-02-21T10:53:05Z","closed_at":"2015-02-21T10:53:05Z","body":"After #291 is done, the cell and ocid_cell tables almost match again. What's missing is removing the auto-inc id column from the cell/_blacklist tables and defining a new primary key based on radio, mcc, mnc, lac, cid.\r\n\r\nWe should do that now, the migration is pretty much the same as in `4c89b299ffb0_remove_ocid_cell_id_column.py`.\r\n\r\nChanging the primary key has one problem, we cannot run the migration in one release. The very last step of the migration (removing the id columns) has to happen one release after we deploy the rest. For the duration of the release there are web frontends running the old code and model definitions. If we remove the primary key column from underneath those, they get very unhappy."}}