wordpress使用dbDelta创建数据库的方法

直接上代码

假设我们要创建一张表用来作为wordpress网站的工单专用的table

$table_ticket_name = $wpdb->prefix . "tickets";
$table_ticket_sql = "CREATE TABLE $table_ticket_name (
id int(11) NOT NULL auto_increment,
user_id int(11) NOT NULL,
type int(1) NOT NULL,
number varchar(50) NOT NULL,
email varchar(200),
status int(1) default 0 NOT NULL,
score int(1),
note text NOT NULL,
create_time datetime,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
dbDelta($table_ticket_sql);