← All changes | database/Migrations/RelationMigrator.php +3 -0 1.35 → 2.2.0 View file →

		@@ -16,9 +16,11 @@
16	16
17	17	$charsetCollate = $wpdb->get_charset_collate();
18	18	$table = $wpdb->prefix . 'fbs_relations';
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	`object_id` INT UNSIGNED NOT NULL,
24	26	`object_type` VARCHAR(100) NOT NULL,
		@@ -26,8 +28,9 @@
26	28	`settings` TEXT NULL COMMENT 'Serialized',
27	29	`preferences` TEXT NULL COMMENT 'Serialized',
28	30	`created_at` TIMESTAMP NULL,
29	31	`updated_at` TIMESTAMP NULL,
	32	+ KEY `fbs_object_type_id` (`object_type`, `object_id`),
30	33	KEY `object_type` (`object_type`),
31	34	KEY `object_id` (`object_id`),
32	35	KEY `foreign_id` (`foreign_id`)
33	36	) $charsetCollate;";