Cwq08Ynw

1public function add_tables() {
2
3        // Global $wpdb
4
5        global $wpdb;
6        $wpdb->hide_errors();
7
8        // Require upgrade
9
10        require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
11
12        // Set charset
13
14        $collate = '';
15        if ( $wpdb->has_cap( 'collation' ) ) {
16            $collate = $wpdb->get_charset_collate();
17        }
18
19        // SQL query
20
21        $sql = "
22        CREATE TABLE IF NOT EXISTS " . $wpdb->prefix . "test1 (
23            test_id bigint(20) NOT NULL AUTO_INCREMENT,
24            test_key char(64) NOT NULL,
25        ) $collate;
26        CREATE TABLE IF NOT EXISTS " . $wpdb->prefix . "test2 (
27            test_id bigint(20) NOT NULL AUTO_INCREMENT,
28            test_key char(64) NOT NULL,
29        ) $collate;
30        ";
31
32        // Do SQL
33
34        dbDelta( $sql );
35
36    }