{"action":"opened","issue":{"url":"https://api.github.com/repos/datanucleus/datanucleus-rdbms/issues/248","repository_url":"https://api.github.com/repos/datanucleus/datanucleus-rdbms","labels_url":"https://api.github.com/repos/datanucleus/datanucleus-rdbms/issues/248/labels{/name}","comments_url":"https://api.github.com/repos/datanucleus/datanucleus-rdbms/issues/248/comments","events_url":"https://api.github.com/repos/datanucleus/datanucleus-rdbms/issues/248/events","html_url":"https://github.com/datanucleus/datanucleus-rdbms/issues/248","id":295897738,"number":248,"title":"Support more complete specification of CREATE INDEX statement","user":{"login":"andyjefferson","id":6105519,"avatar_url":"https://avatars1.githubusercontent.com/u/6105519?v=4","gravatar_id":"","url":"https://api.github.com/users/andyjefferson","html_url":"https://github.com/andyjefferson","followers_url":"https://api.github.com/users/andyjefferson/followers","following_url":"https://api.github.com/users/andyjefferson/following{/other_user}","gists_url":"https://api.github.com/users/andyjefferson/gists{/gist_id}","starred_url":"https://api.github.com/users/andyjefferson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andyjefferson/subscriptions","organizations_url":"https://api.github.com/users/andyjefferson/orgs","repos_url":"https://api.github.com/users/andyjefferson/repos","events_url":"https://api.github.com/users/andyjefferson/events{/privacy}","received_events_url":"https://api.github.com/users/andyjefferson/received_events","type":"User","site_admin":false},"labels":[{"id":69837757,"url":"https://api.github.com/repos/datanucleus/datanucleus-rdbms/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-09T14:57:09Z","updated_at":"2018-02-09T14:57:09Z","closed_at":null,"author_association":"OWNER","body":"DataNucleus has always supported the basic SQL standard \r\n\r\n`CREATE [UNIQUE] INDEX idxName ON tableName (col1, ...)`\r\n\r\nSome time back we added the ability to tag extra settings on the end of this. \r\n\r\nIf we look down current RDBMS capabilities the majority allow the column ordering to be specified, so we would have `col1 [ASC|DESC]` instead of `col1`. Similarly others provide for specification of the \"type\" of index as well as other things. We should try to allow these via extensions"}}
{"actor":{"display_login":"andyjefferson"}}