← All changes | classes/Dashboard/DBManager.php +16 -3 3.2 → 3.3 View file →

		@@ -41,13 +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 $table ($columns) DEFAULT CHARACTER SET {$wpdb->charset} COLLATE {$wpdb->collate};";
	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;";
50	63	require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
51	64	dbDelta( $sql );
52	65	}
53	66