CREATE TABLE IF NOT EXISTS channel_categories ( id uuid PRIMARY KEY DEFAULT gen_random_uuid(), community_id uuid NOT NULL REFERENCES communities (id) ON DELETE CASCADE, name text NOT NULL, position int NOT NULL DEFAULT 0 );