mirror of
https://github.com/willchen96/mike.git
synced 2026-07-26 23:51:08 +02:00
20 lines
475 B
MySQL
20 lines
475 B
MySQL
|
do $$
|
||
|
|
begin
|
||
|
|
if exists (
|
||
|
|
select 1
|
||
|
|
from information_schema.columns
|
||
|
|
where table_schema = 'public'
|
||
|
|
and table_name = 'chat_messages'
|
||
|
|
and column_name = 'annotations'
|
||
|
|
) and not exists (
|
||
|
|
select 1
|
||
|
|
from information_schema.columns
|
||
|
|
where table_schema = 'public'
|
||
|
|
and table_name = 'chat_messages'
|
||
|
|
and column_name = 'citations'
|
||
|
|
) then
|
||
|
|
alter table public.chat_messages
|
||
|
|
rename column annotations to citations;
|
||
|
|
end if;
|
||
|
|
end $$;
|