Skip to content

Instantly share code, notes, and snippets.

@scripting
Created December 1, 2023 15:12
Show Gist options
  • Save scripting/a5b3ac43939954c4af6759a9ce27989f to your computer and use it in GitHub Desktop.
Save scripting/a5b3ac43939954c4af6759a9ce27989f to your computer and use it in GitHub Desktop.
SQL code to create Bingeworthy database
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)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment