wp_bmw_users

Column Definitions

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS wp_bmw_users ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, user_id BIGINT NOT NULL, user_key VARCHAR( 15 ) NOT NULL, parent_key VARCHAR( 15 ) NOT NULL, sponsor_key VARCHAR( 15 ) NOT NULL, leg ENUM( '1', '0' ) NOT NULL, payment_status ENUM('0','1','2') NOT NULL, qualification_point INT(11) NOT NULL, left_point float NOT NULL, right_point float NOT NULL, own_point float NOT NULL, created_at datetime NOT NULL, paid_at datetime NOT NULL ) $collate;"; $tables[] = "CREATE TABLE IF NOT EXISTS wp_bmw_leftleg( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, user_key VARCHAR( 15 ) NOT NULL, parent_key VARCHAR( 15 ) NOT NULL, sponsor_key VARCHAR( 15 ) NOT NULL, comm_status int( 11 ) NOT NULL DEFAULT '0' ) $collate;"; $tables[] = "CREATE TABLE IF NOT EXISTS wp_bmw_rightleg( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, user_key VARCHAR( 15 ) NOT NULL, parent_key VARCHAR( 15 ) NOT NULL, sponsor_key VARCHAR( 15 ) NOT NULL, comm_status int( 11 ) NOT NULL DEFAULT '0' ) $collate;"; $tables[] = "CREATE TABLE IF NOT EXISTS wp_bmw_point_transaction( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, user_key VARCHAR( 15 ) NOT NULL, payout_id INT(15) NOT NULL, date date NOT NULL, status enum('0','1') NOT NULL, commission_amount double(15,3) NOT NULL DEFAULT '0', commission_points double(10,3) NOT NULL DEFAULT '0', childs longtext NOT NULL ) $collate;"; $tables[] = "CREATE TABLE IF NOT EXISTS wp_bmw_payout( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, userid BIGINT NOT NULL, date date NOT NULL, units int(25) NOT NULL, commission_amount double(10,2) DEFAULT '0' ) $collate;"; $tables[] = "CREATE TABLE IF NOT EXISTS wp_bmw_payout_master( id int(10) unsigned NOT NULL auto_increment PRIMARY KEY, date date NOT NULL ) $collate;"; $tables[] = "CREATE TABLE IF NOT EXISTS wp_bmw_pv_detail( id int(11) unsigned NOT NULL auto_increment PRIMARY KEY, order_id int(11) NOT NULL UNIQUE KEY, user_id int(11) NULL, total_amount int(11) NOT NULL, total_point int(11) NOT NULL, status int(11) NOT NULL DEFAULT '0' ) $collate;"; return $tables; } /*================================Create Pages=======================================*/ private static function create_pages() { global $wpdb; $bmwpages = array( 'my-networks-page' => array( 'name' => 'my-networks-page', 'title' => __('My Networks', 'binary-mlm-for-woocommerce'), 'tag' => '[bmw_network]', 'option' => 'my_networks_url' ), 'my-downlines' => array( 'name' => 'my-downlines', 'title' => __('My Downlines', 'binary-mlm-for-woocommerce'), 'tag' => '[bmw_downlines]', 'option' => 'my_downlines_url' ), 'registration-page' => array( 'name' => 'registration-page', 'title' => __('Registration', 'binary-mlm-for-woocommerce'), 'tag' => '[bmw_registration]', 'option' => 'registration_url' ), 'join-networks-page' => array( 'name' => 'join-networks-page', 'title' => __('Join Network', 'binary-mlm-for-woocommerce'), 'tag' => '[bmw_join_network]', 'option' => 'join_networks_url' ) );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_bmw_users`;

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

Other tables from Binary MLM For WooCommerce