{"table_name":"bmp_users","full_table_name":"wp_bmp_users","description":"Stores bmp users data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_bmp_users ( id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY , user_id BIGINT(20) NOT NULL COMMENT 'foreign key of the wp_users table', user_name VARCHAR(60) NOT NULL , user_key VARCHAR(15) NOT NULL , parent_key VARCHAR(15) NOT NULL , sponsor_key VARCHAR(15) NOT NULL , position ENUM( 'right', 'left' ) NOT NULL, payment_status ENUM( '0', '1','2' ) NOT NULL DEFAULT '0' COMMENT ' 0 indicate unpaid AND 1 indicate paid and 2 Indicate Special Paid Member', payment_date VARCHAR(255), product_price DOUBLE(10,2) NOT NULL DEFAULT '0.00', KEY index_user_key (user_key), KEY index_parent_key (parent_key), KEY index_sponsor_key (sponsor_key), UNIQUE (user_name) ) $collate;\"; $tables[] = \"CREATE TABLE wp_bmp_leftposition ( id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, user_key VARCHAR(25) NOT NULL, parent_key VARCHAR(25) NOT NULL, payout_id INT(11) default 0, commission_status ENUM('0','1') NOT NULL DEFAULT '0', status ENUM('0','1') NOT NULL DEFAULT '0', KEY index_parent_key (parent_key), KEY index_user_key (user_key) ) $collate;\"; $tables[] = \"CREATE TABLE wp_bmp_rightposition ( id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, user_key VARCHAR(25) NOT NULL, parent_key VARCHAR(25) NOT NULL, payout_id INT(11) default 0 , commission_status ENUM('0','1') NOT NULL DEFAULT '0', status ENUM('0','1') NOT NULL DEFAULT '0', KEY index_parent_key(parent_key), KEY index_user_key(user_key) ) $collate;\"; $tables[] = \"CREATE TABLE wp_bmp_country ( id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, iso CHAR(2) NOT NULL, name VARCHAR(80) NOT NULL, iso3 CHAR(3) DEFAULT NULL, numcode SMALLINT(6) DEFAULT NULL ) $collate;\"; $tables[] = \"CREATE TABLE wp_bmp_currency ( id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY , iso3 VARCHAR (5) NOT NULL, symbol VARCHAR (50) NULL, currency VARCHAR( 60 ) NOT NULL ) $collate;\"; $tables[] = \"CREATE TABLE wp_bmp_payout ( id int(10) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, date date NOT NULL, commission_amount double(10,2) DEFAULT '0.00', referral_commission_amount DOUBLE( 10, 2 ) NOT NULL DEFAULT '0.00', bonus_amount double(10,2) DEFAULT '0.00', total_amount VARCHAR(100) NOT NULL DEFAULT '0.00', capped_amount VARCHAR(100) NOT NULL DEFAULT '0.00', cap_limit VARCHAR(100) NOT NULL DEFAULT '0.00', withdrawal_initiated BOOLEAN NOT NULL DEFAULT '0' COMMENT '0=>No, 1=> Yes', withdrawal_initiated_date DATE NOT NULL, payment_mode VARCHAR(100) NOT NULL, payment_processed BOOLEAN NOT NULL DEFAULT '0' COMMENT '0=>No, 1=> Yes', payment_processed_date DATE NOT NULL, beneficiary VARCHAR(100) NOT NULL, withdrawal_initiated_comment VARCHAR( 200 ) NOT NULL, banktransfer_code varchar(10) DEFAULT NULL, cheque_no varchar(10) DEFAULT NULL, cheque_date date DEFAULT NULL, bank_name varchar(50) DEFAULT NULL, user_bank_name varchar(50) DEFAULT NULL, user_bank_account_no varchar(10) DEFAULT NULL, other_comments VARCHAR(100) NOT NULL, tax double(10,2) DEFAULT '0.00', service_charge double(10,2) DEFAULT '0.00', dispatch_date date DEFAULT NULL, courier_name varchar(20) DEFAULT NULL, awb_no varchar(20) DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;\"; $tables[] = \"CREATE TABLE wp_bmp_referral_commission ( id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, date_notified datetime NOT NULL, sponsor_id BIGINT(20) NOT NULL, child_id BIGINT(60) NOT NULL, amount DOUBLE(6,2) NOT NULL DEFAULT 0.00 , payout_id int(11) NOT NULL DEFAULT '0', KEY index_sponsorid (sponsor_id), UNIQUE(child_id) ) $collate;\"; $tables[] = \"CREATE TABLE wp_bmp_epins ( id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, epin_name VARCHAR(155) NOT NULL, epin_no VARCHAR(155) NOT NULL, type VARCHAR(50) NOT NULL, date_generated date NOT NULL, user_key VARCHAR(155) NOT NULL DEFAULT 0, date_used date DEFAULT NULL, status ENUM('0','1') NOT NULL DEFAULT '0', epin_price DOUBLE(15,2) NOT NULL DEFAULT 0.00 ) $collate;\"; //print_r($tables);","columns":[{"name":"id","type":"BIGINT(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"user_name","type":"VARCHAR(60)","nullable":false,"primary_key":false},{"name":"user_key","type":"VARCHAR(15)","nullable":false,"primary_key":false},{"name":"parent_key","type":"VARCHAR(15)","nullable":false,"primary_key":false},{"name":"sponsor_key","type":"VARCHAR(15)","nullable":false,"primary_key":false},{"name":"position","type":"ENUM(  'right',  'left' )","nullable":false,"primary_key":false},{"name":"payment_status","type":"ENUM(  '0',  '1','2' )","nullable":false,"primary_key":false},{"name":"payment_date","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"product_price","type":"DOUBLE(10,2)","nullable":false,"primary_key":false},{"name":"user_key","type":"VARCHAR(25)","nullable":false,"primary_key":false},{"name":"parent_key","type":"VARCHAR(25)","nullable":false,"primary_key":false},{"name":"payout_id","type":"INT(11)","nullable":true,"primary_key":false},{"name":"commission_status","type":"ENUM('0','1')","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('0','1')","nullable":false,"primary_key":false},{"name":"user_key","type":"VARCHAR(25)","nullable":false,"primary_key":false},{"name":"parent_key","type":"VARCHAR(25)","nullable":false,"primary_key":false},{"name":"payout_id","type":"INT(11)","nullable":true,"primary_key":false},{"name":"commission_status","type":"ENUM('0','1')","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('0','1')","nullable":false,"primary_key":false},{"name":"iso","type":"CHAR(2)","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"iso3","type":"CHAR(3)","nullable":true,"primary_key":false},{"name":"numcode","type":"SMALLINT(6)","nullable":false,"primary_key":true},{"name":"iso3","type":"VARCHAR","nullable":false,"primary_key":false},{"name":"symbol","type":"VARCHAR","nullable":true,"primary_key":false},{"name":"currency","type":"VARCHAR( 60 )","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"commission_amount","type":"double(10,2)","nullable":true,"primary_key":false},{"name":"referral_commission_amount","type":"DOUBLE( 10, 2 )","nullable":false,"primary_key":false},{"name":"bonus_amount","type":"double(10,2)","nullable":true,"primary_key":false},{"name":"total_amount","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"capped_amount","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"cap_limit","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"withdrawal_initiated","type":"BOOLEAN","nullable":false,"primary_key":false},{"name":"withdrawal_initiated_date","type":"DATE","nullable":false,"primary_key":false},{"name":"payment_mode","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"payment_processed","type":"BOOLEAN","nullable":false,"primary_key":false},{"name":"payment_processed_date","type":"DATE","nullable":false,"primary_key":false},{"name":"beneficiary","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"withdrawal_initiated_comment","type":"VARCHAR( 200 )","nullable":false,"primary_key":false},{"name":"banktransfer_code","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"cheque_no","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"cheque_date","type":"date","nullable":true,"primary_key":false},{"name":"bank_name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"user_bank_name","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"user_bank_account_no","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"other_comments","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"tax","type":"double(10,2)","nullable":true,"primary_key":false},{"name":"service_charge","type":"double(10,2)","nullable":true,"primary_key":false},{"name":"dispatch_date","type":"date","nullable":true,"primary_key":false},{"name":"courier_name","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"awb_no","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"date_notified","type":"datetime","nullable":false,"primary_key":false},{"name":"sponsor_id","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"child_id","type":"BIGINT(60)","nullable":false,"primary_key":false},{"name":"amount","type":"DOUBLE(6,2)","nullable":false,"primary_key":false},{"name":"payout_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"epin_name","type":"VARCHAR(155)","nullable":false,"primary_key":false},{"name":"epin_no","type":"VARCHAR(155)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"date_generated","type":"date","nullable":false,"primary_key":false},{"name":"user_key","type":"VARCHAR(155)","nullable":false,"primary_key":false},{"name":"date_used","type":"date","nullable":true,"primary_key":false},{"name":"status","type":"ENUM('0','1')","nullable":false,"primary_key":false},{"name":"epin_price","type":"DOUBLE(15,2)","nullable":false,"primary_key":false}],"plugin":{"slug":"binary-mlm-plan","name":"Binary MLM Plan","active_installs":30,"version":"5.1","wp_org_url":"https://wordpress.org/plugins/binary-mlm-plan/"}}