SQL code to create Bingeworthy database

bingeworthy.sql

create table programs (
	id varchar (255), 
	type varchar (32), 
	title varchar (255), 
	screenname varchar (255),
	approved boolean, 
	whencreated datetime, 
	whenmodified datetime, 
	primary key (id)
	);
create table ratings (
	idprogram varchar (255),
	screenname varchar (255),
	rating tinyint,
	whencreated datetime, 
	whenmodified datetime,
	comment text,
	primary key (idprogram, screenname)
	);
create table log (
	name varchar (32),
	whencreated datetime, 
	jsontext text,
	primary key (whencreated)
	);
create table watchlist (
	idprogram varchar (255),
	screenname varchar (255),
	whencreated datetime, 
	primary key (idprogram, screenname)
	);