{"action":"created","issue":{"url":"https://api.github.com/repos/SecUpwN/Android-IMSI-Catcher-Detector/issues/215","labels_url":"https://api.github.com/repos/SecUpwN/Android-IMSI-Catcher-Detector/issues/215/labels{/name}","comments_url":"https://api.github.com/repos/SecUpwN/Android-IMSI-Catcher-Detector/issues/215/comments","events_url":"https://api.github.com/repos/SecUpwN/Android-IMSI-Catcher-Detector/issues/215/events","html_url":"https://github.com/SecUpwN/Android-IMSI-Catcher-Detector/issues/215","id":52186652,"number":215,"title":"Major DataBase overhaul and restructuring","user":{"login":"E3V3A","id":194392,"avatar_url":"https://avatars.githubusercontent.com/u/194392?v=3","gravatar_id":"","url":"https://api.github.com/users/E3V3A","html_url":"https://github.com/E3V3A","followers_url":"https://api.github.com/users/E3V3A/followers","following_url":"https://api.github.com/users/E3V3A/following{/other_user}","gists_url":"https://api.github.com/users/E3V3A/gists{/gist_id}","starred_url":"https://api.github.com/users/E3V3A/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/E3V3A/subscriptions","organizations_url":"https://api.github.com/users/E3V3A/orgs","repos_url":"https://api.github.com/users/E3V3A/repos","events_url":"https://api.github.com/users/E3V3A/events{/privacy}","received_events_url":"https://api.github.com/users/E3V3A/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/SecUpwN/Android-IMSI-Catcher-Detector/labels/DATABASE","name":"DATABASE","color":"bfe5bf"},{"url":"https://api.github.com/repos/SecUpwN/Android-IMSI-Catcher-Detector/labels/DEV_DISCUSSION","name":"DEV_DISCUSSION","color":"fbca04"},{"url":"https://api.github.com/repos/SecUpwN/Android-IMSI-Catcher-Detector/labels/DOCUMENTATION","name":"DOCUMENTATION","color":"006b75"},{"url":"https://api.github.com/repos/SecUpwN/Android-IMSI-Catcher-Detector/labels/ENHANCEMENT","name":"ENHANCEMENT","color":"c7def8"},{"url":"https://api.github.com/repos/SecUpwN/Android-IMSI-Catcher-Detector/labels/URGENT","name":"URGENT","color":"000000"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/SecUpwN/Android-IMSI-Catcher-Detector/milestones/1","html_url":"https://github.com/SecUpwN/Android-IMSI-Catcher-Detector/milestones/v1.0-beta","labels_url":"https://api.github.com/repos/SecUpwN/Android-IMSI-Catcher-Detector/milestones/1/labels","id":634574,"number":1,"title":"v1.0-beta","description":"In order to go from **alpha** stage to **beta** we need to have a minimal set of working test conditions to answer the following question:\r\n\r\n**Given a handful neighboring BTS towers, with LAC,CID, GPS, band, channel, time history, signal strength, how can find the fake one?**\r\n \r\nThus we have to focus on the detection matrix using the data we already have access to, like cell tower info and MLS/OCID BTS info.\r\n\r\nThe things we need to accomplish for this milestone are:\r\n\r\nImplementation of the most basic detection matrix using minimal set of currently available variables:\r\n- [ ] Create a flow-chart for the detection mechanism using the following variables:\r\n- [ ] 1. Changing of LAC/CID \r\n- [ ] 2. Sudden change of of Signal Strength (with same LAC/SID)\r\n- [ ] 3. Appearance of new BTS (different LAC/CID etc) where none was found before (BTS neighborhood history)\r\n- [ ] 4. \r\n\r\nUI requirements:\r\n- [x] Implementing the UI screens and layout\r\n- [x] Adding Installation Disclaimer\r\n- [ ] Map of current, previous BTS's with indicator of suspicious ones.\r\n\r\nVarious Network data & variables:\r\n- [ ] SIM Cipher Indication availability\r\n- [ ] Current connection encryption algorithm A5/1-3\r\n- [ ] Current connection ciphering status\r\n- [x] Network data such as LAC,CID, etc\r\n- [ ] Neighboring cells and their data\r\n- [ ] RSSI \r\n- [ ] History of Dropped Calls (and the reason/status)\r\n- [ ] Emergency radio shutdown (shutdown of all internal RF systems like BT, Wifi, NFC etc.) \r\n- [ ] Roaming indication\r\n- [/] Current GPS location within 50m \r\n- [ ] Transmission (TX) power\r\n\r\nOther:\r\n- [ ] Option: to use 2G GSM only (during detection) and 3G/LTE only during normal operation.\r\n- [ ] Option: to disable automatic Network Selection (network lock.)\r\n- [ ] Detection and blockage of Silent Calls\r\n- [/] Detection and blockage of Silent SMS\r\n- [ ] Detection and blockage of silent install attempts of applications \r\n    (I.e. monitor or disable GTalkService / INSTALL_ASSET)\r\n\r\n---\r\n- [x] = Done\r\n- [/] = Partially done or WIP that need further attention\r\n\r\n","creator":{"login":"E3V3A","id":194392,"avatar_url":"https://avatars.githubusercontent.com/u/194392?v=3","gravatar_id":"","url":"https://api.github.com/users/E3V3A","html_url":"https://github.com/E3V3A","followers_url":"https://api.github.com/users/E3V3A/followers","following_url":"https://api.github.com/users/E3V3A/following{/other_user}","gists_url":"https://api.github.com/users/E3V3A/gists{/gist_id}","starred_url":"https://api.github.com/users/E3V3A/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/E3V3A/subscriptions","organizations_url":"https://api.github.com/users/E3V3A/orgs","repos_url":"https://api.github.com/users/E3V3A/repos","events_url":"https://api.github.com/users/E3V3A/events{/privacy}","received_events_url":"https://api.github.com/users/E3V3A/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":0,"state":"open","created_at":"2014-04-19T15:38:10Z","updated_at":"2014-12-17T00:29:57Z","due_on":null,"closed_at":null},"comments":30,"created_at":"2014-12-17T00:29:57Z","updated_at":"2015-06-09T01:36:13Z","closed_at":null,"body":"As we have noticed in many recent issues and many past discussions, there is a terrible urgent need to restructure our original database (DB). This DB was originally made for our very first attempts in building this app. However, we've come to realize that the way it is used and structured and how its tables are internally labelled is really confusing at best. It was made according to very weak documentation and poor understanding of what we actually needed. \r\n\r\nAfter several weeks of thinking about this, on and off, I've come to the point where it's time to get it done. Here is a brand new proposal that should cover most features in the near future and hopefully most of the **beta** stage life-time. \r\n\r\nThis is the way we will do it:\r\n 1. I finish the DB documents and table ER diagram, then \r\n 2. you guys make a critical re-view and feedback.\r\n 3. I make the required updates, if any, and go back to (1), else \r\n 4. we re-code the DB into app.\r\n\r\n**NOTE**: I suggest keeping the old tables while adding the new ones, to maintain simple and progressive migration. \r\n\r\nThere will surely be loads of questions surrounding this, but I think I might have covered most of it in the (still to be finished) documents:\r\n - [ ] General DB functional overview\r\n - [ ] Detailed DB tables Descriptions\r\n - [ ] Default DB data \r\n\r\nThen there will be new App help pages and an FAQ, to be implemented inside app. (Separate issue.)\r\n - [ ] General App functionality\r\n - [ ] Internal App help pages\r\n - [ ] Internal App FAQ\r\n - [ ] *TBA*\r\n\r\n---\r\n\r\n#### Here are the **old** currently used DB tables:\r\n\r\n![aimsicd_mycellinfo_er_2](https://cloud.githubusercontent.com/assets/194392/4782936/85b1be08-5d0f-11e4-89c6-62a0efc22a6a.png)\r\n\r\n---\r\n\r\n#### Here are the **NEW** DB tables:\r\n\r\n![aimsicd4_er](https://cloud.githubusercontent.com/assets/194392/5824571/22bf9860-a0ee-11e4-8794-491c53d1c58a.png)\r\n\r\n---\r\n\r\n**Reference Issues:** These are issues that directly depend on these tables. \r\n#13, #69,#71, #91, #93, #97, #100, #117, #176, #201, (#203 ?), \r\n\r\nMore descriptions will be added below.\r\n\r\n\r\n<bountysource-plugin>\r\n---\r\nWant to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/7069218-major-database-overhaul-and-restructuring?utm_campaign=plugin&utm_content=tracker%2F565750&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F565750&utm_medium=issues&utm_source=github).\r\n</bountysource-plugin>"},"comment":{"url":"https://api.github.com/repos/SecUpwN/Android-IMSI-Catcher-Detector/issues/comments/110192257","html_url":"https://github.com/SecUpwN/Android-IMSI-Catcher-Detector/issues/215#issuecomment-110192257","issue_url":"https://api.github.com/repos/SecUpwN/Android-IMSI-Catcher-Detector/issues/215","id":110192257,"user":{"login":"E3V3A","id":194392,"avatar_url":"https://avatars.githubusercontent.com/u/194392?v=3","gravatar_id":"","url":"https://api.github.com/users/E3V3A","html_url":"https://github.com/E3V3A","followers_url":"https://api.github.com/users/E3V3A/followers","following_url":"https://api.github.com/users/E3V3A/following{/other_user}","gists_url":"https://api.github.com/users/E3V3A/gists{/gist_id}","starred_url":"https://api.github.com/users/E3V3A/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/E3V3A/subscriptions","organizations_url":"https://api.github.com/users/E3V3A/orgs","repos_url":"https://api.github.com/users/E3V3A/repos","events_url":"https://api.github.com/users/E3V3A/events{/privacy}","received_events_url":"https://api.github.com/users/E3V3A/received_events","type":"User","site_admin":false},"created_at":"2015-06-09T01:36:13Z","updated_at":"2015-06-09T01:36:13Z","body":"I'm adding the \"bug\" label, and removing the \"dev_discussion\" label, so that new developers will understand that this is a real issue. \r\n\r\nIn the meantime, we can try to merge the data from `Measured Signal Strengths` table into the `BTS Measurements` table (as visible from the *Database Viewer*.) This might need to be posted as a separate issue. I also noticed that the signal strengths (RSS) as shown in the former is no longer working... "}}