Ability to add column indexes

[simonw]

No description provided.

[simonw]

This is quite an advanced feature. Should it support compound indexes? I think so, but the UI for those is tricky.

[simonw]

Presumably it should prevent people from creating the same index multiple times - or does SQLite already either prevent that or quietly just create a single index?

[simonw]

I'm going to allow adding indexes on single columns, with an option to make them unique. I'll add drop index too.

[simonw]

I'm seeing these two indexes on a table that I ran this against:

CREATE INDEX o_order_date ON Orders (order_date);

[
  Index(seq=0, name='o_order_date', unique=0, origin='c', partial=0, columns=['order_date']),
  Index(seq=1, name='sqlite_autoindex_Orders_1', unique=1, origin='pk', partial=0, columns=['id'])
]

I probably shouldn't let people drop those sqlite_autoindex_Orders_1 indexes - best information I found about them was this thread: https://sqlite.org/forum/info/f16f8ed8666c5e97

[simonw]

CREATE INDEX blah_customer_id 
ON Orders (customer_id, order_date, status);

CREATE UNIQUE INDEX idx_orders_unique 
ON Orders (order_id, order_date);

Page now looks like this: