<?php
  // This php page will create a new movies table

  // create new database (OO interface)
$db = new SQLiteDatabase("db/db.sqlite");

// create table movies with title and year columns
$db->query("BEGIN;
        CREATE TABLE movies(id INTEGER PRIMARY KEY, title CHAR(255), year INTEGER);
        COMMIT;");


// not generally needed as PHP will destroy the connection
unset($db);

?>