create table if not exists users (
    id text not null primary key,
    username text not null unique,
    hash_pass text not null,
    created_at datetime not null
);

create table if not exists characters (
    id text not null primary key,
    user_id text not null,
    name text not null,
    description text not null,
    created_at datetime not null,
    foreign key(user_id) references user(id)
);
create unique index if not exists idx_characters_user_id_name on characters(user_id, name);

create table if not exists prompts (
    id text not null primary key,
    user_id text not null,
    prompt text not null,
    created_at datetime not null,
    foreign key(user_id) references user(id)
);

create table if not exists subscriptions (
    id text not null primary key,
    user_id text not null unique,
    stripe_customer_id text not null unique,
    active bool not null,
    created_at datetime not null,
    foreign key(user_id) references user(id)
);

create table if not exists stories (
    id text not null primary key,
    prompt_id text not null,
    user_id text not null,
    title text not null,
    summary text not null,
    story text not null,
    created_at datetime not null,
    foreign key(prompt_id) references prompts(id)
    foreign key(user_id) references user(id)
);

create table if not exists sessions (
    token text primary key,
    user_id text not null,
    expire_at datetime not null
);