{"action":"created","issue":{"url":"https://api.github.com/repos/ahelsing/tickettest2/issues/174","labels_url":"https://api.github.com/repos/ahelsing/tickettest2/issues/174/labels{/name}","comments_url":"https://api.github.com/repos/ahelsing/tickettest2/issues/174/comments","events_url":"https://api.github.com/repos/ahelsing/tickettest2/issues/174/events","html_url":"https://github.com/ahelsing/tickettest2/issues/174","id":78322965,"number":174,"title":"sa_slice(slice_id) should be declared unique","user":{"login":"ahelsing","id":12136824,"avatar_url":"https://avatars.githubusercontent.com/u/12136824?v=3","gravatar_id":"","url":"https://api.github.com/users/ahelsing","html_url":"https://github.com/ahelsing","followers_url":"https://api.github.com/users/ahelsing/followers","following_url":"https://api.github.com/users/ahelsing/following{/other_user}","gists_url":"https://api.github.com/users/ahelsing/gists{/gist_id}","starred_url":"https://api.github.com/users/ahelsing/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ahelsing/subscriptions","organizations_url":"https://api.github.com/users/ahelsing/orgs","repos_url":"https://api.github.com/users/ahelsing/repos","events_url":"https://api.github.com/users/ahelsing/events{/privacy}","received_events_url":"https://api.github.com/users/ahelsing/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"ahelsing","id":12136824,"avatar_url":"https://avatars.githubusercontent.com/u/12136824?v=3","gravatar_id":"","url":"https://api.github.com/users/ahelsing","html_url":"https://github.com/ahelsing","followers_url":"https://api.github.com/users/ahelsing/followers","following_url":"https://api.github.com/users/ahelsing/following{/other_user}","gists_url":"https://api.github.com/users/ahelsing/gists{/gist_id}","starred_url":"https://api.github.com/users/ahelsing/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ahelsing/subscriptions","organizations_url":"https://api.github.com/users/ahelsing/orgs","repos_url":"https://api.github.com/users/ahelsing/repos","events_url":"https://api.github.com/users/ahelsing/events{/privacy}","received_events_url":"https://api.github.com/users/ahelsing/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/ahelsing/tickettest2/milestones/12","html_url":"https://github.com/ahelsing/tickettest2/milestones/1.15","labels_url":"https://api.github.com/repos/ahelsing/tickettest2/milestones/12/labels","id":1119614,"number":12,"title":"1.15","description":null,"creator":{"login":"ahelsing","id":12136824,"avatar_url":"https://avatars.githubusercontent.com/u/12136824?v=3","gravatar_id":"","url":"https://api.github.com/users/ahelsing","html_url":"https://github.com/ahelsing","followers_url":"https://api.github.com/users/ahelsing/followers","following_url":"https://api.github.com/users/ahelsing/following{/other_user}","gists_url":"https://api.github.com/users/ahelsing/gists{/gist_id}","starred_url":"https://api.github.com/users/ahelsing/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ahelsing/subscriptions","organizations_url":"https://api.github.com/users/ahelsing/orgs","repos_url":"https://api.github.com/users/ahelsing/repos","events_url":"https://api.github.com/users/ahelsing/events{/privacy}","received_events_url":"https://api.github.com/users/ahelsing/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":0,"state":"open","created_at":"2015-05-20T01:33:43Z","updated_at":"2015-05-20T01:33:48Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2015-05-20T01:33:48Z","updated_at":"2015-05-20T01:33:59Z","closed_at":null,"body":"The sa_slice table's slice_id column is not declared UNIQUE. I think we intend it to be unique and should declare it as such.\r\nAnd then make all uses of `slice_id` within the SA database use `REFERENCES sa_slice(slice_id)`\r\n\r\nThis replaces proto-ch ticket 658\n\n _Imported from trac ticket [#174](http://trac.gpolab.bbn.com/chapi/ticket/174),  created by ahelsing on 12-11-2013 at 09:48, last modified: 07-25-2014 at 15:44_\n"},"comment":{"url":"https://api.github.com/repos/ahelsing/tickettest2/issues/comments/103715165","html_url":"https://github.com/ahelsing/tickettest2/issues/174#issuecomment-103715165","issue_url":"https://api.github.com/repos/ahelsing/tickettest2/issues/174","id":103715165,"user":{"login":"ahelsing","id":12136824,"avatar_url":"https://avatars.githubusercontent.com/u/12136824?v=3","gravatar_id":"","url":"https://api.github.com/users/ahelsing","html_url":"https://github.com/ahelsing","followers_url":"https://api.github.com/users/ahelsing/followers","following_url":"https://api.github.com/users/ahelsing/following{/other_user}","gists_url":"https://api.github.com/users/ahelsing/gists{/gist_id}","starred_url":"https://api.github.com/users/ahelsing/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ahelsing/subscriptions","organizations_url":"https://api.github.com/users/ahelsing/orgs","repos_url":"https://api.github.com/users/ahelsing/repos","events_url":"https://api.github.com/users/ahelsing/events{/privacy}","received_events_url":"https://api.github.com/users/ahelsing/received_events","type":"User","site_admin":false},"created_at":"2015-05-20T01:33:59Z","updated_at":"2015-05-20T01:33:59Z","body":"Changes to code in this repo are to re-arrange code creating projects and slices to avoid foreign key constraint violations.\r\n\r\nAfter applying the update.sql for the SA due to chapi ticket 943, this code is required when creating a project or slice.\r\n\n\n_Trac comment by ahelsing on 07-25-2014 at 15:44_\n"}}