wp_bmp_users

Column Definitions

CREATE TABLE Statement

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);

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_bmp_users`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Binary MLM Plan