cur.execute("""CREATE TABLE IF NOT EXISTS users (
                id INT NOT NULL AUTOINCREMENT,
                name TEXT NOT NULL,
                pass TEXT NOT NULL,
                revision INT, PRIMARY KEY(id))
                """)

 CREATE TABLE people (
   person_id INTEGER PRIMARY KEY AUTOINCREMENT,
   first_name text NOT NULL,
   last_name text NOT NULL
);

 CREATE TABLE IF NOT EXISTS room(room_id INTEGER PRIMARY KEY, name VARCHAR(25) NOT NULL, home_id VARCHAR(25) NOT NULL);