create database


  
  db = new SQLiteDatabase("server-php-sqlite-voting.db"); 
  
  /* 
  db->query("BEGIN;
          CREATE TABLE voteoptions (id INTEGER PRIMARY KEY, name CHAR(20));
          INSERT INTO voteoptions (name) VALUES('hat');
          INSERT INTO voteoptions (name) VALUES('mug');
          INSERT INTO voteoptions (name) VALUES('shirt');
          INSERT INTO voteoptions (name) VALUES('cup');
          COMMIT;"); 
          
  db->query("BEGIN;
          CREATE TABLE poll (id INTEGER PRIMARY KEY, vote CHAR(20));
          INSERT INTO poll (vote) VALUES('hat');
          INSERT INTO poll (vote) VALUES('hat');
          INSERT INTO poll (vote) VALUES('shirt');
          INSERT INTO poll (vote) VALUES('mug');
          INSERT INTO poll (vote) VALUES('hat');
          INSERT INTO poll (vote) VALUES('hat');
          COMMIT;"); 
  */