wordpress批量建数据库表

这是一个插件中的，我阅读到源码，觉得批量建表很有用，以后可能用得到，记录下来，之前也分享过类似的：

wordpress 新建数据表储存信息

3年前

02119

wordpress插件新建自定义Mysql数据表

3年前

03576

今天分享的代码如下：

<?php
        global $wpdb;
        $sql = file_get_contents(__DIR__.'/install/init.sql');
        $charset_collate = $wpdb->get_charset_collate();
        $sql = str_replace('`wp_wb_','`'.$wpdb->prefix.'wb_',$sql);//替换表前缀
        $sql = str_replace('ENGINE=InnoDB', $charset_collate , $sql);//
        $sql_rows = explode('-- row split --',$sql);//分割sql文件
        foreach($sql_rows as $row){

            if(preg_match('#`'.$wpdb->prefix.'(wb_spider.*?)`\s+\(#',$row,$match)){
                if(in_array($match[1],$set_up)){
                    $wpdb->query($row);
                }
            }
            //print_r($row);exit();
        }

其sql文件内容如下：

CREATE TABLE IF NOT EXISTS `wp_wb_spider` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL,
  `marker` varchar(64) DEFAULT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `skip` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `bot_type` varchar(32) DEFAULT NULL,
  `bot_url` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `bot_type` (`bot_type`)
) ENGINE=InnoDB;

-- row split --

CREATE TABLE IF NOT EXISTS `wp_wb_spider_ip` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ip` varchar(32) DEFAULT NULL,
  `name` varchar(128) NOT NULL,
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ip` (`ip`,`name`),
  KEY `status` (`status`)
) ENGINE=InnoDB;

-- row split --

CREATE TABLE IF NOT EXISTS `wp_wb_spider_log` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `spider` varchar(64) DEFAULT NULL,
  `visit_date` datetime NOT NULL,
  `code` varchar(32) DEFAULT NULL,
  `visit_ip` varchar(32) DEFAULT NULL,
  `url` varchar(256) DEFAULT NULL,
  `url_md5` varchar(32) DEFAULT NULL,
  `url_type` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `spider` (`spider`),
  KEY `url_md5` (`url_md5`),
  KEY `url_type` (`url_type`)
) ENGINE=InnoDB;

-- row split --

CREATE TABLE IF NOT EXISTS `wp_wb_spider_post` (
  `post_id` bigint(20) UNSIGNED NOT NULL,
  `url_in` int(11) NOT NULL DEFAULT '0',
  `url_out` int(11) NOT NULL DEFAULT '0',
  `url_md5` varchar(32) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`),
  KEY `url_md5` (`url_md5`)
) ENGINE=InnoDB;

-- row split --

CREATE TABLE IF NOT EXISTS `wp_wb_spider_post_link` (
  `post_id` bigint(20) UNSIGNED NOT NULL,
  `link_url_md5` varchar(32) NOT NULL,
  `link_post_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`post_id`,`link_url_md5`)
) ENGINE=InnoDB;

-- row split --

CREATE TABLE IF NOT EXISTS `wp_wb_spider_sum` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ymdh` int(10) UNSIGNED NOT NULL,
  `created` int(10) UNSIGNED NOT NULL,
  `spider` tinyint(3) UNSIGNED NOT NULL,
  `visit_times` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ymdh` (`ymdh`),
  KEY `spider` (`spider`)
) ENGINE=InnoDB;

-- row split --

CREATE TABLE IF NOT EXISTS `wp_wb_spider_visit` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `spider` tinyint(3) UNSIGNED NOT NULL,
  `ymdh` int(10) UNSIGNED NOT NULL,
  `created` int(10) UNSIGNED NOT NULL,
  `visit_times` int(10) UNSIGNED NOT NULL,
  `url_md5` varchar(32) DEFAULT NULL,
  `url` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ymdh` (`ymdh`),
  KEY `spider` (`spider`),
  KEY `url_md5` (`url_md5`)
) ENGINE=InnoDB;