db.sqlite.create.php

[GoogleCodeExporter]

Version  1.4.3

Three table are not installed on sqlite  "users", "settings", 
"plugin_extensions"

The sql code is wrong.

The right code is here:

$kfmdb->query("CREATE TABLE ".KFM_DB_PREFIX."users(
        id INTEGER PRIMARY KEY,
        username text,
        password text,
        status INTEGER default 2
    )");
    $kfmdb->query("CREATE TABLE ".KFM_DB_PREFIX."settings(
        id INTEGER PRIMARY KEY,
        name text,
        value text,
        user_id INTEGER not null,
        usersetting INTEGER(1) default 0
    )");
    $kfmdb->query("CREATE TABLE ".KFM_DB_PREFIX."plugin_extensions(
        id INTEGER PRIMARY KEY,
        extension text,
        plugin text,
        user_id INTEGER not null
    )");

Please Change this !!!

Original issue reported on code.google.com by nilsfeld@gmail.com on 17 Nov 2009 at 6:59

[GoogleCodeExporter]

a little bug fixed:

$kfmdb->query("CREATE TABLE ".KFM_DB_PREFIX."settings(
        id INTEGER PRIMARY KEY,
        name text,
        value text,
        user_id INTEGER not null,
        usersetting INTEGER default 0
)");

Original comment by nilsfeld@gmail.com on 18 Nov 2009 at 6:16

[GoogleCodeExporter]

thanks Nils,
I've added that to the SVN version of 1.4

I'll republish the KFM package once I've looked at some other bugs. (checking 
now)

Original comment by kae.verens@gmail.com on 18 Nov 2009 at 8:52

• Changed state: Fixed