Lançado Adianti Framework 7.6!
Clique aqui para saber mais
Conheça Características Quem usa Galeria Cursos Docs Fórum
Downloads
Posts Fique por dentro Sobre o Fórum Minha conta
Script para criar base permission no PostgreSQL Alguém usa o Framework com o PostgreSQL?? Pode me enviar o script da estrutura permission e log?? Obrigado!...
LA
Script para criar base permission no PostgreSQL  
Fechado
Luis Alberto 20/02/2016 (há 8 anos)
Alguém usa o Framework com o PostgreSQL??
Pode me enviar o script da estrutura permission e log??

Obrigado!
Pacotão Dominando o Adianti Framework 7
O material mais completo de treinamento do Framework.
Curso em vídeo aulas + Livro completo + Códigos fontes do projeto ERPHouse.
Conteúdo Atualizado! Versão 7.4


Dominando o Adianti 7 Quero me inscrever agora!

Comentários (5)

CS
Carlos Stclara       20/02/2016 (há 8 anos)

Retirado do Studio:

-- Creator: MySQL Workbench 5.2.37/ExportPostgres plugin 2009.12.02
-- Author: Administrador
-- Caption: New Model
-- Project: Name of the project
-- Changed: 2014-03-15 23:44
-- Created: 2014-03-15 23:37

-- Schema: mydb
BEGIN;
CREATE TABLE system_group(
id INTEGER PRIMARY KEY NOT NULL,
name VARCHAR(100)
);
CREATE TABLE system_program(
id INTEGER PRIMARY KEY NOT NULL,
name VARCHAR(100),
controller VARCHAR(100)
);
CREATE TABLE system_user(
id INTEGER PRIMARY KEY NOT NULL,
name VARCHAR(100),
login VARCHAR(100),
password VARCHAR(100),
email VARCHAR(100),
frontpage_id INTEGER NOT NULL,
CONSTRAINT fk_system_user_system_program1
FOREIGN KEY(frontpage_id)
REFERENCES system_program(id)
);
CREATE INDEX system_user_fk_system_user_system_program1 ON system_user(frontpage_id);
CREATE TABLE system_user_group(
id INTEGER PRIMARY KEY NOT NULL,
system_user_id INTEGER NOT NULL,
system_group_id INTEGER NOT NULL,
CONSTRAINT fk_system_user_has_system_group_system_user
FOREIGN KEY(system_user_id)
REFERENCES system_user(id),
CONSTRAINT fk_system_user_has_system_group_system_group1
FOREIGN KEY(system_group_id)
REFERENCES system_group(id)
);
CREATE INDEX system_user_group_fk_system_user_has_system_group_system_group1 ON system_user_group(system_group_id);
CREATE INDEX system_user_group_fk_system_user_has_system_group_system_user ON system_user_group(system_user_id);
CREATE TABLE system_group_program(
id INTEGER PRIMARY KEY NOT NULL,
system_group_id INTEGER NOT NULL,
system_program_id INTEGER NOT NULL,
CONSTRAINT fk_system_group_has_system_program_system_group1
FOREIGN KEY(system_group_id)
REFERENCES system_group(id),
CONSTRAINT fk_system_group_has_system_program_system_program1
FOREIGN KEY(system_program_id)
REFERENCES system_program(id)
);
CREATE INDEX system_group_program_fk_system_group_has_system_program1 ON system_group_program(system_program_id);
CREATE INDEX system_group_program_fk_system_group_has_system_group1 ON system_group_program(system_group_id);
CREATE TABLE system_user_program(
id INTEGER PRIMARY KEY NOT NULL,
system_user_id INTEGER NOT NULL,
system_program_id INTEGER NOT NULL,
CONSTRAINT fk_system_user_has_system_program_system_user1
FOREIGN KEY(system_user_id)
REFERENCES system_user(id),
CONSTRAINT fk_system_user_has_system_program_system_program1
FOREIGN KEY(system_program_id)
REFERENCES system_program(id)
);
CREATE INDEX system_user_program_fk_system_user_has_system_program_system_program1 ON system_user_program(system_program_id);
CREATE INDEX system_user_program_fk_system_user_has_system_program_system_user1 ON system_user_program(system_user_id);

