{"action":"created","issue":{"url":"https://api.github.com/repos/franc3000/datastore/issues/39","repository_url":"https://api.github.com/repos/franc3000/datastore","labels_url":"https://api.github.com/repos/franc3000/datastore/issues/39/labels{/name}","comments_url":"https://api.github.com/repos/franc3000/datastore/issues/39/comments","events_url":"https://api.github.com/repos/franc3000/datastore/issues/39/events","html_url":"https://github.com/franc3000/datastore/issues/39","id":158811843,"number":39,"title":"indexes broken for realtytrac_tax","user":{"login":"franc3000","id":10376582,"avatar_url":"https://avatars.githubusercontent.com/u/10376582?v=3","gravatar_id":"","url":"https://api.github.com/users/franc3000","html_url":"https://github.com/franc3000","followers_url":"https://api.github.com/users/franc3000/followers","following_url":"https://api.github.com/users/franc3000/following{/other_user}","gists_url":"https://api.github.com/users/franc3000/gists{/gist_id}","starred_url":"https://api.github.com/users/franc3000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/franc3000/subscriptions","organizations_url":"https://api.github.com/users/franc3000/orgs","repos_url":"https://api.github.com/users/franc3000/repos","events_url":"https://api.github.com/users/franc3000/events{/privacy}","received_events_url":"https://api.github.com/users/franc3000/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"franc3000","id":10376582,"avatar_url":"https://avatars.githubusercontent.com/u/10376582?v=3","gravatar_id":"","url":"https://api.github.com/users/franc3000","html_url":"https://github.com/franc3000","followers_url":"https://api.github.com/users/franc3000/followers","following_url":"https://api.github.com/users/franc3000/following{/other_user}","gists_url":"https://api.github.com/users/franc3000/gists{/gist_id}","starred_url":"https://api.github.com/users/franc3000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/franc3000/subscriptions","organizations_url":"https://api.github.com/users/franc3000/orgs","repos_url":"https://api.github.com/users/franc3000/repos","events_url":"https://api.github.com/users/franc3000/events{/privacy}","received_events_url":"https://api.github.com/users/franc3000/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/franc3000/datastore/milestones/2","html_url":"https://github.com/franc3000/datastore/milestones/RealtyTrac%20import","labels_url":"https://api.github.com/repos/franc3000/datastore/milestones/2/labels","id":1748127,"number":2,"title":"RealtyTrac import","description":"","creator":{"login":"franc3000","id":10376582,"avatar_url":"https://avatars.githubusercontent.com/u/10376582?v=3","gravatar_id":"","url":"https://api.github.com/users/franc3000","html_url":"https://github.com/franc3000","followers_url":"https://api.github.com/users/franc3000/followers","following_url":"https://api.github.com/users/franc3000/following{/other_user}","gists_url":"https://api.github.com/users/franc3000/gists{/gist_id}","starred_url":"https://api.github.com/users/franc3000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/franc3000/subscriptions","organizations_url":"https://api.github.com/users/franc3000/orgs","repos_url":"https://api.github.com/users/franc3000/repos","events_url":"https://api.github.com/users/franc3000/events{/privacy}","received_events_url":"https://api.github.com/users/franc3000/received_events","type":"User","site_admin":false},"open_issues":9,"closed_issues":0,"state":"open","created_at":"2016-05-04T16:57:02Z","updated_at":"2016-06-07T01:41:06Z","due_on":"2016-05-05T07:00:00Z","closed_at":null},"comments":1,"created_at":"2016-06-07T01:40:57Z","updated_at":"2016-06-07T05:50:53Z","closed_at":null,"body":"```\r\nmysql> optimize table realtytrac_tax;\r\n+-------------------------+----------+----------+-------------------------------------------------------------------+\r\n| Table                   | Op       | Msg_type | Msg_text                                                          |\r\n+-------------------------+----------+----------+-------------------------------------------------------------------+\r\n| paretodb.realtytrac_tax | optimize | note     | Table does not support optimize, doing recreate + analyze instead |\r\n| paretodb.realtytrac_tax | optimize | status   | OK                                                                |\r\n+-------------------------+----------+----------+-------------------------------------------------------------------+\r\n2 rows in set (2 hours 1 min 9.29 sec)\r\n```\r\n\r\n```\r\nmysql> alter table realtytrac_tax ADD SFR int(11) default 0;\r\nQuery OK, 0 rows affected (3 hours 37 min 3.83 sec)\r\nRecords: 0  Duplicates: 0  Warnings: 0\r\n```"},"comment":{"url":"https://api.github.com/repos/franc3000/datastore/issues/comments/224185194","html_url":"https://github.com/franc3000/datastore/issues/39#issuecomment-224185194","issue_url":"https://api.github.com/repos/franc3000/datastore/issues/39","id":224185194,"user":{"login":"franc3000","id":10376582,"avatar_url":"https://avatars.githubusercontent.com/u/10376582?v=3","gravatar_id":"","url":"https://api.github.com/users/franc3000","html_url":"https://github.com/franc3000","followers_url":"https://api.github.com/users/franc3000/followers","following_url":"https://api.github.com/users/franc3000/following{/other_user}","gists_url":"https://api.github.com/users/franc3000/gists{/gist_id}","starred_url":"https://api.github.com/users/franc3000/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/franc3000/subscriptions","organizations_url":"https://api.github.com/users/franc3000/orgs","repos_url":"https://api.github.com/users/franc3000/repos","events_url":"https://api.github.com/users/franc3000/events{/privacy}","received_events_url":"https://api.github.com/users/franc3000/received_events","type":"User","site_admin":false},"created_at":"2016-06-07T05:50:53Z","updated_at":"2016-06-07T05:50:53Z","body":"```\r\n-- REALTYTRAC\r\nALTER TABLE realtytrac_tax ADD dataset varchar(255);\r\n\r\nALTER TABLE realtytrac_tax ADD SFR int(11) default 0;\r\nUPDATE realtytrac_tax set SFR=1 where PropertyType = 'Single Family Residence';\r\nCREATE INDEX SFR on realtytrac_tax (SFR);\r\n\r\nALTER TABLE realtytrac_tax ADD OwnerOccupiedInt int(11) default 0;\r\nUPDATE realtytrac_tax set OwnerOccupiedInt=1 where OwnerOccupied = 'Y';\r\nCREATE INDEX occ on realtytrac_tax (OwnerOccupiedInt);\r\n```"}}
{"actor":{"display_login":"franc3000"}}