{"table_name":"bmw_users","full_table_name":"wp_bmw_users","description":"Stores bmw users data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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' ) );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT","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":"leg","type":"ENUM(  '1',  '0' )","nullable":false,"primary_key":false},{"name":"payment_status","type":"ENUM('0','1','2')","nullable":false,"primary_key":false},{"name":"qualification_point","type":"INT(11)","nullable":false,"primary_key":false},{"name":"left_point","type":"float","nullable":false,"primary_key":false},{"name":"right_point","type":"float","nullable":false,"primary_key":false},{"name":"own_point","type":"float","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"paid_at","type":"datetime","nullable":false,"primary_key":true},{"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":"comm_status","type":"int( 11 )","nullable":false,"primary_key":true},{"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":"comm_status","type":"int( 11 )","nullable":false,"primary_key":true},{"name":"user_key","type":"VARCHAR( 15 )","nullable":false,"primary_key":false},{"name":"payout_id","type":"INT(15)","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"status","type":"enum('0','1')","nullable":false,"primary_key":false},{"name":"commission_amount","type":"double(15,3)","nullable":false,"primary_key":false},{"name":"commission_points","type":"double(10,3)","nullable":false,"primary_key":false},{"name":"childs","type":"longtext","nullable":false,"primary_key":true},{"name":"userid","type":"BIGINT","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"units","type":"int(25)","nullable":false,"primary_key":false},{"name":"commission_amount","type":"double(10,2)","nullable":false,"primary_key":true},{"name":"date","type":"date","nullable":false,"primary_key":true},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"total_amount","type":"int(11)","nullable":false,"primary_key":false},{"name":"total_point","type":"int(11)","nullable":false,"primary_key":false},{"name":"status","type":"int(11)","nullable":false,"primary_key":false}],"plugin":{"slug":"woo-binary-mlm","name":"Binary MLM For WooCommerce","active_installs":30,"version":"2.1","wp_org_url":"https://wordpress.org/plugins/woo-binary-mlm/"}}