plugin – creating extra tables

  • Marty

    (@mrthrust)


    14 years, 5 months ago

    hi guys/girls

    Ive been banging my head against a wall with this one..
    its not something ive not done before. but this time i can get my plugin to create the second table..

    the plugin on activation will create 2 new tables.
    clients & templates

    /*TABLE CLIENTS */

    $table_clients  = $wpdb->prefix."pm_clients";
if($wpdb->get_var("show tables like '".$table_clients."'") != $table_clients) {
$sql1 = "CREATE TABLE ".$table_clients." (";
$sql1.= "id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,";
$sql1.= "fname VARCHAR(100) NOT NULL, ";
$sql1.= "lname VARCHAR(100) NOT NULL, ";
$sql1.= "email VARCHAR(150) NOT NULL, ";
$sql1.= "dob VARCHAR(20) NOT NULL, ";
$sql1.= "currentage VARCHAR(10) NOT NULL,";
$sql1.= "emailfreq VARCHAR(10) NOT NULL, ";
$sql1.= "retage VARCHAR(10) NOT NULL, ";
$sql1.= "pay VARCHAR(10) NOT NULL, ";
$sql1.= "dateadded DATE NOT NULL, ";
$sql1.= "contactdate DATE NOT NULL,";
$sql1.= "lastemailed DATE NOT NULL";
$sql1.= ") ENGINE = MyISAM;";
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
dbDelta($sql1);
}

    this one is fine, it runs and creates the table..

    but right under this one in my install function i have another table to create..

    $table_templates = $wpdb->prefix."pension_manager_templates";
if($wpdb->get_var("show tables like '$table_templates'") != $table_templates) {	

$sql2 = "CREATE TABLE $table_templates (";
$sql2.= "id INT NOT NULL AUTO_INCREMENT PRIMARY  KEY,";
$sql2.= "name VARCHAR ( 100 ) NOT NULL, ";
$sql2.= "desc VARCHAR( 100 ) NOT NULL, ";
$sql2.= "content TEXT NOT NULL, ";
$sql2.= "status INT NOT NULL ";
$sql2.= ") ENGINE = MyISAM;";

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

    which is never created…

    can anyone see a reason why its not been made?

    cheers

The topic ‘plugin – creating extra tables’ is closed to new replies.

Tags