| @@ -41,14 +41,26 @@ | ||
| 41 | 41 | |
| 42 | 42 | return $wpdb->delete( $table, [ 'id' => $id ], [ '%d' ] ); |
| 43 | 43 | } |
| 44 | 44 | |
| 45 | - public static function create( $columns ): void { | |
| 45 | + public static function create(): void { | |
| 46 | 46 | global $wpdb; |
| 47 | - $table = $wpdb->prefix . WPCoder::PREFIX; | |
| 47 | + $table_name = $wpdb->prefix . WPCoder::PREFIX; | |
| 48 | + $charset_collate = $wpdb->get_charset_collate(); | |
| 48 | 49 | |
| 49 | - $sql = "CREATE TABLE IF NOT EXISTS $table ($columns) DEFAULT CHARACTER SET {$wpdb->charset} COLLATE {$wpdb->collate};"; | |
| 50 | - | |
| 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;"; | |
| 51 | 63 | require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); |
| 52 | 64 | dbDelta( $sql ); |
| 53 | 65 | } |
| 54 | 66 | |
