{"action":"created","issue":{"url":"https://api.github.com/repos/zanata/zanata-server/issues/755","labels_url":"https://api.github.com/repos/zanata/zanata-server/issues/755/labels{/name}","comments_url":"https://api.github.com/repos/zanata/zanata-server/issues/755/comments","events_url":"https://api.github.com/repos/zanata/zanata-server/issues/755/events","html_url":"https://github.com/zanata/zanata-server/pull/755","id":65136034,"number":755,"title":"Restore constraints on glossary tables for H2","user":{"login":"seanf","id":54155,"avatar_url":"https://avatars.githubusercontent.com/u/54155?v=3","gravatar_id":"","url":"https://api.github.com/users/seanf","html_url":"https://github.com/seanf","followers_url":"https://api.github.com/users/seanf/followers","following_url":"https://api.github.com/users/seanf/following{/other_user}","gists_url":"https://api.github.com/users/seanf/gists{/gist_id}","starred_url":"https://api.github.com/users/seanf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/seanf/subscriptions","organizations_url":"https://api.github.com/users/seanf/orgs","repos_url":"https://api.github.com/users/seanf/repos","events_url":"https://api.github.com/users/seanf/events{/privacy}","received_events_url":"https://api.github.com/users/seanf/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/zanata/zanata-server/labels/Reviewed","name":"Reviewed","color":"bfdadc"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-03-30T05:06:06Z","updated_at":"2015-03-30T23:13:23Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/zanata/zanata-server/pulls/755","html_url":"https://github.com/zanata/zanata-server/pull/755","diff_url":"https://github.com/zanata/zanata-server/pull/755.diff","patch_url":"https://github.com/zanata/zanata-server/pull/755.patch"},"body":"The constraints which were dropped by changeset db.changelog-1.6a.xml:1:aeng@redhat.com were never reinstated, so this changeset puts them back.  (Discovered while investigating https://bugzilla.redhat.com/show_bug.cgi?id=1048293)\r\n\r\nNote: this change is untested, and to test it will require running Zanata server against a persistent H2 database.  That isn't something we normally do these days, but I want to record this for completeness, and in case we ever want to run Zanata against H2 in future (eg for demos or quickstarts).\r\n\r\nTODO:\r\n\r\n - [ ] Add a basic test which deploys Zanata on H2, thus validating that our liquibase changesets at least work on an empty H2 database.  Trying to be database-agnostic might help with future migration, eg https://bugzilla.redhat.com/show_bug.cgi?id=1205945"},"comment":{"url":"https://api.github.com/repos/zanata/zanata-server/issues/comments/87873575","html_url":"https://github.com/zanata/zanata-server/pull/755#issuecomment-87873575","issue_url":"https://api.github.com/repos/zanata/zanata-server/issues/755","id":87873575,"user":{"login":"davidmason","id":482026,"avatar_url":"https://avatars.githubusercontent.com/u/482026?v=3","gravatar_id":"","url":"https://api.github.com/users/davidmason","html_url":"https://github.com/davidmason","followers_url":"https://api.github.com/users/davidmason/followers","following_url":"https://api.github.com/users/davidmason/following{/other_user}","gists_url":"https://api.github.com/users/davidmason/gists{/gist_id}","starred_url":"https://api.github.com/users/davidmason/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidmason/subscriptions","organizations_url":"https://api.github.com/users/davidmason/orgs","repos_url":"https://api.github.com/users/davidmason/repos","events_url":"https://api.github.com/users/davidmason/events{/privacy}","received_events_url":"https://api.github.com/users/davidmason/received_events","type":"User","site_admin":false},"created_at":"2015-03-30T23:13:23Z","updated_at":"2015-03-30T23:13:23Z","body":":+1: "}}