• Home
• com.github.tiagompalte
• tcc-porta-servico
• 1.0.14
• source code
• V05__adicionado_fk_estabelecimento_tabela_usuario.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.migration.V05__adicionado_fk_estabelecimento_tabela_usuario.sql Maven / Gradle / Ivy

alter table usuario add column codigo_estabelecimento BIGINT(20);
alter table usuario add constraint FK_estabelecimento foreign key (codigo_estabelecimento) references estabelecimento(codigo);

update usuario u set codigo_estabelecimento = (select codigo from estabelecimento where codigo_responsavel = u.codigo);