postgress stuff about headshots-starter

[rossman22590]

-- Create the models table first since it's referenced by other tables
CREATE TABLE models (
id INT8 PRIMARY KEY,
name TEXT NOT NULL,
type TEXT NOT NULL,
created_at TIMESTAMPTZ DEFAULT NOW(),
user_id UUID REFERENCES auth.users(id),
status TEXT NOT NULL,
modelId TEXT -- No need for unique constraint on this column anymore
);

-- Create the images table
CREATE TABLE images (
id INT8 PRIMARY KEY,
modelId INT8 REFERENCES models(id),
uri TEXT NOT NULL,
created_at TIMESTAMPTZ DEFAULT NOW()
);

-- Create the samples table
CREATE TABLE samples (
id INT8 PRIMARY KEY,
uri TEXT NOT NULL,
modelId INT8 REFERENCES models(id),
created_at TIMESTAMPTZ DEFAULT NOW()
);

-- Create the credits table
CREATE TABLE credits (
id INT8 PRIMARY KEY,
created_at TIMESTAMPTZ DEFAULT NOW(),
credits INT8 NOT NULL, -- Assuming credits is an integer field
user_id UUID REFERENCES auth.users(id)
);

[rossman22590]

[abhayjb]

Is your link from images modelId to models missing ?

[rossman22590]

Seems so u know how to fix this or do you have a schema I can use ?

[Marfuen]

Hey @rossman22590 , we just added a migration file for Supabase that can handle everything for you. If you want to run this on your Supabase SQL Dashboard, or run it locally while linking to it, it will handle your table creations / policies

https://github.com/leap-ai/headshots-starter/blob/main/supabase/migrations/20231010160942_remote_schema.sql

[rossman22590]

ok so you are actually amazing ty - it works now

[rossman22590]

ok now im stuck on the screen it says its training , but i got email saying its done

[Marfuen]

@rossman22590 The UI could be cached

[rossman22590]

i wish its been going for 6 hours and i went to anew machine

[rossman22590]

how can i fix it ?
i was charged, its pending for 2 days but on leap it has finsihed