{"action":"created","issue":{"url":"https://api.github.com/repos/dmwm/WMCore/issues/6126","labels_url":"https://api.github.com/repos/dmwm/WMCore/issues/6126/labels{/name}","comments_url":"https://api.github.com/repos/dmwm/WMCore/issues/6126/comments","events_url":"https://api.github.com/repos/dmwm/WMCore/issues/6126/events","html_url":"https://github.com/dmwm/WMCore/pull/6126","id":100516302,"number":6126,"title":"Sync Mysql schema w.r.t. Oracle","user":{"login":"amaltaro","id":1798520,"avatar_url":"https://avatars.githubusercontent.com/u/1798520?v=3","gravatar_id":"","url":"https://api.github.com/users/amaltaro","html_url":"https://github.com/amaltaro","followers_url":"https://api.github.com/users/amaltaro/followers","following_url":"https://api.github.com/users/amaltaro/following{/other_user}","gists_url":"https://api.github.com/users/amaltaro/gists{/gist_id}","starred_url":"https://api.github.com/users/amaltaro/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amaltaro/subscriptions","organizations_url":"https://api.github.com/users/amaltaro/orgs","repos_url":"https://api.github.com/users/amaltaro/repos","events_url":"https://api.github.com/users/amaltaro/events{/privacy}","received_events_url":"https://api.github.com/users/amaltaro/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-08-12T10:46:55Z","updated_at":"2015-08-12T12:30:40Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/dmwm/WMCore/pulls/6126","html_url":"https://github.com/dmwm/WMCore/pull/6126","diff_url":"https://github.com/dmwm/WMCore/pull/6126.diff","patch_url":"https://github.com/dmwm/WMCore/pull/6126.patch"},"body":"As discussed in #6099, here is the PR. Changes are:\r\n - as suggested by @yuyiguo , not null was put back for a few cases\r\n - set back primary key for dbsbuffer_file_parent (though I don't get why we would need both, I guess only child would be enough)\r\n - synced other constraints from oracle to mysql\r\n\r\nI also think we should remove the uniqueness from those 4 columns in dbsbuffer_algo, they make no sense for me (though I kept them here).\r\n\r\n@yuyiguo @hufnagel you may want to take a look here"},"comment":{"url":"https://api.github.com/repos/dmwm/WMCore/issues/comments/130283231","html_url":"https://github.com/dmwm/WMCore/pull/6126#issuecomment-130283231","issue_url":"https://api.github.com/repos/dmwm/WMCore/issues/6126","id":130283231,"user":{"login":"DMWMBot","id":1124170,"avatar_url":"https://avatars.githubusercontent.com/u/1124170?v=3","gravatar_id":"","url":"https://api.github.com/users/DMWMBot","html_url":"https://github.com/DMWMBot","followers_url":"https://api.github.com/users/DMWMBot/followers","following_url":"https://api.github.com/users/DMWMBot/following{/other_user}","gists_url":"https://api.github.com/users/DMWMBot/gists{/gist_id}","starred_url":"https://api.github.com/users/DMWMBot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DMWMBot/subscriptions","organizations_url":"https://api.github.com/users/DMWMBot/orgs","repos_url":"https://api.github.com/users/DMWMBot/repos","events_url":"https://api.github.com/users/DMWMBot/events{/privacy}","received_events_url":"https://api.github.com/users/DMWMBot/received_events","type":"User","site_admin":false},"created_at":"2015-08-12T12:30:40Z","updated_at":"2015-08-12T12:30:40Z","body":"Beginning pylint and unit tests.\nSee https://cmssdt.cern.ch/jenkins/job/DMWM-PR-test/248/ for details"}}