dhkatzandClaude Opus 5.5
6ba4d83317
CI / test (push) Successful in 6m38s
The realtime connection now carries the IMVU chats a client is in: the hub tells each proxy in a chat which other T5DE users are there and what community products they wear (adult products only to adult accounts), on joining and on every change. Rooms T5DE users enter are looked up on IMVU; those that are public, listed and whose owner turned on "List my public rooms" appear on the new Rooms page, with the T5DE users in them who show they're online. AP rooms are shown to adults only. Co-Authored-By: Claude Opus 5.5 <[email protected]>
19 lines
785 B
SQL
19 lines
785 B
SQL
CREATE TABLE "room" (
|
|
"instance_id" text PRIMARY KEY NOT NULL,
|
|
"owner_imvu_id" bigint NOT NULL,
|
|
"name" text NOT NULL,
|
|
"description" text DEFAULT '' NOT NULL,
|
|
"image_url" text DEFAULT '' NOT NULL,
|
|
"privacy" text NOT NULL,
|
|
"type" text NOT NULL,
|
|
"content_rating" text DEFAULT '' NOT NULL,
|
|
"access_pass" boolean DEFAULT false NOT NULL,
|
|
"occupancy" integer DEFAULT 0 NOT NULL,
|
|
"capacity" integer DEFAULT 0 NOT NULL,
|
|
"expired" boolean DEFAULT false NOT NULL,
|
|
"checked_at" timestamp with time zone DEFAULT now() NOT NULL,
|
|
"seen_at" timestamp with time zone DEFAULT now() NOT NULL
|
|
);
|
|
--> statement-breakpoint
|
|
ALTER TABLE "imvu_link" ADD COLUMN "list_rooms" boolean DEFAULT false NOT NULL;--> statement-breakpoint
|
|
CREATE INDEX "room_owner" ON "room" USING btree ("owner_imvu_id"); |