text: -- Adding columns creation_user and creation_date to lang_messages
  -- Need to add not-null column so re-creating table
  create table lang_messages_tmp (    
      message_key        varchar(200),
      package_key        varchar(100),
      locale             varchar(30),
      message            text,
      upgrade_status     varchar(30)
  );
  
  insert into lang_messages_tmp select message_key, package_key, locale, message, upgrade_status from lang_messages;
  
  drop table lang_messages;
  
  create table lang_messages (    
      message_key        varchar(200)
                         constraint lang_messages_message_key_nn
                         not null,
      package_key        varchar(100)
                         constraint lang_messages_package_key_nn
                         not null,
      locale             varchar(30) 
                         constraint lang_messages_locale_fk
                         references ad_locales(locale)
                         constraint lang_messages_locale_nn
                         not null,
      message            text,
      upgrade_status     varchar(30)
                         constraint lang_messages_us_ck
                         check (upgrade_status in ('no_upgrade', 'added', 'deleted', 'updated')),
      creation_date      timestamptz 
                         default now() 
                         not null,
      creation_user      integer
                         constraint lang_messages_creation_u_fk
                         references users (user_id),
      constraint lang_messages_fk
      foreign key (message_key, package_key) 
      references lang_message_keys(message_key, package_key)
      on delete cascade,
      constraint lang_messages_pk 
      primary key (message_key, package_key, locale)
  );
  
  insert into lang_messages select message_key, package_key, locale, message, upgrade_status, now(), null from lang_messages_tmp;
  