Failed to create multiple user db tables when activating wp plugin

Question

I can’t create several user tables in db when my wordpress plugin is activated, it creates only the last table, as indicated in this code, instead of Bookmarks, instead of creating all the tables (user, field, visibility, notification), etc.

function your_plugin_options_install() {
    global $wpdb;
    //global $your_db_name;
    $uservar = $wpdb->prefix . 'user';
    $fieldvar = $wpdb->prefix . 'field';
    $visibilitytypevar = $wpdb->prefix . 'visibily';
    $notificationvar = $wpdb->prefix . 'notification';
    $jobtypevar = $wpdb->prefix . 'jobtype';
    $bookmarkvar = $wpdb->prefix . 'bookmark';
   // $profiledatavar = $wpdb->prefix . 'profiledata';
    //$employeevar = $wpdb->prefix . 'employee';
 //echo "some";
    // create the ECPT metabox database table
    //if($wpdb->get_var("SHOW TABLES LIKE '$yourtable'") != $yourtable) 
    //{
        $sql = "CREATE TABLE IF NOT EXISTS " . $uservar . " (
        `u_id` int(20) NOT NULL AUTO_INCREMENT,
        `u_name` varchar(30) ,
        `u_phonenumber` int(20) ,
        `u_email` varchar(30) NOT NULL,
        `u_password` varchar(50) NOT NULL,
         PRIMARY KEY (u_id)
         );";
          $sql = "CREATE TABLE IF NOT EXISTS " . $fieldvar . " (
         `f_id` int(20) NOT NULL AUTO_INCREMENT ,
         `f_title` varchar(30) NOT NULL,
          PRIMARY KEY (f_id)
         );";

         $sql = "CREATE TABLE IF NOT EXISTS " . $visibilitytypevar . " (
         `v_id` int(20) NOT NULL AUTO_INCREMENT ,
         `v_type` bool NOT NULL,
          PRIMARY KEY (v_id)
         );";

         $sql = "CREATE TABLE IF NOT EXISTS " . $notificationvar . " (
         `n_id` int(20) NOT NULL AUTO_INCREMENT ,
         `u_id` int(20) NOT NULL,
         PRIMARY KEY (n_id)
         );";

         $sql = "CREATE TABLE IF NOT EXISTS " . $jobtypevar . " (
         `jt_id` int(20) NOT NULL AUTO_INCREMENT ,
         `jt_title` varchar(30),
         PRIMARY KEY (jt_id)
         );";

          $sql = "CREATE TABLE IF NOT EXISTS " . $bookmarkvar . " (
         `bm_id` int(20) NOT NULL AUTO_INCREMENT ,
         `u_id` int(20) NOT NULL,
         `bm_title` varchar(30),
         PRIMARY KEY (bm_id)
         );";


        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
        dbDelta($sql);
    }

//}
// run the install scripts upon plugin activation
register_activation_hook(__FILE__,'your_plugin_options_install');

Answer 1

you redefine your variable $sql. Just use the dbDelta function after each request. as below format.

require_once(ABSPATH . 'wp-admin/includes/upgrade.php');

// your first query
$sql = '...'; 
dbDelta($sql);

// your second query
$sql = '...'; 
dbDelta($sql);

.
.
.


// your nth query
$sql = '...'; 
dbDelta($sql);

Answer 2

, $sql, . .

$sql .

//define the query
$sql = "CREATE TABLE `firsttable` ....";
//Run the query
dbDelta($sql); //If this is what is running the query.
//Another table
$sql = "CREATE TABLE `secondtable` ....";
//Run the new query
dbDelta($sql); //If this is what is running the query.

Answer 3

If dbDelta($sql);your sql runs, you must add this uder string to each sql statement to release it

Answer 4

You can also try something like this:

for the first wright request $sql = "your query text goes here",

and for all of the following queries $sql .= "your query text goes here"