function mlm_core_install_withdrawal() { global $wpdb; $charset_collate = mlm_core_set_charset(); $table_prefix = mlm_core_get_table_prefix(); $sql[] = "CREATE TABLE IF NOT EXISTS {$table_prefix}mlm_withdrawal\n\t\t\t(\n\t\t\t\tid BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,\n\t\t\t\tuser_id BIGINT(20) NOT NULL,\n\t\t\t\tamount DOUBLE(10,2) NOT NULL,\n withdrawal_fee DOUBLE(10,2) NOT NULL,\n witholding_tax double(10,2) DEFAULT '0.00',\n tax_status ENUM('0','1') DEFAULT '0',\n\t\t\t\twithdrawal_initiated TINYINT NOT NULL,\n\t\t\t\twithdrawal_mode VARCHAR(200) NOT NULL,\n\t\t\t\tother_method VARCHAR(200) NOT NULL,\n\t\t\t\twithdrawal_initiated_comment VARCHAR(200) NOT NULL,\n\t\t\t\twithdrawal_initiated_date DATE NOT NULL,\n\t\t\t\tpayment_processed TINYINT NOT NULL,\n\t\t\t\tpayment_processed_date DATE NOT NULL,\n\t\t\t\tpayment_mode VARCHAR(100) NOT NULL,\n\t\t\t\tbanktransfer_code VARCHAR(100) NOT NULL,\n\t\t\t\tbeneficiary VARCHAR(100),\n\t\t\t\tcheque_no VARCHAR(100) NOT NULL,\n\t\t\t\tcheque_date DATE NOT NULL,\n\t\t\t\tbank_name VARCHAR(100) NOT NULL,\n\t\t\t\tuser_bank_name VARCHAR(50) NOT NULL,\n\t\t\t\tuser_bank_account_no VARCHAR(10) NOT NULL,\n\t\t\t\tcourier_name VARCHAR(20) NOT NULL,\n\t\t\t\tawb_no VARCHAR(20) NOT NULL,\n\t\t\t\tdispatch_date DATE,\n\t\t\t\tother_comments VARCHAR(100) NOT NULL\n\t\t\t) {$charset_collate} AUTO_INCREMENT=1"; dbDelta($sql); }
function mlm_core_install_product_price() { global $wpdb; $charset_collate = mlm_core_set_charset(); $table_prefix = mlm_core_get_table_prefix(); $sql[] = "CREATE TABLE IF NOT EXISTS {$table_prefix}mlm_product_price(\n p_id BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,\n product_name VARCHAR( 255 ) NOT NULL,\n product_price INT(11) NOT NULL DEFAULT '0') {$charset_collate} AUTO_INCREMENT=1"; dbDelta($sql); if ($wpdb->get_var("select count(p_id)as count from {$table_prefix}mlm_product_price") < 1) { $wpdb->query("INSERT INTO {$table_prefix}mlm_product_price set product_name='Free ePin',product_price=0"); } }