{"action":"created","issue":{"url":"https://api.github.com/repos/PecanProject/pecan/issues/325","labels_url":"https://api.github.com/repos/PecanProject/pecan/issues/325/labels{/name}","comments_url":"https://api.github.com/repos/PecanProject/pecan/issues/325/comments","events_url":"https://api.github.com/repos/PecanProject/pecan/issues/325/events","html_url":"https://github.com/PecanProject/pecan/issues/325","id":54461592,"number":325,"title":"Add ID to many-many tables","user":{"login":"robkooper","id":1580696,"avatar_url":"https://avatars.githubusercontent.com/u/1580696?v=3","gravatar_id":"","url":"https://api.github.com/users/robkooper","html_url":"https://github.com/robkooper","followers_url":"https://api.github.com/users/robkooper/followers","following_url":"https://api.github.com/users/robkooper/following{/other_user}","gists_url":"https://api.github.com/users/robkooper/gists{/gist_id}","starred_url":"https://api.github.com/users/robkooper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robkooper/subscriptions","organizations_url":"https://api.github.com/users/robkooper/orgs","repos_url":"https://api.github.com/users/robkooper/repos","events_url":"https://api.github.com/users/robkooper/events{/privacy}","received_events_url":"https://api.github.com/users/robkooper/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"robkooper","id":1580696,"avatar_url":"https://avatars.githubusercontent.com/u/1580696?v=3","gravatar_id":"","url":"https://api.github.com/users/robkooper","html_url":"https://github.com/robkooper","followers_url":"https://api.github.com/users/robkooper/followers","following_url":"https://api.github.com/users/robkooper/following{/other_user}","gists_url":"https://api.github.com/users/robkooper/gists{/gist_id}","starred_url":"https://api.github.com/users/robkooper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robkooper/subscriptions","organizations_url":"https://api.github.com/users/robkooper/orgs","repos_url":"https://api.github.com/users/robkooper/repos","events_url":"https://api.github.com/users/robkooper/events{/privacy}","received_events_url":"https://api.github.com/users/robkooper/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/PecanProject/pecan/milestones/13","labels_url":"https://api.github.com/repos/PecanProject/pecan/milestones/13/labels","id":912554,"number":13,"title":"1.4.2 Benchmarks, etc","description":"","creator":{"login":"mdietze","id":3081466,"avatar_url":"https://avatars.githubusercontent.com/u/3081466?v=3","gravatar_id":"","url":"https://api.github.com/users/mdietze","html_url":"https://github.com/mdietze","followers_url":"https://api.github.com/users/mdietze/followers","following_url":"https://api.github.com/users/mdietze/following{/other_user}","gists_url":"https://api.github.com/users/mdietze/gists{/gist_id}","starred_url":"https://api.github.com/users/mdietze/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mdietze/subscriptions","organizations_url":"https://api.github.com/users/mdietze/orgs","repos_url":"https://api.github.com/users/mdietze/repos","events_url":"https://api.github.com/users/mdietze/events{/privacy}","received_events_url":"https://api.github.com/users/mdietze/received_events","type":"User","site_admin":false},"open_issues":26,"closed_issues":0,"state":"open","created_at":"2014-12-22T18:29:04Z","updated_at":"2015-01-16T14:48:10Z","due_on":"2015-02-24T05:00:00Z","closed_at":null},"comments":3,"created_at":"2015-01-15T15:26:07Z","updated_at":"2015-01-19T13:49:30Z","closed_at":null,"body":"To be able to sync correctly we need an ID field to know who added that specific row in many-many relationship tables. For example pfts_species can have pfts that are added by BU with species added at EBI.\n\nRight now the script will only remove those rows that are added both at the remote site, and will leave those rows alone that are added by the remote site and reference a local specie."},"comment":{"url":"https://api.github.com/repos/PecanProject/pecan/issues/comments/70494423","html_url":"https://github.com/PecanProject/pecan/issues/325#issuecomment-70494423","issue_url":"https://api.github.com/repos/PecanProject/pecan/issues/325","id":70494423,"user":{"login":"robkooper","id":1580696,"avatar_url":"https://avatars.githubusercontent.com/u/1580696?v=3","gravatar_id":"","url":"https://api.github.com/users/robkooper","html_url":"https://github.com/robkooper","followers_url":"https://api.github.com/users/robkooper/followers","following_url":"https://api.github.com/users/robkooper/following{/other_user}","gists_url":"https://api.github.com/users/robkooper/gists{/gist_id}","starred_url":"https://api.github.com/users/robkooper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robkooper/subscriptions","organizations_url":"https://api.github.com/users/robkooper/orgs","repos_url":"https://api.github.com/users/robkooper/repos","events_url":"https://api.github.com/users/robkooper/events{/privacy}","received_events_url":"https://api.github.com/users/robkooper/received_events","type":"User","site_admin":false},"created_at":"2015-01-19T13:49:30Z","updated_at":"2015-01-19T13:49:30Z","body":"I think I might have the answer, just need to try on a linux machine. Will try this morning and let you know."}}