convert_before_postgres.sql
399 Bytes
do $$
begin
if (exists (select 1 from information_schema.Columns where table_name = 'sungero_docregister_currentnumbers')
and not exists (select 1 from information_schema.Columns where table_name = 'sungero_docregister_currentnumbers' and column_name = 'day'))
then
alter table Sungero_DocRegister_CurrentNumbers
add Day integer not null default(0);
end if;
end $$