DROP TABLE IF EXISTS event_collections;
CREATE TABLE event_collections(
    collection_id INTEGER PRIMARY KEY,
    owner_id INTEGER, 
    type TEXT, 
    collection_summary TEXT,
    t5_summary TEXT,
    bert_summary TEXT,
    nltk_summary TEXT,
    collection_name TEXT
);

DROP TABLE IF EXISTS raw_text_files;
CREATE TABLE raw_text_files(
    id INTEGER PRIMARY KEY,
    collection_id INTEGER, 
    file_path TEXT
);

DROP TABLE IF EXISTS users;
CREATE TABLE users(
    user_id INTEGER, 
    user_name TEXT, 
    user_hash TEXT
);