{"action":"created","issue":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/81","repository_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/81/labels{/name}","comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/81/comments","events_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/81/events","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/81","id":41016468,"number":81,"title":"Editing schema would remove foreign keys, constraints, and cascades","user":{"login":"justinclift","id":406299,"avatar_url":"https://avatars.githubusercontent.com/u/406299?v=3","gravatar_id":"","url":"https://api.github.com/users/justinclift","html_url":"https://github.com/justinclift","followers_url":"https://api.github.com/users/justinclift/followers","following_url":"https://api.github.com/users/justinclift/following{/other_user}","gists_url":"https://api.github.com/users/justinclift/gists{/gist_id}","starred_url":"https://api.github.com/users/justinclift/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/justinclift/subscriptions","organizations_url":"https://api.github.com/users/justinclift/orgs","repos_url":"https://api.github.com/users/justinclift/repos","events_url":"https://api.github.com/users/justinclift/events{/privacy}","received_events_url":"https://api.github.com/users/justinclift/received_events","type":"User","site_admin":false},"labels":[{"id":96964808,"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/labels/bug","name":"bug","color":"fc2929","default":true},{"id":405011124,"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/labels/constraints%20&%20foreign%20keys","name":"constraints & foreign keys","color":"006b75","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2014-08-24T19:00:26Z","updated_at":"2017-01-06T23:00:17Z","closed_at":null,"body":"From @TWiStErRob:\n\n> I see all the schemas listed, however I can't edit (don't even want to, see my comment on #78) nearly any of them because it would remove all the foreign keys and constraints and cascades. See Category_Descendant in http://temp.twisterrob.net/share/MagicHomeInventory.sqlite\n\nThis is following on from https://github.com/sqlitebrowser/sqlitebrowser/issues/77.\n"},"comment":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/comments/271033598","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/81#issuecomment-271033598","issue_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/81","id":271033598,"user":{"login":"justinclift","id":406299,"avatar_url":"https://avatars.githubusercontent.com/u/406299?v=3","gravatar_id":"","url":"https://api.github.com/users/justinclift","html_url":"https://github.com/justinclift","followers_url":"https://api.github.com/users/justinclift/followers","following_url":"https://api.github.com/users/justinclift/following{/other_user}","gists_url":"https://api.github.com/users/justinclift/gists{/gist_id}","starred_url":"https://api.github.com/users/justinclift/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/justinclift/subscriptions","organizations_url":"https://api.github.com/users/justinclift/orgs","repos_url":"https://api.github.com/users/justinclift/repos","events_url":"https://api.github.com/users/justinclift/events{/privacy}","received_events_url":"https://api.github.com/users/justinclift/received_events","type":"User","site_admin":false},"created_at":"2017-01-06T23:00:17Z","updated_at":"2017-01-06T23:00:17Z","body":"@MKleusberg Is this warning on the virtual table 'Search' expected?\r\n\r\n![screen shot 2017-01-06 at 22 52 36](https://cloud.githubusercontent.com/assets/406299/21735580/d8ad16b2-d462-11e6-8223-667e62f4b508.png)\r\n\"USING USING\" seems like an error (causing the warning?), though I'm not sure where it's originating from.  Haven't attached a debugger. :smile:\r\n\r\nOn a side note, choosing that virtual table (no defined fields) in the Browse Data tab display strangely.  No filters row, probably because no fields.  But the background colouring for the filter row is there.  Not real high urgency to fix though I reckon... :wink:\r\n\r\n![screen shot 2017-01-06 at 22 59 31](https://cloud.githubusercontent.com/assets/406299/21735711/d4a11f36-d463-11e6-8cd3-ed69e6192593.png)"}}
{"actor":{"display_login":"justinclift"}}