May 15, 2025 · May 15, 2025
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/foreign_key_constraint.go b/coderd/database/foreign_key_constraint.go
diff --git a/coderd/database/migrations/000319_chat.down.sql b/coderd/database/migrations/000319_chat.down.sql
 DROP TABLE IF EXISTS chat_messages;

 DROP TABLE IF EXISTS chats;
diff --git a/coderd/database/migrations/000319_chat.up.sql b/coderd/database/migrations/000319_chat.up.sql
 CREATE TABLE IF NOT EXISTS chats (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    owner_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    title TEXT NOT NULL
 );

 CREATE TABLE IF NOT EXISTS chat_messages (
    -- BIGSERIAL is auto-incrementing so we know the exact order of messages.
    id BIGSERIAL PRIMARY KEY,
    chat_id UUID NOT NULL REFERENCES chats(id) ON DELETE CASCADE,
    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    model TEXT NOT NULL,
    provider TEXT NOT NULL,
    content JSONB NOT NULL
 );
diff --git a/coderd/database/migrations/testdata/fixtures/000319_chat.up.sql b/coderd/database/migrations/testdata/fixtures/000319_chat.up.sql
 INSERT INTO chats (id, owner_id, created_at, updated_at, title) VALUES
 ('00000000-0000-0000-0000-000000000001', '0ed9befc-4911-4ccf-a8e2-559bf72daa94', '2023-10-01 12:00:00+00', '2023-10-01 12:00:00+00', 'Test Chat 1');

 INSERT INTO chat_messages (id, chat_id, created_at, model, provider, content) VALUES
 (1, '00000000-0000-0000-0000-000000000001', '2023-10-01 12:00:00+00', 'annie-oakley', 'cowboy-coder', '{"role":"user","content":"Hello"}'),
 (2, '00000000-0000-0000-0000-000000000001', '2023-10-01 12:01:00+00', 'annie-oakley', 'cowboy-coder', '{"role":"assistant","content":"Howdy pardner! What can I do ya for?"}');
diff --git a/coderd/database/models.go b/coderd/database/models.go
diff --git a/coderd/database/unique_constraint.go b/coderd/database/unique_constraint.go
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,3 @@
		DROP TABLE IF EXISTS chat_messages;

		DROP TABLE IF EXISTS chats;
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,17 @@
		CREATE TABLE IF NOT EXISTS chats (
		id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
		owner_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
		created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
		updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
		title TEXT NOT NULL
		);

		CREATE TABLE IF NOT EXISTS chat_messages (
		-- BIGSERIAL is auto-incrementing so we know the exact order of messages.
		id BIGSERIAL PRIMARY KEY,
		chat_id UUID NOT NULL REFERENCES chats(id) ON DELETE CASCADE,
		created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
		model TEXT NOT NULL,
		provider TEXT NOT NULL,
		content JSONB NOT NULL
		);
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,6 @@
		INSERT INTO chats (id, owner_id, created_at, updated_at, title) VALUES
		('00000000-0000-0000-0000-000000000001', '0ed9befc-4911-4ccf-a8e2-559bf72daa94', '2023-10-01 12:00:00+00', '2023-10-01 12:00:00+00', 'Test Chat 1');

		INSERT INTO chat_messages (id, chat_id, created_at, model, provider, content) VALUES
		(1, '00000000-0000-0000-0000-000000000001', '2023-10-01 12:00:00+00', 'annie-oakley', 'cowboy-coder', '{"role":"user","content":"Hello"}'),
		(2, '00000000-0000-0000-0000-000000000001', '2023-10-01 12:01:00+00', 'annie-oakley', 'cowboy-coder', '{"role":"assistant","content":"Howdy pardner! What can I do ya for?"}');