← All changes | database/Migrations/CommentsMigrator.php +3 -0 1.13 → 2.1.0 View file →

		@@ -16,9 +16,11 @@
16	16
17	17	$charsetCollate = $wpdb->get_charset_collate();
18	18	$table = $wpdb->prefix . 'fbs_comments';
19	19
	20	+ // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- Schema check query, caching not applicable for migrations
20	21	if ($wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE %s", $table)) != $table || $isForced) {
	22	+ // phpcs:ignore WordPress.DB.DirectDatabaseQuery.SchemaChange -- Table name cannot be prepared in CREATE TABLE
21	23	$sql = "CREATE TABLE $table (
22	24	`id` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
23	25	`board_id` INT UNSIGNED NOT NULL,
24	26	`task_id` INT UNSIGNED NOT NULL,
		@@ -30,8 +32,9 @@
30	32	`author_email` VARCHAR(192) NULL DEFAULT '',
31	33	`author_ip` VARCHAR(50) NULL DEFAULT '',
32	34	`description` TEXT NULL,
33	35	`created_by` BIGINT UNSIGNED NULL,
	36	+ `settings` TEXT NULL COMMENT 'Serialized Array',
34	37	`created_at` TIMESTAMP NULL,
35	38	`updated_at` TIMESTAMP NULL,
36	39	KEY `type` (`type`),
37	40	KEY `task_id` (`task_id`),