{"action":"created","issue":{"url":"https://api.github.com/repos/Runalyze/Runalyze/issues/581","labels_url":"https://api.github.com/repos/Runalyze/Runalyze/issues/581/labels{/name}","comments_url":"https://api.github.com/repos/Runalyze/Runalyze/issues/581/comments","events_url":"https://api.github.com/repos/Runalyze/Runalyze/issues/581/events","html_url":"https://github.com/Runalyze/Runalyze/issues/581","id":40730389,"number":581,"title":"Equipment for all sport types","user":{"login":"mipapo","id":2135076,"avatar_url":"https://avatars.githubusercontent.com/u/2135076?v=3","gravatar_id":"","url":"https://api.github.com/users/mipapo","html_url":"https://github.com/mipapo","followers_url":"https://api.github.com/users/mipapo/followers","following_url":"https://api.github.com/users/mipapo/following{/other_user}","gists_url":"https://api.github.com/users/mipapo/gists{/gist_id}","starred_url":"https://api.github.com/users/mipapo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mipapo/subscriptions","organizations_url":"https://api.github.com/users/mipapo/orgs","repos_url":"https://api.github.com/users/mipapo/repos","events_url":"https://api.github.com/users/mipapo/events{/privacy}","received_events_url":"https://api.github.com/users/mipapo/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Runalyze/Runalyze/labels/feature","name":"feature","color":"fbca04"}],"state":"open","locked":false,"assignee":{"login":"laufhannes","id":8313118,"avatar_url":"https://avatars.githubusercontent.com/u/8313118?v=3","gravatar_id":"","url":"https://api.github.com/users/laufhannes","html_url":"https://github.com/laufhannes","followers_url":"https://api.github.com/users/laufhannes/followers","following_url":"https://api.github.com/users/laufhannes/following{/other_user}","gists_url":"https://api.github.com/users/laufhannes/gists{/gist_id}","starred_url":"https://api.github.com/users/laufhannes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laufhannes/subscriptions","organizations_url":"https://api.github.com/users/laufhannes/orgs","repos_url":"https://api.github.com/users/laufhannes/repos","events_url":"https://api.github.com/users/laufhannes/events{/privacy}","received_events_url":"https://api.github.com/users/laufhannes/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/Runalyze/Runalyze/milestones/30","html_url":"https://github.com/Runalyze/Runalyze/milestones/Runalyze%20v2.2","labels_url":"https://api.github.com/repos/Runalyze/Runalyze/milestones/30/labels","id":1156636,"number":30,"title":"Runalyze v2.2","description":"Further improvements of Runalyze v2.1.","creator":{"login":"laufhannes","id":8313118,"avatar_url":"https://avatars.githubusercontent.com/u/8313118?v=3","gravatar_id":"","url":"https://api.github.com/users/laufhannes","html_url":"https://github.com/laufhannes","followers_url":"https://api.github.com/users/laufhannes/followers","following_url":"https://api.github.com/users/laufhannes/following{/other_user}","gists_url":"https://api.github.com/users/laufhannes/gists{/gist_id}","starred_url":"https://api.github.com/users/laufhannes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laufhannes/subscriptions","organizations_url":"https://api.github.com/users/laufhannes/orgs","repos_url":"https://api.github.com/users/laufhannes/repos","events_url":"https://api.github.com/users/laufhannes/events{/privacy}","received_events_url":"https://api.github.com/users/laufhannes/received_events","type":"User","site_admin":false},"open_issues":9,"closed_issues":0,"state":"open","created_at":"2015-06-09T11:11:04Z","updated_at":"2015-07-11T07:49:24Z","due_on":"2015-08-30T22:00:00Z","closed_at":null},"comments":4,"created_at":"2014-08-20T18:40:35Z","updated_at":"2015-07-11T10:31:55Z","closed_at":null,"body":"Equipment must be available for all sport types. Running shoes and clothes have to be migrated to a new database structure.\r\n\r\nUsers should be able to define their own categories/types of equipment, e.g. bikes. Each type should have its own predefined lifetime.\r\n\r\n**equipment_type**\r\n - `id`\r\n - `name`\r\n - `input` (`select | checkbox`)\r\n - `max_km`\r\n - `max_time`\r\n - `accountid`\r\n\r\n**equipment**\r\n - `id`\r\n - `name`\r\n - `typeid`\r\n - `notes` (current weight of shoes has to go here)\r\n - `distance`\r\n - `time`\r\n - `additional_km`\r\n - `date_start`\r\n - `date_end` (instead of inuse)\r\n - `accountid`\r\n\r\n**equipment_sport**\r\n - `sportid`\r\n - `equipment_typeid`\r\n\r\n**activity_equipment**\r\n - `activityid`\r\n - `equipmentid`\r\n\r\nTODO:\r\n-  [ ] Search function\r\n-  [ ] Plugin (Order limit km/time)\r\n-  [x] Cleanup / Recalculate Equipment"},"comment":{"url":"https://api.github.com/repos/Runalyze/Runalyze/issues/comments/120602976","html_url":"https://github.com/Runalyze/Runalyze/issues/581#issuecomment-120602976","issue_url":"https://api.github.com/repos/Runalyze/Runalyze/issues/581","id":120602976,"user":{"login":"mipapo","id":2135076,"avatar_url":"https://avatars.githubusercontent.com/u/2135076?v=3","gravatar_id":"","url":"https://api.github.com/users/mipapo","html_url":"https://github.com/mipapo","followers_url":"https://api.github.com/users/mipapo/followers","following_url":"https://api.github.com/users/mipapo/following{/other_user}","gists_url":"https://api.github.com/users/mipapo/gists{/gist_id}","starred_url":"https://api.github.com/users/mipapo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mipapo/subscriptions","organizations_url":"https://api.github.com/users/mipapo/orgs","repos_url":"https://api.github.com/users/mipapo/repos","events_url":"https://api.github.com/users/mipapo/events{/privacy}","received_events_url":"https://api.github.com/users/mipapo/received_events","type":"User","site_admin":false},"created_at":"2015-07-11T10:31:55Z","updated_at":"2015-07-11T10:31:55Z","body":"`select * from runalyze_equipment eq LEFT JOIN runalyze_equipment_type eqt ON eq.typeid = eqt.id LEFT JOIN runalyze_equipment_sport eqs ON eqt.id = eqs.equipment_typeid;`"}}