fluent-boards / database / Migrations / TaskMetaMigrator.php

TaskMetaMigrator.php in FluentBoards – Project Management, Task Management, Goal Tracking, Kanban Board, and, Team Collaboration 1.41, at database/Migrations/TaskMetaMigrator.php

35 lines 988 B

Raw Download Zip

1	<?php
2
3	namespace FluentBoards\Database\Migrations;
4
5	class TaskMetaMigrator
6	{
7	/**
8	* Task Meta Table.
9	*
10	* @param bool $isForced
11	* @return void
12	*/
13	public static function migrate($isForced = true)
14	{
15	global $wpdb;
16
17	$charsetCollate = $wpdb->get_charset_collate();
18	$table = $wpdb->prefix . 'fbs_task_metas';
19
20	if ($wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE %s", $table)) != $table \|\| $isForced) {
21	$sql = "CREATE TABLE $table (
22	`id` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
23	`task_id` INT UNSIGNED NOT NULL,
24	`key` VARCHAR(100) NOT NULL,
25	`value` LONGTEXT NULL,
26	`created_at` TIMESTAMP NULL,
27	`updated_at` TIMESTAMP NULL,
28	KEY `task_id` (`task_id`)
29	) $charsetCollate;";
30	require_once ABSPATH . 'wp-admin/includes/upgrade.php';
31	dbDelta($sql);
32	}
33	}
34	}
35