Adding new field to table
Issue #42
invalid
Originally reported on Google Code with ID 42 ``` What steps will reproduce the problem? 1. Create table 2. Adding new field 3. Field: ID Type: INTEGER Primary Key + Autoincrement + Not NULL
What is the expected output? What do you see instead?
An error occured. This may be a bug that needs to be reported...
What version of the product are you using? On what operating system? phpliteadmin v1-8-6, Linux fedora 15 (php 5.3.6), SQLite 3.
Please provide any additional information below.
If this is done when creating a table, then everything is fine.
```
Reported by `XNicON` on 2011-06-20 13:00:39
Comments (1)
-
Account Deleted - Log in to comment
``` According to SQLite.org:
"The ADD COLUMN syntax is used to add a new column to an existing table. The new column is always appended to the end of the list of existing columns. The column-def rule defines the characteristics of the new column. The new column may take any of the forms permissible in a CREATE TABLE statement, with the following restrictions:
The column may not have a PRIMARY KEY or UNIQUE constraint."
The operation described is not supported. ```
Reported by `george@digitalgaslight.com` on 2011-08-24 18:00:29 - Status changed: `Invalid` - Labels added: Type-Other, Priority-Low - Labels removed: Type-Defect, Priority-Medium