| @@ -41,26 +41,13 @@ | ||
| 41 | 41 | |
| 42 | 42 | return $wpdb->delete( $table, [ 'id' => $id ], [ '%d' ] ); |
| 43 | 43 | } |
| 44 | 44 | |
| 45 | - public static function create(): void { | |
| 45 | + public static function create( $columns ): void { | |
| 46 | 46 | global $wpdb; |
| 47 | - $table_name = $wpdb->prefix . WPCoder::PREFIX; | |
| 48 | - $charset_collate = $wpdb->get_charset_collate(); | |
| 47 | + $table = $wpdb->prefix . WPCoder::PREFIX; | |
| 49 | 48 | |
| 50 | - $sql = "CREATE TABLE $table_name ( | |
| 51 | - id mediumint(9) NOT NULL AUTO_INCREMENT, | |
| 52 | - title VARCHAR(200) NOT NULL, | |
| 53 | - html_code LONGTEXT, | |
| 54 | - css_code LONGTEXT, | |
| 55 | - js_code LONGTEXT, | |
| 56 | - php_code LONGTEXT, | |
| 57 | - param LONGTEXT, | |
| 58 | - status BOOLEAN, | |
| 59 | - mode BOOLEAN, | |
| 60 | - tag TEXT, | |
| 61 | - PRIMARY KEY (id) | |
| 62 | - ) $charset_collate;"; | |
| 49 | + $sql = "CREATE TABLE $table ($columns) DEFAULT CHARACTER SET {$wpdb->charset} COLLATE {$wpdb->collate};"; | |
| 63 | 50 | require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); |
| 64 | 51 | dbDelta( $sql ); |
| 65 | 52 | } |
| 66 | 53 | |
