<?php

// open database
$db = new SQLiteDatabase('db/state.db',0666);
// $db = new PDO('sqlite:db.sql'); 

// uncomment the block below and 
// call this script if you lost the database file
// (visit http://locationofthis/update.php)

	$db->query("BEGIN;
        CREATE TABLE boxes (
			num INTEGER(5),
			name CHAR(140),
			x INTEGER(5),
			y INTEGER(5),
			z INTEGER(5),
			state INTEGER(5),
			text CHAR(140),
			code CHAR(140)
		);
        COMMIT;");
?>