text: 
  -- this is to ensure that previous tables are cleared out
  DROP TABLE IF EXISTS user;
  DROP TABLE IF EXISTS post;
  
  /* 
  	Create the user and post tables which we need for the blog. 
  
  	We need to have that each author of a post is a user, so  
  	the post foreign key is user. 
  */
  CREATE TABLE user (
  	id INTEGER PRIMARY KEY AUTOINCREMENT,
  	username TEXT UNIQUE NOT NULL,
  	password TEXT NOT NULL
  );
  
  CREATE TABLE post (
  	id INTEGER PRIMARY KEY AUTOINCREMENT,
  	author_id INTEGER NOT NULL,
  	created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  	title TEXT NOT NULL,
  	body TEXT NOT NULL,
  	FOREIGN KEY (author_id) REFERENCES user (id)
  );
  