Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly
Appearance settings

Expand file tree

/

springJavaCode.sql

Copy path
More file actions
More file actions

Latest commit

 

History

History
History
20 lines (15 loc) · 846 Bytes
/

springJavaCode.sql

Copy path

File metadata and controls

20 lines (15 loc) · 846 Bytes
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
/*TRUNCATE TABLE permissao_tela_dpto, tela, usuario, departamento;*/
/* Departamentos */
insert into departamento (id_departamento, nome)
select 1, 'Gerência' from departamento
where (select count(*) from departamento where nome = 'Gerência') = 0;
insert into departamento (id_departamento, nome)
select 1, 'TI' from departamento
where (select count(*) from departamento where nome = 'TI') = 0;
/* Usuários */
insert into usuario (id_usuario, login, nome, senha, id_depto)
select 1,'admin','Administrador', '307446D9DEB709CC9742429AE33B40C9', 2 from usuario
where (select count(*) from usuario where login = 'admin') = 0;
insert into usuario (id_usuario, login, nome, senha, id_depto)
select 2,'gerente','Gerente', '307446D9DEB709CC9742429AE33B40C9', 1 from usuario
where (select count(*) from usuario where login = 'gerente') = 0;
Morty Proxy This is a proxified and sanitized view of the page, visit original site.