 create table shows (
     id integer primary key autoincrement,
     public_id text not null,
-    title text not null,
-    seasons integer not null,
+    title text,
+    season_count integer,
     description text
 );
 

create table seasons (
    id integer primary key autoincrement,
    public_id integer not null,
    episodes integer not null
);

drop table if exists episodes;
create table episodes (
    id integer primary key autoincrement,
    public_id integer not null,
    title text not null
);

drop table if exists users;

    email text not null,
    username text not null,
    password text not null,
    first_name text,
    last_name text,
    permissions integer not null
);

drop table if exists watch_history;
create table watch_history (
    id integer primary key autoincrement,
    user_id integer,
    episode_id integer
);