urfatBro/app/core/auth/base.sql

insert into inf_auth_group (name) VALUES ('Admin');
insert into inf_auth_group (name) VALUES ('Vendedor');

insert into inf_auth_permission (name) VALUES ('admin');

insert into inf_auth_permission (name) VALUES ('user:search');
insert into inf_auth_permission (name) VALUES ('user:create');
insert into inf_auth_permission (name) VALUES ('user:update');
insert into inf_auth_permission (name) VALUES ('user:delete');
insert into inf_auth_permission (name) VALUES ('user:purge');

insert into inf_auth_permission (name) VALUES ('sells:make');
insert into inf_auth_permission (name) VALUES ('sells:lookSelf');

insert into inf_auth_permission_group (group_id, permission_id) VALUES (1, 2);
insert into inf_auth_permission_group (group_id, permission_id) VALUES (1, 3);
insert into inf_auth_permission_group (group_id, permission_id) VALUES (1, 4);
insert into inf_auth_permission_group (group_id, permission_id) VALUES (1, 5);
insert into inf_auth_permission_group (group_id, permission_id) VALUES (1, 6);
insert into inf_auth_permission_group (group_id, permission_id) VALUES (1, 7);

insert into inf_auth_user (username, name, email, password) VALUES ('v', 'admin', 'admin@admin.com', '21232f297a57a5a743894a0e4a801fc3');
insert into inf_auth_user (username, name, email, password) VALUES ('v1', 'vendedor', 'admin@admin.com', '0407e8c8285ab85509ac2884025dcf42');

insert into inf_auth_group_user (user_id, group_id) VALUES (1, 1);
insert into inf_auth_group_user (user_id, group_id) VALUES (1, 2);

insert into inf_auth_permission_user (user_id, permission_id, action) VALUES (3, 5, 'a');
insert into inf_auth_permission_user (user_id, permission_id, action) VALUES (3, 6, 'a');

insert into inf_auth_permission_user (user_id, permission_id, action) VALUES (1, 1, 'd');

drop table inf_auth_group;
drop table inf_auth_permission;
drop table inf_auth_permission_group;
drop table inf_auth_user;