ALTERTABLE chat_messages

DROP COLUMN IF EXISTS created_at;

DROPTABLE IF EXISTS chat_messages;

ALTERTABLE chat_messages

ADD COLUMN IF NOT EXISTS message_typeTEXTNOT NULL DEFAULT'',-- Provide a default or handle NULLs

ADD COLUMN IF NOT EXISTS message_indexSERIAL;

ALTERTABLE chat_messages

ALTER COLUMN content TYPETEXT USING content::TEXT;

ALTERTABLE chat_messages DROPCONSTRAINT IF EXISTS chat_messages_pkey;

DROPSEQUENCE IF EXISTS chat_messages_id_seq;

ALTERTABLE chat_messages ALTER COLUMN id DROP DEFAULT;

ALTERTABLE chat_messages ALTER COLUMN id TYPE UUID USING (gen_random_uuid());-- Attempt conversion, may fail

ALTERTABLE chat_messages ALTER COLUMN idSET DEFAULT gen_random_uuid();

ALTERTABLE chat_messages ADDPRIMARY KEY (id);

ALTERTABLE chat_conversations

DROP COLUMN IF EXISTS deleted_at;

ALTERTABLE chat_conversations DROPCONSTRAINT IF EXISTS chat_conversations_user_id_fkey;

ALTERTABLE chat_conversations ADDCONSTRAINT chat_conversations_user_id_fkeyFOREIGN KEY (user_id)REFERENCES users(id);

ALTERTABLE chat_conversations ALTER COLUMN created_atSET DEFAULTCURRENT_TIMESTAMP;

ALTERTABLE chat_conversations ALTER COLUMN updated_atSET DEFAULTCURRENT_TIMESTAMP;

ALTERTABLE chat_messages DROPCONSTRAINT IF EXISTS chat_messages_conversation_id_fkey;

ALTERTABLE chat_messages ADDCONSTRAINT chat_messages_conversation_id_fkeyFOREIGN KEY (conversation_id)REFERENCES chat_conversations(id);

DROPTABLE IF EXISTS chats;

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?"}');