[bcoder wallpaper主题]3.1更新：启用该主题时自动新建额外数据库表

在3.0版本中，需要手动导入额外的bizhi_collect，bizhi_download_times ，bizhi_order ，bizhi_yanzm 数据库，不少新手并不会操作。所以我们在3.1的版本中加入了启用主题，自动新建数据库表功能。

3.0版本用户可直接将以下代码复制，加入到functions.php即可。重新启用主题，即可自动新建额外的数据库。

如图所示：

//新建额外表
function my_crate_table() {
    global $wpdb; 
    $bizhi_collect =  "bizhi_collect";
    $bizhi_download_times =  "bizhi_download_times";
    $bizhi_order =  "bizhi_order";
    $bizhi_yanzm =  "bizhi_yanzm";

    if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $bizhi_collect){
        $sql = "CREATE TABLE " . $bizhi_collect . " (
             `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
			 `postid` bigint(20) NOT NULL,
			 `message` varchar(255) NOT NULL,
			 `userid` bigint(20) NOT NULL,
			 `flag` int(11) NOT NULL,
			 `collectTime` datetime NOT NULL,
			 `category` varchar(255) NOT NULL,
			 PRIMARY KEY (`id`)
			) ENGINE=MyISAM DEFAULT CHARSET=gbk;
        ";
        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
 
        dbDelta($sql);
    }

    if($wpdb->get_var("SHOW TABLES LIKE '$bizhi_download_times'") != $bizhi_download_times){
        $sql = "CREATE TABLE " . $bizhi_download_times . " (
             `id` bigint(20) NOT NULL AUTO_INCREMENT,
			 `postid` bigint(20) NOT NULL,
			 `userid` bigint(20) DEFAULT NULL,
			 `download_time` datetime DEFAULT NULL,
			 PRIMARY KEY (`id`)
			) ENGINE=MyISAM DEFAULT CHARSET=gbk
        ";
        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
 
        dbDelta($sql);
    }


    if($wpdb->get_var("SHOW TABLES LIKE '$bizhi_order'") != $bizhi_order){
        $sql = "CREATE TABLE " . $bizhi_order . " (
             `id` bigint(20) NOT NULL AUTO_INCREMENT,
			 `orderID` varchar(20) NOT NULL,
			 `payAmount` int(255) DEFAULT NULL,
			 `orderName` varchar(255) DEFAULT NULL,
			 `userEmail` varchar(255) DEFAULT NULL,
			 `orderDate` datetime DEFAULT NULL,
			 `isPay` int(255) DEFAULT NULL,
			 `userID` bigint(20) NOT NULL,
			 `deviceId` varchar(255) NOT NULL DEFAULT '',
			 PRIMARY KEY (`id`,`orderID`,`userID`,`deviceId`)
			) ENGINE=MyISAM DEFAULT CHARSET=gbk
        ";
        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
 
        dbDelta($sql);
    }


    if($wpdb->get_var("SHOW TABLES LIKE '$bizhi_yanzm'") != $bizhi_yanzm){
        $sql = "CREATE TABLE " . $bizhi_yanzm . " (
             `id` bigint(150) unsigned NOT NULL AUTO_INCREMENT,
			 `toemail` varchar(150) NOT NULL,
			 `code` varchar(150) NOT NULL,
			 `saveTime` date NOT NULL,
			 PRIMARY KEY (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='保存的验证码'
        ";
        require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
 
        dbDelta($sql);
    }


}

//启用主题时候，新建额外表
add_action('after_switch_theme', 'my_crate_table');