PostgreSQL

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

Last updated