phpuserlite 1.x->2.x DB upgrade script - Draft 1

<?php

$dbpath = '';

$db = new PDO('sqlite:'.$dbpath);

$db->exec('CREATE TEMP TABLE users(id INTEGER PRIMARY KEY,
                                   username TEXT NOT NULL UNIQUE COLLATE NOCASE,
                                   password TEXT NOT NULL,
                                   salt BLOB NOT NULL,
                                   email TEXT NOT NULL UNIQUE COLLATE NOCASE,
                                   date INTEGER NOT NULL,
                                   sessionKey TEXT,
                                   sessionIP TEXT)');
$db->exec('INSERT INTO temp.users SELECT * FROM users');
$db->exec('DROP TABLE users');
$db->exec('CREATE TABLE IF NOT EXISTS users(id INTEGER PRIMARY KEY,
                                            username TEXT NOT NULL UNIQUE COLLATE NOCASE,
                                            password TEXT NOT NULL,
                                            salt BLOB NOT NULL,
                                            email TEXT NOT NULL UNIQUE COLLATE NOCASE,
                                            date INTEGER NOT NULL,
                                            sessionKey TEXT,
                                            sessionIP TEXT,
                                            failureCount INTEGER,
                                            failureTime REAL)');
$db->exec('INSERT INTO users SELECT * FROM temp.users');

?>