Create table: Column names not properly escaped

[Christopher Kramer]

Originally reported on Google Code with ID 107 ``` What steps will reproduce the problem? 1. Create a table with two columns "a,b" and "c"

What is the expected output? What do you see instead? The following command is queried: CREATE TABLE test3(a,b INTEGER, c INTEGER) This creates a table with 3 columns (a,b,c) with column a having no type (which is no problem in SQLite because of its dynamic typing).

Expected result: Creation of a table with two columns, one having the name "a,b" and the second "c". This could be done using this SQL query: CREATE TABLE test3('a,b' INTEGER, c INTEGER)

Similar problems occur with column names containing spaces like "a b" which will cause a column "a" of type "a INTEGER" (if INTEGER type was chosen).

This is a concrete example of what was meant in issue #93 . ```

Reported by `crazy4chrissi` on 2012-05-30 15:39:48

[Christopher Kramer]

``` Typo above: Similar problems occur with column names containing spaces like "a b" which will cause a column "a" of type "a INTEGER" (if INTEGER type was chosen).

The resulting type is "b INTEGER", not "a INTEGER". ```

Reported by `crazy4chrissi` on 2012-05-30 15:41:46

[Christopher Kramer]

``` Fixed this issue in SVN Revision #209: http://code.google.com/p/phpliteadmin/source/browse/source/1.9.3/phpliteadmin.php ```

Reported by `crazy4chrissi` on 2012-05-30 16:11:22 - Status changed: `Started`

[Christopher Kramer]

Reported by `crazy4chrissi` on 2012-06-02 10:54:21 - Status changed: `Fixed`