{"table_name":"woocommerce_npp_transactions","full_table_name":"wp_woocommerce_npp_transactions","description":"Stores woocommerce npp transactions data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_woocommerce_npp_transactions ( ID BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT UNSIGNED NOT NULL, oid VARCHAR( 64 ) NOT null, trantype VARCHAR( 20 ) NOT null, protocol VARCHAR( 20 ) NOT null, amount DECIMAL( 12, 2 ) NOT null, currency VARCHAR( 3 ) NOT null, Response VARCHAR( 10 ) default null, ProcReturnCode VARCHAR( 2 ) default null, mdStatus VARCHAR( 3 ) default null, ErrMsg VARCHAR( 255 ) default null, AuthCode VARCHAR( 32 ) default null, TransId VARCHAR( 64 ) default null, TRANID VARCHAR( 64 ) default null, clientIp VARCHAR( 15 ) default null, payResults_dsId VARCHAR( 64 ) default null, signature VARCHAR( 1024 ) default null, description VARCHAR( 255 ) default null, orgHash VARCHAR( 512 ) default null, HASHPARAMS VARCHAR( 512 ) default null, HASH VARCHAR( 512 ) default null, HASHPARAMSVAL VARCHAR( 512 ) default null, orgRnd VARCHAR( 64 ) default null, comments VARCHAR( 255 ) default null, instalment VARCHAR( 3 ) null, storetype VARCHAR( 16 ) default null, lang VARCHAR( 16 ) default null, xid VARCHAR( 255 ) default null, HostRefNum VARCHAR( 255 ) default null, ReturnOid VARCHAR( 64 ) default null, MaskedPan VARCHAR( 20 ) default null, rnd VARCHAR( 20 ) default null, merchantID VARCHAR( 255 ) default null, hc_active SMALLINT( 1 ) default null, txstatus VARCHAR( 255 ) default null, iReqCode VARCHAR( 255 ) default null, iReqDetail VARCHAR( 255 ) default null, vendorCode VARCHAR( 255 ) default null, PAResSyntaxOK VARCHAR( 255 ) default null, PAResVerified VARCHAR( 255 ) default null, veresEnrolledStatus VARCHAR( 255 ) default null, eci VARCHAR( 255 ) default null, cavv VARCHAR( 255 ) default null, cavvAlgorthm VARCHAR( 255 ) default null, md VARCHAR( 255 ) default null, Version VARCHAR( 255 ) default null, sID VARCHAR( 255 ) default null, mdErrorMsg text default null, clientid VARCHAR( 255 ) default null, EXTRA_TRXDATE VARCHAR( 255 ) default null, EXTRA_UCAFINDICATOR VARCHAR( 255 ) default null, ACQBIN VARCHAR( 255 ) default null, acqStan VARCHAR( 255 ) default null, cavvAlgorithm VARCHAR( 255 ) default null, digest VARCHAR( 255 ) default null, dsId VARCHAR( 255 ) default null, isHPPCall VARCHAR( 255 ) default null, Ecom_Payment_Card_ExpDate_Month VARCHAR( 255 ) default null, Ecom_Payment_Card_ExpDate_Year VARCHAR( 255 ) default null, EXTRA_CARDBRAND VARCHAR( 255 ) default null, EXTRA_CARDISSUER VARCHAR( 255 ) default null, shopurl VARCHAR( 255 ) default null, callbackCall VARCHAR( 20 ) default null, encoding VARCHAR( 20 ) default null, refreshtime VARCHAR( 255 ) default null, SettleId VARCHAR( 255 ) default null, created_at timestamp NOT null default CURRENT_TIMESTAMP, updated_at timestamp NOT null default CURRENT_TIMESTAMP, _charset_ VARCHAR( 10 ) default null, PRIMARY KEY (ID), KEY trantype (trantype), KEY currency (currency), KEY Response (Response), KEY ProcReturnCode (ProcReturnCode), KEY mdStatus (mdStatus), KEY AuthCode (AuthCode) ) {$collate};\"; return $tables; } /** * Adds default plugin options * * @since 2.0.0 */ public static function create_options() { } /** * Update wcnpg version to current. */ public static function update_wcnpg_version() { update_option( 'wcnpg_version', WCNPG()->version );","columns":[{"name":"ID","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"order_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"oid","type":"VARCHAR( 64 )","nullable":false,"primary_key":false},{"name":"trantype","type":"VARCHAR( 20 )","nullable":false,"primary_key":false},{"name":"protocol","type":"VARCHAR( 20 )","nullable":false,"primary_key":false},{"name":"amount","type":"DECIMAL( 12, 2 )","nullable":false,"primary_key":false},{"name":"currency","type":"VARCHAR( 3 )","nullable":false,"primary_key":false},{"name":"Response","type":"VARCHAR( 10 )","nullable":true,"primary_key":false},{"name":"ProcReturnCode","type":"VARCHAR( 2 )","nullable":true,"primary_key":false},{"name":"mdStatus","type":"VARCHAR( 3 )","nullable":true,"primary_key":false},{"name":"ErrMsg","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"AuthCode","type":"VARCHAR( 32 )","nullable":true,"primary_key":false},{"name":"TransId","type":"VARCHAR( 64 )","nullable":true,"primary_key":false},{"name":"TRANID","type":"VARCHAR( 64 )","nullable":true,"primary_key":false},{"name":"clientIp","type":"VARCHAR( 15 )","nullable":true,"primary_key":false},{"name":"payResults_dsId","type":"VARCHAR( 64 )","nullable":true,"primary_key":false},{"name":"signature","type":"VARCHAR( 1024 )","nullable":true,"primary_key":false},{"name":"description","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"orgHash","type":"VARCHAR( 512 )","nullable":true,"primary_key":false},{"name":"HASHPARAMS","type":"VARCHAR( 512 )","nullable":true,"primary_key":false},{"name":"HASH","type":"VARCHAR( 512 )","nullable":true,"primary_key":false},{"name":"HASHPARAMSVAL","type":"VARCHAR( 512 )","nullable":true,"primary_key":false},{"name":"orgRnd","type":"VARCHAR( 64 )","nullable":true,"primary_key":false},{"name":"comments","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"instalment","type":"VARCHAR( 3 )","nullable":true,"primary_key":false},{"name":"storetype","type":"VARCHAR( 16 )","nullable":true,"primary_key":false},{"name":"lang","type":"VARCHAR( 16 )","nullable":true,"primary_key":false},{"name":"xid","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"HostRefNum","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"ReturnOid","type":"VARCHAR( 64 )","nullable":true,"primary_key":false},{"name":"MaskedPan","type":"VARCHAR( 20 )","nullable":true,"primary_key":false},{"name":"rnd","type":"VARCHAR( 20 )","nullable":true,"primary_key":false},{"name":"merchantID","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"hc_active","type":"SMALLINT( 1 )","nullable":true,"primary_key":false},{"name":"txstatus","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"iReqCode","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"iReqDetail","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"vendorCode","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"PAResSyntaxOK","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"PAResVerified","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"veresEnrolledStatus","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"eci","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"cavv","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"cavvAlgorthm","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"md","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"Version","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"sID","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"mdErrorMsg","type":"text","nullable":true,"primary_key":false},{"name":"clientid","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"EXTRA_TRXDATE","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"EXTRA_UCAFINDICATOR","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"ACQBIN","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"acqStan","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"cavvAlgorithm","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"digest","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"dsId","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"isHPPCall","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"Ecom_Payment_Card_ExpDate_Month","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"Ecom_Payment_Card_ExpDate_Year","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"EXTRA_CARDBRAND","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"EXTRA_CARDISSUER","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"shopurl","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"callbackCall","type":"VARCHAR( 20 )","nullable":true,"primary_key":false},{"name":"encoding","type":"VARCHAR( 20 )","nullable":true,"primary_key":false},{"name":"refreshtime","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"SettleId","type":"VARCHAR( 255 )","nullable":true,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false},{"name":"updated_at","type":"timestamp","nullable":false,"primary_key":false},{"name":"_charset_","type":"VARCHAR( 10 )","nullable":true,"primary_key":false}],"plugin":{"slug":"wc-serbian-nestpay","name":"Payment gateway NestPay for WooCommerce","active_installs":200,"version":"1.2.2","wp_org_url":"https://wordpress.org/plugins/wc-serbian-nestpay/"}}