| @@ -23,26 +23,25 @@ | ||
| 23 | 23 | } |
| 24 | 24 | |
| 25 | 25 | private static function updateDB(): void { |
| 26 | 26 | global $wpdb; |
| 27 | - $table = $wpdb->prefix . WPCoder::PREFIX; | |
| 27 | + $table_name = $wpdb->prefix . WPCoder::PREFIX; | |
| 28 | + $charset_collate = $wpdb->get_charset_collate(); | |
| 28 | 29 | |
| 29 | - $columns = " | |
| 30 | - id mediumint(9) NOT NULL AUTO_INCREMENT, | |
| 31 | - title VARCHAR(200) NOT NULL, | |
| 32 | - html_code LONGTEXT, | |
| 33 | - css_code LONGTEXT, | |
| 34 | - js_code LONGTEXT, | |
| 35 | - php_code LONGTEXT, | |
| 36 | - param LONGTEXT, | |
| 37 | - status BOOLEAN, | |
| 38 | - mode BOOLEAN, | |
| 39 | - tag TEXT, | |
| 40 | - UNIQUE KEY id (id) | |
| 41 | - "; | |
| 30 | + $sql = "CREATE TABLE $table_name ( | |
| 31 | + id mediumint(9) NOT NULL AUTO_INCREMENT, | |
| 32 | + title VARCHAR(200) NOT NULL, | |
| 33 | + html_code LONGTEXT, | |
| 34 | + css_code LONGTEXT, | |
| 35 | + js_code LONGTEXT, | |
| 36 | + php_code LONGTEXT, | |
| 37 | + param LONGTEXT, | |
| 38 | + status BOOLEAN, | |
| 39 | + mode BOOLEAN, | |
| 40 | + tag TEXT, | |
| 41 | + PRIMARY KEY (id) | |
| 42 | + ) $charset_collate;"; | |
| 42 | 43 | require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); |
| 43 | - | |
| 44 | - $sql = "CREATE TABLE $table ($columns) DEFAULT CHARACTER SET {$wpdb->charset} COLLATE {$wpdb->collate};"; | |
| 45 | 44 | dbDelta( $sql ); |
| 46 | 45 | } |
| 47 | 46 | |
| 48 | 47 | private static function updateDBFields(): void { |
