Description:
------------
   sqlite3 file.db ".dump"

produces on the first line

   CREATE TABLE "historia" ("nr" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL , 
"jahr" TEXT);

This string produces a table in sqlite> (a sqlite3 started on command line)




but, as $query="CREATE TABLE historia (nr INTEGER PRIMARY KEY  AUTOINCREMENT  
NOT NULL , jahr TEXT);";

and sent with sqlite_exec($dbhandle, $query, $error);
or            $base->queryexec($query);

doesn't work.




Is fixed by moving AUTOINCREMENT in front of PRIMARY KEY
Can be a parsing error in the parsers used by sqlite_exec() and $base-
>queryexec()

Test script:
---------------
$dbhandle = sqlite_open(minfil, 0666, $error);
if (!$dbhandle) die ($error);

$query = "CREATE TABLE hist (nr INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL , jahr TEXT);";

$ok = sqlite_exec($dbhandle, $query, $error);
if (!$ok) die("Cannot execute query. $error");


echo "OK!";

Expected result:
----------------
new TABLE in the database file

Actual result:
--------------
error message