Hullo people,
We installed ShotGrid Addon to do some testing in AYON, but I realized that this added the ShotGrid specific attributes to AYON postgres DB’s public.attributes table.
Is there a way to safely remove these attributes? This is in the case where we don’t need to use ShotGrid after the test?
Is there a documentation with regards to AYON database schema?
Regards,
Tu
As far as I know, you can manage them from Attributes
tab:
Where you can edit and delete them:
1 Like
Hi,
Not sure if it’s what you need, but here is what I found :
----------------
-- AUX TABLES --
----------------
CREATE TABLE thumbnails(
id UUID NOT NULL PRIMARY KEY,
mime VARCHAR NOT NULL,
data BYTEA NOT NULL,
meta JSONB NOT NULL DEFAULT '{}'::JSONB,
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);
ALTER TABLE thumbnails ALTER COLUMN data SET STORAGE EXTERNAL;
CREATE TABLE task_types(
name VARCHAR NOT NULL PRIMARY KEY,
position INTEGER NOT NULL DEFAULT 0,
data JSONB NOT NULL DEFAULT '{}'::JSONB
);
This file has been truncated. show original
CREATE EXTENSION IF NOT EXISTS "pg_trgm";
ALTER EXTENSION pg_trgm SET SCHEMA public;
CREATE TABLE IF NOT EXISTS public.config(
key VARCHAR NOT NULL PRIMARY KEY,
value JSONB NOT NULL DEFAULT '{}'::JSONB
);
-- Server updates
CREATE TABLE IF NOT EXISTS public.server_updates(
id SERIAL PRIMARY KEY,
version VARCHAR NOT NULL,
data JSONB NOT NULL DEFAULT '{}'::JSONB,
created_at TIMESTAMPTZ DEFAULT NOW()
);
CREATE UNIQUE INDEX IF NOT EXISTS server_updates_version_idx ON public.server_updates(version);
-- Projects
This file has been truncated. show original
1 Like
Thanks for the responses guys.