Fly postgres not creating a table

Questions / Help
1

The table UsersToPatches isn’t created when running schema.sql on postgres fly.io

DROP TABLE IF EXISTS Patches CASCADE;
DROP TABLE IF EXISTS Images CASCADE;
DROP TABLE IF EXISTS Users CASCADE;
DROP TABLE IF EXISTS UsersToPatches CASCADE;

CREATE TABLE Users (
    id SERIAL PRIMARY KEY,
    username TEXT UNIQUE,
    password TEXT
);

CREATE TABLE Patches (
    id SERIAL PRIMARY KEY, 
    name TEXT,
    created_by_user TEXT REFERENCES Users(username)
);

CREATE TABLE Images (
    id SERIAL PRIMARY KEY,
    patch_id INTEGER REFERENCES Patches(id) ON DELETE CASCADE,
    data BYTEA
);

CREATE TABLE UsersToPatches (
    id SERIAL PRIMARY KEY,
    user_id INTEGER REFERENCES Users(id),
    patch_id INTEGER REFERENCES Patches(id) ON DELETE CASCADE,
    sent_at TIMESTAMP 
);```
2

What’s the error?

3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.