create index action and create-table option

[Meaglin]

Allow defining an index when creating a table and also create index query type.

[jrf0110]

Hey, @Meaglin I've been on vacation for the past week, so I'm just getting to my notifications.

When you say defining an index when creating a table, do you mean to allow the create-table query to output multiple queries? If so, I think that may be out-of-scope of the project.

However, we do need to add a create-index query type. I will take care of that in #117

[Meaglin]

I'm actually using mongo-sql for both postgres and mysql. And in mysql you can define ur index inside your create table query:

CREATE TABLE 'name' (
'id' int(10) primary,
'name' varchar(255),
'status' varchar(255),
unique 'unique key name' ('name', 'status'),
key 'key name' ('id', 'name')
)

And i was also missing the separate option to define an index: CREATE INDEX 'index_name' ('id','status')
as covered by #117

[jrf0110]

Interesting. That actually shouldn't be too bad to support