#100 No interface for creating auto_increment fields in dbtables

[Seamus Campbell]

Currently there is no way short of manually executing
SQL to do much editing of existing dbtable fields. One
such useful editing task is making the automatically
created TABLENAME_id field an auto_increment field.
Other tasks that SQL permits are renaming whole
tables, renaming fields, and (in some circumstances)
changing the data type of a field.

Ideally the interface for dbtable editing in the
displaytable htmlcode would be updated along with
backend wrapper code to perform the update.

The following SQL query will modify your dbtable's id
field to auto_increment:

ALTER TABLE my_table CHANGE COLUMN
my_table_id my_table_id int(11) NOT NULL
auto_increment

This has been tested under mySql on (I think) pre-1.0.3.
I don't have any idea how portable this is to other DBs
but I believe it is SQL '92 compliant.

--conform