← All changes | classes/Update/UpdateDB.php +17 -17 3.1 → 3.3 View file →

		@@ -11,9 +11,9 @@
11	11
12	12	public static function init(): void {
13	13	$current_db_version = get_option( WPCoder::PREFIX . '_db_version' );
14	14
15		- if ( $current_db_version && version_compare( $current_db_version, '3.0.5', '>=' ) ) {
	15	+ if ( $current_db_version && version_compare( $current_db_version, '3.2', '>=' ) ) {
16	16	return;
17	17	}
18	18
19	19	self::updateDB();
		@@ -18,30 +18,30 @@
18	18
19	19	self::updateDB();
20	20	self::updateDBFields();
21	21
22		- update_option( WPCoder::PREFIX . '_db_version', '3.0.5' );
	22	+ update_option( WPCoder::PREFIX . '_db_version', '3.2' );
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		- param LONGTEXT,
36		- status BOOLEAN,
37		- mode BOOLEAN,
38		- tag TEXT,
39		- UNIQUE KEY id (id)
40		- ";
	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;";
41	43	require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
42		-
43		- $sql = "CREATE TABLE $table ($columns) DEFAULT CHARACTER SET {$wpdb->charset} COLLATE {$wpdb->collate};";
44	44	dbDelta( $sql );
45	45	}
46	46
47	47	private static function updateDBFields(): void {