CREATE TABLE log_deduct (
    notrans character varying(50) NOT NULL,
    respon_reader character(10),
    rep_content character varying(2500),
    waktu timestamp without time zone
);


ALTER TABLE public.log_deduct OWNER TO postgres;

CREATE TABLE settlement_dt (
    no_trans character varying(5000),
    rep_content character varying(5000),
    nominal integer
);


ALTER TABLE public.settlement_dt OWNER TO postgres;

CREATE TABLE settlement_tr (
    notrans character varying(5000),
    nama_file character varying(1000),
    "TID" character varying(15),
    status_buat_settlement integer DEFAULT 0,
    kirim_file_ftp integer DEFAULT 0,
    status_hit_smt integer DEFAULT 0,
    qty_trans integer,
    biaya integer,
    created_by character varying(100),
    tgl_pembuatan timestamp without time zone,
    trx_mdd integer,
    trx_mmandiri integer,
    trx_bri integer,
    trx_bni integer,
    trx_bri_java integer,
    trx_bca integer,
    trx_dki integer,
    amt_mdd integer,
    amt_mmandiri integer,
    amt_bri integer,
    amt_bni integer,
    amt_bri_java integer,
    amt_bca integer,
    amt_dki integer,
    amt_mandiri integer,
    trx_mandiri integer,
    tgl_transaksi timestamp without time zone,
    tgl_kirim timestamp without time zone,
    last_send timestamp without time zone
);


ALTER TABLE public.settlement_tr OWNER TO postgres;
ALTER TABLE config_pos_hardware ADD COLUMN bank_reader_avail integer;
ALTER TABLE config_pos_hardware ALTER COLUMN bank_reader_avail SET DEFAULT 0;
ALTER TABLE config_pos_hardware ADD COLUMN bank_reader_comm character varying(128);
ALTER TABLE config_pos_hardware ADD COLUMN mandiri_sam_pin character varying(32);
ALTER TABLE config_pos_hardware ADD COLUMN mandiri_reader_tid character varying(16);
ALTER TABLE config_pos_hardware ADD COLUMN mandiri_reader_mid character varying(16);
ALTER TABLE config_pos_hardware ADD COLUMN bca_reader_tid character varying(16);
ALTER TABLE config_pos_hardware ADD COLUMN bca_reader_mid character varying(16);
ALTER TABLE config_pos_hardware ADD COLUMN bca_batch integer;
ALTER TABLE transaksi_parkir ADD COLUMN rep_has_settle integer;
ALTER TABLE transaksi_parkir ALTER COLUMN rep_has_settle SET DEFAULT 0;
ALTER TABLE transaksi_parkir ADD COLUMN rep_bank character varying(3);
ALTER TABLE config_pos_hardware ADD COLUMN bank_reader_tid character varying(16);
ALTER TABLE config_pos_hardware ADD COLUMN bank_reader_mid character varying(16);
ALTER TABLE config_pos_hardware ADD COLUMN bank_reader_key character varying(32);
ALTER TABLE config_pos_hardware ADD COLUMN bni_tid character varying(16);
ALTER TABLE config_pos_hardware ADD COLUMN bni_mid character varying(16);
ALTER TABLE softseting ADD COLUMN izin timestamp without time zone;
ALTER TABLE config_pos_hardware ADD COLUMN lpr_avail integer;
ALTER TABLE config_pos_hardware ADD COLUMN lpr_ip character varying(16);
ALTER TABLE transaksi_parkir ADD COLUMN no_kartu character varying(20);
ALTER TABLE transaksi_parkir ADD COLUMN card_bank character varying(20);
ALTER TABLE transaksi_parkir ADD COLUMN tid_bank character varying(20);
ALTER TABLE transaksi_parkir ADD COLUMN saldo integer;
ALTER TABLE transaksi_parkir ADD COLUMN balance integer;
ALTER TABLE transaksi_parkir ADD COLUMN refference_id_settlement character varying(20);
ALTER TABLE transaksi_parkir ADD COLUMN rep_content character varying(2500);
ALTER TABLE transaksi_parkir ADD COLUMN mid_bank character varying(20);
