{"action":"closed","issue":{"url":"https://api.github.com/repos/loconomics/loconomics/issues/798","repository_url":"https://api.github.com/repos/loconomics/loconomics","labels_url":"https://api.github.com/repos/loconomics/loconomics/issues/798/labels{/name}","comments_url":"https://api.github.com/repos/loconomics/loconomics/issues/798/comments","events_url":"https://api.github.com/repos/loconomics/loconomics/issues/798/events","html_url":"https://github.com/loconomics/loconomics/issues/798","id":296120671,"number":798,"title":"Add VOC Element for Credentials","user":{"login":"joshdanielson","id":1202838,"avatar_url":"https://avatars3.githubusercontent.com/u/1202838?v=4","gravatar_id":"","url":"https://api.github.com/users/joshdanielson","html_url":"https://github.com/joshdanielson","followers_url":"https://api.github.com/users/joshdanielson/followers","following_url":"https://api.github.com/users/joshdanielson/following{/other_user}","gists_url":"https://api.github.com/users/joshdanielson/gists{/gist_id}","starred_url":"https://api.github.com/users/joshdanielson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joshdanielson/subscriptions","organizations_url":"https://api.github.com/users/joshdanielson/orgs","repos_url":"https://api.github.com/users/joshdanielson/repos","events_url":"https://api.github.com/users/joshdanielson/events{/privacy}","received_events_url":"https://api.github.com/users/joshdanielson/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"IagoSRL","id":1070576,"avatar_url":"https://avatars1.githubusercontent.com/u/1070576?v=4","gravatar_id":"","url":"https://api.github.com/users/IagoSRL","html_url":"https://github.com/IagoSRL","followers_url":"https://api.github.com/users/IagoSRL/followers","following_url":"https://api.github.com/users/IagoSRL/following{/other_user}","gists_url":"https://api.github.com/users/IagoSRL/gists{/gist_id}","starred_url":"https://api.github.com/users/IagoSRL/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/IagoSRL/subscriptions","organizations_url":"https://api.github.com/users/IagoSRL/orgs","repos_url":"https://api.github.com/users/IagoSRL/repos","events_url":"https://api.github.com/users/IagoSRL/events{/privacy}","received_events_url":"https://api.github.com/users/IagoSRL/received_events","type":"User","site_admin":false},"assignees":[{"login":"IagoSRL","id":1070576,"avatar_url":"https://avatars1.githubusercontent.com/u/1070576?v=4","gravatar_id":"","url":"https://api.github.com/users/IagoSRL","html_url":"https://github.com/IagoSRL","followers_url":"https://api.github.com/users/IagoSRL/followers","following_url":"https://api.github.com/users/IagoSRL/following{/other_user}","gists_url":"https://api.github.com/users/IagoSRL/gists{/gist_id}","starred_url":"https://api.github.com/users/IagoSRL/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/IagoSRL/subscriptions","organizations_url":"https://api.github.com/users/IagoSRL/orgs","repos_url":"https://api.github.com/users/IagoSRL/repos","events_url":"https://api.github.com/users/IagoSRL/events{/privacy}","received_events_url":"https://api.github.com/users/IagoSRL/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-02-10T18:07:37Z","updated_at":"2018-03-02T19:06:53Z","closed_at":"2018-03-02T19:06:53Z","author_association":"COLLABORATOR","body":"@IagoSRL this should have been a separate issue for External Listings and Earnings but wasn't. External Listings was added to the live VOCElement table but not the dev. I just updated dev with the three elements but did not touch live. You'll have an issue with the first statement since that id already exists so omit it, but run it on any local db copies. \r\n\r\n\r\n\r\n`INSERT INTO dbo.VOCElement (VOCElementID, LanguageID, CountryID, VOCElementName, ScoreStartValue, ScoreMidValue, ScoreEndValue, ScoreStartLabel, ScoreMidLabel, ScoreEndLabel, CreateDate, UpdatedDate, ModifiedBy, Active) VALUES (21, 1, 1, 'External Listings', null, null, null, null, null, null, '2/9/2018', '2/9/2018', 'js', 1);\r\nINSERT INTO dbo.VOCElement (VOCElementID, LanguageID, CountryID, VOCElementName, ScoreStartValue, ScoreMidValue, ScoreEndValue, ScoreStartLabel, ScoreMidLabel, ScoreEndLabel, CreateDate, UpdatedDate, ModifiedBy, Active) VALUES (22, 1, 1, 'Earnings', null, null, null, null, null, null, '2/9/2018', '2/9/2018', 'js', 1);\r\nINSERT INTO dbo.VOCElement (VOCElementID, LanguageID, CountryID, VOCElementName, ScoreStartValue, ScoreMidValue, ScoreEndValue, ScoreStartLabel, ScoreMidLabel, ScoreEndLabel, CreateDate, UpdatedDate, ModifiedBy, Active) VALUES (23, 1, 1, 'Credentials', null, null, null, null, null, null, '2/9/2018', '2/9/2018', 'js', 1);\r\n`"}}
{"actor":{"display_login":"IagoSRL"}}