PostgreSQL report server

Репорт сервер, аналог штатного репорт сервера но работающий с базой данных PostgreSQL.
Данная база имеет рая преимуществ перед базой MySQL, в которую происходит репликация данных репорт сервера от компании metaquotes.
PostgreSQL vs MySQL

По мимо использования PostgreSQL, репрот сервера экспортирует в базу дополнительные данные такие как: набор торговых инструментов со всеми настройками, набор групп счетов, со всеми настройками, в том числе доступные для торговли инструменты.

CREATE TABLE IF NOT EXISTS MT4_SYMBOLS(
  "SYMBOL" char(12) NOT NULL PRIMARY KEY, 
  "description"          char(64),
  "source"               char(12),
  "currency"             char(8),
  "gtype"                integer,
  "trade"                integer,
  "background_color"     BIGINT,
  "count"                integer,
  "count_original"       integer,
  "realtime"             integer,
  "starting"              TIMESTAMP,
  "expiration"            TIMESTAMP,
  "profit_mode"           integer,
  "filter"                integer,
  "filter_counter"        integer,
  "filter_limit"          NUMERIC,
  "filter_reserved"       NUMERIC,
  "logging"               integer,
  "spread"                integer,
  "spread_balance"        integer,
  "exemode"               integer,
  "swap_enable"            integer, 
  "swap_type"             integer,
  "swap_long"              NUMERIC,
  "swap_short"             NUMERIC,
  "swap_rollover3days"    integer,
  "contract_size"         NUMERIC,
  "tick_value"            NUMERIC,
  "tick_size"             NUMERIC,
  "stops_level"           integer,
  "gtc_pendings"          integer,
  "margin_mode"           integer,
  "margin_initial"         NUMERIC,
  "margin_maintenance"     NUMERIC,
  "margin_hedged"          NUMERIC,
  "margin_divider"         NUMERIC,
  "point"                 NUMERIC,
  "multiply"              NUMERIC,
  "bid_tickvalue"         NUMERIC,
  "ask_tickvalue"         NUMERIC,
  "long_only"             integer,
  "instant_max_volume"    integer,
  "margin_currency"       char(12), 
  "freeze_level"          integer)

  CREATE TABLE IF NOT EXISTS MT4_PRICES(
    "SYMBOL" char(12) NOT NULL PRIMARY KEY, 
    "DIGITS" INTEGER,                       
    "STYPE"  INTEGER,                       
    "POINT"  INTEGER,                       
    "SPREAD" INTEGER,                       
    "SPREAD_BALANCE"  INTEGER,              
    "DIRECTION" INTEGER,                    
    "UPDATEFLAG"  INTEGER,                  
    "TIME" TIMESTAMP,                       
    "BID" NUMERIC,                          
    "ASK" NUMERIC,                          
    "HIGH" NUMERIC,                         
    "LOW" NUMERIC) 

CREATE TABLE IF NOT EXISTS MT4_TRADES (
    "TICKET" INTEGER NOT NULL PRIMARY KEY,
    "LOGIN" INTEGER NOT NULL,
    "SYMBOL" VARCHAR NOT NULL,
    "DIGITS" INTEGER,
    "CMD" INTEGER,
    "VOLUME" INTEGER,
    "OPEN_TIME" TIMESTAMP,
    "OPEN_PRICE" NUMERIC,
    "SL" NUMERIC,
    "TP" NUMERIC,
    "CLOSE_TIME" TIMESTAMP,
    "EXPIRATION" TIMESTAMP,
    "CONV_RATES1"   NUMERIC,
    "CONV_RATES2"   NUMERIC,
    "COMMISSION"   NUMERIC,
    "COMMISSION_AGENT"  NUMERIC,
    "STORAGE" NUMERIC,
    "CLOSE_PRICE" NUMERIC,
    "PROFIT" NUMERIC,
    "MAGIC" INTEGER,
    "COMMENT" CHAR(32),
    "INTERNAL_ID" INTEGER,
    "ACTIVATION" INTEGER,
    "MARGIN_RATE" NUMERIC)

CREATE TABLE IF NOT EXISTS MT4_USERS (
  "LOGIN" integer NOT NULL PRIMARY KEY,
  "GROUP" char(16) NOT NULL,
  "ENABLE" BOOLEAN,
  "PASSWORD_PHONE" char(32) ,
  "NAME" char(128) NOT NULL,
  "COUNTRY" char(32) ,
  "CITY" char(32) ,
  "STATE" char(32) ,
  "ZIPCODE" char(16) ,
  "ADDRESS" char(128) ,
  "PHONE" char(32) ,
  "EMAIL" char(48) ,
  "COMMENT" char(64),
  "ID" char(32),
  "STATUS" char(16), 
  "REGDATE" timestamp NOT NULL,
  "LASTDATE" timestamp NOT NULL,
  "LEVERAGE" integer NOT NULL,
  "AGENT_ACCOUNT" integer NOT NULL,
  "TIMESTAMP" timestamp NOT NULL,
  "BALANCE" NUMERIC NOT NULL,
  "PREVMONTHBALANCE" NUMERIC NOT NULL,
  "PREVBALANCE" NUMERIC NOT NULL,
  "CREDIT" NUMERIC NOT NULL,
  "INTERESTRATE" NUMERIC NOT NULL,
  "TAXES" NUMERIC NOT NULL,
  "SEND_REPORTS" BOOLEAN NOT NULL,
  "USER_COLOR" BIGINT NOT NULL,
  "EQUITY" NUMERIC NOT NULL DEFAULT 0,
  "MARGIN" NUMERIC NOT NULL DEFAULT 0,
  "MARGIN_LEVEL" NUMERIC NOT NULL DEFAULT 0,
  "MARGIN_FREE" NUMERIC NOT NULL DEFAULT 0,
  "MODIFY_TIME" timestamp NOT NULL,
  "MQID" integer NOT NULL DEFAULT 0,
  "CURRENCY" char(16) NOT NULL)