Anonymous

$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);}