--- data
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'System Group Form','SystemGroupForm');
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'System Group List','SystemGroupList');
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'System Program Form','SystemProgramForm');
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'System Program List','SystemProgramList');
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'System User Form','SystemUserForm');
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'System User List','SystemUserList');
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'Common Page','CommonPage');

INSERT INTO system_group VALUES(1,'Admin');
INSERT INTO system_group VALUES(2,'Public');

INSERT INTO system_user VALUES(1,'Administrator','admin','21232f297a57a5a743894a0e4a801fc3','admin@admin.net', 7);
INSERT INTO system_user VALUES(2,'User','user','ee11cbb19052e40b07aac0ca060c23ee','user@user.net', 7);

INSERT INTO system_user_group VALUES(1,1,1);
INSERT INTO system_user_group VALUES(2,2,2);
INSERT INTO system_user_group VALUES(3,1,2);

INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 1,
(select id from system_program where controller='SystemGroupForm'));
INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 1,
(select id from system_program where controller='SystemGroupList'));
INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 1,
(select id from system_program where controller='SystemProgramForm'));
INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 1,
(select id from system_program where controller='SystemProgramList'));
INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 1,
(select id from system_program where controller='SystemUserForm'));
INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 1,
(select id from system_program where controller='SystemUserList'));
INSERT INTO system_user_program VALUES((select coalesce(max(id),0)+1 from system_user_program), 2,
(select id from system_program where controller='CommonPage'));

--- new programs of 3.0.0
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'System PHP Info','SystemPHPInfoView');
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'System ChangeLog View','SystemChangeLogView');
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'Welcome View','WelcomeView');
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'System Sql Log','SystemSqlLogList');
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'System Profile View','SystemProfileView');
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'System Profile Form','SystemProfileForm');
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'System SQL Panel','SystemSQLPanel');
INSERT INTO system_program VALUES((select coalesce(max(id),0)+1 from system_program),'System Access Log','SystemAccessLogList');

INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 1,
(select id from system_program where controller='SystemPHPInfoView'));
INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 1,
(select id from system_program where controller='SystemChangeLogView'));
INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 1,
(select id from system_program where controller='SystemSqlLogList'));
INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 1,
(select id from system_program where controller='SystemSQLPanel'));
INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 1,
(select id from system_program where controller='SystemAccessLogList'));
INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 2,
(select id from system_program where controller='WelcomeView'));
INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 2,
(select id from system_program where controller='SystemProfileView'));
INSERT INTO system_group_program VALUES((select coalesce(max(id),0)+1 from system_group_program), 2,
(select id from system_program where controller='SystemProfileForm'));

UPDATE system_user set frontpage_id = (select id from system_program where controller='WelcomeView') where id=1;
COMMIT;
PD
Pablo Dall'Oglio       20/02/2016 (há 8 anos)

Luis,

Basta baixar o Template e descompartar. O arquivo é esse:
template/app/database/permission.pgsql.sql

Att,
LA
Luis Alberto - AUTOR DO POST       22/02/2016 (há 8 anos)

Carlos e Pablo, ja tinha visto. Consigo executar sem erro no pgAdmin, mas qdo vou tentar entrar no sistema aparece este erro:

https://drive.bitcasa.com/send/Vy08IrNsN1NHAiaRqp0vKko1TkknINGpO89bs6ltiTIy

Com o SQLite e MySQL entra normal.
LA
Luis Alberto - AUTOR DO POST       23/02/2016 (há 8 anos)

Resolvido.
Tive que alterar o proprietário das tabelas.
MC
Miuller De Faria Castro       10/10/2018 (há 5 anos)

Alguém teria o script dos bancos de log, comunication, permission em postgress do template 5.5?
Já baixei o template e não está vindo mais na pasta app/database.