Adding new field to table

Issue #42 invalid
Former user created an issue

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)

  1. Former user Account Deleted

    ``` 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

  2. Log in to comment