--It's only test. Many features are not implemented yet.

DROP TABLE "informix".payments;

CREATE TABLE "informix".payments(
   id INTEGER NOT NULL,
   indexvz VARCHAR(6),
   operatorfio VARCHAR(50),
   oper_wnd_number INTEGER,
   payment_code VARCHAR(20),
   payment_sum FLOAT,
   comission_sum FLOAT,
   bonus_sum FLOAT,
   status_id INTEGER default 21107 NOT NULL,
   receiverid INTEGER NOT NULL,
   receiveredrpou VARCHAR(10),
   receivername VARCHAR(50),
   receiveracc VARCHAR(20),
   receivermfo VARCHAR(10),
   receiverbnkname VARCHAR(50),
   senderacc VARCHAR(100),
   senderfio VARCHAR(100),
   senderadress VARCHAR(100),
   senderpass VARCHAR(20),
   sendertel VARCHAR(255),
   contractnumber VARCHAR(100),
   date_ DATE,
   period INTEGER default 0 NOT NULL,
   ks INTEGER default 0,
   previous_ DECIMAL(16),
   current_ DECIMAL(16),
   date_start DATE,
   date_end DATE,
   jek VARCHAR(50),
   service_name VARCHAR(50),
   barcode VARCHAR(100),
   operatorid INTEGER,
   namevz VARCHAR(50),
   sessionid VARCHAR(50),
   nomenklature VARCHAR(20),
   paymenttype INTEGER,
   export_date DATE,
   export_login VARCHAR(20),
   exp_date_to_file DATE,
   exp_to_file_login VARCHAR(20),
   date_service DATETIME YEAR to SECOND,
   offlineimportdate DATE,
   receipt VARCHAR(30),
   plat_num INTEGER default 0 NOT NULL,
   sendercity VARCHAR(255),
   senderbuilding VARCHAR(255),
   senderkorpus VARCHAR(255),
   senderapartment VARCHAR(255),
   resend_sum FLOAT,
   resend_type INTEGER,
   payment_type "informix".boolean default f NOT NULL,
   debt FLOAT,
   addsum FLOAT,
   edit_date DATETIME YEAR to SECOND,
   edit_login NVARCHAR(100),
   additionally NVARCHAR(50),
   cpzimport "informix".boolean default f,
   mdaddvalueid INTEGER,
   senderid INTEGER,
   identifier NVARCHAR(30),
   receivergroup VARCHAR(10),
   fileid INTEGER default 0,
   service_purpose NVARCHAR(255) default '',
   subsidies FLOAT,
   plat_date DATE,
   counter_code VARCHAR(40),
   service_code VARCHAR(10),
   sendercityid DECIMAL(20,0),
   group_sign INTEGER,
   plat_edrpou VARCHAR(12),
   plat_mfo VARCHAR(12),
   plat_acc VARCHAR(20))
EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW;

CREATE INDEX "informix".idx_payments_z1 ON "informix".payments(period, status_id, receiverid);

CREATE INDEX "informix".payments_receiverid ON "informix".payments(receiverid);

CREATE INDEX "informix".payments_receivername ON "informix".payments(receivername);

CREATE INDEX "informix".payments ON "informix".payments(sessionid, indexvz);

CREATE INDEX "informix".payments_date_service_ind ON "informix".payments(date_service);

CREATE INDEX "informix".payments_indexvz ON "informix".payments(indexvz);

CREATE INDEX "informix".payments_iscanceled ON "informix".payments(status_id);

CREATE INDEX "informix".payments_period ON "informix".payments(period, senderpass);

CREATE INDEX "informix".payments_plat_num ON "informix".payments(plat_num, receiverid, status_id, date_service, indexvz);

ALTER TABLE "informix".payments ADD CONSTRAINT PRIMARY KEY 
   (id, indexvz, sessionid) CONSTRAINT "informix".paymentspk;

GRANT select, update, insert, delete, index ON payments TO public AS informix;

SELECT COUNT(*) AS count_column FROM payments  WHERE receiverid = 1073858
    AND status_id = 21107 AND period = 0 AND export_date IS NULL AND
    payments.indexvz in       (       select i.indexvalue       from
    user_to_index  uti       inner join  indexes i  on i.id = uti.index_id
      and   user_pkid = 'cd537660-de2b-4c2c-bc29-a9e278e8729e')