#30 no way to create Auto Increment columns with gui

[Edward Rudd]

SQLite support the autoincrement feature when a column
in a table is created as follows

CREATE TABLE names (
name_id INTEGER PRIMARY KEY AUTOINCREMENT,
name VARCHAR(255)
);

However this is not exposed through the sqlite web user
interface.

[Gandalf]

Logged In: YES
user_id=1598437

As far as I know SQLite does not support this way of
defining an Autoincrement. In SQLite it's defined as follows:

INTEGER PRIMARY KEY
Source: http://www.sqlite.org/faq.html#q1

[Edward Rudd]

Logged In: YES
user_id=8488

From that same FAQ entry "
To create keys that are unique over the lifetime of the
table, add the AUTOINCREMENT keyword to the INTEGER PRIMARY
KEY declaration. Then the key chosen will be one more than
than the largest key that has ever existed in that table.
"

Also it would allow the ability to make it so the SCHEMA is
similar to what would be used in MySQL (as I often use
SSQLite for prototyping )