$table = $wpdb->prefix ."eshop_base_products"; if ($wpdb->get_var("show tables like '$table'") != $table) { $sql = "CREATE TABLE ".$table." ( post_id BIGINT( 20 ) NOT NULL, img TEXT NOT NULL default '', brand VARCHAR( 255 ) NOT NULL default '', ptype VARCHAR( 255 ) NOT NULL default '', condition VARCHAR( 255 ) NOT NULL default '', expiry DATE NOT NULL default '00-00-0000', ean VARCHAR( 255 ) NOT NULL default '', isbn VARCHAR( 255 ) NOT NULL default '', mpn VARCHAR( 255 ) NOT NULL default '', qty INT( 5 ) NOT NULL default '', xtra TEXT NOT NULL default '', PRIMARY KEY ( post_id ) );"; error_log("creating table $table"); //$wpdb->query($sql); dbDelta($sql); }