{"action":"created","issue":{"url":"https://api.github.com/repos/TeamPlate/OnMiner/issues/5","labels_url":"https://api.github.com/repos/TeamPlate/OnMiner/issues/5/labels{/name}","comments_url":"https://api.github.com/repos/TeamPlate/OnMiner/issues/5/comments","events_url":"https://api.github.com/repos/TeamPlate/OnMiner/issues/5/events","html_url":"https://github.com/TeamPlate/OnMiner/issues/5","id":55797228,"number":5,"title":"Реализация триггеров на update,insert и create в SQL Database","user":{"login":"RSamokhin","id":5427231,"avatar_url":"https://avatars.githubusercontent.com/u/5427231?v=3","gravatar_id":"","url":"https://api.github.com/users/RSamokhin","html_url":"https://github.com/RSamokhin","followers_url":"https://api.github.com/users/RSamokhin/followers","following_url":"https://api.github.com/users/RSamokhin/following{/other_user}","gists_url":"https://api.github.com/users/RSamokhin/gists{/gist_id}","starred_url":"https://api.github.com/users/RSamokhin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RSamokhin/subscriptions","organizations_url":"https://api.github.com/users/RSamokhin/orgs","repos_url":"https://api.github.com/users/RSamokhin/repos","events_url":"https://api.github.com/users/RSamokhin/events{/privacy}","received_events_url":"https://api.github.com/users/RSamokhin/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TeamPlate/OnMiner/labels/development","name":"development","color":"eb6420"}],"state":"open","locked":false,"assignee":{"login":"iFoxxy","id":10603050,"avatar_url":"https://avatars.githubusercontent.com/u/10603050?v=3","gravatar_id":"","url":"https://api.github.com/users/iFoxxy","html_url":"https://github.com/iFoxxy","followers_url":"https://api.github.com/users/iFoxxy/followers","following_url":"https://api.github.com/users/iFoxxy/following{/other_user}","gists_url":"https://api.github.com/users/iFoxxy/gists{/gist_id}","starred_url":"https://api.github.com/users/iFoxxy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/iFoxxy/subscriptions","organizations_url":"https://api.github.com/users/iFoxxy/orgs","repos_url":"https://api.github.com/users/iFoxxy/repos","events_url":"https://api.github.com/users/iFoxxy/events{/privacy}","received_events_url":"https://api.github.com/users/iFoxxy/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/TeamPlate/OnMiner/milestones/1","labels_url":"https://api.github.com/repos/TeamPlate/OnMiner/milestones/1/labels","id":954545,"number":1,"title":"initiation project","description":"","creator":{"login":"RSamokhin","id":5427231,"avatar_url":"https://avatars.githubusercontent.com/u/5427231?v=3","gravatar_id":"","url":"https://api.github.com/users/RSamokhin","html_url":"https://github.com/RSamokhin","followers_url":"https://api.github.com/users/RSamokhin/followers","following_url":"https://api.github.com/users/RSamokhin/following{/other_user}","gists_url":"https://api.github.com/users/RSamokhin/gists{/gist_id}","starred_url":"https://api.github.com/users/RSamokhin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RSamokhin/subscriptions","organizations_url":"https://api.github.com/users/RSamokhin/orgs","repos_url":"https://api.github.com/users/RSamokhin/repos","events_url":"https://api.github.com/users/RSamokhin/events{/privacy}","received_events_url":"https://api.github.com/users/RSamokhin/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":0,"state":"open","created_at":"2015-01-28T08:48:12Z","updated_at":"2015-01-28T18:42:38Z","due_on":"2015-02-02T21:00:00Z","closed_at":null},"comments":1,"created_at":"2015-01-28T18:42:38Z","updated_at":"2015-01-28T20:05:39Z","closed_at":null,"body":"Зарегистрировать триальную версию на Azure, создать SQL database, понять, возможно ли в ней создание триггеров на апдейт и инсерт.\r\n\r\nПроверить возможность создания триггеров на create, при создании таблицы всегда создавать дополнительный столбец timestamp с хранением даты (например в милисекундах) Если триггер на создание таблицы повесить невозможно, поле будем создавать вручную, либо напишем обработчик\r\n* Промежуточная задача -  При добавлении или изменении записи должно проставляться текущее время\r\n* Пред Конечная задача - должна создаваться строчка в файле лога с указанием что на что и во сколько поменялось. Файлы с логами периодически должны комититься на гит-сервер и удаляться, чтобы не разрастались\r\n* Абсолютно конечная задача - должна создаваться запись в REDDIS или в realtime.co и с определенной периодичностью данные должны сбрасываться в файл\r\n\r\nФакультативная задача - настройка поиска по многим файлам логов"},"comment":{"url":"https://api.github.com/repos/TeamPlate/OnMiner/issues/comments/71905615","html_url":"https://github.com/TeamPlate/OnMiner/issues/5#issuecomment-71905615","issue_url":"https://api.github.com/repos/TeamPlate/OnMiner/issues/5","id":71905615,"user":{"login":"jgc128","id":669142,"avatar_url":"https://avatars.githubusercontent.com/u/669142?v=3","gravatar_id":"","url":"https://api.github.com/users/jgc128","html_url":"https://github.com/jgc128","followers_url":"https://api.github.com/users/jgc128/followers","following_url":"https://api.github.com/users/jgc128/following{/other_user}","gists_url":"https://api.github.com/users/jgc128/gists{/gist_id}","starred_url":"https://api.github.com/users/jgc128/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jgc128/subscriptions","organizations_url":"https://api.github.com/users/jgc128/orgs","repos_url":"https://api.github.com/users/jgc128/repos","events_url":"https://api.github.com/users/jgc128/events{/privacy}","received_events_url":"https://api.github.com/users/jgc128/received_events","type":"User","site_admin":false},"created_at":"2015-01-28T20:05:39Z","updated_at":"2015-01-28T20:05:39Z","body":">должна создаваться строчка в файле лога\r\n\r\nЭто может не получится, я не знаю, есть ли там доступ к файлам. Можно записывать в специальную лог-таблицу"}}