To configure ONEWEB database you must follow the below steps.
Step1: Create Schema & role authorization. Use following details to create database schema on postgresql server. Create schema for ONEWEB Application by using SQL script. Execute: create_schema.sql Create role authorization for ONEWEB Application by using SQL script. Execute: create_role.sql Alter password to user role by using SQL script. Execute: alter_password.sql
Step2: Restricting database user permissions. Alter administrator's privilege and search_path on schema for each user. Alter privilege for ONEWEB Application by using SQL script. Execute: alter_priviledge.sql
Step3: Create table and initial data.
Schema
Create table, initial data
eaf_master
create table structure and insert initial data.
ONEWEB.AR.4.0.19.12.base.postgres.sql
iam2
create table structure and insert initial data
ONEWEB.IAM.4.0.19.12.base.postgres.sql
mfd
create table structure and insert initial data
ONEWEB.MFD.4.0.0.19.12.base.postgres.sql
pd
create table structure and insert initial data
ONEWEB.PD.4.0.0.19_12.base.postgres.sql
bpm
create table structure and insert initial data
ONEWEB.PR.4.0.0.19.12.base.postgres.sql
asp
create table structure and insert initial data
ONEWEB.ASP.4.0.19.12.base.postgres.sql
dpc2
Table structure created automatically when install app
page
create table structure and insert initial data
ONEWEB.PGD.4.0.19.12.base.postgres.sql
dashboard
create table structure and insert initial data
ONEWEB.DSHB.4.0.19.12.base.postgres.sql
Reference: https://www.postgresql.org/docs/9.3/tutorial-install.html