Sorry if this is in the wrong forum but it appears daniweb doesn't have a category for sqlite or miscellaneous database systems. I have just started on a personal project which is an admin interface for sqlite (Like sqliteMyAdmin), similar to Phpmyadmin but for sqlite.
Anyways the question is how do I add indexes to a table when creating a table and what indexes are available for use. The only one I know of is
PRIMARY KEY . Does anybody know?